create table `modules` (`id` bigint unsigned not null auto_increment primary key, `name` varchar(191) not null, `is_active` tinyint(1) not null default '1', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci';

alter table `modules` add `route` varchar(191) null after `is_active`;
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Patients', 1, 'patients.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Doctors', 1, 'doctors.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Accountants', 1, 'accountants.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Medicines', 1, 'medicines.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Nurses', 1, 'nurses.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Receptionists', 1, 'receptionists.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Lab Technicians', 1, 'lab-technicians.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Pharmacists', 1, 'pharmacists.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Birth Reports', 1, 'birth-reports.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Death Reports', 1, 'death-reports.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Investigation Reports', 1, 'investigation-reports.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Operation Reports', 1, 'operation-reports.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Income', 1, 'incomes.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Expense', 1, 'expenses.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('SMS', 1, 'sms.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('IPD Patients', 1, 'ipd.patient.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('OPD Patients', 1, 'opd.patient.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Accounts', 1, 'accounts.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Employee Payrolls', 1, 'employee-payrolls.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Invoices', 1, 'invoices.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Payments', 1, 'payments.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Payment Reports', 1, 'payment.reports','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Advance Payments', 1, 'advanced-payments.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Bills', 1, 'bills.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Bed Types', 1, 'bed-types.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Beds', 1, 'beds.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Bed Assigns', 1, 'bed-assigns.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Blood Banks', 1, 'blood-banks.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Blood Donors', 1, 'blood-donors.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Documents', 1, 'documents.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Document Types', 1, 'document-types.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Services', 1, 'services.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Insurances', 1, 'insurances.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Packages', 1, 'packages.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Ambulances', 1, 'ambulances.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Ambulances Calls', 1, 'ambulance-calls.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Appointments', 1, 'appointments.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Call Logs', 1, 'call_logs.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Visitors', 1, 'visitors.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Postal Receive', 1, 'receives.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Postal Dispatch', 1, 'dispatches.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Notice Boards', 1, 'notice-boards.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Mail', 1, 'mail','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Enquires', 1, 'enquiries','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Charge Categories', 1, 'charge-categories.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Charges', 1, 'charges.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Doctor OPD Charges', 1, 'doctor-opd-charges.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Items Categories', 1, 'item-categories.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Items', 1, 'items.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Item Stocks', 1, 'item.stock.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Issued Items', 1, 'issued.item.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Diagnosis Categories', 1, 'diagnosis.category.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Diagnosis Tests', 1, 'patient.diagnosis.test.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Pathology Categories', 1, 'pathology.category.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Pathology Tests', 1, 'pathology.test.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Radiology Categories', 1, 'radiology.category.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Radiology Tests', 1, 'radiology.test.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Medicine Categories', 1, 'categories.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Medicine Brands', 1, 'brands.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Doctor Departments', 1, 'doctor-departments.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Schedules', 1, 'schedules.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Prescriptions', 1, 'prescriptions.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Cases', 1, 'patient-cases.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Case Handlers', 1, 'case-handlers.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Patient Admissions', 1, 'patient-admissions.index','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('My Payrolls', 1, 'payroll','2020-10-03 00:00:00', '2020-10-03 00:00:00');
insert into `modules` (`name`, `is_active`, `route`, `updated_at`, `created_at`) values ('Patient Cases', 1, 'patients.cases','2020-10-03 00:00:00', '2020-10-03 00:00:00');