﻿/* Add New Guid column for PCC */
ALTER TABLE T_Document ADD PccGuid NVARCHAR(36) NULL;
GO

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

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

ALTER TABLE T_Participant ADD Subteam NVARCHAR(128) NULL;
GO


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

