﻿--PR-4441 password policy
ALTER TABLE T_NativeUser ADD PasswordChangeDate DATETIME NULL;
GO

UPDATE T_NativeUser SET PasswordChangeDate = GETDATE() WHERE Password <> 'x';
GO

-- set a maximum date time so that user that has yet to set a password won't be expired
UPDATE T_NativeUser SET PasswordChangeDate = '9999-12-31 23:59:59' WHERE Password = 'x';
GO

ALTER TABLE T_NativeUser ALTER COLUMN PasswordChangeDate DATETIME NOT NULL;
GO

CREATE TABLE T_PreviousPassword(
	ObjectId	INT NOT NULL,
	SubjectId	INT NOT NULL,
	Password	NVARCHAR(128) NOT NULL,
	UpdateDate	DATETIME NOT NULL
);

CREATE UNIQUE CLUSTERED INDEX IX_PreviousPassword ON T_PreviousPassword (ObjectId);
CREATE INDEX IX_PreviousPassword2 ON T_PreviousPassword (SubjectId, UpdateDate);

--end of PR-4441

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

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