-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 02, 2021 at 03:41 PM
-- Server version: 5.5.20
-- PHP Version: 5.3.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `dachtech`
--

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

--
-- Table structure for table `admin_block_open_all_report_card_tbl`
--

CREATE TABLE IF NOT EXISTS `admin_block_open_all_report_card_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `statements` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin_block_open_all_report_card_tbl`
--

INSERT INTO `admin_block_open_all_report_card_tbl` (`id`, `statements`) VALUES
(1, 'Open');

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

--
-- Table structure for table `admin_block_open_graduate_return_tbl`
--

CREATE TABLE IF NOT EXISTS `admin_block_open_graduate_return_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `statements` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin_block_open_graduate_return_tbl`
--

INSERT INTO `admin_block_open_graduate_return_tbl` (`id`, `statements`) VALUES
(1, 'Open');

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

--
-- Table structure for table `admin_block_open_semester_scores_entering_tbl`
--

CREATE TABLE IF NOT EXISTS `admin_block_open_semester_scores_entering_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `statements` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin_block_open_semester_scores_entering_tbl`
--

INSERT INTO `admin_block_open_semester_scores_entering_tbl` (`id`, `statements`) VALUES
(1, 'Open');

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

--
-- Table structure for table `admin_block_open_ss3_deleted_reserved_tbl`
--

CREATE TABLE IF NOT EXISTS `admin_block_open_ss3_deleted_reserved_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `statements` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin_block_open_ss3_deleted_reserved_tbl`
--

INSERT INTO `admin_block_open_ss3_deleted_reserved_tbl` (`id`, `statements`) VALUES
(1, 'Open');

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

--
-- Table structure for table `admin_blok_prv_promotd_term_tbl`
--

CREATE TABLE IF NOT EXISTS `admin_blok_prv_promotd_term_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `statements` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin_blok_prv_promotd_term_tbl`
--

INSERT INTO `admin_blok_prv_promotd_term_tbl` (`id`, `statements`) VALUES
(1, 'Open');

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

--
-- Table structure for table `app_matric_year_tbl`
--

CREATE TABLE IF NOT EXISTS `app_matric_year_tbl` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `app_matric_year` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `captured_olevel_tbl`
--

CREATE TABLE IF NOT EXISTS `captured_olevel_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `email` varchar(80) NOT NULL,
  `sub_name` varchar(80) NOT NULL,
  `exam_body` varchar(20) NOT NULL,
  `yearss` varchar(100) NOT NULL,
  `grade` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `captured_olevel_tbl`
--

INSERT INTO `captured_olevel_tbl` (`id`, `email`, `sub_name`, `exam_body`, `yearss`, `grade`) VALUES
(1, 'joy@yahoo.com', 'ENGLISH LANGUAGE', 'NECO', '2006', 'A1'),
(2, 'joy@yahoo.com', 'MATHEMATICS', 'NECO', '2006', 'B2'),
(3, 'joy@yahoo.com', '', 'NECO', '2006', ''),
(4, 'joy@yahoo.com', '', 'NECO', '2006', ''),
(5, 'joy@yahoo.com', '', 'NECO', '2006', ''),
(6, 'joy@yahoo.com', '', 'NECO', '2006', ''),
(7, 'joy@yahoo.com', '', 'NECO', '2006', ''),
(8, 'joy@yahoo.com', '', 'NECO', '2006', ''),
(9, 'joy@yahoo.com', '', 'NECO', '2006', ''),
(10, 'kay@yahoo.com', '', '', '', ''),
(11, 'kay@yahoo.com', '', '', '', ''),
(12, 'kay@yahoo.com', '', '', '', ''),
(13, 'kay@yahoo.com', '', '', '', ''),
(14, 'kay@yahoo.com', '', '', '', ''),
(15, 'kay@yahoo.com', '', '', '', ''),
(16, 'kay@yahoo.com', '', '', '', ''),
(17, 'kay@yahoo.com', '', '', '', ''),
(18, 'kay@yahoo.com', '', '', '', '');

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

--
-- Table structure for table `captured_ond_tbl`
--

CREATE TABLE IF NOT EXISTS `captured_ond_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `institution` varchar(200) NOT NULL,
  `course` varchar(500) NOT NULL,
  `grade` varchar(40) NOT NULL,
  `yearss` varchar(40) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `captured_ond_tbl`
--

INSERT INTO `captured_ond_tbl` (`id`, `institution`, `course`, `grade`, `yearss`, `email`) VALUES
(1, 'FEDERAL POLYTECHNIC OFFA', 'COMPUTER SCIRENCE', 'Distinction', '2010', 'kay@yahoo.com');

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

--
-- Table structure for table `courseenrolls_tbl`
--

