-- Table structure for table `library_members`
--

CREATE TABLE IF NOT EXISTS `library_members` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `custom_member_id` varchar(20) CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `library_members`
--

INSERT INTO `library_members` (`id`, `user_id`, `custom_member_id`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(5, 81, 'LM00005', 1, '2018-02-11 10:35:31', '0000-00-00 00:00:00', 1, 0),
(2, 75, 'LM00002', 1, '2018-02-11 10:33:24', '0000-00-00 00:00:00', 1, 0),
(3, 76, 'LM00003', 1, '2018-02-11 10:33:28', '0000-00-00 00:00:00', 1, 0),
(4, 77, 'LM00004', 1, '2018-02-11 10:33:31', '0000-00-00 00:00:00', 1, 0),
(6, 79, 'LM00006', 1, '2018-02-11 10:35:43', '0000-00-00 00:00:00', 1, 0),
(7, 86, 'LM00007', 1, '2018-02-11 10:35:55', '0000-00-00 00:00:00', 1, 0),
(8, 88, 'LM00008', 1, '2018-02-11 10:36:02', '0000-00-00 00:00:00', 1, 0),
(9, 83, 'LM00009', 1, '2018-02-11 10:37:11', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `marks`
--

CREATE TABLE IF NOT EXISTS `marks` (
  `id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `grade_id` int(11) NOT NULL,
  `exam_mark` int(11) NOT NULL,
  `obtain_mark` int(11) NOT NULL,
  `remark` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `marks`
--

INSERT INTO `marks` (`id`, `exam_id`, `class_id`, `section_id`, `subject_id`, `academic_year_id`, `student_id`, `grade_id`, `exam_mark`, `obtain_mark`, `remark`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 1, 1, 1, 2, 1, 1, 100, 80, '', 1, '2018-02-24 02:14:41', '0000-00-00 00:00:00', 1, 0),
(2, 1, 1, 1, 1, 2, 2, 1, 100, 90, '', 1, '2018-02-24 02:14:41', '0000-00-00 00:00:00', 1, 0),
(3, 1, 1, 1, 1, 2, 3, 2, 100, 70, '', 1, '2018-02-24 02:14:41', '0000-00-00 00:00:00', 1, 0),
(4, 1, 1, 1, 1, 2, 4, 3, 100, 60, '', 1, '2018-02-24 02:14:41', '0000-00-00 00:00:00', 1, 0),
(5, 1, 1, 1, 1, 2, 5, 1, 100, 85, '', 1, '2018-02-24 02:14:41', '0000-00-00 00:00:00', 1, 0),
(6, 1, 1, 11, 1, 2, 6, 0, 0, 0, NULL, 1, '2018-02-11 08:27:30', '0000-00-00 00:00:00', 1, 0),
(7, 1, 1, 11, 1, 2, 7, 0, 0, 0, NULL, 1, '2018-02-11 08:27:30', '0000-00-00 00:00:00', 1, 0),
(8, 1, 1, 11, 1, 2, 8, 0, 0, 0, NULL, 1, '2018-02-11 08:27:30', '0000-00-00 00:00:00', 1, 0),
(9, 1, 1, 11, 1, 2, 9, 0, 0, 0, NULL, 1, '2018-02-11 08:27:30', '0000-00-00 00:00:00', 1, 0),
(10, 1, 1, 11, 1, 2, 10, 0, 0, 0, NULL, 1, '2018-02-11 08:27:30', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `mark_emails`
--

CREATE TABLE IF NOT EXISTS `mark_emails` (
  `id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `receiver_role_id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `sender_role_id` int(11) NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8 NOT NULL,
  `note` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mark_emails`
--

INSERT INTO `mark_emails` (`id`, `exam_id`, `class_id`, `receiver_role_id`, `academic_year_id`, `sender_role_id`, `subject`, `note`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 1, 3, 2, 2, 'First Term Exam Marks', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-14 04:01:26', '0000-00-00 00:00:00', 44, 0);

-- --------------------------------------------------------

--
-- Table structure for table `mark_smses`
--

CREATE TABLE IF NOT EXISTS `mark_smses` (
  `id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `receiver_role_id` int(11) NOT NULL,
  `sms_gateway` varchar(50) CHARACTER SET utf8 NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `sender_role_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mark_smses`
--

INSERT INTO `mark_smses` (`id`, `exam_id`, `class_id`, `receiver_role_id`, `sms_gateway`, `academic_year_id`, `sender_role_id`, `status`, `created_at`, `created_by`) VALUES
(1, 1, 1, 3, 'twilio', 2, 2, 1, '2018-02-14 04:04:03', 44);

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8 NOT NULL,
  `body` text CHARACTER SET utf8 NOT NULL,
  `attachment` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `academic_year_id`, `subject`, `body`, `attachment`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 2, 'Lorem Ipsum is simply dummy text', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '', 1, '2018-02-14 01:13:19', '0000-00-00 00:00:00', 1, 0),
(2, 2, ' Lorem Ipsum has been the industry''s standard', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '', 1, '2018-02-14 01:14:24', '0000-00-00 00:00:00', 1, 0),
(3, 2, 'There are many variations of passages of Lorem Ipsum', 'There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don''t look even slightly believable.', '', 1, '2018-02-14 02:37:20', '0000-00-00 00:00:00', 1, 0),
(4, 2, 'Contrary to popular belief, Lorem Ipsum', 'There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don''t look even slightly believable.', '', 1, '2018-02-14 02:38:22', '0000-00-00 00:00:00', 1, 0),
(5, 2, 'Contrary to popular belief, Lorem Ipsum is not simply random', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage', '', 1, '2018-02-14 02:56:13', '0000-00-00 00:00:00', 44, 0);

-- --------------------------------------------------------

--
-- Table structure for table `message_relationships`
--

CREATE TABLE IF NOT EXISTS `message_relationships` (
  `id` int(11) NOT NULL,
  `message_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `is_trash` tinyint(1) NOT NULL,
  `is_draft` smallint(1) NOT NULL,
  `is_favorite` tinyint(1) NOT NULL,
  `is_read` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `message_relationships`
--

INSERT INTO `message_relationships` (`id`, `message_id`, `sender_id`, `receiver_id`, `owner_id`, `role_id`, `is_trash`, `is_draft`, `is_favorite`, `is_read`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 1, 44, 1, 1, 0, 0, 0, 0, 1, '2018-02-14 01:13:19', '0000-00-00 00:00:00', 1, 0),
(2, 1, 1, 44, 44, 2, 0, 0, 0, 0, 1, '2018-02-14 01:13:19', '0000-00-00 00:00:00', 1, 0),
(3, 2, 1, 64, 1, 1, 0, 0, 0, 0, 1, '2018-02-14 01:14:25', '0000-00-00 00:00:00', 1, 0),
(4, 2, 1, 64, 64, 3, 0, 0, 0, 0, 1, '2018-02-14 01:14:25', '0000-00-00 00:00:00', 1, 0),
(5, 3, 1, 43, 1, 9, 0, 1, 0, 0, 1, '2018-02-14 02:37:20', '0000-00-00 00:00:00', 1, 0),
(6, 4, 1, 49, 1, 1, 1, 0, 0, 0, 1, '2018-02-14 02:38:22', '0000-00-00 00:00:00', 1, 0),
(7, 4, 1, 49, 49, 7, 0, 0, 0, 0, 1, '2018-02-14 02:38:22', '0000-00-00 00:00:00', 1, 0),
(8, 5, 44, 1, 44, 2, 0, 0, 0, 0, 1, '2018-02-14 02:56:13', '0000-00-00 00:00:00', 44, 0),
(9, 5, 44, 1, 1, 1, 0, 0, 0, 0, 1, '2018-02-14 02:56:13', '0000-00-00 00:00:00', 44, 0);

-- --------------------------------------------------------

--
-- Table structure for table `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
  `id` int(11) NOT NULL,
  `module_name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `module_slug` varchar(50) CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `module_name`, `module_slug`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 'Setting', 'setting', 1, '2017-11-13 22:55:19', '2017-11-13 22:57:10', 1, 1),
(2, 'Theme', 'theme', 1, '2017-12-12 13:34:52', '0000-00-00 00:00:00', 1, 0),
(3, 'Language', 'language', 1, '2017-12-12 13:36:11', '0000-00-00 00:00:00', 1, 0),
(4, 'Administrator', 'administrator', 1, '2017-12-12 13:36:35', '0000-00-00 00:00:00', 1, 0),
(5, 'Human Resource', 'hrm', 1, '2017-12-12 13:38:30', '0000-00-00 00:00:00', 1, 0),
(6, 'Teacher', 'teacher', 1, '2017-12-12 13:39:01', '0000-00-00 00:00:00', 1, 0),
(7, 'Academic Activity', 'academic', 1, '2017-12-12 13:42:24', '0000-00-00 00:00:00', 1, 0),
(8, 'Guardian', 'guardian', 1, '2017-12-12 13:43:01', '0000-00-00 00:00:00', 1, 0),
(9, 'Student', 'student', 1, '2017-12-12 13:43:28', '0000-00-00 00:00:00', 1, 0),
(10, 'Attendance', 'attendance', 1, '2017-12-12 13:45:03', '0000-00-00 00:00:00', 1, 0),
(11, 'Assignment', 'assignment', 1, '2017-12-12 13:45:45', '0000-00-00 00:00:00', 1, 0),
(12, 'Exam', 'exam', 1, '2017-12-12 13:46:13', '0000-00-00 00:00:00', 1, 0),
(14, 'Library', 'library', 1, '2017-12-12 13:46:33', '0000-00-00 00:00:00', 1, 0),
(15, 'Transport', 'transport', 1, '2017-12-12 13:46:52', '0000-00-00 00:00:00', 1, 0),
(16, 'Hostel', 'hostel', 1, '2017-12-12 13:47:15', '0000-00-00 00:00:00', 1, 0),
(17, 'Message, Email & SMS', 'message', 1, '2017-12-12 13:47:48', '2017-12-14 08:48:49', 1, 1),
(18, 'Announcement', 'announcement', 1, '2017-12-12 13:48:23', '0000-00-00 00:00:00', 1, 0),
(19, 'Event', 'event', 1, '2017-12-12 13:48:36', '0000-00-00 00:00:00', 1, 0),
(20, 'Visitor Info', 'visitor', 1, '2017-12-12 13:49:05', '0000-00-00 00:00:00', 1, 0),
(21, 'Accounting', 'accounting', 1, '2017-12-12 13:49:32', '0000-00-00 00:00:00', 1, 0),
(22, 'Report', 'report', 1, '2017-12-12 13:51:09', '0000-00-00 00:00:00', 1, 0),
(13, 'Exam Mark', 'exam', 1, '2017-12-14 00:00:00', '2017-12-14 09:07:46', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `date` date NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `news` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `date`, `image`, `news`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 'School Magazine', '2018-03-01', 'news-1518603269-sms.jpg', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage', 1, '2018-02-14 03:11:28', '2018-02-14 03:57:21', 1, 44),
(2, 'School Admission', '2018-01-08', 'news-1518628816-sms.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.', 1, '2018-02-14 03:17:20', '2018-02-14 10:20:16', 1, 1),
(3, 'Daily Education', '2018-03-09', 'news-1518628922-sms.jpg', 'Lorem Ipsum ei ole vain sattumanvarainen teksti.', 1, '2018-02-14 06:39:00', '2018-02-14 10:22:02', 1, 1),
(4, 'WU Wins Exclusive Course of the Year Award', '2018-03-10', NULL, 'Lorem Ipsum on yksinkertaisesti testausteksti,', 1, '2018-02-14 06:58:00', '0000-00-00 00:00:00', 1, 0),
(5, 'MSc Chemical Engineering Class of 2017 graduation celebrations', '2018-03-08', NULL, 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 1, '2018-02-14 08:32:36', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `notices`
--

CREATE TABLE IF NOT EXISTS `notices` (
  `id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `date` date NOT NULL,
  `notice` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` (`id`, `role_id`, `title`, `date`, `notice`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 4, 'First Term Exam', '2018-04-05', 'Lorem Ipsum on yksinkertaisesti testausteksti, jota tulostus- ja ladontateollisuudet käyttävät. Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti, jolloin tuntematon tulostaja otti kaljuunan ja sekoitti sen tehdäkseen esimerkkikirjan. Se ei ole selvinnyt vain viittä vuosisataa, mutta myös loikan elektroniseen kirjoitukseen, jääden suurinpiirtein muuntamattomana. Se tuli kuuluisuuteen 1960-luvulla kun Letraset-paperiarkit, joissa oli Lorem Ipsum pätkiä, julkaistiin ja vielä myöhemmin tietokoneen julkistusohjelmissa, kuten Aldus PageMaker joissa oli versioita Lorem Ipsumista.', 1, '2018-02-14 02:09:54', '0000-00-00 00:00:00', 1, 0),
(2, 5, 'Meeting', '2018-02-14', 'Lorem Ipsum ei ole vain sattumanvarainen teksti. Sillä on pitkät juuret klassisesta latinalaisesta kirjallisuudesta vuonna 45 eKr alkaen, tehden siitä yli 2000 vuotta vanhan. Richard McClintock, latinalainen professori Hampden-Sydneyn yliopistossa Virginiassa, etsi yhden vaikeaselkoisimmista latinalaisista sanoista, consectetur, Lorem Ipsumin kappaleesta ja etsi lainauksia sanasta klassisessa kirjallisuudessa löytäen varman lähteen. Lorem Ipsum tulee osista 1.10.32 ja 1.10.33 "de Finibus Bonorum et Malorum":ksesta (The Extremes of Good and Evil), jonka teki Cicero vuonna 45 eKr. Tämä kirja on tutkielma etiikasta, joka oli hyvin yleistä Renesanssin aikana. Ensimmäinen Lorem Ipsumin rivi, "Lorem ipsum dolor sit amet..", tulee rivistä joka on osassa 1.10.32.', 1, '2018-02-14 02:14:14', '0000-00-00 00:00:00', 1, 0),
(3, 0, 'Holiday', '2018-03-01', 'Lorem Ipsumia'' etsittäessä löytyy monen monta nettisivua, jotka ovat vasta aluillaan. Useita versioita on muodostunut vuosien kuluessa, jotkut vahingossa ja jotkut tarkoituksella (lisätty huumoria ja niin edelleen).', 1, '2018-02-14 02:20:05', '0000-00-00 00:00:00', 1, 0),
(4, 4, 'Sport', '2018-04-01', 'Lorem Ipsumin käytön tarkoitus on, että se omaa enemmän-tai-vähemmän normaalimpaa sanojen sijoitusta kuin ''Sisältöä tähän, sisältöä tähän''.', 1, '2018-02-14 02:25:33', '0000-00-00 00:00:00', 1, 0),
(5, 4, 'Sports Competition', '2018-03-07', 'Lorem Ipsumia'' etsittäessä löytyy monen monta nettisivua, jotka ovat vasta aluillaan. Useita versioita on muodostunut vuosien kuluessa, jotkut vahingossa ja jotkut tarkoituksella (lisätty huumoria ja niin edelleen).', 1, '2018-02-14 02:28:07', '0000-00-00 00:00:00', 1, 0),
(6, 0, 'Celebration Party', '2018-06-09', 'Lorem Ipsum tulee osista 1.10.32 ja 1.10.33 "de Finibus Bonorum et Malorum":ksesta (The Extremes of Good and Evil), jonka teki Cicero vuonna 45 eKr. Tämä kirja on tutkielma etiikasta, joka oli hyvin yleistä Renesanssin aikana. Ensimmäinen Lorem Ipsumin rivi, "Lorem ipsum dolor sit amet..", tulee rivistä joka on osassa 1.10.32.', 1, '2018-02-14 02:33:02', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `operations`
--

CREATE TABLE IF NOT EXISTS `operations` (
  `id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `operation_name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `operation_slug` varchar(50) CHARACTER SET utf8 NOT NULL,
  `is_view_vissible` tinyint(1) NOT NULL,
  `is_add_vissible` tinyint(1) NOT NULL,
  `is_edit_vissible` tinyint(1) NOT NULL,
  `is_delete_vissible` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `operations`
--

INSERT INTO `operations` (`id`, `module_id`, `operation_name`, `operation_slug`, `is_view_vissible`, `is_add_vissible`, `is_edit_vissible`, `is_delete_vissible`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 'General Setting', 'setting', 1, 1, 1, 0, 1, '2017-12-12 16:06:25', '2018-02-09 01:24:50', 1, 1),
(2, 1, 'Payment Setting', 'payment', 1, 1, 1, 0, 1, '2017-12-12 16:06:55', '2018-02-09 01:24:40', 1, 1),
(3, 1, 'SMS Setting', 'sms', 1, 1, 1, 0, 1, '2017-12-12 16:07:07', '2018-02-09 01:05:32', 1, 1),
(4, 2, 'Theme', 'theme', 1, 0, 1, 0, 1, '2017-12-12 16:08:39', '2018-01-03 07:02:51', 1, 1),
(5, 3, 'Language', 'language', 1, 1, 1, 1, 1, '2017-12-12 16:09:22', '2018-01-03 07:03:03', 1, 1),
(6, 4, 'Academic Year', 'year', 1, 1, 1, 1, 1, '2017-12-12 16:10:34', '2018-01-03 07:03:18', 1, 1),
(7, 4, 'User Role', 'role', 1, 1, 1, 1, 1, '2017-12-12 16:10:55', '2018-01-03 07:03:31', 1, 1),
(8, 4, 'Role Permission', 'permission', 1, 0, 1, 0, 1, '2017-12-12 16:12:10', '2018-01-03 07:05:00', 1, 1),
(64, 4, 'Reset User Password', 'password', 0, 0, 1, 0, 1, '2017-12-13 20:14:23', '2018-01-03 07:05:11', 1, 1),
(10, 5, 'Designation', 'designation', 1, 1, 1, 1, 1, '2017-12-12 16:15:38', '2018-01-03 07:07:38', 1, 1),
(11, 5, 'Employee', 'employee', 1, 1, 1, 1, 1, '2017-12-12 16:15:55', '2018-01-03 07:19:54', 1, 1),
(12, 6, 'Teacher', 'teacher', 1, 1, 1, 1, 1, '2017-12-12 16:17:22', '2018-01-03 07:25:07', 1, 1),
(14, 7, 'Classes', 'classes', 1, 1, 1, 1, 1, '2017-12-12 16:19:01', '2018-01-03 07:25:17', 1, 1),
(15, 7, 'Section', 'section', 1, 1, 1, 1, 1, '2017-12-12 16:19:24', '2018-01-03 07:25:24', 1, 1),
(16, 7, 'Subject', 'subject', 1, 1, 1, 1, 1, '2017-12-12 16:19:48', '2018-01-03 07:25:33', 1, 1),
(17, 7, 'Syllabus', 'syllabus', 1, 1, 1, 1, 1, '2017-12-12 16:20:32', '2018-01-03 07:25:54', 1, 1),
(18, 7, 'Class Routine', 'routine', 1, 1, 1, 1, 1, '2017-12-12 16:20:56', '2018-01-03 07:26:13', 1, 1),
(19, 7, 'Promotion', 'promotion', 1, 1, 0, 0, 1, '2017-12-12 16:21:17', '2018-02-09 01:42:57', 1, 1),
(20, 8, 'Guardian', 'guardian', 1, 1, 1, 1, 1, '2017-12-12 16:23:32', '2018-01-03 07:29:06', 1, 1),
(21, 9, 'Student', 'student', 1, 1, 1, 1, 1, '2017-12-12 17:58:56', '2018-01-03 07:29:15', 1, 1),
(65, 4, 'Backup Database', 'backup', 1, 0, 0, 0, 1, '2017-12-13 20:14:39', '2018-02-09 01:29:33', 1, 1),
(23, 10, 'Employee Attendance', 'employee', 1, 1, 1, 0, 1, '2017-12-12 18:00:10', '2018-01-03 07:30:19', 1, 1),
(24, 10, 'Teacher Attendance', 'teacher', 1, 1, 1, 0, 1, '2017-12-12 18:00:51', '2018-01-03 07:29:52', 1, 1),
(25, 10, 'Student Attendance', 'student', 1, 1, 1, 0, 1, '2017-12-12 18:01:17', '2018-01-03 07:30:01', 1, 1),
(26, 11, 'Assignment', 'assignment', 1, 1, 1, 1, 1, '2017-12-12 18:02:08', '2018-01-03 07:30:40', 1, 1),
(28, 12, 'Exam Term', 'exam', 1, 1, 1, 1, 1, '2017-12-12 18:03:30', '2018-02-09 01:49:25', 1, 1),
(29, 12, 'Exam Grade', 'grade', 1, 1, 1, 1, 1, '2017-12-12 18:03:56', '2018-01-03 07:31:56', 1, 1),
(30, 12, 'Exam Schedule', 'schedule', 1, 1, 1, 1, 1, '2017-12-12 18:04:58', '2018-01-03 07:32:14', 1, 1),
(31, 12, 'Exam Suggestion', 'suggestion', 1, 1, 1, 1, 1, '2017-12-12 18:05:18', '2018-01-03 07:32:30', 1, 1),
(32, 12, 'Exam Attendance', 'attendance', 1, 1, 1, 0, 1, '2017-12-12 18:05:43', '2018-01-03 07:32:58', 1, 1),
(33, 13, 'Exam Mark', 'mark', 1, 1, 1, 0, 1, '2017-12-12 18:06:04', '2018-01-03 07:33:16', 1, 1),
(34, 13, 'Mark Sheet', 'marksheet', 1, 1, 1, 0, 1, '2017-12-12 18:06:24', '2018-01-03 07:34:08', 1, 1),
(35, 13, 'Exam Result', 'result', 1, 1, 1, 0, 1, '2017-12-12 18:06:41', '2018-01-03 07:34:20', 1, 1),
(37, 14, 'Library Book', 'book', 1, 1, 1, 1, 1, '2017-12-12 18:09:17', '2018-01-03 07:36:02', 1, 1),
(38, 14, 'Library Member', 'member', 1, 1, 0, 1, 1, '2017-12-12 18:09:33', '2018-01-03 07:36:24', 1, 1),
(66, 14, 'Issue & Return', 'issue', 1, 1, 1, 0, 1, '2017-12-14 08:46:37', '2018-01-03 07:37:01', 1, 1),
(40, 15, 'Vehicle', 'vehicle', 1, 1, 1, 1, 1, '2017-12-12 18:10:49', '2018-01-03 07:37:11', 1, 1),
(41, 15, 'Transport Route', 'route', 1, 1, 1, 1, 1, '2017-12-12 18:11:17', '2018-01-03 07:41:27', 1, 1),
(42, 15, 'Transport Member', 'member', 1, 1, 0, 1, 1, '2017-12-12 18:11:39', '2018-01-03 07:41:46', 1, 1),
(43, 16, 'Hostel', 'hostel', 1, 1, 1, 1, 1, '2017-12-12 18:12:16', '2018-01-03 07:41:55', 1, 1),
(44, 16, 'Hostel Room', 'room', 1, 1, 1, 1, 1, '2017-12-12 18:12:37', '2018-01-03 07:42:02', 1, 1),
(45, 16, 'Hostel Member', 'member', 1, 1, 0, 1, 1, '2017-12-12 18:13:00', '2018-01-03 07:42:23', 1, 1),
(47, 17, 'Email', 'mail', 1, 1, 0, 1, 1, '2017-12-12 18:15:57', '2018-01-03 07:44:16', 1, 1),
(48, 17, 'Text SMS', 'text', 1, 1, 0, 1, 1, '2017-12-12 18:16:17', '2018-01-03 07:44:25', 1, 1),
(50, 18, 'Notice', 'notice', 1, 1, 1, 1, 1, '2017-12-12 18:20:38', '2018-01-03 07:47:39', 1, 1),
(51, 18, 'News', 'news', 1, 1, 1, 1, 1, '2017-12-12 18:20:54', '2018-01-03 07:47:46', 1, 1),
(52, 18, 'Holiday', 'holiday', 1, 1, 1, 1, 1, '2017-12-12 18:21:08', '2018-01-03 07:47:53', 1, 1),
(53, 19, 'Event', 'event', 1, 1, 1, 1, 1, '2017-12-12 18:21:35', '2018-01-03 07:48:00', 1, 1),
(54, 20, 'Visitor Info', 'visitor', 1, 1, 1, 1, 1, '2017-12-12 18:22:05', '2018-01-03 07:48:15', 1, 1),
(56, 21, 'Expenditure Head', 'exphead', 1, 1, 1, 1, 1, '2017-12-12 18:23:51', '2018-01-03 07:48:23', 1, 1),
(57, 21, 'Expenditure', 'expenditure', 1, 1, 1, 1, 1, '2017-12-12 18:24:14', '2018-01-03 07:48:32', 1, 1),
(58, 21, 'Income Head', 'incomehead', 1, 1, 1, 1, 1, '2017-12-12 18:24:42', '2018-01-03 07:48:39', 1, 1),
(59, 21, 'Income', 'income', 1, 1, 1, 1, 1, '2017-12-12 18:24:54', '2018-01-03 07:48:59', 1, 1),
(60, 21, 'Invoice', 'invoice', 1, 1, 1, 1, 1, '2017-12-12 18:25:16', '2018-01-03 07:49:12', 1, 1),
(61, 21, 'Payment', 'payment', 1, 1, 0, 0, 1, '2017-12-12 18:25:34', '2018-01-03 07:49:47', 1, 1),
(62, 22, 'Report', 'report', 1, 0, 0, 0, 1, '2017-12-12 18:26:16', '2018-01-03 07:50:00', 1, 1),
(63, 4, 'Manage User', 'user', 1, 0, 1, 0, 1, '2017-12-13 20:13:49', '2018-01-03 07:35:43', 1, 1),
(67, 13, 'Mark send by SMS', 'text', 1, 1, 0, 1, 1, '2017-12-14 09:09:58', '2018-01-03 07:34:45', 1, 1),
(68, 13, 'Mark send by Email', 'mail', 1, 1, 0, 1, 1, '2017-12-14 09:10:15', '2018-01-03 07:35:13', 1, 1),
(69, 17, 'message', 'message', 1, 1, 1, 1, 1, '2018-01-13 08:53:53', '2018-01-13 09:06:22', 2, 2);

-- --------------------------------------------------------

--
-- Table structure for table `payment_settings`
--

CREATE TABLE IF NOT EXISTS `payment_settings` (
  `id` int(11) NOT NULL,
  `paypal_api_username` varchar(100) DEFAULT NULL,
  `paypal_api_password` varchar(100) DEFAULT NULL,
  `paypal_api_signature` varchar(100) DEFAULT NULL,
  `paypal_email` varchar(50) DEFAULT NULL,
  `paypal_demo` tinyint(1) DEFAULT NULL,
  `paypal_status` tinyint(1) DEFAULT NULL,
  `stripe_secret` varchar(100) DEFAULT NULL,
  `stripe_demo` tinyint(1) DEFAULT NULL,
  `stripe_status` tinyint(1) DEFAULT NULL,
  `payumoney_key` varchar(100) DEFAULT NULL,
  `payumoney_salt` varchar(100) DEFAULT NULL,
  `payumoney_demo` tinyint(1) DEFAULT NULL,
  `payumoney_status` tinyint(1) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payment_settings`
--

INSERT INTO `payment_settings` (`id`, `paypal_api_username`, `paypal_api_password`, `paypal_api_signature`, `paypal_email`, `paypal_demo`, `paypal_status`, `stripe_secret`, `stripe_demo`, `stripe_status`, `payumoney_key`, `payumoney_salt`, `payumoney_demo`, `payumoney_status`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, NULL, NULL, NULL, '', 0, 0, '', 0, 0, '', '', 0, 0, 0, '2017-08-24 10:58:24', '2018-01-13 04:15:18', 1, 2);

-- --------------------------------------------------------

--
-- Table structure for table `privileges`
--

CREATE TABLE IF NOT EXISTS `privileges` (
  `id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `operation_id` int(11) NOT NULL,
  `is_add` tinyint(1) NOT NULL,
  `is_edit` tinyint(1) NOT NULL,
  `is_view` tinyint(1) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=609 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `privileges`
--

INSERT INTO `privileges` (`id`, `role_id`, `operation_id`, `is_add`, `is_edit`, `is_view`, `is_delete`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 1, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(2, 1, 2, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(3, 1, 3, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(4, 1, 4, 0, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(5, 1, 5, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(6, 1, 6, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(7, 1, 7, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(8, 1, 8, 0, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(9, 1, 64, 0, 1, 0, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(10, 1, 65, 0, 0, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(11, 1, 63, 0, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(12, 1, 10, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(13, 1, 11, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(14, 1, 12, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(15, 1, 14, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(16, 1, 15, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(17, 1, 16, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(18, 1, 17, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(19, 1, 18, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(20, 1, 19, 1, 0, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(21, 1, 20, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(22, 1, 21, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(23, 1, 23, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(24, 1, 24, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(25, 1, 25, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(26, 1, 26, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(27, 1, 27, 1, 1, 1, 1, 1, '2018-01-13 09:07:29', '0000-00-00 00:00:00', 2, 0),
(28, 1, 28, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(29, 1, 29, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(30, 1, 30, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(31, 1, 31, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(32, 1, 32, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(33, 1, 33, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(34, 1, 34, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(35, 1, 35, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(36, 1, 67, 1, 0, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(37, 1, 68, 1, 0, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(38, 1, 37, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(39, 1, 38, 1, 0, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(40, 1, 66, 1, 1, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(41, 1, 40, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(42, 1, 41, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(43, 1, 42, 1, 0, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(44, 1, 43, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(45, 1, 44, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(46, 1, 45, 1, 0, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(47, 1, 46, 1, 1, 1, 1, 1, '2017-12-23 22:10:34', '0000-00-00 00:00:00', 1, 0),
(48, 1, 47, 1, 0, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(49, 1, 48, 1, 0, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(50, 1, 50, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(51, 1, 51, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(52, 1, 52, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(53, 1, 53, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(54, 1, 54, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(55, 1, 55, 1, 1, 1, 1, 1, '2017-12-23 22:10:34', '0000-00-00 00:00:00', 1, 0),
(56, 1, 56, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(57, 1, 57, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(58, 1, 58, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(59, 1, 59, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(60, 1, 60, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(61, 1, 61, 1, 0, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(62, 1, 62, 0, 0, 1, 0, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(63, 3, 1, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(64, 3, 2, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(65, 3, 3, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(66, 3, 4, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(67, 3, 5, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(68, 3, 6, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(69, 3, 7, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(70, 3, 8, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(71, 3, 64, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(72, 3, 65, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(73, 3, 63, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(74, 3, 10, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(75, 3, 11, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(76, 3, 12, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(77, 3, 14, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(78, 3, 15, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(79, 3, 16, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(80, 3, 17, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(81, 3, 18, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(82, 3, 19, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(83, 3, 20, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(84, 3, 21, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(85, 3, 23, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(86, 3, 24, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(87, 3, 25, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(88, 3, 26, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(89, 3, 27, 1, 1, 0, 1, 1, '2018-01-03 07:12:55', '0000-00-00 00:00:00', 1, 0),
(90, 3, 28, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(91, 3, 29, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(92, 3, 30, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(93, 3, 31, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(94, 3, 32, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(95, 3, 33, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(96, 3, 34, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(97, 3, 35, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(98, 3, 67, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(99, 3, 68, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(100, 3, 37, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(101, 3, 38, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(102, 3, 66, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(103, 3, 40, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(104, 3, 41, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(105, 3, 42, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(106, 3, 43, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(107, 3, 44, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(108, 3, 45, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(109, 3, 46, 1, 1, 0, 1, 1, '2018-01-03 07:12:55', '0000-00-00 00:00:00', 1, 0),
(110, 3, 47, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(111, 3, 48, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(112, 3, 50, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(113, 3, 51, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(114, 3, 52, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(115, 3, 53, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(116, 3, 54, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(117, 3, 55, 1, 1, 0, 1, 1, '2018-01-03 07:12:55', '0000-00-00 00:00:00', 1, 0),
(118, 3, 56, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(119, 3, 57, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(120, 3, 58, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(121, 3, 59, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(122, 3, 60, 0, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(123, 3, 61, 1, 0, 1, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(124, 3, 62, 0, 0, 0, 0, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(125, 1, 69, 1, 1, 1, 1, 1, '2018-02-09 02:56:09', '0000-00-00 00:00:00', 1, 0),
(126, 5, 1, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(127, 5, 2, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(128, 5, 3, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(129, 5, 4, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(130, 5, 5, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(131, 5, 6, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(132, 5, 7, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(133, 5, 8, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(134, 5, 64, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(135, 5, 65, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(136, 5, 63, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(137, 5, 10, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(138, 5, 11, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(139, 5, 12, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(140, 5, 14, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(141, 5, 15, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(142, 5, 16, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(143, 5, 17, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(144, 5, 18, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(145, 5, 19, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(146, 5, 20, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(147, 5, 21, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(148, 5, 23, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(149, 5, 24, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(150, 5, 25, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(151, 5, 26, 1, 1, 1, 1, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(152, 5, 27, 1, 1, 1, 0, 1, '2018-01-13 09:46:35', '0000-00-00 00:00:00', 1, 0),
(153, 5, 28, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(154, 5, 29, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(155, 5, 30, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(156, 5, 31, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(157, 5, 32, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(158, 5, 33, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(159, 5, 34, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(160, 5, 35, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(161, 5, 67, 1, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(162, 5, 68, 1, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(163, 5, 37, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(164, 5, 38, 1, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(165, 5, 66, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(166, 5, 40, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(167, 5, 41, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(168, 5, 42, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(169, 5, 43, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(170, 5, 44, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(171, 5, 45, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(172, 5, 47, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(173, 5, 48, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(174, 5, 69, 1, 1, 1, 1, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(175, 5, 50, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(176, 5, 51, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(177, 5, 52, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(178, 5, 53, 1, 1, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(179, 5, 54, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(180, 5, 56, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(181, 5, 57, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(182, 5, 58, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(183, 5, 59, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(184, 5, 60, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(185, 5, 61, 0, 0, 0, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(186, 5, 62, 0, 0, 1, 0, 1, '2018-02-09 03:07:30', '0000-00-00 00:00:00', 1, 0),
(187, 13, 1, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(188, 13, 2, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(189, 13, 3, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(190, 13, 4, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(191, 13, 5, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(192, 13, 6, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(193, 13, 7, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(194, 13, 8, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(195, 13, 64, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(196, 13, 65, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(197, 13, 63, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(198, 13, 10, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(199, 13, 11, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(200, 13, 12, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(201, 13, 14, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(202, 13, 15, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(203, 13, 16, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(204, 13, 17, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(205, 13, 18, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(206, 13, 19, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(207, 13, 20, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(208, 13, 21, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(209, 13, 23, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(210, 13, 24, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(211, 13, 25, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(212, 13, 26, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(213, 13, 27, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(214, 13, 28, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(215, 13, 29, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(216, 13, 30, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(217, 13, 31, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(218, 13, 32, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(219, 13, 33, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(220, 13, 34, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(221, 13, 35, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(222, 13, 67, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(223, 13, 68, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(224, 13, 37, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(225, 13, 38, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(226, 13, 66, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(227, 13, 40, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(228, 13, 41, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(229, 13, 42, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(230, 13, 43, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(231, 13, 44, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(232, 13, 45, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(233, 13, 47, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(234, 13, 48, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(235, 13, 69, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(236, 13, 50, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(237, 13, 51, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(238, 13, 52, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(239, 13, 53, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(240, 13, 54, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(241, 13, 56, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(242, 13, 57, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(243, 13, 58, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(244, 13, 59, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(245, 13, 60, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(246, 13, 61, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(247, 13, 62, 0, 0, 0, 0, 1, '2018-02-04 04:46:43', '0000-00-00 00:00:00', 1, 0),
(248, 3, 69, 1, 1, 1, 1, 1, '2018-02-25 03:15:25', '0000-00-00 00:00:00', 1, 0),
(249, 2, 1, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(250, 2, 2, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(251, 2, 3, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(252, 2, 4, 0, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(253, 2, 5, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(254, 2, 6, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(255, 2, 7, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(256, 2, 8, 0, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(257, 2, 64, 0, 1, 0, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(258, 2, 65, 0, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(259, 2, 63, 0, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(260, 2, 10, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(261, 2, 11, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(262, 2, 12, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(263, 2, 14, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(264, 2, 15, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(265, 2, 16, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(266, 2, 17, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(267, 2, 18, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(268, 2, 19, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(269, 2, 20, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(270, 2, 21, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(271, 2, 23, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(272, 2, 24, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(273, 2, 25, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(274, 2, 26, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(275, 2, 28, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(276, 2, 29, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(277, 2, 30, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(278, 2, 31, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(279, 2, 32, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(280, 2, 33, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(281, 2, 34, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(282, 2, 35, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(283, 2, 67, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(284, 2, 68, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(285, 2, 37, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(286, 2, 38, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(287, 2, 66, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(288, 2, 40, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(289, 2, 41, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(290, 2, 42, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(291, 2, 43, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(292, 2, 44, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(293, 2, 45, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(294, 2, 47, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(295, 2, 48, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(296, 2, 69, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(297, 2, 50, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(298, 2, 51, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(299, 2, 52, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(300, 2, 53, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(301, 2, 54, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(302, 2, 56, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(303, 2, 57, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(304, 2, 58, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(305, 2, 59, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(306, 2, 60, 1, 1, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(307, 2, 61, 1, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(308, 2, 62, 0, 0, 1, 0, 1, '2018-02-09 02:56:37', '0000-00-00 00:00:00', 1, 0),
(309, 4, 1, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(310, 4, 2, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(311, 4, 3, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(312, 4, 4, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(313, 4, 5, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(314, 4, 6, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(315, 4, 7, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(316, 4, 8, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(317, 4, 64, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(318, 4, 65, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(319, 4, 63, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(320, 4, 10, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(321, 4, 11, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(322, 4, 12, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(323, 4, 14, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(324, 4, 15, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(325, 4, 16, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(326, 4, 17, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(327, 4, 18, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(328, 4, 19, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(329, 4, 20, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(330, 4, 21, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(331, 4, 23, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(332, 4, 24, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(333, 4, 25, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(334, 4, 26, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(335, 4, 28, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(336, 4, 29, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(337, 4, 30, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(338, 4, 31, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(339, 4, 32, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(340, 4, 33, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(341, 4, 34, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(342, 4, 35, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(343, 4, 67, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(344, 4, 68, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(345, 4, 37, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(346, 4, 38, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(347, 4, 66, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(348, 4, 40, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(349, 4, 41, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(350, 4, 42, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(351, 4, 43, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(352, 4, 44, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(353, 4, 45, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(354, 4, 47, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(355, 4, 48, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(356, 4, 69, 1, 1, 1, 1, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(357, 4, 50, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(358, 4, 51, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(359, 4, 52, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(360, 4, 53, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(361, 4, 54, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(362, 4, 56, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(363, 4, 57, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(364, 4, 58, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(365, 4, 59, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(366, 4, 60, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(367, 4, 61, 0, 0, 1, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(368, 4, 62, 0, 0, 0, 0, 1, '2018-02-09 03:04:15', '0000-00-00 00:00:00', 1, 0),
(369, 6, 1, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(370, 6, 2, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(371, 6, 3, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(372, 6, 4, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(373, 6, 5, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(374, 6, 6, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(375, 6, 7, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(376, 6, 8, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(377, 6, 64, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(378, 6, 65, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(379, 6, 63, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(380, 6, 10, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(381, 6, 11, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(382, 6, 12, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(383, 6, 14, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(384, 6, 15, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(385, 6, 16, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(386, 6, 17, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(387, 6, 18, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(388, 6, 19, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(389, 6, 20, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(390, 6, 21, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(391, 6, 23, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(392, 6, 24, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(393, 6, 25, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(394, 6, 26, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(395, 6, 28, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(396, 6, 29, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(397, 6, 30, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(398, 6, 31, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(399, 6, 32, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(400, 6, 33, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(401, 6, 34, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(402, 6, 35, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(403, 6, 67, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(404, 6, 68, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(405, 6, 37, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(406, 6, 38, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(407, 6, 66, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(408, 6, 40, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(409, 6, 41, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(410, 6, 42, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(411, 6, 43, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(412, 6, 44, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(413, 6, 45, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(414, 6, 47, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(415, 6, 48, 0, 0, 0, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(416, 6, 69, 1, 1, 1, 1, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(417, 6, 50, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(418, 6, 51, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(419, 6, 52, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(420, 6, 53, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(421, 6, 54, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(422, 6, 56, 1, 1, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(423, 6, 57, 1, 1, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(424, 6, 58, 1, 1, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(425, 6, 59, 1, 1, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(426, 6, 60, 1, 1, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(427, 6, 61, 1, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(428, 6, 62, 0, 0, 1, 0, 1, '2018-02-09 03:09:17', '0000-00-00 00:00:00', 1, 0),
(429, 7, 1, 0, 0, 0, 0, 1, '2018-02-09 03:11:18', '0000-00-00 00:00:00', 1, 0),
(430, 7, 2, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(431, 7, 3, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(432, 7, 4, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(433, 7, 5, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(434, 7, 6, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(435, 7, 7, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(436, 7, 8, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(437, 7, 64, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(438, 7, 65, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(439, 7, 63, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(440, 7, 10, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(441, 7, 11, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(442, 7, 12, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(443, 7, 14, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(444, 7, 15, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(445, 7, 16, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(446, 7, 17, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(447, 7, 18, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(448, 7, 19, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(449, 7, 20, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(450, 7, 21, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(451, 7, 23, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(452, 7, 24, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(453, 7, 25, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(454, 7, 26, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(455, 7, 28, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(456, 7, 29, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(457, 7, 30, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(458, 7, 31, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(459, 7, 32, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(460, 7, 33, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(461, 7, 34, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(462, 7, 35, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(463, 7, 67, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(464, 7, 68, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(465, 7, 37, 1, 1, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(466, 7, 38, 1, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(467, 7, 66, 1, 1, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(468, 7, 40, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(469, 7, 41, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(470, 7, 42, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(471, 7, 43, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(472, 7, 44, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(473, 7, 45, 0, 0, 1, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(474, 7, 47, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(475, 7, 48, 0, 0, 0, 0, 1, '2018-02-09 03:11:19', '0000-00-00 00:00:00', 1, 0),
(476, 7, 69, 1, 1, 1, 1, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(477, 7, 50, 0, 0, 1, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(478, 7, 51, 0, 0, 1, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(479, 7, 52, 0, 0, 1, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(480, 7, 53, 0, 0, 1, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(481, 7, 54, 0, 0, 1, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(482, 7, 56, 0, 0, 0, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(483, 7, 57, 0, 0, 0, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(484, 7, 58, 0, 0, 0, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(485, 7, 59, 0, 0, 0, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(486, 7, 60, 0, 0, 0, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(487, 7, 61, 0, 0, 0, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(488, 7, 62, 0, 0, 1, 0, 1, '2018-02-09 03:11:20', '0000-00-00 00:00:00', 1, 0),
(489, 8, 1, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(490, 8, 2, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(491, 8, 3, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(492, 8, 4, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(493, 8, 5, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(494, 8, 6, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(495, 8, 7, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(496, 8, 8, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(497, 8, 64, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(498, 8, 65, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(499, 8, 63, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(500, 8, 10, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(501, 8, 11, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(502, 8, 12, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(503, 8, 14, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(504, 8, 15, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(505, 8, 16, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(506, 8, 17, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(507, 8, 18, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(508, 8, 19, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(509, 8, 20, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(510, 8, 21, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(511, 8, 23, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(512, 8, 24, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(513, 8, 25, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(514, 8, 26, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(515, 8, 28, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(516, 8, 29, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(517, 8, 30, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(518, 8, 31, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(519, 8, 32, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(520, 8, 33, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(521, 8, 34, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(522, 8, 35, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(523, 8, 67, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(524, 8, 68, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(525, 8, 37, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(526, 8, 38, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(527, 8, 66, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(528, 8, 40, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(529, 8, 41, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(530, 8, 42, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(531, 8, 43, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(532, 8, 44, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(533, 8, 45, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(534, 8, 47, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(535, 8, 48, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(536, 8, 69, 1, 1, 1, 1, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(537, 8, 50, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(538, 8, 51, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(539, 8, 52, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(540, 8, 53, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(541, 8, 54, 0, 0, 1, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(542, 8, 56, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(543, 8, 57, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(544, 8, 58, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(545, 8, 59, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(546, 8, 60, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(547, 8, 61, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(548, 8, 62, 0, 0, 0, 0, 1, '2018-02-09 03:12:40', '0000-00-00 00:00:00', 1, 0),
(549, 9, 1, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(550, 9, 2, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(551, 9, 3, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(552, 9, 4, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(553, 9, 5, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(554, 9, 6, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(555, 9, 7, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(556, 9, 8, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(557, 9, 64, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(558, 9, 65, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(559, 9, 63, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(560, 9, 10, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(561, 9, 11, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(562, 9, 12, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(563, 9, 14, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(564, 9, 15, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(565, 9, 16, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(566, 9, 17, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(567, 9, 18, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(568, 9, 19, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(569, 9, 20, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(570, 9, 21, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(571, 9, 23, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(572, 9, 24, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(573, 9, 25, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(574, 9, 26, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(575, 9, 28, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(576, 9, 29, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(577, 9, 30, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(578, 9, 31, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(579, 9, 32, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(580, 9, 33, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(581, 9, 34, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(582, 9, 35, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(583, 9, 67, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(584, 9, 68, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(585, 9, 37, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(586, 9, 38, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(587, 9, 66, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(588, 9, 40, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(589, 9, 41, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(590, 9, 42, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(591, 9, 43, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(592, 9, 44, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(593, 9, 45, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(594, 9, 47, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(595, 9, 48, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(596, 9, 69, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(597, 9, 50, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(598, 9, 51, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(599, 9, 52, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(600, 9, 53, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(601, 9, 54, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(602, 9, 56, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(603, 9, 57, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(604, 9, 58, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(605, 9, 59, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(606, 9, 60, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(607, 9, 61, 0, 0, 0, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0),
(608, 9, 62, 0, 0, 1, 0, 1, '2018-02-25 03:22:56', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `replies`
--

CREATE TABLE IF NOT EXISTS `replies` (
  `id` int(11) NOT NULL,
  `message_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `body` text CHARACTER SET utf8 NOT NULL,
  `attachment` varchar(100) CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `results`
--

CREATE TABLE IF NOT EXISTS `results` (
  `id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `avg_grade_point` float(5,2) NOT NULL,
  `exam_total_mark` int(11) NOT NULL,
  `obtain_total_mark` int(11) NOT NULL,
  `remark` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `results`
--

INSERT INTO `results` (`id`, `exam_id`, `class_id`, `section_id`, `academic_year_id`, `student_id`, `avg_grade_point`, `exam_total_mark`, `obtain_total_mark`, `remark`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 1, 1, 2, 1, 0.00, 0, 0, NULL, 1, '2018-02-24 02:15:57', '0000-00-00 00:00:00', 1, 0),
(2, 1, 1, 1, 2, 2, 0.00, 0, 0, NULL, 1, '2018-02-24 02:15:57', '0000-00-00 00:00:00', 1, 0),
(3, 1, 1, 1, 2, 3, 0.00, 0, 0, NULL, 1, '2018-02-24 02:15:57', '0000-00-00 00:00:00', 1, 0),
(4, 1, 1, 1, 2, 4, 0.00, 0, 0, NULL, 1, '2018-02-24 02:15:57', '0000-00-00 00:00:00', 1, 0),
(5, 1, 1, 1, 2, 5, 0.00, 0, 0, NULL, 1, '2018-02-24 02:15:57', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(11) NOT NULL,
  `slug` varchar(50) CHARACTER SET utf8 NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `note` varchar(255) CHARACTER SET utf8 NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `slug`, `name`, `note`, `is_default`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 'super-admin', 'Super Admin', 'Super Admin User', 1, 1, '2017-08-13 12:15:17', '2018-02-09 01:58:57', 0, 1),
(2, 'admin', 'Admin', 'Admin User', 1, 1, '2017-08-13 13:01:36', '0000-00-00 00:00:00', 0, 0),
(3, 'guardian', 'Guardian', 'Guardian/Parent User', 1, 1, '2017-08-13 13:02:05', '2018-02-09 01:59:22', 0, 1),
(4, 'student', 'Student', 'Student User', 1, 1, '2017-08-13 13:02:24', '2018-02-09 01:59:34', 0, 1),
(5, 'teacher', 'Teacher', 'Teacher User', 1, 1, '2017-08-13 13:02:51', '2018-02-09 01:59:46', 0, 1),
(6, 'accountant', 'Accountant', 'Accountant User', 1, 1, '2017-08-13 13:04:00', '2018-02-09 02:00:07', 0, 1),
(7, 'librarian', 'Librarian', 'Librarian User', 1, 1, '2017-08-13 13:04:18', '2018-02-09 02:00:22', 0, 1),
(8, 'receptioniast', 'Receptioniast', 'Receptionist/ Front Desk User', 1, 1, '2017-08-13 13:04:36', '2018-02-09 02:02:30', 0, 1),
(9, 'staff', 'Staff', 'General Staff User', 0, 1, '2017-08-13 13:05:01', '2018-02-09 02:02:48', 0, 1),
(13, 'servent', 'Servent', 'Servant User', 0, 1, '2018-02-04 04:40:37', '2018-02-09 02:03:09', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `rooms`
--

CREATE TABLE IF NOT EXISTS `rooms` (
  `id` int(11) NOT NULL,
  `hostel_id` int(11) NOT NULL,
  `room_no` varchar(20) CHARACTER SET utf8 NOT NULL,
  `room_type` varchar(10) CHARACTER SET utf8 NOT NULL,
  `total_seat` varchar(50) CHARACTER SET utf8 NOT NULL,
  `cost` decimal(10,2) NOT NULL,
  `note` text CHARACTER SET utf8,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`id`, `hostel_id`, `room_no`, `room_type`, `total_seat`, `cost`, `note`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 2, '101', 'ac', '3', '8000.00', 'Lorem Ipsumin kappaleesta ja etsi lainauksia sanasta klassisessa kirjallisuudessa löytäen varman lähteen.', 1, '2018-02-13 12:07:03', '0000-00-00 00:00:00', 1, 0),
(2, 2, '102', 'non_ac', '5', '4000.00', 'Lorem Ipsum on yksinkertaisesti testausteksti, jota tulostus- ja ladontateollisuudet käyttävät.', 1, '2018-02-13 12:08:34', '0000-00-00 00:00:00', 1, 0),
(3, 2, '103', 'non_ac', '5', '4000.00', 'Lorem Ipsum on yksinkertaisesti testausteksti, jota tulostus- ja ladontateollisuudet käyttävät.', 1, '2018-02-13 12:10:23', '0000-00-00 00:00:00', 1, 0),
(4, 2, '104', 'non_ac', '5', '4000.00', 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 1, '2018-02-13 12:11:03', '0000-00-00 00:00:00', 1, 0),
(5, 2, '105', 'ac', '2', '10000.00', 'Lorem Ipsum on yksinkertaisesti testausteksti,', 1, '2018-02-13 20:41:42', '0000-00-00 00:00:00', 1, 0),
(6, 1, '101', 'non_ac', '6', '3000.00', 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 1, '2018-02-13 20:53:25', '0000-00-00 00:00:00', 1, 0),
(7, 1, '102', 'non_ac', '5', '3500.00', 'Lorem Ipsum ei ole vain sattumanvarainen teksti.', 1, '2018-02-13 21:34:52', '2018-02-13 21:39:11', 1, 1),
(8, 1, '103', 'ac', '3', '7000.00', 'Lorem Ipsumin käytön tarkoitus on, että se omaa enemmän-tai-vähemmän normaalimpaa sanojen sijoitusta kuin ''Sisältöä tähän.', 1, '2018-02-13 21:41:25', '0000-00-00 00:00:00', 1, 0),
(9, 1, '104', 'ac', '2', '8500.00', 'Lorem Ipsumin käytön tarkoitus on, että se omaa enemmän-tai-vähemmän normaalimpaa sanojen sijoitusta kuin ''Sisältöä tähän.', 1, '2018-02-13 21:42:29', '2018-02-13 21:43:52', 1, 1),
(10, 3, '101', 'non_ac', '6', '3500.00', 'Lorem Ipsum on yksinkertaisesti testausteksti,', 1, '2018-02-13 21:46:04', '0000-00-00 00:00:00', 1, 0),
(11, 3, '102', 'ac', '3', '8000.00', 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 1, '2018-02-14 01:18:14', '0000-00-00 00:00:00', 1, 0),
(12, 3, '103', 'ac', '3', '8000.00', 'Lorem Ipsum ei ole vain sattumanvarainen teksti.', 1, '2018-02-14 01:19:29', '0000-00-00 00:00:00', 1, 0),
(13, 3, '104', 'non_ac', '6', '3500.00', 'Lorem Ipsumin kappaleesta ja etsi lainauksia sanasta klassisessa kirjallisuudessa löytäen varman lähteen.', 1, '2018-02-14 01:20:58', '0000-00-00 00:00:00', 1, 0),
(14, 3, '105', 'non_ac', '6', '3500.00', 'Lorem Ipsum tulee osista 1.10.32 ja 1.10.33 "de Finibus Bonorum et Malorum":ksesta.', 1, '2018-02-14 01:22:31', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `routes`
--

CREATE TABLE IF NOT EXISTS `routes` (
  `id` int(11) NOT NULL,
  `vehicle_ids` varchar(150) CHARACTER SET utf8 NOT NULL,
  `title` varchar(150) CHARACTER SET utf8 NOT NULL,
  `route_start` varchar(255) CHARACTER SET utf8 NOT NULL,
  `route_end` varchar(255) CHARACTER SET utf8 NOT NULL,
  `fare` decimal(10,2) NOT NULL,
  `note` text CHARACTER SET utf8,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `routes`
--

INSERT INTO `routes` (`id`, `vehicle_ids`, `title`, `route_start`, `route_end`, `fare`, `note`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, '1', 'Autaugaville', 'School Campus', '5213 Academy St  Autaugaville, AL 26003', '20.00', 'Lorem Ipsumin kappaleesta ja etsi lainauksia sanasta klassisessa kirjallisuudessa löytäen varman lähteen.', 1, '2018-02-13 07:17:24', '2018-02-13 08:31:41', 1, 1),
(2, '2', 'New London', 'School Campus', '2761 Dutch Island Cir  Autaugaville, AL 36003', '30.00', 'Lorem Ipsumin käytön tarkoitus on,', 1, '2018-02-13 08:36:00', '0000-00-00 00:00:00', 1, 0),
(3, '3', 'New London, CT', 'School Campus', '31 Blinman St  New London, CT 2320', '25.00', 'Lorem Ipsum on yksinkertaisesti testausteksti, jota tulostus- ja ladontateollisuudet käyttävät.', 1, '2018-02-13 08:37:39', '2018-02-13 08:39:47', 1, 1),
(4, '3', 'Evangeline', 'School Campus', '529 Macon Pl  Autaugaville, AL 87403', '20.00', 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 1, '2018-02-13 08:46:15', '0000-00-00 00:00:00', 1, 0),
(5, '4', 'Unalaska', 'School Campus', '76 Airport Beach Rd  Unalaska, AK 96685', '40.00', 'Lorem Ipsum ei ole vain sattumanvarainen teksti.', 1, '2018-02-13 08:50:09', '0000-00-00 00:00:00', 1, 0),
(6, '5', 'Anchorage', 'School Campus', '201 W 100th Ave  Anchorage, AK 10015', '35.00', 'Lorem Ipsumin kappaleesta ja etsi lainauksia sanasta klassisessa kirjallisuudessa löytäen varman lähteen.', 1, '2018-02-13 08:52:24', '0000-00-00 00:00:00', 1, 0),
(7, '6', 'Chugiak', 'School Campus', '35427 Chapel Dr  Chugiak, AK 65467', '50.00', 'Lorem Ipsum tulee osista 1.10.32 ja 1.10.33 "de Finibus Bonorum et Malorum":ksesta.', 1, '2018-02-13 08:57:25', '0000-00-00 00:00:00', 1, 0),
(8, '7', 'Eagle River', 'School Campus', '36927 Baronoff Ave  Eagle River, AK 85577', '40.00', 'Lorem ipsum dolor sit amet..", tulee rivistä joka on osassa 1.10.32.', 1, '2018-02-13 09:00:17', '0000-00-00 00:00:00', 1, 0),
(9, '8', 'Indian', 'School Campus', '225 Indian Creek Way  Indian, AK 39940', '50.00', 'Lorem Ipsumia'' etsittäessä löytyy monen monta nettisivua, jotka ovat vasta aluillaan.', 1, '2018-02-13 09:03:42', '0000-00-00 00:00:00', 1, 0),
(10, '9', 'Jber', 'School Campus', '287 Fishwheel Ave  Jber, AK 99505', '20.00', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit,', 1, '2018-02-13 09:08:22', '0000-00-00 00:00:00', 1, 0),
(11, '10', 'Kodiak', 'School Campus', '620 Bonaparte Cir  Kodiak, AK 91965', '30.00', 'Lorem Ipsum on yksinkertaisesti testausteksti, jota tulostus- ja ladontateollisuudet käyttävät.', 1, '2018-02-13 09:22:38', '0000-00-00 00:00:00', 1, 0),
(12, '11', 'Anchorage', 'School Campus', '451 W 64th Ave  Anchorage, AK 91958', '60.00', 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 1, '2018-02-13 09:29:19', '0000-00-00 00:00:00', 1, 0),
(13, '11', 'Verkin', 'School Campus', '161 W 280 N  La Verkin, UT 59745', '60.00', 'Lorem Ipsum ei ole vain sattumanvarainen teksti.', 1, '2018-02-13 09:32:38', '2018-02-13 09:34:09', 1, 1),
(14, '12', 'Dammeron Valley', 'School Campus', '12 Dammeron Valley Farms Dr  Dammeron Valley, UT 84783', '60.00', 'Lorem Ipsum tulee osista 1.10.32 ja 1.10.33 "de Finibus Bonorum et Malorum', 1, '2018-02-13 09:35:28', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `routines`
--

CREATE TABLE IF NOT EXISTS `routines` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `day` varchar(20) CHARACTER SET utf8 NOT NULL,
  `start_time` varchar(20) CHARACTER SET utf8 NOT NULL,
  `end_time` varchar(20) CHARACTER SET utf8 NOT NULL,
  `room_no` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `routines`
--

INSERT INTO `routines` (`id`, `class_id`, `section_id`, `subject_id`, `teacher_id`, `academic_year_id`, `day`, `start_time`, `end_time`, `room_no`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 1, 1, 3, 2, 'tuesday', '8:00 AM', '8:45 AM', 101, 1, '2018-02-09 21:17:26', '2018-02-10 07:05:34', 1, 1),
(30, 1, 1, 5, 11, 2, 'tuesday', '8:45 AM', '9:30 AM', 101, 1, '2018-02-10 08:52:43', '0000-00-00 00:00:00', 1, 0),
(31, 1, 1, 2, 4, 2, 'monday', '9:30 AM', '10:15 AM', 101, 1, '2018-02-10 08:56:23', '0000-00-00 00:00:00', 1, 0),
(4, 1, 1, 1, 3, 2, 'monday', '8:00 AM', '8:45 AM', 101, 1, '2018-02-09 21:25:15', '2018-02-09 21:26:48', 1, 1),
(46, 1, 1, 1, 3, 2, 'thursday', '10:15 AM', '11:00 PM', 101, 1, '2018-02-10 09:48:35', '0000-00-00 00:00:00', 1, 0),
(27, 1, 1, 7, 8, 2, 'thursday', '8:00 AM', '8:45 AM', 101, 1, '2018-02-10 08:44:22', '0000-00-00 00:00:00', 1, 0),
(28, 1, 1, 7, 8, 2, 'friday', '8:00 AM', '8:45 AM', 101, 1, '2018-02-10 08:45:16', '0000-00-00 00:00:00', 1, 0),
(29, 1, 1, 5, 11, 2, 'monday', '8:45 AM', '9:30 AM', 101, 1, '2018-02-10 08:46:38', '0000-00-00 00:00:00', 1, 0),
(10, 1, 1, 1, 3, 2, 'wednesday', '8:00 AM', '8:45 AM', 101, 1, '2018-02-10 07:08:40', '0000-00-00 00:00:00', 1, 0),
(32, 1, 1, 10, 14, 2, 'monday', '10:15 AM', '11:00 AM', 101, 1, '2018-02-10 08:57:25', '0000-00-00 00:00:00', 1, 0),
(33, 1, 1, 4, 10, 2, 'monday', '11:00 AM', '11:45 AM', 101, 1, '2018-02-10 08:59:24', '0000-00-00 00:00:00', 1, 0),
(34, 1, 1, 8, 9, 2, 'monday', '11:45 AM', '12:30 PM', 101, 1, '2018-02-10 09:01:03', '0000-00-00 00:00:00', 1, 0),
(35, 1, 1, 2, 4, 2, 'tuesday', '9:30 AM', '10:15 PM', 101, 1, '2018-02-10 09:27:01', '0000-00-00 00:00:00', 1, 0),
(36, 1, 1, 10, 14, 2, 'tuesday', '10:15 AM', '11:00 AM', 101, 1, '2018-02-10 09:28:13', '0000-00-00 00:00:00', 1, 0),
(37, 1, 1, 4, 10, 2, 'tuesday', '11:00 AM', '11:45 AM', 101, 1, '2018-02-10 09:29:35', '0000-00-00 00:00:00', 1, 0),
(38, 1, 1, 8, 9, 2, 'tuesday', '11:45 AM', '12:30 PM', 101, 1, '2018-02-10 09:30:59', '0000-00-00 00:00:00', 1, 0),
(39, 1, 1, 9, 12, 2, 'wednesday', '8:45 AM', '9:30 AM', 101, 1, '2018-02-10 09:33:36', '0000-00-00 00:00:00', 1, 0),
(40, 1, 1, 9, 12, 2, 'thursday', '8:45 AM', '9:30 AM', 101, 1, '2018-02-10 09:35:15', '0000-00-00 00:00:00', 1, 0),
(41, 1, 1, 9, 12, 2, 'friday', '8:45 AM', '9:30 AM', 101, 1, '2018-02-10 09:36:00', '0000-00-00 00:00:00', 1, 0),
(42, 1, 1, 2, 4, 2, 'wednesday', '9:30 AM', '10:15 AM', 101, 1, '2018-02-10 09:38:38', '0000-00-00 00:00:00', 1, 0),
(43, 1, 1, 6, 7, 2, 'thursday', '9:30 AM', '10:15 AM', 101, 1, '2018-02-10 09:43:18', '0000-00-00 00:00:00', 1, 0),
(44, 1, 1, 6, 7, 2, 'friday', '9:30 AM', '10:15 AM', 101, 1, '2018-02-10 09:44:11', '0000-00-00 00:00:00', 1, 0),
(45, 1, 1, 10, 14, 2, 'wednesday', '10:15 AM', '11:00 AM', 101, 1, '2018-02-10 09:46:06', '0000-00-00 00:00:00', 1, 0),
(47, 1, 1, 1, 4, 2, 'friday', '10:15 AM', '11:00 PM', 101, 1, '2018-02-10 09:49:39', '0000-00-00 00:00:00', 1, 0),
(48, 1, 1, 3, 5, 2, 'wednesday', '11:00 AM', '11:45 AM', 101, 1, '2018-02-10 09:51:25', '0000-00-00 00:00:00', 1, 0),
(49, 1, 1, 3, 5, 2, 'thursday', '11:00 AM', '11:45 AM', 101, 1, '2018-02-10 09:52:08', '0000-00-00 00:00:00', 1, 0),
(50, 1, 1, 3, 5, 2, 'friday', '11:00 AM', '11:45 AM', 101, 1, '2018-02-10 09:53:06', '0000-00-00 00:00:00', 1, 0),
(51, 1, 1, 8, 9, 2, 'wednesday', '11:45 AM', '12:30 PM', 101, 1, '2018-02-10 09:55:31', '0000-00-00 00:00:00', 1, 0),
(52, 1, 1, 2, 4, 2, 'thursday', '11:45 AM', '12:30 PM', 101, 1, '2018-02-10 09:57:04', '0000-00-00 00:00:00', 1, 0),
(53, 1, 1, 2, 4, 2, 'friday', '11:45 AM', '12:30 PM', 101, 1, '2018-02-10 09:57:49', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `sections`
--

CREATE TABLE IF NOT EXISTS `sections` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `note` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `class_id`, `teacher_id`, `name`, `note`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 1, 'A', 'Default Section', 1, '2018-02-09 08:44:23', '0000-00-00 00:00:00', 1, 0),
(2, 2, 2, 'A', 'Default Section', 1, '2018-02-09 08:45:11', '0000-00-00 00:00:00', 1, 0),
(3, 3, 3, 'A', 'Default Section', 1, '2018-02-09 08:46:13', '0000-00-00 00:00:00', 1, 0),
(4, 4, 4, 'A', 'Default Section', 1, '2018-02-09 08:50:50', '0000-00-00 00:00:00', 1, 0),
(5, 5, 5, 'A', 'Default Section', 1, '2018-02-09 08:53:33', '0000-00-00 00:00:00', 1, 0),
(6, 6, 6, 'A', 'Default Section', 1, '2018-02-09 08:55:00', '0000-00-00 00:00:00', 1, 0),
(7, 7, 7, 'A', 'Default Section', 1, '2018-02-09 09:42:50', '0000-00-00 00:00:00', 1, 0),
(8, 8, 8, 'A', 'Default Section', 1, '2018-02-09 09:43:49', '0000-00-00 00:00:00', 1, 0),
(9, 9, 9, 'A', 'Default Section', 1, '2018-02-09 09:46:08', '0000-00-00 00:00:00', 1, 0),
(10, 10, 11, 'A', 'Default Section', 1, '2018-02-09 09:47:20', '0000-00-00 00:00:00', 1, 0),
(11, 1, 2, 'B', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 09:52:27', '0000-00-00 00:00:00', 1, 0),
(13, 2, 3, 'B', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 19:53:46', '0000-00-00 00:00:00', 1, 0),
(14, 3, 4, 'B', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, '2018-02-09 19:54:44', '0000-00-00 00:00:00', 1, 0),
(15, 4, 5, 'B', 'Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum"', 1, '2018-02-09 20:01:50', '0000-00-00 00:00:00', 1, 0),
(16, 5, 6, 'B', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 20:03:35', '0000-00-00 00:00:00', 1, 0),
(17, 6, 7, 'B', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, '2018-02-09 20:07:42', '0000-00-00 00:00:00', 1, 0),
(18, 7, 8, 'B', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, ', 1, '2018-02-09 20:09:58', '0000-00-00 00:00:00', 1, 0),
(19, 8, 9, 'B', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', 1, '2018-02-09 20:29:07', '0000-00-00 00:00:00', 1, 0),
(20, 9, 10, 'B', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 20:41:18', '0000-00-00 00:00:00', 1, 0),
(21, 10, 1, 'B', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-10 03:06:31', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL,
  `school_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `address` varchar(255) CHARACTER SET utf8 NOT NULL,
  `phone` varchar(15) CHARACTER SET utf8 NOT NULL,
  `email` varchar(50) CHARACTER SET utf8 NOT NULL,
  `currency` varchar(10) CHARACTER SET utf8 NOT NULL,
  `currency_symbol` varchar(10) CHARACTER SET utf8 NOT NULL,
  `language` varchar(50) CHARACTER SET utf8 NOT NULL,
  `footer` text CHARACTER SET utf8 NOT NULL,
  `logo` varchar(120) CHARACTER SET utf8 NOT NULL,
  `running_year` varchar(15) CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `school_name`, `address`, `phone`, `email`, `currency`, `currency_symbol`, `language`, `footer`, `logo`, `running_year`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 'Windsor Park High School', '10433 Wolverine Way  Bellevue, CA 98456', '0123456789', 'info@gsms.com', 'usd', '$', 'english', 'Copyright© SMS', 'school-logo.png', '2017 - 2018', 1, '2017-08-23 09:40:28', '2018-02-14 03:50:36', 1, 44);

-- --------------------------------------------------------

--
-- Table structure for table `sms_settings`
--

CREATE TABLE IF NOT EXISTS `sms_settings` (
  `id` int(11) NOT NULL,
  `clickatell_username` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `clickatell_password` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `clickatell_api_key` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `clickatell_from_number` varchar(50) CHARACTER SET utf8 NOT NULL,
  `clickatell_status` tinyint(1) DEFAULT NULL,
  `twilio_account_sid` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `twilio_auth_token` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `twilio_from_number` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `clickatell_mo_no` varchar(50) CHARACTER SET utf8 NOT NULL,
  `twilio_status` tinyint(1) DEFAULT NULL,
  `bulk_username` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `bulk_password` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `bulk_status` tinyint(1) DEFAULT NULL,
  `msg91_auth_key` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `msg91_sender_id` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `msg91_status` tinyint(1) DEFAULT NULL,
  `plivo_auth_id` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `plivo_auth_token` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `plivo_from_number` varchar(50) CHARACTER SET utf8 NOT NULL,
  `plivo_status` tinyint(1) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sms_settings`
--

INSERT INTO `sms_settings` (`id`, `clickatell_username`, `clickatell_password`, `clickatell_api_key`, `clickatell_from_number`, `clickatell_status`, `twilio_account_sid`, `twilio_auth_token`, `twilio_from_number`, `clickatell_mo_no`, `twilio_status`, `bulk_username`, `bulk_password`, `bulk_status`, `msg91_auth_key`, `msg91_sender_id`, `msg91_status`, `plivo_auth_id`, `plivo_auth_token`, `plivo_from_number`, `plivo_status`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, '', '', '', '', 0, '', '', '', '', 0, '', '', 0, '', '', 0, '', '', '', 0, 0, '2017-08-24 13:22:49', '2018-01-13 05:30:39', 1, 2);

-- --------------------------------------------------------

--
-- Table structure for table `students`
--

CREATE TABLE IF NOT EXISTS `students` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `guardian_id` int(11) NOT NULL,
  `registration_no` varchar(50) CHARACTER SET utf8 NOT NULL,
  `group` varchar(50) CHARACTER SET utf8 NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8 NOT NULL,
  `present_address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `permanent_address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `gender` varchar(10) CHARACTER SET utf8 NOT NULL,
  `blood_group` varchar(10) CHARACTER SET utf8 NOT NULL,
  `religion` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `dob` date NOT NULL,
  `photo` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `other_info` text,
  `is_library_member` tinyint(1) NOT NULL DEFAULT '0',
  `is_hostel_member` tinyint(1) NOT NULL DEFAULT '0',
  `is_transport_member` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`id`, `user_id`, `guardian_id`, `registration_no`, `group`, `name`, `phone`, `present_address`, `permanent_address`, `gender`, `blood_group`, `religion`, `dob`, `photo`, `other_info`, `is_library_member`, `is_hostel_member`, `is_transport_member`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 74, 1, '123456', '', 'SW Ambris', '123456789', '3243 Hosea Ln Autaugaville, AL 63803', '3243 Hosea Ln Autaugaville, AL 63803', 'male', 'a_positive', '', '2002-11-08', 'photo-1518327593-sms.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 0, 1, 1, 1, '2018-02-10 22:39:53', '2018-02-10 23:00:17', 1, 1),
(2, 75, 2, '123465', '', 'Jawahir Shah', '123654789', '21 E 207th St New York, NY 20329', '21 E 207th St New York, NY 20329', 'male', 'a_negative', '', '2002-01-29', 'photo-1518327883-sms.jpg', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, 1, 1, 1, '2018-02-10 22:44:43', '2018-02-10 23:00:03', 1, 1),
(3, 76, 3, '123654', '', 'Sikander Zulfiqar', '123589647', '25801 E 31st Ave Watkins, CO 55137', '25801 E 31st Ave Watkins, CO 55137', 'male', 'b_positive', '', '2001-02-01', 'photo-1518328766-sms.jpg', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC.', 1, 1, 0, 1, '2018-02-10 22:59:26', '0000-00-00 00:00:00', 1, 0),
(4, 77, 4, '123546', '', 'Sidra Ameen', '123589647', '62 1st St Hamden, CT 8914', '62 1st St Hamden, CT 8914', 'female', 'b_negative', '', '2003-02-01', 'photo-1518329770-sms.jpg', 'Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum.', 1, 1, 1, 1, '2018-02-10 23:16:09', '0000-00-00 00:00:00', 1, 0),
(5, 78, 5, '123467', '', 'Mudassar Bukhari', '123789654', '47 1st St Hamden, CT 1516', '47 1st St Hamden, CT 1516', 'male', 'o_positive', '', '2002-01-30', 'photo-1518329993-sms.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 0, 0, 0, 1, '2018-02-10 23:19:53', '0000-00-00 00:00:00', 1, 0),
(6, 79, 6, '124563', '', 'Sidra Nawaz', '123478569', '91 1st St Hamden, CT 2814', '91 1st St Hamden, CT 2814', 'female', 'o_negative', '', '2002-01-28', 'photo-1518330242-sms.jpg', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s', 1, 1, 1, 1, '2018-02-10 23:24:02', '0000-00-00 00:00:00', 1, 0),
(7, 80, 7, '132654', '', 'Rabiya Shah', '123965478', '31 1st St Hamden, CT 9514', '31 1st St Hamden, CT 9514', 'female', 'o_negative', '', '2002-01-30', 'photo-1518330494-sms.jpg', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC', 0, 0, 0, 1, '2018-02-10 23:28:14', '0000-00-00 00:00:00', 1, 0),
(8, 81, 8, '123789', '', 'Raza-ur-Rehman', '123987456', '18 E 109th St New York, NY 32029', '18 E 109th St New York, NY 32029', 'male', 'ab_positiv', '', '2003-01-30', 'photo-1518342539-sms.jpg', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, 1, 1, 1, '2018-02-11 02:48:59', '0000-00-00 00:00:00', 1, 0),
(9, 82, 9, '123745', '', 'Zahid Hussain', '123587469', '62 W 109th St New York, NY 21025', '62 W 109th St New York, NY 21025', 'male', 'ab_negativ', '', '2002-09-04', 'photo-1518342830-sms.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 0, 0, 0, 1, '2018-02-11 02:53:50', '0000-00-00 00:00:00', 1, 0),
(10, 83, 5, '147852', '', 'Javeria Khan', '123789654', '47 1st St Hamden, CT 1516', '47 1st St Hamden, CT 1516', 'female', 'ab_negativ', '', '2001-12-01', 'photo-1518343255-sms.jpg', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, 0, 1, 1, '2018-02-11 03:00:55', '0000-00-00 00:00:00', 1, 0),
(12, 85, 1, '236547', '', 'Tammy Beaumont', '123456789', '3243 Hosea Ln Autaugaville, AL 63803', '3243 Hosea Ln Autaugaville, AL 63803', 'female', 'a_positive', '', '2001-01-28', 'photo-1518347007-sms.jpg', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s', 0, 0, 0, 1, '2018-02-11 04:03:27', '0000-00-00 00:00:00', 1, 0),
(13, 86, 5, '365489', '', 'Junaid Siddiqui', '123789654', '47 1st St Hamden, CT 1516', '47 1st St Hamden, CT 1516', 'male', 'a_negative', '', '2001-01-30', 'photo-1518347257-sms.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, 0, 0, 1, '2018-02-11 04:07:37', '0000-00-00 00:00:00', 1, 0),
(14, 87, 2, '236548', '', 'ML Cummins', '123654789', '21 E 207th St New York, NY 20329', '21 E 207th St New York, NY 20329', 'male', 'b_positive', '', '2001-02-04', 'photo-1518347470-sms.jpg', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 0, 0, 0, 1, '2018-02-11 04:11:10', '0000-00-00 00:00:00', 1, 0),
(15, 88, 4, '236547', '', 'Alex Hartley', '123589647', '62 1st St Hamden, CT 8914', '62 1st St Hamden, CT 8914', 'female', 'b_negative', '', '2001-01-17', 'photo-1518347678-sms.jpg', 'Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et Malorum', 1, 0, 1, 1, '2018-02-11 04:14:38', '0000-00-00 00:00:00', 1, 0),
(16, 89, 6, '456987', '', 'K Kamyuka', '123478569', '91 1st St Hamden, CT 2814', '91 1st St Hamden, CT 2814', 'male', 'o_negative', '', '2002-02-20', 'photo-1518347786-sms.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 0, 0, 1, 1, '2018-02-11 04:16:26', '0000-00-00 00:00:00', 1, 0),
(17, 90, 1, '123587496', '', 'Neil Wagner', '123456789', '3243 Hosea Ln Autaugaville, AL 63803', '3243 Hosea Ln Autaugaville, AL 63803', 'male', 'a_negative', '', '2000-02-01', 'photo-1518721211-sms.jpg', 'Lorem Ipsum on yksinkertaisesti testausteksti, jota tulostus- ja ladontateollisuudet käyttävät.', 0, 0, 0, 1, '2018-02-15 12:00:11', '0000-00-00 00:00:00', 1, 0),
(18, 91, 2, '123654879', '', 'Kraigg Clairmonte Brathwaite', '123654789', '21 E 207th St New York, NY 20329', '21 E 207th St New York, NY 20329', 'male', 'b_positive', '', '2000-01-29', 'photo-1518721384-sms.jpg', 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 0, 0, 0, 1, '2018-02-15 12:03:04', '0000-00-00 00:00:00', 1, 0),
(19, 92, 3, '123654897', '', 'Xan de Waard', '123589647', '25801 E 31st Ave Watkins, CO 55137', '25801 E 31st Ave Watkins, CO 55137', 'female', 'o_positive', '', '2000-01-01', 'photo-1518726533-sms.jpg', 'Lorem Ipsum ei ole vain sattumanvarainen teksti.', 0, 0, 0, 1, '2018-02-15 13:28:53', '0000-00-00 00:00:00', 1, 0),
(20, 93, 6, '123698745', '', 'AR Nurse', '123478569', '91 1st St Hamden, CT 2814', '91 1st St Hamden, CT 2814', 'male', 'o_positive', '', '1999-12-26', 'photo-1518727159-sms.jpg', 'Lorem Ipsumin kappaleesta ja etsi lainauksia sanasta klassisessa kirjallisuudessa löytäen varman lähteen.', 0, 0, 0, 1, '2018-02-15 13:39:19', '0000-00-00 00:00:00', 1, 0),
(21, 94, 8, '123689547', '', 'Kitty van Male', '123987456', '18 E 109th St New York, NY 32029', '18 E 109th St New York, NY 32029', 'female', 'ab_negativ', '', '1999-11-28', 'photo-1518727414-sms.jpg', 'Lorem Ipsum tulee osista 1.10.32 ja 1.10.33 "de Finibus Bonorum et Malorum":ksesta', 0, 0, 0, 1, '2018-02-15 13:43:33', '0000-00-00 00:00:00', 1, 0),
(22, 95, 10, '123564789', '', 'Marloes Keetels', '123587469', '70 1st St Hamden, CT 6904', '70 1st St Hamden, CT 6904', 'female', 'ab_positiv', '', '2001-01-01', 'photo-1518897625-sms.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', 0, 0, 0, 1, '2018-02-17 13:00:25', '0000-00-00 00:00:00', 1, 0),
(23, 96, 7, '123658974', '', 'KS Williamson', '123965478', '31 1st St Hamden, CT 9514', '31 1st St Hamden, CT 9514', 'male', 'o_negative', '', '2000-12-29', 'photo-1518898053-sms.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit,', 0, 0, 0, 1, '2018-02-17 13:07:33', '0000-00-00 00:00:00', 1, 0),
(24, 97, 4, '123589674', '', 'TL Seifert', '123589647', '62 1st St Hamden, CT 8914', '62 1st St Hamden, CT 8914', 'male', 'b_negative', '', '1999-11-06', 'photo-1518898619-sms.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut in vulputate tellus.', 0, 0, 0, 1, '2018-02-17 13:16:59', '0000-00-00 00:00:00', 1, 0),
(25, 98, 4, '125463987', '', 'HM Nicholls', '123589647', '62 1st St Hamden, CT 8914', '62 1st St Hamden, CT 8914', 'male', 'b_negative', '', '1999-08-31', 'photo-1518963078-sms.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit,', 0, 0, 0, 1, '2018-02-18 07:11:18', '0000-00-00 00:00:00', 1, 0),
(26, 99, 3, '123859674', '', 'Margot van Geffen', '123589647', '25801 E 31st Ave Watkins, CO 55137', '25801 E 31st Ave Watkins, CO 55137', 'female', 'o_negative', '', '1999-09-30', 'photo-1518963516-sms.jpg', 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 0, 0, 0, 1, '2018-02-18 07:18:36', '0000-00-00 00:00:00', 1, 0),
(27, 100, 3, '123478569', '', 'Lidewij Welten', '123589647', '25801 E 31st Ave Watkins, CO 55137', '25801 E 31st Ave Watkins, CO 55137', 'female', 'a_positive', '', '1999-11-29', 'photo-1518970472-sms.jpg', 'Lorem Ipsum pätkiä, julkaistiin ja vielä myöhemmin tietokoneen julkistusohjelmissa,', 0, 0, 0, 1, '2018-02-18 09:14:32', '0000-00-00 00:00:00', 1, 0),
(28, 101, 7, '123948657', '', 'Gijs van Heumen', '123965478', '31 1st St Hamden, CT 9514', '31 1st St Hamden, CT 9514', 'male', 'b_negative', '', '1999-09-28', 'photo-1518970826-sms.jpg', 'Lorem Ipsumia'' etsittäessä löytyy monen monta nettisivua,', 0, 0, 0, 1, '2018-02-18 09:20:26', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `student_attendances`
--

CREATE TABLE IF NOT EXISTS `student_attendances` (
  `id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `month` varchar(10) CHARACTER SET utf8 NOT NULL,
  `year` varchar(10) CHARACTER SET utf8 NOT NULL,
  `day_1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_4` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_5` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_6` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_7` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_8` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_9` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_10` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_11` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_12` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_13` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_14` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_15` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_16` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_17` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_18` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_19` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_20` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_21` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_22` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_23` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_24` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_25` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_26` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_27` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_28` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_29` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_30` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_31` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_attendances`
--

INSERT INTO `student_attendances` (`id`, `student_id`, `academic_year_id`, `class_id`, `section_id`, `month`, `year`, `day_1`, `day_2`, `day_3`, `day_4`, `day_5`, `day_6`, `day_7`, `day_8`, `day_9`, `day_10`, `day_11`, `day_12`, `day_13`, `day_14`, `day_15`, `day_16`, `day_17`, `day_18`, `day_19`, `day_20`, `day_21`, `day_22`, `day_23`, `day_24`, `day_25`, `day_26`, `day_27`, `day_28`, `day_29`, `day_30`, `day_31`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 2, 1, 1, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'L', NULL, NULL, NULL, 1, '2018-02-12 03:02:16', '0000-00-00 00:00:00', 1, 0),
(2, 2, 2, 1, 1, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'L', NULL, NULL, NULL, 1, '2018-02-12 03:02:16', '0000-00-00 00:00:00', 1, 0),
(3, 3, 2, 1, 1, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'L', NULL, NULL, NULL, 1, '2018-02-12 03:02:16', '0000-00-00 00:00:00', 1, 0),
(4, 4, 2, 1, 1, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'L', NULL, NULL, NULL, 1, '2018-02-12 03:02:16', '0000-00-00 00:00:00', 1, 0),
(5, 5, 2, 1, 1, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'L', NULL, NULL, NULL, 1, '2018-02-12 03:02:16', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `subjects`
--

CREATE TABLE IF NOT EXISTS `subjects` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `type` varchar(50) CHARACTER SET utf8 NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `code` varchar(50) CHARACTER SET utf8 NOT NULL,
  `author` varchar(100) CHARACTER SET utf8 NOT NULL,
  `pass_mark` int(11) NOT NULL,
  `full_mark` int(11) NOT NULL,
  `note` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` (`id`, `class_id`, `teacher_id`, `type`, `name`, `code`, `author`, `pass_mark`, `full_mark`, `note`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 3, 'mandatory', 'English', '101', '', 40, 100, 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, '2018-02-09 10:10:28', '2018-02-09 10:13:45', 1, 1),
(2, 1, 2, 'mandatory', 'Mathematics', '102', '', 40, 100, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 10:17:19', '0000-00-00 00:00:00', 1, 0),
(3, 1, 5, 'mandatory', 'General Science', '103', '', 40, 100, 'Lorem Ipsum is not simply random text.', 1, '2018-02-09 10:20:10', '0000-00-00 00:00:00', 1, 0),
(4, 1, 10, 'optional', 'Drawing', '105', '', 20, 50, 'Lorem Ipsum is not simply random text.', 1, '2018-02-09 21:02:34', '2018-02-09 22:49:49', 1, 1),
(5, 1, 11, '', 'Religion', '104', '', 40, 100, 'Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.', 1, '2018-02-09 21:05:20', '0000-00-00 00:00:00', 1, 0),
(6, 1, 7, 'mandatory', 'History', '106', '', 40, 100, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 22:49:28', '2018-02-09 22:54:05', 1, 1),
(7, 1, 8, 'mandatory', 'Literature', '107', '', 40, 100, 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, '2018-02-09 22:53:14', '2018-02-09 22:54:42', 1, 1),
(8, 1, 9, 'mandatory', 'Political Science', '108', '', 40, 100, 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, '2018-02-09 23:01:29', '0000-00-00 00:00:00', 1, 0),
(9, 1, 12, 'mandatory', 'Agriculture', '109', '', 40, 100, 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, '2018-02-09 23:30:20', '0000-00-00 00:00:00', 1, 0),
(10, 1, 14, 'mandatory', 'Computer', '110', '', 40, 100, 'Lorem Ipsum as their default model text,', 1, '2018-02-10 03:23:14', '2018-02-10 03:24:03', 1, 1),
(11, 2, 4, 'mandatory', 'Mathematics', '202', '', 40, 100, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-10 03:28:46', '0000-00-00 00:00:00', 1, 0),
(12, 2, 3, 'mandatory', 'English', '201', '', 40, 100, 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, '2018-02-10 03:31:52', '0000-00-00 00:00:00', 1, 0),
(13, 2, 5, 'mandatory', 'General Science', '203', '', 40, 100, 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, '2018-02-10 03:34:01', '0000-00-00 00:00:00', 1, 0),
(14, 2, 10, 'mandatory', 'Drawing', '205', '', 20, 50, 'Lorem ipsum dolor sit amet..", comes from a line in section 1.10.32.', 1, '2018-02-10 03:37:06', '2018-02-10 03:37:36', 1, 1),
(15, 2, 11, 'mandatory', 'Religion', '204', '', 40, 100, 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, '2018-02-10 03:39:54', '0000-00-00 00:00:00', 1, 0),
(16, 2, 7, 'mandatory', 'History', '206', '', 40, 100, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-10 03:44:17', '0000-00-00 00:00:00', 1, 0),
(17, 2, 8, 'mandatory', 'Literature', '207', '', 40, 100, 'Lorem Ipsum is therefore always free from repetition, injected humour,', 1, '2018-02-10 03:46:49', '0000-00-00 00:00:00', 1, 0),
(18, 2, 9, 'mandatory', 'Political Science', '208', '', 40, 100, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-10 03:49:53', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `suggestions`
--

CREATE TABLE IF NOT EXISTS `suggestions` (
  `id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `note` text CHARACTER SET utf8 COLLATE utf8_estonian_ci,
  `suggestion` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `suggestions`
--

INSERT INTO `suggestions` (`id`, `exam_id`, `class_id`, `subject_id`, `academic_year_id`, `title`, `note`, `suggestion`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 1, 1, 2, 'First Term Suggestion', 'Lorem Ipsum is not simply random text.', 'suggestion-1518360846-sms.docx', 1, '2018-02-11 07:54:06', '0000-00-00 00:00:00', 1, 0),
(2, 1, 1, 2, 2, 'first Term Suggestion', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'suggestion-1518360926-sms.docx', 1, '2018-02-11 07:55:26', '0000-00-00 00:00:00', 1, 0),
(3, 1, 1, 3, 2, 'First Term Suggestion', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 'suggestion-1518360998-sms.docx', 1, '2018-02-11 07:56:38', '0000-00-00 00:00:00', 1, 0),
(4, 1, 1, 5, 2, 'First Term Suggestion', 'Lorem Ipsum is not simply random text.', 'suggestion-1518361104-sms.docx', 1, '2018-02-11 07:58:24', '0000-00-00 00:00:00', 1, 0),
(5, 1, 1, 4, 2, 'First Term Suggestion', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'suggestion-1518361171-sms.docx', 1, '2018-02-11 07:59:31', '0000-00-00 00:00:00', 1, 0),
(6, 1, 1, 6, 2, 'First Term Suggestion', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s', 'suggestion-1518361244-sms.docx', 1, '2018-02-11 08:00:44', '0000-00-00 00:00:00', 1, 0),
(7, 1, 1, 7, 2, 'First Term Suggestion', 'Lorem Ipsum is not simply random text.', 'suggestion-1518361357-sms.docx', 1, '2018-02-11 08:02:37', '0000-00-00 00:00:00', 1, 0),
(8, 1, 1, 8, 2, 'First Term Suggestion', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'suggestion-1518361946-sms.docx', 1, '2018-02-11 08:12:26', '0000-00-00 00:00:00', 1, 0),
(9, 1, 1, 9, 2, 'First Term Suggestion', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'suggestion-1518361978-sms.docx', 1, '2018-02-11 08:12:58', '0000-00-00 00:00:00', 1, 0),
(10, 1, 1, 10, 2, 'First Term Suggestion', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 'suggestion-1518362029-sms.docx', 1, '2018-02-11 08:13:49', '0000-00-00 00:00:00', 1, 0),
(11, 1, 2, 11, 2, 'First Term Suggestion', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 'suggestion-1518362112-sms.docx', 1, '2018-02-11 08:15:12', '0000-00-00 00:00:00', 1, 0),
(12, 1, 2, 13, 2, 'First Term Suggestion', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'suggestion-1518362169-sms.docx', 1, '2018-02-11 08:16:09', '0000-00-00 00:00:00', 1, 0),
(13, 1, 2, 18, 2, 'First Term Suggestion', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'suggestion-1518362281-sms.docx', 1, '2018-02-11 08:18:01', '0000-00-00 00:00:00', 1, 0),
(14, 1, 2, 12, 2, 'First Term Suggestion', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 'suggestion-1518362342-sms.docx', 1, '2018-02-11 08:19:02', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `syllabuses`
--

CREATE TABLE IF NOT EXISTS `syllabuses` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `syllabus` varchar(255) CHARACTER SET utf8 NOT NULL,
  `note` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `syllabuses`
--

INSERT INTO `syllabuses` (`id`, `class_id`, `subject_id`, `academic_year_id`, `title`, `syllabus`, `note`, `status`, `created_by`, `modified_by`, `created_at`, `modified_at`) VALUES
(1, 1, 1, 2, 'Academic Syllabus', 'syllabus-1518260192-sms.docx', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, 1, 0, '2018-02-10 03:56:32', '0000-00-00 00:00:00'),
(2, 1, 2, 2, 'Academic Syllabus', 'syllabus-1518262511-sms.docx', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, 1, 0, '2018-02-10 04:35:11', '0000-00-00 00:00:00'),
(3, 1, 3, 2, 'Academic Syllabus', 'syllabus-1518262738-sms.docx', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, 1, 0, '2018-02-10 04:38:58', '0000-00-00 00:00:00'),
(4, 1, 4, 2, 'Academic Syllabus', 'syllabus-1518262838-sms.docx', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, 1, 0, '2018-02-10 04:40:38', '0000-00-00 00:00:00'),
(5, 1, 5, 2, 'Academic Syllabus', 'syllabus-1518262848-sms.docx', 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, 1, 1, '2018-02-10 04:40:48', '2018-02-10 04:41:22'),
(6, 1, 6, 2, 'Academic Syllabus', 'syllabus-1518262999-sms.docx', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, 1, 0, '2018-02-10 04:43:19', '0000-00-00 00:00:00'),
(7, 1, 7, 2, 'Academic Syllabus', 'syllabus-1518264002-sms.docx', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, 1, 0, '2018-02-10 05:00:02', '0000-00-00 00:00:00'),
(8, 2, 11, 2, 'Academic Syllabus', 'syllabus-1518265621-sms.docx', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, 1, 1, '2018-02-10 05:27:01', '2018-02-10 05:33:30'),
(9, 2, 9, 2, 'Academic Syllabus', 'syllabus-1518265683-sms.docx', 'Lorem Ipsum available, but the majority have suffered alteration in some form,', 1, 1, 1, '2018-02-10 05:28:03', '2018-02-10 05:45:41'),
(10, 2, 12, 2, 'Academic Syllabus', 'syllabus-1518265720-sms.docx', 'Lorem Ipsum available, but the majority have suffered alteration in some form,', 1, 1, 1, '2018-02-10 05:28:40', '2018-02-10 05:33:51'),
(11, 2, 13, 2, 'Academic Syllabus', 'syllabus-1518266161-sms.docx', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s', 1, 1, 0, '2018-02-10 05:36:01', '0000-00-00 00:00:00'),
(12, 2, 15, 2, 'Academic Syllabus', 'syllabus-1518266651-sms.docx', 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s', 1, 1, 0, '2018-02-10 05:44:11', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `teachers`
--

CREATE TABLE IF NOT EXISTS `teachers` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `responsibility` varchar(255) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8 NOT NULL,
  `present_address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `permanent_address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `gender` varchar(10) CHARACTER SET utf8 NOT NULL,
  `blood_group` varchar(10) CHARACTER SET utf8 NOT NULL,
  `religion` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `dob` date NOT NULL,
  `joining_date` date NOT NULL,
  `resign_date` date DEFAULT NULL,
  `photo` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `resume` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `other_info` text,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` (`id`, `user_id`, `responsibility`, `name`, `phone`, `present_address`, `permanent_address`, `gender`, `blood_group`, `religion`, `dob`, `joining_date`, `resign_date`, `photo`, `resume`, `other_info`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 50, 'English', 'SW Ambris', '123456789', '3153 Hosea Ln Autaugaville, AL 63003', '3153 Hosea Ln Autaugaville, AL 63003', 'male', 'a_positive', '', '1987-02-14', '2018-02-01', NULL, 'photo-1518108990-sms.jpg', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-08 09:56:30', '2018-02-09 08:40:14', 1, 1),
(2, 51, 'Mathematics', 'KOK Williams', '123654789', '6261 Hosea Ln Autaugaville, FL 48003', '6261 Hosea Ln Autaugaville, FL 48003', 'male', '', '', '1987-08-22', '2018-02-06', NULL, 'photo-1518109597-sms.jpg', NULL, 'Lorem Ipsum is not simply random text.', 1, '2018-02-08 10:06:37', '2018-02-09 08:40:45', 1, 1),
(3, 52, 'English', 'Tahlia McGrath', '123456987', '3167 Hosea Ln Autaugaville, FL 21003', '3167 Hosea Ln Autaugaville, FL 21003', 'female', 'o_negative', '', '1988-03-01', '2018-02-01', NULL, 'photo-1518171795-sms.jpg', NULL, 'Lorem ipsum dolor sit amet', 1, '2018-02-09 03:23:15', '2018-02-09 08:40:59', 1, 1),
(4, 53, 'Mathematics', 'Belinda Vakarewa', '123478569', '6185 Hosea Ln Autaugaville, AL83303', '6185 Hosea Ln Autaugaville, AL83303', 'female', 'b_positive', '', '1989-03-08', '2018-02-02', NULL, 'photo-1518172607-sms.jpg', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 03:36:47', '2018-02-09 08:41:17', 1, 1),
(5, 54, 'General Science', 'Amanda Wellington', '123698547', '5213 Hosea Ln Autaugaville, AL 60303', '5213 Hosea Ln Autaugaville, AL 60303', 'female', 'a_positive', '', '1986-02-28', '2018-02-01', NULL, 'photo-1518173266-sms.jpg', NULL, 'Lorem Ipsum is not simply random text.', 1, '2018-02-09 03:47:46', '0000-00-00 00:00:00', 1, 0),
(6, 55, 'Accounting', 'KS Williamson', '123589647', '3543 Hosea Ln Autaugaville, AL 65403', '3543 Hosea Ln Autaugaville, AL 65403', 'male', 'b_negative', '', '1985-03-08', '2018-02-01', NULL, 'photo-1518174690-sms.jpg', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 04:11:30', '0000-00-00 00:00:00', 1, 0),
(7, 56, 'History', 'DAJ Bracewell', '123546879', '5440 1 Ave New York, NY 22065', '5440 1 Ave New York, NY 22065', 'male', 'b_positive', '', '1985-02-22', '2018-02-01', NULL, 'photo-1518176497-sms.jpg', NULL, 'Lorem ipsum dolor sit amet.', 1, '2018-02-09 04:41:37', '0000-00-00 00:00:00', 1, 0),
(8, 57, 'Literature', 'Washington Sundar', '123456987', '510 W 153rd St New York, NY 20409', '510 W 153rd St New York, NY 20409', 'male', 'ab_negativ', '', '1899-07-10', '2018-02-03', NULL, 'photo-1518176894-sms.jpg', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 04:48:14', '0000-00-00 00:00:00', 1, 0),
(9, 58, 'Political Science', 'Mohammed Shami', '123654789', '320 W 153rd St New York, NY 21039', '320 W 153rd St New York, NY 21039', 'male', 'a_positive', '', '1987-03-06', '2018-02-08', NULL, 'photo-1518179739-sms.jpg', NULL, 'Lorem Ipsum is not simply random text.', 1, '2018-02-09 05:32:48', '2018-02-09 05:35:39', 1, 1),
(10, 59, 'Drawing', 'Jessica Jonassen', '123698547', '30 Henderson Rd New London, CT 3520', '30 Henderson Rd New London, CT 3520', 'female', 'a_negative', '', '1992-02-09', '2018-02-04', NULL, 'photo-1518180397-sms.jpg', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 05:46:37', '2018-02-09 21:00:02', 1, 1),
(11, 60, 'Religion', 'Mohammad Nawaz', '123785469', '10 Henderson Rd New London, CT 1350', '10 Henderson Rd New London, CT 1350', 'male', 'o_positive', '', '1988-02-25', '2018-02-09', NULL, 'photo-1518190682-sms.jpg', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-09 08:38:02', '0000-00-00 00:00:00', 1, 0),
(12, 61, 'Agriculture', 'MD Gunathilaka', '123546897', '72 Henderson Rd New London, CT 7220', '72 Henderson Rd New London, CT 7220', 'male', 'o_negative', '', '1988-03-09', '2018-02-10', NULL, 'photo-1518242976-sms.jpg', NULL, 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, '2018-02-09 23:09:36', '0000-00-00 00:00:00', 1, 0),
(13, 62, 'Initiative in business', 'Tammy Beaumont', '123589674', '13560 38th Ave Watkins, CO 92137', '13560 38th Ave Watkins, CO 92137', 'female', 'b_positive', '', '1992-02-16', '2018-02-01', NULL, 'photo-1518244018-sms.jpg', NULL, 'Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s,', 1, '2018-02-09 23:26:58', '0000-00-00 00:00:00', 1, 0),
(14, 63, 'Computer', 'HDRL Thirimanne', '123587469', '67801 E 51st Ave Watkins, CO 20107', '67801 E 51st Ave Watkins, CO 20107', 'male', 'ab_negativ', '', '1989-03-04', '2018-02-19', NULL, 'photo-1518258046-sms.jpg', NULL, 'Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC,', 1, '2018-02-10 03:20:46', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `teacher_attendances`
--

CREATE TABLE IF NOT EXISTS `teacher_attendances` (
  `id` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `month` varchar(10) CHARACTER SET utf8 NOT NULL,
  `year` varchar(10) CHARACTER SET utf8 NOT NULL,
  `day_1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_3` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_4` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_5` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_6` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_7` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_8` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_9` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_10` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_11` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_12` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_13` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_14` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_15` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_16` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_17` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_18` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_19` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_20` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_21` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_22` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_23` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_24` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_25` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_26` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_27` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_28` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_29` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_30` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `day_31` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `teacher_attendances`
--

INSERT INTO `teacher_attendances` (`id`, `teacher_id`, `academic_year_id`, `month`, `year`, `day_1`, `day_2`, `day_3`, `day_4`, `day_5`, `day_6`, `day_7`, `day_8`, `day_9`, `day_10`, `day_11`, `day_12`, `day_13`, `day_14`, `day_15`, `day_16`, `day_17`, `day_18`, `day_19`, `day_20`, `day_21`, `day_22`, `day_23`, `day_24`, `day_25`, `day_26`, `day_27`, `day_28`, `day_29`, `day_30`, `day_31`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(2, 2, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(3, 3, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(4, 4, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(5, 5, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(6, 6, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(7, 7, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(8, 8, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(9, 9, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(10, 10, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(11, 11, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(12, 12, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(13, 13, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0),
(14, 14, 2, '02', '2018', 'P', NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'L', NULL, NULL, NULL, NULL, 'P', NULL, NULL, NULL, NULL, 'A', NULL, NULL, NULL, NULL, 'P', NULL, NULL, 'P', NULL, NULL, NULL, 1, '2018-02-14 02:00:23', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `text_messages`
--

CREATE TABLE IF NOT EXISTS `text_messages` (
  `id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `sender_role_id` int(11) NOT NULL,
  `receivers` text,
  `academic_year_id` int(11) NOT NULL,
  `sms_gateway` varchar(20) CHARACTER SET utf8 NOT NULL,
  `body` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `themes`
--

CREATE TABLE IF NOT EXISTS `themes` (
  `id` int(11) NOT NULL,
  `name` varchar(120) CHARACTER SET utf8 NOT NULL,
  `slug` varchar(120) CHARACTER SET utf8 NOT NULL,
  `color_code` varchar(10) CHARACTER SET utf8 NOT NULL,
  `description` text CHARACTER SET utf8 NOT NULL,
  `is_active` tinyint(1) NOT NULL COMMENT '1 = Active, 0 = Inactive',
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `name`, `slug`, `color_code`, `description`, `is_active`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 'DodgerBlue ', 'dodger-blue', '#1E90FF', 'cbcvbced', 1, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(2, 'Black ', 'black', '#23282d', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(3, 'LightSeaGreen ', 'light-sea-green', '#20B2AA', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(4, 'MediumPurple ', 'medium-purple', '#9370DB', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(5, 'Orchid', 'orchid', '#DA70D6', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(6, 'RebeccaPurple ', 'rebecca-purple', '#663399', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(7, 'Red', 'red', '#e80000', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(8, 'SlateGray', 'slate-gray', '#2A3F54', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(9, 'Maroon', 'maroon', '#800000', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(10, 'DarkOrange', 'dark-orange', '#FF8C00', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(11, 'DeepPink', 'deep-pink', '#FF1493', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0),
(12, 'LimeGreen', 'lime-green', '#32CD32', 'cbcvbced', 0, 1, '2017-08-18 12:59:25', '2017-08-18 13:03:43', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE IF NOT EXISTS `transactions` (
  `id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` varchar(20) CHARACTER SET utf8 NOT NULL,
  `bank_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `cheque_no` varchar(100) CHARACTER SET utf8 NOT NULL,
  `transaction_id` varchar(100) CHARACTER SET utf8 NOT NULL,
  `payment_date` date NOT NULL,
  `pum_first_name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `pum_email` varchar(50) CHARACTER SET utf8 NOT NULL,
  `pum_phone` varchar(20) CHARACTER SET utf8 NOT NULL,
  `stripe_card_number` varchar(50) CHARACTER SET utf8 NOT NULL,
  `note` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `academic_year_id`, `invoice_id`, `amount`, `payment_method`, `bank_name`, `cheque_no`, `transaction_id`, `payment_date`, `pum_first_name`, `pum_email`, `pum_phone`, `stripe_card_number`, `note`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 2, 1, '500.00', 'cash', '', '', '', '2018-02-20', '', '', '', '', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 1, '2018-02-13 23:30:20', '0000-00-00 00:00:00', 1, 0),
(2, 2, 2, '300.00', 'cash', '', '', '', '2018-02-25', '', '', '', '', 'Lorem Ipsum has been the industry''s standard dummy text', 1, '2018-02-13 23:31:21', '0000-00-00 00:00:00', 1, 0),
(3, 2, 3, '700.00', 'cash', '', '', '', '2018-02-28', '', '', '', '', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 1, '2018-02-13 23:35:01', '0000-00-00 00:00:00', 1, 0),
(4, 2, 4, '1000.00', 'cheque', 'Switch Bank', '123456987', '', '2018-02-22', '', '', '', '', 'Lorem Ipsum has been the industry''s standard dummy text', 1, '2018-02-13 23:36:01', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `transport_members`
--

CREATE TABLE IF NOT EXISTS `transport_members` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `route_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transport_members`
--

INSERT INTO `transport_members` (`id`, `user_id`, `route_id`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 89, 5, 1, '2018-02-13 09:39:36', '0000-00-00 00:00:00', 1, 0),
(2, 83, 4, 1, '2018-02-13 09:39:40', '0000-00-00 00:00:00', 1, 0),
(3, 81, 8, 1, '2018-02-13 09:39:43', '0000-00-00 00:00:00', 1, 0),
(4, 79, 10, 1, '2018-02-13 09:39:46', '0000-00-00 00:00:00', 1, 0),
(5, 77, 14, 1, '2018-02-13 09:39:51', '0000-00-00 00:00:00', 1, 0),
(6, 75, 13, 1, '2018-02-13 09:39:53', '0000-00-00 00:00:00', 1, 0),
(7, 74, 14, 1, '2018-02-13 09:39:56', '0000-00-00 00:00:00', 1, 0),
(8, 88, 7, 1, '2018-02-13 09:39:59', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `password` varchar(100) NOT NULL,
  `temp_password` varchar(255) DEFAULT NULL,
  `email` varchar(30) NOT NULL,
  `reset_key` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1= Active, 0 = InActive',
  `last_logged_in` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `modified_by` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `role_id`, `password`, `temp_password`, `email`, `reset_key`, `status`, `last_logged_in`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 1, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2Nw==', 'superadmin@gsms.com', '', 1, '2018-02-25 03:21:33', '2013-11-15 20:33:03', '2018-01-13 10:51:12', 0, 1),
(2, 1, 'fcea920f7412b5da7be0cf42b8c93759', 'MTIzNDU2', 'yousuf361@gmail.com', NULL, 1, '2018-02-07 23:25:25', '2017-10-15 09:50:22', '2018-01-18 06:03:25', 0, 1),
(59, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'jonassen@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-09 05:46:37', '0000-00-00 00:00:00', 1, 0),
(58, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'shami@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-09 05:32:48', '0000-00-00 00:00:00', 1, 0),
(57, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'washington@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-09 04:48:14', '0000-00-00 00:00:00', 1, 0),
(56, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'bracewell@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-09 04:41:37', '0000-00-00 00:00:00', 1, 0),
(55, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'williamson@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-09 04:11:30', '0000-00-00 00:00:00', 1, 0),
(54, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'wellington@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-09 03:47:46', '0000-00-00 00:00:00', 1, 0),
(53, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'vakarewa@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-09 03:36:47', '0000-00-00 00:00:00', 1, 0),
(52, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'mcgrath@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-09 03:23:15', '0000-00-00 00:00:00', 1, 0),
(51, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'williams@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-08 10:06:37', '0000-00-00 00:00:00', 1, 0),
(50, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'teacher@gsms.com', NULL, 1, '2018-02-25 03:17:54', '2018-02-08 09:56:30', '0000-00-00 00:00:00', 1, 0),
(49, 7, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'wdparnell@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-08 09:47:05', '0000-00-00 00:00:00', 1, 0),
(48, 9, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'bampton@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-08 09:33:16', '0000-00-00 00:00:00', 1, 0),
(47, 13, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'cheatle@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-08 09:02:53', '0000-00-00 00:00:00', 1, 0),
(46, 7, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'librarian@gsms.com', NULL, 1, '2018-02-25 03:18:45', '2018-02-08 08:50:53', '0000-00-00 00:00:00', 1, 0),
(45, 8, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'receptionist@gsms.com', NULL, 1, '2018-02-25 03:19:05', '2018-02-08 07:56:00', '0000-00-00 00:00:00', 1, 0),
(44, 2, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'admin@gsms.com', NULL, 1, '2018-02-25 03:10:48', '2018-02-08 07:35:38', '0000-00-00 00:00:00', 1, 0),
(43, 9, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'behardien@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-08 07:08:16', '0000-00-00 00:00:00', 1, 0),
(41, 6, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'accountant@gsms.com', NULL, 1, '2018-02-25 03:18:22', '2018-02-08 06:38:44', '0000-00-00 00:00:00', 1, 0),
(42, 9, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'staff@gsms.com', NULL, 1, '2018-02-25 03:23:05', '2018-02-08 06:48:27', '0000-00-00 00:00:00', 1, 0),
(60, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'nawaz@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-09 08:38:02', '0000-00-00 00:00:00', 1, 0),
(61, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'gunathilaka@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-09 23:09:36', '0000-00-00 00:00:00', 1, 0),
(62, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'beaumont@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-09 23:26:58', '0000-00-00 00:00:00', 1, 0),
(63, 5, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'thirimanne@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 03:20:46', '0000-00-00 00:00:00', 1, 0),
(64, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'guardian@gsms.com', NULL, 1, '2018-02-25 03:15:45', '2018-02-10 10:07:08', '0000-00-00 00:00:00', 1, 0),
(65, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'madushanka@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 10:14:45', '0000-00-00 00:00:00', 1, 0),
(66, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'nataliesciver@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-10 10:21:40', '0000-00-00 00:00:00', 1, 0),
(67, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'carlosricardo@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-10 10:29:11', '0000-00-00 00:00:00', 1, 0),
(68, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'nasirjaved@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-10 10:38:56', '0000-00-00 00:00:00', 1, 0),
(69, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'bismahmaroof@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 11:05:03', '0000-00-00 00:00:00', 1, 0),
(70, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'javeriakhan@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 11:49:33', '0000-00-00 00:00:00', 1, 0),
(71, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'quaraishy@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 11:57:37', '0000-00-00 00:00:00', 1, 0),
(72, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'zulfiqar@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 12:01:51', '0000-00-00 00:00:00', 1, 0),
(73, 3, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'brathwaite@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 12:06:03', '0000-00-00 00:00:00', 1, 0),
(74, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'student@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-10 22:39:53', '0000-00-00 00:00:00', 1, 0),
(75, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'jawahirshah@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-10 22:44:43', '0000-00-00 00:00:00', 1, 0),
(76, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'sikander@gsms.com', NULL, 1, '0000-00-00 00:00:00', '2018-02-10 22:59:26', '0000-00-00 00:00:00', 1, 0),
(77, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'sidraameen@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 23:16:09', '0000-00-00 00:00:00', 1, 0),
(78, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'mudassar@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 23:19:53', '0000-00-00 00:00:00', 1, 0),
(79, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'sidranawaz@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 23:24:02', '0000-00-00 00:00:00', 1, 0),
(80, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'rabiyashah@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-10 23:28:14', '0000-00-00 00:00:00', 1, 0),
(81, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'raza-ur-rehman@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-11 02:48:59', '0000-00-00 00:00:00', 1, 0),
(82, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'zahid.hussain@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-11 02:53:50', '0000-00-00 00:00:00', 1, 0),
(83, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'javeria.khan@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-11 03:00:55', '0000-00-00 00:00:00', 1, 0),
(85, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'beaumont.120@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-11 04:03:27', '0000-00-00 00:00:00', 1, 0),
(86, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'junaid.siddiqui@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-11 04:07:37', '0000-00-00 00:00:00', 1, 0),
(87, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'cummins.24@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-11 04:11:10', '0000-00-00 00:00:00', 1, 0),
(88, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'alex.hartley@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-11 04:14:38', '0000-00-00 00:00:00', 1, 0),
(89, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'k.kamyuka@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-11 04:16:26', '0000-00-00 00:00:00', 1, 0),
(90, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'neil.wagner@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-15 12:00:11', '0000-00-00 00:00:00', 1, 0),
(91, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'clairmonte.brathwaite@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-15 12:03:04', '0000-00-00 00:00:00', 1, 0),
(92, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'xan.de.waard@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-15 13:28:53', '0000-00-00 00:00:00', 1, 0),
(93, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'ar.nurse@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-15 13:39:19', '0000-00-00 00:00:00', 1, 0),
(94, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'kitty.van.male@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-15 13:43:33', '0000-00-00 00:00:00', 1, 0),
(95, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'marloes.keetels@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-17 13:00:25', '0000-00-00 00:00:00', 1, 0),
(96, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'ks.williamson@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-17 13:07:33', '0000-00-00 00:00:00', 1, 0),
(97, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'tl.seifert@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-17 13:16:59', '0000-00-00 00:00:00', 1, 0),
(98, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'hm.micholls@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-18 07:11:18', '0000-00-00 00:00:00', 1, 0),
(99, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'margot.van.geffen@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-18 07:18:36', '0000-00-00 00:00:00', 1, 0),
(100, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'lidewij.welten@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-18 09:14:32', '0000-00-00 00:00:00', 1, 0),
(101, 4, 'e10adc3949ba59abbe56e057f20f883e', 'MTIzNDU2', 'gijs.van.heumen@gsms.com', NULL, 0, '0000-00-00 00:00:00', '2018-02-18 09:20:26', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `vehicles`
--

CREATE TABLE IF NOT EXISTS `vehicles` (
  `id` int(11) NOT NULL,
  `number` varchar(100) CHARACTER SET utf8 NOT NULL,
  `model` varchar(100) CHARACTER SET utf8 NOT NULL,
  `driver` varchar(100) CHARACTER SET utf8 NOT NULL,
  `license` varchar(100) CHARACTER SET utf8 NOT NULL,
  `contact` varchar(20) CHARACTER SET utf8 NOT NULL,
  `is_allocated` tinyint(1) NOT NULL,
  `note` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vehicles`
--

INSERT INTO `vehicles` (`id`, `number`, `model`, `driver`, `license`, `contact`, `is_allocated`, `note`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 'AKW 2', 'Volvo', 'Moeen Munir Ali', 'A 1956 UK tax disc', '123456789', 1, 'Lorem Ipsum on yksinkertaisesti testausteksti,', 1, '2018-02-13 06:16:02', '0000-00-00 00:00:00', 1, 0),
(2, 'BPG 1', 'Toyota', 'BA Stokes', 'A377B7', '01587789', 1, 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 1, '2018-02-13 06:27:14', '0000-00-00 00:00:00', 1, 0),
(3, 'VAM 3', 'Subaru', 'JP Behrendorff', 'B271PO', '123654789', 1, 'Lorem Ipsumia'' etsittäessä löytyy monen monta nettisivua,', 1, '2018-02-13 06:30:11', '0000-00-00 00:00:00', 1, 0),
(4, 'VBD 4', 'Lamborghini', 'SE Marsh', 'A752PO', '123654789', 1, 'Lorem Ipsumin kappaleesta ja etsi lainauksia sanasta klassisessa kirjallisuudessa löytäen varman lähteen.', 1, '2018-02-13 06:32:20', '0000-00-00 00:00:00', 1, 0),
(5, 'BPE 5', 'BMW', 'M Mosehle', 'V752RO', '123456879', 1, 'Lorem ipsum dolor sit amet..", tulee rivistä joka on osassa 1.10.32.', 1, '2018-02-13 06:35:51', '0000-00-00 00:00:00', 1, 0),
(6, 'AKW 6', 'Lotus', 'VD Philander', '372RTB', '123547896', 1, 'Lorem Ipsum on yksinkertaisesti testausteksti, jota tulostus- ja ladontateollisuudet käyttävät.', 1, '2018-02-13 06:38:36', '0000-00-00 00:00:00', 1, 0),
(7, 'VE 6', 'Honda', 'J Blackwood', 'CD2358', '123587496', 1, 'Lorem Ipsum on ollut teollisuuden normaali testausteksti jo 1500-luvulta asti,', 1, '2018-02-13 06:41:17', '0000-00-00 00:00:00', 1, 0),
(8, 'BPJ 7', 'Lotus', 'RL Chase', '885JAG', '123658749', 1, 'Lorem Ipsum ei ole vain sattumanvarainen teksti.', 1, '2018-02-13 06:45:59', '0000-00-00 00:00:00', 1, 0),
(9, 'RT 7', 'Haval', 'SO Hetmyer', '013035EA', '123589647', 1, 'Lorem Ipsum tulee osista 1.10.32 ja 1.10.33 "de Finibus Bonorum et Malorum.', 1, '2018-02-13 06:48:31', '0000-00-00 00:00:00', 1, 0),
(10, 'VBD 9', 'Kia', 'TWM Latham', '47EKV', '123587496', 1, 'Lorem Ipsumia'' etsittäessä löytyy monen monta nettisivua, jotka ovat vasta aluillaan.', 1, '2018-02-13 06:51:06', '0000-00-00 00:00:00', 1, 0),
(11, 'NBOS 10', 'Ssangyong', 'MS Chapman', 'ISO 50166', '123698745', 1, 'Lorem Ipsum ei ole vain sattumanvarainen teksti.', 1, '2018-02-13 06:56:54', '0000-00-00 00:00:00', 1, 0),
(12, 'VAQ 22', 'McLaren', 'LRPL Taylor', 'ElL-679', '125893647', 1, 'Lorem Ipsumin kappaleesta ja etsi lainauksia sanasta klassisessa kirjallisuudessa löytäen varman lähteen.', 1, '2018-02-13 07:03:35', '0000-00-00 00:00:00', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `visitors`
--

CREATE TABLE IF NOT EXISTS `visitors` (
  `id` int(11) NOT NULL,
  `academic_year_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `phone` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `coming_from` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `reason` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `check_in` datetime DEFAULT NULL,
  `check_out` datetime DEFAULT NULL,
  `note` text CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified_by` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `visitors`
--

INSERT INTO `visitors` (`id`, `academic_year_id`, `role_id`, `user_id`, `name`, `phone`, `coming_from`, `reason`, `check_in`, `check_out`, `note`, `status`, `created_at`, `modified_at`, `created_by`, `modified_by`) VALUES
(1, 2, 4, 74, 'Gholam Nousher', '123456789', 'Academy St', 'friend', '2018-02-14 02:08:59', '2018-02-14 02:17:02', 'Lorem Ipsum has been the industry''s standard dummy text', 1, '2018-02-14 02:08:59', '2018-02-14 02:17:02', 1, 1),
(2, 2, 4, 85, 'Tapash Baisya', '123456789', 'County Road 15', 'friend', '2018-02-14 02:12:12', NULL, 'Lorem Ipsum as their default model text', 1, '2018-02-14 02:12:12', '0000-00-00 00:00:00', 1, 0),
(3, 2, 5, 50, 'Subashis Roy', '963258741', 'Dutch Island Cir', 'meeting', '2018-02-14 02:14:10', '2018-02-14 02:17:08', 'Lorem Ipsum comes from sections', 1, '2018-02-14 02:14:10', '2018-02-14 02:17:08', 1, 1),
(5, 2, 3, 64, 'Fahim Muntasir', '0123654789', 'Pickett Mill Rd', 'family', '2018-02-14 02:15:43', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 1, '2018-02-14 02:15:43', '0000-00-00 00:00:00', 1, 0),
(6, 2, 9, 42, 'Jahangir Alam', '01236547890', 'Riverview Rd', 'meeting', '2018-02-14 02:16:56', NULL, 'Lorem Ipsum available, but the majority have suffered', 1, '2018-02-14 02:16:56', '0000-00-00 00:00:00', 1, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `academic_years`
--
ALTER TABLE `academic_years`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `assignments`
--
ALTER TABLE `assignments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `books`
--
ALTER TABLE `books`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `book_issues`
--
ALTER TABLE `book_issues`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `classes`
--
ALTER TABLE `classes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `designations`
--
ALTER TABLE `designations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `emails`
--
ALTER TABLE `emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `employee_attendances`
--
ALTER TABLE `employee_attendances`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `enrollments`
--
ALTER TABLE `enrollments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `exams`
--
ALTER TABLE `exams`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `exam_attendances`
--
ALTER TABLE `exam_attendances`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `exam_schedules`
--
ALTER TABLE `exam_schedules`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expenditures`
--
ALTER TABLE `expenditures`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expenditure_heads`
--
ALTER TABLE `expenditure_heads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `grades`
--
ALTER TABLE `grades`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `guardians`
--
ALTER TABLE `guardians`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `holidays`
--
ALTER TABLE `holidays`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hostels`
--
ALTER TABLE `hostels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hostel_members`
--
ALTER TABLE `hostel_members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `income_heads`
--
ALTER TABLE `income_heads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `library_members`
--
ALTER TABLE `library_members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `marks`
--
ALTER TABLE `marks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mark_emails`
--
ALTER TABLE `mark_emails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mark_smses`
--
ALTER TABLE `mark_smses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `message_relationships`
--
ALTER TABLE `message_relationships`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `modules`
--
ALTER TABLE `modules`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notices`
--
ALTER TABLE `notices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `operations`
--
ALTER TABLE `operations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_settings`
--
ALTER TABLE `payment_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `privileges`
--
ALTER TABLE `privileges`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `replies`
--
ALTER TABLE `replies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `results`
--
ALTER TABLE `results`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `routes`
--
ALTER TABLE `routes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `routines`
--
ALTER TABLE `routines`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sms_settings`
--
ALTER TABLE `sms_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_attendances`
--
ALTER TABLE `student_attendances`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subjects`
--
ALTER TABLE `subjects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suggestions`
--
ALTER TABLE `suggestions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `syllabuses`
--
ALTER TABLE `syllabuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `teachers`
--
ALTER TABLE `teachers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `teacher_attendances`
--
ALTER TABLE `teacher_attendances`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `text_messages`
--
ALTER TABLE `text_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `themes`
--
ALTER TABLE `themes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transport_members`
--
ALTER TABLE `transport_members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vehicles`
--
ALTER TABLE `vehicles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visitors`
--
ALTER TABLE `visitors`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `academic_years`
--
ALTER TABLE `academic_years`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `assignments`
--
ALTER TABLE `assignments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `book_issues`
--
ALTER TABLE `book_issues`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `classes`
--
ALTER TABLE `classes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=252;
--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `emails`
--
ALTER TABLE `emails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `employee_attendances`
--
ALTER TABLE `employee_attendances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `enrollments`
--
ALTER TABLE `enrollments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `exams`
--
ALTER TABLE `exams`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `exam_attendances`
--
ALTER TABLE `exam_attendances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `exam_schedules`
--
ALTER TABLE `exam_schedules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `expenditures`
--
ALTER TABLE `expenditures`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `expenditure_heads`
--
ALTER TABLE `expenditure_heads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `grades`
--
ALTER TABLE `grades`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `guardians`
--
ALTER TABLE `guardians`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `holidays`
--
ALTER TABLE `holidays`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `hostels`
--
ALTER TABLE `hostels`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `hostel_members`
--
ALTER TABLE `hostel_members`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `income_heads`
--
ALTER TABLE `income_heads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=637;
--
-- AUTO_INCREMENT for table `library_members`
--
ALTER TABLE `library_members`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `marks`
--
ALTER TABLE `marks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `mark_emails`
--
ALTER TABLE `mark_emails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `mark_smses`
--
ALTER TABLE `mark_smses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `message_relationships`
--
ALTER TABLE `message_relationships`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `modules`
--
ALTER TABLE `modules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `notices`
--
ALTER TABLE `notices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `operations`
--
ALTER TABLE `operations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=70;
--
-- AUTO_INCREMENT for table `payment_settings`
--
ALTER TABLE `payment_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `privileges`
--
ALTER TABLE `privileges`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=609;
--
-- AUTO_INCREMENT for table `replies`
--
ALTER TABLE `replies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `results`
--
ALTER TABLE `results`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `routes`
--
ALTER TABLE `routes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `routines`
--
ALTER TABLE `routines`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=54;
--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `sms_settings`
--
ALTER TABLE `sms_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `student_attendances`
--
ALTER TABLE `student_attendances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `suggestions`
--
ALTER TABLE `suggestions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `syllabuses`
--
ALTER TABLE `syllabuses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `teachers`
--
ALTER TABLE `teachers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `teacher_attendances`
--
ALTER TABLE `teacher_attendances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `text_messages`
--
ALTER TABLE `text_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `transport_members`
--
ALTER TABLE `transport_members`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=102;
--
-- AUTO_INCREMENT for table `vehicles`
--
ALTER TABLE `vehicles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `visitors`
--
ALTER TABLE `visitors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;

