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

START TRANSACTION;



--
-- Database: `resultapp-dls`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `name` varchar(180) NOT NULL,
  `password` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `name`, `password`, `type`) VALUES
(1, 'admin', 'Edward Humphrey', '$2y$12$00okMWYwMDZhNjE4OWYyOOyWiwVl9HS89zoRp1nYpkgr0R0AVmZ.6', 'superadmin'),
(2, 'joshua', 'Joshua Victor', '$2y$12$00okMzAxMzIxZDk3MzYxNu7V5Y5Xi3bCSeiwf1EbwXstnGv7qdtf2', 'admin'),
(4, 'peter', 'Peter Smile', '$2y$12$00okOTlkNmFkOTQ1YzQ3Ne0BV43WzN647nmaQ5JLKYrK1AphQbf6i', 'superadmin');

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

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `class` varchar(100) NOT NULL,
  `section` varchar(100) NOT NULL,
  `exam` varchar(100) NOT NULL,
  `exam_year` varchar(100) NOT NULL,
  `attendance` int(3) NOT NULL,
  `hwrite` int(3) NOT NULL,
  `fluency` int(3) NOT NULL,
  `games` int(3) NOT NULL,
  `sport` int(3) NOT NULL,
  `music` int(3) NOT NULL,
  `punctual` int(3) NOT NULL,
  `neat` int(3) NOT NULL,
  `polite` int(3) NOT NULL,
  `honest` int(3) NOT NULL,
  `leader` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `attendance`
--

