CREATE TABLE BLC_USER_LOGIN_ATTEMPT (ID VARCHAR2(36 CHAR) NOT NULL, ATTEMPT_TIMESTAMP TIMESTAMP(6) NOT NULL, AUTH_SERVER_ID VARCHAR2(255 CHAR) NOT NULL, CONSIDERED CHAR(1 CHAR) DEFAULT 'Y' NOT NULL, LOGIN_ATTEMPT_RESULT VARCHAR2(255 CHAR), USER_ID VARCHAR2(255 CHAR), USERNAME VARCHAR2(255 CHAR) NOT NULL, CONSTRAINT CT_24S4GLY88TPBJUMPPDTH PRIMARY KEY (ID));
ALTER TABLE BLC_AUTHORIZATION_SERVER ADD LOGIN_ATTEMPTS_ALLOWED NUMBER(10, 0);
ALTER TABLE BLC_AUTHORIZATION_SERVER ADD LOCKOUT_DURATION_MINS NUMBER(19, 0);
ALTER TABLE BLC_AUTHORIZATION_SERVER ADD LOGIN_FAIL_DECAY_MINS NUMBER(19, 0);
ALTER TABLE BLC_USER ADD USER_LOCKED_TIME TIMESTAMP(6);
CREATE INDEX IDX57HIP06M20V679O7M7GH95IQS ON BLC_USER_LOGIN_ATTEMPT(USERNAME, AUTH_SERVER_ID);
ALTER TABLE BLC_AUTHORIZATION_SERVER ADD EMBEDDED_LOGIN_ENABLED CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_AUTHORIZATION_SERVER ADD LOCKED_USR_CAN_RESET_PWD CHAR(1 CHAR);
ALTER TABLE BLC_AUTHORIZATION_SERVER ADD RESET_PWD_UNLOCKS_USR CHAR(1 CHAR);
ALTER TABLE BLC_PASSWORD_TOKEN ADD PURPOSE VARCHAR2(255 CHAR) DEFAULT 'RESET_PASSWORD' NOT NULL;