-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Apr 02, 2025 at 11:38 AM
-- Server version: 8.3.0
-- PHP Version: 8.2.18

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: `cbt`
--

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

--
-- Table structure for table `2024ndicom222`
--

DROP TABLE IF EXISTS `2024ndicom222`;
CREATE TABLE IF NOT EXISTS `2024ndicom222` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` text NOT NULL,
  `opt1` varchar(255) NOT NULL,
  `opt2` varchar(255) NOT NULL,
  `opt3` varchar(255) NOT NULL,
  `opt4` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024ndicom222`
--

INSERT INTO `2024ndicom222` (`id`, `qst`, `opt1`, `opt2`, `opt3`, `opt4`, `ans`) VALUES
(1, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'a'),
(2, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'b'),
(3, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'c'),
(4, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'c'),
(5, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'd'),
(6, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'e'),
(7, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'b'),
(8, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'c'),
(9, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'c'),
(10, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'd'),
(11, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'a'),
(12, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'b');

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

--
-- Table structure for table `2024ndicom222score`
--

DROP TABLE IF EXISTS `2024ndicom222score`;
CREATE TABLE IF NOT EXISTS `2024ndicom222score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024ndicom222score`
--

INSERT INTO `2024ndicom222score` (`id`, `matric`, `fname`, `score`) VALUES
(1, '124', 'oladeji', 2),
(2, '1', 'who is the first man ', 0),
(3, '2', 'who is a teacher ', 0),
(4, '223', 'komolafe', 0),
(5, 'BB', 'olasoji', 0),
(6, 'DD', 'titi', 0),
(7, '4', 'Where is OSUN', 0),
(8, 'CC', 'kolade', 0);

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

--
-- Table structure for table `2025ndicdd222`
--

DROP TABLE IF EXISTS `2025ndicdd222`;
CREATE TABLE IF NOT EXISTS `2025ndicdd222` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` text NOT NULL,
  `opt1` varchar(255) NOT NULL,
  `opt2` varchar(255) NOT NULL,
  `opt3` varchar(255) NOT NULL,
  `opt4` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2025ndicdd222`
--

