CREATE TABLE `chat_connections` (
  `id` int(11) NOT NULL,
  `chat_user_one` int(11) NOT NULL,
  `chat_user_two` int(11) NOT NULL,
  `ip` varchar(30) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `chat_messages` (
  `id` int(11) NOT NULL,
  `message` text,
  `chat_user_id` int(11) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `time` int(11) NOT NULL,
  `is_first` int(1) DEFAULT '0',
  `is_read` int(1) NOT NULL DEFAULT '0',
  `chat_connection_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `chat_users` (
  `id` int(11) NOT NULL,
  `user_type` varchar(20) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `create_staff_id` int(11) DEFAULT NULL,
  `create_student_id` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `custom_fields` (
  `id` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `belong_to` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `type` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `bs_column` int(10) DEFAULT NULL,
  `validation` int(11) DEFAULT '0',
  `field_values` text CHARACTER SET latin1,
  `show_table` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `visible_on_table` int(11) NOT NULL,
  `weight` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `custom_field_values` (
  `id` int(11) NOT NULL,
  `belong_table_id` int(11) DEFAULT NULL,
  `custom_field_id` int(11) DEFAULT NULL,
  `field_value` longtext CHARACTER SET latin1,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `disable_reason` (
  `id` int(11) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `exam_groups` (
  `id` int(11) NOT NULL,
  `name` varchar(250) DEFAULT NULL,
  `exam_type` varchar(250) DEFAULT NULL,
  `description` text,
  `is_active` int(11) DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `exam_group_class_batch_exam_subjects` (
  `id` int(11) NOT NULL,
  `exam_group_class_batch_exams_id` int(11) DEFAULT NULL,
  `subject_id` int(10) NOT NULL,
  `date_from` date NOT NULL,
  `time_from` time NOT NULL,
  `duration` varchar(50) NOT NULL,
  `room_no` varchar(100) DEFAULT NULL,
  `max_marks` float(10,2) DEFAULT NULL,
  `min_marks` float(10,2) DEFAULT NULL,
  `credit_hours` float(10,2) DEFAULT '0.00',
  `date_to` datetime DEFAULT NULL,
  `is_active` int(11) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `exam_group_exam_connections` (
  `id` int(11) NOT NULL,
  `exam_group_id` int(11) DEFAULT NULL,
  `exam_group_class_batch_exams_id` int(11) DEFAULT NULL,
  `exam_weightage` float(10,2) DEFAULT '0.00',
  `is_active` int(11) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `exam_group_exam_results` (
  `id` int(11) NOT NULL,
  `exam_group_class_batch_exam_student_id` int(11) NOT NULL,
  `exam_group_class_batch_exam_subject_id` int(11) DEFAULT NULL,
  `attendence` varchar(10) DEFAULT NULL,
  `get_marks` float(10,2) DEFAULT '0.00',
  `note` text,
  `is_active` int(11) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  `exam_group_student_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `fees_reminder` (
  `id` int(11) NOT NULL,
  `reminder_type` varchar(10) DEFAULT NULL,
  `day` int(2) DEFAULT NULL,
  `is_active` int(1) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `message` text,
  `record_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `action` varchar(50) DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  `platform` varchar(50) DEFAULT NULL,
  `agent` varchar(50) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `onlineexam_attempts` (
  `id` int(11) NOT NULL,
  `onlineexam_student_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `onlineexam_student_results` (
  `id` int(11) NOT NULL,
  `onlineexam_student_id` int(11) NOT NULL,
  `onlineexam_question_id` int(11) NOT NULL,
  `select_option` varchar(10) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `permission_parent` (
  `id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) NOT NULL,
  `is_active` int(11) DEFAULT '0',
  `system` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `permission_student` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) NOT NULL,
  `is_active` int(11) DEFAULT '0',
  `system` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `questions` (
  `id` int(11) NOT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `question` text,
  `opt_a` text,
  `opt_b` text,
  `opt_c` text,
  `opt_d` text,
  `opt_e` text,
  `correct` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `question_answers` (
  `id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `option_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `question_options` (
  `id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `option` text CHARACTER SET latin1 NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `staff_rating` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `comment` text CHARACTER SET latin1 NOT NULL,
  `rate` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `role` varchar(255) CHARACTER SET latin1 NOT NULL,
  `status` int(11) NOT NULL COMMENT '0 decline, 1 Approve',
  `entrydt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `submit_assignment` (
  `id` int(11) NOT NULL,
  `homework_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `docs` varchar(225) NOT NULL,
  `file_name` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `template_admitcards` (
  `id` int(11) NOT NULL,
  `template` varchar(250) DEFAULT NULL,
  `heading` text,
  `title` text,
  `left_logo` varchar(200) DEFAULT NULL,
  `right_logo` varchar(200) DEFAULT NULL,
  `exam_name` varchar(200) DEFAULT NULL,
  `school_name` varchar(200) DEFAULT NULL,
  `exam_center` varchar(200) DEFAULT NULL,
  `sign` varchar(200) DEFAULT NULL,
  `background_img` varchar(200) DEFAULT NULL,
  `is_name` int(1) NOT NULL DEFAULT '1',
  `is_father_name` int(1) NOT NULL DEFAULT '1',
  `is_mother_name` int(1) NOT NULL DEFAULT '1',
  `is_dob` int(1) NOT NULL DEFAULT '1',
  `is_admission_no` int(1) NOT NULL DEFAULT '1',
  `is_roll_no` int(1) NOT NULL DEFAULT '1',
  `is_address` int(1) NOT NULL DEFAULT '1',
  `is_gender` int(1) NOT NULL DEFAULT '1',
  `is_photo` int(11) NOT NULL,
  `is_class` int(11) NOT NULL DEFAULT 0,
  `is_section` int(11) NOT NULL DEFAULT 0,
  `content_footer` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE `template_marksheets` (
  `id` int(11) NOT NULL,
  `template` varchar(200) DEFAULT NULL,
  `heading` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `left_logo` varchar(200) DEFAULT NULL,
  `right_logo` varchar(200) DEFAULT NULL,
  `exam_name` varchar(200) DEFAULT NULL,
  `school_name` varchar(200) DEFAULT NULL,
  `exam_center` varchar(200) DEFAULT NULL,
  `left_sign` varchar(200) DEFAULT NULL,
  `middle_sign` varchar(200) DEFAULT NULL,
  `right_sign` varchar(200) DEFAULT NULL,
 `exam_session` int(1) DEFAULT 1,
  `is_name` int(1) DEFAULT 1,
  `is_father_name` int(1) DEFAULT 1,
  `is_mother_name` int(1) DEFAULT 1,
  `is_dob` int(1) DEFAULT 1,
  `is_admission_no` int(1) DEFAULT 1,
  `is_roll_no` int(1) DEFAULT 1,
  `is_photo` int(11) DEFAULT 1,
  `is_division` int(1) NOT NULL DEFAULT 1,
  `is_customfield` int(1) NOT NULL,
  `background_img` varchar(200) DEFAULT NULL,
  `date` varchar(20) DEFAULT NULL,
  `is_class` int(11) NOT NULL DEFAULT '0',
  `is_section` int(11) NOT NULL DEFAULT '0',
  `content` text,
  `content_footer` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `chat_connections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chat_user_one` (`chat_user_one`),
  ADD KEY `chat_user_two` (`chat_user_two`);


ALTER TABLE `chat_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chat_user_id` (`chat_user_id`),
  ADD KEY `chat_connection_id` (`chat_connection_id`);


ALTER TABLE `chat_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `staff_id` (`staff_id`),
  ADD KEY `student_id` (`student_id`),
  ADD KEY `create_staff_id` (`create_staff_id`),
  ADD KEY `create_student_id` (`create_student_id`);


ALTER TABLE `custom_fields`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `custom_field_values`
  ADD PRIMARY KEY (`id`),
  ADD KEY `custom_field_id` (`custom_field_id`);


ALTER TABLE `disable_reason`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `exam_groups`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `exam_group_class_batch_exam_subjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_group_class_batch_exams_id` (`exam_group_class_batch_exams_id`),
  ADD KEY `subject_id` (`subject_id`);

ALTER TABLE `exam_group_exam_connections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_group_id` (`exam_group_id`),
  ADD KEY `exam_group_class_batch_exams_id` (`exam_group_class_batch_exams_id`);


ALTER TABLE `exam_group_exam_results`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_group_class_batch_exam_subject_id` (`exam_group_class_batch_exam_subject_id`),
  ADD KEY `exam_group_student_id` (`exam_group_student_id`),
  ADD KEY `exam_group_class_batch_exam_student_id` (`exam_group_class_batch_exam_student_id`);

ALTER TABLE `fees_reminder`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `onlineexam_attempts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `onlineexam_student_id` (`onlineexam_student_id`);


ALTER TABLE `onlineexam_student_results`
  ADD PRIMARY KEY (`id`),
  ADD KEY `onlineexam_student_id` (`onlineexam_student_id`),
  ADD KEY `onlineexam_question_id` (`onlineexam_question_id`);


ALTER TABLE `permission_parent`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `permission_student`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subject_id` (`subject_id`);


ALTER TABLE `question_answers`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `question_options`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `staff_rating`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_staff_rating_staff` (`staff_id`);


ALTER TABLE `submit_assignment`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `template_admitcards`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `template_marksheets`
  ADD PRIMARY KEY (`id`);




ALTER TABLE `chat_connections`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;


ALTER TABLE `chat_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;


ALTER TABLE `chat_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;


ALTER TABLE `custom_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;


ALTER TABLE `custom_field_values`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;


ALTER TABLE `disable_reason`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;


ALTER TABLE `exam_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;


ALTER TABLE `exam_group_class_batch_exam_subjects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;


ALTER TABLE `exam_group_exam_connections`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;


ALTER TABLE `exam_group_exam_results`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

ALTER TABLE `exam_results`
  MODIFY `updated_at` date DEFAULT NULL;


ALTER TABLE `fees_reminder`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1621;


ALTER TABLE `onlineexam_attempts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;


ALTER TABLE `onlineexam_student_results`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;


ALTER TABLE `permission_parent`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;


ALTER TABLE `permission_student`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;


ALTER TABLE `questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;


ALTER TABLE `question_answers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `question_options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `staff_rating`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;


ALTER TABLE `submit_assignment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;


ALTER TABLE `template_admitcards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;


ALTER TABLE `template_marksheets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;




ALTER TABLE `chat_connections`
  ADD CONSTRAINT `chat_connections_ibfk_1` FOREIGN KEY (`chat_user_one`) REFERENCES `chat_users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chat_connections_ibfk_2` FOREIGN KEY (`chat_user_two`) REFERENCES `chat_users` (`id`) ON DELETE CASCADE;


ALTER TABLE `chat_messages`
  ADD CONSTRAINT `chat_messages_ibfk_1` FOREIGN KEY (`chat_user_id`) REFERENCES `chat_users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chat_messages_ibfk_2` FOREIGN KEY (`chat_connection_id`) REFERENCES `chat_connections` (`id`) ON DELETE CASCADE;


ALTER TABLE `chat_users`
  ADD CONSTRAINT `chat_users_ibfk_1` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chat_users_ibfk_2` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chat_users_ibfk_3` FOREIGN KEY (`create_staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `chat_users_ibfk_4` FOREIGN KEY (`create_student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE;


ALTER TABLE `custom_field_values`
  ADD CONSTRAINT `custom_field_values_ibfk_1` FOREIGN KEY (`custom_field_id`) REFERENCES `custom_fields` (`id`) ON DELETE CASCADE;


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


ALTER TABLE `exam_group_exam_connections`
  ADD CONSTRAINT `exam_group_exam_connections_ibfk_1` FOREIGN KEY (`exam_group_id`) REFERENCES `exam_groups` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exam_group_exam_connections_ibfk_2` FOREIGN KEY (`exam_group_class_batch_exams_id`) REFERENCES `exam_group_class_batch_exams` (`id`) ON DELETE CASCADE;


ALTER TABLE `exam_group_exam_results`
  ADD CONSTRAINT `exam_group_exam_results_ibfk_1` FOREIGN KEY (`exam_group_class_batch_exam_subject_id`) REFERENCES `exam_group_class_batch_exam_subjects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exam_group_exam_results_ibfk_2` FOREIGN KEY (`exam_group_student_id`) REFERENCES `exam_group_students` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exam_group_exam_results_ibfk_3` FOREIGN KEY (`exam_group_class_batch_exam_student_id`) REFERENCES `exam_group_class_batch_exam_students` (`id`) ON DELETE CASCADE;


ALTER TABLE `onlineexam_attempts`
  ADD CONSTRAINT `onlineexam_attempts_ibfk_1` FOREIGN KEY (`onlineexam_student_id`) REFERENCES `onlineexam_students` (`id`) ON DELETE CASCADE;


ALTER TABLE `onlineexam_student_results`
  ADD CONSTRAINT `onlineexam_student_results_ibfk_1` FOREIGN KEY (`onlineexam_student_id`) REFERENCES `onlineexam_students` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `onlineexam_student_results_ibfk_2` FOREIGN KEY (`onlineexam_question_id`) REFERENCES `onlineexam_questions` (`id`) ON DELETE CASCADE;


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


ALTER TABLE `staff_rating`
  ADD CONSTRAINT `FK_staff_rating_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE;




ALTER TABLE attendence_type MODIFY updated_at date NULL;
ALTER TABLE books MODIFY updated_at date NULL;
ALTER TABLE categories MODIFY updated_at date NULL;
ALTER TABLE certificates MODIFY updated_at date NULL;
ALTER TABLE chat_connections MODIFY updated_at date NULL;
ALTER TABLE chat_users MODIFY updated_at date NULL;
ALTER TABLE classes MODIFY updated_at date NULL;
ALTER TABLE class_sections MODIFY updated_at date NULL;
ALTER TABLE contents MODIFY updated_at date NULL;
ALTER TABLE custom_fields MODIFY updated_at date NULL;
ALTER TABLE custom_field_values MODIFY updated_at date NULL;
ALTER TABLE dispatch_receive MODIFY updated_at date NULL;
ALTER TABLE exams MODIFY updated_at date NULL;
ALTER TABLE exam_schedules MODIFY updated_at date NULL;
ALTER TABLE expenses MODIFY updated_at date NULL;
ALTER TABLE expense_head MODIFY updated_at date NULL;
ALTER TABLE feecategory MODIFY updated_at date NULL;
ALTER TABLE feemasters MODIFY updated_at date NULL;
ALTER TABLE fees_reminder MODIFY updated_at date NULL;
ALTER TABLE feetype MODIFY updated_at date NULL;
ALTER TABLE grades MODIFY updated_at date NULL;
ALTER TABLE hostel MODIFY updated_at date NULL;
ALTER TABLE hostel_rooms MODIFY updated_at date NULL;
ALTER TABLE income MODIFY updated_at date NULL;
ALTER TABLE income_head MODIFY updated_at date NULL;
ALTER TABLE item MODIFY updated_at date NULL;
ALTER TABLE item_category MODIFY updated_at date NULL;
ALTER TABLE languages MODIFY updated_at date NULL;
ALTER TABLE messages MODIFY updated_at date NULL;
ALTER TABLE onlineexam_attempts MODIFY updated_at date NULL;
ALTER TABLE onlineexam_student_results MODIFY updated_at date NULL;
ALTER TABLE questions MODIFY updated_at date NULL;
ALTER TABLE read_notification MODIFY updated_at date NULL;
ALTER TABLE roles MODIFY updated_at date NULL;
ALTER TABLE room_types MODIFY updated_at date NULL;
ALTER TABLE sch_settings MODIFY updated_at date NULL;
ALTER TABLE sections MODIFY updated_at date NULL;
ALTER TABLE send_notification MODIFY updated_at date NULL;
ALTER TABLE sessions MODIFY updated_at date NULL;
ALTER TABLE sms_config MODIFY updated_at date NULL;
ALTER TABLE staff_attendance MODIFY updated_at date NULL;
ALTER TABLE staff_attendance_type MODIFY updated_at date NULL;
ALTER TABLE staff_roles MODIFY updated_at date NULL;
ALTER TABLE students MODIFY updated_at date NULL;
ALTER TABLE student_attendences MODIFY updated_at date NULL;
ALTER TABLE student_fees MODIFY updated_at date NULL;
ALTER TABLE student_session MODIFY updated_at date NULL;
ALTER TABLE student_sibling MODIFY updated_at date NULL;
ALTER TABLE subjects MODIFY updated_at date NULL;
ALTER TABLE teacher_subjects MODIFY updated_at date NULL;
ALTER TABLE template_admitcards MODIFY updated_at date NULL;
ALTER TABLE template_marksheets MODIFY updated_at date NULL;
ALTER TABLE timetables MODIFY updated_at date NULL;
ALTER TABLE transport_route MODIFY updated_at date NULL;
ALTER TABLE users MODIFY updated_at date NULL;


drop table `student_transport_fees`;

ALTER TABLE book_issues
ADD duereturn_date date NULL AFTER book_id;


ALTER TABLE homework_evaluation
ADD student_session_id  INT(11) NULL AFTER student_id;



ALTER TABLE item
ADD unit VARCHAR(100) NOT NULL AFTER  name;



ALTER TABLE item_stock
ADD purchase_price VARCHAR(100) NOT NULL AFTER  quantity;




ALTER TABLE languages
ADD short_code VARCHAR(255) NOT NULL AFTER  language,
ADD country_code VARCHAR(255) NOT NULL AFTER  short_code;

ALTER TABLE languages
drop code;



ALTER TABLE notification_setting
ADD template LONGTEXT NOT NULL AFTER  is_sms,
ADD variables TEXT NOT NULL AFTER  template;

ALTER TABLE notification_setting
drop is_notification,
drop display_notification;



ALTER TABLE staff
ADD lang_id INT(11) NOT NULL AFTER  employee_id;


 ALTER TABLE staff MODIFY department int(11) NULL DEFAULT 0;
 ALTER TABLE staff MODIFY designation int(11) NULL DEFAULT 0;



 ALTER TABLE student_fees MODIFY date date NULL;


ALTER TABLE users
ADD lang_id INT(11) NOT NULL AFTER  verification_code;




ALTER TABLE fee_groups_feetype MODIFY `amount` decimal(10,2) DEFAULT NULL AFTER session_id;

ALTER TABLE fee_groups_feetype
ADD  `fine_type` varchar(50) NOT NULL DEFAULT 'none' AFTER amount,
ADD fine_percentage FLOAT(10,2) NOT NULL DEFAULT 0.00 AFTER due_date,
ADD fine_amount FLOAT(10,2) NOT NULL DEFAULT 0.00 AFTER fine_percentage;



ALTER TABLE students
ADD dis_reason INT(11) NOT NULL AFTER  measurement_date,
ADD dis_note TEXT NOT NULL AFTER  note;

 ALTER TABLE students MODIFY admission_date date NULL;
 ALTER TABLE students MODIFY rte varchar(20) NULL DEFAULT NULL;
 ALTER TABLE students MODIFY cast varchar(50) NULL DEFAULT NULL;
 ALTER TABLE students MODIFY dob date NULL DEFAULT NULL;
 ALTER TABLE students MODIFY guardian_email varchar(100) NULL DEFAULT NULL;
 ALTER TABLE students MODIFY note varchar(200) NULL DEFAULT NULL;
 ALTER TABLE students MODIFY dis_note TEXT NOT NULL DEFAULT '';
 ALTER TABLE students MODIFY is_active varchar(255) NULL DEFAULT 'yes';
 ALTER TABLE students MODIFY `note` varchar(200) DEFAULT NULL AFTER dis_reason;
 ALTER TABLE students MODIFY `dis_note` text NOT NULL AFTER note;


ALTER TABLE sch_settings MODIFY `cron_secret_key` varchar(100) NOT NULL AFTER session_id;

ALTER TABLE sch_settings
ADD biometric INT(11) NULL DEFAULT 0 AFTER name,
ADD biometric_device TEXT NULL DEFAULT NULL AFTER biometric,
ADD languages VARCHAR(500) NOT NULL DEFAULT '[\"4\"]' AFTER lang_id,
ADD time_format VARCHAR(255) NOT NULL AFTER date_format,
ADD is_duplicate_fees_invoice INT(1) NULL DEFAULT 0 AFTER is_rtl,
ADD attendence_type INT(10) NULL DEFAULT 0 AFTER start_month,
ADD admin_logo VARCHAR(255) NOT NULL DEFAULT '1.png' AFTER image,
ADD admin_small_logo VARCHAR(255) NOT NULL DEFAULT '1.png' AFTER admin_logo,
ADD adm_auto_insert INT(1) NULL AFTER fee_due_days,
ADD adm_prefix VARCHAR(50) NULL AFTER adm_auto_insert,
ADD adm_start_from VARCHAR(11) NULL AFTER adm_prefix,
ADD adm_no_digit INT(10) NULL AFTER  adm_start_from,
ADD adm_update_status INT(11) NULL AFTER adm_no_digit,
ADD staffid_auto_insert INT(11) NULL AFTER adm_update_status,
ADD staffid_prefix VARCHAR(100) NULL AFTER staffid_auto_insert,
ADD staffid_start_from VARCHAR(50) NULL AFTER staffid_prefix,
ADD staffid_no_digit INT(11) NULL AFTER staffid_start_from,
ADD staffid_update_status INT(11) NULL AFTER  staffid_no_digit,
ADD online_admission INT(1) NULL DEFAULT 0 AFTER is_active,
ADD is_blood_group INT(10) NOT NULL DEFAULT 1 AFTER online_admission,
ADD is_student_house INT(10) NOT NULL DEFAULT 1 AFTER is_blood_group,
ADD roll_no INT(11) NOT NULL DEFAULT '1' AFTER is_student_house,
ADD category INT(11) NOT NULL DEFAULT '1' AFTER roll_no,
ADD religion INT(11) NOT NULL DEFAULT '1' AFTER category,
ADD cast INT(11) NOT NULL DEFAULT '1' AFTER religion,
ADD mobile_no INT(11) NOT NULL DEFAULT '1' AFTER cast,
ADD student_email INT(11) NOT NULL DEFAULT '1' AFTER  mobile_no,
ADD admission_date INT(11) NOT NULL DEFAULT '1' AFTER student_email,
ADD lastname INT(11) NOT NULL DEFAULT '1' AFTER admission_date,
ADD student_photo INT(11) NOT NULL DEFAULT '1' AFTER lastname,
ADD student_height INT(11) NOT NULL DEFAULT '1' AFTER student_photo,
ADD student_weight INT(11) NOT NULL DEFAULT '1' AFTER student_height,
ADD measurement_date INT(11) NOT NULL DEFAULT '1' AFTER student_weight,
ADD father_name INT(11) NOT NULL DEFAULT '1' AFTER measurement_date,
ADD father_phone INT(11) NOT NULL DEFAULT '1' AFTER father_name,
ADD father_occupation INT(11) NOT NULL DEFAULT '1' AFTER father_phone,
ADD father_pic INT(11) NOT NULL DEFAULT '1' AFTER father_occupation,
ADD mother_name INT(11) NOT NULL DEFAULT '1' AFTER father_pic,
ADD mother_phone INT(11) NOT NULL DEFAULT '1' AFTER mother_name,
ADD mother_occupation INT(11) NOT NULL DEFAULT '1' AFTER mother_phone,
ADD mother_pic INT(11) NOT NULL DEFAULT '1' AFTER mother_occupation,
ADD guardian_relation INT(11) NOT NULL DEFAULT '1' AFTER mother_pic,
ADD guardian_email INT(11) NOT NULL DEFAULT '1' AFTER guardian_relation,
ADD guardian_pic INT(11) NOT NULL DEFAULT '1' AFTER guardian_email,
ADD guardian_address INT(11) NOT NULL DEFAULT '1' AFTER guardian_pic,
ADD current_address INT(11) NOT NULL DEFAULT '1' AFTER guardian_address,
ADD permanent_address INT(11) NOT NULL DEFAULT '1' AFTER current_address,
ADD route_list INT(11) NOT NULL DEFAULT '1' AFTER permanent_address,
ADD hostel_id INT(11) NOT NULL DEFAULT '1' AFTER route_list,
ADD bank_account_no INT(11) NOT NULL DEFAULT '1' AFTER hostel_id,
ADD national_identification_no INT(11) NOT NULL DEFAULT '1' AFTER bank_account_no,
ADD local_identification_no INT(11) NOT NULL DEFAULT '1' AFTER national_identification_no,
ADD rte INT(11) NOT NULL DEFAULT '1' AFTER local_identification_no,
ADD previous_school_details INT(11) NOT NULL DEFAULT '1' AFTER rte,
ADD student_note INT(11) NOT NULL DEFAULT '1' AFTER previous_school_details,
ADD upload_documents INT(11) NOT NULL DEFAULT '1' AFTER student_note,
ADD staff_designation INT(11) NOT NULL DEFAULT '1' AFTER upload_documents,
ADD staff_department INT(11) NOT NULL DEFAULT '1' AFTER staff_designation,
ADD staff_last_name INT(11) NOT NULL DEFAULT '1' AFTER staff_department,
ADD staff_father_name INT(11) NOT NULL DEFAULT '1' AFTER staff_last_name,
ADD staff_mother_name INT(11) NOT NULL DEFAULT '1' AFTER staff_father_name,
ADD staff_date_of_joining INT(11) NOT NULL DEFAULT '1' AFTER staff_mother_name,
ADD staff_phone INT(11) NOT NULL DEFAULT '1' AFTER staff_date_of_joining,
ADD staff_emergency_contact INT(11) NOT NULL DEFAULT '1' AFTER staff_phone,
ADD staff_marital_status INT(11) NOT NULL DEFAULT '1' AFTER staff_emergency_contact,
ADD staff_photo INT(11) NOT NULL DEFAULT '1' AFTER staff_marital_status,
ADD staff_current_address INT(11) NOT NULL DEFAULT '1' AFTER staff_photo,
ADD staff_permanent_address INT(11) NOT NULL DEFAULT '1' AFTER staff_current_address,
ADD staff_qualification INT(11) NOT NULL DEFAULT '1' AFTER staff_permanent_address,
ADD staff_work_experience INT(11) NOT NULL DEFAULT '1' AFTER staff_qualification,
ADD staff_note INT(11) NOT NULL DEFAULT '1' AFTER staff_work_experience,
ADD staff_epf_no INT(11) NOT NULL DEFAULT '1' AFTER staff_note,
ADD staff_basic_salary INT(11) NOT NULL DEFAULT '1' AFTER staff_epf_no,
ADD staff_contract_type INT(11) NOT NULL DEFAULT '1' AFTER staff_basic_salary,
ADD staff_work_shift INT(11) NOT NULL DEFAULT '1' AFTER staff_contract_type,
ADD staff_work_location INT(11) NOT NULL DEFAULT '1' AFTER staff_work_shift,
ADD staff_leaves INT(11) NOT NULL DEFAULT '1' AFTER staff_work_location,
ADD staff_account_details INT(11) NOT NULL DEFAULT '1' AFTER staff_leaves,
ADD staff_social_media INT(11) NOT NULL DEFAULT '1' AFTER staff_account_details,
ADD staff_upload_documents INT(11) NOT NULL DEFAULT '1' AFTER staff_social_media,
ADD `currency_place` varchar(50) NOT NULL DEFAULT 'before_number' AFTER cron_secret_key;


  ALTER TABLE sch_settings MODIFY `attendence_type` int(10) NOT NULL DEFAULT '0';
  ALTER TABLE sch_settings MODIFY `fee_due_days` int(3) DEFAULT '0' AFTER theme;
  ALTER TABLE sch_settings MODIFY `adm_auto_insert` int(1) DEFAULT NULL AFTER fee_due_days;
  ALTER TABLE sch_settings MODIFY `adm_prefix` varchar(50) DEFAULT NULL AFTER adm_auto_insert;
  ALTER TABLE sch_settings MODIFY `adm_start_from` varchar(11) DEFAULT NULL AFTER adm_prefix;
  ALTER TABLE sch_settings MODIFY `adm_no_digit` int(10) DEFAULT NULL AFTER adm_start_from;
  ALTER TABLE sch_settings MODIFY `adm_update_status` int(11) DEFAULT NULL AFTER adm_no_digit;
  ALTER TABLE sch_settings MODIFY `staffid_auto_insert` int(11) DEFAULT NULL AFTER adm_update_status;
  ALTER TABLE sch_settings MODIFY `staffid_prefix` varchar(100) DEFAULT NULL AFTER staffid_auto_insert;
  ALTER TABLE sch_settings MODIFY `staffid_start_from` varchar(50) DEFAULT NULL AFTER staffid_prefix;
  ALTER TABLE sch_settings MODIFY `staffid_no_digit` int(11) DEFAULT NULL AFTER staffid_start_from;
  ALTER TABLE sch_settings MODIFY `staffid_update_status` int(11) DEFAULT NULL AFTER staffid_no_digit;
  ALTER TABLE sch_settings MODIFY `mobile_api_url` TEXT NOT NULL AFTER staff_upload_documents;
  ALTER TABLE sch_settings MODIFY `app_primary_color_code` varchar(20) DEFAULT NULL AFTER mobile_api_url;
  ALTER TABLE sch_settings MODIFY `app_secondary_color_code` varchar(20) DEFAULT NULL AFTER app_primary_color_code;
  ALTER TABLE sch_settings MODIFY `app_logo` varchar(250) DEFAULT NULL AFTER app_secondary_color_code;

  ALTER TABLE sch_settings MODIFY  `class_teacher` varchar(100) NOT NULL AFTER currency_place;
  ALTER TABLE sch_settings MODIFY  `fee_due_days` int(3) DEFAULT '0' AFTER theme;


ALTER TABLE student_attendences
ADD biometric_attendence INT(1) NOT NULL DEFAULT '0' AFTER student_session_id,
ADD biometric_device_data TEXT NULL DEFAULT NULL AFTER remark;


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



ALTER TABLE grades
ADD exam_type VARCHAR(250) NULL AFTER id;


ALTER TABLE homework
ADD session_id INT(10) NOT NULL AFTER section_id,
ADD subject_group_subject_id INT(11) NOT NULL AFTER staff_id,
ADD evaluation_date date NOT NULL AFTER create_date;






ALTER TABLE `homework`
ADD CONSTRAINT `subject_group_subject_id` FOREIGN KEY (`subject_group_subject_id`) REFERENCES `subject_group_subjects` (`id`) ON DELETE CASCADE;




ALTER TABLE `staff_attendance`
ADD CONSTRAINT `FK_staff_attendance_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `FK_staff_attendance_staff_attendance_type` FOREIGN KEY (`staff_attendance_type_id`) REFERENCES `staff_attendance_type` (`id`) ON DELETE CASCADE;





ALTER TABLE `staff_leave_details`

  ADD CONSTRAINT `FK_staff_leave_details_leave_types` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_staff_leave_details_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE;



ALTER TABLE `staff_leave_request`  
  ADD CONSTRAINT `FK_staff_leave_request_leave_types` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_staff_leave_request_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE;




ALTER TABLE `staff_payslip`
  ADD CONSTRAINT `FK_staff_payslip_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE;



ALTER TABLE `staff_roles`
  ADD CONSTRAINT `FK_staff_roles_roles` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_staff_roles_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE;



ALTER TABLE `staff_timeline`
  ADD CONSTRAINT `FK_staff_timeline_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE;



ALTER TABLE `student_session`
  ADD CONSTRAINT `student_session_ibfk_1` FOREIGN KEY (`session_id`) REFERENCES `sessions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `student_session_ibfk_2` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `student_session_ibfk_3` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `student_session_ibfk_4` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE;



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


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`;

truncate table notification_setting;
 
INSERT INTO `notification_setting` (`id`, `type`, `is_mail`, `is_sms`, `is_notification`, `display_notification`, `template`, `variables`, `created_at`) VALUES
(1, 'student_admission', '1', '1', 0, 0, 'Dear {{firstname}} {{lastname}} your admission is confirm in Class: {{class}} Section:  {{section}} for Session: {{current_session_name}} for more detail contact System Admin\r\n{{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}}', '{{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}}', '2020-02-01 08:58:40'),
(2, 'exam_result', '1', '1', 1, 1, 'Dear {{student_name}} - {{exam_roll_no}}, your {{exam}} result has been published.', '{{student_name}} {{exam_name}} {{total_marks}} {{achive_marks}} {{result}}', '2020-01-20 16:09:22'),
(3, 'fee_submission', '0', '1', 1, 1, 'Dear parents, we have received  Fees Amount {{fee_amount}} for  {{firstname}} {{lastname}}  by Your School Name', ' {{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}}', '2020-02-08 17:23:20'),
(4, 'absent_attendence', '1', '1', 1, 1, 'Absent Notice :{{firstname}} {{lastname}}  was absent on date {{date}} in period {{subject_name}} {{subject_code}} {{subject_type}} from Your School Name', '{{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}} ', '2020-02-08 17:33:13'),
(5, 'login_credential', '1', '1', 0, 0, 'Hello {{display_name}} your login details for Url: {{url}} Username: {{username}}  Password: {{password}}', '{{url}} {{display_name}} {{username}} {{password}}', '2020-02-08 15:55:33'),
(6, 'homework', '0', '1', 1, 1, 'New Homework has been created for {{student_name}} at {{homework_date}} for the class {{class}} {{section}} {{subject}}. kindly submit your homework before {{submit_date}} .Thank you', '{{homework_date}} {{submit_date}} {{class}} {{section}} {{subject}} {{student_name}}', '2020-02-08 15:55:33'),
(7, 'fees_reminder', '1', '1', 1, 1, 'Dear parents, please pay fee amount Rs.{{due_amount}} of {{fee_type}} before {{due_date}} for {{firstname}} {{lastname}} from smart school (ignore if you already paid)', '{{fee_type}}{{fee_code}}{{due_date}}{{firstname}} {{lastname}}{{school_name}}{{fee_amount}}{{due_amount}}{{deposit_amount}}', '2020-02-08 15:55:33');


CREATE TABLE `print_headerfooter` (
  `id` int(11) 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-28 15:41:08'),
(2, 'student_receipt', 'header_image.jpg', 'This receipt is computer generated hence no signature is required.', 1, '2020-02-28 15:40:58');


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 `fees_reminder` (`id`, `reminder_type`, `day`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'before', 2, 0, '2019-09-03 11:31:23', '2019-09-03'),
(2, 'before', 5, 0, '2019-12-02 05:09:33', '2019-12-02'),
(3, 'after', 2, 0, '2019-09-04 11:45:29', '2019-09-04'),
(4, 'after', 5, 0, '2019-12-02 05:09:33', '2019-12-02');


truncate table `languages`;

INSERT INTO `languages` (`id`, `language`, `short_code`, `country_code`, `is_deleted`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Azerbaijan', 'az', 'az', 'no', 'no', '2019-11-20 11:23:12', '0000-00-00'),
(2, 'Albanian', 'sq', 'al', 'no', 'no', '2019-11-20 11:42:42', '0000-00-00'),
(3, 'Amharic', 'am', 'am', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(4, 'English', 'en', 'us', 'no', 'no', '2019-11-20 11:38:50', '0000-00-00'),
(5, 'Arabic', 'ar', 'sa', 'no', 'no', '2019-11-20 11:47:28', '0000-00-00'),
(7, 'Afrikaans', 'af', 'af', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(8, 'Basque', 'eu', 'es', 'no', 'no', '2019-11-20 11:54:10', '0000-00-00'),
(11, 'Bengali', 'bn', 'in', 'no', 'no', '2019-11-20 11:41:53', '0000-00-00'),
(13, 'Bosnian', 'bs', 'bs', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(14, 'Welsh', 'cy', 'cy', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(15, 'Hungarian', 'hu', 'hu', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(16, 'Vietnamese', 'vi', 'vi', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(17, 'Haitian (Creole)', 'ht', 'ht', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(18, 'Galician', 'gl', 'gl', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(19, 'Dutch', 'nl', 'nl', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(21, 'Greek', 'el', 'gr', 'no', 'no', '2019-11-20 12:12:08', '0000-00-00'),
(22, 'Georgian', 'ka', 'ge', 'no', 'no', '2019-11-20 12:11:40', '0000-00-00'),
(23, 'Gujarati', 'gu', 'in', 'no', 'no', '2019-11-20 11:39:16', '0000-00-00'),
(24, 'Danish', 'da', 'dk', 'no', 'no', '2019-11-20 12:03:25', '0000-00-00'),
(25, 'Hebrew', 'he', 'il', 'no', 'no', '2019-11-20 12:13:50', '0000-00-00'),
(26, 'Yiddish', 'yi', 'il', 'no', 'no', '2019-11-20 12:25:33', '0000-00-00'),
(27, 'Indonesian', 'id', 'id', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(28, 'Irish', 'ga', 'ga', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(29, 'Italian', 'it', 'it', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(30, 'Icelandic', 'is', 'is', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(31, 'Spanish', 'es', 'es', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(33, 'Kannada', 'kn', 'kn', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(34, 'Catalan', 'ca', 'ca', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(36, 'Chinese', 'zh', 'cn', 'no', 'no', '2019-11-20 12:01:48', '0000-00-00'),
(37, 'Korean', 'ko', 'kr', 'no', 'no', '2019-11-20 12:19:09', '0000-00-00'),
(38, 'Xhosa', 'xh', 'ls', 'no', 'no', '2019-11-20 12:24:39', '0000-00-00'),
(39, 'Latin', 'la', 'la', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(40, 'Latvian', 'lv', 'lv', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(41, 'Lithuanian', 'lt', 'lt', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(43, 'Malagasy', 'mg', 'mg', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(44, 'Malay', 'ms', 'ms', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(45, 'Malayalam', 'ml', 'ml', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(46, 'Maltese', 'mt', 'mt', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(47, 'Macedonian', 'mk', 'mk', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(48, 'Maori', 'mi', 'nz', 'no', 'no', '2019-11-20 12:20:27', '0000-00-00'),
(49, 'Marathi', 'mr', 'in', 'no', 'no', '2019-11-20 11:39:51', '0000-00-00'),
(51, 'Mongolian', 'mn', 'mn', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(52, 'German', 'de', 'de', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(53, 'Nepali', 'ne', 'ne', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(54, 'Norwegian', 'no', 'no', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(55, 'Punjabi', 'pa', 'in', 'no', 'no', '2019-11-20 11:40:16', '0000-00-00'),
(57, 'Persian', 'fa', 'ir', 'no', 'no', '2019-11-20 12:21:17', '0000-00-00'),
(59, 'Portuguese', 'pt', 'pt', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(60, 'Romanian', 'ro', 'ro', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(61, 'Russian', 'ru', 'ru', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(62, 'Cebuano', 'ceb', 'ph', 'no', 'no', '2019-11-20 11:59:12', '0000-00-00'),
(64, 'Sinhala', 'si', 'si', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(65, 'Slovakian', 'sk', 'sk', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(66, 'Slovenian', 'sl', 'sl', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(67, 'Swahili', 'sw', 'ke', 'no', 'no', '2019-11-20 12:21:57', '0000-00-00'),
(68, 'Sundanese', 'su', 'sd', 'no', 'no', '2019-12-03 11:06:57', '0000-00-00'),
(70, 'Thai', 'th', 'th', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(71, 'Tagalog', 'tl', 'tl', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(72, 'Tamil', 'ta', 'in', 'no', 'no', '2019-11-20 11:40:53', '0000-00-00'),
(74, 'Telugu', 'te', 'in', 'no', 'no', '2019-11-20 11:41:15', '0000-00-00'),
(75, 'Turkish', 'tr', 'tr', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(77, 'Uzbek', 'uz', 'uz', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(79, 'Urdu', 'ur', 'pk', 'no', 'no', '2019-11-20 12:23:57', '0000-00-00'),
(80, 'Finnish', 'fi', 'fi', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(81, 'French', 'fr', 'fr', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(82, 'Hindi', 'hi', 'in', 'no', 'no', '2019-11-20 11:36:34', '0000-00-00'),
(84, 'Czech', 'cs', 'cz', 'no', 'no', '2019-11-20 12:02:36', '0000-00-00'),
(85, 'Swedish', 'sv', 'sv', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(86, 'Scottish', 'gd', 'gd', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(87, 'Estonian', 'et', 'et', 'no', 'no', '2019-11-20 11:24:23', '0000-00-00'),
(88, 'Esperanto', 'eo', 'br', 'no', 'no', '2019-11-21 04:49:18', '0000-00-00'),
(89, 'Javanese', 'jv', 'id', 'no', 'no', '2019-11-20 12:18:29', '0000-00-00'),
(90, 'Japanese', 'ja', 'jp', 'no', 'no', '2019-11-20 12:14:39', '0000-00-00');


INSERT INTO `permission_parent` (`id`, `group_id`, `name`, `short_code`, `is_active`, `system`, `created_at`) VALUES
(1, 2, 'Fees', 'fees', 1, 0, '2019-12-01 14:08:13'),
(2, 7, 'Class Timetable', 'class_timetable', 1, 1, '2019-12-01 07:46:35'),
(3, 19, 'Homework', 'homework', 1, 0, '2019-12-01 07:46:44'),
(4, 8, 'Download Center', 'download_center', 1, 0, '2019-12-01 07:46:52'),
(5, 5, 'Attendance', 'attendance', 1, 0, '2019-12-01 07:47:03'),
(7, 6, 'Examinations', 'examinations', 1, 0, '2019-12-01 07:43:17'),
(8, 13, 'Notice Board', 'notice_board', 1, 0, '2019-12-01 07:47:12'),
(11, 9, 'Library', 'library', 1, 0, '2019-12-01 07:47:18'),
(12, 11, 'Transport Routes', 'transport_routes', 1, 0, '2019-12-01 07:47:26'),
(13, 12, 'Hostel Rooms', 'hostel_rooms', 1, 0, '2019-12-01 07:47:34'),
(14, 21, 'Calendar To Do List', 'calendar_to_do_list', 1, 0, '2019-12-01 07:47:40'),
(15, 0, 'Teachers Rating', 'teachers_rating', 1, 0, '2019-12-01 07:47:49');


INSERT INTO `permission_student` (`id`, `name`, `short_code`, `is_active`, `system`, `group_id`, `created_at`) VALUES
(1, 'Fees', 'fees', 1, 0, 2, '2019-12-01 07:55:37'),
(2, 'Class Timetable', 'class_timetable', 1, 1, 7, '2019-12-01 07:40:07'),
(3, 'Homework', 'homework', 1, 0, 19, '2019-12-01 07:40:18'),
(4, 'Download Center', 'download_center', 1, 0, 8, '2019-12-01 07:40:30'),
(5, 'Attendance', 'attendance', 1, 0, 5, '2019-12-01 07:40:38'),
(7, 'Examinations', 'examinations', 1, 0, 6, '2019-12-06 07:55:30'),
(8, 'Notice Board', 'notice_board', 1, 0, 13, '2019-12-01 07:40:46'),
(11, 'Library', 'library', 1, 0, 9, '2019-12-01 07:40:52'),
(12, 'Transport Routes', 'transport_routes', 1, 0, 11, '2019-12-01 07:40:58'),
(13, 'Hostel Rooms', 'hostel_rooms', 1, 0, 12, '2019-12-01 07:41:04'),
(14, 'Calendar To Do List', 'calendar_to_do_list', 1, 0, 21, '2019-12-01 07:41:09'),
(15, 'Online Examination', 'online_examination', 1, 0, 23, '2019-12-01 07:41:21'),
(16, 'Teachers Rating', 'teachers_rating', 1, 0, 0, '2019-12-01 07:41:31'),
(17, 'Chat', 'chat', 1, 0, 25, '2019-12-01 07:50:25'),
(18, 'Multi Class', 'multi_class', 1, 0, 26, '2019-12-01 07:50:28');


INSERT INTO `template_admitcards` (`id`, `template`, `heading`, `title`, `left_logo`, `right_logo`, `exam_name`, `school_name`, `exam_center`, `sign`, `background_img`, `is_name`, `is_father_name`, `is_mother_name`, `is_dob`, `is_admission_no`, `is_roll_no`, `is_address`, `is_gender`, `is_photo`, `is_class`, `is_section`, `content_footer`, `created_at`, `updated_at`) VALUES
(1, 'Sample Admit Card', 'BOARD OF SECONDARY EDUCATION, MADHYA PRADESH, BHOPAL', 'HIGHER SECONDARY SCHOOL CERTIFICATE EXAMINATION (10+2) 2014', 'ab12c4b65f53ee621dcf84370a7c5be4.png', '0910482bf79df5fd103e8383d61b387a.png', 'Test', 'Mount Carmel School', 'test dmit card2', 'aa9c7087e68c5af1d2c04946de1d3bd3.png', '782a71f53ea6bca213012d49e9d46d98.jpg', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-02-28 14:26:15', NULL);

INSERT INTO `template_marksheets` (`id`, `template`, `heading`, `title`, `left_logo`, `right_logo`, `exam_name`, `school_name`, `exam_center`, `left_sign`, `middle_sign`, `right_sign`, `exam_session`, `is_name`, `is_father_name`, `is_mother_name`, `is_dob`, `is_admission_no`, `is_roll_no`, `is_photo`, `is_division`, `is_customfield`, `background_img`, `date`, `is_class`, `is_section`, `content`, `content_footer`, `created_at`, `updated_at`) VALUES
(1, 'Sample Marksheet', 'BOARD OF SECONDARY EDUCATION, MADHYA PRADESH, BHOPAL', 'BOARD OF SECONDARY EDUCATION, MADHYA PRADESH, BHOPAL', 'f314cec3f688771ccaeddbcee6e52f7c.png', 'e824b2df53266266be2dbfd2001168b8.png', 'HIGHER SECONDARY SCHOOL CERTIFICATE EXAMINATION', 'Mount Carmel School', 'GOVT GIRLS H S SCHOOL', '331e0690e50f8c6b7a219a0a2b9667f7.png', '351f513d79ee5c0f642c2d36514a1ff4.png', 'fb79d2c0d163357d1706b78550a05e2c.png', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '', NULL, 0, 0, NULL, NULL, '2020-02-28 14:26:06', NULL);

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



ALTER TABLE `certificates`
  MODIFY  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
