-- phpMyAdmin SQL Dump -- version 4.7.7 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Dec 01, 2019 at 10:47 AM -- Server version: 10.1.30-MariaDB -- PHP Version: 7.2.2 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `kattor` -- -- -------------------------------------------------------- -- -- Table structure for table `academic_syllabus` -- CREATE TABLE `academic_syllabus` ( `academic_syllabus_id` int(11) NOT NULL, `academic_syllabus_code` longtext COLLATE utf8_unicode_ci, `title` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `class_id` int(11) DEFAULT NULL, `uploader_type` longtext COLLATE utf8_unicode_ci, `uploader_id` int(11) DEFAULT NULL, `year` longtext COLLATE utf8_unicode_ci, `timestamp` longtext COLLATE utf8_unicode_ci, `file_name` longtext COLLATE utf8_unicode_ci, `subject_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `accountant` -- CREATE TABLE `accountant` ( `accountant_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `email` longtext COLLATE utf8_unicode_ci, `password` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `admin_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `email` longtext COLLATE utf8_unicode_ci, `password` longtext COLLATE utf8_unicode_ci, `level` longtext COLLATE utf8_unicode_ci, `authentication_key` longtext COLLATE utf8_unicode_ci, `phone` longtext COLLATE utf8_unicode_ci, `address` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`admin_id`, `name`, `email`, `password`, `level`, `authentication_key`, `phone`, `address`) VALUES (1, 'Saheed', 'ysbabatunde@gmail.com', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `attendance` -- CREATE TABLE `attendance` ( `attendance_id` int(11) NOT NULL, `timestamp` longtext COLLATE utf8_unicode_ci, `year` longtext COLLATE utf8_unicode_ci, `class_id` int(11) DEFAULT NULL, `section_id` int(11) DEFAULT NULL, `student_id` int(11) DEFAULT NULL, `class_routine_id` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `attendance` -- INSERT INTO `attendance` (`attendance_id`, `timestamp`, `year`, `class_id`, `section_id`, `student_id`, `class_routine_id`, `status`) VALUES (1, '1575050400', '2020-2021', 1, 1, 1, NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `book` -- CREATE TABLE `book` ( `book_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `author` longtext COLLATE utf8_unicode_ci, `class_id` longtext COLLATE utf8_unicode_ci, `price` longtext COLLATE utf8_unicode_ci, `total_copies` int(11) DEFAULT NULL, `issued_copies` int(11) DEFAULT NULL, `status` longtext COLLATE utf8_unicode_ci, `file_name` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `book_request` -- CREATE TABLE `book_request` ( `book_request_id` int(11) NOT NULL, `book_id` int(11) DEFAULT NULL, `student_id` int(11) DEFAULT NULL, `issue_start_date` longtext COLLATE utf8_unicode_ci, `issue_end_date` longtext COLLATE utf8_unicode_ci, `status` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ci_sessions` -- CREATE TABLE `ci_sessions` ( `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL, `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0', `data` blob NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `ci_sessions` -- INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('085pipo1vq3khlf61gap4q8kp40vic2v', '::1', 1575137994, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133373833323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('22ugvjer1h47qce1ccn81faulgmjuaaq', '::1', 1575099426, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353039393232323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('266dgpfppq88o6lcpfoh68h34iipcdo6', '::1', 1575106565, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353130363536333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('2acgarm45he3qtvotgtef37kfm39rglp', '::1', 1575122137, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132323133373b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a32333a2244617461204164646564205375636365737366756c6c79223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('2shu6rb8fvh25qksnqdff202ns184rop', '::1', 1575129739, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132393733393b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('3631tjop0oaocqr6tpkt1lj5754k78a5', '::1', 1575190111, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139303131313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('3cuchtftgj2o1jrpe5funj68ebjlkinu', '::1', 1575130434, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133303433343b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('3kmd8pmtelqfjibtijqur1fbqmqsdnk8', '::1', 1575128724, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132383732343b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('428qaqli0dert3fumsua0d23gi97msn4', '::1', 1575192061, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139323036313b746561636865725f6c6f67696e7c733a313a2231223b746561636865725f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a373a2274656163686572223b), ('4qna03s88l8ians0lfcgf6ghhhsdc445', '::1', 1575103206, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353130333230363b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('5i5nii9lc4o97krhvkmd4esnoeoae724', '::1', 1575189154, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353138393135343b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('5n9ljjcsnq5mh5bbev9u05frpc19dhpb', '::1', 1575191161, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139313136313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a32333a2244617461204164646564205375636365737366756c6c79223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('6h0geav8jlkbsgpsdcvf21u4ptcmaie6', '::1', 1575192532, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139323533323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a31333a224d61726b732055706461746564223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('6tiundgvdcverlueqfu08vov4lqt4uk3', '::1', 1575128413, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132383431333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a31333a224d61726b732055706461746564223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('7tdrnilrcd5e6ro8371f97cfi6nqhl65', '::1', 1575124851, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132343835313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('7uiv0sngt6i9hnlmbrelp5n1n63uk53r', '::1', 1575132590, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133323539303b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('86lulrlcig92ft7lfkoe8lmmo1rv52nq', '::1', 1575132278, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133323237383b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('8ani4id6ftg90n4vtlhcn68en54eeu97', '::1', 1575136389, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133363338393b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('8esb4160baf51u61pcnrup1bfa2tb6n8', '::1', 1575126350, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132363335303b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('99krksno8p0qpudh9g7oome8j4crd1cr', '::1', 1575100828, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353130303832383b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('b0fcsamcdcba9r677mi7no9cgpcc9020', '::1', 1575189486, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353138393438363b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('bmd13esqcn98bqevre2c81sju854o1ms', '::1', 1575121812, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132313831323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('botl9ovqfohc9gihqifbvh19u4hh21dh', '::1', 1575188544, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353138383534343b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('burqm9qlhp39iopb61g4g3n4g69ho48c', '::1', 1575187093, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353138373039333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('bvldqq16vjj8vbm8h00ibfn5oiggvmm4', '::1', 1575125532, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132353533323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('c8j908t0einm933o1rm4tvfdfgmdng2r', '::1', 1575133635, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133333633353b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('cjntne0u1ojf554rbpeppotjo6ooq9bb', '::1', 1575134284, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133343238343b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('cremltfd96qgc3ob58pckjiit07r7mrj', '::1', 1575191821, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139313832313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('d9ei77525saj9j7ccp5ptdcqg7t0ae1s', '::1', 1575130104, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133303130343b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('dit68lg3eevsls2eg7gpnesa1iujq8dp', '::1', 1575134588, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133343538383b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('doff7vkjc7g980aerb7sb5ravgerbc6b', '::1', 1575099222, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353039393232323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('eg0lpboul8m6683fdbt2a647b60m3sl9', '::1', 1575103516, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353130333531363b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('eqnpo13tsqdbdaq4ojar5kqnvspkj6mt', '::1', 1575126045, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132363034353b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('f1jl5tui1d4p27gvfig0kmc5qgq0q81r', '::1', 1575136738, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133363733383b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('fc59fa7k6np914b0l79hto4e6dqpggn9', '::1', 1575129381, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132393338313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('ffj1c7qsk179q5jk6sdo3ltr42mffs8o', '::1', 1575137832, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133373833323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a32333a2244617461204164646564205375636365737366756c6c79223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('g4igcjgoj4kje52pvppitgdrnje01ssd', '::1', 1575126687, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132363638373b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('g86ogf7rlb7aoaqi241h2fvad25obj5t', '::1', 1575192675, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139323637353b746561636865725f6c6f67696e7c733a313a2231223b746561636865725f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a373a2274656163686572223b666c6173685f6d6573736167657c733a32333a2244617461204164646564205375636365737366756c6c79223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('gadckfjoec0pde0l0oefn85luib2fbbc', '::1', 1575129063, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132393036333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('h01q12qd2sb1otprqkja00lcf6pknq6g', '::1', 1575135919, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133353931393b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('hnu44d2ilrmivjut7jo1hum97tdmr1bo', '::1', 1575100082, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353130303038323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('i0b6ccemuefmi4qj5hhqoeg6kitkbg67', '::1', 1575192911, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139323737323b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('i6532sgdqdotl7ubpfn3rff4blg7cdia', '::1', 1575188217, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353138383231373b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a32333a2244617461204164646564205375636365737366756c6c79223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('i9ik1lpjj1c4s97g1rqs0ffnu2cj8pk2', '::1', 1575133968, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133333936383b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('iq1j2an1flfq5um3b8bcqts6opdcquch', '::1', 1575123190, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132333139303b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('it9hsa99hvr0s78upnidc7kcl04r80h0', '::1', 1575135127, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133353132373b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('j5qpv4sgpe8bpjqmt1nhcqptivnmetvn', '::1', 1575131651, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133313635313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('j9b1bjdfsn82odtgado3aanq2c0vklhv', '::1', 1575122546, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132323534363b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('j9rrjq08c0cu1s9o1h5vtrosembssbbn', '::1', 1575130891, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133303839313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('jbpburn58vidlv1nff0oosff13vcsgir', '::1', 1575124533, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132343533333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('k92otm97lipaanajq4pjan4gqqed2vg8', '::1', 1575099189, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353039393138393b73747564656e745f6c6f67696e7c733a313a2231223b73747564656e745f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a31333a2259656b65656e20736168656564223b6c6f67696e5f747970657c733a373a2273747564656e74223b), ('kdruo0lvehcu0dj47pkd4undboqvi5qt', '::1', 1575127140, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132373134303b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('kn177rh7doomvh8mhqhlf1kn2t7pbnd5', '::1', 1575187671, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353138373637313b706172656e745f6c6f67696e7c733a313a2231223b706172656e745f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a393a224d722059656b65656e223b6c6f67696e5f747970657c733a363a22706172656e74223b), ('loc4dsrfmlkq631ptqta09kba17aco0b', '::1', 1575098049, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353039383034393b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a31323a22446174612055706461746564223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('m99j1p3rdqn3cj6c5bp35aaqcr7gnc86', '::1', 1575191470, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139313437303b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('mpnbplufukft18p0rvvb5t1390av4roi', '::1', 1575128093, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132383039333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('mq3nq6i291j8l8p8g2ov7vt6qkuk3rjl', '::1', 1575122883, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132323838333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('okos8kr1shq0d54o5639mhe3hhrkrmkl', '::1', 1575123741, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132333734313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('or6gnpj0vp7qfgvple2c0d4vupon6l91', '::1', 1575132909, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133323930393b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('p3rj8i8abo6sp1i4eidkf1mem0a4bf3b', '::1', 1575137197, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133373139373b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a32333a2244617461204164646564205375636365737366756c6c79223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('p9cq8naj98hbjugv1drddc16ik86cksn', '::1', 1575098664, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353039383636343b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('pmk7qmgg5t3d9avcvsq254f3icp18nm7', '::1', 1575098350, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353039383335303b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('qp0c446oathjb4a7a1jh8cbed6t1nsdl', '::1', 1575121488, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132313438383b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('rmss4c61de7moed7hgdijlra505cp1pi', '::1', 1575131977, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133313937373b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('s263a94f86j5isk7bakjae1ff6m0ac97', '::1', 1575189796, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353138393739363b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('t2c7m6m54vme9jtb0abjrb78bdjem2f2', '::1', 1575106563, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353130363536333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('theka7s11369qlrnoo3e03doopgctmdu', '::1', 1575125210, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132353231303b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('u2b2tjtitb83dd4h09j39spq34oi2bed', '::1', 1575137510, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133373531303b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('ull67gi5bvem228rf68ilucv37j3m5rb', '::1', 1575124171, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353132343137313b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('uo6g3803n7mla3k7apnf0g7oqqs26l5i', '::1', 1575193533, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139333533333b73747564656e745f6c6f67696e7c733a313a2231223b73747564656e745f69647c733a313a2233223b6c6f67696e5f757365725f69647c733a313a2233223b6e616d657c733a373a22536f6c6f6d6f6e223b6c6f67696e5f747970657c733a373a2273747564656e74223b), ('v2qkstrgp45mb90vboh0l82eq81alo5f', '::1', 1575188853, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353138383835333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b666c6173685f6d6573736167657c733a32333a2244617461204164646564205375636365737366756c6c79223b5f5f63695f766172737c613a313a7b733a31333a22666c6173685f6d657373616765223b733a333a226f6c64223b7d), ('v9eaqhg4sg4ssmd95s7mvupd3nrgfjt3', '::1', 1575103828, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353130333832383b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('vieu0j4hq2qcacavqpuo8vh7fom8bcos', '::1', 1575135447, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353133353434373b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('vm4tcamc3k01or0k4ejpa44erlpn664c', '::1', 1575193574, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353139333533343b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b), ('vo1dilf5s8jnpldqdjvua19bn5nml3b8', '::1', 1575097553, 0x5f5f63695f6c6173745f726567656e65726174657c693a313537353039373535333b61646d696e5f6c6f67696e7c733a313a2231223b61646d696e5f69647c733a313a2231223b6c6f67696e5f757365725f69647c733a313a2231223b6e616d657c733a363a22536168656564223b6c6f67696e5f747970657c733a353a2261646d696e223b); -- -------------------------------------------------------- -- -- Table structure for table `class` -- CREATE TABLE `class` ( `class_id` int(11) NOT NULL, `name` varchar(11) COLLATE utf8_unicode_ci DEFAULT '', `name_numeric` varchar(3) COLLATE utf8_unicode_ci DEFAULT '', `teacher_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `class` -- INSERT INTO `class` (`class_id`, `name`, `name_numeric`, `teacher_id`) VALUES (1, 'JSS 1', '1', 1), (2, 'JSS 2', '2', 1); -- -------------------------------------------------------- -- -- Table structure for table `class_routine` -- CREATE TABLE `class_routine` ( `class_routine_id` int(11) NOT NULL, `class_id` int(11) DEFAULT NULL, `section_id` int(11) DEFAULT NULL, `subject_id` int(11) DEFAULT NULL, `time_start` int(11) DEFAULT NULL, `time_end` int(11) DEFAULT NULL, `time_start_min` int(11) DEFAULT NULL, `time_end_min` int(11) DEFAULT NULL, `day` longtext COLLATE utf8_unicode_ci, `year` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `document` -- CREATE TABLE `document` ( `document_id` int(11) NOT NULL, `title` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `file_name` longtext COLLATE utf8_unicode_ci, `file_type` longtext COLLATE utf8_unicode_ci, `class_id` longtext COLLATE utf8_unicode_ci, `teacher_id` int(11) DEFAULT NULL, `timestamp` longtext COLLATE utf8_unicode_ci, `subject_id` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `dormitory` -- CREATE TABLE `dormitory` ( `dormitory_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `number_of_room` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `enroll` -- CREATE TABLE `enroll` ( `enroll_id` int(11) NOT NULL, `enroll_code` longtext COLLATE utf8_unicode_ci, `student_id` int(11) DEFAULT NULL, `class_id` int(11) DEFAULT NULL, `section_id` int(11) DEFAULT NULL, `roll` int(11) DEFAULT NULL, `date_added` longtext COLLATE utf8_unicode_ci, `year` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `enroll` -- INSERT INTO `enroll` (`enroll_id`, `enroll_code`, `student_id`, `class_id`, `section_id`, `roll`, `date_added`, `year`) VALUES (1, '29d759a', 1, 1, 1, NULL, '1575098788', '2020-2021'), (2, 'a8dadb3', 2, 1, 1, NULL, '1575122782', '2020-2021'), (3, '4d649f5', 3, 2, 3, NULL, '1575193135', '2020-2021'); -- -------------------------------------------------------- -- -- Table structure for table `exam` -- CREATE TABLE `exam` ( `exam_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `date` longtext COLLATE utf8_unicode_ci, `year` longtext COLLATE utf8_unicode_ci, `comment` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `exam` -- INSERT INTO `exam` (`exam_id`, `name`, `date`, `year`, `comment`) VALUES (2, 'Second Term', '11/30/2019', '2020-2021', 'Students must come early'), (3, 'First Term', '11/30/2019', '2020-2021', 'Students must come early and mark attendance'), (4, 'Third Term', '12/02/2019', '2020-2021', 'Students must come early and mark attendance'); -- -------------------------------------------------------- -- -- Table structure for table `expense_category` -- CREATE TABLE `expense_category` ( `expense_category_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `frontend_events` -- CREATE TABLE `frontend_events` ( `frontend_events_id` int(11) NOT NULL, `title` text, `timestamp` int(11) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `frontend_gallery` -- CREATE TABLE `frontend_gallery` ( `frontend_gallery_id` int(11) NOT NULL, `title` text, `description` longtext, `date_added` int(11) DEFAULT NULL, `image` text, `show_on_website` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `frontend_gallery_image` -- CREATE TABLE `frontend_gallery_image` ( `frontend_gallery_image_id` int(11) NOT NULL, `frontend_gallery_id` int(11) DEFAULT NULL, `title` text, `image` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `frontend_general_settings` -- CREATE TABLE `frontend_general_settings` ( `frontend_general_settings_id` int(11) NOT NULL, `type` varchar(255) DEFAULT NULL, `description` longtext ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `frontend_general_settings` -- INSERT INTO `frontend_general_settings` (`frontend_general_settings_id`, `type`, `description`) VALUES (1, 'about_us', ''), (2, 'terms_conditions', ''), (3, 'privacy_policy', ''), (4, 'social_links', '[{\"facebook\":\"http:\\/\\/facebook.com\",\"twitter\":\"http:\\/\\/twitter.com\",\"linkedin\":\"http:\\/\\/linkedin.com\",\"google\":\"http:\\/\\/google.com\",\"youtube\":\"http:\\/\\/youtube.com\",\"instagram\":\"http:\\/\\/instagram.com\"}]'), (5, 'school_title', 'CodeCraft Academy'), (6, 'school_logo', ''), (7, 'school_location', '51.7548164,-1.2565555'), (8, 'address', 'Apalara House, Lagos'), (9, 'phone', '08082812464'), (10, 'email', 'codecraftnigeria@gmail.com'), (11, 'fax', ''), (12, 'header_logo', 'header_imageedit_9_3881196219.png'), (13, 'footer_logo', 'footer_imageedit_9_3881196219.png'), (14, 'copyright_text', ''), (15, 'about_us_image', 'about_us_bg.png'), (16, 'slider_images', '[{\"title\":\"We rock the big stage\",\"description\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected \",\"image\":\"bg.png\"},{\"title\":\"Making this the first true generator on the Internet\",\"description\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected \",\"image\":\"never-quit-700m.jpg\"},{\"title\":\"There are many variations of passages of Lorem Ipsum\",\"description\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected \",\"image\":\"maxresdefault.jpg\"}]'), (17, 'theme', 'ultimate'), (18, 'homepage_note_title', ''), (19, 'homepage_note_description', 'Nothing goes here'), (20, 'recaptcha_site_key', ''); -- -------------------------------------------------------- -- -- Table structure for table `frontend_news` -- CREATE TABLE `frontend_news` ( `frontend_news_id` int(11) NOT NULL, `title` text COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `date_added` int(11) DEFAULT NULL, `image` text COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `grade` -- CREATE TABLE `grade` ( `grade_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `grade_point` longtext COLLATE utf8_unicode_ci, `mark_from` int(11) DEFAULT NULL, `mark_upto` int(11) DEFAULT NULL, `comment` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `grade` -- INSERT INTO `grade` (`grade_id`, `name`, `grade_point`, `mark_from`, `mark_upto`, `comment`) VALUES (1, 'A1', '5', 80, 100, 'Serious students'), (2, 'B2', '4', 70, 79, 'Serious students'), (3, 'B3', '3', 60, 69, 'Serious students'), (4, 'C4', '2', 50, 59, 'Serious students'), (5, 'C5', '1', 40, 49, 'Serious students'), (6, 'C6', '0', 0, 39, 'Serious students'); -- -------------------------------------------------------- -- -- Table structure for table `group_message` -- CREATE TABLE `group_message` ( `group_message_id` int(11) NOT NULL, `group_message_thread_code` longtext COLLATE utf8_unicode_ci, `sender` longtext COLLATE utf8_unicode_ci, `message` longtext COLLATE utf8_unicode_ci, `timestamp` longtext COLLATE utf8_unicode_ci, `read_status` int(11) DEFAULT NULL, `attached_file_name` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `group_message_thread` -- CREATE TABLE `group_message_thread` ( `group_message_thread_id` int(11) NOT NULL, `group_message_thread_code` longtext COLLATE utf8_unicode_ci, `members` longtext COLLATE utf8_unicode_ci, `group_name` longtext COLLATE utf8_unicode_ci, `last_message_timestamp` longtext COLLATE utf8_unicode_ci, `created_timestamp` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `invoice` -- CREATE TABLE `invoice` ( `invoice_id` int(11) NOT NULL, `student_id` int(11) DEFAULT NULL, `title` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `amount` int(11) DEFAULT NULL, `amount_paid` longtext COLLATE utf8_unicode_ci, `due` longtext COLLATE utf8_unicode_ci, `creation_timestamp` int(11) DEFAULT NULL, `payment_timestamp` longtext COLLATE utf8_unicode_ci, `payment_method` longtext COLLATE utf8_unicode_ci, `payment_details` longtext COLLATE utf8_unicode_ci, `status` longtext COLLATE utf8_unicode_ci, `year` longtext COLLATE utf8_unicode_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `language` -- CREATE TABLE `language` ( `id` int(11) NOT NULL, `english` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `bangali` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `librarian` -- CREATE TABLE `librarian` ( `librarian_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `email` longtext COLLATE utf8_unicode_ci, `password` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `mark` -- CREATE TABLE `mark` ( `mark_id` int(11) NOT NULL, `student_id` int(11) DEFAULT NULL, `subject_id` int(11) DEFAULT NULL, `class_id` int(11) DEFAULT NULL, `section_id` int(11) DEFAULT NULL, `exam_id` int(11) DEFAULT NULL, `mark_obtained` int(11) DEFAULT NULL, `ca` int(11) DEFAULT NULL, `mark_total` int(11) DEFAULT NULL, `comment` longtext COLLATE utf8_unicode_ci, `year` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `mark` -- INSERT INTO `mark` (`mark_id`, `student_id`, `subject_id`, `class_id`, `section_id`, `exam_id`, `mark_obtained`, `ca`, `mark_total`, `comment`, `year`) VALUES (1, 2, 1, 1, 1, 3, 55, 21, 76, 'Nice', '2020-2021'), (2, 1, 1, 1, 1, 3, 80, 20, 100, 'Very good performance', '2020-2021'), (3, 1, 2, 1, 1, 3, 80, 20, 100, 'Very good performance', '2020-2021'), (4, 2, 2, 1, 1, 3, 60, 30, 90, 'Good performance', '2020-2021'), (5, 1, 3, 1, 1, 3, 50, 50, 100, 'Poor performance', '2020-2021'), (6, 2, 3, 1, 1, 3, 60, 40, 100, 'Nice Performance', '2020-2021'), (7, 1, 4, 1, 1, 3, 80, 20, 100, 'Good', '2020-2021'), (8, 2, 4, 1, 1, 3, 30, 30, 60, 'Fair', '2020-2021'), (10, 1, 1, 1, 1, 2, 70, 3, 73, 'Good', '2020-2021'), (11, 2, 1, 1, 1, 2, 45, 43, 88, 'Keep it up', '2020-2021'), (12, 1, 2, 1, 1, 2, 66, 23, 89, 'Good Boy', '2020-2021'), (13, 2, 2, 1, 1, 2, 80, 11, 91, 'Nice', '2020-2021'), (14, 1, 3, 1, 1, 2, 45, 20, 65, 'Nice', '2020-2021'), (15, 2, 3, 1, 1, 2, 34, 4, 38, 'Good', '2020-2021'), (16, 1, 4, 1, 1, 2, 77, 23, 100, 'Good', '2020-2021'), (17, 2, 4, 1, 1, 2, 88, 10, 98, 'Nice', '2020-2021'), (18, 1, 1, 1, 1, 4, 50, 30, 80, 'Nice work', '2020-2021'), (19, 2, 1, 1, 1, 4, 30, 20, 50, 'Poor', '2020-2021'), (20, 1, 2, 1, 1, 4, 50, 20, 70, 'Well', '2020-2021'), (21, 2, 2, 1, 1, 4, 60, 30, 90, 'Good performance', '2020-2021'), (22, 1, 3, 1, 1, 4, 60, 20, 80, 'Nice', '2020-2021'), (23, 2, 3, 1, 1, 4, 70, 30, 100, 'Good', '2020-2021'), (24, 1, 4, 1, 1, 4, 70, 20, 90, 'Very Good', '2020-2021'), (25, 2, 4, 1, 1, 4, 60, 30, 90, 'Good', '2020-2021'), (26, 3, 5, 2, 3, 3, 60, 20, 80, 'Very Good', '2020-2021'); -- -------------------------------------------------------- -- -- Table structure for table `message` -- CREATE TABLE `message` ( `message_id` int(11) NOT NULL, `message_thread_code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, `message` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, `sender` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, `timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, `read_status` int(11) DEFAULT NULL, `attached_file_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `message_thread` -- CREATE TABLE `message_thread` ( `message_thread_id` int(11) NOT NULL, `message_thread_code` longtext COLLATE utf8_unicode_ci, `sender` longtext COLLATE utf8_unicode_ci, `reciever` longtext COLLATE utf8_unicode_ci, `last_message_timestamp` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `noticeboard` -- CREATE TABLE `noticeboard` ( `notice_id` int(11) NOT NULL, `notice_title` longtext COLLATE utf8_unicode_ci, `notice` longtext COLLATE utf8_unicode_ci, `create_timestamp` longtext COLLATE utf8_unicode_ci, `status` int(11) DEFAULT '1', `show_on_website` int(11) DEFAULT '0', `image` text COLLATE utf8_unicode_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `online_exam` -- CREATE TABLE `online_exam` ( `online_exam_id` int(11) UNSIGNED NOT NULL, `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `title` text COLLATE utf8_unicode_ci, `class_id` int(11) DEFAULT NULL, `section_id` int(11) DEFAULT NULL, `subject_id` int(11) DEFAULT NULL, `exam_date` int(11) DEFAULT NULL, `time_start` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `time_end` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `duration` text COLLATE utf8_unicode_ci COMMENT 'duration in second', `minimum_percentage` text COLLATE utf8_unicode_ci, `instruction` longtext COLLATE utf8_unicode_ci, `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'pending', `running_year` varchar(255) COLLATE utf8_unicode_ci DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `online_exam_result` -- CREATE TABLE `online_exam_result` ( `online_exam_result_id` int(11) UNSIGNED NOT NULL, `online_exam_id` int(11) DEFAULT NULL, `student_id` int(11) DEFAULT NULL, `answer_script` longtext COLLATE utf8_unicode_ci, `obtained_mark` text COLLATE utf8_unicode_ci, `status` text COLLATE utf8_unicode_ci, `exam_started_timestamp` longtext COLLATE utf8_unicode_ci, `result` text COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `online_exam_result` -- INSERT INTO `online_exam_result` (`online_exam_result_id`, `online_exam_id`, `student_id`, `answer_script`, `obtained_mark`, `status`, `exam_started_timestamp`, `result`) VALUES (1, 2, 1, '[{\"question_bank_id\":\"2\",\"submitted_answer\":\"true\",\"correct_answers\":\"true\"}]', '4', 'submitted', '1575099232', 'pass'); -- -------------------------------------------------------- -- -- Table structure for table `parent` -- CREATE TABLE `parent` ( `parent_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `email` longtext COLLATE utf8_unicode_ci, `password` longtext COLLATE utf8_unicode_ci, `phone` longtext COLLATE utf8_unicode_ci, `address` longtext COLLATE utf8_unicode_ci, `profession` longtext COLLATE utf8_unicode_ci, `authentication_key` longtext COLLATE utf8_unicode_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `parent` -- INSERT INTO `parent` (`parent_id`, `name`, `email`, `password`, `phone`, `address`, `profession`, `authentication_key`) VALUES (1, 'Mr Yekeen', 'b@b.com', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', '4567890', 'Apalara House, Lagos', 'Developer', NULL); -- -------------------------------------------------------- -- -- Table structure for table `payment` -- CREATE TABLE `payment` ( `payment_id` int(11) NOT NULL, `expense_category_id` int(11) DEFAULT NULL, `title` longtext COLLATE utf8_unicode_ci, `payment_type` longtext COLLATE utf8_unicode_ci, `invoice_id` int(11) DEFAULT NULL, `student_id` int(11) DEFAULT NULL, `method` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `amount` longtext COLLATE utf8_unicode_ci, `timestamp` longtext COLLATE utf8_unicode_ci, `year` longtext COLLATE utf8_unicode_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `question_bank` -- CREATE TABLE `question_bank` ( `question_bank_id` int(11) UNSIGNED NOT NULL, `online_exam_id` int(11) DEFAULT NULL, `question_title` longtext COLLATE utf8_unicode_ci, `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `number_of_options` int(11) DEFAULT NULL, `options` longtext COLLATE utf8_unicode_ci, `correct_answers` longtext COLLATE utf8_unicode_ci, `mark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `question_bank` -- INSERT INTO `question_bank` (`question_bank_id`, `online_exam_id`, `question_title`, `type`, `number_of_options`, `options`, `correct_answers`, `mark`) VALUES (1, 1, 'What is a noun?', 'true_false', NULL, NULL, 'true', '5'), (2, 2, 'What is a noun?', 'true_false', NULL, NULL, 'true', '4'); -- -------------------------------------------------------- -- -- Table structure for table `question_paper` -- CREATE TABLE `question_paper` ( `question_paper_id` int(11) NOT NULL, `title` longtext COLLATE utf8_unicode_ci, `question_paper` longtext COLLATE utf8_unicode_ci, `class_id` int(11) DEFAULT NULL, `exam_id` int(11) DEFAULT NULL, `teacher_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `remarks` -- CREATE TABLE `remarks` ( `id` int(11) NOT NULL, `student` bigint(20) NOT NULL, `class_id` int(11) NOT NULL, `exam` int(11) NOT NULL, `remark` text NOT NULL, `tremark` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `remarks` -- INSERT INTO `remarks` (`id`, `student`, `class_id`, `exam`, `remark`, `tremark`) VALUES (2, 1, 1, 2, 'Nice', 'Very%20good'), (4, 1, 1, 3, 'Nice%20work', 'Wow'), (5, 1, 1, 2, 'Nice', 'Very%20good'), (6, 1, 1, 2, 'Nice', 'Very%20good'), (7, 1, 1, 4, 'Well%20organized%20boy', 'Good%20job'); -- -------------------------------------------------------- -- -- Table structure for table `section` -- CREATE TABLE `section` ( `section_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `nick_name` longtext COLLATE utf8_unicode_ci, `class_id` int(11) DEFAULT NULL, `teacher_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `section` -- INSERT INTO `section` (`section_id`, `name`, `nick_name`, `class_id`, `teacher_id`) VALUES (1, 'Commercial', NULL, 1, 1), (2, 'Science', NULL, 1, 1), (3, 'Commercial', NULL, 2, 1); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `settings_id` int(11) NOT NULL, `type` longtext, `description` longtext ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`settings_id`, `type`, `description`) VALUES (1, 'system_name', 'CodeCraft'), (2, 'system_title', 'CodeCraft School Management System'), (3, 'address', 'Address'), (4, 'phone', '+2348161610410'), (5, 'paypal_email', NULL), (6, 'currency', 'usd'), (7, 'system_email', 'school@ekattor.com'), (20, 'active_sms_service', 'disabled'), (11, 'language', 'english'), (12, 'text_align', 'left-to-right'), (13, 'clickatell_user', ''), (14, 'clickatell_password', ''), (15, 'clickatell_api_id', ''), (16, 'skin_colour', 'default'), (17, 'twilio_account_sid', ''), (18, 'twilio_auth_token', ''), (19, 'twilio_sender_phone_number', ''), (21, 'running_year', '2020-2021'), (22, 'payumoney_merchant_key', 'sad'), (23, 'payumoney_salt_id', 'asd'), (24, 'msg91_authentication_key', NULL), (25, 'msg91_sender_ID', NULL), (26, 'msg91_route', NULL), (27, 'msg91_country_code', NULL), (28, 'purchase_code', '67'), (29, 'paypal', '[{\"active\":\"1\",\"mode\":\"sandbox\",\"sandbox_client_id\":\"AZDxjDScFpQtjWTOUtWKbyN_bDt4OgqaF4eYXlewfBP4-8aqX3PiV8e1GWU6liB2CUXlkA59kJXE7M6R\",\"production_client_id\":\"SomeId\"}]'), (30, 'stripe_keys', '[{\"active\":\"0\",\"testmode\":\"on\",\"public_key\":\"pk_test_c6VvBEbwHFdulFZ62q1IQrar\",\"secret_key\":\"sk_test_9IMkiM6Ykxr1LCe2dJ3PgaxS\",\"public_live_key\":\"pk_live_xxxxxxxxxxxxxxxxxxxxxxxx\",\"secret_live_key\":\"sk_live_xxxxxxxxxxxxxxxxxxxxxxxx\"}]'), (31, 'disable_frontend', '0'), (32, 'protocol', 'smtp'), (33, 'smtp_host', 'ssl://smtp.googlemail.com'), (34, 'smtp_port', '465'), (35, 'smtp_user', ''), (36, 'smtp_pass', ''); -- -------------------------------------------------------- -- -- Table structure for table `student` -- CREATE TABLE `student` ( `student_id` int(11) NOT NULL, `student_code` longtext COLLATE utf8_unicode_ci, `name` longtext COLLATE utf8_unicode_ci, `birthday` longtext COLLATE utf8_unicode_ci, `sex` longtext COLLATE utf8_unicode_ci, `religion` longtext COLLATE utf8_unicode_ci, `blood_group` longtext COLLATE utf8_unicode_ci, `address` longtext COLLATE utf8_unicode_ci, `phone` longtext COLLATE utf8_unicode_ci, `email` longtext COLLATE utf8_unicode_ci, `password` longtext COLLATE utf8_unicode_ci, `parent_id` int(11) DEFAULT NULL, `dormitory_id` int(11) DEFAULT NULL, `transport_id` int(11) DEFAULT NULL, `dormitory_room_number` longtext COLLATE utf8_unicode_ci, `authentication_key` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `student` -- INSERT INTO `student` (`student_id`, `student_code`, `name`, `birthday`, `sex`, `religion`, `blood_group`, `address`, `phone`, `email`, `password`, `parent_id`, `dormitory_id`, `transport_id`, `dormitory_room_number`, `authentication_key`) VALUES (1, '2acb62b', 'Yekeen saheed', '07/16/2015', 'male', NULL, NULL, 'Apalara House, Lagos', '8656565667', 'c@c.com', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', 1, NULL, NULL, NULL, NULL), (2, 'd68c04e', 'Oseni Olabisi', '10/31/2018', 'female', NULL, NULL, 'Apalara House, Lagos', '08082812464', 'e@e.com', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', 1, NULL, NULL, NULL, NULL), (3, 'a7da9c1', 'Solomon', '10/30/2018', 'male', NULL, NULL, 'Apalara House, Lagos', '08082812464', 'f@f.com', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', 1, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `subject` -- CREATE TABLE `subject` ( `subject_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `class_id` int(11) DEFAULT NULL, `teacher_id` int(11) DEFAULT NULL, `year` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `subject` -- INSERT INTO `subject` (`subject_id`, `name`, `class_id`, `teacher_id`, `year`) VALUES (1, 'Mathematics', 1, 1, '2020-2021'), (2, 'English Language', 1, 1, '2020-2021'), (3, 'Basic Science', 1, 1, '2020-2021'), (4, 'Government', 1, 1, '2020-2021'), (5, 'IRK', 2, 1, '2020-2021'); -- -------------------------------------------------------- -- -- Table structure for table `teacher` -- CREATE TABLE `teacher` ( `teacher_id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `birthday` longtext COLLATE utf8_unicode_ci, `sex` longtext COLLATE utf8_unicode_ci, `religion` longtext COLLATE utf8_unicode_ci, `blood_group` longtext COLLATE utf8_unicode_ci, `address` longtext COLLATE utf8_unicode_ci, `phone` longtext COLLATE utf8_unicode_ci, `email` longtext COLLATE utf8_unicode_ci, `password` longtext COLLATE utf8_unicode_ci, `authentication_key` longtext COLLATE utf8_unicode_ci, `designation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `social_links` text COLLATE utf8_unicode_ci, `about` longtext COLLATE utf8_unicode_ci, `show_on_website` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `teacher` -- INSERT INTO `teacher` (`teacher_id`, `name`, `birthday`, `sex`, `religion`, `blood_group`, `address`, `phone`, `email`, `password`, `authentication_key`, `designation`, `social_links`, `about`, `show_on_website`) VALUES (1, 'Saheed', '06/09/2004', 'male', NULL, NULL, 'Apalara House, Lagos', '08082812464', 'a@a.com', '86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', NULL, 'Math Teacher', '[{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}]', 'sdfg', 1); -- -------------------------------------------------------- -- -- Table structure for table `transport` -- CREATE TABLE `transport` ( `transport_id` int(11) NOT NULL, `route_name` longtext COLLATE utf8_unicode_ci, `number_of_vehicle` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `route_fare` longtext COLLATE utf8_unicode_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `academic_syllabus` -- ALTER TABLE `academic_syllabus` ADD PRIMARY KEY (`academic_syllabus_id`); -- -- Indexes for table `accountant` -- ALTER TABLE `accountant` ADD PRIMARY KEY (`accountant_id`); -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`admin_id`); -- -- Indexes for table `attendance` -- ALTER TABLE `attendance` ADD PRIMARY KEY (`attendance_id`); -- -- Indexes for table `book` -- ALTER TABLE `book` ADD PRIMARY KEY (`book_id`); -- -- Indexes for table `book_request` -- ALTER TABLE `book_request` ADD PRIMARY KEY (`book_request_id`); -- -- Indexes for table `ci_sessions` -- ALTER TABLE `ci_sessions` ADD PRIMARY KEY (`id`), ADD KEY `ci_sessions_timestamp` (`timestamp`); -- -- Indexes for table `class` -- ALTER TABLE `class` ADD PRIMARY KEY (`class_id`); -- -- Indexes for table `class_routine` -- ALTER TABLE `class_routine` ADD PRIMARY KEY (`class_routine_id`); -- -- Indexes for table `document` -- ALTER TABLE `document` ADD PRIMARY KEY (`document_id`); -- -- Indexes for table `dormitory` -- ALTER TABLE `dormitory` ADD PRIMARY KEY (`dormitory_id`); -- -- Indexes for table `enroll` -- ALTER TABLE `enroll` ADD PRIMARY KEY (`enroll_id`); -- -- Indexes for table `exam` -- ALTER TABLE `exam` ADD PRIMARY KEY (`exam_id`); -- -- Indexes for table `expense_category` -- ALTER TABLE `expense_category` ADD PRIMARY KEY (`expense_category_id`); -- -- Indexes for table `frontend_events` -- ALTER TABLE `frontend_events` ADD PRIMARY KEY (`frontend_events_id`); -- -- Indexes for table `frontend_gallery` -- ALTER TABLE `frontend_gallery` ADD PRIMARY KEY (`frontend_gallery_id`); -- -- Indexes for table `frontend_gallery_image` -- ALTER TABLE `frontend_gallery_image` ADD PRIMARY KEY (`frontend_gallery_image_id`); -- -- Indexes for table `frontend_general_settings` -- ALTER TABLE `frontend_general_settings` ADD PRIMARY KEY (`frontend_general_settings_id`); -- -- Indexes for table `frontend_news` -- ALTER TABLE `frontend_news` ADD PRIMARY KEY (`frontend_news_id`); -- -- Indexes for table `grade` -- ALTER TABLE `grade` ADD PRIMARY KEY (`grade_id`); -- -- Indexes for table `group_message` -- ALTER TABLE `group_message` ADD PRIMARY KEY (`group_message_id`); -- -- Indexes for table `group_message_thread` -- ALTER TABLE `group_message_thread` ADD PRIMARY KEY (`group_message_thread_id`); -- -- Indexes for table `invoice` -- ALTER TABLE `invoice` ADD PRIMARY KEY (`invoice_id`); -- -- Indexes for table `librarian` -- ALTER TABLE `librarian` ADD PRIMARY KEY (`librarian_id`); -- -- Indexes for table `mark` -- ALTER TABLE `mark` ADD PRIMARY KEY (`mark_id`); -- -- Indexes for table `message` -- ALTER TABLE `message` ADD PRIMARY KEY (`message_id`); -- -- Indexes for table `message_thread` -- ALTER TABLE `message_thread` ADD PRIMARY KEY (`message_thread_id`); -- -- Indexes for table `noticeboard` -- ALTER TABLE `noticeboard` ADD PRIMARY KEY (`notice_id`); -- -- Indexes for table `online_exam` -- ALTER TABLE `online_exam` ADD PRIMARY KEY (`online_exam_id`); -- -- Indexes for table `online_exam_result` -- ALTER TABLE `online_exam_result` ADD PRIMARY KEY (`online_exam_result_id`); -- -- Indexes for table `parent` -- ALTER TABLE `parent` ADD PRIMARY KEY (`parent_id`); -- -- Indexes for table `payment` -- ALTER TABLE `payment` ADD PRIMARY KEY (`payment_id`); -- -- Indexes for table `question_bank` -- ALTER TABLE `question_bank` ADD PRIMARY KEY (`question_bank_id`); -- -- Indexes for table `question_paper` -- ALTER TABLE `question_paper` ADD PRIMARY KEY (`question_paper_id`); -- -- Indexes for table `remarks` -- ALTER TABLE `remarks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `section` -- ALTER TABLE `section` ADD PRIMARY KEY (`section_id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`settings_id`); -- -- Indexes for table `student` -- ALTER TABLE `student` ADD PRIMARY KEY (`student_id`); -- -- Indexes for table `subject` -- ALTER TABLE `subject` ADD PRIMARY KEY (`subject_id`); -- -- Indexes for table `teacher` -- ALTER TABLE `teacher` ADD PRIMARY KEY (`teacher_id`); -- -- Indexes for table `transport` -- ALTER TABLE `transport` ADD PRIMARY KEY (`transport_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `academic_syllabus` -- ALTER TABLE `academic_syllabus` MODIFY `academic_syllabus_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `accountant` -- ALTER TABLE `accountant` MODIFY `accountant_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `attendance` -- ALTER TABLE `attendance` MODIFY `attendance_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `book` -- ALTER TABLE `book` MODIFY `book_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `book_request` -- ALTER TABLE `book_request` MODIFY `book_request_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `class` -- ALTER TABLE `class` MODIFY `class_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `class_routine` -- ALTER TABLE `class_routine` MODIFY `class_routine_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `document` -- ALTER TABLE `document` MODIFY `document_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dormitory` -- ALTER TABLE `dormitory` MODIFY `dormitory_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `enroll` -- ALTER TABLE `enroll` MODIFY `enroll_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `exam` -- ALTER TABLE `exam` MODIFY `exam_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `expense_category` -- ALTER TABLE `expense_category` MODIFY `expense_category_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `frontend_events` -- ALTER TABLE `frontend_events` MODIFY `frontend_events_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `frontend_gallery` -- ALTER TABLE `frontend_gallery` MODIFY `frontend_gallery_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `frontend_gallery_image` -- ALTER TABLE `frontend_gallery_image` MODIFY `frontend_gallery_image_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `frontend_general_settings` -- ALTER TABLE `frontend_general_settings` MODIFY `frontend_general_settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `frontend_news` -- ALTER TABLE `frontend_news` MODIFY `frontend_news_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `grade` -- ALTER TABLE `grade` MODIFY `grade_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `group_message` -- ALTER TABLE `group_message` MODIFY `group_message_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `group_message_thread` -- ALTER TABLE `group_message_thread` MODIFY `group_message_thread_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `invoice` -- ALTER TABLE `invoice` MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `librarian` -- ALTER TABLE `librarian` MODIFY `librarian_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `mark` -- ALTER TABLE `mark` MODIFY `mark_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `message` -- ALTER TABLE `message` MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `message_thread` -- ALTER TABLE `message_thread` MODIFY `message_thread_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `noticeboard` -- ALTER TABLE `noticeboard` MODIFY `notice_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `online_exam` -- ALTER TABLE `online_exam` MODIFY `online_exam_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `online_exam_result` -- ALTER TABLE `online_exam_result` MODIFY `online_exam_result_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `parent` -- ALTER TABLE `parent` MODIFY `parent_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `payment` -- ALTER TABLE `payment` MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `question_bank` -- ALTER TABLE `question_bank` MODIFY `question_bank_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `question_paper` -- ALTER TABLE `question_paper` MODIFY `question_paper_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `remarks` -- ALTER TABLE `remarks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `section` -- ALTER TABLE `section` MODIFY `section_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `student` -- ALTER TABLE `student` MODIFY `student_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `subject` -- ALTER TABLE `subject` MODIFY `subject_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `teacher` -- ALTER TABLE `teacher` MODIFY `teacher_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `transport` -- ALTER TABLE `transport` MODIFY `transport_id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;