INSERT INTO `2025ndicdd222` (`id`, `qst`, `opt1`, `opt2`, `opt3`, `opt4`, `ans`) VALUES
(1, 'Full Name', 'EEID', 'Job Title', 'Department', 'Business Unit', ''),
(2, 'Emily Davis', 'E02387', 'Sr. Manger', 'IT', 'Research & Development', 'Research & Development'),
(3, 'Theodore Dinh', 'E04105', 'Technical Architect', 'IT', 'Manufacturing', 'Manufacturing'),
(4, 'Luna Sanders', 'E02572', 'Director', 'Finance', 'Speciality Products', 'c'),
(5, 'Penelope Jordan', 'E02832', 'Computer Systems Manager', 'IT', 'Manufacturing', 'd'),
(6, 'Austin Vo', 'E01639', 'Sr. Analyst', 'Finance', 'Manufacturing', 'a'),
(7, 'Joshua Gupta', 'E00644', 'Account Representative', 'Sales', 'Corporate', 'b'),
(8, 'Ruby Barnes', 'E01550', 'Manager', 'IT', 'Corporate', 'c'),
(9, 'Luke Martin', 'E04332', 'Analyst', 'Finance', 'Manufacturing', 'd'),
(10, 'Easton Bailey', 'E04533', 'Manager', 'Accounting', 'Manufacturing', 'a'),
(11, 'Madeline Walker', 'E03838', 'Sr. Analyst', 'Finance', 'Speciality Products', 'b'),
(12, 'Savannah Ali', 'E00591', 'Sr. Manger', 'Human Resources', 'Manufacturing', 'c'),
(13, 'Camila Rogers', 'E03344', 'Controls Engineer', 'Engineering', 'Speciality Products', 'd'),
(14, 'Eli Jones', 'E00530', 'Manager', 'Human Resources', 'Manufacturing', 'Manufacturing'),
(15, 'Everleigh Ng', 'E04239', 'Sr. Manger', 'Finance', 'Research & Development', 'b'),
(16, 'Robert Yang', 'E03496', 'Sr. Analyst', 'Accounting', 'Speciality Products', 'c'),
(17, 'Isabella Xi', 'E00549', 'Vice President', 'Marketing', 'Research & Development', 'd'),
(18, 'Bella Powell', 'E00163', 'Director', 'Finance', 'Research & Development', 'a'),
(19, 'Camila Silva', 'E00884', 'Sr. Manger', 'Marketing', 'Speciality Products', 'b'),
(20, 'David Barnes', 'E04116', 'Director', 'IT', 'Corporate', 'c'),
(21, 'Adam Dang', 'E04625', 'Director', 'Sales', 'Research & Development', 'd'),
(22, 'Elias Alvarado', 'E03680', 'Sr. Manger', 'IT', 'Manufacturing', 'a'),
(23, 'Eva Rivera', 'E04732', 'Director', 'Sales', 'Manufacturing', 'b'),
(24, 'Logan Rivera', 'E03484', 'Director', 'IT', 'Research & Development', 'c'),
(25, 'Leonardo Dixon', 'E00671', 'Analyst', 'Sales', 'Speciality Products', 'd'),
(26, 'Mateo Her', 'E02071', 'Vice President', 'Sales', 'Speciality Products', 'a'),
(27, 'Jose Henderson', 'E02206', 'Director', 'Human Resources', 'Speciality Products', 'b'),
(28, 'Abigail Mejia', 'E04545', 'Quality Engineer', 'Engineering', 'Corporate', 'c'),
(29, 'Wyatt Chin', 'E00154', 'Vice President', 'Engineering', 'Speciality Products', 'd'),
(30, 'Carson Lu', 'E03343', 'Engineering Manager', 'Engineering', 'Speciality Products', 'a'),
(31, 'Dylan Choi', 'E00304', 'Vice President', 'IT', 'Corporate', 'b'),
(32, 'Ezekiel Kumar', 'E02594', 'IT Coordinator', 'IT', 'Research & Development', 'c'),
(33, 'Dominic Guzman', 'E00402', 'Analyst', 'Finance', 'Manufacturing', 'd'),
(34, 'Angel Powell', 'E01994', 'Analyst II', 'Sales', 'Research & Development', 'a'),
(35, 'Mateo Vu', 'E03549', 'Account Representative', 'Sales', 'Speciality Products', 'b'),
(36, 'Caroline Jenkins', 'E03247', 'Analyst', 'Finance', 'Research & Development', 'c'),
(37, 'Nora Brown', 'E02074', 'Enterprise Architect', 'IT', 'Manufacturing', 'd'),
(38, 'Adeline Huang', 'E04152', 'Controls Engineer', 'Engineering', 'Manufacturing', 'a'),
(39, 'Jackson Perry', 'E01628', 'Vice President', 'Marketing', 'Research & Development', 'b'),
(40, 'Riley Padilla', 'E04285', 'Technical Architect', 'IT', 'Manufacturing', 'c'),
(41, 'Leah Pena', 'E01417', 'Enterprise Architect', 'IT', 'Corporate', 'd'),
(42, 'Owen Lam', 'E01754', 'Sr. Business Partner', 'Human Resources', 'Speciality Products', 'a'),
(43, 'Kennedy Foster', 'E03749', 'Manager', 'Marketing', 'Speciality Products', 'b'),
(44, 'John Moore', 'E03574', 'Vice President', 'IT', 'Speciality Products', 'c'),
(45, 'William Vu', 'E04600', 'Account Representative', 'Sales', 'Speciality Products', 'd'),
(46, 'Sadie Washington', 'E00586', 'Sr. Manger', 'Marketing', 'Research & Development', 'a'),
(47, 'Gabriel Holmes', 'E03538', 'Enterprise Architect', 'IT', 'Research & Development', 'b'),
(48, 'Wyatt Rojas', 'E02185', 'Computer Systems Manager', 'IT', 'Corporate', 'c'),
(49, 'Eva Coleman', 'E03830', 'Director', 'IT', 'Research & Development', 'd'),
(50, 'Dominic Clark', 'E03720', 'Quality Engineer', 'Engineering', 'Research & Development', 'a'),
(51, 'Lucy Alexander', 'E03025', 'Director', 'Engineering', 'Manufacturing', 'b'),
(52, 'Everleigh Washington', 'E04917', 'HRIS Analyst', 'Human Resources', 'Research & Development', 'c'),
(53, 'Leilani Butler', 'E00415', 'Analyst II', 'Marketing', 'Manufacturing', 'd'),
(54, 'Peyton Huang', 'E02862', 'Sr. Manger', 'IT', 'Manufacturing', 'a'),
(55, 'John Contreras', 'E04207', 'Analyst II', 'Marketing', 'Manufacturing', 'Marketing'),
(56, 'Rylee Yu', 'E02139', 'Director', 'Accounting', 'Research & Development', 'c'),
(57, 'Piper Lewis', 'E01797', 'Field Engineer', 'Engineering', 'Research & Development', 'd'),
(58, 'Stella Alexander', 'E01839', 'Automation Engineer', 'Engineering', 'Corporate', 'a'),
(59, 'Addison Do', 'E01633', 'Operations Engineer', 'Engineering', 'Manufacturing', 'b'),
(60, 'Zoey Jackson', 'E01848', 'Business Partner', 'Human Resources', 'Manufacturing', 'c'),
(61, 'John Chow', 'E00716', 'Sr. Manger', 'Marketing', 'Research & Development', 'd'),
(62, 'Ava Ayala', 'E00699', 'Sr. Manger', 'IT', 'Corporate', 'a'),
(63, 'Natalia Salazar', 'E00502', 'Sr. Analyst', 'Accounting', 'Manufacturing', 'b'),
(64, 'Skylar Carrillo', 'E04000', 'Engineering Manager', 'Engineering', 'Corporate', 'c'),
(65, 'Christian Sanders', 'E02112', 'Vice President', 'Human Resources', 'Speciality Products', 'd'),
(66, 'Penelope Coleman', 'E03824', 'Analyst', 'Finance', 'Corporate', 'a'),
(67, 'Piper Richardson', 'E03906', 'Sr. Analyst', 'Sales', 'Corporate', 'b'),
(68, 'Everly Walker', 'E00436', 'HRIS Analyst', 'Human Resources', 'Speciality Products', 'Speciality Products'),
(69, 'Aurora Ali', 'E04798', 'Manager', 'Marketing', 'Research & Development', 'd'),
(70, 'Penelope Guerrero', 'E01249', 'Vice President', 'IT', 'Speciality Products', 'a'),
(71, 'Anna Mehta', 'E03349', 'Cloud Infrastructure Architect', 'IT', 'Speciality Products', 'b'),
(72, 'William Foster', 'E02966', 'Field Engineer', 'Engineering', 'Manufacturing', 'c'),
(73, 'Jade Rojas', 'E01499', 'Director', 'Finance', 'Speciality Products', 'd'),
(74, 'Isla Espinoza', 'E00105', 'Manager', 'Accounting', 'Speciality Products', 'a'),
(75, 'David Chu', 'E00665', 'Controls Engineer', 'Engineering', 'Corporate', 'E00665'),
(76, 'Thomas Padilla', 'E00791', 'Vice President', 'Marketing', 'Research & Development', 'c'),
(77, 'Miles Salazar', 'E01540', 'IT Coordinator', 'IT', 'Manufacturing', 'd'),
(78, 'Mila Hong', 'E04474', 'Test Engineer', 'Engineering', 'Research & Development', 'a'),
(79, 'Benjamin Moua', 'E03417', 'Computer Systems Manager', 'IT', 'Manufacturing', 'b'),
(80, 'Samuel Morales', 'E00254', 'Analyst II', 'Finance', 'Corporate', 'c'),
(81, 'John Soto', 'E02166', 'Sr. Manger', 'Finance', 'Manufacturing', 'd'),
(82, 'Joseph Martin', 'E00935', 'Analyst II', 'Marketing', 'Corporate', 'a'),
(83, 'Jose Ross', 'E01525', 'Engineering Manager', 'Engineering', 'Research & Development', 'b'),
(84, 'Parker James', 'E00386', 'Quality Engineer', 'Engineering', 'Speciality Products', 'c'),
(85, 'Everleigh Fernandez', 'E00416', 'Director', 'Engineering', 'Research & Development', 'd'),
(86, 'Lincoln Hall', 'E03383', 'Director', 'Accounting', 'Speciality Products', 'a'),
(87, 'Willow Mai', 'E01516', 'Business Partner', 'Human Resources', 'Manufacturing', 'b'),
(88, 'Jack Cheng', 'E01234', 'Director', 'Human Resources', 'Manufacturing', 'c'),
(89, 'Genesis Navarro', 'E03440', 'Cloud Infrastructure Architect', 'IT', 'Corporate', 'd'),
(90, 'Eliza Hernandez', 'E00431', 'Network Architect', 'IT', 'Corporate', 'a'),
(91, 'Gabriel Brooks', 'E01258', 'Network Engineer', 'IT', 'Manufacturing', 'b'),
(92, 'Jack Huynh', 'E00440', 'Manager', 'Marketing', 'Research & Development', 'c'),
(93, 'Everly Chow', 'E00595', 'Sr. Manger', 'Finance', 'Speciality Products', 'd'),
(94, 'Amelia Salazar', 'E00972', 'Analyst II', 'Finance', 'Corporate', 'a'),
(95, 'Xavier Zheng', 'E04562', 'Account Representative', 'Sales', 'Manufacturing', 'b'),
(96, 'Matthew Chau', 'E02802', 'Sr. Business Partner', 'Human Resources', 'Research & Development', 'c'),
(97, 'Mia Cheng', 'E01427', 'Sr. Manger', 'Sales', 'Manufacturing', 'd'),
(98, 'Rylee Yu', 'E04568', 'Vice President', 'Finance', 'Speciality Products', 'a'),
(99, 'Zoe Romero', 'E04931', 'Network Architect', 'IT', 'Manufacturing', 'b'),
(100, 'Nolan Bui', 'E00443', 'Computer Systems Manager', 'IT', 'Research & Development', 'c'),
(101, 'Nevaeh Jones', 'E03890', 'Vice President', 'Sales', 'Manufacturing', 'd'),
(102, 'Samantha Adams', 'E01194', 'Test Engineer', 'Engineering', 'Research & Development', 'a'),
(103, 'Madeline Shin', 'E02875', 'Computer Systems Manager', 'IT', 'Speciality Products', 'b'),
(104, 'Noah King', 'E04959', 'Development Engineer', 'Engineering', 'Speciality Products', 'c'),
(105, 'Leilani Chow', 'E03816', 'Director', 'Human Resources', 'Corporate', 'd');

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

