/* PR-4441 password policy */
ALTER TABLE T_NativeUser ADD PasswordChangeDate DATE NULL;
COMMIT;

UPDATE T_NativeUser SET PasswordChangeDate = TO_DATE(SYSDATE, 'DD-MM-YYYY HH:MI:SS') WHERE Password <> 'x';
COMMIT;

/* set a maximum date time so that user that has yet to set a password won't be expired */
UPDATE T_NativeUser SET PasswordChangeDate = TO_DATE('31-12-9999 23:59:59', 'DD-MM-YYYY HH24:MI:SS') WHERE Password = 'x';
COMMIT;

ALTER TABLE T_NativeUser MODIFY PasswordChangeDate DATE NOT NULL;
COMMIT;

CREATE TABLE T_PreviousPassword(
	ObjectId	INT NOT NULL,
	SubjectId	INT NOT NULL,
	Password	NVARCHAR2(128) NOT NULL,
	UpdateDate	DATE NOT NULL
);

CREATE UNIQUE INDEX IX_PreviousPassword ON T_PreviousPassword (ObjectId);
CREATE INDEX IX_PreviousPassword2 ON T_PreviousPassword (SubjectId, UpdateDate);
COMMIT;
/* end of PR-4441 */

/* LocalFileUpload */
UPDATE T_Config SET StringParam1 = 'both', IntParam1 = NULL WHERE EntryName = 'LocalFileUpload' AND ObjectId = 50;
COMMIT;
/* End of LocalFileUpload */

/* Schema Versioning */
UPDATE T_SchemaInfo SET SchemaVersion = '5.2.0';
COMMIT;
/* End of Schema Versioning */