CREATE TABLE IF NOT EXISTS `courseenrolls_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `matricno` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  `session` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `department` int(100) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `inner_semester` varchar(100) NOT NULL,
  `programme_year` int(100) NOT NULL,
  `course` int(100) NOT NULL,
  `courseUnit` int(11) NOT NULL,
  `enrollDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ca1` varchar(100) NOT NULL,
  `ca2` varchar(100) NOT NULL,
  `exam` varchar(100) NOT NULL,
  `total` decimal(6,1) NOT NULL,
  `max_course` varchar(100) NOT NULL,
  `min_course` varchar(100) NOT NULL,
  `avg_course` varchar(100) NOT NULL,
  `grade` varchar(100) NOT NULL,
  `cp` decimal(6,1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `courseenrolls_tbl`
--

INSERT INTO `courseenrolls_tbl` (`id`, `matricno`, `email`, `session`, `level`, `department`, `semester`, `inner_semester`, `programme_year`, `course`, `courseUnit`, `enrollDate`, `ca1`, `ca2`, `exam`, `total`, `max_course`, `min_course`, `avg_course`, `grade`, `cp`) VALUES
(2, 'CH/HND/2021/113', 'kay@yahoo.com', '2021/2022', 'HND1', 1, 'First', '1st', 2021, 47, 2, '2021-06-23 20:42:48', '', '', '', '0.0', '', '', '', '', '0.0');

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

--
-- Table structure for table `course_registration_increment_serials`
--

CREATE TABLE IF NOT EXISTS `course_registration_increment_serials` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `lengths` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `course_registration_increment_serials`
--

INSERT INTO `course_registration_increment_serials` (`id`, `lengths`) VALUES
(1, 2021206);

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

--
-- Table structure for table `course_tbl`
--

CREATE TABLE IF NOT EXISTS `course_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_id` int(11) NOT NULL,
  `level_id` varchar(100) NOT NULL,
  `semester_id` int(11) NOT NULL,
  `courseCode` varchar(255) NOT NULL,
  `courseName` varchar(255) NOT NULL,
  `courseUnit` varchar(255) NOT NULL,
  `creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;

--
-- Dumping data for table `course_tbl`
--

