

/****** Object:  Table [dbo].[HMS_User]    Script Date: 04/02/2017 00:15:50 ******/
SET IDENTITY_INSERT [dbo].[HMS_User] ON
INSERT [dbo].[HMS_User] ([UserId], [FirstName], [MiddleName], [LastName], [Email], [Phone], [Password], [CompanyId], [RoleId], [Address1], [Address2], [City], [State], [ZipCode], [Country], [ProfilePic], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate], [CreatedBy]) VALUES (1, N'Super', N'-', N'Admin', N'superadmin@email.com', N'1234567890', N'123456', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, CAST(0x0000A08C011C5BBB AS DateTime), CAST(0x0000A6E900BC033D AS DateTime), NULL)
SET IDENTITY_INSERT [dbo].[HMS_User] OFF
/****** Object:  Table [dbo].[HMS_SiteMenuLTE]    Script Date: 04/02/2017 00:15:50 ******/
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1, 0, N'DASHBOARD', N'Dashboard', N'Dashboard', N'fa-dashboard', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (101, 0, N'COMPANY_MGMT', N'Hospital Mgmt', N'Company', N'fa-header', 2, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (102, 101, N'COMPANY', N'Hospitals', N'Company', N'fa-circle-o', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (201, 0, N'DOCTOR', N'Doctors', N'Doctor', N'fa-user-md', 3, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (301, 0, N'PATIENT', N'Patients', N'Patient', N'fa-wheelchair-alt', 4, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (401, 0, N'USER_MGMT', N'User Mgmt', N'Admin', N'fa-user', 5, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (402, 401, N'ADMIN_MGMT', N'Admins', N'Admin', N'fa-circle-o', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (403, 401, N'NURSE', N'Nurses', N'Nurse', N'fa-user-o', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (404, 401, N'LABORATRIST', N'Laboraties', N'Lab', N'fa-user-o', 2, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (405, 401, N'PHARMACIST', N'Pharmacist', N'Pharma', N'fa-user-o', 3, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (406, 401, N'ACCOUNTANT', N'Accountants', N'Accountant', N'fa-user-o', 4, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (501, 0, N'FINANCE_MGMT', N'Finance Mgmt', N'', N'fa-dollar', 6, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (502, 501, N'PAYMENT', N'Payment', N'Payment', N'fa-money', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (503, 501, N'EXPENSE', N'Expense', N'Expense', N'fa-credit-card', 2, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (504, 501, N'PAYMENT_CATEGORY', N'Payment Categories', N'PaymentCategoryList', N'fa-tags', 3, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (505, 501, N'EXPENSE_CATEGORY', N'Expense Categories', N'ExpenseCategory', N'fa-tags', 4, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (601, 0, N'MEDICINE_MGMT', N'Medicine Mgmt', N'', N'fa-medkit', 7, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (602, 601, N'MEDICINE', N'Medicines', N'Medicine', N'fa-circle-o', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (603, 601, N'MEDICINE_CAT', N'Medicine Categories', N'MedicineCategory', N'fa-circle-o', 2, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (701, 0, N'BED_MGMT', N'Bed Mgmt', N'', N'fa-bed', 8, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (702, 701, N'BED', N'Beds', N'Bed', N'fa-circle-o', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (703, 701, N'BED_CAT', N'Bed Categories', N'BedCategory', N'fa-circle-o', 2, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (704, 701, N'BED_ALLOT', N'Bed Allotments', N'BedAllotment', N'fa-circle-o', 3, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (801, 0, N'LAB_MGMT', N'Lab Mgmt', N'', N'fa-flask', 9, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (802, 801, N'LAB_TEST', N'Lab Test', N'LabTest', N'fa-circle-o', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (803, 801, N'LAB_TEST_CAT', N'Lab Test Categories', N'LabTestCategory', N'fa-circle-o', 2, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (804, 801, N'PATIENT_TEST', N'Patient Test', N'PatientTest', N'fa-circle-o', 3, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (901, 0, N'SETTINGS', N'Settings', N'', N'fa-cog', 18, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (902, 901, N'GENERAL_SETTINGS', N'Site Settings', N'SiteFeatures', N'fa-circle-o', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (903, 901, N'EMAIL_TEMPLATE_MGMT', N'Email Templates', N'EmailTemplate', N'fa-circle-o', 2, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1001, 0, N'EDIT_PROFILE', N'Edit Profile', N'EditProfile', N'fa-edit', 19, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1101, 0, N'SITEMAP', N'Sitemap', N'Sitemap', N'fa-home', 20, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1301, 0, N'REPORT_MGMT', N'Reports', N'', N'fa-heartbeat', 10, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1302, 1301, N'BIRTH_REPORT', N'Birth Report', N'Birth', N'fa-wpforms', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1303, 1301, N'DEATH_REPORT', N'Death Report', N'Death', N'fa-wpforms', 2, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1401, 0, N'BLOOD_BANK', N'Blood Bank', N'', N'fa-tint', 11, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1402, 1401, N'PRIVATE_BLOOD_BANK', N'Private Blood Bank', N'PrivateBloodBank', N'fa-circle-o', 1, 1, 0)
INSERT [dbo].[HMS_SiteMenuLTE] ([MenuId], [ParentMenuId], [MenuCode], [MenuName], [MenuPageName], [MenuImageName], [MenuOrderNo], [IsActive], [IsDeleted]) VALUES (1403, 1401, N'PUBLIC_BLOOD_BANK', N'Public Bood Bank', N'PublicBloodBank', N'fa-circle-o', 2, 1, 0)
/****** Object:  Table [dbo].[HMS_Setting]    Script Date: 04/02/2017 00:15:50 ******/
SET IDENTITY_INSERT [dbo].[HMS_Setting] ON
INSERT [dbo].[HMS_Setting] ([SettingId], [SiteTitle], [CopyrightText], [AdminEmail], [SupportEmail], [ContactEmail], [TollFreeNo], [ContactNo], [SMTPHost], [SMTPPort], [SMTPUserName], [SMTPPassword], [PageSize]) VALUES (1, N'Hospital Management System', N'##YEAR##  &copy; HMS PRO', N'admin@email.com', N'support@email.com', N'contact@email.com', N'', N'', N'localhost', 25, N'', N'', 10)
SET IDENTITY_INSERT [dbo].[HMS_Setting] OFF
/****** Object:  Table [dbo].[HMS_RoleSiteMenu]    Script Date: 04/02/2017 00:15:50 ******/
SET IDENTITY_INSERT [dbo].[HMS_RoleSiteMenu] ON
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (1, 1, 1, N'DASHBOARD')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (2, 1, 101, N'COMPANY_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (3, 1, 102, N'COMPANY')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (4, 1, 401, N'USER_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (5, 1, 402, N'ADMIN_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (6, 1, 901, N'SETTINGS')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (7, 1, 902, N'GENERAL_SETTINGS')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (8, 1, 903, N'EMAIL_TEMPLATE_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (9, 1, 1001, N'EDIT_PROFILE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (10, 1, 1101, N'SITEMAP')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (11, 2, 1, N'DASHBOARD')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (12, 2, 201, N'DOCTOR')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (13, 2, 301, N'PATIENT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (14, 2, 401, N'USER_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (16, 2, 403, N'NURSE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (17, 2, 404, N'LABORATRIST')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (18, 2, 405, N'PHARMACIST')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (19, 2, 406, N'ACCOUNTANT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (20, 2, 501, N'FINANCE_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (21, 2, 502, N'PAYMENT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (22, 2, 503, N'EXPENSE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (23, 2, 504, N'PAYMENT_CATEGORY')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (24, 2, 505, N'EXPENSE_CATEGORY')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (25, 2, 601, N'MEDICINE_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (26, 2, 602, N'MEDICINE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (27, 2, 603, N'MEDICINE_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (28, 2, 701, N'BED_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (29, 2, 702, N'BED')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (30, 2, 703, N'BED_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (31, 2, 704, N'BED_ALLOT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (32, 2, 801, N'LAB_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (33, 2, 802, N'LAB_TEST')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (34, 2, 803, N'LAB_TEST_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (35, 2, 804, N'PATIENT_TEST')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (36, 2, 1001, N'EDIT_PROFILE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (37, 2, 1101, N'SITEMAP')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (38, 3, 1, N'DASHBOARD')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (39, 4, 1, N'DASHBOARD')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (40, 5, 1, N'DASHBOARD')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (41, 6, 1, N'DASHBOARD')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (42, 7, 1, N'DASHBOARD')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (43, 3, 301, N'PATIENT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (44, 7, 501, N'FINANCE_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (45, 7, 502, N'PAYMENT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (46, 7, 503, N'EXPENSE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (47, 7, 504, N'PAYMENT_CATEGORY')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (49, 7, 505, N'EXPENSE_CATEGORY')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (50, 3, 601, N'MEDICINE_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (51, 5, 601, N'MEDICINE_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (52, 3, 602, N'MEDICINE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (53, 5, 602, N'MEDICINE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (54, 3, 603, N'MEDICINE_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (55, 5, 603, N'MEDICINE_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (56, 3, 701, N'BED_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (57, 3, 702, N'BED')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (58, 3, 703, N'BED_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (59, 3, 704, N'BED_ALLOT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (60, 4, 701, N'BED_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (61, 4, 702, N'BED')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (62, 4, 703, N'BED_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (63, 4, 704, N'BED_ALLOT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (64, 3, 801, N'LAB_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (65, 3, 802, N'LAB_TEST')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (66, 3, 803, N'LAB_TEST_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (67, 3, 804, N'PATIENT_TEST')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (68, 6, 801, N'LAB_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (69, 6, 802, N'LAB_TEST')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (70, 6, 803, N'LAB_TEST_CAT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (71, 6, 804, N'PATIENT_TEST')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (72, 3, 1001, N'EDIT_PROFILE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (73, 4, 1001, N'EDIT_PROFILE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (76, 5, 1001, N'EDIT_PROFILE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (77, 6, 1001, N'EDIT_PROFILE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (78, 7, 1001, N'EDIT_PROFILE')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (79, 3, 1101, N'SITEMAP')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (80, 4, 1101, N'SITEMAP')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (81, 5, 1101, N'SITEMAP')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (82, 6, 1101, N'SITEMAP')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (83, 7, 1101, N'SITEMAP')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (84, 4, 301, N'PATIENT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (86, 2, 1301, N'REPORT_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (87, 3, 1301, N'REPORT_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (88, 4, 1301, N'REPORT_MGMT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (89, 2, 1302, N'BIRTH_REPORT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (90, 3, 1302, N'BIRTH_REPORT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (91, 4, 1302, N'BIRTH_REPORT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (92, 2, 1303, N'DEATH_REPORT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (93, 3, 1303, N'DEATH_REPORT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (94, 4, 1303, N'DEATH_REPORT')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (95, 2, 1401, N'BLOOD_BANK')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (96, 6, 1401, N'BLOOD_BANK')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (97, 2, 1402, N'PRIVATE_BLOOD_BANK')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (98, 6, 1402, N'PRIVATE_BLOOD_BANK')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (99, 2, 1403, N'PUBLIC_BLOOD_BANK')
INSERT [dbo].[HMS_RoleSiteMenu] ([RoleSiteMenuId], [RoleId], [MenuId], [MenuCode]) VALUES (100, 6, 1403, N'PUBLIC_BLOOD_BANK')
SET IDENTITY_INSERT [dbo].[HMS_RoleSiteMenu] OFF
/****** Object:  Table [dbo].[HMS_Role]    Script Date: 04/02/2017 00:15:50 ******/
SET IDENTITY_INSERT [dbo].[HMS_Role] ON
INSERT [dbo].[HMS_Role] ([RoleId], [RoleName]) VALUES (1, N'Super Administrator')
INSERT [dbo].[HMS_Role] ([RoleId], [RoleName]) VALUES (2, N'Administrator')
INSERT [dbo].[HMS_Role] ([RoleId], [RoleName]) VALUES (3, N'Doctor')
INSERT [dbo].[HMS_Role] ([RoleId], [RoleName]) VALUES (4, N'Nurse')
INSERT [dbo].[HMS_Role] ([RoleId], [RoleName]) VALUES (5, N'Pharmacist')
INSERT [dbo].[HMS_Role] ([RoleId], [RoleName]) VALUES (6, N'Laboratorist')
INSERT [dbo].[HMS_Role] ([RoleId], [RoleName]) VALUES (7, N'Accountant')
INSERT [dbo].[HMS_Role] ([RoleId], [RoleName]) VALUES (8, N'Patient')
SET IDENTITY_INSERT [dbo].[HMS_Role] OFF
/****** Object:  Table [dbo].[HMS_EmailTemplate]    Script Date: 04/02/2017 00:15:50 ******/
SET IDENTITY_INSERT [dbo].[HMS_EmailTemplate] ON
INSERT [dbo].[HMS_EmailTemplate] ([EmailTemplateId], [Code], [Title], [Subject], [FromEmail], [Message], [Signature], [IsActive], [IsDeleted], [CreatedDate], [ModifiedDate]) VALUES (1, N'FORGOT_PASSWORD', N'Forgot Password', N'Your login details', N'tgeek001@gmail.com', N'<p>Hi,</p>

<p>We have received a request to remind you of your registered password. If this was not you please contact admin@demo.com</p>

<p>Password : ##PASSWORD## [as per registered]</p>

<p>&nbsp;</p>

<p>Thanks &amp; Regards</p>

<p>##SIGNATURE_NAME##</p>
', N'<p>Company Name</p>
', 1, 0, CAST(0x0000A2BD00B255A2 AS DateTime), CAST(0x0000A74500C36ABC AS DateTime))
SET IDENTITY_INSERT [dbo].[HMS_EmailTemplate] OFF

INSERT [dbo].[HMS_BloodGroup] ([BloodGroup]) VALUES (N'A+')
INSERT [dbo].[HMS_BloodGroup] ([BloodGroup]) VALUES (N'A-')
INSERT [dbo].[HMS_BloodGroup] ([BloodGroup]) VALUES (N'AB+')
INSERT [dbo].[HMS_BloodGroup] ([BloodGroup]) VALUES (N'AB-')
INSERT [dbo].[HMS_BloodGroup] ([BloodGroup]) VALUES (N'B+')
INSERT [dbo].[HMS_BloodGroup] ([BloodGroup]) VALUES (N'B-')
INSERT [dbo].[HMS_BloodGroup] ([BloodGroup]) VALUES (N'O+')
INSERT [dbo].[HMS_BloodGroup] ([BloodGroup]) VALUES (N'O-')
