USE sotelsoenet;

INSERT INTO dbo.documenttype
(Name, ViewPageName, ViewControlName, LargeIcon, ParentIDType, isPlugin, GUID, FormClass, CreatedDt, UpdatedDt, PAssembly_PAssemblyID)
VALUES ('Consent Form', 'consent-form.aspx', '', 'consent-128.png', 'Patient', 0, 'b7c8ce1c-3f5f-4966-b603-55da4845e49c', '', '2018-11-15 13:36:15', '2018-11-15 13:36:15', null);

INSERT INTO dbo.documenttype
(Name, ViewPageName, ViewControlName, LargeIcon, ParentIDType, isPlugin, GUID, FormClass, CreatedDt, UpdatedDt, PAssembly_PAssemblyID)
VALUES ('PediSANE Form', 'Plugins/PediSANEProtocol/default.aspx', '', 'pedisane-128.png', 'Root', 1, 'd417f045-2242-489a-b369-b74da227f03d', '', '2018-11-15 13:36:15', '2018-11-15 13:36:15', null);

INSERT INTO dbo.documenttype
(Name, ViewPageName, ViewControlName, LargeIcon, ParentIDType, isPlugin, GUID, FormClass, CreatedDt, UpdatedDt, PAssembly_PAssemblyID)
VALUES ('PediSANE Form', 'Plugins/PediSANEProtocol/default.aspx', '', 'pedisane-128.png', 'Site', 1, 'd417f045-2242-489a-b369-b74da227f03d', '', '2018-11-15 13:36:15', '2018-11-15 13:36:15', null);

INSERT INTO dbo.documenttype
(Name, ViewPageName, ViewControlName, LargeIcon, ParentIDType, isPlugin, GUID, FormClass, CreatedDt, UpdatedDt, PAssembly_PAssemblyID)
VALUES ('PediSANE Form', 'Plugins/PediSANEProtocol/default.aspx', '', 'pedisane-128.png', 'Patient', 1, 'd417f045-2242-489a-b369-b74da227f03d', '', '2018-11-15 13:36:15', '2018-11-15 13:36:15', null);

INSERT INTO dbo.documenttype
(Name, ViewPageName, ViewControlName, LargeIcon, ParentIDType, isPlugin, GUID, FormClass, CreatedDt, UpdatedDt, PAssembly_PAssemblyID)
VALUES ('PediSANE Form', 'Plugins/PediSANEProtocol/default.aspx', '', 'pedisane-128.png', 'Referral', 1, 'd417f045-2242-489a-b369-b74da227f03d', '', '2018-11-15 13:36:15', '2018-11-15 13:36:15', null);

INSERT INTO dbo.documenttype
(Name, ViewPageName, ViewControlName, LargeIcon, ParentIDType, isPlugin, GUID, FormClass, CreatedDt, UpdatedDt, PAssembly_PAssemblyID)
VALUES ('Quarantine', 'quarantined-file.aspx', 'quarantined-file.aspx', 'quarantine2-128.png', 'Patient', 0, '36ede044-4bf0-4e83-99d3-587e760df89a', '', '2018-11-15 13:36:15', '2018-11-15 13:36:15', null);

INSERT INTO dbo.documenttype
(Name, ViewPageName, ViewControlName, LargeIcon, ParentIDType, isPlugin, GUID, FormClass, CreatedDt, UpdatedDt, PAssembly_PAssemblyID)
VALUES ('Upload Community File', 'uploadfile-form.aspx', 'ViewOther.ascx', 'document-128.png', 'Site', 0, '2e8fb4d0-1735-42c6-b05c-6c3d90c331b9', '', '2018-11-15 13:36:15', '2018-11-15 13:36:15', null);

DELETE FROM dbo.documenttype WHERE Name='StrokeProtocol';
DELETE FROM dbo.documenttype WHERE Name='UCLA Anoscopy';
DELETE FROM dbo.documenttype WHERE Name='UCLA High Resolution Anoscopy Report';