INSERT INTO `course_tbl` (`id`, `dept_id`, `level_id`, `semester_id`, `courseCode`, `courseName`, `courseUnit`, `creationDate`) VALUES
(1, 1, 'ND1', 1, 'BCH 111', 'General and Physical Chemistry', '3', '2021-06-05 17:56:00'),
(2, 1, 'ND1', 1, 'FST 122', 'General Microbiology', '3', '2021-06-05 17:56:00'),
(3, 1, 'ND1', 1, 'FST 125', 'Nutrition', '2', '2021-06-05 17:56:00'),
(4, 1, 'ND1', 1, 'GNP 111', 'Anatomy and Physiology 1', '3', '2021-06-05 17:56:00'),
(5, 1, 'ND1', 1, 'FOT 111', 'Geography of Nigeria', '1', '2021-06-05 17:56:00'),
(6, 1, 'ND1', 1, 'DTH 111', 'Oral Hygiene', '2', '2021-06-05 17:56:00'),
(7, 1, 'ND1', 1, 'EHT 111', 'Introduction to Environmental Health', '2', '2021-06-05 17:56:00'),
(8, 1, 'ND1', 1, 'CHO 111', 'Primary Health Care Management 1', '1', '2021-06-05 17:56:00'),
(9, 1, 'ND1', 1, 'CHO 112', 'Introductory Epidemiology', '1', '2021-06-05 17:56:00'),
(10, 1, 'ND1', 1, 'GNS 101', 'Use of English', '3', '2021-06-05 17:56:00'),
(11, 1, 'ND1', 1, 'GNS 120', 'Citizenship Education', '2', '2021-06-05 17:56:00'),
(12, 1, 'ND1', 2, 'STA 111', 'Introduction to Statistics', '1', '2021-06-05 17:56:00'),
(13, 1, 'ND1', 2, 'STB 211', 'Introduction to Microbiology', '3', '2021-06-05 17:56:00'),
(14, 1, 'ND1', 2, 'COM 111', 'Introduction to Computer', '2', '2021-06-05 17:56:00'),
(15, 1, 'ND1', 2, 'GNP 121', 'Anatomy and Physiology 11', '2', '2021-06-05 17:56:00'),
(16, 1, 'ND1', 2, 'EHT 223', 'Occupational Health and Safety', '2', '2021-06-05 17:56:00'),
(17, 1, 'ND1', 2, 'GNP 123', 'Introduction to Pharmacology', '1', '2021-06-05 17:56:00'),
(18, 1, 'ND1', 2, 'GNP 216', 'Mental Health', '2', '2021-06-05 17:56:00'),
(19, 1, 'ND1', 2, 'CHO 121', 'Basic Clinical Skills', '4', '2021-06-05 17:56:00'),
(20, 1, 'ND1', 2, 'GNS 102', 'Communication in English 1', '2', '2021-06-05 17:56:00'),
(21, 1, 'ND1', 2, 'GNS 121', 'Introduction to Sociology', '1', '2021-06-05 17:56:00'),
(22, 1, 'ND2', 1, 'HRE 111', 'Introduction to Home and Rural Economics', '2', '2021-06-05 17:56:00'),
(23, 1, 'ND2', 1, 'GNP 214', 'Introduction to Microbiology', '1', '2021-06-05 17:56:00'),
(24, 1, 'ND2', 1, 'EHT 211', 'Introduction to Health Education', '2', '2021-06-05 17:56:00'),
(25, 1, 'ND2', 1, 'CHO 211', 'Primary Health Care Management  (Community Diagnosis & Mobilization) 11', '3', '2021-06-05 17:56:00'),
(26, 1, 'ND2', 1, 'CHO 212', 'Standing Orders', '2', '2021-06-05 17:56:00'),
(27, 1, 'ND2', 1, 'CHO 213', 'Maternal Health and Family Planning', '2', '2021-06-05 17:56:00'),
(28, 1, 'ND2', 1, 'CHO 214', 'Child Health', '2', '2021-06-05 17:56:00'),
(29, 1, 'ND2', 1, 'CHO 215', 'Communicable Diseases 1 (Water related airborne diseases)', '2', '2021-06-05 17:56:00'),
(30, 1, 'ND2', 1, 'GNS 122', 'Sociology of the Family', '3', '2021-06-05 17:56:00'),
(31, 1, 'ND2', 1, 'GNS 201', 'Use of English 11', '3', '2021-06-05 17:56:00'),
(32, 1, 'ND2', 2, 'BUS 211', 'Entrepreneurship/Small Business Management', '2', '2021-06-05 17:56:00'),
(33, 1, 'ND2', 2, 'CHO 221', 'Primary Health Care Management 111', '2', '2021-06-05 17:56:00'),
(34, 1, 'ND2', 2, 'CHO 222', 'Communicable Diseases 11', '2', '2021-06-05 17:56:00'),
(35, 1, 'ND2', 2, 'CHO 223', 'Non Communicable diseases', '2', '2021-06-05 17:56:00'),
(36, 1, 'ND2', 2, 'CHO 224', 'Ethics in Community Health Practice', '1', '2021-06-05 17:56:00'),
(37, 1, 'ND2', 2, 'CHO 225', 'Term Paper/ Project', '6', '2021-06-05 17:56:00'),
(38, 1, 'ND2', 2, 'GNS 202', 'Communication in English 11', '2', '2021-06-05 17:56:00'),
(39, 1, 'ND2', 2, 'GNS 123', 'Introduction to Medical Sociology', '3', '2021-06-05 17:56:00'),
(40, 1, 'HND1', 1, 'STB 322', 'Environmental Microbiology', '3', '2021-06-05 17:56:00'),
(41, 1, 'HND1', 1, 'STB 316', 'Parasitology', '3', '2021-06-05 17:56:00'),
(42, 1, 'HND1', 1, 'COM 311', 'Computer Programming', '3', '2021-06-05 17:56:00'),
(43, 1, 'HND1', 1, 'GLT 111', 'General Laboratory Techniques', '3', '2021-06-05 17:56:00'),
(44, 1, 'HND1', 1, 'EHT 323', 'Primary Health Care', '2', '2021-06-05 17:56:00'),
(45, 1, 'HND1', 1, 'NUD 311', 'Human Nutrition 1', '3', '2021-06-05 17:56:00'),
(46, 1, 'HND1', 1, 'PHN 313', 'Drug supply, Administration and control', '1', '2021-06-05 17:56:00'),
(47, 1, 'HND1', 1, 'CHO 311', 'Primary Health Care Management IV', '2', '2021-06-05 17:56:00'),
(48, 1, 'HND1', 1, 'GNS 302', 'Communication in English 111', '3', '2021-06-05 17:56:00'),
(49, 1, 'HND1', 2, 'NUD 312', 'Nutrition 11', '3', '2021-06-05 17:56:00'),
(50, 1, 'HND1', 2, 'PHN 412', 'Care of the Adolescent, Aged and Handicapped', '3', '2021-06-05 17:56:00'),
(51, 1, 'HND1', 2, 'PHN 414', 'Family Planning', '6', '2021-06-05 17:56:00'),
(52, 1, 'HND1', 2, 'NUD 435', 'Research Methodology', '1', '2021-06-05 17:56:00'),
(53, 1, 'HND1', 2, 'CHO 321', 'Community Involvement in Health Care', '1', '2021-06-05 17:56:00'),
(54, 1, 'HND1', 2, 'CHO 322', 'Clinical Skills 1', '4', '2021-06-05 17:56:00'),
(55, 1, 'HND1', 2, 'GNS 123', 'Introduction to Medical Sociology', '3', '2021-06-05 17:56:00'),
(56, 1, 'HND2', 1, 'STA 416', 'Medical  Statistics', '4', '2021-06-05 17:56:00'),
(57, 1, 'HND2', 1, 'PHN 322', 'Community  Mental Health', '4', '2021-06-05 17:56:00'),
(58, 1, 'HND2', 1, 'PHN 324', 'Outreach services and Referral Practice', '2', '2021-06-05 17:56:00'),
(59, 1, 'HND2', 1, 'PHN 421', 'Maternal and Child Health 11', '4', '2021-06-05 17:56:00'),
(60, 1, 'HND2', 1, 'PHN 422', 'School Health Programme', '1', '2021-06-05 17:56:00'),
(61, 1, 'HND2', 1, 'EHT 421', 'Health & Safety 11', '4', '2021-06-05 17:56:00'),
(62, 1, 'HND2', 1, 'CHO 411', 'Clinical Skills 11', '2', '2021-06-05 17:56:00'),
(63, 1, 'HND2', 1, 'CHO 412', 'Primary Eye Care', '3', '2021-06-05 17:56:00'),
(64, 1, 'HND2', 1, 'GNS 323', 'Introduction to Psychology', '3', '2021-06-05 17:56:00'),
(65, 1, 'HND2', 2, 'DTH 313', 'Primary Oral Health Care', '2', '2021-06-05 17:56:00'),
(66, 1, 'HND2', 2, 'ETH 324', 'Public Health Economics', '1', '2021-06-05 17:56:00'),
(67, 1, 'HND2', 2, 'PHN 323', 'Accident Emergency and Minor Surgeries', '2', '2021-06-05 17:56:00'),
(68, 1, 'HND2', 2, 'EHT 414', 'Public Health Laws', '1', '2021-06-05 17:56:00'),
(69, 1, 'HND2', 2, 'PHN 415', 'Health Education', '3', '2021-06-05 17:56:00'),
(70, 1, 'HND2', 2, 'CHO 421', 'Clinical Skills 11 (Use of Standing Order)', '3', '2021-06-05 17:56:00'),
(71, 1, 'HND2', 2, 'CHO 423', 'Projects', '6', '2021-06-05 17:56:00'),
(72, 1, 'HND2', 2, 'GNS 323', 'Internship', '3', '2021-06-05 17:56:00');

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

