﻿ALTER TABLE T_Subject ADD CultureName NVARCHAR(128);
GO

ALTER TABLE T_Review ADD Deleted INT NOT NULL Default 0;
GO

ALTER TABLE T_Review ADD UpdateDate DATETIME;
GO

ALTER TABLE T_Workgroup ADD IsTaskgroup INT NOT NULL Default 0;
GO

CREATE INDEX IX_Comment3 ON T_Comment (ReviewId);
GO

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'T_QueueEntry' AND COLUMN_NAME = 'ServiceId')
BEGIN
ALTER TABLE T_QueueEntry ADD ServiceId NVARCHAR(128) NULL
END
GO

--select * from T_SystemPolicy where Permission='REMOVEEXTRAAUTONUMLGLTEXT'
IF NOT EXISTS ( select 1 from T_SystemPolicy  where Permission='REMOVEEXTRAAUTONUMLGLTEXT')
BEGIN
INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (50,'SYSTEM','REMOVEEXTRAAUTONUMLGLTEXT','DENY','SYSTEM');
END
GO

--select * from T_SystemPolicy where Permission='DEFAULTREVIEWDURATION'
IF NOT EXISTS ( select 1 from T_SystemPolicy  where Permission='DEFAULTREVIEWDURATION')
BEGIN
INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (51,'SYSTEM','DEFAULTREVIEWDURATION','1','SYSTEM');
END
GO

INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (52,'SYSTEM','RECYCLEPURGEDAYS','30','SYSTEM');
INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (53,'SYSTEM','AUTOCOMPLETEDAYS','-1','SYSTEM');
INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (54,'SYSTEM','AUTODELETEDAYS','-1','SYSTEM');
INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (55,'SYSTEM','AUTODELETEREMINDER','-1','SYSTEM');
INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (56,'SYSTEM','ALLOWPROPOSEDCHANGE','PERMIT','SYSTEM');
INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (57,'SYSTEM','TASKGROUPSFORREVIEW','DENY','SYSTEM');
INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (58,'SYSTEM','CREATEREVIEWONLYINTASKGROUPS','DENY','SYSTEM');

UPDATE T_SystemPolicy SET PolicyAction='60' WHERE ObjectId = 11;
DELETE FROM T_SystemPolicy WHERE ObjectId = 44;

GO

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (17,'Workgroup','Monitor Only',
';MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (18,'Workgroup','Reviewer-Monitor',
';DOREVIEW;COMMENT;MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (19,'Workgroup','Author-Monitor',
';DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (20,'Workgroup','Contributor-Monitor',
';DOREVIEW;COMMENT;CONTRIBUTE;MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (21,'Workgroup','Author-Contributor-Monitor',
';DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;CONTRIBUTE;MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (22,'Workgroup','Admin-Monitor',
';WORKGROUPADMIN;MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (23,'Workgroup','Admin-Reviewer-Monitor',
';WORKGROUPADMIN;DOREVIEW;COMMENT;MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (24,'Workgroup','Admin-Author-Monitor',
';WORKGROUPADMIN;DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (25,'Workgroup','Admin-Contributor-Monitor',
';WORKGROUPADMIN;DOREVIEW;COMMENT;CONTRIBUTE;MONITOR;');

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags )
VALUES (26,'Workgroup','Admin-Author-Contributor-Monitor',
';WORKGROUPADMIN;DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;CONTRIBUTE;MONITOR;');
GO

UPDATE T_Review SET UpdateDate = GetDate(); --use Now() for MySql
GO

UPDATE T_Settings SET StringParam1 = StringParam1 + ';False' WHERE EntryName = 'InboxSelection';
GO

UPDATE T_QueueEntry SET RepeatInterval = 3600 WHERE ObjectId = 1;
GO
