-- ABS-49831
-------   WEBUSER   ------------
ALTER TABLE WEBUSER ADD (PASSWORDENCRYPTION VARCHAR2(15) DEFAULT 'PBEMD5DES' NOT NULL CONSTRAINT PASSWORDENCRYPTION_VALID1_1
                         CHECK (PASSWORDENCRYPTION IN ('PBEMD5DES', 'PBKDF2SHA256')));


-------   WEBUSERRESETPASSWORD   ------------

CREATE TABLE WEBUSERRESETPASSWORD
(
WEBUSER_ID NUMBER NOT NULL,
TOKEN VARCHAR2(36) NOT NULL,
SYSTEMUSER_ID NUMBER NOT NULL,
TIMESTAMP DATE NOT NULL
);

ALTER TABLE WEBUSERRESETPASSWORD ADD CONSTRAINT XPKWEBUSERRESETPASSWORD PRIMARY KEY (WEBUSER_ID);

ALTER TABLE WEBUSERRESETPASSWORD ADD CONSTRAINT WEBUSERRESETPASSWORD_WEBUS FOREIGN KEY (WEBUSER_ID)
REFERENCES WEBUSER (WEBUSER_ID) ON DELETE CASCADE;