--
-- Table structure for table `current_app_year_tbl`
--

CREATE TABLE IF NOT EXISTS `current_app_year_tbl` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `app_year` varchar(100) NOT NULL,
  `app_session` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `current_app_year_tbl`
--

INSERT INTO `current_app_year_tbl` (`id`, `app_year`, `app_session`) VALUES
(1, '2021', '2021/2022');

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

--
-- Table structure for table `current_session_tbl`
--

CREATE TABLE IF NOT EXISTS `current_session_tbl` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `session` varchar(100) NOT NULL,
  `semester` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `current_session_tbl`
--

INSERT INTO `current_session_tbl` (`id`, `session`, `semester`) VALUES
(1, '2021/2022', 'Second');

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

--
-- Table structure for table `declare_result_tbl`
--

CREATE TABLE IF NOT EXISTS `declare_result_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `session` varchar(1000) NOT NULL,
  `term` varchar(1000) NOT NULL,
  `status` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `declare_result_tbl`
--

INSERT INTO `declare_result_tbl` (`id`, `session`, `term`, `status`) VALUES
(8, '2020/2021', 'First', '1'),
(7, '2020/2021', 'Second', '1'),
(6, '2020/2021', 'Third', '1'),
(9, '2021/2022', 'First', '1'),
(10, '2021/2022', 'Second', '1');

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

--
-- Table structure for table `department_tbl`
--

CREATE TABLE IF NOT EXISTS `department_tbl` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `department` varchar(100) NOT NULL,
  `dept_code` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `department_tbl`
--

INSERT INTO `department_tbl` (`id`, `department`, `dept_code`) VALUES
(1, 'Community Health', 'CH'),
(2, 'Health Technician', 'HT'),
(3, 'Health Assistant', 'HA'),
(4, 'Pharmacy Technology', 'PH'),
(5, 'Health Information Management', 'HIM'),
(6, 'Nutrition And Dietics', 'NAD'),
(7, 'Environmental Health Technician', 'EHT'),
(8, 'Environmental Health Assistant', 'EHA'),
(9, 'Health Education And Promotion', 'HEAP'),
(10, 'Dental Health', 'DH'),
(11, 'X-ray Technician', 'XRT'),
(12, 'Biomedical Engineering', 'BE'),
(13, 'Orthopaedic Cast Technology', 'OCT');

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

--
-- Table structure for table `fees_tbl`
--

CREATE TABLE IF NOT EXISTS `fees_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `session` varchar(80) NOT NULL,
  `term` varchar(20) NOT NULL,
  `class_name` varchar(100) NOT NULL,
  `b_fees` varchar(20) NOT NULL,
  `all_fees` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `fresher_enrol_tbl`
--

