CREATE TABLE blc_user_login_attempt (id VARCHAR(36) NOT NULL, attempt_timestamp datetime NOT NULL, auth_server_id VARCHAR(255) NOT NULL, considered CHAR(1) DEFAULT 'Y' NOT NULL, login_attempt_result VARCHAR(255) NULL, user_id VARCHAR(255) NULL, username VARCHAR(255) NOT NULL, CONSTRAINT PK_BLC_USER_LOGIN_ATTEMPT PRIMARY KEY (id));
ALTER TABLE blc_authorization_server ADD login_attempts_allowed INT DEFAULT null NULL;
ALTER TABLE blc_authorization_server ADD lockout_duration_mins BIGINT DEFAULT null NULL;
ALTER TABLE blc_authorization_server ADD login_fail_decay_mins BIGINT DEFAULT null NULL;
ALTER TABLE blc_user ADD user_locked_time datetime DEFAULT null NULL;
CREATE INDEX IDX57hip06m20v679o7m7gh95iqs ON blc_user_login_attempt(username, auth_server_id);
ALTER TABLE blc_authorization_server ADD embedded_login_enabled CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_authorization_server ADD locked_usr_can_reset_pwd CHAR(1) NULL;
ALTER TABLE blc_authorization_server ADD reset_pwd_unlocks_usr CHAR(1) NULL;
ALTER TABLE blc_password_token ADD purpose VARCHAR(255) DEFAULT 'RESET_PASSWORD' NOT NULL;