Delete from hib.[activitytype]


SET IDENTITY_INSERT  hib.[activitytype]  ON


Insert into hib.[activitytype] (id, name)
values (1, 'Activity')

Insert into hib.[activitytype] (id, name)
values (2, 'Research Study')

Insert into hib.[activitytype] (id, name)
values (3, 'Operational Study')


SET IDENTITY_INSERT  hib.[activitytype]  OFF


--; Select * from hib.[activitytype]

----------------------------------------------------------
----------------------------------------------------------

Delete from hib.[requesttype]


SET IDENTITY_INSERT  hib.[requesttype]  ON


Insert into hib.[requesttype] (id, name)
values (1, 'Request')

Insert into hib.[requesttype] (id, name)
values (2, 'Dart Request')

Insert into hib.[requesttype] (id, name)
values (3, 'Software Request')

Insert into hib.[requesttype] (id, name)
values (4, 'Operational Request')


SET IDENTITY_INSERT  hib.[requesttype]  OFF


--; Select * from hib.[requesttype]

----------------------------------------------------------
----------------------------------------------------------

Delete from hib.[requeststatus]


SET IDENTITY_INSERT  hib.[requeststatus]  ON


Insert into hib.[requeststatus] (id, name)
values (1, 'Initiated')

Insert into hib.[requeststatus] (id, name)
values (2, 'Submitted')

Insert into hib.[requeststatus] (id, name)
values (3, 'Change Requested')

Insert into hib.[requeststatus] (id, name)
values (4, 'Approved')

Insert into hib.[requeststatus] (id, name)
values (5, 'Denied')

Insert into hib.[requeststatus] (id, name)
values (6, 'Closed')

Insert into hib.[requeststatus] (id, name)
values (7, 'Request Completed')


SET IDENTITY_INSERT  hib.[requeststatus]  OFF


--; Select * from hib.[requeststatus]