-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `bhartiya_cjsis`
--

DELIMITER $$
--
-- Procedures
--
$$

$$

$$

$$

$$

$$

$$

DELIMITER ;

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

--
-- Table structure for table `blood_groups`
--

CREATE TABLE `blood_groups` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blood_groups`
--

INSERT INTO `blood_groups` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'O-', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(2, 'O+', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(3, 'A+', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(4, 'A-', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(5, 'B+', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(6, 'B-', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(7, 'AB+', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(8, 'AB-', '2023-09-07 16:30:24', '2023-09-07 16:30:24');

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

--
-- Table structure for table `books`
--

CREATE TABLE `books` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `my_class_id` int UNSIGNED DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `book_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_copies` int DEFAULT NULL,
  `issued_copies` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `book_requests`
--

CREATE TABLE `book_requests` (
  `id` int UNSIGNED NOT NULL,
  `book_id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `start_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `returned` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `class_types`
--

CREATE TABLE `class_types` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_types`
--

INSERT INTO `class_types` (`id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(1, 'Creche', 'C', NULL, NULL),
(2, 'Pre Nursery', 'PN', NULL, NULL),
(3, 'Nursery', 'N', NULL, NULL),
(4, 'Primary', 'P', NULL, NULL),
(5, 'Junior Secondary', 'J', NULL, NULL),
(6, 'Senior Secondary', 'S', NULL, NULL);

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

--
-- Table structure for table `dorms`
--

CREATE TABLE `dorms` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dorms`
--

INSERT INTO `dorms` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Faith Hostel', NULL, NULL, NULL),
(2, 'Peace Hostel', NULL, NULL, NULL),
(3, 'Grace Hostel', NULL, NULL, NULL),
(4, 'Success Hostel', NULL, NULL, NULL),
(5, 'Trust Hostel', NULL, NULL, NULL),
(7, 'diamond', NULL, '2023-09-11 15:00:22', '2023-09-11 15:00:22');

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

--
-- Table structure for table `exams`
--

CREATE TABLE `exams` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `term` tinyint NOT NULL,
  `year` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exams`
--

INSERT INTO `exams` (`id`, `name`, `term`, `year`, `created_at`, `updated_at`) VALUES
(1, 'Mid semesters', 2, '2023-2024', '2023-09-08 14:51:48', '2023-09-08 14:51:54'),
(2, 'First semester', 1, '2023-2024', '2023-09-08 14:52:39', '2023-09-08 14:52:39'),
(8, 'final semester', 3, '2023-2024', '2023-09-08 15:34:08', '2023-09-08 15:34:08');

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

--
-- Table structure for table `exam_records`
--

CREATE TABLE `exam_records` (
  `id` int UNSIGNED NOT NULL,
  `exam_id` int UNSIGNED NOT NULL,
  `student_id` int UNSIGNED NOT NULL,
  `my_class_id` int UNSIGNED NOT NULL,
  `section_id` int UNSIGNED NOT NULL,
  `total` int DEFAULT NULL,
  `ave` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class_ave` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pos` int DEFAULT NULL,
  `af` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ps` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `p_comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `t_comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exam_records`
--

INSERT INTO `exam_records` (`id`, `exam_id`, `student_id`, `my_class_id`, `section_id`, `total`, `ave`, `class_ave`, `pos`, `af`, `ps`, `p_comment`, `t_comment`, `year`, `created_at`, `updated_at`) VALUES
(1, 2, 64, 12, 15, 178, '89', '76.9', 1, '5,5,5,5,5,4,5', '3,4,4,2,5,1,2', 'good behaviour', 'very clam child', '2023-2024', '2023-09-11 16:51:01', '2023-09-12 10:00:06'),
(2, 2, 66, 12, 15, 143, '71.5', '76.9', 3, NULL, NULL, NULL, NULL, '2023-2024', '2023-09-11 17:06:54', '2023-09-12 10:00:06'),
(3, 2, 67, 12, 15, 156, '78', '76.9', 2, NULL, NULL, NULL, NULL, '2023-2024', '2023-09-12 09:58:44', '2023-09-12 10:00:06'),
(4, 2, 68, 12, 15, 138, '69', '76.9', 4, '2,3,4,2,2,4,4', NULL, NULL, 'good behaviour', '2023-2024', '2023-09-12 09:58:44', '2023-09-12 13:45:06');

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

--
-- Table structure for table `grades`
--

CREATE TABLE `grades` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_type_id` int UNSIGNED DEFAULT NULL,
  `mark_from` tinyint NOT NULL,
  `mark_to` tinyint NOT NULL,
  `remark` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grades`
--

INSERT INTO `grades` (`id`, `name`, `class_type_id`, `mark_from`, `mark_to`, `remark`, `created_at`, `updated_at`) VALUES
(1, 'A', NULL, 70, 100, 'Excellent', NULL, NULL),
(2, 'B', NULL, 60, 69, 'Very Good', NULL, NULL),
(3, 'C', NULL, 50, 59, 'Good', NULL, NULL),
(4, 'D', NULL, 45, 49, 'Pass', NULL, NULL),
(5, 'E', NULL, 40, 44, 'Poor', NULL, NULL),
(6, 'F', NULL, 0, 39, 'Fail', NULL, NULL);

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

--
-- Table structure for table `lgas`
--

CREATE TABLE `lgas` (
  `id` int UNSIGNED NOT NULL,
  `state_id` int UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lgas`
--

INSERT INTO `lgas` (`id`, `state_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 'Aba North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(2, 1, 'Aba South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(3, 1, 'Arochukwu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(4, 1, 'Bende', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(5, 1, 'Ikwuano', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(6, 1, 'Isiala Ngwa North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(7, 1, 'Isiala Ngwa South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(8, 1, 'Isuikwuato', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(9, 1, 'Obi Ngwa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(10, 1, 'Ohafia', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(11, 1, 'Osisioma', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(12, 1, 'Ugwunagbo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(13, 1, 'Ukwa East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(14, 1, 'Ukwa West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(15, 1, 'Umuahia North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(16, 1, 'Umuahia South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(17, 1, 'Umu Nneochi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(18, 2, 'Demsa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(19, 2, 'Fufure', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(20, 2, 'Ganye', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(21, 2, 'Gayuk', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(22, 2, 'Gombi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(23, 2, 'Grie', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(24, 2, 'Hong', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(25, 2, 'Jada', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(26, 2, 'Larmurde', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(27, 2, 'Madagali', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(28, 2, 'Maiha', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(29, 2, 'Mayo Belwa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(30, 2, 'Michika', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(31, 2, 'Mubi North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(32, 2, 'Mubi South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(33, 2, 'Numan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(34, 2, 'Shelleng', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(35, 2, 'Song', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(36, 2, 'Toungo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(37, 2, 'Yola North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(38, 2, 'Yola South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(39, 3, 'Abak', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(40, 3, 'Eastern Obolo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(41, 3, 'Eket', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(42, 3, 'Esit Eket', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(43, 3, 'Essien Udim', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(44, 3, 'Etim Ekpo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(45, 3, 'Etinan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(46, 3, 'Ibeno', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(47, 3, 'Ibesikpo Asutan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(48, 3, 'Ibiono-Ibom', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(49, 3, 'Ika', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(50, 3, 'Ikono', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(51, 3, 'Ikot Abasi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(52, 3, 'Ikot Ekpene', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(53, 3, 'Ini', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(54, 3, 'Itu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(55, 3, 'Mbo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(56, 3, 'Mkpat-Enin', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(57, 3, 'Nsit-Atai', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(58, 3, 'Nsit-Ibom', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(59, 3, 'Nsit-Ubium', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(60, 3, 'Obot Akara', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(61, 3, 'Okobo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(62, 3, 'Onna', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(63, 3, 'Oron', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(64, 3, 'Oruk Anam', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(65, 3, 'Udung-Uko', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(66, 3, 'Ukanafun', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(67, 3, 'Uruan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(68, 3, 'Urue-Offong/Oruko', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(69, 3, 'Uyo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(70, 4, 'Aguata', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(71, 4, 'Anambra East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(72, 4, 'Anambra West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(73, 4, 'Anaocha', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(74, 4, 'Awka North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(75, 4, 'Awka South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(76, 4, 'Ayamelum', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(77, 4, 'Dunukofia', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(78, 4, 'Ekwusigo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(79, 4, 'Idemili North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(80, 4, 'Idemili South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(81, 4, 'Ihiala', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(82, 4, 'Njikoka', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(83, 4, 'Nnewi North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(84, 4, 'Nnewi South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(85, 4, 'Ogbaru', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(86, 4, 'Onitsha North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(87, 4, 'Onitsha South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(88, 4, 'Orumba North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(89, 4, 'Orumba South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(90, 4, 'Oyi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(91, 5, 'Alkaleri', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(92, 5, 'Bauchi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(93, 5, 'Bogoro', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(94, 5, 'Damban', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(95, 5, 'Darazo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(96, 5, 'Dass', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(97, 5, 'Gamawa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(98, 5, 'Ganjuwa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(99, 5, 'Giade', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(100, 5, 'Itas/Gadau', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(101, 5, 'Jama\'are', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(102, 5, 'Katagum', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(103, 5, 'Kirfi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(104, 5, 'Misau', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(105, 5, 'Ningi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(106, 5, 'Shira', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(107, 5, 'Tafawa Balewa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(108, 5, 'Toro', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(109, 5, 'Warji', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(110, 5, 'Zaki', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(111, 6, 'Brass', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(112, 6, 'Ekeremor', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(113, 6, 'Kolokuma/Opokuma', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(114, 6, 'Nembe', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(115, 6, 'Ogbia', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(116, 6, 'Sagbama', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(117, 6, 'Southern Ijaw', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(118, 6, 'Yenagoa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(119, 7, 'Agatu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(120, 7, 'Apa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(121, 7, 'Ado', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(122, 7, 'Buruku', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(123, 7, 'Gboko', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(124, 7, 'Guma', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(125, 7, 'Gwer East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(126, 7, 'Gwer West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(127, 7, 'Katsina-Ala', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(128, 7, 'Konshisha', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(129, 7, 'Kwande', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(130, 7, 'Logo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(131, 7, 'Makurdi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(132, 7, 'Obi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(133, 7, 'Ogbadibo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(134, 7, 'Ohimini', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(135, 7, 'Oju', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(136, 7, 'Okpokwu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(137, 7, 'Oturkpo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(138, 7, 'Tarka', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(139, 7, 'Ukum', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(140, 7, 'Ushongo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(141, 7, 'Vandeikya', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(142, 8, 'Abadam', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(143, 8, 'Askira/Uba', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(144, 8, 'Bama', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(145, 8, 'Bayo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(146, 8, 'Biu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(147, 8, 'Chibok', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(148, 8, 'Damboa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(149, 8, 'Dikwa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(150, 8, 'Gubio', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(151, 8, 'Guzamala', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(152, 8, 'Gwoza', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(153, 8, 'Hawul', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(154, 8, 'Jere', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(155, 8, 'Kaga', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(156, 8, 'Kala/Balge', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(157, 8, 'Konduga', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(158, 8, 'Kukawa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(159, 8, 'Kwaya Kusar', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(160, 8, 'Mafa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(161, 8, 'Magumeri', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(162, 8, 'Maiduguri', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(163, 8, 'Marte', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(164, 8, 'Mobbar', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(165, 8, 'Monguno', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(166, 8, 'Ngala', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(167, 8, 'Nganzai', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(168, 8, 'Shani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(169, 9, 'Abi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(170, 9, 'Akamkpa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(171, 9, 'Akpabuyo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(172, 9, 'Bakassi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(173, 9, 'Bekwarra', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(174, 9, 'Biase', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(175, 9, 'Boki', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(176, 9, 'Calabar Municipal', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(177, 9, 'Calabar South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(178, 9, 'Etung', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(179, 9, 'Ikom', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(180, 9, 'Obanliku', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(181, 9, 'Obubra', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(182, 9, 'Obudu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(183, 9, 'Odukpani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(184, 9, 'Ogoja', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(185, 9, 'Yakuur', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(186, 9, 'Yala', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(187, 10, 'Aniocha North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(188, 10, 'Aniocha South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(189, 10, 'Bomadi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(190, 10, 'Burutu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(191, 10, 'Ethiope East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(192, 10, 'Ethiope West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(193, 10, 'Ika North East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(194, 10, 'Ika South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(195, 10, 'Isoko North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(196, 10, 'Isoko South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(197, 10, 'Ndokwa East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(198, 10, 'Ndokwa West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(199, 10, 'Okpe', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(200, 10, 'Oshimili North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(201, 10, 'Oshimili South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(202, 10, 'Patani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(203, 10, 'Sapele, Delta', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(204, 10, 'Udu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(205, 10, 'Ughelli North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(206, 10, 'Ughelli South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(207, 10, 'Ukwuani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(208, 10, 'Uvwie', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(209, 10, 'Warri North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(210, 10, 'Warri South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(211, 10, 'Warri South West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(212, 11, 'Abakaliki', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(213, 11, 'Afikpo North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(214, 11, 'Afikpo South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(215, 11, 'Ebonyi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(216, 11, 'Ezza North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(217, 11, 'Ezza South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(218, 11, 'Ikwo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(219, 11, 'Ishielu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(220, 11, 'Ivo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(221, 11, 'Izzi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(222, 11, 'Ohaozara', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(223, 11, 'Ohaukwu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(224, 11, 'Onicha', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(225, 12, 'Akoko-Edo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(226, 12, 'Egor', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(227, 12, 'Esan Central', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(228, 12, 'Esan North-East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(229, 12, 'Esan South-East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(230, 12, 'Esan West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(231, 12, 'Etsako Central', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(232, 12, 'Etsako East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(233, 12, 'Etsako West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(234, 12, 'Igueben', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(235, 12, 'Ikpoba Okha', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(236, 12, 'Orhionmwon', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(237, 12, 'Oredo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(238, 12, 'Ovia North-East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(239, 12, 'Ovia South-West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(240, 12, 'Owan East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(241, 12, 'Owan West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(242, 12, 'Uhunmwonde', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(243, 13, 'Ado Ekiti', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(244, 13, 'Efon', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(245, 13, 'Ekiti East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(246, 13, 'Ekiti South-West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(247, 13, 'Ekiti West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(248, 13, 'Emure', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(249, 13, 'Gbonyin', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(250, 13, 'Ido Osi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(251, 13, 'Ijero', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(252, 13, 'Ikere', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(253, 13, 'Ikole', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(254, 13, 'Ilejemeje', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(255, 13, 'Irepodun/Ifelodun', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(256, 13, 'Ise/Orun', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(257, 13, 'Moba', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(258, 13, 'Oye', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(259, 14, 'Aninri', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(260, 14, 'Awgu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(261, 14, 'Enugu East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(262, 14, 'Enugu North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(263, 14, 'Enugu South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(264, 14, 'Ezeagu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(265, 14, 'Igbo Etiti', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(266, 14, 'Igbo Eze North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(267, 14, 'Igbo Eze South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(268, 14, 'Isi Uzo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(269, 14, 'Nkanu East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(270, 14, 'Nkanu West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(271, 14, 'Nsukka', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(272, 14, 'Oji River', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(273, 14, 'Udenu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(274, 14, 'Udi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(275, 14, 'Uzo Uwani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(276, 15, 'Abaji', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(277, 15, 'Bwari', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(278, 15, 'Gwagwalada', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(279, 15, 'Kuje', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(280, 15, 'Kwali', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(281, 15, 'Municipal Area Council', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(282, 16, 'Akko', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(283, 16, 'Balanga', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(284, 16, 'Billiri', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(285, 16, 'Dukku', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(286, 16, 'Funakaye', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(287, 16, 'Gombe', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(288, 16, 'Kaltungo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(289, 16, 'Kwami', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(290, 16, 'Nafada', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(291, 16, 'Shongom', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(292, 16, 'Yamaltu/Deba', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(293, 17, 'Aboh Mbaise', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(294, 17, 'Ahiazu Mbaise', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(295, 17, 'Ehime Mbano', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(296, 17, 'Ezinihitte', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(297, 17, 'Ideato North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(298, 17, 'Ideato South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(299, 17, 'Ihitte/Uboma', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(300, 17, 'Ikeduru', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(301, 17, 'Isiala Mbano', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(302, 17, 'Isu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(303, 17, 'Mbaitoli', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(304, 17, 'Ngor Okpala', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(305, 17, 'Njaba', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(306, 17, 'Nkwerre', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(307, 17, 'Nwangele', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(308, 17, 'Obowo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(309, 17, 'Oguta', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(310, 17, 'Ohaji/Egbema', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(311, 17, 'Okigwe', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(312, 17, 'Orlu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(313, 17, 'Orsu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(314, 17, 'Oru East', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(315, 17, 'Oru West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(316, 17, 'Owerri Municipal', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(317, 17, 'Owerri North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(318, 17, 'Owerri West', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(319, 17, 'Unuimo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(320, 18, 'Auyo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(321, 18, 'Babura', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(322, 18, 'Biriniwa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(323, 18, 'Birnin Kudu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(324, 18, 'Buji', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(325, 18, 'Dutse', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(326, 18, 'Gagarawa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(327, 18, 'Garki', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(328, 18, 'Gumel', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(329, 18, 'Guri', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(330, 18, 'Gwaram', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(331, 18, 'Gwiwa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(332, 18, 'Hadejia', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(333, 18, 'Jahun', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(334, 18, 'Kafin Hausa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(335, 18, 'Kazaure', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(336, 18, 'Kiri Kasama', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(337, 18, 'Kiyawa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(338, 18, 'Kaugama', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(339, 18, 'Maigatari', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(340, 18, 'Malam Madori', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(341, 18, 'Miga', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(342, 18, 'Ringim', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(343, 18, 'Roni', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(344, 18, 'Sule Tankarkar', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(345, 18, 'Taura', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(346, 18, 'Yankwashi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(347, 19, 'Birnin Gwari', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(348, 19, 'Chikun', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(349, 19, 'Giwa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(350, 19, 'Igabi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(351, 19, 'Ikara', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(352, 19, 'Jaba', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(353, 19, 'Jema\'a', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(354, 19, 'Kachia', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(355, 19, 'Kaduna North', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(356, 19, 'Kaduna South', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(357, 19, 'Kagarko', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(358, 19, 'Kajuru', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(359, 19, 'Kaura', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(360, 19, 'Kauru', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(361, 19, 'Kubau', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(362, 19, 'Kudan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(363, 19, 'Lere', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(364, 19, 'Makarfi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(365, 19, 'Sabon Gari', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(366, 19, 'Sanga', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(367, 19, 'Soba', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(368, 19, 'Zangon Kataf', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(369, 19, 'Zaria', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(370, 20, 'Ajingi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(371, 20, 'Albasu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(372, 20, 'Bagwai', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(373, 20, 'Bebeji', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(374, 20, 'Bichi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(375, 20, 'Bunkure', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(376, 20, 'Dala', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(377, 20, 'Dambatta', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(378, 20, 'Dawakin Kudu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(379, 20, 'Dawakin Tofa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(380, 20, 'Doguwa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(381, 20, 'Fagge', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(382, 20, 'Gabasawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(383, 20, 'Garko', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(384, 20, 'Garun Mallam', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(385, 20, 'Gaya', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(386, 20, 'Gezawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(387, 20, 'Gwale', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(388, 20, 'Gwarzo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(389, 20, 'Kabo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(390, 20, 'Kano Municipal', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(391, 20, 'Karaye', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(392, 20, 'Kibiya', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(393, 20, 'Kiru', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(394, 20, 'Kumbotso', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(395, 20, 'Kunchi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(396, 20, 'Kura', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(397, 20, 'Madobi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(398, 20, 'Makoda', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(399, 20, 'Minjibir', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(400, 20, 'Nasarawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(401, 20, 'Rano', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(402, 20, 'Rimin Gado', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(403, 20, 'Rogo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(404, 20, 'Shanono', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(405, 20, 'Sumaila', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(406, 20, 'Takai', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(407, 20, 'Tarauni', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(408, 20, 'Tofa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(409, 20, 'Tsanyawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(410, 20, 'Tudun Wada', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(411, 20, 'Ungogo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(412, 20, 'Warawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(413, 20, 'Wudil', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(414, 21, 'Bakori', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(415, 21, 'Batagarawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(416, 21, 'Batsari', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(417, 21, 'Baure', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(418, 21, 'Bindawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(419, 21, 'Charanchi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(420, 21, 'Dandume', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(421, 21, 'Danja', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(422, 21, 'Dan Musa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(423, 21, 'Daura', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(424, 21, 'Dutsi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(425, 21, 'Dutsin Ma', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(426, 21, 'Faskari', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(427, 21, 'Funtua', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(428, 21, 'Ingawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(429, 21, 'Jibia', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(430, 21, 'Kafur', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(431, 21, 'Kaita', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(432, 21, 'Kankara', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(433, 21, 'Kankia', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(434, 21, 'Katsina', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(435, 21, 'Kurfi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(436, 21, 'Kusada', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(437, 21, 'Mai\'Adua', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(438, 21, 'Malumfashi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(439, 21, 'Mani', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(440, 21, 'Mashi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(441, 21, 'Matazu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(442, 21, 'Musawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(443, 21, 'Rimi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(444, 21, 'Sabuwa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(445, 21, 'Safana', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(446, 21, 'Sandamu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(447, 21, 'Zango', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(448, 22, 'Aleiro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(449, 22, 'Arewa Dandi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(450, 22, 'Argungu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(451, 22, 'Augie', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(452, 22, 'Bagudo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(453, 22, 'Birnin Kebbi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(454, 22, 'Bunza', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(455, 22, 'Dandi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(456, 22, 'Fakai', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(457, 22, 'Gwandu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(458, 22, 'Jega', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(459, 22, 'Kalgo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(460, 22, 'Koko/Besse', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(461, 22, 'Maiyama', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(462, 22, 'Ngaski', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(463, 22, 'Sakaba', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(464, 22, 'Shanga', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(465, 22, 'Suru', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(466, 22, 'Wasagu/Danko', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(467, 22, 'Yauri', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(468, 22, 'Zuru', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(469, 23, 'Adavi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(470, 23, 'Ajaokuta', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(471, 23, 'Ankpa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(472, 23, 'Bassa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(473, 23, 'Dekina', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(474, 23, 'Ibaji', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(475, 23, 'Idah', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(476, 23, 'Igalamela Odolu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(477, 23, 'Ijumu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(478, 23, 'Kabba/Bunu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(479, 23, 'Kogi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(480, 23, 'Lokoja', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(481, 23, 'Mopa Muro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(482, 23, 'Ofu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(483, 23, 'Ogori/Magongo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(484, 23, 'Okehi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(485, 23, 'Okene', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(486, 23, 'Olamaboro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(487, 23, 'Omala', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(488, 23, 'Yagba East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(489, 23, 'Yagba West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(490, 24, 'Asa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(491, 24, 'Baruten', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(492, 24, 'Edu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(493, 24, 'Ekiti, Kwara State', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(494, 24, 'Ifelodun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(495, 24, 'Ilorin East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(496, 24, 'Ilorin South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(497, 24, 'Ilorin West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(498, 24, 'Irepodun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(499, 24, 'Isin', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(500, 24, 'Kaiama', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(501, 24, 'Moro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(502, 24, 'Offa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(503, 24, 'Oke Ero', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(504, 24, 'Oyun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(505, 24, 'Pategi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(506, 25, 'Agege', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(507, 25, 'Ajeromi-Ifelodun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(508, 25, 'Alimosho', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(509, 25, 'Amuwo-Odofin', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(510, 25, 'Apapa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(511, 25, 'Badagry', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(512, 25, 'Epe', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(513, 25, 'Eti Osa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(514, 25, 'Ibeju-Lekki', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(515, 25, 'Ifako-Ijaiye', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(516, 25, 'Ikeja', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(517, 25, 'Ikorodu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(518, 25, 'Kosofe', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(519, 25, 'Lagos Island', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(520, 25, 'Lagos Mainland', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(521, 25, 'Mushin', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(522, 25, 'Ojo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(523, 25, 'Oshodi-Isolo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(524, 25, 'Shomolu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(525, 25, 'Surulere, Lagos State', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(526, 26, 'Akwanga', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(527, 26, 'Awe', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(528, 26, 'Doma', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(529, 26, 'Karu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(530, 26, 'Keana', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(531, 26, 'Keffi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(532, 26, 'Kokona', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(533, 26, 'Lafia', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(534, 26, 'Nasarawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(535, 26, 'Nasarawa Egon', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(536, 26, 'Obi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(537, 26, 'Toto', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(538, 26, 'Wamba', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(539, 27, 'Agaie', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(540, 27, 'Agwara', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(541, 27, 'Bida', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(542, 27, 'Borgu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(543, 27, 'Bosso', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(544, 27, 'Chanchaga', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(545, 27, 'Edati', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(546, 27, 'Gbako', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(547, 27, 'Gurara', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(548, 27, 'Katcha', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(549, 27, 'Kontagora', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(550, 27, 'Lapai', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(551, 27, 'Lavun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(552, 27, 'Magama', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(553, 27, 'Mariga', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(554, 27, 'Mashegu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(555, 27, 'Mokwa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(556, 27, 'Moya', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(557, 27, 'Paikoro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(558, 27, 'Rafi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(559, 27, 'Rijau', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(560, 27, 'Shiroro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(561, 27, 'Suleja', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(562, 27, 'Tafa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(563, 27, 'Wushishi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(564, 28, 'Abeokuta North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(565, 28, 'Abeokuta South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(566, 28, 'Ado-Odo/Ota', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(567, 28, 'Egbado North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(568, 28, 'Egbado South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(569, 28, 'Ewekoro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(570, 28, 'Ifo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(571, 28, 'Ijebu East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(572, 28, 'Ijebu North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(573, 28, 'Ijebu North East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(574, 28, 'Ijebu Ode', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(575, 28, 'Ikenne', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(576, 28, 'Imeko Afon', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(577, 28, 'Ipokia', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(578, 28, 'Obafemi Owode', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(579, 28, 'Odeda', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(580, 28, 'Odogbolu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(581, 28, 'Ogun Waterside', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(582, 28, 'Remo North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(583, 28, 'Shagamu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(584, 29, 'Akoko North-East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(585, 29, 'Akoko North-West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(586, 29, 'Akoko South-West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(587, 29, 'Akoko South-East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(588, 29, 'Akure North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(589, 29, 'Akure South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(590, 29, 'Ese Odo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(591, 29, 'Idanre', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(592, 29, 'Ifedore', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(593, 29, 'Ilaje', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(594, 29, 'Ile Oluji/Okeigbo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(595, 29, 'Irele', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(596, 29, 'Odigbo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(597, 29, 'Okitipupa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(598, 29, 'Ondo East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(599, 29, 'Ondo West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(600, 29, 'Ose', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(601, 29, 'Owo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(602, 30, 'Atakunmosa East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(603, 30, 'Atakunmosa West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(604, 30, 'Aiyedaade', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(605, 30, 'Aiyedire', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(606, 30, 'Boluwaduro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(607, 30, 'Boripe', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(608, 30, 'Ede North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(609, 30, 'Ede South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(610, 30, 'Ife Central', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(611, 30, 'Ife East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(612, 30, 'Ife North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(613, 30, 'Ife South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(614, 30, 'Egbedore', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(615, 30, 'Ejigbo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(616, 30, 'Ifedayo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(617, 30, 'Ifelodun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(618, 30, 'Ila', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(619, 30, 'Ilesa East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(620, 30, 'Ilesa West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(621, 30, 'Irepodun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(622, 30, 'Irewole', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(623, 30, 'Isokan', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(624, 30, 'Iwo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(625, 30, 'Obokun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(626, 30, 'Odo Otin', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(627, 30, 'Ola Oluwa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(628, 30, 'Olorunda', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(629, 30, 'Oriade', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(630, 30, 'Orolu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(631, 30, 'Osogbo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(632, 31, 'Afijio', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(633, 31, 'Akinyele', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(634, 31, 'Atiba', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(635, 31, 'Atisbo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(636, 31, 'Egbeda', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(637, 31, 'Ibadan North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(638, 31, 'Ibadan North-East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(639, 31, 'Ibadan North-West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(640, 31, 'Ibadan South-East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(641, 31, 'Ibadan South-West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(642, 31, 'Ibarapa Central', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(643, 31, 'Ibarapa East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(644, 31, 'Ibarapa North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(645, 31, 'Ido', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(646, 31, 'Irepo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(647, 31, 'Iseyin', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(648, 31, 'Itesiwaju', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(649, 31, 'Iwajowa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(650, 31, 'Kajola', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(651, 31, 'Lagelu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(652, 31, 'Ogbomosho North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(653, 31, 'Ogbomosho South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(654, 31, 'Ogo Oluwa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(655, 31, 'Olorunsogo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(656, 31, 'Oluyole', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(657, 31, 'Ona Ara', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(658, 31, 'Orelope', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(659, 31, 'Ori Ire', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(660, 31, 'Oyo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(661, 31, 'Oyo East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(662, 31, 'Saki East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(663, 31, 'Saki West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(664, 31, 'Surulere, Oyo State', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(665, 32, 'Bokkos', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(666, 32, 'Barkin Ladi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(667, 32, 'Bassa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(668, 32, 'Jos East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(669, 32, 'Jos North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(670, 32, 'Jos South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(671, 32, 'Kanam', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(672, 32, 'Kanke', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(673, 32, 'Langtang South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(674, 32, 'Langtang North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(675, 32, 'Mangu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(676, 32, 'Mikang', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(677, 32, 'Pankshin', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(678, 32, 'Qua\'an Pan', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(679, 32, 'Riyom', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(680, 32, 'Shendam', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(681, 32, 'Wase', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(682, 33, 'Abua/Odual', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(683, 33, 'Ahoada East', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(684, 33, 'Ahoada West', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(685, 33, 'Akuku-Toru', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(686, 33, 'Andoni', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(687, 33, 'Asari-Toru', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(688, 33, 'Bonny', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(689, 33, 'Degema', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(690, 33, 'Eleme', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(691, 33, 'Emuoha', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(692, 33, 'Etche', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(693, 33, 'Gokana', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(694, 33, 'Ikwerre', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(695, 33, 'Khana', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(696, 33, 'Obio/Akpor', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(697, 33, 'Ogba/Egbema/Ndoni', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(698, 33, 'Ogu/Bolo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(699, 33, 'Okrika', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(700, 33, 'Omuma', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(701, 33, 'Opobo/Nkoro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(702, 33, 'Oyigbo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(703, 33, 'Port Harcourt', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(704, 33, 'Tai', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(705, 34, 'Binji', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(706, 34, 'Bodinga', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(707, 34, 'Dange Shuni', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(708, 34, 'Gada', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(709, 34, 'Goronyo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(710, 34, 'Gudu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(711, 34, 'Gwadabawa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(712, 34, 'Illela', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(713, 34, 'Isa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(714, 34, 'Kebbe', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(715, 34, 'Kware', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(716, 34, 'Rabah', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(717, 34, 'Sabon Birni', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(718, 34, 'Shagari', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(719, 34, 'Silame', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(720, 34, 'Sokoto North', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(721, 34, 'Sokoto South', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(722, 34, 'Tambuwal', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(723, 34, 'Tangaza', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(724, 34, 'Tureta', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(725, 34, 'Wamako', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(726, 34, 'Wurno', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(727, 34, 'Yabo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(728, 35, 'Ardo Kola', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(729, 35, 'Bali', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(730, 35, 'Donga', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(731, 35, 'Gashaka', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(732, 35, 'Gassol', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(733, 35, 'Ibi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(734, 35, 'Jalingo', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(735, 35, 'Karim Lamido', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(736, 35, 'Kumi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(737, 35, 'Lau', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(738, 35, 'Sardauna', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(739, 35, 'Takum', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(740, 35, 'Ussa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(741, 35, 'Wukari', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(742, 35, 'Yorro', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(743, 35, 'Zing', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(744, 36, 'Bade', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(745, 36, 'Bursari', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(746, 36, 'Damaturu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(747, 36, 'Fika', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(748, 36, 'Fune', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(749, 36, 'Geidam', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(750, 36, 'Gujba', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(751, 36, 'Gulani', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(752, 36, 'Jakusko', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(753, 36, 'Karasuwa', '2023-09-07 16:30:25', '2023-09-07 16:30:25');
INSERT INTO `lgas` (`id`, `state_id`, `name`, `created_at`, `updated_at`) VALUES
(754, 36, 'Machina', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(755, 36, 'Nangere', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(756, 36, 'Nguru', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(757, 36, 'Potiskum', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(758, 36, 'Tarmuwa', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(759, 36, 'Yunusari', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(760, 36, 'Yusufari', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(761, 37, 'Anka', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(762, 37, 'Bakura', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(763, 37, 'Birnin Magaji/Kiyaw', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(764, 37, 'Bukkuyum', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(765, 37, 'Bungudu', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(766, 37, 'Gummi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(767, 37, 'Gusau', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(768, 37, 'Kaura Namoda', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(769, 37, 'Maradun', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(770, 37, 'Maru', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(771, 37, 'Shinkafi', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(772, 37, 'Talata Mafara', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(773, 37, 'Chafe', '2023-09-07 16:30:25', '2023-09-07 16:30:25'),
(774, 37, 'Zurmi', '2023-09-07 16:30:25', '2023-09-07 16:30:25');

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

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

CREATE TABLE `marks` (
  `id` int UNSIGNED NOT NULL,
  `student_id` int UNSIGNED NOT NULL,
  `subject_id` int UNSIGNED NOT NULL,
  `my_class_id` int UNSIGNED NOT NULL,
  `section_id` int UNSIGNED NOT NULL,
  `exam_id` int UNSIGNED NOT NULL,
  `t1` int DEFAULT NULL,
  `t2` int DEFAULT NULL,
  `t3` int DEFAULT NULL,
  `t4` int DEFAULT NULL,
  `tca` int DEFAULT NULL,
  `exm` int DEFAULT NULL,
  `tex1` int DEFAULT NULL,
  `tex2` int DEFAULT NULL,
  `tex3` int DEFAULT NULL,
  `sub_pos` tinyint DEFAULT NULL,
  `cum` int DEFAULT NULL,
  `cum_ave` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grade_id` int UNSIGNED DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `marks` (`id`, `student_id`, `subject_id`, `my_class_id`, `section_id`, `exam_id`, `t1`, `t2`, `t3`, `t4`, `tca`, `exm`, `tex1`, `tex2`, `tex3`, `sub_pos`, `cum`, `cum_ave`, `grade_id`, `year`, `created_at`, `updated_at`) VALUES
(1, 64, 24, 12, 15, 2, 18, 20, NULL, NULL, 38, 55, 93, NULL, NULL, 1, NULL, NULL, 1, '2023-2024', '2023-09-11 16:51:01', '2023-09-11 16:51:22'),
(2, 64, 26, 12, 15, 2, 19, 15, NULL, NULL, 34, 51, 85, NULL, NULL, 1, NULL, NULL, 1, '2023-2024', '2023-09-11 17:02:52', '2023-09-11 17:03:16'),
(3, 66, 26, 12, 15, 2, 15, 10, NULL, NULL, 25, 50, 75, NULL, NULL, 3, NULL, NULL, 1, '2023-2024', '2023-09-11 17:06:54', '2023-09-12 10:00:06'),
(4, 66, 24, 12, 15, 2, 11, 12, NULL, NULL, 23, 45, 68, NULL, NULL, 3, NULL, NULL, 2, '2023-2024', '2023-09-11 17:07:13', '2023-09-12 09:59:20'),
(5, 67, 24, 12, 15, 2, 14, 15, NULL, NULL, 29, 51, 80, NULL, NULL, 2, NULL, NULL, 1, '2023-2024', '2023-09-12 09:58:44', '2023-09-12 09:59:20'),
(6, 68, 24, 12, 15, 2, 10, 8, NULL, NULL, 18, 50, 68, NULL, NULL, 3, NULL, NULL, 2, '2023-2024', '2023-09-12 09:58:44', '2023-09-12 09:59:20'),
(7, 67, 26, 12, 15, 2, 10, 14, NULL, NULL, 24, 52, 76, NULL, NULL, 2, NULL, NULL, 1, '2023-2024', '2023-09-12 09:59:40', '2023-09-12 10:00:06'),
(8, 68, 26, 12, 15, 2, 12, 13, NULL, NULL, 25, 45, 70, NULL, NULL, 4, NULL, NULL, 1, '2023-2024', '2023-09-12 09:59:40', '2023-09-12 10:00:06');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2013_09_20_121733_create_blood_groups_table', 1),
(2, '2013_09_22_124750_create_states_table', 1),
(3, '2013_09_22_124806_create_lgas_table', 1),
(4, '2013_09_26_121148_create_nationalities_table', 1),
(5, '2014_10_12_000000_create_users_table', 1),
(6, '2014_10_12_100000_create_password_resets_table', 1),
(7, '2018_09_20_100249_create_user_types_table', 1),
(8, '2018_09_20_150906_create_class_types_table', 1),
(9, '2018_09_22_073005_create_my_classes_table', 1),
(10, '2018_09_22_073526_create_sections_table', 1),
(11, '2018_09_22_080555_create_settings_table', 1),
(12, '2018_09_22_081302_create_subjects_table', 1),
(13, '2018_09_22_151514_create_student_records_table', 1),
(14, '2018_09_26_124241_create_dorms_table', 1),
(15, '2018_10_04_224910_create_exams_table', 1),
(16, '2018_10_06_224846_create_marks_table', 1),
(17, '2018_10_06_224944_create_grades_table', 1),
(18, '2018_10_06_225007_create_pins_table', 1),
(19, '2018_10_18_205550_create_skills_table', 1),
(20, '2018_10_18_205842_create_exam_records_table', 1),
(21, '2018_10_31_191358_create_books_table', 1),
(22, '2018_10_31_192540_create_book_requests_table', 1),
(23, '2018_11_01_132115_create_staff_records_table', 1),
(24, '2018_11_03_210758_create_payments_table', 1),
(25, '2018_11_03_210817_create_payment_records_table', 1),
(26, '2018_11_06_083707_create_receipts_table', 1),
(27, '2018_11_27_180401_create_time_tables_table', 1),
(28, '2019_09_22_142514_create_fks', 1),
(29, '2019_09_26_132227_create_promotions_table', 1);

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

--
-- Table structure for table `my_classes`
--

CREATE TABLE `my_classes` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_type_id` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `my_classes`
--

INSERT INTO `my_classes` (`id`, `name`, `class_type_id`, `created_at`, `updated_at`) VALUES
(1, 'Nursery 1', 3, NULL, NULL),
(2, 'Nursery 2', 3, NULL, NULL),
(3, 'Nursery 3', 3, NULL, NULL),
(4, 'Primary 1', 4, NULL, NULL),
(5, 'Primary 2', 4, NULL, NULL),
(6, 'JSS 2', 5, NULL, NULL),
(7, 'JSS 3', 5, NULL, NULL),
(8, 'SSS 1', 6, NULL, NULL),
(9, 'SSS 2', 6, NULL, NULL),
(10, 'SSS 3', 6, NULL, NULL),
(11, 'ruby', 3, '2023-09-08 14:02:08', '2023-09-08 14:02:08'),
(12, 'Secondary school', 6, '2023-09-08 14:49:20', '2023-09-08 14:49:20');

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

--
-- Table structure for table `nationalities`
--

CREATE TABLE `nationalities` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `nationalities`
--

INSERT INTO `nationalities` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Afghan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(2, 'Albanian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(3, 'Algerian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(4, 'American', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(5, 'Andorran', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(6, 'Angolan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(7, 'Antiguans', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(8, 'Argentinean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(9, 'Armenian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(10, 'Australian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(11, 'Austrian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(12, 'Azerbaijani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(13, 'Bahamian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(14, 'Bahraini', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(15, 'Bangladeshi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(16, 'Barbadian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(17, 'Barbudans', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(18, 'Batswana', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(19, 'Belarusian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(20, 'Belgian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(21, 'Belizean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(22, 'Beninese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(23, 'Bhutanese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(24, 'Bolivian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(25, 'Bosnian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(26, 'Brazilian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(27, 'British', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(28, 'Bruneian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(29, 'Bulgarian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(30, 'Burkinabe', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(31, 'Burmese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(32, 'Burundian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(33, 'Cambodian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(34, 'Cameroonian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(35, 'Canadian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(36, 'Cape Verdean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(37, 'Central African', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(38, 'Chadian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(39, 'Chilean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(40, 'Chinese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(41, 'Colombian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(42, 'Comoran', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(43, 'Congolese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(44, 'Costa Rican', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(45, 'Croatian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(46, 'Cuban', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(47, 'Cypriot', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(48, 'Czech', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(49, 'Danish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(50, 'Djibouti', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(51, 'Dominican', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(52, 'Dutch', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(53, 'East Timorese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(54, 'Ecuadorean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(55, 'Egyptian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(56, 'Emirian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(57, 'Equatorial Guinean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(58, 'Eritrean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(59, 'Estonian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(60, 'Ethiopian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(61, 'Fijian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(62, 'Filipino', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(63, 'Finnish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(64, 'French', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(65, 'Gabonese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(66, 'Gambian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(67, 'Georgian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(68, 'German', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(69, 'Ghanaian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(70, 'Greek', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(71, 'Grenadian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(72, 'Guatemalan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(73, 'Guinea-Bissauan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(74, 'Guinean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(75, 'Guyanese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(76, 'Haitian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(77, 'Herzegovinian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(78, 'Honduran', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(79, 'Hungarian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(80, 'I-Kiribati', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(81, 'Icelander', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(82, 'Indian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(83, 'Indonesian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(84, 'Iranian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(85, 'Iraqi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(86, 'Irish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(87, 'Israeli', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(88, 'Italian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(89, 'Ivorian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(90, 'Jamaican', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(91, 'Japanese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(92, 'Jordanian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(93, 'Kazakhstani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(94, 'Kenyan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(95, 'Kittian and Nevisian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(96, 'Kuwaiti', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(97, 'Kyrgyz', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(98, 'Laotian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(99, 'Latvian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(100, 'Lebanese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(101, 'Liberian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(102, 'Libyan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(103, 'Liechtensteiner', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(104, 'Lithuanian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(105, 'Luxembourger', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(106, 'Macedonian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(107, 'Malagasy', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(108, 'Malawian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(109, 'Malaysian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(110, 'Maldivan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(111, 'Malian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(112, 'Maltese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(113, 'Marshallese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(114, 'Mauritanian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(115, 'Mauritian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(116, 'Mexican', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(117, 'Micronesian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(118, 'Moldovan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(119, 'Monacan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(120, 'Mongolian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(121, 'Moroccan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(122, 'Mosotho', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(123, 'Motswana', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(124, 'Mozambican', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(125, 'Namibian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(126, 'Nauruan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(127, 'Nepalese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(128, 'New Zealander', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(129, 'Nicaraguan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(130, 'Nigerian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(131, 'Nigerien', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(132, 'North Korean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(133, 'Northern Irish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(134, 'Norwegian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(135, 'Omani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(136, 'Pakistani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(137, 'Palauan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(138, 'Panamanian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(139, 'Papua New Guinean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(140, 'Paraguayan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(141, 'Peruvian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(142, 'Polish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(143, 'Portuguese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(144, 'Qatari', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(145, 'Romanian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(146, 'Russian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(147, 'Rwandan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(148, 'Saint Lucian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(149, 'Salvadoran', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(150, 'Samoan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(151, 'San Marinese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(152, 'Sao Tomean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(153, 'Saudi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(154, 'Scottish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(155, 'Senegalese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(156, 'Serbian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(157, 'Seychellois', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(158, 'Sierra Leonean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(159, 'Singaporean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(160, 'Slovakian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(161, 'Slovenian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(162, 'Solomon Islander', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(163, 'Somali', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(164, 'South African', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(165, 'South Korean', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(166, 'Spanish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(167, 'Sri Lankan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(168, 'Sudanese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(169, 'Surinamer', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(170, 'Swazi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(171, 'Swedish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(172, 'Swiss', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(173, 'Syrian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(174, 'Taiwanese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(175, 'Tajik', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(176, 'Tanzanian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(177, 'Thai', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(178, 'Togolese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(179, 'Tongan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(180, 'Trinidadian/Tobagonian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(181, 'Tunisian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(182, 'Turkish', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(183, 'Tuvaluan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(184, 'Ugandan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(185, 'Ukrainian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(186, 'Uruguayan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(187, 'Uzbekistani', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(188, 'Venezuelan', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(189, 'Vietnamese', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(190, 'Welsh', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(191, 'Yemenite', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(192, 'Zambian', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(193, 'Zimbabwean', '2023-09-07 16:30:24', '2023-09-07 16:30:24');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` int NOT NULL,
  `ref_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cash',
  `my_class_id` int UNSIGNED DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `title`, `amount`, `ref_no`, `method`, `my_class_id`, `description`, `year`, `created_at`, `updated_at`) VALUES
(1, 'acedemic fee', 4500, '2023/823870', 'cash', NULL, 'academic fee', '2023-2024', '2023-09-08 13:10:42', '2023-09-08 13:10:42'),
(2, 'fee', 234567, '2023/441774', 'cash', NULL, NULL, '2023-2024', '2023-09-08 13:11:39', '2023-09-12 07:46:59'),
(3, 'acadmic fee', 34567, '2023/798767', 'cash', NULL, NULL, '2023-2024', '2023-09-08 13:12:32', '2023-09-08 13:12:32'),
(4, 'School fee', 15000, '2023/113159', 'cash', 1, NULL, '2023-2024', '2023-09-11 09:56:03', '2023-09-11 09:56:03'),
(5, 'Test', 234, '2023/113815', 'cash', 1, NULL, '2023-2024', '2023-09-11 10:23:34', '2023-09-11 10:23:34'),
(6, 'school fee', 12000, '2023/284320', 'cash', 7, 'academic fee', '2023-2024', '2023-09-11 12:59:35', '2023-09-11 12:59:35'),
(7, 'fee', 12000, '2023/717568', 'cash', NULL, 'academic fee', '2023-2024', '2023-09-11 13:14:34', '2023-09-11 13:14:34'),
(8, 'fee', 8000, '2023/532086', 'cash', NULL, NULL, '2023-2024', '2023-09-11 13:16:32', '2023-09-11 13:16:32'),
(9, 'Acedmic fee', 12000, '2023/700214', 'cash', NULL, 'academic fee', '2023-2024', '2023-09-12 07:41:03', '2023-09-12 07:41:03');

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

--
-- Table structure for table `payment_records`
--

CREATE TABLE `payment_records` (
  `id` int UNSIGNED NOT NULL,
  `payment_id` int UNSIGNED NOT NULL,
  `student_id` int UNSIGNED NOT NULL,
  `ref_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amt_paid` int DEFAULT NULL,
  `balance` int DEFAULT NULL,
  `paid` tinyint NOT NULL DEFAULT '0',
  `year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_records`
--

INSERT INTO `payment_records` (`id`, `payment_id`, `student_id`, `ref_no`, `amt_paid`, `balance`, `paid`, `year`, `created_at`, `updated_at`) VALUES
(1, 1, 40, '63388314', NULL, NULL, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:17'),
(2, 1, 41, '94590681', NULL, NULL, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:17'),
(3, 1, 42, '90058254', NULL, NULL, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:17'),
(4, 2, 40, '92855426', NULL, NULL, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:17'),
(5, 2, 41, '14020396', 34556, 200011, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:35'),
(6, 2, 42, '89219997', NULL, NULL, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:17'),
(7, 3, 40, '37000884', NULL, NULL, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:17'),
(8, 3, 41, '79094536', NULL, NULL, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:17'),
(9, 3, 42, '60478607', NULL, NULL, 0, '2023-2024', '2023-09-08 13:17:17', '2023-09-08 13:17:17'),
(10, 1, 18, '36534081', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(11, 1, 19, '26184313', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(12, 1, 20, '19187359', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(13, 1, 21, '68249468', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(14, 1, 22, '78321491', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(15, 1, 23, '65507351', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(16, 1, 24, '84658703', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(17, 2, 18, '42217364', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(18, 2, 19, '2462614', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(19, 2, 20, '21648594', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(20, 2, 21, '5757858', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(21, 2, 22, '50363368', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(22, 2, 23, '93609724', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(23, 2, 24, '43455013', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(24, 3, 18, '45435263', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(25, 3, 19, '12446320', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(26, 3, 20, '93549242', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(27, 3, 21, '45434789', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(28, 3, 22, '81784751', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(29, 3, 23, '69965833', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(30, 3, 24, '504342', NULL, NULL, 0, '2023-2024', '2023-09-08 16:01:17', '2023-09-08 16:01:17'),
(31, 4, 18, '9274832', NULL, NULL, 0, '2023-2024', '2023-09-11 10:09:24', '2023-09-11 10:09:24'),
(32, 4, 19, '45546849', NULL, NULL, 0, '2023-2024', '2023-09-11 10:09:24', '2023-09-11 10:09:24'),
(33, 4, 20, '11577224', NULL, NULL, 0, '2023-2024', '2023-09-11 10:09:24', '2023-09-11 10:09:24'),
(34, 4, 21, '5635383', NULL, NULL, 0, '2023-2024', '2023-09-11 10:09:24', '2023-09-11 10:09:24'),
(35, 4, 22, '48278483', NULL, NULL, 0, '2023-2024', '2023-09-11 10:09:24', '2023-09-11 10:09:24'),
(36, 4, 23, '29557392', NULL, NULL, 0, '2023-2024', '2023-09-11 10:09:24', '2023-09-11 10:09:24'),
(37, 4, 24, '33136554', NULL, NULL, 0, '2023-2024', '2023-09-11 10:09:24', '2023-09-11 10:09:24'),
(38, 1, 55, '58619909', 4000, 500, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 14:08:08'),
(39, 2, 55, '10710141', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(40, 3, 55, '70018392', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(41, 7, 40, '42804586', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(42, 7, 41, '3355885', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(43, 7, 42, '63660507', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(44, 7, 55, '84003318', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(45, 8, 40, '66489011', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(46, 8, 41, '76482716', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(47, 8, 42, '94467993', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(48, 8, 55, '23958161', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:09', '2023-09-11 13:27:09'),
(49, 1, 34, '91807122', 4380, 120, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:29:06'),
(50, 1, 35, '11095086', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(51, 1, 36, '28086869', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(52, 2, 34, '43933997', 36800, 197767, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:29:34'),
(53, 2, 35, '83440079', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(54, 2, 36, '13063158', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(55, 3, 34, '40646953', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(56, 3, 35, '97748776', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(57, 3, 36, '81386970', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(58, 7, 34, '23027392', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(59, 7, 35, '56595553', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(60, 7, 36, '22742008', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(61, 8, 34, '49685178', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(62, 8, 35, '22450723', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(63, 8, 36, '47916481', NULL, NULL, 0, '2023-2024', '2023-09-11 13:27:54', '2023-09-11 13:27:54'),
(64, 6, 43, '97544421', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(65, 6, 44, '92168565', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(66, 6, 45, '72427402', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(67, 6, 59, '51459734', 12000, 0, 1, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:55:21'),
(68, 1, 43, '49432562', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(69, 1, 44, '93049570', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(70, 1, 45, '93921598', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(71, 1, 59, '53850333', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(72, 2, 43, '17685616', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(73, 2, 44, '60408277', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(74, 2, 45, '53948493', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(75, 2, 59, '75558704', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(76, 3, 43, '56225104', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(77, 3, 44, '70772417', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(78, 3, 45, '44505702', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(79, 3, 59, '57453983', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(80, 7, 43, '94024167', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(81, 7, 44, '34950564', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(82, 7, 45, '31097631', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(83, 7, 59, '20922029', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(84, 8, 43, '37777054', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(85, 8, 44, '52209405', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(86, 8, 45, '71763686', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(87, 8, 59, '99785387', NULL, NULL, 0, '2023-2024', '2023-09-11 13:44:16', '2023-09-11 13:44:16'),
(88, 1, 64, '88657211', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(89, 1, 66, '37280045', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(90, 2, 64, '33727089', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(91, 2, 66, '34425582', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(92, 3, 64, '12698843', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(93, 3, 66, '20231707', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(94, 7, 64, '50022805', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(95, 7, 66, '19616859', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(96, 8, 64, '3342007', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(97, 8, 66, '61111841', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(98, 9, 64, '58216829', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(99, 9, 66, '38776387', NULL, NULL, 0, '2023-2024', '2023-09-12 07:47:52', '2023-09-12 07:47:52'),
(100, 9, 40, '14524501', NULL, NULL, 0, '2023-2024', '2023-09-12 10:15:06', '2023-09-12 10:15:06'),
(101, 9, 41, '74372720', NULL, NULL, 0, '2023-2024', '2023-09-12 10:15:06', '2023-09-12 10:15:06'),
(102, 9, 42, '95606477', NULL, NULL, 0, '2023-2024', '2023-09-12 10:15:06', '2023-09-12 10:15:06'),
(103, 9, 55, '58431024', NULL, NULL, 0, '2023-2024', '2023-09-12 10:15:06', '2023-09-12 10:15:06'),
(104, 4, 63, '76925284', 15000, 0, 1, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:27:02'),
(105, 5, 18, '84597347', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(106, 5, 19, '2425002', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(107, 5, 20, '64441664', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(108, 5, 21, '22370055', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(109, 5, 22, '74814098', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(110, 5, 23, '29979543', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(111, 5, 24, '52886748', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(112, 5, 63, '321008', 234, 0, 1, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:27:06'),
(113, 1, 63, '97663143', 4500, 0, 1, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:27:13'),
(114, 2, 63, '13668157', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(115, 3, 63, '68959715', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(116, 7, 18, '81016742', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(117, 7, 19, '54496980', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(118, 7, 20, '49415079', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(119, 7, 21, '21362117', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(120, 7, 22, '72873250', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(121, 7, 23, '4906695', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(122, 7, 24, '26106760', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(123, 7, 63, '84102233', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(124, 8, 18, '45923725', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(125, 8, 19, '7414764', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(126, 8, 20, '33867407', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(127, 8, 21, '44694129', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(128, 8, 22, '22216701', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(129, 8, 23, '51961006', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(130, 8, 24, '33344843', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(131, 8, 63, '27162916', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(132, 9, 18, '26566815', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(133, 9, 19, '43682136', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(134, 9, 20, '19100743', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(135, 9, 21, '70371623', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(136, 9, 22, '87039153', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(137, 9, 23, '55390234', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(138, 9, 24, '76750801', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(139, 9, 63, '56892195', NULL, NULL, 0, '2023-2024', '2023-09-12 10:24:31', '2023-09-12 10:24:31'),
(140, 1, 67, '10368699', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(141, 1, 68, '35046793', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(142, 2, 67, '87702206', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(143, 2, 68, '52787674', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(144, 3, 67, '7876438', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(145, 3, 68, '62346392', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(146, 7, 67, '95222554', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(147, 7, 68, '71071943', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(148, 8, 67, '33151404', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(149, 8, 68, '63922341', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(150, 9, 67, '34803327', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55'),
(151, 9, 68, '2907389', NULL, NULL, 0, '2023-2024', '2023-09-12 13:26:55', '2023-09-12 13:26:55');

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

--
-- Table structure for table `pins`
--

CREATE TABLE `pins` (
  `id` int UNSIGNED NOT NULL,
  `code` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `used` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `times_used` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `user_id` int UNSIGNED DEFAULT NULL,
  `student_id` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `promotions`
--

CREATE TABLE `promotions` (
  `id` int UNSIGNED NOT NULL,
  `student_id` int UNSIGNED NOT NULL,
  `from_class` int UNSIGNED NOT NULL,
  `from_section` int UNSIGNED NOT NULL,
  `to_class` int UNSIGNED NOT NULL,
  `to_section` int UNSIGNED NOT NULL,
  `grad` tinyint NOT NULL,
  `from_session` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `to_session` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotions`
--

INSERT INTO `promotions` (`id`, `student_id`, `from_class`, `from_section`, `to_class`, `to_section`, `grad`, `from_session`, `to_session`, `status`, `created_at`, `updated_at`) VALUES
(1, 55, 6, 8, 6, 8, 0, '2023-2024', '2024-2025', 'P', '2023-09-08 13:42:33', '2023-09-08 13:42:33'),
(2, 63, 6, 18, 1, 2, 0, '2023-2024', '2024-2025', 'P', '2023-09-11 15:54:38', '2023-09-11 15:54:38'),
(3, 66, 12, 15, 12, 15, 1, '2023-2024', '2024-2025', 'G', '2023-09-12 07:49:35', '2023-09-12 07:49:35'),
(4, 64, 12, 15, 12, 15, 0, '2023-2024', '2024-2025', 'P', '2023-09-12 07:49:35', '2023-09-12 07:49:35');

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

--
-- Table structure for table `receipts`
--

CREATE TABLE `receipts` (
  `id` int UNSIGNED NOT NULL,
  `pr_id` int UNSIGNED NOT NULL,
  `amt_paid` int NOT NULL,
  `balance` int NOT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `receipts`
--

INSERT INTO `receipts` (`id`, `pr_id`, `amt_paid`, `balance`, `year`, `created_at`, `updated_at`) VALUES
(1, 5, 34556, 200011, '2023-2024', '2023-09-08 13:17:35', '2023-09-08 13:17:35'),
(2, 49, 4380, 120, '2023-2024', '2023-09-11 13:29:06', '2023-09-11 13:29:06'),
(3, 52, 33000, 201567, '2023-2024', '2023-09-11 13:29:25', '2023-09-11 13:29:25'),
(4, 52, 3800, 197767, '2023-2024', '2023-09-11 13:29:34', '2023-09-11 13:29:34'),
(5, 67, 12000, 0, '2023-2024', '2023-09-11 13:55:21', '2023-09-11 13:55:21'),
(6, 38, 4000, 500, '2023-2024', '2023-09-11 14:08:08', '2023-09-11 14:08:08'),
(7, 104, 15000, 0, '2023-2024', '2023-09-12 10:27:02', '2023-09-12 10:27:02'),
(8, 112, 234, 0, '2023-2024', '2023-09-12 10:27:06', '2023-09-12 10:27:06'),
(9, 113, 4500, 0, '2023-2024', '2023-09-12 10:27:13', '2023-09-12 10:27:13');

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

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

CREATE TABLE `sections` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `my_class_id` int UNSIGNED NOT NULL,
  `teacher_id` int UNSIGNED DEFAULT NULL,
  `active` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sections` (`id`, `name`, `my_class_id`, `teacher_id`, `active`, `created_at`, `updated_at`) VALUES
(1, 'Gold', 1, NULL, 1, NULL, NULL),
(2, 'Diamond', 1, NULL, 0, NULL, NULL),
(3, 'Silver', 2, NULL, 1, NULL, NULL),
(4, 'Lemon', 2, NULL, 0, NULL, NULL),
(5, 'Bronze', 3, NULL, 1, NULL, NULL),
(6, 'Silver', 4, NULL, 1, NULL, NULL),
(7, 'Diamond', 5, NULL, 1, NULL, NULL),
(8, 'Blue', 6, NULL, 1, NULL, NULL),
(9, 'A', 7, 11, 1, NULL, '2023-09-11 14:59:07'),
(10, 'A', 8, NULL, 1, NULL, NULL),
(11, 'A', 9, NULL, 1, NULL, NULL),
(12, 'A', 10, NULL, 1, NULL, NULL),
(13, 'A', 11, NULL, 1, '2023-09-08 14:02:08', '2023-09-08 14:02:08'),
(14, 'Ruby', 6, NULL, 0, '2023-09-08 14:02:58', '2023-09-08 14:02:58'),
(15, 'Physics', 12, NULL, 1, '2023-09-08 14:49:20', '2023-09-12 07:51:40'),
(16, 'Ruby', 1, 3, 0, '2023-09-08 14:50:32', '2023-09-08 14:50:32'),
(17, 'A', 6, 3, 0, '2023-09-08 14:50:55', '2023-09-08 14:50:55'),
(18, 'B', 6, 7, 0, '2023-09-11 14:58:47', '2023-09-11 14:58:47'),
(19, 'Hindi', 1, 65, 0, '2023-09-11 16:55:39', '2023-09-11 16:55:39'),
(20, 'Biology', 12, 3, 0, '2023-09-11 17:00:07', '2023-09-11 17:00:07'),
(21, 'chemistry', 12, 65, 0, '2023-09-11 17:00:23', '2023-09-11 17:00:23');

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

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

CREATE TABLE `settings` (
  `id` int UNSIGNED NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `type`, `description`, `created_at`, `updated_at`) VALUES
(1, 'current_session', '2023-2024', NULL, '2023-09-08 16:35:45'),
(2, 'system_title', 'SIS', NULL, '2023-09-08 16:35:45'),
(3, 'system_name', 'SIS Academy', NULL, '2023-09-08 16:35:45'),
(4, 'term_ends', '03/01/2024', NULL, '2023-09-08 16:35:45'),
(5, 'term_begins', '04/01/2023', NULL, '2023-09-08 16:35:45'),
(6, 'phone', '9988558855', NULL, '2023-09-08 16:35:45'),
(7, 'address', 'Behind Central Triangle Tourist Center', NULL, '2023-09-08 16:35:45'),
(8, 'system_email', 'abhishar@yopmail.com', NULL, '2023-09-08 16:35:45'),
(9, 'alt_email', '', NULL, NULL),
(10, 'email_host', '', NULL, NULL),
(11, 'email_pass', '', NULL, NULL),
(12, 'lock_exam', '0', NULL, '2023-09-08 16:35:45'),
(13, 'logo', 'https://sis.getanapp.co.in/storage/uploads//logo.jpg', NULL, '2023-09-08 15:52:36'),
(14, 'next_term_fees_j', '20000', NULL, '2023-09-08 16:35:45'),
(15, 'next_term_fees_pn', '25000', NULL, '2023-09-08 16:35:45'),
(16, 'next_term_fees_p', '25000', NULL, '2023-09-08 16:35:45'),
(17, 'next_term_fees_n', '25600', NULL, '2023-09-08 16:35:45'),
(18, 'next_term_fees_s', '15600', NULL, '2023-09-08 16:35:45'),
(19, 'next_term_fees_c', '1600', NULL, '2023-09-08 16:35:45');

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

--
-- Table structure for table `skills`
--

CREATE TABLE `skills` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `skill_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `skills`
--

INSERT INTO `skills` (`id`, `name`, `skill_type`, `class_type`, `created_at`, `updated_at`) VALUES
(1, 'PUNCTUALITY', 'AF', NULL, NULL, NULL),
(2, 'NEATNESS', 'AF', NULL, NULL, NULL),
(3, 'HONESTY', 'AF', NULL, NULL, NULL),
(4, 'RELIABILITY', 'AF', NULL, NULL, NULL),
(5, 'RELATIONSHIP WITH OTHERS', 'AF', NULL, NULL, NULL),
(6, 'POLITENESS', 'AF', NULL, NULL, NULL),
(7, 'ALERTNESS', 'AF', NULL, NULL, NULL),
(8, 'HANDWRITING', 'PS', NULL, NULL, NULL),
(9, 'GAMES & SPORTS', 'PS', NULL, NULL, NULL),
(10, 'DRAWING & ARTS', 'PS', NULL, NULL, NULL),
(11, 'PAINTING', 'PS', NULL, NULL, NULL),
(12, 'CONSTRUCTION', 'PS', NULL, NULL, NULL),
(13, 'MUSICAL SKILLS', 'PS', NULL, NULL, NULL),
(14, 'FLEXIBILITY', 'PS', NULL, NULL, NULL);

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

--
-- Table structure for table `staff_records`
--

CREATE TABLE `staff_records` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `emp_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `staff_records`
--

INSERT INTO `staff_records` (`id`, `user_id`, `code`, `emp_date`, `created_at`, `updated_at`) VALUES
(1, 56, 'SIS/STAFF/1970/01/2682', NULL, '2023-09-08 16:11:01', '2023-09-08 16:11:01'),
(3, 58, 'SIS/STAFF/2023/09/1811', '09/01/2023', '2023-09-11 10:35:43', '2023-09-11 10:35:43'),
(4, 60, 'SIS/STAFF/1970/01/2765', NULL, '2023-09-11 11:07:18', '2023-09-11 12:27:15'),
(5, 61, 'SIS/STAFF/2023/09/5056', '09/01/2023', '2023-09-11 12:45:15', '2023-09-11 12:45:15'),
(6, 65, 'SIS/STAFF/2023/09/9685', '09/02/2023', '2023-09-11 16:24:05', '2023-09-11 16:24:05');

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Abia', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(2, 'Adamawa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(3, 'Akwa Ibom', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(4, 'Anambra', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(5, 'Bauchi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(6, 'Bayelsa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(7, 'Benue', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(8, 'Borno', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(9, 'Cross River', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(10, 'Delta', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(11, 'Ebonyi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(12, 'Edo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(13, 'Ekiti', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(14, 'Enugu', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(15, 'FCT', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(16, 'Gombe', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(17, 'Imo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(18, 'Jigawa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(19, 'Kaduna', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(20, 'Kano', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(21, 'Katsina', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(22, 'Kebbi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(23, 'Kogi', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(24, 'Kwara', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(25, 'Lagos', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(26, 'Nasarawa', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(27, 'Niger', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(28, 'Ogun', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(29, 'Ondo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(30, 'Osun', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(31, 'Oyo', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(32, 'Plateau', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(33, 'Rivers', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(34, 'Sokoto', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(35, 'Taraba', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(36, 'Yobe', '2023-09-07 16:30:24', '2023-09-07 16:30:24'),
(37, 'Zamfara', '2023-09-07 16:30:24', '2023-09-07 16:30:24');

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

--
-- Table structure for table `student_records`
--

CREATE TABLE `student_records` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `my_class_id` int UNSIGNED NOT NULL,
  `section_id` int UNSIGNED NOT NULL,
  `adm_no` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `my_parent_id` int UNSIGNED DEFAULT NULL,
  `dorm_id` int UNSIGNED DEFAULT NULL,
  `dorm_room_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `session` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `house` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` tinyint DEFAULT NULL,
  `year_admitted` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grad` tinyint NOT NULL DEFAULT '0',
  `grad_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `student_records`
--

INSERT INTO `student_records` (`id`, `user_id`, `my_class_id`, `section_id`, `adm_no`, `my_parent_id`, `dorm_id`, `dorm_room_no`, `session`, `house`, `age`, `year_admitted`, `grad`, `grad_date`, `created_at`, `updated_at`) VALUES
(1, 18, 1, 1, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(2, 19, 1, 1, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(3, 20, 1, 1, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(4, 21, 1, 1, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(5, 22, 1, 2, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(6, 23, 1, 2, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(7, 24, 1, 2, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(8, 25, 2, 3, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(9, 26, 2, 3, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(10, 27, 2, 3, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:26', '2023-09-07 16:30:26'),
(11, 28, 2, 4, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(12, 29, 2, 4, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(13, 30, 2, 4, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(14, 31, 3, 5, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(15, 32, 3, 5, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(16, 33, 3, 5, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(17, 34, 4, 6, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(18, 35, 4, 6, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(19, 36, 4, 6, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(20, 37, 5, 7, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(21, 38, 5, 7, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(22, 39, 5, 7, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:27', '2023-09-07 16:30:27'),
(23, 40, 6, 8, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(24, 41, 6, 8, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(25, 42, 6, 8, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(26, 43, 7, 9, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(27, 44, 7, 9, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(28, 45, 7, 9, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(29, 46, 8, 10, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(30, 47, 8, 10, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(31, 48, 8, 10, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(32, 49, 9, 11, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(33, 50, 9, 11, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(34, 51, 9, 11, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:28', '2023-09-07 16:30:28'),
(35, 52, 10, 12, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:29', '2023-09-07 16:30:29'),
(36, 53, 10, 12, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:29', '2023-09-07 16:30:29'),
(37, 54, 10, 12, NULL, NULL, NULL, NULL, '2018-2019', NULL, NULL, NULL, 0, NULL, '2023-09-07 16:30:29', '2023-09-07 16:30:29'),
(38, 55, 6, 8, 'SIS/J/2023/93002', 9, 2, '21', '2024-2025', NULL, NULL, '2023', 0, NULL, '2023-09-08 13:28:18', '2023-09-08 13:42:33'),
(39, 59, 7, 9, 'SIS/J/2022/1234', NULL, 3, '12', '2023-2024', 'yellow', NULL, '2022', 0, NULL, '2023-09-11 10:52:26', '2023-09-11 11:03:43'),
(40, 63, 1, 2, 'SIS/J/2023/101', 62, 7, '12', '2024-2025', 'red', NULL, '2023', 0, NULL, '2023-09-11 15:52:52', '2023-09-11 15:54:38'),
(41, 64, 12, 15, 'SIS/S/2022/001', 62, 4, '01', '2024-2025', 'green', NULL, '2022', 1, '2023-2024', '2023-09-11 15:58:02', '2023-09-12 07:49:35'),
(42, 66, 12, 15, 'SIS/S/2022/002', 62, 7, '12', '2023-2024', 'red', NULL, '2022', 1, '2023-2024', '2023-09-11 17:06:05', '2023-09-12 07:49:35'),
(43, 67, 12, 15, 'SIS/S/2022/003', NULL, 1, '23', '2023-2024', 'red', NULL, '2022', 0, NULL, '2023-09-12 09:16:08', '2023-09-12 10:05:07'),
(44, 68, 12, 15, 'SIS/S/2022/004', 62, 3, '23', '2023-2024', 'red', NULL, '2022', 0, NULL, '2023-09-12 09:41:54', '2023-09-12 09:41:54'),
(45, 69, 5, 7, 'SIS/P/2023/53494', NULL, NULL, NULL, '2023-2024', NULL, NULL, '2023', 0, NULL, '2023-09-12 09:56:07', '2023-09-12 09:56:07');

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

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

CREATE TABLE `subjects` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `my_class_id` int UNSIGNED NOT NULL,
  `teacher_id` int UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `subjects` (`id`, `name`, `slug`, `my_class_id`, `teacher_id`, `created_at`, `updated_at`) VALUES
(1, 'English Language', 'Eng', 1, 3, NULL, NULL),
(2, 'Mathematics', 'Math', 1, 3, NULL, NULL),
(3, 'English Language', 'Eng', 2, 3, NULL, NULL),
(4, 'Mathematics', 'Math', 2, 3, NULL, NULL),
(5, 'English Language', 'Eng', 3, 3, NULL, NULL),
(6, 'Mathematics', 'Math', 3, 3, NULL, NULL),
(7, 'English Language', 'Eng', 4, 3, NULL, NULL),
(8, 'Mathematics', 'Math', 4, 3, NULL, NULL),
(9, 'English Language', 'Eng', 5, 3, NULL, NULL),
(10, 'Mathematics', 'Math', 5, 3, NULL, NULL),
(11, 'English Language', 'Eng', 6, 3, NULL, NULL),
(12, 'Mathematics', 'Math', 6, 3, NULL, NULL),
(13, 'English Language', 'Eng', 7, 3, NULL, NULL),
(14, 'Mathematics', 'Math', 7, 3, NULL, NULL),
(15, 'English Language', 'Eng', 8, 3, NULL, NULL),
(16, 'Mathematics', 'Math', 8, 3, NULL, NULL),
(17, 'English Language', 'Eng', 9, 3, NULL, NULL),
(18, 'Mathematics', 'Math', 9, 3, NULL, NULL),
(19, 'English Language', 'Eng', 10, 3, NULL, NULL),
(20, 'Mathematics', 'Math', 10, 3, NULL, NULL),
(21, 'Ruby', 'ruby', 7, 7, '2023-09-08 14:03:32', '2023-09-08 14:03:32'),
(22, 'English', 'eng', 1, 3, '2023-09-08 14:51:15', '2023-09-08 14:51:15'),
(23, 'hindi', 'hin', 1, 56, '2023-09-08 16:32:33', '2023-09-08 16:32:33'),
(24, 'Physics', 'phy', 12, 65, '2023-09-11 16:27:52', '2023-09-11 16:27:52'),
(25, 'hindi', 'hin', 7, 56, '2023-09-11 16:55:54', '2023-09-11 16:55:54'),
(26, 'biology', 'bio', 12, 65, '2023-09-11 17:01:51', '2023-09-11 17:01:51');

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

--
-- Table structure for table `time_slots`
--

CREATE TABLE `time_slots` (
  `id` int UNSIGNED NOT NULL,
  `ttr_id` int UNSIGNED NOT NULL,
  `hour_from` tinyint NOT NULL,
  `min_from` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meridian_from` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hour_to` tinyint NOT NULL,
  `min_to` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meridian_to` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `time_from` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `time_to` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp_from` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp_to` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `full` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `time_tables`
--

CREATE TABLE `time_tables` (
  `id` int UNSIGNED NOT NULL,
  `ttr_id` int UNSIGNED NOT NULL,
  `ts_id` int UNSIGNED NOT NULL,
  `subject_id` int UNSIGNED DEFAULT NULL,
  `exam_date` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp_from` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp_to` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `day` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `day_num` tinyint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `time_table_records`
--

CREATE TABLE `time_table_records` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `my_class_id` int UNSIGNED NOT NULL,
  `exam_id` int UNSIGNED DEFAULT NULL,
  `year` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `time_table_records`
--

INSERT INTO `time_table_records` (`id`, `name`, `my_class_id`, `exam_id`, `year`, `created_at`, `updated_at`) VALUES
(1, 'Ruby', 1, NULL, '2023-2024', '2023-09-08 12:56:43', '2023-09-08 12:56:43'),
(2, 'Physics', 6, NULL, '2023-2024', '2023-09-12 13:14:36', '2023-09-12 13:14:36');

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

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` (`id`, `title`, `name`, `level`, `created_at`, `updated_at`) VALUES
(1, 'accountant', 'Accountant', '5', NULL, NULL),
(2, 'parent', 'Parent', '4', NULL, NULL),
(3, 'teacher', 'Teacher', '3', NULL, NULL),
(4, 'admin', 'Admin', '2', NULL, NULL),
(5, 'super_admin', 'Super Admin', '1', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `book_requests`
--
ALTER TABLE `book_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `book_requests_book_id_foreign` (`book_id`),
  ADD KEY `book_requests_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `dorms`
--
ALTER TABLE `dorms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `dorms_name_unique` (`name`);

--
-- Indexes for table `exams`
--
ALTER TABLE `exams`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `exams_term_year_unique` (`term`,`year`);

--
-- Indexes for table `exam_records`
--
ALTER TABLE `exam_records`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_records_exam_id_foreign` (`exam_id`),
  ADD KEY `exam_records_my_class_id_foreign` (`my_class_id`),
  ADD KEY `exam_records_student_id_foreign` (`student_id`),
  ADD KEY `exam_records_section_id_foreign` (`section_id`);

--
-- Indexes for table `grades`
--
ALTER TABLE `grades`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `grades_name_class_type_id_remark_unique` (`name`,`class_type_id`,`remark`),
  ADD KEY `grades_class_type_id_foreign` (`class_type_id`);

--
-- Indexes for table `lgas`
--
ALTER TABLE `lgas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lgas_state_id_foreign` (`state_id`);

--
-- Indexes for table `marks`
--
ALTER TABLE `marks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `marks_student_id_foreign` (`student_id`),
  ADD KEY `marks_my_class_id_foreign` (`my_class_id`),
  ADD KEY `marks_section_id_foreign` (`section_id`),
  ADD KEY `marks_subject_id_foreign` (`subject_id`),
  ADD KEY `marks_exam_id_foreign` (`exam_id`),
  ADD KEY `marks_grade_id_foreign` (`grade_id`);

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

--
-- Indexes for table `my_classes`
--
ALTER TABLE `my_classes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `my_classes_class_type_id_name_unique` (`class_type_id`,`name`);

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

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payments_ref_no_unique` (`ref_no`),
  ADD KEY `payments_my_class_id_foreign` (`my_class_id`);

--
-- Indexes for table `payment_records`
--
ALTER TABLE `payment_records`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payment_records_ref_no_unique` (`ref_no`),
  ADD KEY `payment_records_payment_id_foreign` (`payment_id`),
  ADD KEY `payment_records_student_id_foreign` (`student_id`);

--
-- Indexes for table `pins`
--
ALTER TABLE `pins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pins_code_unique` (`code`),
  ADD KEY `pins_user_id_foreign` (`user_id`),
  ADD KEY `pins_student_id_foreign` (`student_id`);

--
-- Indexes for table `promotions`
--
ALTER TABLE `promotions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `promotions_student_id_foreign` (`student_id`),
  ADD KEY `promotions_from_class_foreign` (`from_class`),
  ADD KEY `promotions_from_section_foreign` (`from_section`),
  ADD KEY `promotions_to_section_foreign` (`to_section`),
  ADD KEY `promotions_to_class_foreign` (`to_class`);

--
-- Indexes for table `receipts`
--
ALTER TABLE `receipts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `receipts_pr_id_foreign` (`pr_id`);

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sections_name_my_class_id_unique` (`name`,`my_class_id`),
  ADD KEY `sections_my_class_id_foreign` (`my_class_id`),
  ADD KEY `sections_teacher_id_foreign` (`teacher_id`);

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

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

--
-- Indexes for table `staff_records`
--
ALTER TABLE `staff_records`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `staff_records_code_unique` (`code`),
  ADD KEY `staff_records_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `student_records`
--
ALTER TABLE `student_records`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `student_records_adm_no_unique` (`adm_no`),
  ADD KEY `student_records_user_id_foreign` (`user_id`),
  ADD KEY `student_records_my_class_id_foreign` (`my_class_id`),
  ADD KEY `student_records_section_id_foreign` (`section_id`),
  ADD KEY `student_records_my_parent_id_foreign` (`my_parent_id`),
  ADD KEY `student_records_dorm_id_foreign` (`dorm_id`);

--
-- Indexes for table `subjects`
--
ALTER TABLE `subjects`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subjects_my_class_id_name_unique` (`my_class_id`,`name`),
  ADD KEY `subjects_teacher_id_foreign` (`teacher_id`);

--
-- Indexes for table `time_slots`
--
ALTER TABLE `time_slots`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `time_slots_timestamp_from_timestamp_to_ttr_id_unique` (`timestamp_from`,`timestamp_to`,`ttr_id`),
  ADD KEY `time_slots_ttr_id_foreign` (`ttr_id`);

--
-- Indexes for table `time_tables`
--
ALTER TABLE `time_tables`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `time_tables_ttr_id_ts_id_day_unique` (`ttr_id`,`ts_id`,`day`),
  ADD UNIQUE KEY `time_tables_ttr_id_ts_id_exam_date_unique` (`ttr_id`,`ts_id`,`exam_date`),
  ADD KEY `time_tables_ts_id_foreign` (`ts_id`),
  ADD KEY `time_tables_subject_id_foreign` (`subject_id`);

--
-- Indexes for table `time_table_records`
--
ALTER TABLE `time_table_records`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `time_table_records_name_unique` (`name`),
  ADD UNIQUE KEY `time_table_records_my_class_id_exam_id_year_unique` (`my_class_id`,`exam_id`,`year`),
  ADD KEY `time_table_records_exam_id_foreign` (`exam_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blood_groups`
--
ALTER TABLE `blood_groups`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `book_requests`
--
ALTER TABLE `book_requests`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `class_types`
--
ALTER TABLE `class_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `dorms`
--
ALTER TABLE `dorms`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `exams`
--
ALTER TABLE `exams`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `exam_records`
--
ALTER TABLE `exam_records`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `grades`
--
ALTER TABLE `grades`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `lgas`
--
ALTER TABLE `lgas`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=775;

--
-- AUTO_INCREMENT for table `marks`
--
ALTER TABLE `marks`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `my_classes`
--
ALTER TABLE `my_classes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `nationalities`
--
ALTER TABLE `nationalities`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=194;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `payment_records`
--
ALTER TABLE `payment_records`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=152;

--
-- AUTO_INCREMENT for table `pins`
--
ALTER TABLE `pins`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `promotions`
--
ALTER TABLE `promotions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `receipts`
--
ALTER TABLE `receipts`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `skills`
--
ALTER TABLE `skills`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `staff_records`
--
ALTER TABLE `staff_records`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `student_records`
--
ALTER TABLE `student_records`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `time_slots`
--
ALTER TABLE `time_slots`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `time_tables`
--
ALTER TABLE `time_tables`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `time_table_records`
--
ALTER TABLE `time_table_records`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `user_types`
--
ALTER TABLE `user_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `books`
--
ALTER TABLE `books`
  ADD CONSTRAINT `books_my_class_id_foreign` FOREIGN KEY (`my_class_id`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `book_requests`
--
ALTER TABLE `book_requests`
  ADD CONSTRAINT `book_requests_book_id_foreign` FOREIGN KEY (`book_id`) REFERENCES `books` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `book_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `exam_records`
--
ALTER TABLE `exam_records`
  ADD CONSTRAINT `exam_records_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exam_records_my_class_id_foreign` FOREIGN KEY (`my_class_id`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exam_records_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exam_records_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `grades`
--
ALTER TABLE `grades`
  ADD CONSTRAINT `grades_class_type_id_foreign` FOREIGN KEY (`class_type_id`) REFERENCES `class_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `lgas`
--
ALTER TABLE `lgas`
  ADD CONSTRAINT `lgas_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `marks`
--
ALTER TABLE `marks`
  ADD CONSTRAINT `marks_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `marks_grade_id_foreign` FOREIGN KEY (`grade_id`) REFERENCES `grades` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `marks_my_class_id_foreign` FOREIGN KEY (`my_class_id`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `marks_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `marks_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `marks_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `my_classes`
--
ALTER TABLE `my_classes`
  ADD CONSTRAINT `my_classes_class_type_id_foreign` FOREIGN KEY (`class_type_id`) REFERENCES `class_types` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_my_class_id_foreign` FOREIGN KEY (`my_class_id`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payment_records`
--
ALTER TABLE `payment_records`
  ADD CONSTRAINT `payment_records_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payment_records_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pins`
--
ALTER TABLE `pins`
  ADD CONSTRAINT `pins_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pins_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `promotions`
--
ALTER TABLE `promotions`
  ADD CONSTRAINT `promotions_from_class_foreign` FOREIGN KEY (`from_class`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotions_from_section_foreign` FOREIGN KEY (`from_section`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotions_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotions_to_class_foreign` FOREIGN KEY (`to_class`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotions_to_section_foreign` FOREIGN KEY (`to_section`) REFERENCES `sections` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `receipts`
--
ALTER TABLE `receipts`
  ADD CONSTRAINT `receipts_pr_id_foreign` FOREIGN KEY (`pr_id`) REFERENCES `payment_records` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sections`
--
ALTER TABLE `sections`
  ADD CONSTRAINT `sections_my_class_id_foreign` FOREIGN KEY (`my_class_id`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sections_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `staff_records`
--
ALTER TABLE `staff_records`
  ADD CONSTRAINT `staff_records_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `student_records`
--
ALTER TABLE `student_records`
  ADD CONSTRAINT `student_records_dorm_id_foreign` FOREIGN KEY (`dorm_id`) REFERENCES `dorms` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `student_records_my_class_id_foreign` FOREIGN KEY (`my_class_id`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `student_records_my_parent_id_foreign` FOREIGN KEY (`my_parent_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `student_records_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `student_records_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subjects`
--
ALTER TABLE `subjects`
  ADD CONSTRAINT `subjects_my_class_id_foreign` FOREIGN KEY (`my_class_id`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `subjects_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `time_slots`
--
ALTER TABLE `time_slots`
  ADD CONSTRAINT `time_slots_ttr_id_foreign` FOREIGN KEY (`ttr_id`) REFERENCES `time_table_records` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `time_tables`
--
ALTER TABLE `time_tables`
  ADD CONSTRAINT `time_tables_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `time_tables_ts_id_foreign` FOREIGN KEY (`ts_id`) REFERENCES `time_slots` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `time_tables_ttr_id_foreign` FOREIGN KEY (`ttr_id`) REFERENCES `time_table_records` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `time_table_records`
--
ALTER TABLE `time_table_records`
  ADD CONSTRAINT `time_table_records_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `time_table_records_my_class_id_foreign` FOREIGN KEY (`my_class_id`) REFERENCES `my_classes` (`id`) ON DELETE CASCADE;
COMMIT;

