USE $(DATA_BASE_NAME);
GO
--Add next value to support Preparatory to Research
SET IDENTITY_INSERT  hib.[requesttype]  ON;
Insert into hib.[requesttype] (id, name)
values (5, 'Preparatory Request');
SET IDENTITY_INSERT  hib.[requesttype]  OFF;

SET IDENTITY_INSERT  hib.[activitytype]  ON;
Insert into hib.[activitytype] (id, name)
values (4, 'Preparatory Study');
SET IDENTITY_INSERT  hib.[activitytype]  OFF;

ALTER TABLE hib.[request]
  ADD expectedIRBSubmissionDate date;
  
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (7,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (8,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (11,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (12,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (13,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1001,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1022,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1023,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1024,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1025,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1026,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1029,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1030,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1031,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1037,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1038,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1039,51);
INSERT INTO hib.datasourcedocumenttemplate (datasourceid,documenttemplateid) VALUES (1040,51);


SET IDENTITY_INSERT  hib.[documenttemplate]  ON;
Insert into hib.documenttemplate (id,name,description,location,participant,administrator,activitytype,principalinvestigator,sortorder)
values (51,'Preparatory to Research Memorandum','Preparatory to Research Memorandum',0,0,0,'P',0,1);
SET IDENTITY_INSERT  hib.[documenttemplate]  OFF;
  

SET IDENTITY_INSERT  hib.workflowtype  ON
INSERT INTO hib.workflowtype (id,name,description)
     VALUES(5, 'Preparatory Request Workflow','Preparatory Request Workflow')
SET IDENTITY_INSERT  hib.workflowtype  OFF    

