INSERT INTO T_SystemPolicy(ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (63, 'SYSTEM', 'AUTODELETEAUTHOROVERRIDE', 'PERMIT', 'SYSTEM');
COMMIT;

ALTER TABLE T_Participant ADD DelegatedBy INT NULL;
COMMIT;

UPDATE T_Participant SET DelegatedBy = 0 WHERE DelegatedBy IS NULL;
COMMIT;

ALTER TABLE T_Participant ADD ManagerDelegator INT NULL;
COMMIT;

UPDATE T_Participant SET ManagerDelegator = 0 WHERE ManagerDelegator IS NULL;
COMMIT;

ALTER TABLE T_DistEntry ADD ManagerDelegator INT NULL;
COMMIT;

UPDATE T_DistEntry SET ManagerDelegator = 0 WHERE ManagerDelegator IS NULL;
COMMIT;



/* --- BEGIN _ Standard Data for Managerial Delegation implementation --- */

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (35,'Workgroup','Reviewer-Delegator',
';DOREVIEW;COMMENT;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Author-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (36,'Workgroup','Author-Delegator',
';DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Contributor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (37,'Workgroup','Contributor-Delegator',
';DOREVIEW;COMMENT;CONTRIBUTE;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Author-Contributor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (38,'Workgroup','Author-Contributor-Delegator',
';DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;CONTRIBUTE;DEFINEEDITZONE;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Admin-Reviewer-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (39,'Workgroup','Admin-Reviewer-Delegator',
';WORKGROUPADMIN;DOREVIEW;COMMENT;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Admin-Author-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (40,'Workgroup','Admin-Author-Delegator',
';WORKGROUPADMIN;DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Admin-Contributor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (41,'Workgroup','Admin-Contributor-Delegator',
';WORKGROUPADMIN;DOREVIEW;COMMENT;CONTRIBUTE;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Reviewer-Monitor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (42,'Workgroup','Reviewer-Monitor-Delegator',
';DOREVIEW;COMMENT;MONITOR;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Author-Monitor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (43,'Workgroup','Author-Monitor-Delegator',
';DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;MONITOR;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Contributor-Monitor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (44,'Workgroup','Contributor-Monitor-Delegator',
';DOREVIEW;COMMENT;CONTRIBUTE;MONITOR;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Admin-Author-Contributor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (45,'Workgroup','Admin-Author-Contributor-Delegator',
';WORKGROUPADMIN;DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;CONTRIBUTE;DEFINEEDITZONE;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Author-Contributor-Monitor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (46,'Workgroup','Author-Contributor-Monitor-Delegator',
';DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;CONTRIBUTE;MONITOR;DEFINEEDITZONE;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Admin-Reviewer-Monitor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (47,'Workgroup','Admin-Reviewer-Monitor-Delegator',
';WORKGROUPADMIN;DOREVIEW;COMMENT;MONITOR;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Admin-Author-Monitor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (48,'Workgroup','Admin-Author-Monitor-Delegator',
';WORKGROUPADMIN;DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;MONITOR;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Admin-Contributor-Monitor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (49,'Workgroup','Admin-Contributor-Monitor-Delegator',
';WORKGROUPADMIN;DOREVIEW;COMMENT;CONTRIBUTE;MONITOR;DELEGATOR;', 'PleaseReview');
COMMIT;

-- Admin-Author-Contributor-Monitor-Delegator
INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, 		PermissionFlags, Product)
VALUES (50,'Workgroup','Admin-Author-Contributor-Monitor-Delegator',
';WORKGROUPADMIN;DOREVIEW;COMMENT;AUTHOR;CREATEREVIEW;CONTRIBUTE;MONITOR;DEFINEEDITZONE;DELEGATOR;', 'PleaseReview');
COMMIT;

/* --- END OF Standard Data for Managerial Delegation implementation --- */

/* --- BEGIN _ Standard Data for Simple Delegation implementation --- */

ALTER TABLE T_PermissionSet ADD Internal INT NULL;
COMMIT;

INSERT INTO T_PermissionSet (ObjectId,	PermissionType, Title, PermissionFlags, Product, Internal)
VALUES (51,'Review','Delegated', ';DOREVIEW;', 'PleaseReview', 1);
COMMIT;

/* --- END OF Standard Data for Simple Delegation implementation --- */


INSERT INTO T_SystemPolicy(ObjectId,Principal,Permission,PolicyAction,PolicyObject)
VALUES (64, 'SYSTEM', 'PROTECTDOWNLOADEDDOCUMENT', 'PERMIT', 'SYSTEM');
COMMIT;