CREATE TABLE IF NOT EXISTS `fresher_enrol_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `regno` varchar(100) NOT NULL,
  `matric_no` varchar(100) NOT NULL,
  `user_type` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `session` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `programme_year` int(100) NOT NULL,
  `department` int(100) NOT NULL,
  `serial` varchar(100) NOT NULL,
  `pin` varchar(50) NOT NULL,
  `datess` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `fresher_enrol_tbl`
--

INSERT INTO `fresher_enrol_tbl` (`id`, `regno`, `matric_no`, `user_type`, `email`, `session`, `level`, `programme_year`, `department`, `serial`, `pin`, `datess`, `status`) VALUES
(1, 'APP/ND/2021/2249', 'CH/ND/2021/112', 'student', 'joy@yahoo.com', '2021/2022', 'ND1', 2021, 1, '2001', '2223', '', 'granted'),
(2, 'APP/HND/2021/2250', 'CH/HND/2021/113', 'student', 'kay@yahoo.com', '2021/2022', 'HND1', 2021, 1, '2002', '2224', '', 'granted');

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

--
-- Table structure for table `graduated_students_tbl`
--

CREATE TABLE IF NOT EXISTS `graduated_students_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `regno` varchar(100) NOT NULL,
  `matric_no` varchar(100) NOT NULL,
  `user_type` varchar(100) NOT NULL,
  `namess` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `gender` char(10) NOT NULL,
  `programme_year` int(100) NOT NULL,
  `department` int(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `session` varchar(100) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `dob` date NOT NULL,
  `pob` varchar(100) NOT NULL,
  `nation` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `lga` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `parentname` varchar(50) NOT NULL,
  `parent_address` varchar(1000) NOT NULL,
  `parent_phone` varchar(100) NOT NULL,
  `email` varchar(70) NOT NULL,
  `occupation` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `next_of_kin_name` varchar(200) NOT NULL,
  `next_of_kin_phone` varchar(20) NOT NULL,
  `next_of_kin_address` varchar(1000) NOT NULL,
  `next_of_kin_relationship` varchar(100) NOT NULL,
  `file` varchar(100) NOT NULL,
  `status` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `graduated_students_tbl`
--

INSERT INTO `graduated_students_tbl` (`id`, `regno`, `matric_no`, `user_type`, `namess`, `password`, `gender`, `programme_year`, `department`, `level`, `session`, `semester`, `dob`, `pob`, `nation`, `state`, `lga`, `address`, `parentname`, `parent_address`, `parent_phone`, `email`, `occupation`, `phone`, `next_of_kin_name`, `next_of_kin_phone`, `next_of_kin_address`, `next_of_kin_relationship`, `file`, `status`) VALUES
(9, 'APP/ND/2021/2228', 'DH/ND/2021/105', 'student', 'FOGBOJAYE JOHNSON', 'fon', 'Male', 2021, 10, '', '2021/2022', 'First', '0000-00-00', 'KAD', 'Nigeria', 'Kano State', 'KANGURU', 'ONILEDE COM', 'MR ASADE WEDEKO', 'AS ABOVE', '08089898989', 'fon@yahoo.com', 'COMM.', '08087878787', 'MR JJ TYUO', '080898987', 'AS ABOVE', 'student', 'Adewumi Esther Boluwatife.jpg', 1);

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

--
-- Table structure for table `increments`
--

CREATE TABLE IF NOT EXISTS `increments` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `lengths` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `increments`
--

INSERT INTO `increments` (`id`, `lengths`) VALUES
(1, 2250);

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

--
-- Table structure for table `increments_matricno`
--

CREATE TABLE IF NOT EXISTS `increments_matricno` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `dept_code` varchar(100) NOT NULL,
  `lengths` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `increments_matricno`
--

INSERT INTO `increments_matricno` (`id`, `dept_code`, `lengths`) VALUES
(1, 'CH', 113),
(2, 'HT', 102),
(3, 'HA', 101),
(4, 'PH', 104),
(5, 'HIM', 101),
(6, 'NAD', 105),
(7, 'EHT', 101),
(8, 'EHA', 102),
(9, 'HEAP', 106),
(10, 'DH', 106),
(11, 'XRT', 118),
(12, 'BE', 104),
(13, 'OCT', 101),
(14, 'HE', 101),
(15, 'HE', 101),
(16, 'HE', 101),
(17, 'HE', 101),
(18, 'HE', 101),
(19, 'HE', 101),
(20, 'HE', 101),
(21, 'HE', 101),
(22, 'DE', 101),
(23, 'BC', 101),
(24, 'GA', 101),
(25, 'IC', 101);

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

--
-- Table structure for table `increment_serials`
--

CREATE TABLE IF NOT EXISTS `increment_serials` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `lengths` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `increment_serials`
--

INSERT INTO `increment_serials` (`id`, `lengths`) VALUES
(1, 20191121);

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

--
-- Table structure for table `level_tbl`
--

CREATE TABLE IF NOT EXISTS `level_tbl` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `nd` varchar(100) NOT NULL,
  `hnd` varchar(100) NOT NULL,
  `pc` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `level_tbl`
--

INSERT INTO `level_tbl` (`id`, `nd`, `hnd`, `pc`) VALUES
(1, 'ND1', 'HND1', 'PC1'),
(2, 'ND2', 'HND2', 'PC2');

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

--
-- Table structure for table `past_courseenrolls_tbl`
--

CREATE TABLE IF NOT EXISTS `past_courseenrolls_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `matricno` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  `session` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `department` int(100) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `inner_semester` varchar(100) NOT NULL,
  `programme_year` int(100) NOT NULL,
  `course` int(100) NOT NULL,
  `courseUnit` int(11) NOT NULL,
  `enrollDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ca1` varchar(100) NOT NULL,
  `ca2` varchar(100) NOT NULL,
  `exam` varchar(100) NOT NULL,
  `total` decimal(6,1) NOT NULL,
  `max_course` varchar(100) NOT NULL,
  `min_course` varchar(100) NOT NULL,
  `avg_course` varchar(100) NOT NULL,
  `grade` varchar(100) NOT NULL,
  `cp` decimal(6,1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `payment_tbl`
--

CREATE TABLE IF NOT EXISTS `payment_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `email` varchar(80) NOT NULL,
  `session` varchar(40) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `department` int(100) NOT NULL,
  `bank` varchar(20) NOT NULL,
  `amount_paid` varchar(100) NOT NULL,
  `depositor_name` varchar(100) NOT NULL,
  `teller_number` varchar(40) NOT NULL,
  `datess` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` varchar(40) NOT NULL,
  `file` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `payment_tbl`
--

INSERT INTO `payment_tbl` (`id`, `email`, `session`, `semester`, `level`, `department`, `bank`, `amount_paid`, `depositor_name`, `teller_number`, `datess`, `status`, `file`) VALUES
(1, 'kay@yahoo.com', '2021/2022', 'Second', 'HND1', 1, 'Citibank Nigeria Plc', '50000', 'ASABI KEMI ', '345678', '2021-06-22 19:58:28', 'active', '');

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

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

CREATE TABLE IF NOT EXISTS `pins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `serial` varchar(45) NOT NULL,
  `pin` varchar(45) NOT NULL,
  `status` varchar(45) NOT NULL,
  `email` varchar(45) NOT NULL,
  `matric_no` varchar(100) NOT NULL,
  `department` int(11) NOT NULL,
  `level` varchar(100) NOT NULL,
  `session` varchar(100) NOT NULL,
  `programme_year` varchar(50) NOT NULL,
  `datess` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `pins`
--

INSERT INTO `pins` (`id`, `serial`, `pin`, `status`, `email`, `matric_no`, `department`, `level`, `session`, `programme_year`, `datess`) VALUES
(1, '2001', '2223', 'active', 'joy@yahoo.com', 'er44', 17, 'DN1', '2021/2022', '2021', '0000-00-00 00:00:00'),
(2, '2002', '2224', 'active', 'kay@yahoo.com', '', 0, '', '', '2021', '0000-00-00 00:00:00'),
(3, '2005', '2225', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(4, '2006', '2226', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(5, '2007', '2227', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(6, '2008', '2228', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(7, '2009', '2229', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(8, '3003', '3333', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(9, '3004', '3334', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(10, '4444', '44444', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(11, '5555', '55555', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(12, '6666', '66666', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(13, '7777', '77777', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(14, '8888', '88888', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(15, '9999', '99999', '', '', '', 0, '', '', '', '0000-00-00 00:00:00'),
(16, '20191117', '37463078003784', '', '', '', 0, '', '', '', '2021-06-24 10:54:12'),
(17, '20191118', '33656316166320', '', '', '', 0, '', '', '', '2021-06-24 10:54:12'),
(18, '20191119', '36133723076416', '', '', '', 0, '', '', '', '2021-06-24 10:54:12'),
(19, '20191120', '45950011230163', '', '', '', 0, '', '', '', '2021-06-24 10:54:12'),
(20, '20191121', '83847351717407', '', '', '', 0, '', '', '', '2021-06-24 10:54:12');

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

--
-- Table structure for table `pins_course_registration_tbl`
--

CREATE TABLE IF NOT EXISTS `pins_course_registration_tbl` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `serial` varchar(45) NOT NULL,
  `pin` varchar(45) NOT NULL,
  `status` varchar(45) NOT NULL,
  `level` varchar(100) NOT NULL,
  `email` varchar(45) NOT NULL,
  `matric_no` varchar(45) NOT NULL,
  `semester` varchar(45) NOT NULL,
  `session` varchar(45) NOT NULL,
  `programme_year` varchar(50) NOT NULL,
  `datess` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `pins_course_registration_tbl`
--

INSERT INTO `pins_course_registration_tbl` (`id`, `serial`, `pin`, `status`, `level`, `email`, `matric_no`, `semester`, `session`, `programme_year`, `datess`) VALUES
(1, '2021198', '329971573126', 'active', 'HND1', 'kay@yahoo.com', 'CH/HND/2021/113', 'Second', '2021/2022', '2021', '0000-00-00 00:00:00'),
(2, '2021199', '794198464526', '', '', '', '', '', '', '', '2021-06-24 10:52:18'),
(3, '2021200', '234939620916', '', '', '', '', '', '', '', '2021-06-24 10:52:18'),
(4, '2021201', '884616476281', '', '', '', '', '', '', '', '2021-06-24 10:52:19'),
(5, '2021202', '447525898980', '', '', '', '', '', '', '', '2021-06-24 10:52:19'),
(6, '2021203', '635006268859', '', '', '', '', '', '', '', '2021-06-24 10:53:13'),
(7, '2021204', '338540719683', '', '', '', '', '', '', '', '2021-06-24 10:53:13'),
(8, '2021205', '231478440576', '', '', '', '', '', '', '', '2021-06-24 10:53:13'),
(9, '2021206', '886868693646', '', '', '', '', '', '', '', '2021-06-24 10:53:13');

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

--
-- Table structure for table `school_info_tbl`
--

CREATE TABLE IF NOT EXISTS `school_info_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `school_info` varchar(80) NOT NULL,
  `abbreviation` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `school_info_tbl`
--

INSERT INTO `school_info_tbl` (`id`, `school_info`, `abbreviation`) VALUES
(4, 'Davest College of Health Technology, Ekan, Kwara State, Nigeria', 'DCHT');

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

--
-- Table structure for table `scores_scalling`
--

CREATE TABLE IF NOT EXISTS `scores_scalling` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `ca1` varchar(100) NOT NULL,
  `ca2` varchar(100) NOT NULL,
  `exam` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `scores_scalling`
--

INSERT INTO `scores_scalling` (`id`, `ca1`, `ca2`, `exam`, `level`) VALUES
(1, '15', '15', '70', 'ND1'),
(2, '15', '15', '70', 'ND2'),
(3, '15', '15', '70', 'HN1'),
(4, '15', '15', '70', 'HN2'),
(5, '15', '15', '70', 'PC1'),
(6, '15', '15', '70', 'PC2');

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

--
-- Table structure for table `semester_tbl`
--

CREATE TABLE IF NOT EXISTS `semester_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `semester` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `semester_tbl`
--

INSERT INTO `semester_tbl` (`id`, `semester`) VALUES
(1, 'First'),
(2, 'Second');

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

--
-- Table structure for table `session_tbl`
--

CREATE TABLE IF NOT EXISTS `session_tbl` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `session` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `session_tbl`
--

INSERT INTO `session_tbl` (`id`, `session`) VALUES
(1, '2018/2019'),
(2, '2019/2020'),
(3, '2020/2021'),
(4, '2021/2022'),
(5, '2022/2023');

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

--
-- Table structure for table `signature_tbl`
--

CREATE TABLE IF NOT EXISTS `signature_tbl` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `session` char(30) NOT NULL,
  `term` char(30) NOT NULL,
  `file` char(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `signature_tbl`
--

INSERT INTO `signature_tbl` (`id`, `session`, `term`, `file`) VALUES
(2, '2020/2021', 'First', 'signature.jpg');

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

--
-- Table structure for table `ss3_deleted_reserved_tbl`
--

CREATE TABLE IF NOT EXISTS `ss3_deleted_reserved_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `regno` varchar(100) NOT NULL,
  `matric_no` varchar(100) NOT NULL,
  `user_type` varchar(100) NOT NULL,
  `namess` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `gender` char(10) NOT NULL,
  `programme_year` int(100) NOT NULL,
  `department` int(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `session` varchar(100) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `dob` date NOT NULL,
  `pob` varchar(100) NOT NULL,
  `nation` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `lga` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `parentname` varchar(50) NOT NULL,
  `parent_address` varchar(1000) NOT NULL,
  `parent_phone` varchar(100) NOT NULL,
  `email` varchar(70) NOT NULL,
  `occupation` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `next_of_kin_name` varchar(200) NOT NULL,
  `next_of_kin_phone` varchar(20) NOT NULL,
  `next_of_kin_address` varchar(1000) NOT NULL,
  `next_of_kin_relationship` varchar(100) NOT NULL,
  `file` varchar(100) NOT NULL,
  `status` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `ss3_deleted_reserved_tbl`
--

INSERT INTO `ss3_deleted_reserved_tbl` (`id`, `regno`, `matric_no`, `user_type`, `namess`, `password`, `gender`, `programme_year`, `department`, `level`, `session`, `semester`, `dob`, `pob`, `nation`, `state`, `lga`, `address`, `parentname`, `parent_address`, `parent_phone`, `email`, `occupation`, `phone`, `next_of_kin_name`, `next_of_kin_phone`, `next_of_kin_address`, `next_of_kin_relationship`, `file`, `status`) VALUES
(1, '', '', 'student', 'OLATOYE TOYIN', 'toyin', 'Male', 0, 0, '', '2021/2022', 'First', '0000-00-00', '', '', '', '', '', '', '', '', 'toyin@yahoo.com', '', '', '', '', '', '', '', 1),
(3, 'APP/ND/2021/2232', '', 'student', 'SEMILORE SEUN', 'davtech', 'Male', 2021, 9, '', '2021/2022', 'First', '2021-06-03', 'OMU-ARAN', 'Nigeria', 'Ekiti', 'OSHIMILI NORTH', 'BEHIND OLUSEYI SAWMAIL', 'MR AND MRS SALMAN', 'PAR ADDR', '0909999', 'job55toyin@gmail.com', 'DRIVING, TRADING', '07060513319', 'NNNAME', 'NNNPHONE', 'NNNADDRESS', 'NNN RELA', 'Akolawole moyinoluwa.jpg', 1);

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

--
-- Table structure for table `stu_tbl`
--

CREATE TABLE IF NOT EXISTS `stu_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `regno` varchar(100) NOT NULL,
  `matric_no` varchar(100) NOT NULL,
  `user_type` varchar(100) NOT NULL,
  `namess` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `gender` char(10) NOT NULL,
  `programme_year` int(100) NOT NULL,
  `department` int(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `session` varchar(100) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `dob` date NOT NULL,
  `pob` varchar(100) NOT NULL,
  `nation` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `lga` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `parentname` varchar(50) NOT NULL,
  `parent_address` varchar(1000) NOT NULL,
  `parent_phone` varchar(100) NOT NULL,
  `email` varchar(70) NOT NULL,
  `occupation` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `next_of_kin_name` varchar(200) NOT NULL,
  `next_of_kin_phone` varchar(20) NOT NULL,
  `next_of_kin_address` varchar(1000) NOT NULL,
  `next_of_kin_relationship` varchar(100) NOT NULL,
  `file` varchar(100) NOT NULL,
  `status` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

--
-- Dumping data for table `stu_tbl`
--

INSERT INTO `stu_tbl` (`id`, `regno`, `matric_no`, `user_type`, `namess`, `password`, `gender`, `programme_year`, `department`, `level`, `session`, `semester`, `dob`, `pob`, `nation`, `state`, `lga`, `address`, `parentname`, `parent_address`, `parent_phone`, `email`, `occupation`, `phone`, `next_of_kin_name`, `next_of_kin_phone`, `next_of_kin_address`, `next_of_kin_relationship`, `file`, `status`) VALUES
(41, 'APP/ND/2021/2249', 'CH/ND/2021/112', 'student', 'ADELEKE REJOICE JOY', 'joy', 'Female', 2021, 1, 'ND1', '2021/2022', 'Second', '2021-06-08', 'ONDO', 'Nigeria', 'Kogi', 'Yagba West', 'Beside Formal Olomu Residence, omu-=aran', 'Mrs Adeleke kemi', 'As above 2  ', '080989898', 'joy@yahoo.com', 'TEACHING', '08060219388', 'mr adeleke femi', '08098', 'As above ', 'Brother', 'bamisaye.jpg', 1),
(42, 'APP/HND/2021/2250', 'CH/HND/2021/113', 'student', 'EMMANUEL KAYODE', 'kay', 'Male', 2021, 1, 'HND1', '2021/2022', 'Second', '2021-06-23', 'OMU-ARAN', 'Nigeria', 'Kwara', 'IREPODUN', ' OMONIYEPE HOTEL OMU-ARAN', 'mR AND MRS ALADE KAYODE', 'OMONIYEPE TREET  ', '0908989899', 'kay@yahoo.com', 'INSTRUCTOR', '08060219388', 'MR KAY ASDE', '08078787878', 'OMONIYEPE HOUSE ', 'BROTHER', 'Adeniyi.jpg', 1),
(35, 'obi', '', 'user', 'OBI PRINCIPAL', 'obi', '', 0, 0, '', '2021/2022', 'Second', '0000-00-00', '', '', '', '', '', '', '', '', 'obi4real@yahoo.com', '', '', '', '', '', '', '', 1),
(15, '', '', 'admin', 'JOB TOYIN', 'job', '', 0, 0, '', '2021/2022', 'Second', '0000-00-00', '', '', '', '', '', '', '', '', 'job@yahoo.com', '', '', '', '', '', '', '', 1),
(18, '', '', 'developer', 'JOB TOYIN', 'jobs', '', 0, 0, '', '2021/2022', 'Second', '0000-00-00', '', '', '', '', '', '', '', '', 'jobs@yahoo.com', '', '', '', '', '', '', '', 1);

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

--
-- Table structure for table `submitted_fresh_application_tbl`
--

CREATE TABLE IF NOT EXISTS `submitted_fresh_application_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `email` varchar(80) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `submitted_fresh_application_tbl`
--

INSERT INTO `submitted_fresh_application_tbl` (`id`, `email`) VALUES
(1, 'fon@yahoo.com'),
(2, 'agba@yahoo.com'),
(3, 'kay@yahoo.com');

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

--
-- Table structure for table `sub_tbl`
--

CREATE TABLE IF NOT EXISTS `sub_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `sub_name` varchar(80) NOT NULL,
  `sub_code` varchar(20) NOT NULL,
  `CreationDate` varchar(40) NOT NULL,
  `UpdationDate` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

--
-- Dumping data for table `sub_tbl`
--

INSERT INTO `sub_tbl` (`id`, `sub_name`, `sub_code`, `CreationDate`, `UpdationDate`) VALUES
(1, 'ENGLISH LANGUAGE', 'ENG', '', ''),
(2, 'MATHEMATICS', 'MTH', '', ''),
(3, 'CIVIC EDUCATION', 'CIV', '', ''),
(4, 'BIOLOGY', 'BIO', '', ''),
(5, 'PHYSICS', 'PHY', '', ''),
(6, 'CHEMISTRY', 'CHE', '', ''),
(7, 'AGRICULTURAL SCIENCE', 'AGR', '', ''),
(10, 'COMPUTER SCIENCE', 'CS', '', ''),
(11, 'CHRISTIAN RELIGIOUS STUDIES', 'CRS', '', ''),
(13, 'HEALTH SC.', 'HES', '', ''),
(14, 'FRENCH LANGUAGE', 'FRE', '', ''),
(17, 'COMMERCE', 'CMC', '', ''),
(18, 'GOVERNMENT', 'GVT', '', ''),
(19, 'ECONOMICS', 'ECO', '', ''),
(22, 'YORUBA LANGUAGE', 'YOR', '', ''),
(27, 'GEOGRAPHY', 'GEO', '', ''),
(28, 'FINANCIAL ACCOUNTS', 'F/A', '', ''),
(29, 'LITERATURE-IN-ENGLISH', 'LIT', '', ''),
(35, 'BUSINESS STUDIES', 'BUS', '', ''),
(37, 'BASIC TECHNOLOGY', 'BAS_TEC', '', ''),
(38, 'BASIC SCIENCE', 'BAS_SC', '', ''),
(39, 'SOCIAL STUDIES', 'SOC', '', ''),
(41, 'FURTHER MATHEMATICS', 'F/M', '', ''),
(43, 'CULTURAL AND CREATIVE ART', 'CCA', '', ''),
(44, 'P.H.E', 'PHE', '', ''),
(45, 'MARKETING', 'MKT', '', ''),
(46, 'MUSIC', 'MUS', '', ''),
(47, 'HOUSA', 'HOUS', '', ''),
(48, 'HOME ECONOMICS', 'H_ECO', '', ''),
(49, 'DICTION (PHONICS)', 'DIC', '', ''),
(50, 'ICT', 'ICT', '', ''),
(51, 'ELECTRICAL INSTALLATION', 'E_INST', '', '');

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

--
-- Table structure for table `user_block_open_fresh_application_tbl`
--

CREATE TABLE IF NOT EXISTS `user_block_open_fresh_application_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `session` varchar(100) NOT NULL,
  `status` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `user_block_open_fresh_application_tbl`
--

INSERT INTO `user_block_open_fresh_application_tbl` (`id`, `session`, `status`) VALUES
(1, '2020/2021', 'Open'),
(2, '2021/2022', 'Close');

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

--
-- Table structure for table `user_block_open_semester_scores_enetring_tbl`
--

CREATE TABLE IF NOT EXISTS `user_block_open_semester_scores_enetring_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `statements` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `user_block_open_semester_scores_enetring_tbl`
--

INSERT INTO `user_block_open_semester_scores_enetring_tbl` (`id`, `statements`) VALUES
(1, 'Open');

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

--
-- Table structure for table `user_dept_tbl`
--

CREATE TABLE IF NOT EXISTS `user_dept_tbl` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `email` varchar(80) NOT NULL,
  `regno` varchar(80) NOT NULL,
  `department` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `user_dept_tbl`
--

INSERT INTO `user_dept_tbl` (`id`, `email`, `regno`, `department`) VALUES
(10, 'obi4real@yahoo.com', 'obi', '1'),
(11, 'obi4real@yahoo.com', 'obi', '4'),
(12, 'obi4real@yahoo.com', 'obi', '10');

/*!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 */;
