-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Oct 03, 2024 at 03:57 PM
-- 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=2 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);

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

--
-- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- 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 `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 `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 `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=16 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'),
(14, '2024', '200level', 'computer application package', 'bam312', '2024200levelbam312', '2024200levelbam312score'),
(9, '2024', 'NDI', 'COMPUTER', 'COM222', '2024NDICOM222', '2024NDICOM222score');

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

--
-- 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=9 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, '123', 'Admin_Test', '100LEVEL', 'agricultural Science', '2024NDICOM222', '2024NDICOM222_score', '', '10'),
(2, '125', 'kolapo', '100LEVEL', 'SOCIOLOGY', '2024NDICOM222', '2024NDICOM222_score', '', '10'),
(3, '124', 'oladeji', '100LEVEL', 'SOCIOLOGY Science', '2024NDICOM222', '2024NDICOM222_score', 'Attempted', '10'),
(4, '888', 'olamide', '100LEVEL', 'computer', '2024NDICOM222', '2024NDICOM222_score', '', '10'),
(5, 'GSCOTECH/22/ANA/0001', 'KOMOLAFE SEUN', '100LEVEL', 'ANATOMY', '2024NDICOM222', '2024NDICOM222_score', '', '10'),
(6, '111', 'komolafe', '100LEVEL', 'Agric', '2024NDICOM222', '2024NDICOM222_score', '', '10'),
(7, '222', 'olasoji', '100LEVEL', 'Anatomy Engineering', '2024NDICOM222', '2024NDICOM222_score', '', '10'),
(8, '142', 'titi', '100LEVEL', 'Buss', '2024NDICOM222', '2024NDICOM222_score', '', '10');

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

--
-- 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, '100LEVEL', 'computer science', '2024NDICOM222', '2024NDICOM222_score', 'active'),
(2, '200LEVEL', '', '2024NDICOM222', '2024NDICOM222_score', 'active'),
(3, '300LEVEL', '', '', '', ''),
(4, '400LEVEL', '', '', '', ''),
(5, '500LEVEL', '', '', '', '');

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

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