--
-- Table structure for table `2025ndicdd222score`
--

DROP TABLE IF EXISTS `2025ndicdd222score`;
CREATE TABLE IF NOT EXISTS `2025ndicdd222score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2025ndicdd222score`
--

INSERT INTO `2025ndicdd222score` (`id`, `matric`, `fname`, `score`) VALUES
(1, '10', 'a10', 0);

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

--
-- Table structure for table `2024100levelana321score`
--

DROP TABLE IF EXISTS `2024100levelana321score`;
CREATE TABLE IF NOT EXISTS `2024100levelana321score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024100levelana321score`
--

INSERT INTO `2024100levelana321score` (`id`, `matric`, `fname`, `score`) VALUES
(1, 'GSCOTECH/22/ANA/0001', 'KOMOLAFE SEUN', 0);

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

--
-- Table structure for table `2024100levelbam312`
--

DROP TABLE IF EXISTS `2024100levelbam312`;
CREATE TABLE IF NOT EXISTS `2024100levelbam312` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` text NOT NULL,
  `opt1` varchar(255) NOT NULL,
  `opt2` varchar(255) NOT NULL,
  `opt3` varchar(255) NOT NULL,
  `opt4` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024100levelbam312`
--

INSERT INTO `2024100levelbam312` (`id`, `qst`, `opt1`, `opt2`, `opt3`, `opt4`, `ans`) VALUES
(1, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(2, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(3, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(4, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(5, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(6, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(7, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(8, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(9, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(10, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(11, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(12, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(13, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(14, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(15, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(16, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(17, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(18, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(19, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(20, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(21, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(22, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(23, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(24, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(25, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(26, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(27, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(28, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(29, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(30, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(31, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(32, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(33, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(34, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(35, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(36, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(37, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(38, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(39, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(40, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(41, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(42, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(43, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(44, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(45, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(46, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(47, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(48, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(49, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(50, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(51, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b');

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

--
-- Table structure for table `2024100levelbam312score`
--

DROP TABLE IF EXISTS `2024100levelbam312score`;
CREATE TABLE IF NOT EXISTS `2024100levelbam312score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024100levelbam312score`
--

INSERT INTO `2024100levelbam312score` (`id`, `matric`, `fname`, `score`) VALUES
(1, 'CC', 'kolade', 6),
(2, 'dd', 'titi', 6),
(3, 'BB', 'olasoji', 12);

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

--
-- Table structure for table `2024100levelbio222score`
--

DROP TABLE IF EXISTS `2024100levelbio222score`;
CREATE TABLE IF NOT EXISTS `2024100levelbio222score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `2024100leveleng111`
--

DROP TABLE IF EXISTS `2024100leveleng111`;
CREATE TABLE IF NOT EXISTS `2024100leveleng111` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` text NOT NULL,
  `opt1` varchar(255) NOT NULL,
  `opt2` varchar(255) NOT NULL,
  `opt3` varchar(255) NOT NULL,
  `opt4` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024100leveleng111`
--

INSERT INTO `2024100leveleng111` (`id`, `qst`, `opt1`, `opt2`, `opt3`, `opt4`, `ans`) VALUES
(1, '1', '2', '3', '4', '5', 'A'),
(2, '2', '3', '4', '5', '6', 'b'),
(3, '5', 'jhg', 'jhh', 'jhj', 'jgj', 'a'),
(4, 'nmmn', 'mmn,m', 'm,m', ',mn,', 'm,mn,', ''),
(5, 'nkjk', 'kkjj', 'lkjlkjlk', 'jjlkjl', 'jljl', ''),
(6, 'klknlk', 'nlknlkn', 'knlknl', 'nklnlknl', 'nlknl', ''),
(7, 'jnkjkjn', 'jnjknkjn', 'kjnkjnk', 'kjnkjnk', 'jnkjn', ''),
(8, 'm m, ', ' m, ,m ', ',m ,m ', ', , ', ' m,, ', ''),
(9, 'yuyy', 'uyiuyi', 'yiuyiuy', 'iyiyi', 'iiui', ''),
(10, 'u', 'i', 'io', 'io', 'iiui', ''),
(11, 'yhe', 'ji', 'ji', 'dv', 'bd', ''),
(12, 'ukj', 'nj', 'lk;', ';l', ';l', ''),
(13, '1', '2', '3', '4', '5', 'A'),
(14, '2', '3', '4', '5', '6', 'b'),
(15, '5', 'jhg', 'jhh', 'jhj', 'jgj', 'a'),
(16, 'nmmn', 'mmn,m', 'm,m', ',mn,', 'm,mn,', ''),
(17, 'nkjk', 'kkjj', 'lkjlkjlk', 'jjlkjl', 'jljl', ''),
(18, 'klknlk', 'nlknlkn', 'knlknl', 'nklnlknl', 'nlknl', ''),
(19, 'jnkjkjn', 'jnjknkjn', 'kjnkjnk', 'kjnkjnk', 'jnkjn', ''),
(20, 'm m, ', ' m, ,m ', ',m ,m ', ', , ', ' m,, ', ''),
(21, 'yuyy', 'uyiuyi', 'yiuyiuy', 'iyiyi', 'iiui', ''),
(22, 'u', 'i', 'io', 'io', 'iiui', ''),
(23, 'yhe', 'ji', 'ji', 'dv', 'bd', ''),
(24, 'ukj', 'nj', 'lk;', ';l', ';l', '');

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

--
-- Table structure for table `2024100leveleng111score`
--

DROP TABLE IF EXISTS `2024100leveleng111score`;
CREATE TABLE IF NOT EXISTS `2024100leveleng111score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `2024100levelpo111`
--

DROP TABLE IF EXISTS `2024100levelpo111`;
CREATE TABLE IF NOT EXISTS `2024100levelpo111` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` text NOT NULL,
  `opt1` varchar(255) NOT NULL,
  `opt2` varchar(255) NOT NULL,
  `opt3` varchar(255) NOT NULL,
  `opt4` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024100levelpo111`
--

INSERT INTO `2024100levelpo111` (`id`, `qst`, `opt1`, `opt2`, `opt3`, `opt4`, `ans`) VALUES
(1, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(2, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(3, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(4, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(5, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(6, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(7, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(8, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(9, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(10, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(11, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(12, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(13, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(14, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(15, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(16, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(17, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn'),
(18, 'what', 'ffg', 'dfgdgf', 'dfdgd', 'vbnvn', 'vbnvn');

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

--
-- Table structure for table `2024100levelpo111score`
--

DROP TABLE IF EXISTS `2024100levelpo111score`;
CREATE TABLE IF NOT EXISTS `2024100levelpo111score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `2024200levelbam312`
--

DROP TABLE IF EXISTS `2024200levelbam312`;
CREATE TABLE IF NOT EXISTS `2024200levelbam312` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` text NOT NULL,
  `opt1` varchar(255) NOT NULL,
  `opt2` varchar(255) NOT NULL,
  `opt3` varchar(255) NOT NULL,
  `opt4` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024200levelbam312`
--

INSERT INTO `2024200levelbam312` (`id`, `qst`, `opt1`, `opt2`, `opt3`, `opt4`, `ans`) VALUES
(1, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(2, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(3, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(4, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c'),
(5, 'who is the first man ', 'abraham', 'job', 'john', 'david', 'a'),
(6, 'who is a teacher ', 'oga', 'none ', 'student', 'boy', 'a'),
(7, 'where is esaoke located at', 'Ijebu', 'Osun', 'Ondo', 'ekiti', 'b'),
(8, 'Where is OSUN', 'Lagos', 'ONDO', 'Nigeria', 'none', 'c');

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

--
-- Table structure for table `2024200levelbam312score`
--

DROP TABLE IF EXISTS `2024200levelbam312score`;
CREATE TABLE IF NOT EXISTS `2024200levelbam312score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024200levelbam312score`
--

INSERT INTO `2024200levelbam312score` (`id`, `matric`, `fname`, `score`) VALUES
(1, '123', 'Admin_Test', 4),
(2, '124', 'oladeji', 9);

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

--
-- Table structure for table `2024400levelkaa111`
--

DROP TABLE IF EXISTS `2024400levelkaa111`;
CREATE TABLE IF NOT EXISTS `2024400levelkaa111` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` text NOT NULL,
  `opt1` varchar(255) NOT NULL,
  `opt2` varchar(255) NOT NULL,
  `opt3` varchar(255) NOT NULL,
  `opt4` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024400levelkaa111`
--

INSERT INTO `2024400levelkaa111` (`id`, `qst`, `opt1`, `opt2`, `opt3`, `opt4`, `ans`) VALUES
(1, 'Full Name', 'EEID', 'Job Title', 'Department', 'Business Unit', ''),
(2, 'Emily Davis', 'E02387', 'Sr. Manger', 'IT', 'Research & Development', 'Research & Development'),
(3, 'Theodore Dinh', 'E04105', 'Technical Architect', 'IT', 'Manufacturing', 'Manufacturing'),
(4, 'Luna Sanders', 'E02572', 'Director', 'Finance', 'Speciality Products', 'c'),
(5, 'Penelope Jordan', 'E02832', 'Computer Systems Manager', 'IT', 'Manufacturing', 'd'),
(6, 'Austin Vo', 'E01639', 'Sr. Analyst', 'Finance', 'Manufacturing', 'a'),
(7, 'Joshua Gupta', 'E00644', 'Account Representative', 'Sales', 'Corporate', 'b'),
(8, 'Ruby Barnes', 'E01550', 'Manager', 'IT', 'Corporate', 'c'),
(9, 'Luke Martin', 'E04332', 'Analyst', 'Finance', 'Manufacturing', 'd'),
(10, 'Easton Bailey', 'E04533', 'Manager', 'Accounting', 'Manufacturing', 'a'),
(11, 'Madeline Walker', 'E03838', 'Sr. Analyst', 'Finance', 'Speciality Products', 'b'),
(12, 'Savannah Ali', 'E00591', 'Sr. Manger', 'Human Resources', 'Manufacturing', 'c'),
(13, 'Camila Rogers', 'E03344', 'Controls Engineer', 'Engineering', 'Speciality Products', 'd'),
(14, 'Eli Jones', 'E00530', 'Manager', 'Human Resources', 'Manufacturing', 'Manufacturing'),
(15, 'Everleigh Ng', 'E04239', 'Sr. Manger', 'Finance', 'Research & Development', 'b'),
(16, 'Robert Yang', 'E03496', 'Sr. Analyst', 'Accounting', 'Speciality Products', 'c'),
(17, 'Isabella Xi', 'E00549', 'Vice President', 'Marketing', 'Research & Development', 'd'),
(18, 'Bella Powell', 'E00163', 'Director', 'Finance', 'Research & Development', 'a'),
(19, 'Camila Silva', 'E00884', 'Sr. Manger', 'Marketing', 'Speciality Products', 'b'),
(20, 'David Barnes', 'E04116', 'Director', 'IT', 'Corporate', 'c'),
(21, 'Adam Dang', 'E04625', 'Director', 'Sales', 'Research & Development', 'd'),
(22, 'Elias Alvarado', 'E03680', 'Sr. Manger', 'IT', 'Manufacturing', 'a'),
(23, 'Eva Rivera', 'E04732', 'Director', 'Sales', 'Manufacturing', 'b'),
(24, 'Logan Rivera', 'E03484', 'Director', 'IT', 'Research & Development', 'c'),
(25, 'Leonardo Dixon', 'E00671', 'Analyst', 'Sales', 'Speciality Products', 'd'),
(26, 'Mateo Her', 'E02071', 'Vice President', 'Sales', 'Speciality Products', 'a'),
(27, 'Jose Henderson', 'E02206', 'Director', 'Human Resources', 'Speciality Products', 'b'),
(28, 'Abigail Mejia', 'E04545', 'Quality Engineer', 'Engineering', 'Corporate', 'c'),
(29, 'Wyatt Chin', 'E00154', 'Vice President', 'Engineering', 'Speciality Products', 'd'),
(30, 'Carson Lu', 'E03343', 'Engineering Manager', 'Engineering', 'Speciality Products', 'a'),
(31, 'Dylan Choi', 'E00304', 'Vice President', 'IT', 'Corporate', 'b'),
(32, 'Ezekiel Kumar', 'E02594', 'IT Coordinator', 'IT', 'Research & Development', 'c'),
(33, 'Dominic Guzman', 'E00402', 'Analyst', 'Finance', 'Manufacturing', 'd'),
(34, 'Angel Powell', 'E01994', 'Analyst II', 'Sales', 'Research & Development', 'a'),
(35, 'Mateo Vu', 'E03549', 'Account Representative', 'Sales', 'Speciality Products', 'b'),
(36, 'Caroline Jenkins', 'E03247', 'Analyst', 'Finance', 'Research & Development', 'c'),
(37, 'Nora Brown', 'E02074', 'Enterprise Architect', 'IT', 'Manufacturing', 'd'),
(38, 'Adeline Huang', 'E04152', 'Controls Engineer', 'Engineering', 'Manufacturing', 'a'),
(39, 'Jackson Perry', 'E01628', 'Vice President', 'Marketing', 'Research & Development', 'b'),
(40, 'Riley Padilla', 'E04285', 'Technical Architect', 'IT', 'Manufacturing', 'c'),
(41, 'Leah Pena', 'E01417', 'Enterprise Architect', 'IT', 'Corporate', 'd'),
(42, 'Owen Lam', 'E01754', 'Sr. Business Partner', 'Human Resources', 'Speciality Products', 'a'),
(43, 'Kennedy Foster', 'E03749', 'Manager', 'Marketing', 'Speciality Products', 'b'),
(44, 'John Moore', 'E03574', 'Vice President', 'IT', 'Speciality Products', 'c'),
(45, 'William Vu', 'E04600', 'Account Representative', 'Sales', 'Speciality Products', 'd'),
(46, 'Sadie Washington', 'E00586', 'Sr. Manger', 'Marketing', 'Research & Development', 'a'),
(47, 'Gabriel Holmes', 'E03538', 'Enterprise Architect', 'IT', 'Research & Development', 'b'),
(48, 'Wyatt Rojas', 'E02185', 'Computer Systems Manager', 'IT', 'Corporate', 'c'),
(49, 'Eva Coleman', 'E03830', 'Director', 'IT', 'Research & Development', 'd'),
(50, 'Dominic Clark', 'E03720', 'Quality Engineer', 'Engineering', 'Research & Development', 'a'),
(51, 'Lucy Alexander', 'E03025', 'Director', 'Engineering', 'Manufacturing', 'b'),
(52, 'Everleigh Washington', 'E04917', 'HRIS Analyst', 'Human Resources', 'Research & Development', 'c'),
(53, 'Leilani Butler', 'E00415', 'Analyst II', 'Marketing', 'Manufacturing', 'd'),
(54, 'Peyton Huang', 'E02862', 'Sr. Manger', 'IT', 'Manufacturing', 'a'),
(55, 'John Contreras', 'E04207', 'Analyst II', 'Marketing', 'Manufacturing', 'Marketing'),
(56, 'Rylee Yu', 'E02139', 'Director', 'Accounting', 'Research & Development', 'c'),
(57, 'Piper Lewis', 'E01797', 'Field Engineer', 'Engineering', 'Research & Development', 'd'),
(58, 'Stella Alexander', 'E01839', 'Automation Engineer', 'Engineering', 'Corporate', 'a'),
(59, 'Addison Do', 'E01633', 'Operations Engineer', 'Engineering', 'Manufacturing', 'b'),
(60, 'Zoey Jackson', 'E01848', 'Business Partner', 'Human Resources', 'Manufacturing', 'c'),
(61, 'John Chow', 'E00716', 'Sr. Manger', 'Marketing', 'Research & Development', 'd'),
(62, 'Ava Ayala', 'E00699', 'Sr. Manger', 'IT', 'Corporate', 'a'),
(63, 'Natalia Salazar', 'E00502', 'Sr. Analyst', 'Accounting', 'Manufacturing', 'b'),
(64, 'Skylar Carrillo', 'E04000', 'Engineering Manager', 'Engineering', 'Corporate', 'c'),
(65, 'Christian Sanders', 'E02112', 'Vice President', 'Human Resources', 'Speciality Products', 'd'),
(66, 'Penelope Coleman', 'E03824', 'Analyst', 'Finance', 'Corporate', 'a'),
(67, 'Piper Richardson', 'E03906', 'Sr. Analyst', 'Sales', 'Corporate', 'b'),
(68, 'Everly Walker', 'E00436', 'HRIS Analyst', 'Human Resources', 'Speciality Products', 'Speciality Products'),
(69, 'Aurora Ali', 'E04798', 'Manager', 'Marketing', 'Research & Development', 'd'),
(70, 'Penelope Guerrero', 'E01249', 'Vice President', 'IT', 'Speciality Products', 'a'),
(71, 'Anna Mehta', 'E03349', 'Cloud Infrastructure Architect', 'IT', 'Speciality Products', 'b'),
(72, 'William Foster', 'E02966', 'Field Engineer', 'Engineering', 'Manufacturing', 'c'),
(73, 'Jade Rojas', 'E01499', 'Director', 'Finance', 'Speciality Products', 'd'),
(74, 'Isla Espinoza', 'E00105', 'Manager', 'Accounting', 'Speciality Products', 'a'),
(75, 'David Chu', 'E00665', 'Controls Engineer', 'Engineering', 'Corporate', 'E00665'),
(76, 'Thomas Padilla', 'E00791', 'Vice President', 'Marketing', 'Research & Development', 'c'),
(77, 'Miles Salazar', 'E01540', 'IT Coordinator', 'IT', 'Manufacturing', 'd'),
(78, 'Mila Hong', 'E04474', 'Test Engineer', 'Engineering', 'Research & Development', 'a'),
(79, 'Benjamin Moua', 'E03417', 'Computer Systems Manager', 'IT', 'Manufacturing', 'b'),
(80, 'Samuel Morales', 'E00254', 'Analyst II', 'Finance', 'Corporate', 'c'),
(81, 'John Soto', 'E02166', 'Sr. Manger', 'Finance', 'Manufacturing', 'd'),
(82, 'Joseph Martin', 'E00935', 'Analyst II', 'Marketing', 'Corporate', 'a'),
(83, 'Jose Ross', 'E01525', 'Engineering Manager', 'Engineering', 'Research & Development', 'b'),
(84, 'Parker James', 'E00386', 'Quality Engineer', 'Engineering', 'Speciality Products', 'c'),
(85, 'Everleigh Fernandez', 'E00416', 'Director', 'Engineering', 'Research & Development', 'd'),
(86, 'Lincoln Hall', 'E03383', 'Director', 'Accounting', 'Speciality Products', 'a'),
(87, 'Willow Mai', 'E01516', 'Business Partner', 'Human Resources', 'Manufacturing', 'b'),
(88, 'Jack Cheng', 'E01234', 'Director', 'Human Resources', 'Manufacturing', 'c'),
(89, 'Genesis Navarro', 'E03440', 'Cloud Infrastructure Architect', 'IT', 'Corporate', 'd'),
(90, 'Eliza Hernandez', 'E00431', 'Network Architect', 'IT', 'Corporate', 'a'),
(91, 'Gabriel Brooks', 'E01258', 'Network Engineer', 'IT', 'Manufacturing', 'b'),
(92, 'Jack Huynh', 'E00440', 'Manager', 'Marketing', 'Research & Development', 'c'),
(93, 'Everly Chow', 'E00595', 'Sr. Manger', 'Finance', 'Speciality Products', 'd'),
(94, 'Amelia Salazar', 'E00972', 'Analyst II', 'Finance', 'Corporate', 'a'),
(95, 'Xavier Zheng', 'E04562', 'Account Representative', 'Sales', 'Manufacturing', 'b'),
(96, 'Matthew Chau', 'E02802', 'Sr. Business Partner', 'Human Resources', 'Research & Development', 'c'),
(97, 'Mia Cheng', 'E01427', 'Sr. Manger', 'Sales', 'Manufacturing', 'd'),
(98, 'Rylee Yu', 'E04568', 'Vice President', 'Finance', 'Speciality Products', 'a'),
(99, 'Zoe Romero', 'E04931', 'Network Architect', 'IT', 'Manufacturing', 'b'),
(100, 'Nolan Bui', 'E00443', 'Computer Systems Manager', 'IT', 'Research & Development', 'c'),
(101, 'Nevaeh Jones', 'E03890', 'Vice President', 'Sales', 'Manufacturing', 'd'),
(102, 'Samantha Adams', 'E01194', 'Test Engineer', 'Engineering', 'Research & Development', 'a'),
(103, 'Madeline Shin', 'E02875', 'Computer Systems Manager', 'IT', 'Speciality Products', 'b'),
(104, 'Noah King', 'E04959', 'Development Engineer', 'Engineering', 'Speciality Products', 'c'),
(105, 'Leilani Chow', 'E03816', 'Director', 'Human Resources', 'Corporate', 'd');

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

--
-- Table structure for table `2024400levelkaa111score`
--

DROP TABLE IF EXISTS `2024400levelkaa111score`;
CREATE TABLE IF NOT EXISTS `2024400levelkaa111score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `2024400levelkaa111score`
--

INSERT INTO `2024400levelkaa111score` (`id`, `matric`, `fname`, `score`) VALUES
(3, 'gsco/1', 'komolafe', 0),
(4, 'gsco/2', 'olasoji', 0),
(5, 'gsco/12345', 'MALIK', 3),
(9, 'BB', 'olasoji', 0),
(10, 'CC', 'kolade', 1),
(11, 'DD', 'titi', 0),
(12, '9', 'a9', 0);

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

--
-- Table structure for table `2025100levelggg111`
--

DROP TABLE IF EXISTS `2025100levelggg111`;
CREATE TABLE IF NOT EXISTS `2025100levelggg111` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` text NOT NULL,
  `opt1` varchar(255) NOT NULL,
  `opt2` varchar(255) NOT NULL,
  `opt3` varchar(255) NOT NULL,
  `opt4` varchar(255) NOT NULL,
  `ans` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `2025100levelggg111score`
--

DROP TABLE IF EXISTS `2025100levelggg111score`;
CREATE TABLE IF NOT EXISTS `2025100levelggg111score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(20) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `score` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` varchar(50) NOT NULL,
  `chosen` varchar(50) NOT NULL,
  `correct` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `answers_record`
--

DROP TABLE IF EXISTS `answers_record`;
CREATE TABLE IF NOT EXISTS `answers_record` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(50) NOT NULL,
  `question_id` int NOT NULL,
  `chosen_option` varchar(255) NOT NULL,
  `correct_option` varchar(255) NOT NULL,
  `is_correct` tinyint(1) DEFAULT '0',
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`)
) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `answers_record`
--

INSERT INTO `answers_record` (`id`, `matric`, `question_id`, `chosen_option`, `correct_option`, `is_correct`, `timestamp`) VALUES
(67, 'CC', 73, 'Speciality Products', 'd', 0, '2025-03-06 07:50:13'),
(68, 'CC', 103, 'IT', 'b', 0, '2025-03-06 07:51:03'),
(66, 'CC', 39, 'Research & Development', 'b', 0, '2025-03-06 07:50:29'),
(65, 'CC', 33, 'Finance', 'd', 0, '2025-03-03 08:47:37'),
(64, 'CC', 77, 'Manufacturing', 'd', 0, '2025-03-03 08:47:30'),
(54, 'BB', 26, 'Vice President', 'a', 0, '2025-03-02 21:56:03'),
(53, 'BB', 36, 'Research & Development', 'c', 0, '2025-03-02 21:56:00'),
(52, 'BB', 13, 'Engineering', 'd', 0, '2025-03-02 21:55:57'),
(51, 'BB', 7, 'Account Representative', 'b', 0, '2025-03-02 21:55:51'),
(50, 'CC', 18, 'Finance', 'a', 0, '2025-03-02 21:43:32'),
(63, 'CC', 32, 'E02594', 'c', 0, '2025-03-03 08:47:06'),
(48, 'CC', 60, 'Manufacturing', 'c', 0, '2025-03-02 21:33:17'),
(47, 'CC', 48, 'Computer Systems Manager', 'c', 0, '2025-03-02 21:33:12');

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

--
-- Table structure for table `questionbase`
--

DROP TABLE IF EXISTS `questionbase`;
CREATE TABLE IF NOT EXISTS `questionbase` (
  `id` int NOT NULL AUTO_INCREMENT,
  `qst` varchar(1000) NOT NULL,
  `opt1` varchar(1000) NOT NULL,
  `opt2` varchar(1000) NOT NULL,
  `opt3` varchar(1000) NOT NULL,
  `opt4` varchar(1000) NOT NULL,
  `ans` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `questionbase`
--

INSERT INTO `questionbase` (`id`, `qst`, `opt1`, `opt2`, `opt3`, `opt4`, `ans`) VALUES
(1, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'a'),
(2, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'b'),
(3, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'c'),
(4, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'c'),
(5, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'd'),
(6, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'e'),
(7, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'b'),
(8, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'c'),
(9, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'c'),
(10, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'd'),
(11, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'a'),
(12, 'Who is a boy', 'ada', 'kola', 'oye', 'titi', 'b');

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

--
-- Table structure for table `question_log`
--

DROP TABLE IF EXISTS `question_log`;
CREATE TABLE IF NOT EXISTS `question_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `level` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `course_title` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `course_code` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `question_level` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `question_level_score` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `question_log`
--

INSERT INTO `question_log` (`id`, `year`, `level`, `course_title`, `course_code`, `question_level`, `question_level_score`) VALUES
(15, '2024', '100level', 'computer application package', 'bam312', '2024100levelbam312', '2024100levelbam312score'),
(4, '2024', 'NDI', 'pro', 'pro123', '2024NDIpro123', '2024NDIpro123score'),
(16, '2024', '100level', 'english language', 'eng111', '2024100leveleng111', '2024100leveleng111score'),
(17, '2024', '100level', 'english language', 'eng111', '2024100leveleng111', '2024100leveleng111score'),
(14, '2024', '200level', 'computer application package', 'bam312', '2024200levelbam312', '2024200levelbam312score'),
(9, '2024', 'NDI', 'COMPUTER', 'COM222', '2024NDICOM222', '2024NDICOM222score'),
(20, '2024', '400level', 'kaaaa', 'kaa111', '2024400levelkaa111', '2024400levelkaa111score'),
(21, '2024', '100level', 'popopopo', 'po111', '2024100levelpo111', '2024100levelpo111score'),
(22, '2025', 'ndi', 'adminc nature', 'cdd222', '2025ndicdd222', '2025ndicdd222score');

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

--
-- Table structure for table `score_table`
--

DROP TABLE IF EXISTS `score_table`;
CREATE TABLE IF NOT EXISTS `score_table` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(1000) NOT NULL,
  `score` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `score_table`
--

INSERT INTO `score_table` (`id`, `matric`, `score`) VALUES
(1, '123', '17'),
(2, '124', '1');

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

--
-- Table structure for table `students`
--

DROP TABLE IF EXISTS `students`;
CREATE TABLE IF NOT EXISTS `students` (
  `id` int NOT NULL AUTO_INCREMENT,
  `matric` varchar(1000) NOT NULL,
  `fname` varchar(1000) NOT NULL,
  `level` varchar(100) NOT NULL,
  `dept` varchar(100) NOT NULL,
  `question_level` varchar(1000) NOT NULL,
  `question_level_score` varchar(1000) NOT NULL,
  `status` varchar(100) NOT NULL,
  `duration` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`id`, `matric`, `fname`, `level`, `dept`, `question_level`, `question_level_score`, `status`, `duration`) VALUES
(1, 'GSCOTECH/ATT/001', 'komolafe', '100LEVEL', 'Agric', '2024400levelkaa111', '2024400levelkaa111_score', '', '30'),
(2, 'BB', 'olasoji', '100LEVEL', 'Anatomy', '2024400levelkaa111', '2024400levelkaa111_score', '', '30'),
(3, 'CC', 'kolade', '100LEVEL', 'bankin', '2024400levelkaa111', '2024400levelkaa111_score', 'Attempted', '30'),
(4, 'DD', 'titi', '100LEVEL', 'Buss', '2024400levelkaa111', '2024400levelkaa111_score', 'Attempted', '30'),
(5, '1', 'who is the first man ', '200LEVEL', 'abraham', '2024NDICOM222', '2024NDICOM222_score', 'Attempted', '30'),
(6, '2', 'who is a teacher ', '200LEVEL', 'oga', '2024NDICOM222', '2024NDICOM222_score', 'Attempted', '30'),
(7, '3', 'where is esaoke located at', '200LEVEL', 'Ijebu', '2024NDICOM222', '2024NDICOM222_score', 'Attempted', '30'),
(8, '4', 'Where is OSUN', '200LEVEL', 'Lagos', '2024NDICOM222', '2024NDICOM222_score', '', '30'),
(9, '5', 'who is the first man ', '200LEVEL', 'abraham', '2024NDICOM222', '2024NDICOM222_score', '', '30'),
(10, '6', 'who is a teacher ', '200LEVEL', 'oga', '2024NDICOM222', '2024NDICOM222_score', '', '30'),
(11, '7', 'where is esaoke located at', '200LEVEL', 'Ijebu', '2024NDICOM222', '2024NDICOM222_score', '', '30'),
(12, '8', 'Where is OSUN', '200LEVEL', 'Lagos', '2024NDICOM222', '2024NDICOM222_score', '', '30'),
(13, '', 'where is esaoke located at', '200LEVEL', 'Ijebu', '2024NDICOM222', '2024NDICOM222_score', '', '30'),
(14, 'GSCO/1', 'komolafe', '400LEVEL', 'Agric', '2024400levelkaa111', '2024400levelkaa111_score', 'Attempted', '2'),
(15, 'GSCO/2', 'olasoji', '400LEVEL', 'Anatomy', '2024400levelkaa111', '2024400levelkaa111_score', 'Attempted', '2'),
(16, 'GSCO/3', 'kolade', '400LEVEL', 'bankin', '2024400levelkaa111', '2024400levelkaa111_score', '', '2'),
(17, 'GSCO/4', 'titi', '400LEVEL', 'Buss', '2024400levelkaa111', '2024400levelkaa111_score', '', '2'),
(18, 'GSCO/12345', 'ABDULMALIK', '100LEVEL', 'COMPUTER', '2024400levelkaa111', '2024400levelkaa111_score', '', '30'),
(19, '9', 'a9', 'NDI', 'uyuy', '2025ndicdd222', '2025ndicdd222_score', 'Attempted', '30'),
(20, '10', 'a10', 'NDI', 'lolo', '2025ndicdd222', '2025ndicdd222_score', 'Attempted', '30');

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

--
-- Table structure for table `table_setter`
--

DROP TABLE IF EXISTS `table_setter`;
CREATE TABLE IF NOT EXISTS `table_setter` (
  `id` int NOT NULL AUTO_INCREMENT,
  `level` varchar(1000) NOT NULL,
  `dept` varchar(1000) NOT NULL,
  `level_question` varchar(1000) NOT NULL,
  `level_score` varchar(1000) NOT NULL,
  `status` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `table_setter`
--

INSERT INTO `table_setter` (`id`, `level`, `dept`, `level_question`, `level_score`, `status`) VALUES
(1, 'NDI', 'computer science', '2025ndicdd222', '2025ndicdd222_score', 'active'),
(2, 'NDII', '', '2024NDICOM222', '2024NDICOM222_score', 'active'),
(3, 'HNDI', '', '', '', ''),
(4, 'HNDII', '', '2024400levelkaa111', '2024400levelkaa111_score', 'active'),
(5, 'RERUN NDI', '', '', '', '');

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

--
-- Table structure for table `timer`
--

DROP TABLE IF EXISTS `timer`;
CREATE TABLE IF NOT EXISTS `timer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `duration` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `timer`
--

INSERT INTO `timer` (`id`, `duration`) VALUES
(1, '30');
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 */;
