/* Add New Guid column for PCC */
ALTER TABLE T_Document ADD PccGuid NVARCHAR2(36) NULL;
COMMIT;

/* Migrate all date columns to timestamp(3) */
ALTER TABLE T_Subject MODIFY LastLoginDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_NativeUser MODIFY PasswordChangeDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_PreviousPassword MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_Review MODIFY StartDate TIMESTAMP(3);
ALTER TABLE T_Review MODIFY EndDate TIMESTAMP(3);
ALTER TABLE T_Review MODIFY CloseDate TIMESTAMP(3);
ALTER TABLE T_Review MODIFY CompleteDate TIMESTAMP(3);
ALTER TABLE T_Review MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_Document MODIFY CreateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_Comment MODIFY CreateDate TIMESTAMP(3);
ALTER TABLE T_Comment MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_Participant MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_QueueEntry MODIFY DueDate TIMESTAMP(3);
ALTER TABLE T_QueueEntry MODIFY StartDate TIMESTAMP(3);
ALTER TABLE T_QueueEntry MODIFY EndDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_Settings MODIFY DateParam1 TIMESTAMP(3);
ALTER TABLE T_Settings MODIFY DateParam2 TIMESTAMP(3);
COMMIT;

ALTER TABLE T_CommentHistory MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_Edit MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_EditVersion MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_Bookmark MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_GenDocAudit MODIFY GenerateDate TIMESTAMP(3);
COMMIT;

ALTER TABLE T_Config MODIFY DateParam1 TIMESTAMP(3);
ALTER TABLE T_Config MODIFY DateParam2 TIMESTAMP(3);
COMMIT;

ALTER TABLE T_LicenseFile MODIFY UpdateDate TIMESTAMP(3);
COMMIT;

DROP INDEX IX_Config2;
CREATE UNIQUE INDEX IX_Config2 ON T_Config (RefObjectType, RefObjectId, EntryName);
COMMIT;

UPDATE T_Config SET StringParam1 = 'default' 
WHERE RefObjectType='WORKGROUP' AND RefObjectId='1' AND EntryName='AllowPdfReview';
COMMIT;

ALTER TABLE T_Participant ADD Subteam NVARCHAR2(128) NULL;
COMMIT;


/* Schema Versioning */
UPDATE T_SchemaInfo SET SchemaVersion = '6.0.0';
COMMIT;
