    LARGE_ELEMENT_COUNT_FLAG  numeric(1,0) NOT NULL default '0',
    UPDATE_DATE  smalldatetime NOT NULL default '2005-01-01',
    PARENT_PROTECTION_GROUP_ID  numeric(20) default NULL,
-  PRIMARY KEY  ( PROTECTION_GROUP_ID ),
-	CONSTRAINT UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME UNIQUE (APPLICATION_ID , PROTECTION_GROUP_NAME)
+ CONSTRAINT UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME UNIQUE (APPLICATION_ID , PROTECTION_GROUP_NAME)
 
 )
+alter table CSM_PROTECTION_GROUP add constraint PK_CSM_PROTECTION_GROUP_ID primary key (PROTECTION_GROUP_ID);
+
 
 /* Dumping data for table csm_protection_group*/
 
-SET IDENTITY_INSERT dbo.CSM_PROTECTION_GROUP ON
+SET IDENTITY_INSERT CSM_PROTECTION_GROUP ON
 INSERT INTO CSM_PROTECTION_GROUP (PROTECTION_GROUP_ID,PROTECTION_GROUP_NAME,PROTECTION_GROUP_DESCRIPTION,APPLICATION_ID,LARGE_ELEMENT_COUNT_FLAG,UPDATE_DATE,PARENT_PROTECTION_GROUP_ID) 
 		VALUES (1,'ADMINISTRATOR_PROTECTION_GROUP','Protection elements for class names of objects that belong to Administrative data',1,0,0000-00-00,NULL);
 INSERT INTO CSM_PROTECTION_GROUP (PROTECTION_GROUP_ID,PROTECTION_GROUP_NAME,PROTECTION_GROUP_DESCRIPTION,APPLICATION_ID,LARGE_ELEMENT_COUNT_FLAG,UPDATE_DATE,PARENT_PROTECTION_GROUP_ID) VALUES (2,'SUPERVISOR_PROTECTION_GROUP','Protection elements for class names of objects that belong to Supervisor''s data',1,0,0000-00-00,NULL);

INSERT INTO CSM_ROLE_PRIVILEGE (ROLE_PRIVILEGE_ID,ROLE_ID,PRIVILEGE_ID,UPDATE_DATE) SELECT MAX(ROLE_PRIVILEGE_ID)+1,11,23,'2008-06-19' FROM CSM_ROLE_PRIVILEGE;
INSERT INTO CSM_ROLE_PRIVILEGE (ROLE_PRIVILEGE_ID,ROLE_ID,PRIVILEGE_ID,UPDATE_DATE) SELECT MAX(ROLE_PRIVILEGE_ID)+1,1,30,'2008-08-20' FROM CSM_ROLE_PRIVILEGE;
INSERT INTO CSM_ROLE_PRIVILEGE (ROLE_PRIVILEGE_ID,ROLE_ID,PRIVILEGE_ID,UPDATE_DATE) SELECT MAX(ROLE_PRIVILEGE_ID)+1,2,30,'2008-08-20' FROM CSM_ROLE_PRIVILEGE;
SET IDENTITY_INSERT dbo.CSM_ROLE_PRIVILEGE OFF

/** MSR changes : End **/
INSERT INTO CSM_PRIVILEGE ( PRIVILEGE_ID, PRIVILEGE_NAME , PRIVILEGE_DESCRIPTION , UPDATE_DATE ) VALUES(28,'GENERAL_SITE_ADMINISTRATION','THIS PRIVILEGE GRANTS PERMISSION TO A USER FOR ADD EDIT SITES','2008-06-19');
INSERT INTO CSM_PRIVILEGE ( PRIVILEGE_ID, PRIVILEGE_NAME , PRIVILEGE_DESCRIPTION , UPDATE_DATE ) VALUES(29,'GENERAL_ADMINISTRATION','THIS PRIVILEGE GRANTS PERMISSION TO A USER FOR ADD EDIT DEPARTMENT,INSTITUTION,CANCER RESEARCH GROUP','2008-06-19');
INSERT INTO CSM_PRIVILEGE ( PRIVILEGE_ID, PRIVILEGE_NAME , PRIVILEGE_DESCRIPTION , UPDATE_DATE ) VALUES(30,'SHIPMENT_PROCESSING','THIS PRIVILEGE GRANTS PERMISSION TO A USER TO PROCESS SHIPMENTS','2008-08-20');
SET IDENTITY_INSERT CSM_PRIVILEGE OFF

SET IDENTITY_INSERT CSM_ROLE ON
INSERT INTO CSM_ROLE ( ROLE_ID, ROLE_NAME , ROLE_DESCRIPTION , APPLICATION_ID , ACTIVE_FLAG , UPDATE_DATE ) VALUES(13,'SUPERADMINISTRATOR','SUPER ADMINISTRATOR ROLE',1,0,'2008-06-19');
SET IDENTITY_INSERT CSM_ROLE OFF

SET IDENTITY_INSERT CSM_ROLE_PRIVILEGE ON
INSERT INTO CSM_ROLE_PRIVILEGE (ROLE_PRIVILEGE_ID,ROLE_ID,PRIVILEGE_ID,UPDATE_DATE) SELECT MAX(ROLE_PRIVILEGE_ID)+1,13,13,'2008-06-19' FROM CSM_ROLE_PRIVILEGE;
INSERT INTO CSM_ROLE_PRIVILEGE (ROLE_PRIVILEGE_ID,ROLE_ID,PRIVILEGE_ID,UPDATE_DATE) SELECT MAX(ROLE_PRIVILEGE_ID)+1,13,17,'2008-06-19' FROM CSM_ROLE_PRIVILEGE;
INSERT INTO CSM_ROLE_PRIVILEGE (ROLE_PRIVILEGE_ID,ROLE_ID,PRIVILEGE_ID,UPDATE_DATE) SELECT MAX(ROLE_PRIVILEGE_ID)+1,13,14,'2008-06-19' FROM CSM_ROLE_PRIVILEGE;
