-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 16, 2019 at 11:22 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 7.1.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

TRUNCATE `permission_category`;
TRUNCATE `permission_group`;
TRUNCATE `roles_permissions`;


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Dumping data for table `permission_category`
--

INSERT INTO `permission_category` (`id`, `perm_group_id`, `name`, `short_code`, `enable_view`, `enable_add`, `enable_edit`, `enable_delete`, `created_at`) VALUES
(9, 3, 'Income', 'income', 1, 1, 1, 1, '2018-06-22 15:53:21'),
(10, 3, 'Income Head', 'income_head', 1, 1, 1, 1, '2018-06-22 15:52:44'),
(12, 4, 'Expense', 'expense', 1, 1, 1, 1, '2018-06-22 15:54:06'),
(13, 4, 'Expense Head', 'expense_head', 1, 1, 1, 1, '2018-06-22 15:53:47'),
(14, 4, 'Search Expense', 'search_expense', 1, 0, 0, 0, '2018-06-22 15:54:13'),
(27, 8, 'Upload Content', 'upload_content', 1, 1, 0, 1, '2018-06-22 16:03:19'),
(31, 10, 'Issue Item', 'issue_item', 1, 1, 0, 1, '2018-12-17 15:25:14'),
(32, 10, 'Item Stock', 'item_stock', 1, 1, 1, 1, '2018-06-22 16:05:17'),
(33, 10, 'Item', 'item', 1, 1, 1, 1, '2018-06-22 16:05:40'),
(34, 10, 'Store', 'store', 1, 1, 1, 1, '2018-06-22 16:06:02'),
(35, 10, 'Supplier', 'supplier', 1, 1, 1, 1, '2018-06-22 16:06:25'),
(43, 13, 'Notice Board', 'notice_board', 1, 1, 1, 1, '2018-06-22 16:11:17'),
(44, 13, 'Email / SMS', 'email_sms', 1, 0, 0, 0, '2018-06-22 16:10:54'),
(46, 13, 'Email / SMS Log', 'email_sms_log', 1, 0, 0, 0, '2018-06-22 16:11:23'),
(48, 14, 'OPD Report', 'opd_report', 1, 0, 0, 0, '2018-12-18 14:29:18'),
(53, 15, 'Languages', 'languages', 0, 1, 0, 0, '2018-06-22 16:13:18'),
(54, 15, 'General Setting', 'general_setting', 1, 0, 1, 0, '2018-07-05 14:38:35'),
(56, 15, 'Notification Setting', 'notification_setting', 1, 0, 1, 0, '2018-07-05 14:38:41'),
(57, 15, 'SMS Setting', 'sms_setting', 1, 0, 1, 0, '2018-07-05 14:38:47'),
(58, 15, 'Email Setting', 'email_setting', 1, 0, 1, 0, '2018-07-05 14:38:51'),
(59, 15, 'Front CMS Setting', 'front_cms_setting', 1, 0, 1, 0, '2018-07-05 14:38:55'),
(60, 15, 'Payment Methods', 'payment_methods', 1, 0, 1, 0, '2018-07-05 14:38:59'),
(61, 16, 'Menus', 'menus', 1, 1, 0, 1, '2018-07-09 09:20:06'),
(62, 16, 'Media Manager', 'media_manager', 1, 1, 0, 1, '2018-07-09 09:20:26'),
(63, 16, 'Banner Images', 'banner_images', 1, 1, 0, 1, '2018-06-22 16:16:02'),
(64, 16, 'Pages', 'pages', 1, 1, 1, 1, '2018-06-22 16:16:21'),
(65, 16, 'Gallery', 'gallery', 1, 1, 1, 1, '2018-06-22 16:17:02'),
(66, 16, 'Event', 'event', 1, 1, 1, 1, '2018-06-22 16:17:20'),
(67, 16, 'News', 'notice', 1, 1, 1, 1, '2018-07-03 14:09:34'),
(80, 17, 'Visitor Book', 'visitor_book', 1, 1, 1, 1, '2018-06-22 16:18:58'),
(81, 17, 'Phone Call Log', 'phone_call_log', 1, 1, 1, 1, '2018-06-22 16:20:57'),
(82, 17, 'Postal Dispatch', 'postal_dispatch', 1, 1, 1, 1, '2018-06-22 16:20:21'),
(83, 17, 'Postal Receive', 'postal_receive', 1, 1, 1, 1, '2018-06-22 16:20:04'),
(84, 17, 'Complain', 'complain', 1, 1, 1, 1, '2018-12-19 14:41:37'),
(85, 17, 'Setup Front Office', 'setup_front_office', 1, 1, 1, 1, '2018-11-15 06:19:58'),
(86, 18, 'Staff', 'staff', 1, 1, 1, 1, '2018-06-22 16:23:31'),
(87, 18, 'Disable Staff', 'disable_staff', 1, 0, 0, 0, '2018-06-22 16:23:12'),
(88, 18, 'Staff Attendance', 'staff_attendance', 1, 1, 1, 0, '2018-06-22 16:23:10'),
(89, 18, 'Staff Attendance Report', 'staff_attendance_report', 1, 0, 0, 0, '2018-06-22 16:22:54'),
(90, 18, 'Staff Payroll', 'staff_payroll', 1, 1, 0, 1, '2018-06-22 16:22:51'),
(91, 18, 'Payroll Report', 'payroll_report', 1, 0, 0, 0, '2018-06-22 16:22:34'),
(102, 21, 'Calendar To Do List', 'calendar_to_do_list', 1, 1, 1, 1, '2018-06-22 16:24:41'),
(104, 10, 'Item Category', 'item_category', 1, 1, 1, 1, '2018-06-22 16:04:33'),
(108, 18, ' Approve Leave Request', 'approve_leave_request', 1, 1, 1, 1, '2018-07-02 15:47:41'),
(109, 18, 'Apply Leave', 'apply_leave', 1, 1, 1, 1, '2018-06-26 09:23:32'),
(110, 18, 'Leave Types ', 'leave_types', 1, 1, 1, 1, '2018-07-02 15:47:56'),
(111, 18, 'Department', 'department', 1, 1, 1, 1, '2018-06-26 09:27:07'),
(112, 18, 'Designation', 'designation', 1, 1, 1, 1, '2018-06-26 09:27:07'),
(118, 22, 'Staff Role Count Widget', 'staff_role_count_widget', 1, 0, 0, 0, '2018-07-03 12:43:35'),
(126, 15, 'User Status', 'user_status', 1, 0, 0, 0, '2018-07-03 14:12:29'),
(127, 18, 'Can See Other Users Profile', 'can_see_other_users_profile', 1, 0, 0, 0, '2018-07-03 14:12:29'),
(129, 18, 'Staff Timeline', 'staff_timeline', 0, 1, 0, 1, '2018-07-05 13:38:52'),
(130, 15, 'Backup', 'backup', 1, 1, 0, 1, '2018-07-09 09:47:17'),
(131, 15, 'Restore', 'restore', 1, 0, 0, 0, '2018-07-09 09:47:17'),
(132, 23, 'OPD Patient', 'opd_patient', 1, 1, 1, 1, '2018-12-20 15:07:26'),
(134, 23, 'Prescription', 'prescription', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(135, 23, 'Revisit', 'revisit', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(136, 23, 'OPD Diagnosis', 'opd diagnosis', 1, 1, 1, 1, '2018-10-11 12:16:59'),
(137, 23, 'OPD Timeline', 'opd timeline', 1, 1, 1, 1, '2018-10-11 12:17:22'),
(138, 24, 'IPD Patients', 'ipd_patient', 1, 1, 1, 1, '2018-10-11 12:44:55'),
(139, 24, 'Discharged Patients', 'discharged patients', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(140, 24, 'Consultant Register', 'consultant register', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(141, 24, 'IPD Diagnosis', 'ipd diagnosis', 1, 1, 1, 1, '2018-10-11 12:19:18'),
(142, 24, 'IPD Timeline', 'ipd timeline', 1, 1, 1, 1, '2018-10-11 12:19:42'),
(143, 24, 'Charges', 'charges', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(144, 24, 'Payment', 'payment', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(145, 24, 'Bill', 'bill', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(146, 25, 'Medicine', 'medicine', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(147, 25, 'Add Medicine Stock', 'add_medicine_stock', 1, 1, 1, 1, '2018-12-21 16:19:20'),
(148, 25, 'Pharmacy Bill', 'pharmacy bill', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(149, 26, 'Pathology Test', 'pathology test', 1, 1, 1, 1, '2018-12-22 14:16:42'),
(150, 26, 'Add Patient & Test Report', 'add_patho_patient_test_report', 1, 1, 1, 1, '2019-10-14 10:50:43'),
(152, 27, 'Radiology Test', 'radiology test', 1, 1, 1, 1, '2018-10-11 06:58:26'),
(153, 27, 'Add Patient & Test Report', 'add_radio_patient_test_reprt', 1, 1, 1, 1, '2019-10-14 10:50:53'),
(155, 22, 'IPD Income Widget', 'ipd_income_widget', 1, 0, 0, 0, '2018-12-20 14:38:05'),
(156, 22, 'OPD Income Widget', 'opd_income_widget', 1, 0, 0, 0, '2018-12-20 14:38:15'),
(157, 22, 'Pharmacy Income Widget', 'pharmacy_income_widget', 1, 0, 0, 0, '2018-12-20 14:38:25'),
(158, 22, 'Pathology Income Widget', 'pathology_income_widget', 1, 0, 0, 0, '2018-12-20 14:38:37'),
(159, 22, 'Radiology Income Widget', 'radiology_income_widget', 1, 0, 0, 0, '2018-12-20 14:38:49'),
(160, 22, 'OT Income Widget', 'ot_income_widget', 1, 0, 0, 0, '2018-12-20 14:39:02'),
(161, 22, 'Blood Bank Income Widget', 'blood_bank_income_widget', 1, 0, 0, 0, '2018-12-20 14:39:13'),
(162, 22, 'Ambulance Income Widget', 'ambulance_income_widget', 1, 0, 0, 0, '2018-12-20 14:39:25'),
(163, 28, 'OT Patient', 'ot_patient', 1, 1, 1, 1, '2018-10-27 09:05:57'),
(164, 28, 'OT Consultant Instruction', 'ot_consultant_instruction', 1, 1, 1, 1, '2018-10-27 09:06:19'),
(165, 29, 'Ambulance Call', 'ambulance_call', 1, 1, 1, 1, '2018-10-27 09:07:51'),
(166, 29, 'Ambulance', 'ambulance', 1, 1, 1, 1, '2018-10-27 09:07:59'),
(167, 30, 'Blood Bank Status', 'blood_bank_status', 1, 1, 1, 1, '2018-10-27 09:50:09'),
(168, 30, 'Blood Issue', 'blood_issue', 1, 1, 1, 1, '2018-10-27 09:50:15'),
(169, 30, 'Blood Donor', 'blood_donor', 1, 1, 1, 1, '2018-10-27 09:50:19'),
(170, 25, 'Medicine Category', 'medicine_category', 1, 1, 1, 1, '2018-10-25 11:40:24'),
(171, 27, 'Radiology Category', 'radiology category', 1, 1, 1, 1, '2018-12-22 14:33:20'),
(173, 31, 'Organisation', 'organisation', 1, 1, 1, 1, '2018-10-25 11:40:24'),
(174, 31, 'Charges', 'tpa_charges', 1, 1, 1, 1, '2018-12-22 15:36:57'),
(175, 26, 'Pathology Category', 'pathology_category', 1, 1, 1, 1, '2018-10-25 11:40:24'),
(176, 32, 'Charges', 'hospital_charges', 1, 1, 1, 1, '2018-12-22 15:38:26'),
(178, 14, 'IPD Report', 'ipd_report', 1, 0, 0, 0, '2018-12-12 15:39:24'),
(179, 14, 'Pharmacy Bill Report', 'pharmacy_bill_report', 1, 0, 0, 0, '2018-12-12 15:39:24'),
(180, 14, 'Pathology Patient Report', 'pathology_patient_report', 1, 0, 0, 0, '2018-12-12 15:39:24'),
(181, 14, 'Radiology Patient Report', 'radiology_patient_report', 1, 0, 0, 0, '2018-12-12 15:39:24'),
(182, 14, 'OT Report', 'ot_report', 1, 0, 0, 0, '2019-03-08 12:26:54'),
(183, 14, 'Blood Donor Report', 'blood_donor_report', 1, 0, 0, 0, '2018-12-12 15:39:24'),
(184, 14, 'Payroll Month Report', 'payroll_month_report', 1, 0, 0, 0, '2019-03-08 12:27:25'),
(185, 14, 'Payroll Report', 'payroll_report', 1, 0, 0, 0, '2019-03-08 12:27:35'),
(186, 14, 'Staff Attendance Report', 'staff_attendance_report', 1, 0, 0, 0, '2019-03-08 12:33:28'),
(187, 14, 'User Log', 'user_log', 1, 0, 0, 0, '2018-12-12 15:39:24'),
(188, 14, 'Patient Login Credential', 'patient_login_credential', 1, 0, 0, 0, '2018-12-12 15:39:24'),
(189, 14, 'Email / SMS Log', 'email_sms_log', 1, 0, 0, 0, '2018-12-12 15:39:24'),
(190, 22, 'Yearly Income & Expense Chart', 'yearly_income_expense_chart', 1, 0, 0, 0, '2018-12-12 15:52:05'),
(191, 22, 'Monthly Income & Expense Chart', 'monthly_income_expense_chart', 1, 0, 0, 0, '2018-12-12 15:55:14'),
(192, 23, 'OPD Prescription Print Header Footer ', 'opd_prescription_print_header_footer', 1, 1, 1, 1, '2018-12-12 16:01:07'),
(193, 24, 'Revert Generated Bill', 'revert_generated_bill', 1, 0, 0, 0, '2018-12-12 16:04:02'),
(194, 24, 'Calculate Bill', 'calculate_bill', 1, 0, 0, 0, '2018-12-12 16:05:30'),
(195, 24, 'Generate Bill & Discharge Patient', 'generate_bill_discharge_patient', 1, 0, 0, 0, '2018-12-21 14:56:00'),
(196, 24, 'Bed', 'bed', 1, 1, 1, 1, '2018-12-12 16:16:01'),
(197, 24, 'IPD Prescription Print Header Footer', 'ipd_prescription_print_header_footer', 1, 1, 1, 1, '2018-12-12 16:09:42'),
(198, 24, 'Bed Status', 'bed_status', 1, 0, 0, 0, '2018-12-12 16:09:42'),
(200, 25, 'Medicine Bad Stock', 'medicine_bad_stock', 1, 1, 0, 1, '2018-12-18 06:42:46'),
(201, 25, 'Pharmacy Bill print Header Footer', 'pharmacy_bill_print_header_footer', 1, 1, 1, 1, '2018-12-12 16:36:47'),
(202, 30, 'Donate Blood', 'donate_blood', 1, 1, 0, 1, '2018-12-12 16:47:10'),
(203, 32, 'Charge Category', 'charge_category', 1, 1, 1, 1, '2018-12-12 16:49:38'),
(204, 17, 'Appointment', 'appointment', 1, 1, 1, 1, '2018-12-18 17:22:53'),
(205, 17, 'Appointment Approve', 'appointment_approve', 1, 0, 0, 0, '2018-12-18 17:25:58'),
(206, 14, 'TPA Report', 'tpa_report', 1, 0, 0, 0, '2019-03-08 12:19:25'),
(207, 14, 'Ambulance Report', 'ambulance_report', 1, 0, 0, 0, '2019-03-08 12:19:41'),
(208, 14, 'Discharge Patient Report', 'discharge_patient_report', 1, 0, 0, 0, '2019-03-08 12:19:55'),
(209, 14, 'Appointment Report', 'appointment_report', 1, 0, 0, 0, '2019-03-08 12:20:10'),
(210, 14, 'Transaction Report', 'transaction_report', 1, 0, 0, 0, '2019-03-08 12:27:35'),
(211, 14, 'Blood Issue Report', 'blood_issue_report', 1, 0, 0, 0, '2019-03-08 12:27:35'),
(212, 14, 'Income Report', 'income_report', 1, 0, 0, 0, '2019-03-08 12:27:35'),
(213, 14, 'Expense Report', 'expense_report', 1, 0, 0, 0, '2019-03-08 12:27:35'),
(214, 34, 'Birth Record', 'birth_record', 1, 1, 1, 1, '2018-06-22 16:06:02'),
(215, 34, 'Death Record', 'death_record', 1, 1, 1, 1, '2018-06-22 16:06:02'),
(216, 17, 'Move Patient in OPD', 'move_patient_in_opd', 1, 0, 0, 0, '2019-09-23 10:14:41'),
(217, 17, 'Move Patient in IPD', 'move_patient_in_ipd', 1, 0, 0, 0, '2018-12-18 17:25:58'),
(218, 23, 'Move Patient in IPD', 'opd_move _patient_in_ipd', 1, 0, 0, 0, '2019-09-23 10:19:42'),
(219, 23, 'Manual Prescription', 'manual_prescription', 1, 0, 0, 0, '2019-09-23 10:22:06'),
(220, 24, 'Prescription ', 'ipd_prescription', 1, 1, 1, 1, '2019-09-24 06:29:27'),
(221, 23, 'Charges', 'opd_charges', 1, 1, 1, 1, '2019-09-23 10:28:03'),
(222, 23, 'Payment', 'opd_payment', 1, 1, 1, 1, '2019-09-24 06:14:29'),
(223, 23, 'Bill', 'opd_bill', 1, 1, 1, 1, '2019-09-23 10:29:37'),
(224, 25, 'Import Medicine', 'import_medicine', 1, 0, 0, 0, '2019-09-23 10:33:31'),
(225, 25, 'Medicine Purchase', 'medicine_purchase', 1, 1, 1, 1, '2019-09-23 10:35:53'),
(226, 25, 'Medicine Supplier', 'medicine_supplier', 1, 1, 1, 1, '2019-09-23 10:39:36'),
(227, 25, 'Medicine Dosage', 'medicine_dosage', 1, 1, 1, 1, '2019-09-23 10:47:16'),
(228, 32, 'Doctor OPD Charges', 'doctor_opd_charges', 1, 1, 1, 1, '2019-09-23 10:50:26'),
(229, 18, 'Staff Import', 'staff_import', 1, 0, 0, 0, '2019-09-23 10:51:39'),
(236, 36, 'Patient', 'patient', 1, 1, 1, 1, '2019-09-23 11:55:35'),
(237, 36, 'Enabled/Disabled', 'enabled_disabled', 1, 0, 0, 0, '2019-09-23 11:55:35'),
(238, 22, 'Notification Center', 'notification_center', 1, 0, 0, 0, '2019-09-24 09:18:33'),
(239, 36, 'Import', 'patient_import', 1, 0, 0, 0, '2019-10-04 06:50:26'),
(240, 34, 'Birth Print Header Footer', 'birth_print_header_footer', 1, 1, 1, 1, '2019-10-04 08:14:01'),
(241, 34, 'Custom Fields', 'birth_death_customfields', 1, 1, 1, 1, '2019-10-04 06:53:55'),
(242, 34, 'Death Print Header Footer', 'death_print_header_footer', 1, 1, 1, 1, '2019-10-04 08:13:56'),
(243, 26, 'Print Header Footer', 'pathology_print_header_footer', 1, 1, 1, 1, '2019-10-04 07:06:15'),
(244, 27, 'Print Header Footer', 'radiology_print_header_footer', 1, 1, 1, 1, '2019-10-04 07:10:01'),
(245, 28, 'Print Header Footer', 'ot_print_header_footer', 1, 1, 1, 1, '2019-10-04 07:11:15'),
(246, 30, 'Print Header Footer', 'bloodbank_print_header_footer', 1, 1, 1, 1, '2019-10-04 08:17:17'),
(247, 29, 'Print Header Footer', 'ambulance_print_header_footer', 1, 1, 1, 1, '2019-10-04 07:15:03'),
(248, 24, 'IPD Bill Print Header Footer', 'ipd_bill_print_header_footer', 1, 1, 1, 1, '2019-10-04 07:43:28'),
(249, 18, 'Print Payslip Header Footer', 'print_payslip_header_footer', 1, 1, 1, 1, '2019-10-04 08:01:33'),
(250, 14, 'Income Group Report', 'income_group_report\r\n', 1, 0, 0, 0, '2019-10-04 09:35:55'),
(251, 14, 'Expense Group Report', 'expense_group_report', 1, 0, 0, 0, '2019-10-04 09:45:56'),
(252, 3, 'Search Income', 'search_income', 1, 0, 0, 0, '2019-10-04 09:47:12'),
(253, 14, 'Inventory Stock Report', 'inventory_stock_report', 1, 0, 0, 0, '2019-10-04 10:50:31'),
(254, 14, 'Inventory Item Report', 'add_item_report', 1, 0, 0, 0, '2019-10-04 10:53:22'),
(255, 14, 'Inventory Issue Report', 'issue_inventory_report', 1, 0, 0, 0, '2019-10-04 10:54:40'),
(256, 14, 'Expiry Medicine Report', 'expiry_medicine_report', 1, 0, 0, 0, '2019-10-04 11:30:11'),
(257, 26, 'Pathology Bill', 'pathology bill', 1, 1, 1, 1, '2018-12-22 14:16:42'),
(258, 14, 'Birth Report', 'birth_report', 1, 0, 0, 0, '2019-10-14 08:42:35'),
(259, 14, 'Death Report', 'death_report', 1, 0, 0, 0, '2019-10-14 08:43:56');

--
-- Dumping data for table `permission_group`
--

INSERT INTO `permission_group` (`id`, `name`, `short_code`, `is_active`, `system`, `sort_order`, `created_at`) VALUES
(3, 'Income', 'income', 1, 0, '9.00', '2018-12-23 16:26:51'),
(4, 'Expense', 'expense', 1, 0, '10.00', '2018-12-18 10:20:47'),
(8, 'Download Center', 'download_center', 1, 0, '15.00', '2018-12-18 10:23:12'),
(10, 'Inventory', 'inventory', 1, 0, '16.00', '2018-12-18 10:23:27'),
(13, 'Messaging', 'communicate', 1, 0, '14.00', '2018-12-18 10:22:54'),
(14, 'Reports', 'reports', 1, 1, '19.00', '2018-12-18 10:24:41'),
(15, 'System Settings', 'system_settings', 1, 1, '18.00', '2018-12-18 10:24:23'),
(16, 'Front CMS', 'front_cms', 1, 0, '17.00', '2018-12-18 10:23:47'),
(17, 'Front Office', 'front_office', 1, 0, '12.00', '2018-12-18 10:21:58'),
(18, 'Human Resource', 'human_resource', 1, 1, '13.00', '2018-12-18 10:22:37'),
(21, 'Calendar To Do List', 'calendar_to_do_list', 1, 0, '22.00', '2019-10-04 07:26:23'),
(22, 'Dashboard and Widgets', 'dashboard_and_widgets', 1, 1, '20.00', '2018-12-18 10:24:51'),
(23, 'OPD', 'OPD', 1, 0, '1.00', '2019-07-25 12:49:15'),
(24, 'IPD', 'IPD', 1, 0, '2.00', '2018-12-18 09:53:13'),
(25, 'Pharmacy', 'pharmacy', 1, 0, '3.00', '2018-12-18 10:02:51'),
(26, 'Pathology', 'pathology', 1, 0, '4.00', '2018-12-18 10:02:56'),
(27, 'Radiology', 'radiology', 1, 0, '5.00', '2018-12-18 10:03:00'),
(28, 'Operation Theatre', 'operation_theatre', 1, 0, '6.00', '2018-12-18 10:03:05'),
(29, 'Ambulance', 'ambulance', 1, 0, '11.00', '2018-12-18 10:20:57'),
(30, 'Blood Bank', 'blood_bank', 1, 0, '7.00', '2018-12-18 10:19:14'),
(31, 'TPA Management', 'tpa_management', 1, 0, '8.00', '2018-12-18 10:19:39'),
(32, 'Hospital Charges', 'hospital_charges', 1, 1, '10.10', '2019-03-10 07:08:22'),
(34, 'Birth Death Record', 'birth_death_report', 1, 0, '12.00', '2019-10-04 07:18:39'),
(36, 'Patient', 'patient', 1, 0, '21.00', '2019-10-04 07:26:19');

--
-- Dumping data for table `roles_permissions`
--

INSERT INTO `roles_permissions` (`id`, `role_id`, `perm_cat_id`, `can_view`, `can_add`, `can_edit`, `can_delete`, `created_at`) VALUES
(1, 1, 132, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(3, 1, 134, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(4, 1, 135, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(5, 1, 136, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(6, 1, 137, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(7, 1, 192, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(8, 1, 138, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(9, 1, 139, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(10, 1, 140, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(11, 1, 141, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(12, 1, 142, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(13, 1, 143, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(14, 1, 144, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(15, 1, 145, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(16, 1, 193, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(17, 1, 194, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(18, 1, 195, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(19, 1, 196, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(20, 1, 197, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(21, 1, 198, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(22, 1, 146, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(23, 1, 147, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(24, 1, 148, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(25, 1, 170, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(26, 1, 200, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(27, 1, 201, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(28, 1, 149, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(29, 1, 150, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(30, 1, 175, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(31, 1, 152, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(32, 1, 153, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(33, 1, 171, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(34, 1, 163, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(35, 1, 164, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(36, 1, 167, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(37, 1, 168, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(38, 1, 169, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(39, 1, 202, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(40, 1, 173, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(41, 1, 174, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(42, 1, 9, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(43, 1, 10, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(45, 1, 176, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(46, 1, 203, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(47, 1, 12, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(48, 1, 13, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(49, 1, 14, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(50, 1, 165, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(51, 1, 166, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(52, 1, 80, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(53, 1, 81, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(54, 1, 82, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(55, 1, 83, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(56, 1, 84, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(57, 1, 85, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(58, 1, 204, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(59, 1, 205, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(60, 1, 86, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(61, 1, 87, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(62, 1, 88, 1, 1, 1, 0, '2019-03-09 17:26:01'),
(63, 1, 89, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(64, 1, 90, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(65, 1, 91, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(66, 1, 108, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(67, 1, 109, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(68, 1, 110, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(69, 1, 111, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(70, 1, 112, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(71, 1, 127, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(72, 1, 129, 0, 1, 0, 1, '2019-03-09 17:26:01'),
(73, 1, 43, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(74, 1, 44, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(75, 1, 46, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(76, 1, 27, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(77, 1, 31, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(78, 1, 32, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(79, 1, 33, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(80, 1, 34, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(81, 1, 35, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(82, 1, 104, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(83, 1, 61, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(84, 1, 62, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(85, 1, 63, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(86, 1, 64, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(87, 1, 65, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(88, 1, 66, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(89, 1, 67, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(90, 1, 53, 0, 1, 0, 0, '2019-03-09 17:26:01'),
(91, 1, 54, 1, 0, 1, 0, '2019-03-09 17:26:01'),
(92, 1, 56, 1, 0, 1, 0, '2019-03-09 17:26:01'),
(93, 1, 57, 1, 0, 1, 0, '2019-03-09 17:26:01'),
(94, 1, 58, 1, 0, 1, 0, '2019-03-09 17:26:01'),
(95, 1, 59, 1, 0, 1, 0, '2019-03-09 17:26:01'),
(96, 1, 60, 1, 0, 1, 0, '2019-03-09 17:26:01'),
(97, 1, 126, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(98, 1, 130, 1, 1, 0, 1, '2019-03-09 17:26:01'),
(99, 1, 131, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(100, 1, 48, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(101, 1, 178, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(102, 1, 179, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(103, 1, 180, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(104, 1, 181, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(105, 1, 182, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(106, 1, 183, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(107, 1, 184, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(108, 1, 185, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(109, 1, 186, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(110, 1, 187, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(111, 1, 188, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(112, 1, 189, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(113, 1, 206, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(114, 1, 207, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(115, 1, 208, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(116, 1, 209, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(117, 1, 210, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(118, 1, 211, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(119, 1, 212, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(120, 1, 213, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(121, 1, 118, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(122, 1, 155, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(123, 1, 156, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(124, 1, 157, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(125, 1, 158, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(126, 1, 159, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(127, 1, 160, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(128, 1, 161, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(129, 1, 162, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(130, 1, 190, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(131, 1, 191, 1, 0, 0, 0, '2019-03-09 17:26:01'),
(132, 1, 102, 1, 1, 1, 1, '2019-03-09 17:26:01'),
(133, 2, 132, 1, 1, 1, 0, '2019-03-09 17:43:21'),
(134, 2, 135, 1, 1, 1, 0, '2019-03-09 17:43:21'),
(135, 2, 138, 1, 1, 1, 0, '2019-03-09 17:43:21'),
(136, 2, 139, 1, 1, 1, 0, '2019-03-09 17:43:21'),
(137, 2, 143, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(138, 2, 144, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(139, 2, 145, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(140, 2, 193, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(141, 2, 194, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(142, 2, 195, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(143, 2, 196, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(144, 2, 198, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(145, 2, 148, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(146, 2, 149, 1, 0, 0, 0, '2019-10-14 10:52:30'),
(147, 2, 150, 1, 0, 0, 0, '2019-10-14 10:52:30'),
(148, 2, 152, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(149, 2, 153, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(150, 2, 163, 1, 1, 1, 0, '2019-03-09 17:43:21'),
(151, 2, 167, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(152, 2, 168, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(153, 2, 173, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(154, 2, 174, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(155, 2, 9, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(156, 2, 10, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(158, 2, 176, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(159, 2, 203, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(160, 2, 12, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(161, 2, 13, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(162, 2, 14, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(163, 2, 165, 1, 1, 1, 0, '2019-03-09 17:43:21'),
(164, 2, 166, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(165, 2, 204, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(166, 2, 205, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(167, 2, 86, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(168, 2, 87, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(169, 2, 88, 1, 1, 1, 0, '2019-03-09 17:43:21'),
(170, 2, 89, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(171, 2, 90, 1, 1, 0, 1, '2019-03-09 17:43:21'),
(172, 2, 91, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(173, 2, 108, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(174, 2, 109, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(175, 2, 110, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(176, 2, 111, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(177, 2, 112, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(178, 2, 127, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(179, 2, 129, 0, 1, 0, 1, '2019-03-09 17:43:21'),
(180, 2, 43, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(181, 2, 44, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(182, 2, 46, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(183, 2, 27, 1, 1, 0, 1, '2019-03-09 17:43:21'),
(184, 2, 31, 1, 1, 0, 1, '2019-03-09 17:43:21'),
(185, 2, 32, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(186, 2, 33, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(187, 2, 34, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(188, 2, 35, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(189, 2, 104, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(190, 2, 48, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(191, 2, 178, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(192, 2, 179, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(193, 2, 180, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(194, 2, 181, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(195, 2, 182, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(196, 2, 184, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(197, 2, 185, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(198, 2, 186, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(199, 2, 188, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(200, 2, 189, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(201, 2, 206, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(202, 2, 207, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(203, 2, 208, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(204, 2, 209, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(205, 2, 210, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(206, 2, 211, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(207, 2, 212, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(208, 2, 213, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(209, 2, 118, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(210, 2, 155, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(211, 2, 156, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(212, 2, 157, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(213, 2, 158, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(214, 2, 159, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(215, 2, 160, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(216, 2, 161, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(217, 2, 162, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(218, 2, 190, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(219, 2, 191, 1, 0, 0, 0, '2019-03-09 17:43:21'),
(220, 2, 102, 1, 1, 1, 1, '2019-03-09 17:43:21'),
(221, 3, 132, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(222, 3, 134, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(223, 3, 135, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(224, 3, 136, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(225, 3, 137, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(226, 3, 138, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(227, 3, 139, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(228, 3, 140, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(229, 3, 141, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(230, 3, 142, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(231, 3, 143, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(232, 3, 144, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(233, 3, 145, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(234, 3, 194, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(235, 3, 198, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(236, 3, 163, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(237, 3, 164, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(238, 3, 167, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(239, 3, 166, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(240, 3, 204, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(241, 3, 205, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(242, 3, 86, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(243, 3, 109, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(244, 3, 127, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(245, 3, 43, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(246, 3, 44, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(248, 3, 27, 1, 1, 0, 1, '2019-03-10 07:17:01'),
(249, 3, 48, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(250, 3, 178, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(251, 3, 182, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(253, 3, 208, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(254, 3, 209, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(255, 3, 118, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(256, 3, 155, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(257, 3, 156, 1, 0, 0, 0, '2019-03-10 07:17:01'),
(262, 3, 102, 1, 1, 1, 1, '2019-03-10 07:17:01'),
(263, 4, 146, 1, 1, 1, 1, '2019-03-10 07:21:00'),
(264, 4, 147, 1, 1, 1, 1, '2019-03-10 07:21:00'),
(265, 4, 148, 1, 1, 1, 1, '2019-10-12 11:04:19'),
(266, 4, 170, 1, 1, 1, 1, '2019-03-10 07:21:00'),
(267, 4, 200, 1, 1, 0, 1, '2019-03-10 07:21:00'),
(268, 4, 86, 1, 0, 0, 0, '2019-03-10 07:21:00'),
(269, 4, 43, 1, 1, 1, 1, '2019-03-10 07:21:00'),
(270, 4, 44, 1, 0, 0, 0, '2019-03-10 07:21:00'),
(272, 4, 27, 1, 1, 0, 1, '2019-03-10 07:21:00'),
(273, 4, 179, 1, 0, 0, 0, '2019-03-10 07:21:00'),
(274, 4, 118, 1, 0, 0, 0, '2019-03-10 07:21:00'),
(275, 4, 157, 1, 0, 0, 0, '2019-03-10 07:21:00'),
(276, 4, 102, 1, 1, 1, 1, '2019-03-10 07:21:00'),
(277, 5, 149, 1, 1, 1, 1, '2019-03-10 07:23:30'),
(278, 5, 150, 1, 1, 1, 1, '2019-03-10 07:23:30'),
(279, 5, 175, 1, 1, 1, 1, '2019-03-10 07:23:30'),
(280, 5, 86, 1, 0, 0, 0, '2019-03-10 07:23:30'),
(281, 5, 109, 1, 1, 1, 1, '2019-03-10 07:23:30'),
(282, 5, 43, 1, 1, 1, 1, '2019-03-10 07:23:30'),
(283, 5, 44, 1, 0, 0, 0, '2019-03-10 07:23:30'),
(285, 5, 27, 1, 1, 0, 1, '2019-03-10 07:23:30'),
(286, 5, 180, 1, 0, 0, 0, '2019-03-10 07:23:30'),
(288, 5, 158, 1, 0, 0, 0, '2019-03-10 07:23:30'),
(289, 5, 102, 1, 1, 1, 1, '2019-03-10 07:23:30'),
(290, 6, 152, 1, 1, 1, 1, '2019-03-10 07:31:58'),
(291, 6, 153, 1, 1, 1, 1, '2019-03-10 07:31:58'),
(292, 6, 171, 1, 1, 1, 1, '2019-03-10 07:31:58'),
(293, 6, 86, 1, 0, 0, 0, '2019-03-10 07:31:58'),
(294, 6, 109, 1, 1, 1, 1, '2019-03-10 07:31:58'),
(295, 6, 181, 1, 0, 0, 0, '2019-03-10 07:31:58'),
(297, 6, 118, 1, 0, 0, 0, '2019-03-10 07:31:58'),
(298, 6, 159, 1, 0, 0, 0, '2019-03-10 07:31:58'),
(299, 6, 102, 1, 1, 1, 1, '2019-03-10 07:31:58'),
(300, 8, 132, 1, 1, 1, 1, '2019-03-10 07:38:46'),
(306, 8, 81, 1, 1, 1, 1, '2019-03-10 07:38:46'),
(324, 9, 214, 1, 1, 1, 1, '2019-09-24 05:57:58'),
(325, 9, 215, 1, 1, 1, 1, '2019-09-24 05:57:58'),
(326, 9, 132, 1, 1, 1, 1, '2019-09-24 08:09:37'),
(327, 9, 218, 1, 0, 0, 0, '2019-09-24 05:59:54'),
(338, 9, 135, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(339, 9, 219, 1, 0, 0, 0, '2019-09-24 06:10:21'),
(340, 9, 221, 1, 1, 1, 1, '2019-09-24 06:12:42'),
(341, 9, 222, 1, 1, 1, 1, '2019-09-24 06:15:14'),
(342, 9, 223, 1, 1, 1, 1, '2019-09-24 06:20:24'),
(343, 9, 220, 1, 1, 1, 1, '2019-09-24 06:36:30'),
(344, 9, 138, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(345, 9, 146, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(346, 9, 147, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(347, 9, 148, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(348, 9, 170, 1, 1, 1, 1, '2019-09-24 07:33:23'),
(349, 9, 200, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(350, 9, 201, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(351, 9, 224, 1, 0, 0, 0, '2019-09-24 06:37:17'),
(352, 9, 225, 1, 1, 1, 1, '2019-09-24 06:52:41'),
(353, 9, 226, 1, 1, 1, 1, '2019-09-24 07:32:07'),
(354, 9, 227, 1, 1, 1, 1, '2019-09-24 07:32:07'),
(355, 9, 54, 1, 0, 1, 0, '2019-09-24 09:26:31'),
(356, 9, 56, 1, 0, 1, 0, '2019-09-24 09:26:31'),
(357, 9, 57, 1, 0, 1, 0, '2019-09-24 09:26:31'),
(358, 9, 58, 1, 0, 1, 0, '2019-09-24 09:26:31'),
(359, 9, 59, 1, 0, 1, 0, '2019-09-24 09:26:31'),
(360, 9, 60, 1, 0, 1, 0, '2019-09-24 09:26:31'),
(361, 9, 126, 1, 0, 0, 0, '2019-09-24 07:10:42'),
(362, 9, 130, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(363, 9, 131, 1, 0, 0, 0, '2019-09-24 07:10:42'),
(364, 9, 174, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(367, 9, 14, 1, 0, 0, 0, '2019-09-24 07:56:25'),
(375, 9, 236, 1, 1, 1, 1, '2019-09-24 08:42:37'),
(376, 9, 237, 1, 0, 0, 0, '2019-09-24 08:42:37'),
(377, 9, 134, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(378, 9, 136, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(379, 9, 137, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(380, 9, 192, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(381, 9, 139, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(382, 9, 140, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(383, 9, 141, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(384, 9, 142, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(385, 9, 143, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(386, 9, 144, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(387, 9, 145, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(388, 9, 193, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(389, 9, 194, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(390, 9, 195, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(391, 9, 196, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(392, 9, 197, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(393, 9, 198, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(394, 9, 149, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(395, 9, 150, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(396, 9, 175, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(397, 9, 152, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(398, 9, 153, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(399, 9, 171, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(400, 9, 163, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(401, 9, 164, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(402, 9, 167, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(403, 9, 168, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(404, 9, 169, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(405, 9, 202, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(406, 9, 173, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(407, 9, 9, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(408, 9, 10, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(409, 9, 12, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(410, 9, 13, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(411, 9, 176, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(412, 9, 203, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(413, 9, 228, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(414, 9, 165, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(415, 9, 166, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(416, 9, 80, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(417, 9, 81, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(418, 9, 82, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(419, 9, 83, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(420, 9, 84, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(421, 9, 85, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(422, 9, 204, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(423, 9, 205, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(424, 9, 216, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(425, 9, 217, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(426, 9, 86, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(427, 9, 87, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(428, 9, 88, 1, 1, 1, 0, '2019-09-24 09:26:31'),
(429, 9, 89, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(430, 9, 90, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(431, 9, 91, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(432, 9, 108, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(433, 9, 109, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(434, 9, 110, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(435, 9, 111, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(436, 9, 112, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(437, 9, 127, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(438, 9, 129, 0, 1, 0, 1, '2019-09-24 09:26:31'),
(439, 9, 229, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(440, 9, 43, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(441, 9, 44, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(442, 9, 46, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(443, 9, 27, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(444, 9, 31, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(445, 9, 32, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(446, 9, 33, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(447, 9, 34, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(448, 9, 35, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(449, 9, 104, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(450, 9, 61, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(451, 9, 62, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(452, 9, 63, 1, 1, 0, 1, '2019-09-24 09:26:31'),
(453, 9, 64, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(454, 9, 65, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(455, 9, 66, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(456, 9, 67, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(457, 9, 53, 0, 1, 0, 0, '2019-09-24 09:26:31'),
(458, 9, 48, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(459, 9, 178, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(460, 9, 179, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(461, 9, 180, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(462, 9, 181, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(463, 9, 182, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(464, 9, 183, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(465, 9, 184, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(466, 9, 185, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(467, 9, 186, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(468, 9, 187, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(469, 9, 188, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(470, 9, 189, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(471, 9, 206, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(472, 9, 207, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(473, 9, 208, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(474, 9, 209, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(475, 9, 210, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(476, 9, 211, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(477, 9, 212, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(478, 9, 213, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(479, 9, 118, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(480, 9, 155, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(481, 9, 156, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(482, 9, 157, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(483, 9, 158, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(484, 9, 159, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(485, 9, 160, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(486, 9, 161, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(487, 9, 162, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(488, 9, 190, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(489, 9, 191, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(490, 9, 238, 1, 0, 0, 0, '2019-09-24 09:26:31'),
(491, 9, 102, 1, 1, 1, 1, '2019-09-24 09:26:31'),
(492, 8, 236, 1, 1, 1, 0, '2019-10-12 12:40:43'),
(493, 8, 146, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(495, 8, 138, 1, 1, 1, 1, '2019-10-04 06:35:20'),
(496, 8, 139, 1, 1, 1, 1, '2019-10-04 06:35:49'),
(500, 8, 143, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(501, 8, 144, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(502, 8, 145, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(504, 8, 194, 1, 0, 0, 0, '2019-10-04 06:36:51'),
(506, 8, 196, 1, 0, 1, 1, '2019-10-12 13:16:52'),
(508, 8, 198, 1, 0, 0, 0, '2019-10-04 06:36:51'),
(511, 8, 148, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(516, 8, 225, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(524, 4, 201, 1, 1, 1, 1, '2019-10-04 07:51:19'),
(525, 4, 197, 1, 1, 1, 1, '2019-10-04 07:52:12'),
(526, 4, 243, 1, 0, 0, 0, '2019-10-04 09:11:46'),
(527, 4, 244, 1, 0, 0, 0, '2019-10-04 09:12:02'),
(528, 4, 245, 1, 0, 0, 0, '2019-10-04 07:57:23'),
(530, 4, 249, 1, 1, 1, 1, '2019-10-04 08:02:34'),
(531, 9, 246, 0, 1, 1, 1, '2019-10-04 08:07:16'),
(533, 4, 247, 1, 0, 0, 0, '2019-10-04 08:08:38'),
(536, 4, 240, 1, 0, 0, 0, '2019-10-04 08:10:41'),
(537, 4, 242, 1, 1, 1, 1, '2019-10-04 10:10:41'),
(540, 3, 245, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(541, 9, 243, 1, 0, 0, 0, '2019-10-04 09:17:02'),
(542, 9, 243, 1, 0, 0, 0, '2019-10-04 09:17:02'),
(543, 9, 239, 1, 0, 0, 0, '2019-10-04 09:18:14'),
(544, 9, 239, 1, 0, 0, 0, '2019-10-04 09:18:14'),
(545, 9, 242, 0, 1, 0, 0, '2019-10-04 09:41:27'),
(546, 4, 214, 1, 0, 0, 0, '2019-10-04 09:50:36'),
(547, 4, 241, 1, 1, 1, 1, '2019-10-04 10:01:24'),
(548, 4, 215, 1, 0, 0, 0, '2019-10-04 09:51:09'),
(550, 4, 236, 1, 0, 0, 0, '2019-10-04 10:15:36'),
(571, 4, 256, 1, 0, 0, 0, '2019-10-04 11:36:02'),
(572, 4, 224, 1, 0, 0, 0, '2019-10-12 11:12:53'),
(573, 4, 225, 1, 1, 1, 1, '2019-10-12 12:09:04'),
(574, 4, 226, 1, 1, 1, 1, '2019-10-12 12:09:04'),
(575, 4, 227, 1, 1, 1, 1, '2019-10-12 12:09:04'),
(577, 4, 203, 1, 0, 0, 0, '2019-10-12 11:22:51'),
(578, 4, 176, 1, 0, 0, 0, '2019-10-12 11:25:06'),
(579, 4, 228, 1, 0, 0, 0, '2019-10-12 11:34:35'),
(580, 2, 221, 1, 1, 1, 1, '2019-10-12 11:56:04'),
(581, 2, 222, 1, 1, 1, 1, '2019-10-12 11:56:04'),
(582, 2, 223, 1, 1, 1, 1, '2019-10-12 11:56:04'),
(583, 2, 225, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(584, 2, 216, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(585, 2, 217, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(586, 2, 229, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(587, 2, 249, 1, 1, 1, 1, '2019-10-12 11:56:04'),
(588, 2, 250, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(589, 2, 251, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(590, 2, 253, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(591, 2, 254, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(592, 2, 255, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(593, 2, 256, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(594, 2, 238, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(595, 2, 236, 1, 1, 1, 0, '2019-10-12 11:56:04'),
(596, 2, 237, 1, 0, 0, 0, '2019-10-12 11:56:04'),
(597, 3, 192, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(598, 3, 218, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(599, 3, 219, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(600, 3, 221, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(601, 3, 222, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(602, 3, 223, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(603, 3, 193, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(604, 3, 195, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(605, 3, 196, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(606, 3, 197, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(607, 3, 220, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(608, 3, 248, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(609, 3, 146, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(610, 3, 149, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(611, 3, 152, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(612, 3, 173, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(613, 3, 174, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(614, 3, 176, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(615, 3, 228, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(616, 3, 165, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(617, 3, 214, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(618, 3, 215, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(619, 3, 216, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(620, 3, 217, 1, 0, 0, 0, '2019-10-12 12:02:53'),
(621, 3, 236, 1, 1, 1, 1, '2019-10-12 12:02:53'),
(622, 4, 109, 1, 1, 1, 1, '2019-10-12 12:09:04'),
(623, 5, 243, 1, 1, 1, 1, '2019-10-12 12:24:41'),
(624, 5, 236, 1, 0, 0, 0, '2019-10-12 12:24:41'),
(625, 6, 43, 1, 1, 1, 1, '2019-10-12 12:30:16'),
(626, 6, 44, 1, 0, 0, 0, '2019-10-12 12:30:16'),
(627, 6, 27, 1, 1, 0, 1, '2019-10-12 12:30:16'),
(628, 6, 236, 1, 0, 0, 0, '2019-10-12 12:30:16'),
(629, 8, 135, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(630, 8, 218, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(631, 8, 219, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(632, 8, 221, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(633, 8, 222, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(634, 8, 223, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(635, 8, 149, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(636, 8, 152, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(637, 8, 163, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(638, 8, 167, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(639, 8, 173, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(640, 8, 174, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(641, 8, 176, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(642, 8, 228, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(643, 8, 165, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(644, 8, 166, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(645, 8, 214, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(646, 8, 215, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(647, 8, 82, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(648, 8, 83, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(649, 8, 84, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(650, 8, 85, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(651, 8, 204, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(652, 8, 205, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(653, 8, 216, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(654, 8, 217, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(655, 8, 109, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(656, 8, 43, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(657, 8, 44, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(658, 8, 27, 1, 1, 0, 1, '2019-10-12 12:40:43'),
(659, 8, 31, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(660, 8, 32, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(661, 8, 33, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(662, 8, 48, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(663, 8, 178, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(664, 8, 180, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(665, 8, 181, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(666, 8, 186, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(667, 8, 207, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(668, 8, 208, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(669, 8, 209, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(670, 8, 253, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(671, 8, 254, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(672, 8, 255, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(673, 8, 118, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(674, 8, 238, 1, 0, 0, 0, '2019-10-12 12:40:43'),
(675, 8, 102, 1, 1, 1, 1, '2019-10-12 12:40:43'),
(676, 5, 176, 1, 0, 0, 0, '2019-10-12 13:10:30'),
(677, 6, 176, 1, 0, 0, 0, '2019-10-12 13:12:51'),
(678, 8, 86, 1, 0, 0, 0, '2019-10-12 13:16:52'),
(679, 8, 182, 1, 0, 0, 0, '2019-10-12 13:16:52'),
(680, 2, 147, 1, 0, 0, 0, '2019-10-14 09:34:51'),
(681, 2, 200, 1, 0, 0, 0, '2019-10-14 09:34:51'),
(682, 2, 164, 1, 0, 0, 0, '2019-10-14 09:36:36'),
(683, 2, 146, 1, 0, 0, 0, '2019-10-14 09:39:47'),
(686, 1, 218, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(687, 1, 219, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(688, 1, 221, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(689, 1, 222, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(690, 1, 223, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(691, 1, 220, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(692, 1, 248, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(693, 1, 224, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(694, 1, 225, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(695, 1, 226, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(696, 1, 227, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(697, 1, 243, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(698, 1, 257, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(699, 1, 244, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(700, 1, 245, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(701, 1, 246, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(702, 1, 252, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(703, 1, 228, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(704, 1, 247, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(705, 1, 214, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(706, 1, 215, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(707, 1, 240, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(708, 1, 241, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(709, 1, 242, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(710, 1, 216, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(711, 1, 217, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(712, 1, 229, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(713, 1, 249, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(714, 1, 250, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(715, 1, 251, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(716, 1, 253, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(717, 1, 254, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(718, 1, 255, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(719, 1, 256, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(720, 1, 258, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(721, 1, 259, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(722, 1, 238, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(723, 1, 236, 1, 1, 1, 1, '2019-10-14 15:04:38'),
(724, 1, 237, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(725, 1, 239, 1, 0, 0, 0, '2019-10-14 15:04:38'),
(726, 8, 164, 1, 0, 0, 0, '2019-10-15 05:10:15'),
(727, 8, 147, 1, 0, 0, 0, '2019-10-15 05:28:08'),
(728, 8, 200, 1, 0, 0, 0, '2019-10-15 05:28:08');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

--
-- table `operation_theatre`
--
ALTER TABLE operation_theatre
MODIFY date datetime;

ALTER TABLE operation_theatre
ADD height varchar(255);

ALTER TABLE operation_theatre
ADD weight varchar(255);

ALTER TABLE operation_theatre
ADD bp varchar(255);

ALTER TABLE operation_theatre
ADD symptoms varchar(255);


--
-- table `medicine_batch_details`
--
ALTER TABLE medicine_batch_details
MODIFY inward_date datetime;
