USE $(DATA_BASE_NAME);
GO

DELETE from hib.[datasourceworkflowtemplate]


--NDS
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1022,1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1023, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1024, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1025, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1026, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1027, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1028, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1029, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (6, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (3, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (7, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1030, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1031, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (12, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (11, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1001, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (8, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1036, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1032, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (13, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1037, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1038, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1039, 1)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1040, 1)


--Surgery (Independent Workflow)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1034, 2)

--OEF/OIF (Independent Workflow)
INSERT INTO hib.[datasourceworkflowtemplate] (datasourceid, workflowtemplateid)
VALUES (1033, 3)    
