ALTER TABLE T_Subject ADD CultureName NVARCHAR(128);
COMMIT;

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

ALTER TABLE T_Review ADD UpdateDate DATETIME;
COMMIT;

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

CREATE INDEX IX_Comment3 ON T_Comment (ReviewId);
COMMIT;

DELIMITER $$
DROP PROCEDURE IF EXISTS `addServiceIdColumn` $$
CREATE PROCEDURE `addServiceIdColumn`()
BEGIN
  IF NOT EXISTS(
	SELECT * FROM information_schema.COLUMNS
	WHERE COLUMN_NAME='ServiceId' AND TABLE_NAME='t_queueentry' and TABLE_SCHEMA=SCHEMA()
	)
	THEN
		ALTER TABLE T_QueueEntry
		ADD COLUMN ServiceId nvarchar(128) null;
END IF;
END $$
DELIMITER ;
CALL addServiceIdColumn();
DROP PROCEDURE addServiceIdColumn;
COMMIT;

INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (50,'SYSTEM','REMOVEEXTRAAUTONUMLGLTEXT','DENY','SYSTEM') ON DUPLICATE KEY UPDATE ObjectId=ObjectId;
COMMIT;

INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (51,'SYSTEM','DEFAULTREVIEWDURATION','1','SYSTEM') ON DUPLICATE KEY UPDATE ObjectId=ObjectId;
COMMIT;

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;

COMMIT;

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;');
COMMIT;

UPDATE T_Review SET UpdateDate = Now();
COMMIT;

UPDATE T_Settings SET StringParam1 = CONCAT(StringParam1,';False') WHERE EntryName = 'InboxSelection';
COMMIT;


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