INSERT INTO `attendance` (`id`, `student_name`, `class`, `section`, `exam`, `exam_year`, `attendance`, `hwrite`, `fluency`, `games`, `sport`, `music`, `punctual`, `neat`, `polite`, `honest`, `leader`) VALUES
(2, 'Andrew Stephen', 'Year 7', 'Lily', '2nd Term', '2022', 90, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 'Blessing Okoro', 'Year 7', 'Lily', '2nd Term', '2022', 90, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(4, 'Obagho David', 'Year 7', 'Lily', '2nd Term', '2022', 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(5, 'Amaka Israel', 'Year 7', 'Lily', '2nd Term', '2022', 90, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(6, 'Blessing Praise', 'Year 7', 'Lily', '2nd Term', '2022', 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(7, 'Amaka Israel', 'Year 8', 'Lily', '1st Term', '2022', 80, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0),
(10, 'Blessing Praise', 'Year 8', 'Lily', '1st Term', '2022', 100, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0),
(11, 'Obagho David', 'Year 8', 'Lily', '1st Term', '2022', 120, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0),
(12, 'Amalu Ifeanyi', 'Year 8', 'Lily', '1st Term', '2022', 90, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0),
(13, 'Gloria Smith', 'Year 8', 'Lily', '1st Term', '2022', 90, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0),
(14, 'Grace Kalu', 'Year 8', 'Lily', '1st Term', '2022', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(15, 'Amaka Israel', 'Year 8', 'Lily', '1st Term', '2022', 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(16, 'Amalu Ifeanyi', 'Year 8', 'Lily', '1st Term', '2022', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(17, 'Andrew Stephen', 'Year 8', 'Lily', '1st Term', '2022', 100, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0),
(18, 'Blessing Okoro', 'Year 8', 'Lily', '1st Term', '2022', 100, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0),
(19, 'Blessing Praise', 'Year 8', 'Lily', '1st Term', '2022', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(20, 'Gloria Smith', 'Year 8', 'Lily', '1st Term', '2022', 90, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(21, 'Grace Kalu', 'Year 8', 'Lily', '1st Term', '2022', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(22, 'Obagho David', 'Year 8', 'Lily', '1st Term', '2022', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `card_expire_date`
--

CREATE TABLE `card_expire_date` (
  `id` int(11) NOT NULL,
  `expire_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `card_expire_date`
--

INSERT INTO `card_expire_date` (`id`, `expire_date`) VALUES
(1, '2024-01-06');

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

--
-- Table structure for table `card_usage_limit`
--

CREATE TABLE `card_usage_limit` (
  `id` int(11) NOT NULL,
  `card_limit` int(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `card_usage_limit`
--

INSERT INTO `card_usage_limit` (`id`, `card_limit`) VALUES
(1, 4);

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

--
-- Table structure for table `classes`
--

CREATE TABLE `classes` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `class_numeric` int(11) NOT NULL,
  `teacher_name` varchar(100) NOT NULL,
  `note` text NOT NULL,
  `show_position` varchar(10) NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` (`id`, `name`, `class_numeric`, `teacher_name`, `note`, `show_position`) VALUES
(10, 'Nursery 1', 1, 'Mr Eziako', '', 'yes'),
(11, 'Nursery 2', 2, 'Mrs Faithful', '', 'yes'),
(12, 'KG1', 3, 'Mrs Oluwagbohun', '', 'yes'),
(13, 'KG2', 4, 'Mrs Mary Oshai', '', 'yes'),
(14, 'Primary 1', 5, 'Mrs Okwudili', '', 'yes'),
(15, 'Primary 2', 6, 'Mrs Ibe', '', 'yes'),
(16, 'Primary 3', 8, 'Mrs Chukwuemeka', '', 'yes'),
(17, 'Primary 4', 10, 'Mr Gbadebo', '', 'yes'),
(19, 'Primary 6', 12, 'Mrs Adeoye', '', 'yes');

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `class` varchar(100) NOT NULL,
  `section` varchar(100) NOT NULL,
  `exam` varchar(100) NOT NULL,
  `exam_year` varchar(100) NOT NULL,
  `class_teacher_comment` mediumtext NOT NULL,
  `principal_comment` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `student_name`, `class`, `section`, `exam`, `exam_year`, `class_teacher_comment`, `principal_comment`) VALUES
(2, 'Andrew Stephen', 'Year 7', 'Lily', '2nd Term', '2022', '', ''),
(4, 'Obagho David', 'Year 7', 'Lily', '2nd Term', '2022', 'Great Result, keep it up.', 'He did extremely well. Keep getting better.'),
(6, 'Blessing Okoro', 'Year 7', 'Lily', '2nd Term', '2022', 'A nice result', 'He did great but can make it better.'),
(7, 'Blessing Praise', 'Year 7', 'Lily', '2nd Term', '2022', '', ''),
(8, 'Amalu Ifeanyi', 'Year 8', 'Lily', '1st Term', '2022', '', ''),
(9, 'Gloria Smith', 'Year 8', 'Lily', '1st Term', '2022', 'A great result. keep it up', 'A wonderful, Keep doing good.'),
(10, 'Grace Kalu', 'Year 7', 'Lily', '1st Term', '2022', '', ''),
(11, 'Amaka Israel', 'Year 8', 'Lily', '1st Term', '2022', '', ''),
(12, 'Amalu Ifeanyi', 'Year 8', 'Lily', '1st Term', '2022', '', ''),
(13, 'Andrew Stephen', 'Year 8', 'Lily', '1st Term', '2022', '', ''),
(14, 'Blessing Okoro', 'Year 8', 'Lily', '1st Term', '2022', '', ''),
(15, 'Blessing Praise', 'Year 8', 'Lily', '1st Term', '2022', 'Nice Result', 'wonderful result'),
(16, 'Gloria Smith', 'Year 8', 'Lily', '1st Term', '2022', 'A great result. keep it up', 'A wonderful, Keep doing good.'),
(17, 'Grace Kalu', 'Year 8', 'Lily', '1st Term', '2022', '', ''),
(18, 'Obagho David', 'Year 8', 'Lily', '1st Term', '2022', 'A great result. keep it up', 'A wonderful, Keep doing good.');

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

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

CREATE TABLE `exams` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `exams` (`id`, `name`, `date`) VALUES
(1, '1st Term', '2021-10-23'),
(2, '2nd Term', '2021-12-17'),
(3, '3rd Term', '2022-12-03');

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

--
-- Table structure for table `general_settings`
--

CREATE TABLE `general_settings` (
  `id` int(11) NOT NULL,
  `school_tagline` varchar(255) NOT NULL,
  `school_name` varchar(255) NOT NULL,
  `phone_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `footer` varchar(255) NOT NULL,
  `next_term_begins` varchar(255) NOT NULL,
  `current_school_session` varchar(200) NOT NULL,
  `no_times_school_open` int(11) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `admin_login_bg` varchar(255) NOT NULL,
  `student_login_bg` varchar(255) NOT NULL,
  `teacher_login_bg` varchar(255) NOT NULL,
  `main_url` varchar(255) NOT NULL,
  `reg_no_prefix` varchar(10) NOT NULL,
  `terminal_report_bg_image` varchar(255) NOT NULL,
  `school_website` varchar(255) NOT NULL,
  `school_stamp` varchar(255) NOT NULL,
  `principal_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `general_settings`
--

INSERT INTO `general_settings` (`id`, `school_tagline`, `school_name`, `phone_no`, `email`, `address`, `footer`, `next_term_begins`, `current_school_session`, `no_times_school_open`, `logo`, `admin_login_bg`, `student_login_bg`, `teacher_login_bg`, `main_url`, `reg_no_prefix`, `terminal_report_bg_image`, `school_website`, `school_stamp`, `principal_name`) VALUES
(1, 'Dominating The World', 'DOMINANT LEADERS SCHOOL', '08139780206', 'dominantschool@gmail.com', '14A, Unity Crescent, Off Koku Street, Ijeja, Ogun State\r\n', 'Dominant Leaders School', '2026-01-05', '2025/2026', 100, 'pci_logo.png', 'school-banner.jpg', '1.jpg', 'badagry.jpg', 'http://localhost/resultapp-dls', 'GLS', 'bg-logo.png', 'https://prince-charels.org', 'stamp.png', 'Mr. Ambrose');

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

--
-- Table structure for table `generated_pins`
--

CREATE TABLE `generated_pins` (
  `id` int(11) NOT NULL,
  `pin` varchar(255) NOT NULL,
  `date_generated` date NOT NULL,
  `expired_date` date NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'open'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `generated_pins`
--

INSERT INTO `generated_pins` (`id`, `pin`, `date_generated`, `expired_date`, `status`) VALUES
(1, '5033993287', '2022-04-24', '0000-00-00', 'open'),
(2, '7324896565', '2022-04-24', '0000-00-00', 'open'),
(3, '1242497046', '2022-04-24', '0000-00-00', 'open'),
(4, '7902697525', '2022-04-24', '0000-00-00', 'open'),
(5, '5306098144', '2022-04-24', '0000-00-00', 'open'),
(6, '2492491223', '2022-04-24', '0000-00-00', 'open'),
(7, '8778092216', '2022-04-24', '0000-00-00', 'open'),
(8, '4022092224', '2022-04-24', '0000-00-00', 'close'),
(9, '2694190545', '2022-04-24', '0000-00-00', 'close'),
(10, '6239495706', '2022-04-24', '0000-00-00', 'close'),
(11, '9257898434', '2022-04-24', '0000-00-00', 'close'),
(12, '2981791711', '2022-04-24', '0000-00-00', 'close'),
(13, '6428596298', '2022-04-24', '0000-00-00', 'close'),
(14, '5514995962', '2022-04-24', '0000-00-00', 'close'),
(15, '2531092314', '2022-11-14', '0000-00-00', 'close'),
(16, '5947991877', '2022-11-14', '0000-00-00', 'close'),
(17, '5532994620', '2022-11-14', '0000-00-00', 'close'),
(18, '3701292951', '2025-11-10', '0000-00-00', 'open'),
(19, '4823597931', '2025-11-10', '0000-00-00', 'open'),
(20, '5378896754', '2025-11-10', '0000-00-00', 'open'),
(21, '7160396567', '2025-11-10', '0000-00-00', 'open'),
(22, '4509890881', '2025-11-11', '0000-00-00', 'open'),
(23, '8725890548', '2025-11-11', '0000-00-00', 'open'),
(24, '4070999912', '2025-11-17', '0000-00-00', 'open'),
(25, '2297291655', '2025-11-17', '0000-00-00', 'open'),
(26, '7022993060', '2025-11-17', '0000-00-00', 'open'),
(27, '7947496590', '2025-11-17', '0000-00-00', 'open'),
(28, '3488690642', '2025-11-17', '0000-00-00', 'open'),
(29, '7533297053', '2025-11-17', '0000-00-00', 'open'),
(30, '2186798595', '2025-11-17', '0000-00-00', 'open'),
(31, '7523496480', '2025-11-17', '0000-00-00', 'open'),
(32, '7336097857', '2025-11-17', '0000-00-00', 'open'),
(33, '9886593310', '2025-11-17', '0000-00-00', 'open');

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

--
-- Table structure for table `grade`
--

CREATE TABLE `grade` (
  `id` int(11) NOT NULL,
  `grade_name` varchar(20) NOT NULL,
  `grade_point` varchar(11) NOT NULL,
  `mark_from` int(11) NOT NULL,
  `mark_upto` int(11) NOT NULL,
  `note` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grade`
--

INSERT INTO `grade` (`id`, `grade_name`, `grade_point`, `mark_from`, `mark_upto`, `note`) VALUES
(3, 'B+', '4.50', 80, 89, 'GOLD'),
(4, 'B', '4', 70, 79, 'GOLD'),
(5, 'A', '5.00', 90, 100, 'GOLD'),
(6, 'C+', '3.5', 60, 69, 'SILVER'),
(8, 'C', '3.0', 50, 59, 'SILVER'),
(9, 'D', '1.50', 41, 49, 'BRONZE'),
(12, 'F', '1', 1, 39, 'BRONZE');

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

--
-- Table structure for table `phsyco`
--

CREATE TABLE `phsyco` (
  `id` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `class` varchar(100) NOT NULL,
  `section` varchar(100) NOT NULL,
  `exam` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `hwriting` int(2) NOT NULL,
  `fluency` int(2) NOT NULL,
  `games` int(2) NOT NULL,
  `sport` int(2) NOT NULL,
  `music` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `pins` (
  `id` int(11) NOT NULL,
  `pin_code` varchar(100) NOT NULL,
  `expire_date` date NOT NULL,
  `date_issued` date NOT NULL,
  `used_by` varchar(255) NOT NULL,
  `status` varchar(10) NOT NULL,
  `card_usage` int(10) NOT NULL,
  `card_availability` varchar(50) NOT NULL DEFAULT 'open'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `pins` (`id`, `pin_code`, `expire_date`, `date_issued`, `used_by`, `status`, `card_usage`, `card_availability`) VALUES
(2, '9257898434', '2023-01-10', '2022-09-27', 'Obagho David', '1', 3, 'close'),
(3, '6428596298', '2023-01-10', '2022-09-27', 'Obagho David', '1', 4, 'close'),
(4, '5514995962', '2023-01-10', '2022-10-20', 'Obagho David', '1', 2, 'close'),
(5, '2981791711', '2023-01-10', '2022-11-04', 'Gloria Smith', '1', 4, 'close'),
(6, '6239495706', '2023-01-10', '2022-11-04', 'Gloria Smith', '1', 2, 'open'),
(7, '5532994620', '2023-01-10', '2022-11-25', 'Obagho David', '1', 3, 'open'),
(8, '5947991877', '2023-01-10', '2023-07-06', 'Amaka Isreal', '1', 1, 'open'),
(9, '2531092314', '2023-01-10', '2023-07-06', 'Obagho David', '1', 1, 'open'),
(11, '2694190545', '2024-01-06', '2023-07-07', 'Amaka Israel', '1', 4, 'close'),
(12, '4022092224', '2024-01-06', '2023-07-07', 'Amaka Israel', '1', 3, 'open');

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

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

CREATE TABLE `results` (
  `id` int(11) NOT NULL,
  `name_of_student` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `exam` varchar(100) NOT NULL,
  `section` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `first_ca` int(11) NOT NULL,
  `second_ca` int(11) NOT NULL,
  `exam_score` int(11) NOT NULL,
  `school_year` varchar(100) NOT NULL,
  `current_school_session` varchar(70) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `results` (`id`, `name_of_student`, `class`, `exam`, `section`, `subject`, `first_ca`, `second_ca`, `exam_score`, `school_year`, `current_school_session`) VALUES
(5, 'Amaka Israel', 'Year 7', '2nd Term', 'Lily', 'Computer Studies', 20, 20, 60, '2022', '2022/2023'),
(6, 'Andrew Stephen', 'Year 7', '2nd Term', 'Lily', 'Computer Studies', 20, 20, 50, '2022', '2022/2023'),
(7, 'Blessing Okoro', 'Year 7', '2nd Term', 'Lily', 'Computer Studies', 12, 20, 46, '2022', '2022/2023'),
(8, 'Obagho David', 'Year 7', '2nd Term', 'Lily', 'Computer Studies', 20, 20, 60, '2022', '2022/2023'),
(9, 'Amaka Israel', 'Year 7', '2nd Term', 'Lily', 'English Studies', 20, 20, 60, '2022', '2022/2023'),
(10, 'Andrew Stephen', 'Year 7', '2nd Term', 'Lily', 'English Studies', 12, 16, 50, '2022', '2022/2023'),
(11, 'Blessing Okoro', 'Year 7', '2nd Term', 'Lily', 'English Studies', 10, 10, 43, '2022', '2022/2023'),
(12, 'Obagho David', 'Year 7', '2nd Term', 'Lily', 'English Studies', 15, 18, 60, '2022', '2022/2023'),
(13, 'Amaka Israel', 'Year 7', '2nd Term', 'Lily', 'Health Education', 12, 12, 40, '2022', '2022/2023'),
(14, 'Andrew Stephen', 'Year 7', '2nd Term', 'Lily', 'Health Education', 16, 18, 60, '2022', '2022/2023'),
(15, 'Blessing Okoro', 'Year 7', '2nd Term', 'Lily', 'Health Education', 20, 16, 45, '2022', '2022/2023'),
(16, 'Obagho David', 'Year 7', '2nd Term', 'Lily', 'Health Education', 20, 20, 56, '2022', '2022/2023'),
(17, 'Amaka Israel', 'Year 7', '2nd Term', 'Lily', 'Home Economics', 14, 16, 30, '2022', '2022/2023'),
(18, 'Andrew Stephen', 'Year 7', '2nd Term', 'Lily', 'Home Economics', 12, 12, 54, '2022', '2022/2023'),
(19, 'Blessing Okoro', 'Year 7', '2nd Term', 'Lily', 'Home Economics', 20, 14, 54, '2022', '2022/2023'),
(20, 'Obagho David', 'Year 7', '2nd Term', 'Lily', 'Home Economics', 18, 18, 56, '2022', '2022/2023'),
(21, 'Amaka Israel', 'Year 7', '2nd Term', 'Lily', 'Mathematics', 14, 13, 45, '2022', '2022/2023'),
(22, 'Andrew Stephen', 'Year 7', '2nd Term', 'Lily', 'Mathematics', 16, 17, 58, '2022', '2022/2023'),
(23, 'Blessing Okoro', 'Year 7', '2nd Term', 'Lily', 'Mathematics', 10, 10, 34, '2022', '2022/2023'),
(24, 'Obagho David', 'Year 7', '2nd Term', 'Lily', 'Mathematics', 16, 18, 54, '2022', '2022/2023'),
(25, 'Blessing Praise', 'Year 7', '2nd Term', 'Lily', 'Computer Studies', 12, 20, 46, '2022', '2022/2023'),
(26, 'Amaka Israel', 'Year 7', '1st Term', 'Lily', 'Computer Studies', 13, 16, 56, '2022', '2022/2023'),
(27, 'Andrew Stephen', 'Year 7', '1st Term', 'Lily', 'Computer Studies', 10, 10, 50, '2022', '2022/2023'),
(28, 'Blessing Okoro', 'Year 7', '1st Term', 'Lily', 'Computer Studies', 20, 10, 56, '2022', '2022/2023'),
(29, 'Blessing Praise', 'Year 7', '1st Term', 'Lily', 'Computer Studies', 10, 10, 43, '2022', '2022/2023'),
(30, 'Obagho David', 'Year 7', '1st Term', 'Lily', 'Computer Studies', 17, 18, 58, '2022', '2022/2023'),
(31, 'Amalu Ifeanyi', 'Year 7', '1st Term', 'Lily', 'Health Education', 18, 20, 56, '2022', '2022/2023'),
(32, 'Gloria Smith', 'Year 7', '1st Term', 'Lily', 'Health Education', 16, 18, 54, '2022', '2022/2023'),
(33, 'Grace Kalu', 'Year 7', '1st Term', 'Lily', 'Health Education', 20, 17, 50, '2022', '2022/2023'),
(34, 'Amaka Israel', 'Year 8', '1st Term', 'Lily', 'Computer Studies', 10, 20, 54, '2022', '2022/2023'),
(35, 'Amalu Ifeanyi', 'Year 8', '1st Term', 'Lily', 'Computer Studies', 10, 17, 54, '2022', '2022/2023'),
(36, 'Andrew Stephen', 'Year 8', '1st Term', 'Lily', 'Computer Studies', 17, 18, 45, '2022', '2022/2023'),
(37, 'Blessing Okoro', 'Year 8', '1st Term', 'Lily', 'Computer Studies', 16, 15, 43, '2022', '2022/2023'),
(38, 'Blessing Praise', 'Year 8', '1st Term', 'Lily', 'Computer Studies', 19, 20, 40, '2022', '2022/2023'),
(39, 'Gloria Smith', 'Year 8', '1st Term', 'Lily', 'Computer Studies', 13, 17, 35, '2022', '2022/2023'),
(40, 'Grace Kalu', 'Year 8', '1st Term', 'Lily', 'Computer Studies', 18, 16, 46, '2022', '2022/2023'),
(41, 'Obagho David', 'Year 8', '1st Term', 'Lily', 'Computer Studies', 18, 18, 45, '2022', '2022/2023'),
(42, 'Amaka Israel', 'Year 8', '1st Term', 'Lily', 'English', 10, 10, 54, '2022', '2022/2023'),
(43, 'Amalu Ifeanyi', 'Year 8', '1st Term', 'Lily', 'English', 10, 20, 30, '2022', '2022/2023'),
(44, 'Andrew Stephen', 'Year 8', '1st Term', 'Lily', 'English', 0, 0, 0, '2022', '2022/2023'),
(45, 'Blessing Okoro', 'Year 8', '1st Term', 'Lily', 'English', 0, 0, 0, '2022', '2022/2023'),
(46, 'Blessing Praise', 'Year 8', '1st Term', 'Lily', 'English', 0, 0, 0, '2022', '2022/2023'),
(47, 'Gloria Smith', 'Year 8', '1st Term', 'Lily', 'English', 0, 0, 0, '2022', '2022/2023'),
(48, 'Obagho David', 'Year 8', '1st Term', 'Lily', 'English', 10, 16, 53, '2022', '2022/2023'),
(49, 'Elizabeth Albert', 'Year 10', '1st Term', 'Lily', 'Mathematics', 17, 18, 40, '2022', '2022/2023'),
(50, 'Amaka Israel', 'Year 8', '1st Term', 'Lily', 'French Studies', 10, 10, 54, '2022', '2022/2023'),
(51, 'Amalu Ifeanyi', 'Year 8', '1st Term', 'Lily', 'French Studies', 0, 0, 0, '2022', '2022/2023'),
(52, 'Andrew Stephen', 'Year 8', '1st Term', 'Lily', 'French Studies', 0, 0, 0, '2022', '2022/2023'),
(53, 'Blessing Okoro', 'Year 8', '1st Term', 'Lily', 'French Studies', 0, 0, 0, '2022', '2022/2023'),
(54, 'Blessing Praise', 'Year 8', '1st Term', 'Lily', 'French Studies', 0, 0, 0, '2022', '2022/2023'),
(55, 'Gloria Smith', 'Year 8', '1st Term', 'Lily', 'French Studies', 0, 0, 0, '2022', '2022/2023'),
(56, 'Obagho David', 'Year 8', '1st Term', 'Lily', 'French Studies', 19, 19, 56, '2022', '2022/2023'),
(57, 'Amaka Israel', 'Year 8', '1st Term', 'Lily', 'Home Economics', 10, 19, 45, '2022', '2022/2023'),
(58, 'Amalu Ifeanyi', 'Year 8', '1st Term', 'Lily', 'Home Economics', 18, 18, 45, '2022', '2022/2023'),
(59, 'Andrew Stephen', 'Year 8', '1st Term', 'Lily', 'Home Economics', 0, 0, 0, '2022', '2022/2023'),
(60, 'Blessing Okoro', 'Year 8', '1st Term', 'Lily', 'Home Economics', 0, 0, 0, '2022', '2022/2023'),
(61, 'Blessing Praise', 'Year 8', '1st Term', 'Lily', 'Home Economics', 0, 0, 0, '2022', '2022/2023'),
(62, 'Gloria Smith', 'Year 8', '1st Term', 'Lily', 'Home Economics', 0, 0, 0, '2022', '2022/2023'),
(63, 'Obagho David', 'Year 8', '1st Term', 'Lily', 'Home Economics', 18, 18, 50, '2022', '2022/2023'),
(64, 'Amaka Israel', 'Year 8', '1st Term', 'Lily', 'Introductory Technology', 16, 16, 46, '2022', '2022/2023'),
(65, 'Amalu Ifeanyi', 'Year 8', '1st Term', 'Lily', 'Introductory Technology', 10, 15, 56, '2022', '2022/2023'),
(66, 'Andrew Stephen', 'Year 8', '1st Term', 'Lily', 'Introductory Technology', 0, 0, 0, '2022', '2022/2023'),
(67, 'Blessing Okoro', 'Year 8', '1st Term', 'Lily', 'Introductory Technology', 0, 0, 0, '2022', '2022/2023'),
(68, 'Blessing Praise', 'Year 8', '1st Term', 'Lily', 'Introductory Technology', 0, 0, 0, '2022', '2022/2023'),
(69, 'Gloria Smith', 'Year 8', '1st Term', 'Lily', 'Introductory Technology', 0, 0, 0, '2022', '2022/2023'),
(70, 'Obagho David', 'Year 8', '1st Term', 'Lily', 'Introductory Technology', 18, 18, 54, '2022', '2022/2023'),
(71, 'Amaka Israel', 'Year 8', '1st Term', 'Lily', 'Mathematics', 10, 10, 44, '2022', '2022/2023'),
(72, 'Amalu Ifeanyi', 'Year 8', '1st Term', 'Lily', 'Mathematics', 0, 0, 0, '2022', '2022/2023'),
(73, 'Andrew Stephen', 'Year 8', '1st Term', 'Lily', 'Mathematics', 0, 0, 0, '2022', '2022/2023'),
(74, 'Blessing Okoro', 'Year 8', '1st Term', 'Lily', 'Mathematics', 0, 0, 0, '2022', '2022/2023'),
(75, 'Blessing Praise', 'Year 8', '1st Term', 'Lily', 'Mathematics', 0, 0, 0, '2022', '2022/2023'),
(76, 'Gloria Smith', 'Year 8', '1st Term', 'Lily', 'Mathematics', 0, 0, 0, '2022', '2022/2023'),
(77, 'Obagho David', 'Year 8', '1st Term', 'Lily', 'Mathematics', 20, 20, 52, '2022', '2022/2023'),
(78, 'Amaka Israel', 'Year 8', '1st Term', 'Lily', 'Social Studies', 10, 10, 20, '2022', '2022/2023'),
(79, 'Amalu Ifeanyi', 'Year 8', '1st Term', 'Lily', 'Social Studies', 10, 10, 45, '2022', '2022/2023'),
(80, 'Andrew Stephen', 'Year 8', '1st Term', 'Lily', 'Social Studies', 0, 0, 0, '2022', '2022/2023'),
(81, 'Blessing Okoro', 'Year 8', '1st Term', 'Lily', 'Social Studies', 0, 0, 0, '2022', '2022/2023'),
(82, 'Blessing Praise', 'Year 8', '1st Term', 'Lily', 'Social Studies', 0, 0, 0, '2022', '2022/2023'),
(83, 'Gloria Smith', 'Year 8', '1st Term', 'Lily', 'Social Studies', 0, 0, 0, '2022', '2022/2023'),
(84, 'Obagho David', 'Year 8', '1st Term', 'Lily', 'Social Studies', 20, 16, 44, '2022', '2022/2023'),
(85, 'Amaka Israel', 'Year 8', '1st Term', 'Lily', 'Unique English', 10, 10, 54, '2022', '2022/2023'),
(86, 'Amalu Ifeanyi', 'Year 8', '1st Term', 'Lily', 'Unique English', 10, 10, 10, '2022', '2022/2023'),
(87, 'Andrew Stephen', 'Year 8', '1st Term', 'Lily', 'Unique English', 0, 0, 0, '2022', '2022/2023'),
(88, 'Blessing Okoro', 'Year 8', '1st Term', 'Lily', 'Unique English', 0, 0, 0, '2022', '2022/2023'),
(89, 'Blessing Praise', 'Year 8', '1st Term', 'Lily', 'Unique English', 0, 0, 0, '2022', '2022/2023'),
(90, 'Gloria Smith', 'Year 8', '1st Term', 'Lily', 'Unique English', 0, 0, 0, '2022', '2022/2023'),
(91, 'Obagho David', 'Year 8', '1st Term', 'Lily', 'Unique English', 20, 18, 55, '2022', '2022/2023'),
(92, 'Ambrose Hamid', 'Year 10', '1st Term', 'Ixora', 'Mathematics', 10, 10, 30, '2022', '2022/2023'),
(93, 'Samuel Obed', 'SS3', '2nd Term', 'Lily', 'English Studies', 19, 17, 50, '2023', '2022/2023'),
(94, 'Samuel Obed', 'SS3', '2nd Term', 'Lily', 'Mathematics', 18, 18, 40, '2023', '2022/2023'),
(95, 'Samuel Obed', 'SS3', '2nd Term', 'Lily', 'Social Studies', 18, 16, 60, '2023', '2022/2023'),
(96, 'Oyeudo Samuel ', 'Primary 6', '1st Term', 'Maranatha', 'Mathematics', 13, 14, 45, '2025', '2025/2026'),
(97, 'Oyeudo Samuel ', 'Primary 6', '1st Term', 'Maranatha', 'Abacus', 12, 11, 35, '2025', '2025/2026'),
(98, 'Oyeudo Samuel ', 'Primary 6', '1st Term', 'Maranatha', 'Agric/Home Economics', 11, 16, 46, '2025', '2025/2026'),
(99, 'Oyeudo Samuel ', 'Primary 6', '1st Term', 'Maranatha', 'Basic Science', 12, 12, 50, '2025', '2025/2026'),
(100, 'Oyeudo Samuel ', 'Primary 6', '1st Term', 'Maranatha', 'Christian Religious Studies', 14, 14, 50, '2025', '2025/2026'),
(101, 'Oyeudo Samuel ', 'Primary 6', '1st Term', 'Maranatha', 'English Language', 15, 15, 46, '2025', '2025/2026'),
(102, 'Oyeudo Samuel ', 'Primary 6', '1st Term', 'Maranatha', 'Computer', 14, 13, 30, '2025', '2025/2026'),
(103, 'Oyeudo Samuel ', 'Primary 6', '1st Term', 'Maranatha', 'Quantitative Reasoning', 13, 12, 40, '2025', '2025/2026');

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

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

CREATE TABLE `sections` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `category` varchar(100) NOT NULL,
  `capacity` varchar(50) NOT NULL,
  `class` varchar(40) NOT NULL,
  `teacher_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `sections` (`id`, `name`, `category`, `capacity`, `class`, `teacher_name`) VALUES
(15, 'Kindness', 'Nur', '15', '11', 'Mrs Faithful'),
(16, 'Goodness', 'Nur', '14', '11', 'Mrs Nse'),
(17, 'Wisdom', 'Kg', '18', '12', 'Mrs Oluwagbohun'),
(18, 'Knowledge', 'Kg', '18', '12', 'Miss Kelechi'),
(19, 'Peace', 'Kg', '18', '13', 'Mrs Mary Oshai'),
(20, 'Joy', 'Kg', '20', '13', 'Mrs Oladokun Loveth'),
(21, 'Holiness', 'Pry', '21', '14', 'Mrs Okwudili'),
(22, 'Purity', 'Pry', '22', '14', 'Mrs Nicholas'),
(23, 'Diligence', 'Pry', '18', '15', 'Mrs Ibe'),
(24, 'New', 'Pry', '16', '15', 'Miss Onyinyechi'),
(25, 'Gentleness', 'Pry', '29', '16', 'Mrs Chukwuemeka'),
(26, 'Faithfulness', 'Pry', '31', '17', 'Mr Gbadebo'),
(27, 'Maranatha', 'Pry', '21', '18', 'Mrs Adeoye'),
(29, 'Precious', 'Nur', '18', '10', 'Mr Eziako');

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

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
  `studentID` int(11) NOT NULL,
  `name` varchar(90) NOT NULL,
  `password` varchar(255) NOT NULL,
  `sex` varchar(10) NOT NULL,
  `classesID` int(11) NOT NULL,
  `registerNO` varchar(40) NOT NULL,
  `username` varchar(60) NOT NULL,
  `exam_pin` int(11) NOT NULL,
  `card_serial_no` varchar(255) NOT NULL,
  `sectionid` varchar(10) NOT NULL,
  `country` varchar(100) NOT NULL,
  `dob` varchar(40) NOT NULL,
  `phone` varchar(70) NOT NULL,
  `religion` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `state` varchar(100) NOT NULL,
  `photo` varchar(200) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'on',
  `height` varchar(11) NOT NULL,
  `weight` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`studentID`, `name`, `password`, `sex`, `classesID`, `registerNO`, `username`, `exam_pin`, `card_serial_no`, `sectionid`, `country`, `dob`, `phone`, `religion`, `email`, `address`, `state`, `photo`, `status`, `height`, `weight`) VALUES
(1, 'Ambrose Hamid', '$2y$12$00okYjdlOGM1NmM2YWUyZO5QYSF4.QCpAb5.ZeU4idtatIXxp8O0S', 'male', 5, 'PCIS/2021_2838', 'ambrose', 24086, '', '10', 'Nigeria', '2021-09-15', '09088876473', 'Islam', 'ambrose_hamid@gmail.com', '54, Ibifoma street, ajangbadi', 'Lagos', 'photo1634048386.jpg', 'on', '', ''),
(2, 'Obagho David', '$2y$12$00okZGYwZDJlMDMzN2I5YOMbFcQL93WP2J1tPX0tDHW.C6QdXiz2m', 'male', 4, 'PCIS/2021_6530', 'obagho', 58396, '2531092314', '7', 'Nigeria', '2010-03-12', '07016276723', 'Christianity', 'obagho@gmail.com', '12, Ikonro Street', 'Lagos', 'photo1666773571.png', 'on', '19', '63'),
(3, 'Amaka Israel', '$2y$12$00okYzM3Yzg5NGU0YTM0N.I6JsF/hVjz.Bvon8xMS4dA0MIpis4dy', 'female', 4, 'PCIS/2022_8539', 'amaka', 85134, '', '7', 'Nigeria', '2020-03-04', '', '', 'amaka@gmail.com', '', '', '', 'on', '', ''),
(4, 'Andrew Stephen', '$2y$12$00okMDdhNmYxNDk1YTNhNeKtODJ9z9e76.ZIF4VJNwkDpJnjN801K', 'male', 4, 'PCIS/2022_9447', 'stephen', 75951, '', '7', 'Nigeria', '2022-04-23', '', '', 'stephen@yahoo.com', '', '', '', 'on', '', ''),
(5, 'Blessing Okoro', '$2y$12$00okODY3Yzk0MmI4ZDEwMOK9zqPL2xc8ZUsTSKHtfiFZ7aZuQeaYO', 'female', 4, 'PCIS/2022_1924', 'blessing', 23983, '', '7', 'Nigeria', '2022-04-07', '', '', 'blessing@yahoo.com', '', '', '', 'on', '', ''),
(6, 'Blessing Praise', '$2y$12$00okMmYzMmY3YmIyY2I3OOr2.aIyLagNGtJFJ76uU.9qkFi0TBSIK', 'female', 4, 'PCIS/2022_10050', 'blessing_praise', 60474, '', '7', 'Nigeria', '2010-05-29', '07016773788', 'Christian', 'blessingpraise@gmail.com', 'Festac Lagos, Nigeria', 'Lagos', 'platinum.jpg', 'on', '', ''),
(8, 'Amalu Ifeanyi', '$2y$12$00okZThkMzMwZDNkMDcyMet50RXQjDJtDT3iAdhPDPqebb2PUeXMC', 'male', 4, 'PCIS/2022_5242', 'amalu', 65145, '', '7', 'Nigeria', '2022-11-02', '', '', 'amalu@yahoo.com', '', '', '', 'on', '', ''),
(9, 'Amaka Gideon', '$2y$12$00okYjc1MDQ1MWQzNmFiOOg75gEKXSzm8wPMUwl1yM/mhQU1O8GkW', 'female', 1, 'PCIS/2022_6725', 'amakababy', 92792, '', '5', 'Nigeria', '2022-11-08', '', '', 'amaka123@gmail.com', '', '', '', 'on', '', ''),
(10, 'Esther Gilbert', '$2y$12$00okMzNiNzAwY2NhMzk2Ne0Y9XDZJPfRooqWPs7rfmioOzYEiWVS.', 'female', 1, 'PCIS/2022_4513', 'esther', 47242, '', '4', 'Nigeria', '2022-12-01', '', '', 'esther2020@yahoo.com', '', '', '', 'on', '', ''),
(12, 'Gloria Smith', '$2y$12$00okNzAwYTYyYmE1MDNmMOKbS9RARSUEMp6e/Szdr8M13qz4w8zQ6', 'female', 4, 'PCIS/2022_8943', 'gloria', 40416, '6239495706', '7', 'Nigeria', '2006-01-13', '07016763737', 'Christian', 'gloriasmith@gmail.com', '12, Glover Road, Apapa Lagos, Nigeria', 'Lagos', 'photo1667562511.jpg', 'on', '', ''),
(13, 'Elizabeth Albert', '$2y$12$00okZjYzNzZiMjc0NzA4Mu7W6COCwnpFEUR35uyH6/d9iLNPUdFWe', 'female', 5, 'PCIS/2022_5403', 'elizabeth', 37183, '', '9', 'Nigeria', '2014-04-13', '09050040404', 'Christianity', 'elizabeth@yahoo.com', '14, Cape Town, Apapa Lagos', 'Lagos', 'te1.jpg', 'on', '', ''),
(14, 'Samuel Obed', '$2y$12$00okYzYyYTY3YmI3YTNjYepcuehRgCTtIEqw2d2aGTt9FM6X72sRy', 'male', 7, 'PCIS/2023_113', 'samuel', 38099, '', '13', 'Nigeria', '2022-02-04', '', '', 'samuel@yahoo.com', '', '', '', 'on', '', ''),
(15, 'Chianugo Amarachukwu Greatness ', '$2y$12$00okMzEyMjdlNzZjYzdjZepCY6rj9/5ZP8V6r6RrWdd2NtT1jV3CC', 'female', 10, 'GLS/2025_6706', 'nursery101', 31508, '', '29', 'Nigeria', '2000-05-08', '09028517407', 'Christianity', 'glss1@gmail.com', 'Baptist Church close', 'Lagos', '', 'on', '', ''),
(16, 'Ezeonyeji Chidubem', '$2y$12$00okNmFmMTI0YmJmYzA0MuUNxw4tCPgnT5Oaqam9xDuJJD8rquu9q', 'male', 10, 'GLS/2025_3506', 'Chidubemn1', 19280, '', '29', 'Nigeria', '2014-02-22', '09028517407', 'Christianity', 'glss2@gmail.com', 'Baptist Church close', 'Lagos', '', 'on', '', ''),
(17, 'Oyeudo Samuel ', '$2y$12$00okODIwNGUzYWI1ZGJmMOjjaC/0LLDojUh13DdA93Zb5AD9Y/.Q6', 'male', 19, 'GLS/2025_5039', 'samuel6', 90595, '', '28', 'Nigeria', '2014-10-13', '09028517407', 'Christianity', 'glss6@gmail.com', 'Baptist Church close', 'Lagos', 'TOCHI.jpg', 'on', '', ''),
(18, 'Enyim Daniel', '$2y$12$00okNzBlMDNkMjU4NmRhZ.kngEbd4NslZ8etXT9GRnZiQV0zflUHC', 'male', 17, 'GLS/2025_9511', 'daniel44', 44521, '', '26', 'Nigeria', '2014-10-13', '08034177870', 'Christianity', 'gls@gmail.com', 'Baptist Church close', 'Lagos', '', 'on', '', '');

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

--
-- Table structure for table `student_class_positions`
--

CREATE TABLE `student_class_positions` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `reg_no` varchar(150) NOT NULL,
  `class` varchar(60) NOT NULL,
  `section` varchar(60) NOT NULL,
  `exam` varchar(50) NOT NULL,
  `exam_year` varchar(100) NOT NULL,
  `marks_obtained` int(11) NOT NULL,
  `position` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_class_positions`
--

INSERT INTO `student_class_positions` (`id`, `name`, `reg_no`, `class`, `section`, `exam`, `exam_year`, `marks_obtained`, `position`) VALUES
(1, 'Amaka Israel', 'PCIS/2022_8539', 'Year 7', 'Lily', '2nd Term', '2022', 396, '3rd'),
(2, 'Andrew Stephen', 'PCIS/2022_9447', 'Year 7', 'Lily', '2nd Term', '2022', 431, '2nd'),
(3, 'Blessing Okoro', 'PCIS/2022_1924', 'Year 7', 'Lily', '2nd Term', '2022', 364, '4th'),
(4, 'Obagho David', 'PCIS/2021_6530', 'Year 7', 'Lily', '2nd Term', '2022', 469, '1st'),
(5, 'Blessing Praise', 'PCIS/2022_10050', 'Year 7', 'Lily', '2nd Term', '2022', 78, '5th'),
(6, 'Amaka Israel', 'PCIS/2022_8539', 'Year 7', 'Lily', '1st Term', '2022', 85, '6th'),
(7, 'Andrew Stephen', 'PCIS/2022_9447', 'Year 7', 'Lily', '1st Term', '2022', 70, '7th'),
(8, 'Blessing Okoro', 'PCIS/2022_1924', 'Year 7', 'Lily', '1st Term', '2022', 86, '5th'),
(9, 'Blessing Praise', 'PCIS/2022_10050', 'Year 7', 'Lily', '1st Term', '2022', 63, '8th'),
(10, 'Obagho David', 'PCIS/2021_6530', 'Year 7', 'Lily', '1st Term', '2022', 93, '2nd'),
(11, 'Amalu Ifeanyi', 'PCIS/2022_5242', 'Year 7', 'Lily', '1st Term', '2022', 94, '1st'),
(12, 'Gloria Smith', 'PCIS/2022_8943', 'Year 7', 'Lily', '1st Term', '2022', 88, '3rd'),
(13, 'Grace Kalu', 'PCIS/2022_9002', 'Year 7', 'Lily', '1st Term', '2022', 87, '4th'),
(14, 'Amaka Israel', 'PCIS/2022_8539', 'Year 8', 'Lily', '1st Term', '2022', 562, '2nd'),
(15, 'Amalu Ifeanyi', 'PCIS/2022_5242', 'Year 8', 'Lily', '1st Term', '2022', 398, '3rd'),
(16, 'Andrew Stephen', 'PCIS/2022_9447', 'Year 8', 'Lily', '1st Term', '2022', 80, '4th'),
(17, 'Blessing Okoro', 'PCIS/2022_1924', 'Year 8', 'Lily', '1st Term', '2022', 74, '6th'),
(18, 'Blessing Praise', 'PCIS/2022_10050', 'Year 8', 'Lily', '1st Term', '2022', 79, '5th'),
(19, 'Gloria Smith', 'PCIS/2022_8943', 'Year 8', 'Lily', '1st Term', '2022', 65, '7th'),
(20, 'Grace Kalu', 'PCIS/2022_9002', 'Year 8', 'Lily', '1st Term', '2022', 80, '4th'),
(21, 'Obagho David', 'PCIS/2021_6530', 'Year 8', 'Lily', '1st Term', '2022', 695, '1st'),
(22, 'Elizabeth Albert', 'PCIS/2022_5403', 'Year 10', 'Lily', '1st Term', '2022', 75, '1st'),
(23, 'Ambrose Hamid', 'PCIS/2021_2838', 'Year 10', 'Ixora', '1st Term', '2022', 50, ''),
(24, 'Samuel Obed', 'PCIS/2023_113', 'SS3', 'Lily', '2nd Term', '2023', 256, '1st'),
(25, 'Amaka Israel', 'PCIS/2022_8539', 'Year 8', 'Lily', '1st Term', '2025', 0, ''),
(26, 'Amalu Ifeanyi', 'PCIS/2022_5242', 'Year 8', 'Lily', '1st Term', '2025', 0, ''),
(27, 'Andrew Stephen', 'PCIS/2022_9447', 'Year 8', 'Lily', '1st Term', '2025', 0, ''),
(28, 'Blessing Okoro', 'PCIS/2022_1924', 'Year 8', 'Lily', '1st Term', '2025', 0, ''),
(29, 'Blessing Praise', 'PCIS/2022_10050', 'Year 8', 'Lily', '1st Term', '2025', 0, ''),
(30, 'Gloria Smith', 'PCIS/2022_8943', 'Year 8', 'Lily', '1st Term', '2025', 0, ''),
(31, 'Obagho David', 'PCIS/2021_6530', 'Year 8', 'Lily', '1st Term', '2025', 0, ''),
(32, 'Oyeudo Samuel ', 'GLS/2025_5039', 'Primary 6', 'Maranatha', '1st Term', '2025', 553, '1st');

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

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

CREATE TABLE `subjects` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `teacher_name` varchar(100) NOT NULL,
  `pass_mark` varchar(20) NOT NULL,
  `final_mark` varchar(20) NOT NULL,
  `subject_name` varchar(100) NOT NULL,
  `subject_author` varchar(100) NOT NULL,
  `subject_code` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `subjects` (`id`, `class_id`, `teacher_name`, `pass_mark`, `final_mark`, `subject_name`, `subject_author`, `subject_code`) VALUES
(1, 1, 'Amaka Vivian', '50', '100', 'Mathematics', 'Mr. Barry', 'math001'),
(3, 1, 'Amaka Vivian', '10', '100', 'English Studies', '', 'Eng_001'),
(4, 4, 'Amaka Vivian', '50', '100', 'Mathematics', '', 'math002'),
(5, 3, 'Okeme David', '20', '100', 'Mathematics', '', 'math003'),
(6, 3, 'Okeme David', '20', '100', 'English Studies', '', 'Eng_003'),
(7, 3, 'Okeme David', '10', '100', 'Home Economics', '', 'econs001'),
(8, 3, 'Okeme David', '20', '100', 'Computer Studies', '', 'Comp001'),
(9, 3, 'Okeme David', '20', '100', 'Health Education', '', 'health_021'),
(10, 6, 'Okeme David', '40', '100', 'Mathematics', '', 'mathoo1'),
(11, 5, 'Okeme David', '10', '60', 'Mathematics', '', 'math006'),
(12, 7, 'Amaka Gibson', '10', '60', 'Mathematics', '', 'math008'),
(13, 4, 'teacher 4', '10', '78', 'English', '', 'eng_005'),
(14, 4, 'teacher 4', '1', '89', 'Home Economics', '', 'econs_009'),
(15, 4, 'teacher 4', '10', '100', 'Computer Studies', '', 'comp_005'),
(16, 4, 'Okeme David', '100', '10', 'Social Studies', '', 'sos001'),
(17, 4, 'Okeme David', '100', '10', 'Introductory Technology', '', 'intro001'),
(18, 4, 'Okeme David', '100', '10', 'French Studies', '', 'fren_001'),
(19, 4, 'Okeme David', '100', '10', 'Unique English', '', 'uni_001'),
(20, 7, 'Okeme David', '89', '100', 'English Studies', '', 'Eng001'),
(21, 7, 'Okeme David', '30', '40', 'Social Studies', '', 'sos002'),
(22, 19, 'Mrs Adeoye', '50', '100', 'Mathematics', 'teacher', 'm01'),
(23, 19, 'Mrs Adeoye', '50', '100', 'English Language', 'teacher', 'e01'),
(24, 19, 'Mrs Adeoye', '50', '100', 'Basic Science', 'teacher', 'bs01'),
(25, 19, 'Mrs Adeoye', '50', '100', 'Christian Religious Studies', 'teacher', 'CRK01'),
(26, 19, 'Mrs Adeoye', '50', '100', 'Physical and Health Education', 'teacher', 'PHE06'),
(27, 19, 'Mrs Adeoye', '50', '100', 'Handwriting', 'teacher', 'HRT06'),
(28, 19, 'Mrs Adeoye', '50', '100', 'Agric/Home Economics', 'teacher', 'HM06'),
(29, 19, 'Mrs Adeoye', '50', '100', 'Quantitative Reasoning', 'teacher', 'QR06'),
(30, 19, 'Mrs Adeoye', '50', '100', 'Verbal Reasoning', 'teacher', 'VR06'),
(31, 19, 'Mrs Adeoye', '50', '100', 'Civic Education', 'teacher', 'CV06'),
(32, 19, 'Mrs Adeoye', '50', '100', 'Phonics', 'teacher', 'PH06'),
(33, 19, 'Mrs Adeoye', '50', '100', 'Social Studies', 'teacher', 'SOS06'),
(34, 19, 'Mrs Adeoye', '50', '100', 'Computer', 'teacher', 'CM06'),
(35, 19, 'Mrs Adeoye', '50', '100', 'Literature', 'teacher', 'LT06'),
(36, 19, 'Mrs Adeoye', '50', '100', 'History', 'teacher', 'HST06'),
(37, 19, 'Mrs Adeoye', '50', '100', 'Creative Art', 'teacher', 'CA06'),
(38, 19, 'Mrs Adeoye', '50', '100', 'Abacus', 'teacher', 'AB06'),
(39, 19, 'Mrs Adeoye', '50', '100', 'Music', 'teacher', 'M06');

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

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

CREATE TABLE `teachers` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `designation` varchar(50) NOT NULL,
  `dob` date NOT NULL,
  `gender` varchar(40) NOT NULL,
  `religion` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `address` varchar(255) NOT NULL,
  `joining_date` date NOT NULL,
  `photo` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'on'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `teachers` (`id`, `name`, `designation`, `dob`, `gender`, `religion`, `email`, `phone`, `address`, `joining_date`, `photo`, `username`, `password`, `status`) VALUES
(10, 'Mr Eziako', 'Class Teacher', '2007-01-22', 'female', 'Christianity', 'gls1@gmail.com', '08034177870', 'Baptist Church close', '2020-02-22', '', 'eziako', '$2y$12$00okOGViMzg1NGFlZTI2YOks1rnlFiI3KbRalzNqKQc2Y2hy/ny2a', 'on'),
(11, 'Mrs Faithful', 'Class Teacher', '2007-01-22', '', 'Christianity', 'gls2@gmail.com', '08034177870', 'Baptist Church close', '2020-02-22', '', 'faithful', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(12, 'Mrs Nse', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls3@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'nse', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(13, 'Mrs Oluwagbohun', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls4@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'oluwagbohun', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(14, 'Miss Kelechi', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls5@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'kelechi', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(15, 'Mrs Mary Oshai', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls6@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'mary', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(16, 'Mrs Oladokun Loveth', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls7@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'loveth', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(17, 'Mrs Okwudili', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls8@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'okwudili', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(18, 'Mrs Nicholas', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls9@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'nicholas', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(19, 'Mrs Ibe', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls10@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'ibe', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(20, 'Miss Onyinyechi', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls11@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'onyinyechi', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(21, 'Mrs Chukwuemeka', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls12@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'chukwuemeka', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(22, 'Mr Gbadebo', 'Class Teacher', '0000-00-00', 'Male', 'Christianity', 'gls13@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'gbadebo', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on'),
(23, 'Mrs Adeoye', 'Class Teacher', '0000-00-00', 'female', 'Christianity', 'gls14@gmail.com', '8034177870', 'Baptist Church close', '0000-00-00', '', 'adeoye', '$2y$12$00okMmYwODU4ODM4NWU0O.NMxTsBfXn2k3eu4gV2crQSTsYDQp6Tm', 'on');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `student`
--
ALTER TABLE `student`
  ADD PRIMARY KEY (`studentID`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `student`
--
ALTER TABLE `student`
  MODIFY `studentID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

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

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

