CREATE TABLE `users_authentication` (
  `id` int primary key auto_increment,
  `users_id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `expired_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE students
  DROP COLUMN batch_id;

ALTER TABLE students
ADD COLUMN `parent_app_key` text AFTER app_key;

ALTER TABLE class_teacher
ADD `session_id` int(11) NOT NULL;

ALTER TABLE fees_reminder
MODIFY COLUMN `updated_at` date DEFAULT NULL;

ALTER TABLE staff_attendance
MODIFY COLUMN `updated_at` date DEFAULT NULL;

ALTER TABLE item
MODIFY COLUMN `updated_at` date DEFAULT NULL;

ALTER TABLE visitors_book
MODIFY COLUMN `purpose` varchar(255) NOT NULL;


ALTER TABLE sch_settings
ADD COLUMN mobile_api_url TEXT(20) NOT NULL AFTER staff_upload_documents,
ADD COLUMN app_primary_color_code VARCHAR(20) DEFAULT '#424242' AFTER mobile_api_url,
ADD COLUMN app_secondary_color_code VARCHAR(20) DEFAULT '#eeeeee' AFTER app_primary_color_code,
ADD COLUMN app_logo VARCHAR(250) DEFAULT '1.png' AFTER app_secondary_color_code;


drop table `student_transport_fees_delete`;
drop table `student_subject_groups`;
drop table `question`;
drop table `delete_chat`;


ALTER TABLE `class_batch_subjects`
  DROP FOREIGN KEY class_batch_subjects_ibfk_1,
  DROP FOREIGN KEY class_batch_subjects_ibfk_2,
  DROP KEY class_batch_id,
  DROP KEY subject_id;




ALTER TABLE `exam_group_class_batch_exam_subjects`
  DROP FOREIGN KEY exam_group_class_batch_exam_subjects_ibfk_2,
  DROP KEY class_batch_subject_id,
  DROP class_batch_subject_id;


ALTER TABLE `exam_group_class_batch_exams`
  DROP FOREIGN KEY exam_group_class_batch_exams_ibfk_2,
  DROP KEY class_batch_id,
  DROP class_batch_id;




ALTER TABLE `class_batches`
  DROP FOREIGN KEY `class_batches_ibfk_1`,
  DROP FOREIGN KEY `class_batches_ibfk_2`,
  DROP KEY  `class_section_id`,
  DROP KEY `batch_id`;

    
drop table `class_batch_subjects`;
drop table `class_batches`;
drop table `batch`;



ALTER TABLE exam_group_class_batch_exam_students
MODIFY COLUMN `roll_no` int(6) NOT NULL DEFAULT 0;

ALTER TABLE notification_setting
ADD COLUMN `is_notification` int(11) NOT NULL DEFAULT 0 AFTER `is_sms`,
ADD COLUMN `display_notification` int(11) NOT NULL DEFAULT 0 AFTER `is_notification`;


CREATE TABLE `print_headerfooter` (
  `id` int primary key auto_increment,
  `print_type` varchar(255) NOT NULL,
  `header_image` varchar(255) NOT NULL,
  `footer_content` text NOT NULL,
  `created_by` int(11) NOT NULL,
  `entry_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `print_headerfooter` (`id`, `print_type`, `header_image`, `footer_content`, `created_by`, `entry_date`) VALUES
(1, 'staff_payslip', 'header_image.jpg', 'This payslip is computer generated hence no signature is required.', 1, '2020-02-08 08:34:08'),
(2, 'student_receipt', 'header_image.jpg', 'This receipt is computer generated hence no signature is required.', 1, '2020-02-04 09:45:41');

truncate table `permission_group`;

INSERT INTO `permission_group` (`id`, `name`, `short_code`, `is_active`, `system`, `created_at`) VALUES
(1, 'Student Information', 'student_information', 1, 1, '2019-03-15 15:00:22'),
(2, 'Fees Collection', 'fees_collection', 1, 0, '2019-12-01 14:08:13'),
(3, 'Income', 'income', 1, 0, '2019-03-15 14:36:20'),
(4, 'Expense', 'expense', 1, 0, '2019-03-15 14:36:22'),
(5, 'Student Attendance', 'student_attendance', 1, 0, '2018-07-02 13:18:08'),
(6, 'Examination', 'examination', 1, 0, '2018-07-11 08:19:08'),
(7, 'Academics', 'academics', 1, 1, '2018-07-02 12:55:43'),
(8, 'Download Center', 'download_center', 1, 0, '2018-07-02 13:19:29'),
(9, 'Library', 'library', 1, 0, '2018-06-28 16:43:14'),
(10, 'Inventory', 'inventory', 1, 0, '2018-06-27 06:18:58'),
(11, 'Transport', 'transport', 1, 0, '2018-06-27 13:21:26'),
(12, 'Hostel', 'hostel', 1, 0, '2018-07-02 13:19:32'),
(13, 'Communicate', 'communicate', 1, 0, '2018-07-02 13:20:00'),
(14, 'Reports', 'reports', 1, 1, '2018-06-27 09:10:22'),
(15, 'System Settings', 'system_settings', 1, 1, '2018-06-27 09:10:28'),
(16, 'Front CMS', 'front_cms', 1, 0, '2018-07-10 10:46:54'),
(17, 'Front Office', 'front_office', 1, 0, '2018-06-27 09:15:30'),
(18, 'Human Resource', 'human_resource', 1, 1, '2018-06-27 09:11:02'),
(19, 'Homework', 'homework', 1, 0, '2018-06-27 06:19:38'),
(20, 'Certificate', 'certificate', 1, 0, '2018-06-27 13:21:29'),
(21, 'Calendar To Do List', 'calendar_to_do_list', 1, 0, '2019-03-15 14:36:25'),
(22, 'Dashboard and Widgets', 'dashboard_and_widgets', 1, 1, '2018-06-27 09:11:17'),
(23, 'Online Examination', 'online_examination', 1, 0, '2019-11-24 05:24:02'),
(25, 'Chat', 'chat', 1, 0, '2019-11-24 05:24:04'),
(26, 'Multi Class', 'multi_class', 1, 0, '2019-11-27 17:44:14'),
(27, 'Online Admission', 'online_admission', 1, 0, '2019-11-27 08:12:13');

truncate table roles_permissions;


INSERT INTO `roles_permissions` (`id`, `role_id`, `perm_cat_id`, `can_view`, `can_add`, `can_edit`, `can_delete`, `created_at`) VALUES
(10, 1, 17, 1, 1, 1, 1, '2018-07-06 15:18:56'),
(11, 1, 78, 1, 1, 1, 1, '2018-07-03 06:19:43'),
(23, 1, 12, 1, 1, 1, 1, '2018-07-06 15:15:38'),
(24, 1, 13, 1, 1, 1, 1, '2018-07-06 15:18:28'),
(26, 1, 15, 1, 1, 1, 0, '2019-11-28 05:17:28'),
(28, 1, 19, 1, 1, 1, 0, '2018-07-02 17:01:10'),
(30, 1, 76, 1, 1, 1, 0, '2018-07-02 17:01:10'),
(31, 1, 21, 1, 0, 1, 0, '2019-11-26 10:21:15'),
(32, 1, 22, 1, 1, 1, 1, '2018-07-02 17:02:05'),
(34, 1, 24, 1, 1, 1, 1, '2019-11-28 12:05:20'),
(43, 1, 32, 1, 1, 1, 1, '2018-07-06 15:52:05'),
(44, 1, 33, 1, 1, 1, 1, '2018-07-06 15:52:29'),
(45, 1, 34, 1, 1, 1, 1, '2018-07-06 15:53:59'),
(46, 1, 35, 1, 1, 1, 1, '2018-07-06 15:54:34'),
(47, 1, 104, 1, 1, 1, 1, '2018-07-06 15:53:08'),
(48, 1, 37, 1, 1, 1, 1, '2018-07-06 15:55:30'),
(49, 1, 38, 1, 1, 1, 1, '2018-07-09 10:45:27'),
(58, 1, 52, 1, 1, 0, 1, '2018-07-09 08:49:43'),
(61, 1, 55, 1, 1, 1, 1, '2018-07-02 14:54:16'),
(67, 1, 61, 1, 1, 0, 1, '2018-07-09 11:29:19'),
(68, 1, 62, 1, 1, 0, 1, '2018-07-09 11:29:19'),
(69, 1, 63, 1, 1, 0, 1, '2018-07-09 09:21:38'),
(70, 1, 64, 1, 1, 1, 1, '2018-07-09 08:32:19'),
(71, 1, 65, 1, 1, 1, 1, '2018-07-09 08:41:21'),
(72, 1, 66, 1, 1, 1, 1, '2018-07-09 08:43:09'),
(73, 1, 67, 1, 1, 1, 1, '2018-07-09 08:44:47'),
(74, 1, 79, 1, 1, 0, 1, '2019-11-30 07:02:51'),
(75, 1, 80, 1, 1, 1, 1, '2018-07-06 15:11:23'),
(76, 1, 81, 1, 1, 1, 1, '2018-07-06 15:11:23'),
(78, 1, 83, 1, 1, 1, 1, '2018-07-06 15:11:23'),
(79, 1, 84, 1, 1, 1, 1, '2018-07-06 15:11:23'),
(80, 1, 85, 1, 1, 1, 1, '2018-07-12 05:46:00'),
(87, 1, 92, 1, 1, 1, 1, '2018-06-26 09:03:43'),
(94, 1, 82, 1, 1, 1, 1, '2018-07-06 15:11:23'),
(120, 1, 39, 1, 1, 1, 1, '2018-07-06 15:56:28'),
(156, 1, 9, 1, 1, 1, 1, '2019-11-28 05:15:46'),
(157, 1, 10, 1, 1, 1, 1, '2019-11-28 05:15:46'),
(159, 1, 40, 1, 1, 1, 1, '2019-11-30 06:19:39'),
(160, 1, 41, 1, 1, 1, 1, '2019-12-02 11:13:41'),
(161, 1, 42, 1, 1, 1, 1, '2019-11-30 06:19:39'),
(169, 1, 27, 1, 1, 0, 1, '2019-11-29 11:45:37'),
(178, 1, 54, 1, 0, 1, 0, '2018-07-05 14:39:22'),
(179, 1, 56, 1, 0, 1, 0, '2019-11-30 06:19:54'),
(180, 1, 57, 1, 0, 1, 0, '2019-11-30 07:02:51'),
(181, 1, 58, 1, 0, 1, 0, '2019-11-30 07:02:51'),
(182, 1, 59, 1, 0, 1, 0, '2019-11-30 07:02:51'),
(183, 1, 60, 1, 0, 1, 0, '2019-11-30 06:29:57'),
(190, 1, 105, 1, 0, 0, 0, '2018-07-02 16:43:25'),
(199, 1, 75, 1, 0, 0, 0, '2018-07-02 16:49:46'),
(201, 1, 14, 1, 0, 0, 0, '2018-07-02 16:52:03'),
(203, 1, 16, 1, 0, 0, 0, '2018-07-02 16:54:21'),
(204, 1, 26, 1, 0, 0, 0, '2018-07-02 17:02:05'),
(206, 1, 29, 1, 0, 0, 0, '2018-07-02 17:13:54'),
(207, 1, 30, 1, 0, 0, 0, '2018-07-02 17:13:54'),
(208, 1, 31, 1, 1, 1, 1, '2019-11-30 07:02:51'),
(215, 1, 50, 1, 0, 0, 0, '2018-07-02 17:34:53'),
(216, 1, 51, 1, 0, 0, 0, '2018-07-02 17:34:53'),
(222, 1, 1, 1, 1, 1, 1, '2019-11-28 04:25:06'),
(227, 1, 91, 1, 0, 0, 0, '2018-07-03 07:19:27'),
(230, 10, 53, 0, 1, 0, 0, '2018-07-03 09:22:55'),
(231, 10, 54, 0, 0, 1, 0, '2018-07-03 09:22:55'),
(232, 10, 55, 1, 1, 1, 1, '2018-07-03 09:28:42'),
(233, 10, 56, 0, 0, 1, 0, '2018-07-03 09:22:55'),
(235, 10, 58, 0, 0, 1, 0, '2018-07-03 09:22:55'),
(236, 10, 59, 0, 0, 1, 0, '2018-07-03 09:22:55'),
(239, 10, 1, 1, 1, 1, 1, '2018-07-03 09:46:43'),
(241, 10, 3, 1, 0, 0, 0, '2018-07-03 09:53:56'),
(242, 10, 2, 1, 0, 0, 0, '2018-07-03 09:54:39'),
(243, 10, 4, 1, 0, 1, 1, '2018-07-03 10:01:24'),
(245, 10, 107, 1, 0, 0, 0, '2018-07-03 10:06:41'),
(246, 10, 5, 1, 1, 0, 1, '2018-07-03 10:08:18'),
(247, 10, 7, 1, 1, 1, 1, '2018-07-03 10:12:07'),
(248, 10, 68, 1, 0, 0, 0, '2018-07-03 10:12:53'),
(249, 10, 69, 1, 1, 1, 1, '2018-07-03 10:19:46'),
(250, 10, 70, 1, 0, 0, 1, '2018-07-03 10:22:40'),
(251, 10, 72, 1, 0, 0, 0, '2018-07-03 10:26:46'),
(252, 10, 73, 1, 0, 0, 0, '2018-07-03 10:26:46'),
(253, 10, 74, 1, 0, 0, 0, '2018-07-03 10:28:34'),
(254, 10, 75, 1, 0, 0, 0, '2018-07-03 10:28:34'),
(255, 10, 9, 1, 1, 1, 1, '2018-07-03 10:32:22'),
(256, 10, 10, 1, 1, 1, 1, '2018-07-03 10:33:09'),
(257, 10, 11, 1, 0, 0, 0, '2018-07-03 10:33:09'),
(258, 10, 12, 1, 1, 1, 1, '2018-07-03 10:38:40'),
(259, 10, 13, 1, 1, 1, 1, '2018-07-03 10:38:40'),
(260, 10, 14, 1, 0, 0, 0, '2018-07-03 10:38:53'),
(261, 10, 15, 1, 1, 1, 0, '2018-07-03 10:41:28'),
(262, 10, 16, 1, 0, 0, 0, '2018-07-03 10:42:12'),
(263, 10, 17, 1, 1, 1, 1, '2018-07-03 10:44:30'),
(264, 10, 19, 1, 1, 1, 0, '2018-07-03 10:45:45'),
(265, 10, 20, 1, 1, 1, 1, '2018-07-03 10:48:51'),
(266, 10, 76, 1, 0, 0, 0, '2018-07-03 10:51:21'),
(267, 10, 21, 1, 1, 1, 0, '2018-07-03 10:52:45'),
(268, 10, 22, 1, 1, 1, 1, '2018-07-03 10:55:00'),
(269, 10, 23, 1, 1, 1, 1, '2018-07-03 10:57:16'),
(270, 10, 24, 1, 1, 1, 1, '2018-07-03 10:57:49'),
(271, 10, 25, 1, 1, 1, 1, '2018-07-03 10:57:49'),
(272, 10, 26, 1, 0, 0, 0, '2018-07-03 10:58:25'),
(273, 10, 77, 1, 1, 1, 1, '2018-07-03 10:59:57'),
(274, 10, 27, 1, 1, 0, 1, '2018-07-03 11:00:36'),
(275, 10, 28, 1, 1, 1, 1, '2018-07-03 11:03:09'),
(276, 10, 29, 1, 0, 0, 0, '2018-07-03 11:04:03'),
(277, 10, 30, 1, 0, 0, 0, '2018-07-03 11:04:03'),
(278, 10, 31, 1, 0, 0, 0, '2018-07-03 11:04:03'),
(279, 10, 32, 1, 1, 1, 1, '2018-07-03 11:05:42'),
(280, 10, 33, 1, 1, 1, 1, '2018-07-03 11:06:32'),
(281, 10, 34, 1, 1, 1, 1, '2018-07-03 11:08:03'),
(282, 10, 35, 1, 1, 1, 1, '2018-07-03 11:08:41'),
(283, 10, 104, 1, 1, 1, 1, '2018-07-03 11:10:43'),
(284, 10, 37, 1, 1, 1, 1, '2018-07-03 11:12:42'),
(285, 10, 38, 1, 1, 1, 1, '2018-07-03 11:13:56'),
(286, 10, 39, 1, 1, 1, 1, '2018-07-03 11:15:39'),
(287, 10, 40, 1, 1, 1, 1, '2018-07-03 11:17:22'),
(288, 10, 41, 1, 1, 1, 1, '2018-07-03 11:18:54'),
(289, 10, 42, 1, 1, 1, 1, '2018-07-03 11:19:31'),
(290, 10, 43, 1, 1, 1, 1, '2018-07-03 11:21:15'),
(291, 10, 44, 1, 0, 0, 0, '2018-07-03 11:22:06'),
(292, 10, 46, 1, 0, 0, 0, '2018-07-03 11:22:06'),
(293, 10, 50, 1, 0, 0, 0, '2018-07-03 11:22:59'),
(294, 10, 51, 1, 0, 0, 0, '2018-07-03 11:22:59'),
(295, 10, 60, 0, 0, 1, 0, '2018-07-03 11:25:05'),
(296, 10, 61, 1, 1, 1, 1, '2018-07-03 11:26:52'),
(297, 10, 62, 1, 1, 1, 1, '2018-07-03 11:28:53'),
(298, 10, 63, 1, 1, 0, 0, '2018-07-03 11:29:37'),
(299, 10, 64, 1, 1, 1, 1, '2018-07-03 11:30:27'),
(300, 10, 65, 1, 1, 1, 1, '2018-07-03 11:32:51'),
(301, 10, 66, 1, 1, 1, 1, '2018-07-03 11:32:51'),
(302, 10, 67, 1, 0, 0, 0, '2018-07-03 11:32:51'),
(303, 10, 78, 1, 1, 1, 1, '2018-07-04 09:40:04'),
(307, 1, 126, 1, 0, 0, 0, '2018-07-03 14:56:13'),
(310, 1, 119, 1, 0, 0, 0, '2018-07-03 15:45:00'),
(311, 1, 120, 1, 0, 0, 0, '2018-07-03 15:45:00'),
(315, 1, 123, 1, 0, 0, 0, '2018-07-03 15:57:03'),
(317, 1, 124, 1, 0, 0, 0, '2018-07-03 15:59:14'),
(320, 1, 47, 1, 0, 0, 0, '2018-07-03 16:31:12'),
(321, 1, 121, 1, 0, 0, 0, '2018-07-03 16:31:12'),
(369, 1, 102, 1, 1, 1, 1, '2019-12-02 10:32:15'),
(372, 10, 79, 1, 1, 0, 0, '2018-07-04 09:40:04'),
(373, 10, 80, 1, 1, 1, 1, '2018-07-04 09:53:09'),
(374, 10, 81, 1, 1, 1, 1, '2018-07-04 09:53:50'),
(375, 10, 82, 1, 1, 1, 1, '2018-07-04 09:56:54'),
(376, 10, 83, 1, 1, 1, 1, '2018-07-04 09:57:55'),
(377, 10, 84, 1, 1, 1, 1, '2018-07-04 10:00:26'),
(378, 10, 85, 1, 1, 1, 1, '2018-07-04 10:02:54'),
(379, 10, 86, 1, 1, 1, 1, '2018-07-04 10:16:18'),
(380, 10, 87, 1, 0, 0, 0, '2018-07-04 10:19:49'),
(381, 10, 88, 1, 1, 1, 0, '2018-07-04 10:21:20'),
(382, 10, 89, 1, 0, 0, 0, '2018-07-04 10:21:51'),
(383, 10, 90, 1, 1, 0, 1, '2018-07-04 10:25:01'),
(384, 10, 91, 1, 0, 0, 0, '2018-07-04 10:25:01'),
(385, 10, 108, 1, 1, 1, 1, '2018-07-04 10:27:46'),
(386, 10, 109, 1, 1, 1, 1, '2018-07-04 10:28:26'),
(387, 10, 110, 1, 1, 1, 1, '2018-07-04 10:32:43'),
(388, 10, 111, 1, 1, 1, 1, '2018-07-04 10:33:21'),
(389, 10, 112, 1, 1, 1, 1, '2018-07-04 10:35:06'),
(390, 10, 127, 1, 0, 0, 0, '2018-07-04 10:35:06'),
(391, 10, 93, 1, 1, 1, 1, '2018-07-04 10:37:14'),
(392, 10, 94, 1, 1, 0, 0, '2018-07-04 10:38:02'),
(394, 10, 95, 1, 0, 0, 0, '2018-07-04 10:38:44'),
(395, 10, 102, 1, 1, 1, 1, '2018-07-04 10:41:02'),
(396, 10, 106, 1, 0, 0, 0, '2018-07-04 10:41:39'),
(397, 10, 113, 1, 0, 0, 0, '2018-07-04 10:42:37'),
(398, 10, 114, 1, 0, 0, 0, '2018-07-04 10:42:37'),
(399, 10, 115, 1, 0, 0, 0, '2018-07-04 10:48:45'),
(400, 10, 116, 1, 0, 0, 0, '2018-07-04 10:48:45'),
(401, 10, 117, 1, 0, 0, 0, '2018-07-04 10:49:43'),
(402, 10, 118, 1, 0, 0, 0, '2018-07-04 10:49:43'),
(434, 1, 125, 1, 0, 0, 0, '2018-07-06 15:29:26'),
(435, 1, 96, 1, 1, 1, 1, '2018-07-09 06:33:54'),
(445, 1, 48, 1, 0, 0, 0, '2018-07-06 17:19:35'),
(446, 1, 49, 1, 0, 0, 0, '2018-07-06 17:19:35'),
(461, 1, 97, 1, 0, 0, 0, '2018-07-09 06:30:16'),
(462, 1, 95, 1, 0, 0, 0, '2018-07-09 06:48:41'),
(464, 1, 86, 1, 1, 1, 1, '2019-11-28 12:09:19'),
(474, 1, 130, 1, 1, 0, 1, '2018-07-09 16:26:36'),
(476, 1, 131, 1, 0, 0, 0, '2018-07-09 10:23:32'),
(479, 2, 47, 1, 0, 0, 0, '2018-07-10 12:17:12'),
(480, 2, 105, 1, 0, 0, 0, '2018-07-10 12:17:12'),
(482, 2, 119, 1, 0, 0, 0, '2018-07-10 12:17:12'),
(483, 2, 120, 1, 0, 0, 0, '2018-07-10 12:17:12'),
(486, 2, 16, 1, 0, 0, 0, '2018-07-10 12:17:12'),
(493, 2, 22, 1, 0, 0, 0, '2018-07-12 05:50:27'),
(504, 2, 95, 1, 0, 0, 0, '2018-07-10 12:17:12'),
(513, 3, 72, 1, 0, 0, 0, '2018-07-10 12:37:30'),
(517, 3, 75, 1, 0, 0, 0, '2018-07-10 12:40:38'),
(527, 3, 89, 1, 0, 0, 0, '2018-07-10 12:48:44'),
(529, 3, 91, 1, 0, 0, 0, '2018-07-10 12:48:44'),
(549, 3, 124, 1, 0, 0, 0, '2018-07-10 12:52:17'),
(557, 6, 82, 1, 1, 1, 1, '2019-12-01 07:18:28'),
(558, 6, 83, 1, 1, 1, 1, '2019-12-01 07:19:08'),
(559, 6, 84, 1, 1, 1, 1, '2019-12-01 07:19:59'),
(575, 6, 44, 1, 0, 0, 0, '2018-07-10 13:05:33'),
(576, 6, 46, 1, 0, 0, 0, '2018-07-10 13:05:33'),
(578, 6, 102, 1, 1, 1, 1, '2019-12-01 07:22:27'),
(594, 3, 125, 1, 0, 0, 0, '2018-07-10 13:28:12'),
(595, 3, 48, 1, 0, 0, 0, '2018-07-10 13:28:12'),
(596, 3, 49, 1, 0, 0, 0, '2018-07-10 13:28:12'),
(617, 2, 17, 1, 1, 1, 1, '2018-07-11 12:25:14'),
(618, 2, 19, 1, 1, 1, 0, '2018-07-11 12:25:14'),
(620, 2, 76, 1, 1, 1, 0, '2018-07-11 12:25:14'),
(622, 2, 121, 1, 0, 0, 0, '2018-07-11 12:26:27'),
(625, 1, 28, 1, 1, 1, 1, '2019-11-29 11:49:18'),
(628, 6, 22, 1, 0, 0, 0, '2018-07-12 05:53:47'),
(634, 4, 102, 1, 1, 1, 1, '2019-12-01 06:33:00'),
(662, 1, 138, 1, 0, 0, 0, '2019-11-01 07:58:24'),
(663, 1, 139, 1, 1, 1, 1, '2019-11-01 07:58:24'),
(664, 1, 140, 1, 1, 1, 1, '2019-11-01 07:58:24'),
(669, 1, 145, 1, 0, 0, 0, '2019-11-26 10:21:15'),
(677, 1, 153, 1, 0, 0, 0, '2019-11-01 07:58:24'),
(690, 1, 166, 1, 0, 0, 0, '2019-11-01 07:58:24'),
(691, 1, 167, 1, 0, 0, 0, '2019-11-01 07:58:24'),
(692, 1, 168, 1, 0, 0, 0, '2019-11-01 07:58:24'),
(693, 1, 170, 1, 0, 0, 0, '2019-11-01 07:58:24'),
(694, 1, 172, 1, 0, 0, 0, '2019-11-01 07:58:24'),
(695, 1, 173, 1, 0, 0, 0, '2019-11-01 07:58:24'),
(720, 1, 216, 1, 0, 0, 0, '2019-11-26 10:54:12'),
(728, 1, 185, 1, 1, 1, 1, '2019-11-28 08:20:33'),
(729, 1, 186, 1, 1, 1, 1, '2019-11-28 08:19:07'),
(730, 1, 214, 1, 0, 1, 0, '2019-11-28 07:17:53'),
(732, 1, 198, 1, 0, 0, 0, '2019-11-26 10:54:30'),
(733, 1, 199, 1, 0, 0, 0, '2019-11-26 10:54:30'),
(734, 1, 200, 1, 0, 0, 0, '2019-11-26 10:54:30'),
(735, 1, 201, 1, 0, 0, 0, '2019-11-26 10:54:30'),
(736, 1, 202, 1, 0, 0, 0, '2019-11-26 10:54:30'),
(737, 1, 203, 1, 0, 0, 0, '2019-11-26 10:54:30'),
(739, 1, 218, 1, 0, 0, 0, '2019-11-27 12:06:31'),
(743, 1, 218, 1, 0, 0, 0, '2019-11-27 12:06:32'),
(747, 1, 2, 1, 0, 0, 0, '2019-11-28 04:26:08'),
(748, 1, 3, 1, 1, 1, 1, '2019-11-28 04:26:32'),
(749, 1, 4, 1, 1, 1, 1, '2019-11-28 04:26:48'),
(751, 1, 128, 0, 1, 0, 1, '2019-11-28 04:27:01'),
(752, 1, 132, 1, 0, 1, 1, '2019-11-28 04:32:23'),
(754, 1, 134, 1, 1, 1, 1, '2019-11-28 04:48:21'),
(755, 1, 5, 1, 1, 0, 1, '2019-11-28 05:05:07'),
(756, 1, 6, 1, 0, 0, 0, '2019-11-28 05:05:25'),
(757, 1, 7, 1, 1, 1, 1, '2019-11-28 05:06:35'),
(758, 1, 8, 1, 1, 1, 1, '2019-11-28 05:07:27'),
(760, 1, 68, 1, 0, 0, 0, '2019-11-28 05:08:06'),
(761, 1, 69, 1, 1, 1, 1, '2019-11-28 05:09:06'),
(762, 1, 70, 1, 1, 1, 1, '2019-11-28 05:09:41'),
(763, 1, 71, 1, 0, 0, 0, '2019-11-28 05:09:59'),
(764, 1, 72, 1, 0, 0, 0, '2019-11-28 05:10:11'),
(765, 1, 73, 1, 0, 0, 0, '2019-11-28 05:13:15'),
(766, 1, 74, 1, 0, 0, 0, '2019-11-28 05:13:55'),
(768, 1, 11, 1, 0, 0, 0, '2019-11-28 05:15:46'),
(769, 1, 122, 1, 0, 0, 0, '2019-11-28 05:22:43'),
(771, 1, 136, 1, 0, 0, 0, '2019-11-28 05:25:36'),
(772, 1, 20, 1, 1, 1, 1, '2019-11-28 09:36:44'),
(773, 1, 137, 1, 1, 1, 1, '2019-11-28 06:16:14'),
(774, 1, 141, 1, 1, 1, 1, '2019-11-28 06:29:42'),
(775, 1, 142, 1, 0, 0, 0, '2019-11-28 05:26:12'),
(776, 1, 143, 1, 1, 1, 1, '2019-11-28 06:29:42'),
(777, 1, 144, 1, 0, 0, 0, '2019-11-28 05:26:12'),
(778, 1, 187, 1, 0, 0, 0, '2019-11-28 05:26:12'),
(779, 1, 196, 1, 0, 0, 0, '2019-11-28 05:26:12'),
(781, 1, 207, 1, 0, 0, 0, '2019-11-28 05:26:12'),
(782, 1, 208, 1, 0, 1, 0, '2019-11-28 05:40:22'),
(783, 1, 210, 1, 0, 1, 0, '2019-11-28 06:04:40'),
(784, 1, 211, 1, 0, 1, 0, '2019-11-28 06:08:23'),
(785, 1, 212, 1, 0, 1, 0, '2019-11-28 06:12:15'),
(786, 1, 205, 1, 1, 1, 1, '2019-11-28 06:12:15'),
(787, 1, 222, 1, 0, 1, 0, '2019-11-28 07:06:36'),
(788, 1, 77, 1, 1, 1, 1, '2019-11-28 11:52:10'),
(789, 1, 188, 1, 1, 1, 1, '2019-11-28 11:56:16'),
(790, 1, 23, 1, 1, 1, 1, '2019-11-28 12:04:20'),
(791, 1, 25, 1, 1, 1, 1, '2019-11-28 12:06:20'),
(792, 1, 127, 1, 0, 0, 0, '2019-11-28 12:11:25'),
(794, 1, 88, 1, 1, 1, 0, '2019-11-28 12:13:04'),
(795, 1, 90, 1, 1, 0, 1, '2019-11-28 12:16:22'),
(796, 1, 108, 1, 0, 1, 0, '2019-11-29 05:19:01'),
(797, 1, 109, 1, 1, 0, 0, '2019-11-29 05:08:11'),
(798, 1, 110, 1, 1, 1, 1, '2019-11-29 05:19:29'),
(799, 1, 111, 1, 1, 1, 1, '2019-11-29 05:19:57'),
(800, 1, 112, 1, 1, 1, 1, '2019-11-29 05:19:57'),
(801, 1, 129, 0, 1, 0, 1, '2019-11-29 05:19:57'),
(802, 1, 189, 1, 0, 1, 1, '2019-11-29 05:29:22'),
(806, 2, 133, 1, 0, 1, 0, '2019-11-29 06:04:35'),

(810, 2, 1, 1, 1, 1, 1, '2019-11-30 08:24:16'),
(813, 1, 133, 1, 0, 1, 0, '2019-11-29 06:09:57'),
(817, 1, 93, 1, 1, 1, 1, '2019-11-29 06:26:14'),
(825, 1, 87, 1, 0, 0, 0, '2019-11-29 06:26:14'),
(829, 1, 94, 1, 1, 0, 0, '2019-11-29 06:27:57'),
(836, 1, 146, 1, 0, 0, 0, '2019-11-29 06:43:28'),
(837, 1, 147, 1, 0, 0, 0, '2019-11-29 06:43:28'),
(838, 1, 148, 1, 0, 0, 0, '2019-11-29 06:43:28'),
(839, 1, 149, 1, 0, 0, 0, '2019-11-29 06:43:28'),
(840, 1, 150, 1, 0, 0, 0, '2019-11-29 06:43:28'),
(841, 1, 151, 1, 0, 0, 0, '2019-11-29 06:43:28'),
(842, 1, 152, 1, 0, 0, 0, '2019-11-29 06:43:28'),
(843, 1, 154, 1, 0, 0, 0, '2019-11-29 06:43:28'),
(862, 1, 155, 1, 0, 0, 0, '2019-11-29 07:37:30'),
(863, 1, 156, 1, 0, 0, 0, '2019-11-29 07:37:52'),
(864, 1, 157, 1, 0, 0, 0, '2019-11-29 07:38:05'),
(874, 1, 158, 1, 0, 0, 0, '2019-11-29 07:44:03'),
(875, 1, 159, 1, 0, 0, 0, '2019-11-29 07:44:31'),
(876, 1, 160, 1, 0, 0, 0, '2019-11-29 07:44:44'),
(878, 1, 162, 1, 0, 0, 0, '2019-11-29 07:45:58'),
(879, 1, 163, 1, 0, 0, 0, '2019-11-29 07:46:19'),
(882, 1, 164, 1, 0, 0, 0, '2019-11-29 07:55:17'),
(884, 1, 165, 1, 0, 0, 0, '2019-11-29 07:55:30'),
(886, 1, 197, 1, 0, 0, 0, '2019-11-29 07:55:48'),
(887, 1, 219, 1, 0, 0, 0, '2019-11-29 07:56:05'),
(889, 1, 220, 1, 0, 0, 0, '2019-11-29 07:56:22'),
(932, 1, 204, 1, 0, 0, 0, '2019-11-29 09:13:27'),
(933, 1, 221, 1, 0, 0, 0, '2019-11-29 09:15:04'),
(934, 1, 178, 1, 0, 0, 0, '2019-11-29 09:15:16'),
(935, 1, 179, 1, 0, 0, 0, '2019-11-29 09:15:33'),
(936, 1, 161, 1, 0, 0, 0, '2019-11-29 09:15:48'),
(937, 1, 180, 1, 0, 0, 0, '2019-11-29 09:15:48'),
(938, 1, 181, 1, 0, 0, 0, '2019-11-29 09:19:33'),
(939, 1, 182, 1, 0, 0, 0, '2019-11-29 09:19:45'),
(940, 1, 183, 1, 0, 0, 0, '2019-11-29 09:19:56'),
(941, 1, 174, 1, 0, 0, 0, '2019-11-29 09:20:53'),
(943, 1, 176, 1, 0, 0, 0, '2019-11-29 09:22:10'),
(944, 1, 177, 1, 0, 0, 0, '2019-11-29 09:22:22'),
(945, 1, 53, 0, 1, 0, 0, '2019-11-29 09:24:52'),
(946, 1, 215, 1, 0, 0, 0, '2019-11-29 09:31:37'),
(947, 1, 213, 1, 0, 0, 0, '2019-11-29 09:37:45'),
(974, 1, 224, 1, 0, 0, 0, '2019-11-29 10:02:52'),
(979, 1, 225, 1, 0, 0, 0, '2019-11-29 10:15:30'),
(982, 2, 225, 1, 0, 0, 0, '2019-11-29 10:17:19'),
(1026, 1, 135, 1, 0, 1, 0, '2019-11-29 11:32:12'),
(1031, 1, 228, 1, 0, 0, 0, '2019-11-29 11:51:16'),
(1083, 1, 175, 1, 0, 0, 0, '2019-11-30 06:07:24'),
(1086, 1, 43, 1, 1, 1, 1, '2019-11-30 06:19:39'),
(1087, 1, 44, 1, 0, 0, 0, '2019-11-30 06:19:39'),
(1088, 1, 46, 1, 0, 0, 0, '2019-11-30 06:19:39'),
(1089, 1, 217, 1, 0, 0, 0, '2019-11-30 06:19:39'),
(1090, 1, 98, 1, 1, 1, 1, '2019-11-30 07:02:51'),
(1091, 1, 99, 1, 0, 0, 0, '2019-11-30 07:00:18'),
(1092, 1, 223, 1, 0, 0, 0, '2019-11-30 07:02:51'),
(1103, 2, 205, 1, 1, 1, 1, '2019-11-30 07:26:04'),
(1105, 2, 23, 1, 0, 0, 0, '2019-11-30 07:26:04'),
(1106, 2, 24, 1, 0, 0, 0, '2019-11-30 07:26:04'),
(1107, 2, 25, 1, 0, 0, 0, '2019-11-30 07:26:04'),
(1108, 2, 77, 1, 0, 0, 0, '2019-11-30 07:26:04'),
(1119, 2, 117, 1, 0, 0, 0, '2019-11-30 07:26:04'),
(1123, 3, 8, 1, 1, 1, 1, '2019-11-30 12:16:18'),
(1125, 3, 69, 1, 1, 1, 1, '2019-11-30 12:30:49'),
(1126, 3, 70, 1, 1, 1, 1, '2019-11-30 12:34:46'),
(1130, 3, 9, 1, 1, 1, 1, '2019-11-30 12:44:54'),
(1131, 3, 10, 1, 1, 1, 1, '2019-11-30 12:46:02'),
(1134, 3, 35, 1, 1, 1, 1, '2019-11-30 12:55:04'),
(1135, 3, 104, 1, 1, 1, 1, '2019-11-30 12:55:53'),
(1140, 3, 41, 1, 1, 1, 1, '2019-11-30 13:07:13'),
(1141, 3, 42, 1, 1, 1, 1, '2019-11-30 13:07:46'),
(1142, 3, 43, 1, 1, 1, 1, '2019-11-30 13:12:06'),
(1151, 3, 87, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1152, 3, 88, 1, 1, 1, 0, '2019-11-30 07:53:13'),
(1153, 3, 90, 1, 1, 0, 1, '2019-11-30 07:53:13'),
(1154, 3, 108, 1, 0, 1, 0, '2019-11-30 07:53:13'),
(1155, 3, 109, 1, 1, 0, 0, '2019-11-30 07:53:13'),
(1156, 3, 110, 1, 1, 1, 1, '2019-11-30 07:53:13'),
(1157, 3, 111, 1, 1, 1, 1, '2019-11-30 07:53:13'),
(1158, 3, 112, 1, 1, 1, 1, '2019-11-30 07:53:13'),
(1159, 3, 127, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1160, 3, 129, 0, 1, 0, 1, '2019-11-30 07:53:13'),
(1161, 3, 102, 1, 1, 1, 1, '2019-11-30 07:53:13'),
(1162, 3, 106, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1163, 3, 113, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1164, 3, 114, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1165, 3, 115, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1166, 3, 116, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1167, 3, 117, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1168, 3, 118, 1, 0, 0, 0, '2019-11-30 07:53:13'),
(1171, 2, 142, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1172, 2, 144, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1179, 2, 212, 1, 0, 1, 0, '2019-11-30 08:06:17'),
(1183, 2, 148, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1184, 2, 149, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1185, 2, 150, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1186, 2, 151, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1187, 2, 152, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1188, 2, 153, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1189, 2, 154, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1190, 2, 197, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1191, 2, 198, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1192, 2, 199, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1193, 2, 200, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1194, 2, 201, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1195, 2, 202, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1196, 2, 203, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1197, 2, 219, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1198, 2, 223, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1199, 2, 213, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1201, 2, 230, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1204, 2, 214, 1, 0, 1, 0, '2019-11-30 08:06:17'),
(1206, 2, 224, 1, 0, 0, 0, '2019-11-30 08:06:17'),
(1208, 2, 2, 1, 0, 0, 0, '2019-11-30 08:25:45'),
(1210, 2, 143, 1, 1, 1, 1, '2019-11-30 08:27:28'),
(1211, 2, 145, 1, 0, 0, 0, '2019-11-30 08:27:28'),
(1214, 2, 3, 1, 1, 1, 1, '2019-11-30 08:33:18'),
(1216, 2, 4, 1, 1, 1, 1, '2019-11-30 09:02:56'),

(1218, 2, 128, 0, 1, 0, 1, '2019-11-30 09:07:44'),
(1220, 3, 135, 1, 0, 1, 0, '2019-11-30 12:38:56'),
(1231, 3, 190, 1, 0, 0, 0, '2019-11-30 09:14:02'),
(1232, 3, 192, 1, 0, 0, 0, '2019-11-30 09:14:02'),
(1233, 3, 226, 1, 0, 0, 0, '2019-11-30 09:14:02'),
(1234, 3, 227, 1, 0, 0, 0, '2019-11-30 09:14:02'),
(1235, 3, 224, 1, 0, 0, 0, '2019-11-30 09:14:02'),
(1236, 2, 15, 1, 1, 1, 0, '2019-11-30 09:24:25'),
(1239, 2, 122, 1, 0, 0, 0, '2019-11-30 09:27:48'),
(1240, 2, 136, 1, 0, 0, 0, '2019-11-30 09:27:48'),
(1242, 6, 217, 1, 0, 0, 0, '2019-11-30 09:30:13'),
(1243, 6, 224, 1, 0, 0, 0, '2019-11-30 09:30:13'),
(1245, 2, 20, 1, 1, 1, 1, '2019-11-30 09:31:28'),
(1246, 2, 137, 1, 1, 1, 1, '2019-11-30 09:32:40'),
(1248, 2, 141, 1, 1, 1, 1, '2019-11-30 09:34:04'),
(1250, 2, 187, 1, 0, 0, 0, '2019-11-30 09:41:19'),
(1252, 2, 207, 1, 0, 0, 0, '2019-11-30 09:51:21'),
(1253, 2, 208, 1, 0, 1, 0, '2019-11-30 09:52:00'),
(1255, 2, 210, 1, 0, 1, 0, '2019-11-30 09:52:58'),
(1256, 2, 211, 1, 0, 1, 0, '2019-11-30 09:54:03'),
(1257, 2, 21, 1, 0, 0, 0, '2019-11-30 10:02:59'),
(1259, 2, 188, 1, 0, 0, 0, '2019-11-30 10:04:35'),
(1260, 2, 27, 1, 0, 0, 0, '2019-11-30 10:06:13'),
(1262, 2, 43, 1, 1, 1, 1, '2019-11-30 10:09:42'),
(1263, 2, 44, 1, 0, 0, 0, '2019-11-30 10:11:43'),
(1264, 2, 46, 1, 0, 0, 0, '2019-11-30 10:11:43'),
(1265, 2, 217, 1, 0, 0, 0, '2019-11-30 10:11:43'),
(1266, 2, 146, 1, 0, 0, 0, '2019-11-30 10:16:35'),
(1267, 2, 147, 1, 0, 0, 0, '2019-11-30 10:17:37'),
(1269, 2, 164, 1, 0, 0, 0, '2019-11-30 10:21:04'),

(1271, 2, 109, 1, 1, 0, 0, '2019-11-30 10:33:37'),
(1272, 2, 93, 1, 1, 1, 1, '2019-11-30 10:37:25'),
(1273, 2, 94, 1, 1, 0, 0, '2019-11-30 10:37:42'),
(1275, 2, 102, 1, 1, 1, 1, '2019-11-30 10:41:22'),
(1277, 2, 196, 1, 0, 0, 0, '2019-11-30 10:45:01'),
(1278, 2, 195, 1, 0, 0, 0, '2019-11-30 10:49:08'),
(1279, 2, 185, 1, 1, 1, 1, '2019-11-30 10:51:44'),
(1280, 2, 186, 1, 1, 1, 1, '2019-11-30 10:52:43'),
(1281, 2, 222, 1, 0, 1, 0, '2019-11-30 10:54:30'),
(1283, 3, 5, 1, 1, 0, 1, '2019-11-30 12:13:04'),
(1284, 3, 6, 1, 0, 0, 0, '2019-11-30 12:13:29'),
(1285, 3, 7, 1, 1, 1, 1, '2019-11-30 12:14:39'),
(1286, 3, 68, 1, 0, 0, 0, '2019-11-30 12:16:58'),
(1287, 3, 71, 1, 0, 0, 0, '2019-11-30 12:35:41'),
(1288, 3, 73, 1, 0, 0, 0, '2019-11-30 12:35:59'),
(1289, 3, 74, 1, 0, 0, 0, '2019-11-30 12:36:08'),
(1290, 3, 11, 1, 0, 0, 0, '2019-11-30 12:46:37'),
(1291, 3, 12, 1, 1, 1, 1, '2019-11-30 12:49:29'),
(1292, 3, 13, 1, 1, 1, 1, '2019-11-30 12:52:27'),
(1294, 3, 14, 1, 0, 0, 0, '2019-11-30 12:52:55'),
(1295, 3, 31, 1, 1, 1, 1, '2019-12-02 12:00:37'),
(1297, 3, 37, 1, 1, 1, 1, '2019-11-30 12:58:09'),
(1298, 3, 38, 1, 1, 1, 1, '2019-11-30 12:59:02'),
(1299, 3, 39, 1, 1, 1, 1, '2019-11-30 13:00:07'),
(1300, 3, 40, 1, 1, 1, 1, '2019-11-30 13:02:43'),
(1301, 3, 44, 1, 0, 0, 0, '2019-11-30 13:14:09'),
(1302, 3, 46, 1, 0, 0, 0, '2019-11-30 13:14:09'),
(1303, 3, 217, 1, 0, 0, 0, '2019-11-30 13:14:09'),
(1304, 3, 155, 1, 0, 0, 0, '2019-11-30 13:14:32'),
(1305, 3, 156, 1, 0, 0, 0, '2019-11-30 13:15:18'),
(1306, 3, 157, 1, 0, 0, 0, '2019-11-30 13:15:42'),
(1307, 3, 158, 1, 0, 0, 0, '2019-11-30 13:16:07'),
(1308, 3, 159, 1, 0, 0, 0, '2019-11-30 13:16:21'),
(1309, 3, 160, 1, 0, 0, 0, '2019-11-30 13:16:33'),
(1313, 3, 161, 1, 0, 0, 0, '2019-11-30 13:18:26'),
(1314, 3, 162, 1, 0, 0, 0, '2019-11-30 13:18:48'),
(1315, 3, 163, 1, 0, 0, 0, '2019-11-30 13:18:48'),
(1316, 3, 164, 1, 0, 0, 0, '2019-11-30 13:19:47'),
(1317, 3, 165, 1, 0, 0, 0, '2019-11-30 13:19:47'),
(1318, 3, 174, 1, 0, 0, 0, '2019-11-30 13:19:47'),
(1319, 3, 175, 1, 0, 0, 0, '2019-11-30 13:19:59'),
(1320, 3, 181, 1, 0, 0, 0, '2019-11-30 13:20:08'),
(1321, 3, 86, 1, 1, 1, 1, '2019-11-30 13:24:08'),
(1322, 4, 28, 1, 1, 1, 1, '2019-12-01 06:22:39'),
(1324, 4, 29, 1, 0, 0, 0, '2019-12-01 06:23:46'),
(1325, 4, 30, 1, 0, 0, 0, '2019-12-01 06:23:59'),
(1326, 4, 123, 1, 0, 0, 0, '2019-12-01 06:24:26'),
(1327, 4, 228, 1, 0, 0, 0, '2019-12-01 06:24:39'),
(1328, 4, 43, 1, 1, 1, 1, '2019-12-01 06:28:05'),
(1332, 4, 44, 1, 0, 0, 0, '2019-12-01 06:29:16'),
(1333, 4, 46, 1, 0, 0, 0, '2019-12-01 06:29:16'),
(1334, 4, 217, 1, 0, 0, 0, '2019-12-01 06:29:16'),
(1335, 4, 178, 1, 0, 0, 0, '2019-12-01 06:29:59'),
(1336, 4, 179, 1, 0, 0, 0, '2019-12-01 06:30:11'),
(1337, 4, 180, 1, 0, 0, 0, '2019-12-01 06:30:29'),
(1338, 4, 221, 1, 0, 0, 0, '2019-12-01 06:30:46'),
(1339, 4, 86, 1, 0, 0, 0, '2019-12-01 06:31:02'),
(1341, 4, 106, 1, 0, 0, 0, '2019-12-01 06:35:21'),
(1342, 1, 107, 1, 0, 0, 0, '2019-12-01 06:36:44'),
(1343, 4, 117, 1, 0, 0, 0, '2019-12-01 06:40:20'),
(1344, 4, 194, 1, 0, 0, 0, '2019-12-01 06:41:35'),
(1348, 4, 230, 1, 0, 0, 0, '2019-12-01 06:49:15'),
(1350, 6, 1, 1, 0, 0, 0, '2019-12-01 07:05:32'),
(1351, 6, 21, 1, 0, 0, 0, '2019-12-01 07:06:29'),
(1352, 6, 23, 1, 0, 0, 0, '2019-12-01 07:06:45'),
(1353, 6, 24, 1, 0, 0, 0, '2019-12-01 07:07:05'),
(1354, 6, 25, 1, 0, 0, 0, '2019-12-01 07:07:34'),
(1355, 6, 77, 1, 0, 0, 0, '2019-12-01 07:08:08'),
(1356, 6, 188, 1, 0, 0, 0, '2019-12-01 07:08:45'),
(1357, 6, 43, 1, 1, 1, 1, '2019-12-01 07:10:44'),
(1358, 6, 78, 1, 1, 1, 1, '2019-12-01 07:13:04'),
(1360, 6, 79, 1, 1, 0, 1, '2019-12-01 07:14:39'),
(1361, 6, 80, 1, 1, 1, 1, '2019-12-01 07:15:08'),
(1362, 6, 81, 1, 1, 1, 1, '2019-12-01 07:17:50'),
(1363, 6, 85, 1, 1, 1, 1, '2019-12-01 07:20:43'),
(1364, 6, 86, 1, 0, 0, 0, '2019-12-01 07:21:10'),
(1365, 6, 106, 1, 0, 0, 0, '2019-12-01 07:22:55'),
(1366, 6, 117, 1, 0, 0, 0, '2019-12-01 07:23:08'),
(1394, 1, 106, 1, 0, 0, 0, '2019-12-02 10:50:33'),
(1395, 1, 113, 1, 0, 0, 0, '2019-12-02 10:50:59'),
(1396, 1, 114, 1, 0, 0, 0, '2019-12-02 10:51:34'),
(1397, 1, 115, 1, 0, 0, 0, '2019-12-02 10:51:34'),
(1398, 1, 116, 1, 0, 0, 0, '2019-12-02 10:51:54'),
(1399, 1, 117, 1, 0, 0, 0, '2019-12-02 10:52:04'),
(1400, 1, 118, 1, 0, 0, 0, '2019-12-02 10:52:20'),
(1402, 1, 191, 1, 0, 0, 0, '2019-12-02 10:53:34'),
(1403, 1, 192, 1, 0, 0, 0, '2019-12-02 10:53:47'),
(1404, 1, 193, 1, 0, 0, 0, '2019-12-02 10:53:58'),
(1405, 1, 194, 1, 0, 0, 0, '2019-12-02 10:54:11'),
(1406, 1, 195, 1, 0, 0, 0, '2019-12-02 10:54:20'),
(1408, 1, 227, 1, 0, 0, 0, '2019-12-02 10:55:47'),
(1410, 1, 226, 1, 0, 0, 0, '2019-12-02 11:01:41'),
(1411, 1, 229, 1, 0, 0, 0, '2019-12-02 11:02:57'),
(1412, 1, 230, 1, 0, 0, 0, '2019-12-02 11:02:57'),
(1413, 1, 190, 1, 0, 0, 0, '2019-12-02 11:13:41'),
(1414, 2, 174, 1, 0, 0, 0, '2019-12-02 11:24:37'),
(1415, 2, 175, 1, 0, 0, 0, '2019-12-02 11:24:37'),
(1418, 2, 232, 1, 0, 1, 1, '2019-12-02 11:41:27'),
(1419, 2, 231, 1, 0, 0, 0, '2019-12-02 11:42:28'),
(1420, 1, 231, 1, 0, 0, 0, '2019-12-02 11:49:32'),
(1421, 1, 232, 1, 0, 1, 1, '2019-12-02 11:49:32'),
(1422, 3, 32, 1, 1, 1, 1, '2019-12-02 12:00:37'),
(1423, 3, 33, 1, 1, 1, 1, '2019-12-02 12:00:37'),
(1424, 3, 34, 1, 1, 1, 1, '2019-12-02 12:00:37'),
(1425, 3, 182, 1, 0, 0, 0, '2019-12-02 12:00:37'),
(1426, 3, 183, 1, 0, 0, 0, '2019-12-02 12:00:37'),
(1427, 3, 189, 1, 0, 1, 1, '2019-12-02 12:00:37'),
(1428, 3, 229, 1, 0, 0, 0, '2019-12-02 12:00:37'),
(1429, 3, 230, 1, 0, 0, 0, '2019-12-02 12:00:37'),
(1430, 4, 213, 1, 0, 0, 0, '2019-12-02 12:02:14'),
(1432, 4, 224, 1, 0, 0, 0, '2019-12-02 12:02:14'),
(1433, 4, 195, 1, 0, 0, 0, '2019-12-03 10:27:53'),
(1434, 4, 229, 1, 0, 0, 0, '2019-12-03 10:28:19'),
(1436, 6, 213, 1, 0, 0, 0, '2019-12-03 10:40:11'),
(1437, 6, 191, 1, 0, 0, 0, '2019-12-03 10:40:11'),
(1438, 6, 193, 1, 0, 0, 0, '2019-12-03 10:40:11'),
(1439, 6, 230, 1, 0, 0, 0, '2019-12-03 10:40:11'),
(1440, 2, 106, 1, 0, 0, 0, '2020-01-25 09:51:36'),
(1441, 2, 107, 1, 0, 0, 0, '2020-02-12 07:40:13'),
(1442, 2, 134, 1, 1, 1, 1, '2020-02-12 07:42:36'),
(1443, 1, 233, 1, 0, 0, 0, '2020-02-12 07:51:57'),
(1444, 2, 86, 1, 0, 0, 0, '2020-02-12 07:52:33'),
(1445, 3, 233, 1, 0, 0, 0, '2020-02-12 09:21:17');

truncate 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
(1, 1, 'Student', 'student', 1, 1, 1, 1, '2019-10-24 11:12:03'),
(2, 1, 'Import Student', 'import_student', 1, 0, 0, 0, '2018-06-22 15:47:19'),
(3, 1, 'Student Categories', 'student_categories', 1, 1, 1, 1, '2018-06-22 15:47:36'),
(4, 1, 'Student Houses', 'student_houses', 1, 1, 1, 1, '2018-06-22 15:47:53'),
(5, 2, 'Collect Fees', 'collect_fees', 1, 1, 0, 1, '2018-06-22 15:51:03'),
(6, 2, 'Fees Carry Forward', 'fees_carry_forward', 1, 0, 0, 0, '2018-06-27 05:48:15'),
(7, 2, 'Fees Master', 'fees_master', 1, 1, 1, 1, '2018-06-27 05:48:57'),
(8, 2, 'Fees Group', 'fees_group', 1, 1, 1, 1, '2018-06-22 15:51:46'),
(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'),
(11, 3, 'Search Income', 'search_income', 1, 0, 0, 0, '2018-06-22 15:53:00'),
(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'),
(15, 5, 'Student / Period Attendance', 'student_attendance', 1, 1, 1, 0, '2019-11-29 06:49:05'),
(20, 6, 'Marks Grade', 'marks_grade', 1, 1, 1, 1, '2018-06-22 15:55:25'),
(21, 7, 'Class Timetable', 'class_timetable', 1, 0, 1, 0, '2019-11-24 08:35:17'),
(23, 7, 'Subject', 'subject', 1, 1, 1, 1, '2018-06-22 16:02:17'),
(24, 7, 'Class', 'class', 1, 1, 1, 1, '2018-06-22 16:02:35'),
(25, 7, 'Section', 'section', 1, 1, 1, 1, '2018-06-22 16:01:10'),
(26, 7, 'Promote Student', 'promote_student', 1, 0, 0, 0, '2018-06-22 16:02:47'),
(27, 8, 'Upload Content', 'upload_content', 1, 1, 0, 1, '2018-06-22 16:03:19'),
(28, 9, 'Books List', 'books', 1, 1, 1, 1, '2019-11-24 06:07:12'),
(29, 9, 'Issue Return', 'issue_return', 1, 0, 0, 0, '2019-11-24 06:07:18'),
(30, 9, 'Add Staff Member', 'add_staff_member', 1, 0, 0, 0, '2018-07-02 17:07:00'),
(31, 10, 'Issue Item', 'issue_item', 1, 1, 1, 1, '2019-11-29 12:09:27'),
(32, 10, 'Add Item Stock', 'item_stock', 1, 1, 1, 1, '2019-11-24 06:09:17'),
(33, 10, 'Add Item', 'item', 1, 1, 1, 1, '2019-11-24 06:09:39'),
(34, 10, 'Item Store', 'store', 1, 1, 1, 1, '2019-11-24 06:10:41'),
(35, 10, 'Item Supplier', 'supplier', 1, 1, 1, 1, '2019-11-24 06:10:49'),
(37, 11, 'Routes', 'routes', 1, 1, 1, 1, '2018-06-22 16:09:17'),
(38, 11, 'Vehicle', 'vehicle', 1, 1, 1, 1, '2018-06-22 16:09:36'),
(39, 11, 'Assign Vehicle', 'assign_vehicle', 1, 1, 1, 1, '2018-06-27 10:09:20'),
(40, 12, 'Hostel', 'hostel', 1, 1, 1, 1, '2018-06-22 16:10:49'),
(41, 12, 'Room Type', 'room_type', 1, 1, 1, 1, '2018-06-22 16:10:27'),
(42, 12, 'Hostel Rooms', 'hostel_rooms', 1, 1, 1, 1, '2018-06-25 11:53:03'),
(43, 13, 'Notice Board', 'notice_board', 1, 1, 1, 1, '2018-06-22 16:11:17'),
(44, 13, 'Email', 'email', 1, 0, 0, 0, '2019-11-26 10:50:37'),
(46, 13, 'Email / SMS Log', 'email_sms_log', 1, 0, 0, 0, '2018-06-22 16:11:23'),
(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'),
(55, 15, 'Session Setting', 'session_setting', 1, 1, 1, 1, '2018-06-22 16:14:15'),
(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'),
(68, 2, 'Fees Group Assign', 'fees_group_assign', 1, 0, 0, 0, '2018-06-22 15:50:42'),
(69, 2, 'Fees Type', 'fees_type', 1, 1, 1, 1, '2018-06-22 15:49:34'),
(70, 2, 'Fees Discount', 'fees_discount', 1, 1, 1, 1, '2018-06-22 15:50:10'),
(71, 2, 'Fees Discount Assign', 'fees_discount_assign', 1, 0, 0, 0, '2018-06-22 15:50:17'),
(73, 2, 'Search Fees Payment', 'search_fees_payment', 1, 0, 0, 0, '2018-06-22 15:50:27'),
(74, 2, 'Search Due Fees', 'search_due_fees', 1, 0, 0, 0, '2018-06-22 15:50:35'),
(77, 7, 'Assign Class Teacher', 'assign_class_teacher', 1, 1, 1, 1, '2018-06-22 16:00:52'),
(78, 17, 'Admission Enquiry', 'admission_enquiry', 1, 1, 1, 1, '2018-06-22 16:21:24'),
(79, 17, 'Follow Up Admission Enquiry', 'follow_up_admission_enquiry', 1, 1, 0, 1, '2018-06-22 16:21:39'),
(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', 'complaint', 1, 1, 1, 1, '2018-07-03 14:10:55'),
(85, 17, 'Setup Font Office', 'setup_font_office', 1, 1, 1, 1, '2018-06-22 16:19:24'),
(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'),
(90, 18, 'Staff Payroll', 'staff_payroll', 1, 1, 0, 1, '2018-06-22 16:22:51'),
(93, 19, 'Homework', 'homework', 1, 1, 1, 1, '2018-06-22 16:23:50'),
(94, 19, 'Homework Evaluation', 'homework_evaluation', 1, 1, 0, 0, '2018-06-27 08:37:21'),
(96, 20, 'Student Certificate', 'student_certificate', 1, 1, 1, 1, '2018-07-06 16:11:07'),
(97, 20, 'Generate Certificate', 'generate_certificate', 1, 0, 0, 0, '2018-07-06 16:07:16'),
(98, 20, 'Student ID Card', 'student_id_card', 1, 1, 1, 1, '2018-07-06 16:11:28'),
(99, 20, 'Generate ID Card', 'generate_id_card', 1, 0, 0, 0, '2018-07-06 16:11:49'),
(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'),
(106, 22, 'Quick Session Change', 'quick_session_change', 1, 0, 0, 0, '2018-06-22 16:24:45'),
(107, 1, 'Disable Student', 'disable_student', 1, 0, 0, 0, '2018-06-25 11:51:34'),
(108, 18, ' Approve Leave Request', 'approve_leave_request', 1, 0, 1, 0, '2019-11-29 05:17:51'),
(109, 18, 'Apply Leave', 'apply_leave', 1, 1, 0, 0, '2019-11-29 05:17:46'),
(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'),
(113, 22, 'Fees Collection And Expense Monthly Chart', 'fees_collection_and_expense_monthly_chart', 1, 0, 0, 0, '2018-07-03 12:38:15'),
(114, 22, 'Fees Collection And Expense Yearly Chart', 'fees_collection_and_expense_yearly_chart', 1, 0, 0, 0, '2018-07-03 12:38:15'),
(115, 22, 'Monthly Fees Collection Widget', 'Monthly fees_collection_widget', 1, 0, 0, 0, '2018-07-03 12:43:35'),
(116, 22, 'Monthly Expense Widget', 'monthly_expense_widget', 1, 0, 0, 0, '2018-07-03 12:43:35'),
(117, 22, 'Student Count Widget', 'student_count_widget', 1, 0, 0, 0, '2018-07-03 12:43:35'),
(118, 22, 'Staff Role Count Widget', 'staff_role_count_widget', 1, 0, 0, 0, '2018-07-03 12:43:35'),
(122, 5, 'Attendance By Date', 'attendance_by_date', 1, 0, 0, 0, '2018-07-03 14:12:29'),
(123, 9, 'Add Student', 'add_student', 1, 0, 0, 0, '2018-07-03 14:12:29'),
(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'),
(128, 1, 'Student Timeline', 'student_timeline', 0, 1, 0, 1, '2018-07-05 13:38:52'),
(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'),
(134, 1, 'Disable Reason', 'disable_reason', 1, 1, 1, 1, '2019-11-27 12:09:21'),
(135, 2, 'Fees Reminder', 'fees_reminder', 1, 0, 1, 0, '2019-10-25 06:09:49'),
(136, 5, 'Approve Leave', 'approve_leave', 1, 0, 0, 0, '2019-10-25 06:16:44'),
(137, 6, 'Exam Group', 'exam_group', 1, 1, 1, 1, '2019-10-25 06:32:34'),
(141, 6, 'Design Admit Card', 'design_admit_card', 1, 1, 1, 1, '2019-10-25 06:36:59'),
(142, 6, 'Print Admit Card', 'print_admit_card', 1, 0, 0, 0, '2019-11-24 05:27:51'),
(143, 6, 'Design Marksheet', 'design_marksheet', 1, 1, 1, 1, '2019-10-25 06:40:25'),
(144, 6, 'Print Marksheet', 'print_marksheet', 1, 0, 0, 0, '2019-10-25 06:41:02'),
(145, 7, 'Teachers Timetable', 'teachers_time_table', 1, 0, 0, 0, '2019-11-30 08:22:21'),
(146, 14, 'Student Report', 'student_report', 1, 0, 0, 0, '2019-10-25 06:57:00'),
(147, 14, 'Guardian Report', 'guardian_report', 1, 0, 0, 0, '2019-10-25 07:00:27'),
(148, 14, 'Student History', 'student_history', 1, 0, 0, 0, '2019-10-25 07:09:07'),
(149, 14, 'Student Login Credential Report', 'student_login_credential_report', 1, 0, 0, 0, '2019-10-25 07:09:07'),
(150, 14, 'Class Subject Report', 'class_subject_report', 1, 0, 0, 0, '2019-10-25 07:09:07'),
(151, 14, 'Admission Report', 'admission_report', 1, 0, 0, 0, '2019-10-25 07:09:07'),
(152, 14, 'Sibling Report', 'sibling_report', 1, 0, 0, 0, '2019-10-25 07:09:07'),
(153, 14, 'Homework Evaluation Report', 'homehork_evaluation_report', 1, 0, 0, 0, '2019-11-24 06:34:24'),
(154, 14, 'Student Profile', 'student_profile', 1, 0, 0, 0, '2019-10-25 07:09:07'),
(155, 14, 'Fees Statement', 'fees_statement', 1, 0, 0, 0, '2019-10-25 07:25:52'),
(156, 14, 'Balance Fees Report', 'balance_fees_report', 1, 0, 0, 0, '2019-10-25 07:25:52'),
(157, 14, 'Fees Collection Report', 'fees_collection_report', 1, 0, 0, 0, '2019-10-25 07:25:52'),
(158, 14, 'Online Fees Collection Report', 'online_fees_collection_report', 1, 0, 0, 0, '2019-10-25 07:25:52'),
(159, 14, 'Income Report', 'income_report', 1, 0, 0, 0, '2019-10-25 07:25:52'),
(160, 14, 'Expense Report', 'expense_report', 1, 0, 0, 0, '2019-10-25 07:25:52'),
(161, 14, 'PayRoll Report', 'payroll_report', 1, 0, 0, 0, '2019-10-31 05:53:22'),
(162, 14, 'Income Group Report', 'income_group_report', 1, 0, 0, 0, '2019-10-25 07:25:52'),
(163, 14, 'Expense Group Report', 'expense_group_report', 1, 0, 0, 0, '2019-10-25 07:25:52'),
(164, 14, 'Attendance Report', 'attendance_report', 1, 0, 0, 0, '2019-10-25 07:38:06'),
(165, 14, 'Staff Attendance Report', 'staff_attendance_report', 1, 0, 0, 0, '2019-10-25 07:38:06'),
(174, 14, 'Transport Report', 'transport_report', 1, 0, 0, 0, '2019-10-25 07:43:56'),
(175, 14, 'Hostel Report', 'hostel_report', 1, 0, 0, 0, '2019-11-27 12:21:53'),
(176, 14, 'Audit Trail Report', 'audit_trail_report', 1, 0, 0, 0, '2019-10-25 07:46:39'),
(177, 14, 'User Log', 'user_log', 1, 0, 0, 0, '2019-10-25 07:49:27'),
(178, 14, 'Book Issue Report', 'book_issue_report', 1, 0, 0, 0, '2019-10-25 07:59:04'),
(179, 14, 'Book Due Report', 'book_due_report', 1, 0, 0, 0, '2019-10-25 07:59:04'),
(180, 14, 'Book Inventory Report', 'book_inventory_report', 1, 0, 0, 0, '2019-10-25 07:59:04'),
(181, 14, 'Stock Report', 'stock_report', 1, 0, 0, 0, '2019-10-25 08:01:28'),
(182, 14, 'Add Item Report', 'add_item_report', 1, 0, 0, 0, '2019-10-25 08:01:28'),
(183, 14, 'Issue Item Report', 'issue_item_report', 1, 0, 0, 0, '2019-11-29 09:18:06'),
(185, 23, 'Online Examination', 'online_examination', 1, 1, 1, 1, '2019-11-24 05:24:50'),
(186, 23, 'Question Bank', 'question_bank', 1, 1, 1, 1, '2019-11-24 05:25:18'),
(187, 6, 'Exam Result', 'exam_result', 1, 0, 0, 0, '2019-11-24 05:28:50'),
(188, 7, 'Subject Group', 'subject_group', 1, 1, 1, 1, '2019-11-24 06:04:32'),
(189, 18, 'Teachers Rating', 'teachers_rating', 1, 0, 1, 1, '2019-11-24 08:42:54'),
(190, 22, 'Fees Awaiting Payment Widegts', 'fees_awaiting_payment_widegts', 1, 0, 0, 0, '2019-11-24 06:22:51'),
(191, 22, 'Conveted Leads Widegts', 'conveted_leads_widegts', 1, 0, 0, 0, '2019-11-24 06:28:24'),
(192, 22, 'Fees Overview Widegts', 'fees_overview_widegts', 1, 0, 0, 0, '2019-11-24 06:27:41'),
(193, 22, 'Enquiry Overview Widegts', 'enquiry_overview_widegts', 1, 0, 0, 0, '2019-12-02 10:36:09'),
(194, 22, 'Library Overview Widegts', 'book_overview_widegts', 1, 0, 0, 0, '2019-12-01 06:43:04'),
(195, 22, 'Student Today Attendance Widegts', 'today_attendance_widegts', 1, 0, 0, 0, '2019-12-03 10:27:45'),
(196, 6, 'Marks Import', 'marks_import', 1, 0, 0, 0, '2019-11-24 06:32:11'),
(197, 14, 'Student Attendance Type Report', 'student_attendance_type_report', 1, 0, 0, 0, '2019-11-24 06:36:32'),
(198, 14, 'Exam Marks Report', 'exam_marks_report', 1, 0, 0, 0, '2019-11-24 06:41:15'),
(200, 14, 'Online Exam Wise Report', 'online_exam_wise_report', 1, 0, 0, 0, '2019-11-24 06:48:14'),
(201, 14, 'Online Exams Report', 'online_exams_report', 1, 0, 0, 0, '2019-11-29 08:18:05'),
(202, 14, 'Online Exams Attempt Report', 'online_exams_attempt_report', 1, 0, 0, 0, '2019-11-29 08:16:24'),
(203, 14, 'Online Exams Rank Report', 'online_exams_rank_report', 1, 0, 0, 0, '2019-11-24 06:52:25'),
(204, 14, 'Staff Report', 'staff_report', 1, 0, 0, 0, '2019-11-24 06:55:27'),
(205, 6, 'Exam', 'exam', 1, 1, 1, 1, '2019-11-24 10:25:48'),
(207, 6, 'Exam Publish', 'exam_publish', 1, 0, 0, 0, '2019-11-24 10:45:04'),
(208, 6, 'Link Exam', 'link_exam', 1, 0, 1, 0, '2019-11-24 10:45:04'),
(210, 6, 'Assign / View student', 'exam_assign_view_student', 1, 0, 1, 0, '2019-11-24 10:45:04'),
(211, 6, 'Exam Subject', 'exam_subject', 1, 0, 1, 0, '2019-11-24 10:45:04'),
(212, 6, 'Exam Marks', 'exam_marks', 1, 0, 1, 0, '2019-11-24 10:45:04'),
(213, 15, 'Language Switcher', 'language_switcher', 1, 0, 0, 0, '2019-11-24 10:47:11'),
(214, 23, 'Add Questions in Exam ', 'add_questions_in_exam', 1, 0, 1, 0, '2019-11-28 07:08:57'),
(215, 15, 'Custom Fields', 'custom_fields', 1, 0, 0, 0, '2019-11-29 09:38:35'),
(216, 15, 'System Fields', 'system_fields', 1, 0, 0, 0, '2019-11-25 05:45:01'),
(217, 13, 'SMS', 'sms', 1, 0, 0, 0, '2018-06-22 16:10:54'),
(219, 14, 'Student / Period Attendance Report', 'student_period_attendance_report', 1, 0, 0, 0, '2019-11-29 07:49:31'),
(220, 14, 'Biometric Attendance Log', 'biometric_attendance_log', 1, 0, 0, 0, '2019-11-27 11:29:16'),
(221, 14, 'Book Issue Return Report', 'book_issue_return_report', 1, 0, 0, 0, '2019-11-27 12:00:23'),
(222, 23, 'Assign / View Student', 'online_assign_view_student', 1, 0, 1, 0, '2019-11-28 09:50:22'),
(223, 14, 'Rank Report', 'rank_report', 1, 0, 0, 0, '2019-11-29 08:00:21'),
(224, 25, 'Chat', 'chat', 1, 0, 0, 0, '2019-11-29 09:40:28'),
(226, 22, 'Income Donut Graph', 'income_donut_graph', 1, 0, 0, 0, '2019-11-29 10:30:33'),
(227, 22, 'Expense Donut Graph', 'expense_donut_graph', 1, 0, 0, 0, '2019-11-29 10:31:10'),
(228, 9, 'Import Book', 'import_book', 1, 0, 0, 0, '2019-11-29 11:51:01'),
(229, 22, 'Staff Present Today Widegts', 'staff_present_today_widegts', 1, 0, 0, 0, '2019-11-29 12:18:00'),
(230, 22, 'Student Present Today Widegts', 'student_present_today_widegts', 1, 0, 0, 0, '2019-11-29 12:17:42'),
(231, 26, 'Multi Class Student', 'multi_class_student', 1, 0, 0, 0, '2019-12-02 11:32:58'),
(232, 27, 'Online Admission', 'online_admission', 1, 0, 1, 1, '2019-12-02 11:41:10'),
(233, 15, 'Print Header Footer', 'print_header_footer', 1, 0, 0, 0, '2020-02-12 07:32:02');



INSERT INTO `payment_settings` (`id`, `payment_type`, `api_username`, `api_secret_key`, `salt`, `api_publishable_key`, `api_password`, `api_signature`, `api_email`, `paypal_demo`, `account_no`, `is_active`, `created_at`, `updated_at`) VALUES
(null, 'paystack', NULL, '', '', '', NULL, NULL, NULL, '', '', 'no', '2020-02-12 14:07:08', NULL),
(null, 'instamojo', NULL, '', '', '', NULL, NULL, NULL, '', '', 'no', '2020-02-12 14:07:13', NULL),
(null, 'razorpay', NULL, '', '', '', NULL, NULL, NULL, '', '', 'no', '2020-02-12 14:07:16', NULL);



update `notification_setting` set is_notification=0, display_notification=0, variables = '{{firstname}}  {{lastname}}  {{class}}  {{section}}  {{admission_no}}  {{roll_no}}  {{admission_date}}   {{mobileno}}  {{email}}  {{dob}}  {{guardian_name}}  {{guardian_relation}}  {{guardian_phone}}  {{father_name}}  {{father_phone}}  {{blood_group}}  {{mother_name}}  {{gender}}  {{guardian_email}} {{current_session_name}}' where type= 'student_admission'; 
update `notification_setting` set is_notification=0, display_notification=1, variables = '{{student_name}} {{exam_name}} {{total_marks}} {{achive_marks}} {{result}}' where type= 'exam_result';      
update `notification_setting` set is_notification=0, display_notification=1, variables = '{{firstname}} {{lastname}} {{class}} {{section}} {{fine_type}} {{fine_percentage}} {{fine_amount}} {{fee_group_name}} {{type}} {{code}} {{email}} {{contact_no}} {{invoice_id}} {{sub_invoice_id}} {{due_date}} {{amount}} {{fee_amount}}' where type= 'fee_submission';    
update `notification_setting` set is_notification=0, display_notification=1, variables = '{{firstname}} {{lastname}} {{mobileno}} {{email}} {{father_name}} {{father_phone}} {{father_occupation}} {{mother_name}} {{mother_phone}} {{guardian_name}} {{guardian_phone}} {{guardian_occupation}} {{guardian_email}} {{date}} {{current_session_name}} {{time_from}} {{time_to}} {{subject_name}} {{subject_code}} {{subject_type}} ' where type= 'absent_attendence'; 
update `notification_setting` set is_notification=0, display_notification=0, variables = '{{url}} {{display_name}} {{username}} {{password}}' where type= 'login_credential';
update `notification_setting` set is_notification=0, display_notification=1, variables = '{{homework_date}} {{submit_date}} {{class}} {{section}} {{subject}} {{student_name}}' where type= 'homework';          
update `notification_setting` set is_notification=0, display_notification=1, variables = '{{fee_type}}{{fee_code}}{{due_date}}{{firstname}} {{lastname}}{{school_name}}{{fee_amount}}{{due_amount}}{{deposit_amount}}' where type= 'fees_reminder';     

ALTER TABLE template_marksheets MODIFY `date` varchar(20) DEFAULT NULL AFTER background_img;

  ALTER TABLE template_marksheets 
  ADD COLUMN `is_class` int(11) NOT NULL DEFAULT '0' AFTER date,
  ADD COLUMN `is_section` int(11) NOT NULL DEFAULT '0' AFTER is_class,
  ADD COLUMN `content` text AFTER is_section,
  ADD COLUMN `content_footer` text AFTER content;


 ALTER TABLE template_admitcards
  ADD COLUMN `is_class` int(11) NOT NULL DEFAULT '0' AFTER is_photo,
  ADD COLUMN `is_section` int(11) NOT NULL DEFAULT '0' AFTER is_class,
  ADD COLUMN `content_footer` text AFTER is_section;


ALTER TABLE `exam_group_class_batch_exam_subjects`
   ADD KEY `subject_id` (`subject_id`);

ALTER TABLE `exam_group_class_batch_exam_subjects`
 ADD CONSTRAINT `exam_group_class_batch_exam_subjects_ibfk_2` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE;

ALTER TABLE complaint
MODIFY COLUMN `complaint_type` varchar(15) NOT NULL;

 ALTER TABLE submit_assignment
  ADD COLUMN `file_name` text AFTER docs;