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

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

ALTER TABLE T_Review ADD UpdateDate DATE;
COMMIT;

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

CREATE INDEX IX_Comment3 ON T_Comment (ReviewId);
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 = sysdate;
COMMIT;

UPDATE T_Settings SET StringParam1 = StringParam1 || ';False' WHERE EntryName = 'InboxSelection';
COMMIT;

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

 DECLARE COL_EXIST_CNT INTEGER;
 BEGIN
 select count(column_name) INTO COL_EXIST_CNT FROM user_tab_cols where table_name='T_QUEUEENTRY' and column_name='SERVICEID';
 IF COL_EXIST_CNT = 0 THEN
    EXECUTE IMMEDIATE 'ALTER TABLE T_QUEUEENTRY ADD ServiceId NVARCHAR2(128)';
 END IF;
 select count(*) INTO COL_EXIST_CNT FROM T_SystemPolicy where ObjectId=50;
 IF COL_EXIST_CNT = 0 THEN
    INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
    VALUES (50,'SYSTEM','REMOVEEXTRAAUTONUMLGLTEXT','DENY','SYSTEM') ;
    COMMIT;
 END IF;
 select count(*) INTO COL_EXIST_CNT FROM T_SystemPolicy where ObjectId=51;
 IF COL_EXIST_CNT = 0 THEN
    INSERT INTO T_SystemPolicy (ObjectId,Principal,Permission,PolicyAction,PolicyObject)
    VALUES (51,'SYSTEM','DEFAULTREVIEWDURATION','1','SYSTEM') ;
    COMMIT;
 END IF;
 END;
/