Delete from hib.eventtype --where id >= 1 and id <= 12


--;	private static final int EVENT_TYPE_ID_INITIATE_REQUEST = 1;
--:	private static final int EVENT_TYPE_ID_SUBMIT_REQUEST = 2;
--:	private static final int EVENT_TYPE_ID_AMEND_REQUEST = 3;
--:	private static final int EVENT_TYPE_ID_SUBMIT_CHANGE_REQUEST = 4;	
--:	private static final int EVENT_TYPE_ID_CLOSE_REQUEST = 5;
	
--;	private static final int EVENT_TYPE_ID_APPROVE_REVIEW = 6;
--;	private static final int EVENT_TYPE_ID_DENY_REVIEW = 7;
--;	private static final int EVENT_TYPE_ID_CHANGE_REQUEST = 8;
--;	private static final int EVENT_TYPE_ID_SENT_FOR_REVIEW = 9;

--:	private static final int EVENT_TYPE_ID_APPROVE_ENTIRE_REQUEST = 10;


--; Event.create("Initiated", "Initiated Data Access Request", this, createdBy);
--; Event.create("Submitted", "Submitting Data Access Request Packet to NDS", request, userLoginId);
--; Event.create("Request Submitted with Changes", "Request Submitted with Changes", request, userLoginId);
--; Event.create("Request Amendment Created", "Creating Amendment", amendmentRequest, prefs.getUserLoginId());
--; Event.create("Closed", "Data Access Request Closed", this, userId);

--; Event.create(groupShortName + " Review Approval", groupShortName + " Review Approval", request, userLoginId);
--; Event.create(groupShortName + " Review Denied", groupShortName + " Review Denied", request, userLoginId);
--; Event.create("Change Requested by " + groupShortName, "Change Requested by " + groupShortName, request, userLoginId);
--; Event.create("Request Sent for " + groupShortName + " Review", "Request Sent for " + groupShortName + " Review", request, userLoginId);

--; Event.create("Request Approval", "Request Approval", req, prefs.getUserLoginId());


--; Duplicates
--; Event.create("Sent for Initial NDS Review", "Sent for Initial NDS Review", request, userLoginId);
--; Event.create("Initial NDS Review Complete", "Initial NDS Review Complete", request, userLoginId);
--; Event.create("Initial NDS Review Denied", "Initial NDS Review Denied", request, userLoginId);
--; Event.create("Change Requested by NDS", "Change Requested by NDS", request, userLoginId);
--; Event.create("Request Sent for Final NDS Review", "Request Sent for Final NDS Review", request, userLoginId);
--; Event.create("Final NDS Approval Complete", "Final NDS Approval Complete", request, userLoginId);
--; Event.create("Final NDS Review Denied", "Request Denied", request, userLoginId);


SET IDENTITY_INSERT  hib.eventtype  ON

--; requestor
Insert into hib.eventtype (id, name, description)
values (1, 'Initiated', 'Initiated Data Access Request')

Insert into hib.eventtype (id, name, description)
values (2, 'Submitted', 'Submitting Data Access Request Packet to NDS')

Insert into hib.eventtype (id, name, description)
values (3, 'Request Amendment Created', 'Creating Amendment')

Insert into hib.eventtype (id, name, description)
values (4, 'Request Submitted with Changes', 'Request Submitted with Changes')

Insert into hib.eventtype (id, name, description)
values (5, 'Closed', 'Data Access Request Closed')


--; intermediate review
Insert into hib.eventtype (id, name, description)
values (6, 'Review Approval', 'Review Approval')

Insert into hib.eventtype (id, name, description)
values (7, 'Review Denied', 'Review Denied')

Insert into hib.eventtype (id, name, description)
values (8, 'Change Requested', 'Change Requested')

Insert into hib.eventtype (id, name, description)
values (9, 'Request Sent for Review', 'Request Sent for Review')


--; overall
Insert into hib.eventtype (id, name, description)
values (10, 'Request Approval', 'Request Approval')


--; all workflows completed
Insert into hib.eventtype (id, name, description)
values (11, 'Request Completed', 'Request Completed')


--; data sources removed, workflow closed
Insert into hib.eventtype (id, name, description)
values (12, 'Workflow Closed', 'Workflow Closed');


SET IDENTITY_INSERT  hib.eventtype  OFF


--; Select * from hib.eventtype