File Manager

✏️ Edit File: /home/coemyoza/sms.coeminna.edu.ng/db/smsminna.sql

-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 18, 2024 at 09:24 AM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `smsminna`
--

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

--
-- Table structure for table `action`
--

CREATE TABLE `action` (
  `id` bigint(5) UNSIGNED NOT NULL,
  `title` varchar(100) NOT NULL,
  `date_created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `action`
--

INSERT INTO `action` (`id`, `title`, `date_created`) VALUES
(1, 'Login', '2018-05-22 12:04:58'),
(2, 'New', '2018-05-22 12:05:01'),
(3, 'Change Password', '2018-05-22 12:05:28'),
(4, 'Edit', '2018-05-22 12:05:26'),
(5, 'Activate/Deactivate', '2018-05-22 12:05:57'),
(6, 'Password Reset', '2018-05-22 12:05:53'),
(7, 'Log Out', '2018-05-22 12:56:14');

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

--
-- Table structure for table `courses_preview`
--

CREATE TABLE `courses_preview` (
  `id` bigint(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `code` varchar(8) NOT NULL,
  `unit` int(1) NOT NULL,
  `levelid` varchar(3) NOT NULL,
  `semid` varchar(10) NOT NULL,
  `statusid` varchar(10) NOT NULL,
  `tname` varchar(50) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `created_by` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `course_status`
--

CREATE TABLE `course_status` (
  `id` bigint(20) NOT NULL,
  `title` varchar(15) NOT NULL,
  `created_by` int(10) NOT NULL,
  `date_created` date NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `course_status`
--

INSERT INTO `course_status` (`id`, `title`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1, 'Compulsary', 1019, '2024-03-06', NULL, NULL),
(2, 'Elective', 1019, '2024-03-06', NULL, NULL);

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

--
-- Table structure for table `default_academic`
--

CREATE TABLE `default_academic` (
  `id` bigint(5) UNSIGNED NOT NULL,
  `programs` varchar(50) NOT NULL,
  `semid` int(1) NOT NULL,
  `sdate` varchar(10) DEFAULT NULL,
  `edate` varchar(10) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` int(10) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `modified_by` int(4) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_academic`
--

INSERT INTO `default_academic` (`id`, `programs`, `semid`, `sdate`, `edate`, `status`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1, '2022/2023', 2, '11-12-2022', '11-10-2023', 0, 1019, '2024-03-11 09:07:57', NULL, NULL),
(2, '2023/2024', 2, '02-12-2023', '30-10-2024', 1, 1019, '2024-03-29 21:15:29', 1019, '2024-04-08 11:32:35');

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

--
-- Table structure for table `default_bookstore`
--

CREATE TABLE `default_bookstore` (
  `id` bigint(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `url` varchar(100) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` int(10) NOT NULL,
  `date_created` date NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_bookstore`
--

INSERT INTO `default_bookstore` (`id`, `title`, `url`, `description`, `username`, `password`, `status`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1, 'Ebscohost', 'https://search.ebscohost.com/', '', '', '', 1, 1019, '2024-04-15', NULL, NULL),
(2, 'Emerald eJournals', 'https://www.emerald.com/insight/regiater', '', '', '', 1, 1019, '2024-04-15', NULL, NULL),
(3, 'Research 4Life', 'https://login.research4life.org/tacgw/login.cshtml', '', 'NIE658', '26379', 1, 1019, '2024-04-15', NULL, NULL),
(4, 'JSTOR', 'https://www.jstor.org/', '', '', '', 1, 1019, '2024-04-15', NULL, NULL),
(5, 'OA.MG', 'https://oa.mg/', '', '', '', 1, 1019, '2024-04-15', NULL, NULL),
(6, 'Science Direct', 'https://www.sciencedirect.com/', '', '', '', 1, 1019, '2024-04-15', NULL, NULL),
(7, 'Scopus', 'https://www.scopus.com/home.uri', '', '', '', 1, 1019, '2024-04-15', NULL, NULL),
(8, 'IMF eLibrary', 'https://www.elibrary.imf.org/', '', '', '', 1, 1019, '2024-04-15', NULL, NULL);

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

--
-- Table structure for table `default_courses`
--

CREATE TABLE `default_courses` (
  `id` bigint(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `code` varchar(8) NOT NULL,
  `unit` int(1) NOT NULL,
  `deptid` int(4) NOT NULL,
  `levelid` int(3) NOT NULL,
  `semid` int(1) NOT NULL,
  `statusid` varchar(30) NOT NULL,
  `tname` varchar(50) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` int(10) NOT NULL,
  `date_created` date NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_courses`
--

INSERT INTO `default_courses` (`id`, `title`, `code`, `unit`, `deptid`, `levelid`, `semid`, `statusid`, `tname`, `phone`, `email`, `status`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(2, 'Software Engineering Methodologies', 'CIT231', 3, 1, 2, 1, '1', NULL, NULL, NULL, 1, 1019, '2024-03-06', NULL, NULL),
(4, 'Advanced Information Storage and Retrieval ', 'CIT241', 2, 1, 2, 1, '2', NULL, NULL, NULL, 1, 1019, '2024-03-06', NULL, NULL),
(5, 'Introduction to Database Management', 'CIT243', 2, 1, 2, 1, '1', NULL, NULL, NULL, 1, 1019, '2024-03-06', NULL, NULL),
(6, 'Advanced Systems Analysis and Design', 'CIT251', 3, 1, 2, 1, '1', NULL, NULL, NULL, 1, 1019, '2024-03-06', NULL, NULL),
(7, 'Internet Concepts and Web Design', 'CIT253', 2, 1, 2, 1, '1', NULL, NULL, NULL, 1, 1019, '2024-03-06', NULL, NULL),
(8, 'Advanced Cyber Security', 'CIT255', 3, 1, 2, 1, '2', NULL, NULL, NULL, 1, 1019, '2024-03-06', NULL, NULL),
(9, 'A Study Guide for the Distance Learner', 'GST207', 2, 1, 2, 1, '1', NULL, NULL, NULL, 1, 1019, '2024-03-06', NULL, NULL),
(11, 'User Interface Design and Ergonomic', 'CIT211', 3, 1, 2, 1, '1', '', '', '', 1, 1019, '2024-03-29', NULL, NULL),
(12, 'Technical Report Writing', 'CIT202', 3, 1, 2, 2, '1', '', '', '', 1, 1019, '2024-03-29', NULL, NULL),
(13, 'Object-oriented Programming Using C', 'CIT234', 3, 1, 2, 2, '1', '', '', '', 1, 1019, '2024-03-29', NULL, NULL),
(14, 'Data Communication and Networks', 'CIT252', 3, 1, 2, 2, '1', '', '', '', 1, 1019, '2024-03-29', NULL, NULL),
(15, 'Network Programming and Design', 'CIT254', 3, 1, 2, 2, '1', '', '', '', 1, 1019, '2024-03-29', NULL, NULL),
(16, 'Internet of Things', 'CIT282', 2, 1, 2, 2, '2', '', '', '', 1, 1019, '2024-03-29', NULL, NULL),
(17, 'Computer Programming I', 'CSE301', 3, 1, 3, 1, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(18, 'Computer Logic I', 'CSE303', 3, 1, 3, 1, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(19, 'Data Base Design and Management', 'CSE305', 3, 1, 3, 1, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(20, 'Numerical Computation I', 'CSE307', 3, 1, 3, 1, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(21, 'Automata Theory and Computability', 'CSE311', 3, 1, 3, 1, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(22, 'Engineering Statistics', 'CSE331', 3, 1, 3, 1, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(23, 'Technology and Society', 'MGS201', 1, 3, 3, 1, '2', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(24, 'Linear Algebra I', 'MTH203', 2, 7, 3, 1, '2', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(25, 'Sets, Logic and Algebra', 'MTH307', 3, 7, 3, 1, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(26, 'Computer Programming II', 'CSE302', 3, 1, 3, 2, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(27, 'Computer Logic II', 'CSE304', 3, 1, 3, 2, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(28, 'Assembly Language Programming', 'CSE308', 3, 1, 3, 2, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(29, 'Numerical Computation II', 'CSE310', 3, 1, 3, 2, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(30, 'Data Structures and Algorithms', 'CSE312', 3, 1, 3, 2, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(31, 'Fundamentals of Software Engineering', 'CSE314', 3, 1, 3, 2, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(32, 'Student Work Experience', 'FET300', 2, 8, 3, 2, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(33, 'Mechanical Maintenance and Repairs', 'MEE300', 2, 8, 3, 2, '1', '', '', '', 1, 1019, '2024-03-31', NULL, NULL),
(34, 'Project methodology', 'CVE401', 1, 1, 4, 1, '1', '', '', '', 1, 1019, '2024-04-03', NULL, NULL),
(35, 'Computer Architecture', 'CSE419', 3, 1, 4, 1, '1', '', '', '', 1, 1019, '2024-04-03', NULL, NULL),
(36, 'Complier Construction', 'CSE413', 3, 1, 4, 1, '1', '', '', '', 1, 1019, '2024-04-03', NULL, NULL),
(37, 'User Interfaces Design', 'CSE411', 3, 1, 4, 1, '1', '', '', '', 1, 1019, '2024-04-03', NULL, NULL),
(38, 'Simulation and Modelling', 'CSE409', 2, 1, 4, 1, '1', '', '', '', 1, 1019, '2024-04-03', NULL, NULL),
(39, 'Artificial Intelligence', 'CSE407', 2, 1, 4, 1, '1', '', '', '', 1, 1019, '2024-04-03', NULL, NULL),
(40, 'Programming Project', 'CSE405', 2, 1, 4, 1, '1', '', '', '', 1, 1019, '2024-04-03', NULL, NULL),
(41, 'Principles of Programming Language', 'CSE401', 3, 1, 4, 1, '1', 'Mr. Audu Ogbe', '80', '', 1, 1019, '2024-04-03', NULL, NULL),
(42, 'Operating Systems', 'CSE403', 3, 1, 4, 1, '1', 'Mr. Emmanuel', '', 'ema@yahoo.com', 1, 1019, '2024-04-03', NULL, NULL),
(43, 'Student Industrial Work Experience Scheme', 'FET400', 6, 1, 4, 2, '1', '', '', '', 1, 1019, '2024-04-03', NULL, NULL);

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

--
-- Table structure for table `default_department`
--

CREATE TABLE `default_department` (
  `id` bigint(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `code` varchar(8) DEFAULT NULL,
  `head` varchar(100) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `facid` int(4) NOT NULL,
  `created_by` int(10) NOT NULL,
  `date_created` date NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_department`
--

INSERT INTO `default_department` (`id`, `title`, `code`, `head`, `email`, `phone`, `facid`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1, 'Artificial Intelligence ', 'AI', 'Mr. Emmanuel', 'prof@yahoo.com', '', 6, 1019, '2024-03-06', NULL, NULL),
(2, 'Robotics', 'RBC', 'MRS. Maja Omisore', 'mishadworld@yahoo.com', '7675645535445', 6, 1019, '2024-03-06', 1019, '2024-03-06'),
(3, 'Business Administration ', 'BSN', 'MRS. Iyiola', 'mishadworld@yahoo.com', '', 3, 1019, '2024-03-06', 0, '2024-03-08'),
(5, 'Information Technology ', 'DIT', 'Dr. Tobi Akande', 'prof@yahoo.com', '080', 7, 1019, '2024-03-06', NULL, NULL),
(6, 'Testing Microphe', '', 'Dr. Tobi Akande', 'prof@yahoo.com', '090564563', 5, 0, '2024-03-08', 0, '2024-03-08'),
(7, 'Applied Mathematics', 'APM', '', '', '', 4, 0, '2024-03-31', NULL, NULL),
(8, 'Mechanical', 'MEE', '', '', '', 5, 0, '2024-03-31', NULL, NULL);

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

--
-- Table structure for table `default_faculty`
--

CREATE TABLE `default_faculty` (
  `id` bigint(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `code` varchar(8) DEFAULT NULL,
  `head` varchar(100) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `created_by` int(10) NOT NULL,
  `date_created` date NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_faculty`
--

INSERT INTO `default_faculty` (`id`, `title`, `code`, `head`, `email`, `phone`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(6, 'Falculty Of Computer Science & Engineering ', 'CSE', 'Dr. Tobi Akande', 'mishadworld@yahoo.com', '09854565', 1019, '2024-03-06', 1019, '2024-03-06'),
(3, 'Falculty Of Engineering And Management Science', 'FEMS', 'Dr. Arulogun', 'mishadworld@yahoo.com', '', 1019, '2024-03-06', 1019, '2024-03-06'),
(4, 'Falculty Of Sciences', 'FS', 'Dr. Arulogun', 'mishadworld@yahoo.com', '', 1019, '2024-03-06', 1019, '2024-03-06'),
(5, 'Falculty Of Engineering', 'FOE', 'Dr. Arulogun', 'mishadworld@yahoo.com', '090564563', 1019, '2024-03-06', 0, '2024-03-08'),
(7, 'Faculty Of Information Technology', 'FIT', 'Prof. Isiak Atoyebi', 'prof@yahoo.com', '', 1019, '2024-03-06', NULL, NULL);

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

--
-- Table structure for table `default_grading`
--

CREATE TABLE `default_grading` (
  `id` bigint(5) UNSIGNED NOT NULL,
  `min_score` int(2) NOT NULL,
  `max_score` int(3) NOT NULL,
  `grade` char(5) NOT NULL,
  `remarks` varchar(50) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` int(10) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `modified_by` int(4) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_grading`
--

INSERT INTO `default_grading` (`id`, `min_score`, `max_score`, `grade`, `remarks`, `status`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1, 70, 100, 'A', NULL, 1, 1019, '2024-03-11 09:07:57', NULL, NULL),
(2, 60, 69, 'B', NULL, 1, 1019, '2024-03-15 22:19:31', NULL, NULL),
(3, 50, 59, 'C', NULL, 1, 1019, '2024-03-15 22:20:53', NULL, NULL),
(4, 46, 49, 'D', NULL, 1, 1019, '2024-03-15 22:22:29', NULL, NULL),
(5, 40, 45, 'E', NULL, 1, 1019, '2024-03-15 22:23:42', NULL, NULL),
(6, 0, 39, 'F', '', 1, 1019, '2024-03-15 22:24:42', 1019, '2024-04-06 11:46:48');

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

--
-- Table structure for table `default_groups`
--

CREATE TABLE `default_groups` (
  `id` int(11) NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Permission roles such as admins, moderators, staff, etc';

--
-- Dumping data for table `default_groups`
--

INSERT INTO `default_groups` (`id`, `title`, `description`) VALUES
(1, 'Student', 'Students'),
(2, 'Lecturer', 'Lecturers'),
(3, 'Liberian', 'Liberians'),
(4, 'Record', 'Records Unit/Section'),
(5, 'Bursar', 'Academic Bursar'),
(8, 'Administrator', 'Administrators'),
(9, 'Super Admin', 'Super Administrator');

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

--
-- Table structure for table `default_hostel`
--

CREATE TABLE `default_hostel` (
  `id` bigint(5) UNSIGNED NOT NULL,
  `uid` int(10) NOT NULL,
  `catid` int(3) NOT NULL,
  `roomid` int(4) NOT NULL,
  `bedid` int(4) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` int(10) NOT NULL,
  `date_created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_hostel`
--

INSERT INTO `default_hostel` (`id`, `uid`, `catid`, `roomid`, `bedid`, `status`, `created_by`, `date_created`) VALUES
(1, 2023, 1, 0, 0, 1, 1019, '2024-03-11 09:07:57');

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

--
-- Table structure for table `default_level`
--

CREATE TABLE `default_level` (
  `id` int(11) NOT NULL,
  `title` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Permission roles such as admins, moderators, staff, etc';

--
-- Dumping data for table `default_level`
--

INSERT INTO `default_level` (`id`, `title`, `description`) VALUES
(1, '100', '100 Level Students'),
(2, '200', '200 Level Students'),
(3, '300', '300 Level Students'),
(4, '400', '400 Level Students'),
(5, '500', '500 Level Students'),
(6, '600', '600 Level Students '),
(7, '700', '700 Level Students '),
(8, '800', '800 Level Students '),
(9, '900', '900 Level Students ');

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

--
-- Table structure for table `default_matric`
--

CREATE TABLE `default_matric` (
  `id` bigint(5) UNSIGNED NOT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `digits_no` int(10) NOT NULL,
  `suffix` varchar(50) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` int(10) NOT NULL,
  `date_created` datetime DEFAULT NULL,
  `modified_by` int(4) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_matric`
--

INSERT INTO `default_matric` (`id`, `prefix`, `digits_no`, `suffix`, `status`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1, 'FGCL', 3, '', 1, 1019, '2024-03-11 09:07:57', 1019, '2024-04-06 09:39:42');

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

--
-- Table structure for table `default_region_countries`
--

CREATE TABLE `default_region_countries` (
  `id` int(10) NOT NULL,
  `title` varchar(50) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `default_region_countries`
--

INSERT INTO `default_region_countries` (`id`, `title`) VALUES
(1, 'Afghanistan'),
(2, 'Aland Islands'),
(3, 'Albania'),
(4, 'Algeria'),
(5, 'American Samoa'),
(6, 'Andorra'),
(7, 'Angola'),
(8, 'Anguilla'),
(9, 'Antarctica'),
(10, 'Antigua and Barbuda'),
(11, 'Argentina'),
(12, 'Armenia'),
(13, 'Aruba'),
(14, 'Australia'),
(15, 'Austria'),
(16, 'Azerbaijan'),
(17, 'Bahamas'),
(18, 'Bahrain'),
(19, 'Bangladesh'),
(20, 'Barbados'),
(21, 'Belarus'),
(22, 'Belgium'),
(23, 'Belize'),
(24, 'Benin'),
(25, 'Bermuda'),
(26, 'Bhutan'),
(27, 'Bolivia'),
(28, 'Bonaire, Sint Eustatius and Saba'),
(29, 'Bosnia and Herzegovina'),
(30, 'Botswana'),
(31, 'Bouvet Island'),
(32, 'Brazil'),
(33, 'British Indian Ocean Territory'),
(34, 'Brunei Darussalam'),
(35, 'Bulgaria'),
(36, 'Burkina Faso'),
(37, 'Burundi'),
(38, 'Cambodia'),
(39, 'Cameroon'),
(40, 'Canada'),
(41, 'Cape Verde'),
(42, 'Cayman Islands'),
(43, 'Central African Republic'),
(44, 'Chad'),
(45, 'Chile'),
(46, 'China'),
(47, 'Christmas Island'),
(48, 'Cocos (Keeling) Islands'),
(49, 'Colombia'),
(50, 'Comoros'),
(51, 'Congo'),
(52, 'Congo, Democratic Republic of the Congo'),
(53, 'Cook Islands'),
(54, 'Costa Rica'),
(55, 'Cote D\'Ivoire'),
(56, 'Croatia'),
(57, 'Cuba'),
(58, 'Curacao'),
(59, 'Cyprus'),
(60, 'Czech Republic'),
(61, 'Denmark'),
(62, 'Djibouti'),
(63, 'Dominica'),
(64, 'Dominican Republic'),
(65, 'Ecuador'),
(66, 'Egypt'),
(67, 'Salvador'),
(68, 'Equatorial Guinea'),
(69, 'Eritrea'),
(70, 'Estonia'),
(71, 'Ethiopia'),
(72, 'Falkland Islands (Malvinas)'),
(73, 'Faroe Islands'),
(74, 'Fiji'),
(75, 'Finland'),
(76, 'France'),
(77, 'French Guiana'),
(78, 'French Polynesia'),
(79, 'French Southern Territories'),
(80, 'Gabon'),
(81, 'Gambia'),
(82, 'Georgia'),
(83, 'Germany'),
(84, 'Ghana'),
(85, 'Gibraltar'),
(86, 'Greece'),
(87, 'Greenland'),
(88, 'Grenada'),
(89, 'Guadeloupe'),
(90, 'Guam'),
(91, 'Guatemala'),
(92, 'Guernsey'),
(93, 'Guinea'),
(94, 'Guinea-Bissau'),
(95, 'Guyana'),
(96, 'Haiti'),
(97, 'Heard Island and Mcdonald Islands'),
(98, 'Holy See (Vatican City State)'),
(99, 'Honduras'),
(100, 'Hong Kong'),
(101, 'Hungary'),
(102, 'Iceland'),
(103, 'India'),
(104, 'Indonesia'),
(105, 'Iran, Islamic Republic of'),
(106, 'Iraq'),
(107, 'Ireland'),
(108, 'Isle of Man'),
(109, 'Israel'),
(110, 'Italy'),
(111, 'Jamaica'),
(112, 'Japan'),
(113, 'Jersey'),
(114, 'Jordan'),
(115, 'Kazakhstan'),
(116, 'Kenya'),
(117, 'Kiribati'),
(118, 'Korea, Democratic People\'s Republic of'),
(119, 'Korea, Republic of'),
(120, 'Kosovo'),
(121, 'Kuwait'),
(122, 'Kyrgyzstan'),
(123, 'Lao People\'s Democratic Republic'),
(124, 'Latvia'),
(125, 'Lebanon'),
(126, 'Lesotho'),
(127, 'Liberia'),
(128, 'Libyan Arab Jamahiriya'),
(129, 'Liechtenstein'),
(130, 'Lithuania'),
(131, 'Luxembourg'),
(132, 'Macao'),
(133, 'Macedonia, the Former Yugoslav Republic of'),
(134, 'Madagascar'),
(135, 'Malawi'),
(136, 'Malaysia'),
(137, 'Maldives'),
(138, 'Mali'),
(139, 'Malta'),
(140, 'Marshall Islands'),
(141, 'Martinique'),
(142, 'Mauritania'),
(143, 'Mauritius'),
(144, 'Mayotte'),
(145, 'Mexico'),
(146, 'Micronesia, Federated States of'),
(147, 'Moldova, Republic of'),
(148, 'Monaco'),
(149, 'Mongolia'),
(150, 'Montenegro'),
(151, 'Montserrat'),
(152, 'Morocco'),
(153, 'Mozambique'),
(154, 'Myanmar'),
(155, 'Namibia'),
(156, 'Nauru'),
(157, 'Nepal'),
(158, 'Netherlands'),
(159, 'Netherlands Antilles'),
(160, 'New Caledonia'),
(161, 'New Zealand'),
(162, 'Nicaragua'),
(163, 'Niger'),
(164, 'Nigeria'),
(165, 'Niue'),
(166, 'Norfolk Island'),
(167, 'Northern Mariana Islands'),
(168, 'Norway'),
(169, 'Oman'),
(170, 'Pakistan'),
(171, 'Palau'),
(172, 'Palestinian Territory, Occupied'),
(173, 'Panama'),
(174, 'Papua New Guinea'),
(175, 'Paraguay'),
(176, 'Peru'),
(177, 'Philippines'),
(178, 'Pitcairn'),
(179, 'Poland'),
(180, 'Portugal'),
(181, 'Puerto Rico'),
(182, 'Qatar'),
(183, 'Reunion'),
(184, 'Romania'),
(185, 'Russian Federation'),
(186, 'Rwanda'),
(187, 'Saint Barthelemy'),
(188, 'Saint Helena'),
(189, 'Saint Kitts and Nevis'),
(190, 'Saint Lucia'),
(191, 'Saint Martin'),
(192, 'Saint Pierre and Miquelon'),
(193, 'Saint Vincent and the Grenadines'),
(194, 'Samoa'),
(195, 'San Marino'),
(196, 'Sao Tome and Principe'),
(197, 'Saudi Arabia'),
(198, 'Senegal'),
(199, 'Serbia'),
(200, 'Serbia and Montenegro'),
(201, 'Seychelles'),
(202, 'Sierra Leone'),
(203, 'Singapore'),
(204, 'Sint Maarten'),
(205, 'Slovakia'),
(206, 'Slovenia'),
(207, 'Solomon Islands'),
(208, 'Somalia'),
(209, 'South Africa'),
(210, 'South Georgia and the South Sandwich Islands'),
(211, 'South Sudan'),
(212, 'Spain'),
(213, 'Sri Lanka'),
(214, 'Sudan'),
(215, 'Suriname'),
(216, 'Svalbard and Jan Mayen'),
(217, 'Swaziland'),
(218, 'Sweden'),
(219, 'Switzerland'),
(220, 'Syrian Arab Republic'),
(221, 'Taiwan, Province of China'),
(222, 'Tajikistan'),
(223, 'Tanzania, United Republic of'),
(224, 'Thailand'),
(225, 'Timor-Leste'),
(226, 'Togo'),
(227, 'Tokelau'),
(228, 'Tonga'),
(229, 'Trinidad and Tobago'),
(230, 'Tunisia'),
(231, 'Turkey'),
(232, 'Turkmenistan'),
(233, 'Turks and Caicos Islands'),
(234, 'Tuvalu'),
(235, 'Uganda'),
(236, 'Ukraine'),
(237, 'United Arab Emirates'),
(238, 'United Kingdom'),
(239, 'United States'),
(240, 'United States Minor Outlying Islands'),
(241, 'Uruguay'),
(242, 'Uzbekistan'),
(243, 'Vanuatu'),
(244, 'Venezuela'),
(245, 'Viet Nam'),
(246, 'Virgin Islands, British'),
(247, 'Virgin Islands, U.s.'),
(248, 'Wallis and Futuna'),
(249, 'Western Sahara'),
(250, 'Yemen'),
(251, 'Zambia'),
(252, 'Zimbabwe');

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

--
-- Table structure for table `default_region_lga`
--

CREATE TABLE `default_region_lga` (
  `id` int(10) NOT NULL,
  `state_id` int(2) NOT NULL,
  `title` varchar(50) COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `default_region_lga`
--

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

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

--
-- Table structure for table `default_region_states`
--

CREATE TABLE `default_region_states` (
  `id` int(10) NOT NULL,
  `title` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `country_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `default_region_states`
--

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

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

--
-- Table structure for table `default_semester`
--

CREATE TABLE `default_semester` (
  `id` bigint(20) NOT NULL,
  `title` varchar(15) NOT NULL,
  `slog` varchar(5) NOT NULL,
  `created_by` int(10) NOT NULL,
  `date_created` date NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_semester`
--

INSERT INTO `default_semester` (`id`, `title`, `slog`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1, 'First', '1st', 1019, '2024-03-06', NULL, NULL),
(2, 'Second', '2nd', 1019, '2024-03-06', NULL, NULL);

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

--
-- Table structure for table `default_support`
--

CREATE TABLE `default_support` (
  `id` bigint(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  `email` varchar(30) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` int(10) NOT NULL,
  `date_created` date NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `default_tickets`
--

CREATE TABLE `default_tickets` (
  `id` int(11) NOT NULL,
  `refid` varchar(50) NOT NULL,
  `matid` int(10) NOT NULL,
  `ticket_type` int(1) NOT NULL DEFAULT 0,
  `cat` varchar(100) NOT NULL,
  `comments` text NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_size` varchar(100) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `assigned_to` int(4) DEFAULT NULL,
  `date_applied` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `default_users`
--

CREATE TABLE `default_users` (
  `id` int(11) NOT NULL,
  `md5` varchar(255) DEFAULT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `access_level` int(2) NOT NULL DEFAULT 1,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `other_name` varchar(100) DEFAULT NULL,
  `phone` varchar(250) DEFAULT NULL,
  `email` varchar(200) NOT NULL,
  `pstatus_id` int(2) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `dept_id` int(4) NOT NULL DEFAULT 0,
  `level_id` int(3) NOT NULL DEFAULT 0,
  `academic_statusid` bigint(4) NOT NULL DEFAULT 0,
  `activation_code` int(6) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `banned` int(1) NOT NULL DEFAULT 0,
  `display_name` varchar(255) DEFAULT NULL,
  `passport` varchar(100) DEFAULT NULL,
  `terms_agree` int(1) NOT NULL DEFAULT 1,
  `document_type` int(1) NOT NULL DEFAULT 0,
  `last_login` varchar(20) DEFAULT NULL,
  `user_ip` varchar(15) NOT NULL,
  `ckey` varchar(10) DEFAULT NULL,
  `ctime` varchar(10) DEFAULT NULL,
  `created_by` int(10) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `default_users`
--

INSERT INTO `default_users` (`id`, `md5`, `username`, `password`, `access_level`, `first_name`, `last_name`, `other_name`, `phone`, `email`, `pstatus_id`, `address`, `dept_id`, `level_id`, `academic_statusid`, `activation_code`, `status`, `banned`, `display_name`, `passport`, `terms_agree`, `document_type`, `last_login`, `user_ip`, `ckey`, `ctime`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1000, NULL, 'admin', '8a80d968bfd82acbb1d2ca97c8da56b9350dffc982345e396', 9, 'Supper', 'Admin', '', '08033694738', 'admin@localhost.com', 0, 'O.P., Fingesi Street, Utako, Abuja', 0, 0, 2, NULL, 1, 0, 'Mikkysho', NULL, 1, 0, '2024-07-11 15:53:34', '::1', 'zbvdi3s', '1720709614', 0, '2024-02-11 10:04:18', NULL, NULL),
(1001, NULL, 'testuser', 'f8b7f85fdee6ea3fd4a63307afb60dbd183313bf6ebd1da61', 1, 'Ishola', 'Adeyemi', '', '09035456453', 'mishadworld@yahoo.com', 6, 'Tanke Akata, Ilorin', 1, 3, 2, 412562, 1, 0, 'Starmikky', 'MI ADEDIRAN.jpg', 1, 0, '2024-07-17 20:57:06', '127.0.0.1', '235idjo', '1721246226', 0, '2023-03-30 23:09:50', 1006, '2024-03-21'),
(1002, '', 'testadmin', 'c8fda717f4c41eeb20e3d8f057789ece8c0e19d5e24b742be', 8, 'System Adnin', 'Administrator', '', '0803369', 'testadmin@localhost.com', NULL, 'Utako Abuja, FCT', 0, 0, 2, 998308, 1, 0, 'Sys Admin', 'IMG-20240226-WA0057.jpg', 1, 0, '2024-07-18 07:22:30', '127.0.0.1', 'kc698s3', '1721283750', 0, '2024-03-30 17:07:48', 1019, '2024-03-11');

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

--
-- Table structure for table `hostel_applications`
--

CREATE TABLE `hostel_applications` (
  `id` int(11) NOT NULL,
  `studid` int(10) NOT NULL,
  `catid` int(4) NOT NULL,
  `price` double(10,2) NOT NULL,
  `roomid` int(4) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `bedid` int(4) NOT NULL,
  `created_by` int(4) NOT NULL,
  `date_created` datetime NOT NULL,
  `approval` int(1) NOT NULL DEFAULT 0,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Permission roles such as admins, moderators, staff, etc';

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

--
-- Table structure for table `hostel_bed`
--

CREATE TABLE `hostel_bed` (
  `id` int(11) NOT NULL,
  `bed_no` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `roomid` int(4) NOT NULL,
  `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` int(4) NOT NULL,
  `date_created` datetime NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Permission roles such as admins, moderators, staff, etc';

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

--
-- Table structure for table `hostel_category`
--

CREATE TABLE `hostel_category` (
  `id` int(11) NOT NULL,
  `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(4) NOT NULL,
  `date_created` datetime NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Permission roles such as admins, moderators, staff, etc';

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

--
-- Table structure for table `hostel_room`
--

CREATE TABLE `hostel_room` (
  `id` int(11) NOT NULL,
  `room_no` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `catid` int(4) NOT NULL,
  `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `charge` decimal(10,2) NOT NULL,
  `created_by` int(4) NOT NULL,
  `date_created` datetime NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Permission roles such as admins, moderators, staff, etc';

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

--
-- Table structure for table `marital_status`
--

CREATE TABLE `marital_status` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `marital_status`
--

INSERT INTO `marital_status` (`id`, `title`) VALUES
(1, 'Single'),
(2, 'Engaged'),
(3, 'Divorced'),
(4, 'Seperated'),
(5, 'Remarried'),
(6, 'Married');

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

--
-- Table structure for table `module`
--

CREATE TABLE `module` (
  `id` bigint(5) UNSIGNED NOT NULL,
  `title` varchar(100) NOT NULL,
  `date_created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `module`
--

INSERT INTO `module` (`id`, `title`, `date_created`) VALUES
(1, 'Users Management', '2018-05-22 12:04:20'),
(2, 'Membership Management', '2018-05-22 12:03:10'),
(3, 'Contributions Management', '2018-05-22 12:03:22'),
(4, 'Loan Management', '2018-05-22 12:03:36'),
(5, 'Contents Management', '2018-05-22 12:42:59');

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

--
-- Table structure for table `news_flash`
--

CREATE TABLE `news_flash` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `news` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `created_by` varchar(15) NOT NULL,
  `date_created` date NOT NULL,
  `modified_by` varchar(15) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `payment_history`
--

CREATE TABLE `payment_history` (
  `id` int(11) NOT NULL,
  `transid` varchar(255) DEFAULT NULL,
  `matid` int(10) NOT NULL,
  `request_type` int(1) NOT NULL DEFAULT 0,
  `description` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `payment_type` varchar(50) NOT NULL,
  `date_applied` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `payment_logs`
--

CREATE TABLE `payment_logs` (
  `id` int(11) NOT NULL,
  `transid` varchar(255) DEFAULT NULL,
  `matid` int(10) NOT NULL,
  `request_type` int(1) NOT NULL DEFAULT 0,
  `description` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 100.00,
  `status` int(1) NOT NULL DEFAULT 0,
  `payment_type` varchar(50) NOT NULL,
  `date_applied` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `record_verification`
--

CREATE TABLE `record_verification` (
  `id` int(11) NOT NULL,
  `transcriptid` varchar(30) NOT NULL,
  `paymentid` int(10) NOT NULL DEFAULT 0,
  `matid` int(10) NOT NULL,
  `company` varchar(100) DEFAULT NULL,
  `recipient_email` varchar(30) NOT NULL,
  `contact_person` varchar(30) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `dtype` varchar(20) NOT NULL,
  `dmajor` varchar(100) NOT NULL,
  `atfrom` date NOT NULL,
  `atto` date NOT NULL,
  `dgraduate` date NOT NULL,
  `countryid` int(3) NOT NULL,
  `stateid` varchar(100) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `file_name` varchar(255) DEFAULT NULL,
  `file_size` varchar(100) DEFAULT NULL,
  `courier_name` varchar(100) DEFAULT NULL,
  `track_no` varchar(30) DEFAULT NULL,
  `date_applied` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `registered_courses`
--

CREATE TABLE `registered_courses` (
  `id` bigint(20) NOT NULL,
  `matno` varchar(20) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `ccode` varchar(8) NOT NULL,
  `unit` int(1) NOT NULL,
  `cstatus` int(1) NOT NULL,
  `deptid` int(4) NOT NULL,
  `levelid` int(3) NOT NULL,
  `sesid` bigint(20) NOT NULL,
  `semid` int(1) NOT NULL,
  `test_score` int(2) DEFAULT NULL,
  `exam_score` int(3) NOT NULL DEFAULT 0,
  `total_score` int(3) DEFAULT NULL,
  `grade` char(2) DEFAULT NULL,
  `point` int(2) DEFAULT NULL,
  `gpoint` int(2) DEFAULT NULL,
  `remarks` varchar(50) DEFAULT NULL,
  `created_by` int(10) NOT NULL,
  `date_created` datetime NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `registered_courses`
--

INSERT INTO `registered_courses` (`id`, `matno`, `title`, `ccode`, `unit`, `cstatus`, `deptid`, `levelid`, `sesid`, `semid`, `test_score`, `exam_score`, `total_score`, `grade`, `point`, `gpoint`, `remarks`, `created_by`, `date_created`, `modified_by`, `last_modified`) VALUES
(1, 'testuser', 'A Study Guide for the Distance Learner', 'GST207', 2, 1, 1, 2, 1, 1, 10, 38, 48, 'D', 2, 4, '', 1006, '2024-03-21 17:45:05', 1019, '2024-04-01 16:31:05'),
(2, 'testuser', 'Advanced Cyber Security', 'CIT255', 3, 2, 1, 2, 1, 1, 11, 45, 56, 'C', 3, 9, '', 1006, '2024-03-21 17:45:05', 1019, '2024-04-01 16:30:51'),
(3, 'testuser', 'Advanced Information Storage and Retrieval ', 'CIT241', 2, 2, 1, 2, 1, 1, 15, 48, 63, 'B', 4, 8, '', 1006, '2024-03-21 21:45:37', 1019, '2024-04-01 16:30:39'),
(8, 'testuser', 'Advanced Systems Analysis and Design', 'CIT251', 3, 1, 1, 2, 1, 1, 21, 60, 81, 'A', 5, 15, '', 1006, '2024-03-21 23:10:59', 1019, '2024-04-01 16:29:27'),
(5, 'testuser', 'Internet Concepts and Web Design', 'CIT253', 2, 1, 1, 2, 1, 1, 19, 62, 81, 'A', 5, 10, '', 1006, '2024-03-21 21:48:04', 1019, '2024-04-01 16:30:26'),
(6, 'testuser', 'Introduction to Database Management', 'CIT243', 2, 1, 1, 2, 1, 1, 18, 65, 83, 'A', 5, 10, '', 1006, '2024-03-21 21:48:04', 1019, '2024-04-01 16:29:46'),
(9, 'testuser', 'Software Engineering Methodologies', 'CIT231', 3, 1, 1, 2, 1, 1, 26, 65, 91, 'A', 5, 15, '', 1006, '2024-03-21 23:55:10', 1019, '2024-04-01 16:29:03'),
(10, 'testuser', 'User Interface Design and Ergonomic', 'CIT211', 3, 1, 1, 2, 1, 1, 22, 47, 69, 'B', 4, 12, '', 1006, '2024-03-29 09:41:49', 1019, '2024-04-01 16:28:52'),
(11, 'testuser', 'Data Communication and Networks', 'CIT252', 3, 1, 1, 2, 1, 2, 21, 52, 73, 'A', 5, 15, '', 1006, '2024-03-29 23:45:50', 1019, '2024-04-01 16:28:35'),
(12, 'testuser', 'Internet of Things', 'CIT282', 2, 2, 1, 2, 1, 2, 15, 34, 49, 'D', 2, 4, '', 1006, '2024-03-29 23:45:50', 1019, '2024-04-01 16:28:23'),
(13, 'testuser', 'Network Programming and Design', 'CIT254', 3, 1, 1, 2, 1, 2, 11, 25, 36, 'F', 0, 0, '', 1006, '2024-03-29 23:45:50', 1019, '2024-04-01 16:28:11'),
(14, 'testuser', 'Object-oriented Programming Using C', 'CIT234', 3, 1, 1, 2, 1, 2, 17, 43, 60, 'B', 4, 12, 'Excellent', 1006, '2024-03-29 23:45:50', 1019, '2024-04-01 16:22:41'),
(15, 'testuser', 'Technical Report Writing', 'CIT202', 3, 1, 1, 2, 1, 2, 15, 62, 77, 'A', 5, 15, '', 1006, '2024-03-29 23:45:50', 1019, '2024-04-01 16:27:53'),
(16, 'testuser', 'Automata Theory and Computability', 'CSE311', 3, 1, 1, 3, 2, 1, 25, 60, 85, 'A', 5, 15, NULL, 1006, '2024-03-31 10:08:29', 1019, '2024-04-04 00:04:47'),
(17, 'testuser', 'Computer Programming I', 'CSE301', 3, 1, 1, 3, 2, 1, 30, 65, 95, 'A', 5, 15, NULL, 1006, '2024-03-31 10:08:29', 1019, '2024-04-04 00:04:47');

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

--
-- Table structure for table `reply_ticket`
--

CREATE TABLE `reply_ticket` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` bigint(20) DEFAULT NULL,
  `comment` text NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_size` varchar(100) DEFAULT NULL,
  `ticket_id` bigint(20) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL,
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `like2` int(20) NOT NULL DEFAULT 0,
  `dislike2` int(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `results_preview`
--

CREATE TABLE `results_preview` (
  `id` bigint(20) NOT NULL,
  `matno` varchar(20) NOT NULL,
  `ccode` varchar(8) NOT NULL,
  `unit` int(1) NOT NULL,
  `levelid` varchar(3) NOT NULL,
  `semid` varchar(10) NOT NULL,
  `test_score` int(2) DEFAULT NULL,
  `exam_score` int(3) NOT NULL DEFAULT 0,
  `created_by` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `spotlight`
--

CREATE TABLE `spotlight` (
  `id` bigint(20) NOT NULL,
  `subject` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `message` text COLLATE latin1_general_ci NOT NULL,
  `regdate` date NOT NULL,
  `created_by` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `modified_by` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `picture` tinytext COLLATE latin1_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `spotlight`
--

INSERT INTO `spotlight` (`id`, `subject`, `message`, `regdate`, `created_by`, `status`, `modified_by`, `last_modified`, `picture`) VALUES
(1, 'NOTIFICATION', '<p>\r\n\r\n</p><ol><li>Fresh students registration without penalty begins April 3rd and ends April 12th</li><li>Fresh students registration with penalty begins 13th of April and ends 19th of April</li><li>Stalite registration with penalty is extended to April 19th.</li></ol>\r\n\r\n<p></p>', '2024-04-03', '1019', 1, NULL, NULL, NULL);

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

--
-- Table structure for table `temp_upload`
--

CREATE TABLE `temp_upload` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(30) NOT NULL,
  `passport` varchar(255) NOT NULL,
  `app_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `transcript_application`
--

CREATE TABLE `transcript_application` (
  `id` int(11) NOT NULL,
  `transcriptid` varchar(30) NOT NULL,
  `paymentid` int(10) NOT NULL DEFAULT 0,
  `reference` varchar(50) DEFAULT NULL,
  `matid` int(10) NOT NULL,
  `programme` varchar(100) NOT NULL,
  `company` varchar(100) DEFAULT NULL,
  `recipient_email` varchar(30) NOT NULL,
  `contact_person` varchar(30) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `countryid` int(3) NOT NULL,
  `stateid` varchar(100) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `file_name` varchar(255) DEFAULT NULL,
  `file_size` varchar(100) DEFAULT NULL,
  `courier_name` varchar(100) DEFAULT NULL,
  `track_no` varchar(30) DEFAULT NULL,
  `date_applied` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(10) DEFAULT NULL,
  `last_modified` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `users_activities`
--

CREATE TABLE `users_activities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) NOT NULL,
  `action` int(2) NOT NULL DEFAULT 0,
  `module` int(2) NOT NULL DEFAULT 0,
  `description` varchar(100) NOT NULL,
  `activationdate` date NOT NULL,
  `activationtime` time NOT NULL,
  `affected_user_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `users_preview`
--

CREATE TABLE `users_preview` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(250) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `manageid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `default_users`
--
ALTER TABLE `default_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `users_preview`
--
ALTER TABLE `users_preview`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `action`
--
ALTER TABLE `action`
  MODIFY `id` bigint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `courses_preview`
--
ALTER TABLE `courses_preview`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `course_status`
--
ALTER TABLE `course_status`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `default_academic`
--
ALTER TABLE `default_academic`
  MODIFY `id` bigint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `default_bookstore`
--
ALTER TABLE `default_bookstore`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `default_courses`
--
ALTER TABLE `default_courses`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `default_department`
--
ALTER TABLE `default_department`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `default_faculty`
--
ALTER TABLE `default_faculty`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `default_grading`
--
ALTER TABLE `default_grading`
  MODIFY `id` bigint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `default_groups`
--
ALTER TABLE `default_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `default_hostel`
--
ALTER TABLE `default_hostel`
  MODIFY `id` bigint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `default_level`
--
ALTER TABLE `default_level`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `default_matric`
--
ALTER TABLE `default_matric`
  MODIFY `id` bigint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `default_region_countries`
--
ALTER TABLE `default_region_countries`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;

--
-- AUTO_INCREMENT for table `default_region_lga`
--
ALTER TABLE `default_region_lga`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=775;

--
-- AUTO_INCREMENT for table `default_region_states`
--
ALTER TABLE `default_region_states`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `default_semester`
--
ALTER TABLE `default_semester`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `default_support`
--
ALTER TABLE `default_support`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `default_tickets`
--
ALTER TABLE `default_tickets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `default_users`
--
ALTER TABLE `default_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1003;

--
-- AUTO_INCREMENT for table `hostel_applications`
--
ALTER TABLE `hostel_applications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hostel_bed`
--
ALTER TABLE `hostel_bed`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hostel_category`
--
ALTER TABLE `hostel_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hostel_room`
--
ALTER TABLE `hostel_room`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `marital_status`
--
ALTER TABLE `marital_status`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `module`
--
ALTER TABLE `module`
  MODIFY `id` bigint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `news_flash`
--
ALTER TABLE `news_flash`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_history`
--
ALTER TABLE `payment_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_logs`
--
ALTER TABLE `payment_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `record_verification`
--
ALTER TABLE `record_verification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `registered_courses`
--
ALTER TABLE `registered_courses`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `reply_ticket`
--
ALTER TABLE `reply_ticket`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `results_preview`
--
ALTER TABLE `results_preview`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `spotlight`
--
ALTER TABLE `spotlight`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `temp_upload`
--
ALTER TABLE `temp_upload`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transcript_application`
--
ALTER TABLE `transcript_application`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_activities`
--
ALTER TABLE `users_activities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_preview`
--
ALTER TABLE `users_preview`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Batal

⬅ Naik ke sms.coeminna.edu.ng 2 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘dbc.php	php	8.4 KB	2024-07-31 12:16	✏️ Edit 👁️ View
🗃️smsminna.sql	sql	70.2 KB	2024-07-31 12:16	✏️ Edit 👁️ View