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

START TRANSACTION;



--
-- Database: `leolms`
--

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

--
-- Table structure for table `1002`
--

CREATE TABLE `1002` (
  `questionnos` int(3) NOT NULL,
  `questions` longtext NOT NULL,
  `A` varchar(20) NOT NULL,
  `B` varchar(33) NOT NULL,
  `C` varchar(33) NOT NULL,
  `D` varchar(33) NOT NULL,
  `ans` varchar(33) NOT NULL,
  `img` varchar(25) NOT NULL,
  `solimg` varchar(136) NOT NULL,
  `stack` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admincbt`
--

CREATE TABLE `admincbt` (
  `sno` int(11) NOT NULL,
  `subject` varchar(600) NOT NULL,
  `type` varchar(600) NOT NULL,
  `class` varchar(600) NOT NULL,
  `status` varchar(600) NOT NULL,
  `date` varchar(600) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `admincbt_`
--

CREATE TABLE `admincbt_` (
  `sno` int(11) NOT NULL,
  `subject` varchar(600) NOT NULL,
  `type` varchar(600) NOT NULL,
  `class` varchar(600) NOT NULL,
  `status` varchar(600) NOT NULL,
  `date` varchar(600) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admincbt_`
--

INSERT INTO `admincbt_` (`sno`, `subject`, `type`, `class`, `status`, `date`) VALUES
(18847, 'ROBOTICS', 'FIRST TEST', 'COD 23', 'NOT PUBLISHED', '2023-02-12'),
(85601, 'PYTHON', 'EXAMNITATION', 'COD24', 'NOT PUBLISHED', '2023-09-29');

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

--
-- Table structure for table `admincbt_1001`
--

CREATE TABLE `admincbt_1001` (
  `sno` int(11) NOT NULL,
  `subject` varchar(600) NOT NULL,
  `type` varchar(600) NOT NULL,
  `class` varchar(600) NOT NULL,
  `status` varchar(600) NOT NULL,
  `date` varchar(600) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admincbt_1001`
--

INSERT INTO `admincbt_1001` (`sno`, `subject`, `type`, `class`, `status`, `date`) VALUES
(33096, 'Chemistry', 'FIRST TEST', 'ENVH', 'PUBLISHED', '2020-07-01');

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

--
-- Table structure for table `arm`
--

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

--
-- Dumping data for table `arm`
--

INSERT INTO `arm` (`id`, `arm`) VALUES
(1, '100L'),
(2, '200L'),
(3, '300L'),
(4, '400L'),
(5, '500L'),
(6, '600L'),
(7, '700L'),
(8, '800L');

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

--
-- Table structure for table `assignment`
--

CREATE TABLE `assignment` (
  `sno` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `topic_id` int(11) NOT NULL,
  `questions` varchar(500) NOT NULL,
  `file_location` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `assignment`
--

INSERT INTO `assignment` (`sno`, `teacher_id`, `subject_id`, `topic_id`, `questions`, `file_location`, `class`, `arm`) VALUES
(1, 1003, 2, 1, 'sewqreqrerewe', '5ddfcde92c61a_1574948329.php', 'part-time', '100L');

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

--
-- Table structure for table `ass_`
--

CREATE TABLE `ass_` (
  `sno` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `subject_id` varchar(500) NOT NULL,
  `topic_id` varchar(600) NOT NULL,
  `questions` varchar(500) NOT NULL,
  `file_location` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ass_1002`
--

CREATE TABLE `ass_1002` (
  `sno` int(11) NOT NULL DEFAULT 0,
  `teacher_id` varchar(800) NOT NULL,
  `subject_id` varchar(800) NOT NULL,
  `topic_id` varchar(800) NOT NULL,
  `questions` varchar(500) NOT NULL,
  `file_location` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ass_1002`
--

INSERT INTO `ass_1002` (`sno`, `teacher_id`, `subject_id`, `topic_id`, `questions`, `file_location`, `class`, `arm`) VALUES
(1, '1003', '2', '1', 'sewqreqrerewe', '5ddfcde92c61a_1574948329.php', 'part-time', '100L'),
(2, '1002', 'ROBOTICS', 'ARDUINO PROGRAMMING', 'Answer the questions ', '63e9856e064e1_1676248430.docx', 'COD 23', '1');

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

--
-- Table structure for table `cbt`
--

CREATE TABLE `cbt` (
  `sno` int(11) NOT NULL,
  `question` varchar(400) NOT NULL,
  `answer` varchar(400) NOT NULL,
  `file` varchar(400) NOT NULL,
  `cc1` int(11) NOT NULL,
  `cc2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cbt_`
--

CREATE TABLE `cbt_` (
  `serialno` varchar(9) NOT NULL,
  `subjects` varchar(500) NOT NULL,
  `class` varchar(15) NOT NULL,
  `type` varchar(123) NOT NULL,
  `date` varchar(24) NOT NULL,
  `extime` int(23) NOT NULL,
  `stdate` varchar(34) NOT NULL,
  `endate` varchar(34) NOT NULL,
  `examref` varchar(500) NOT NULL,
  `title` varchar(400) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `cbt_cod 23`
--

CREATE TABLE `cbt_cod 23` (
  `serialno` varchar(9) NOT NULL,
  `subjects` varchar(35) NOT NULL,
  `class` varchar(15) NOT NULL,
  `type` varchar(123) NOT NULL,
  `date` varchar(24) NOT NULL,
  `extime` int(23) NOT NULL,
  `stdate` varchar(34) NOT NULL,
  `endate` varchar(34) NOT NULL,
  `examref` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cbt_cod 23`
--

INSERT INTO `cbt_cod 23` (`serialno`, `subjects`, `class`, `type`, `date`, `extime`, `stdate`, `endate`, `examref`) VALUES
('1', 'ROBOTICS', 'COD 23', 'FIRST TEST', '2023-02-12', 1200, '2023-02-12', '2023-02-14', '18847');

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

--
-- Table structure for table `cbt_cod24`
--

CREATE TABLE `cbt_cod24` (
  `serialno` varchar(9) CHARACTER SET latin1 NOT NULL,
  `subjects` varchar(35) CHARACTER SET latin1 NOT NULL,
  `class` varchar(15) CHARACTER SET latin1 NOT NULL,
  `type` varchar(123) CHARACTER SET latin1 NOT NULL,
  `date` varchar(24) CHARACTER SET latin1 NOT NULL,
  `extime` int(23) NOT NULL,
  `stdate` varchar(34) CHARACTER SET latin1 NOT NULL,
  `endate` varchar(34) CHARACTER SET latin1 NOT NULL,
  `examref` varchar(500) CHARACTER SET latin1 NOT NULL,
  `title` varchar(900) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cbt_cod24`
--

INSERT INTO `cbt_cod24` (`serialno`, `subjects`, `class`, `type`, `date`, `extime`, `stdate`, `endate`, `examref`, `title`) VALUES
('1', 'PYTHON', 'COD24', 'EXAMNITATION', '2023-09-29', 1200, '2023-09-29', '2024-09-18', '85601', 'PYTHON TOPICS 1-4');

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

--
-- Table structure for table `class`
--

CREATE TABLE `class` (
  `id` int(11) NOT NULL,
  `classes` varchar(500) NOT NULL,
  `clas` varchar(400) NOT NULL,
  `arm` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `class`
--

INSERT INTO `class` (`id`, `classes`, `clas`, `arm`) VALUES
(39, 'SCRATCH', 'COD23', ''),
(40, 'PYTHON', 'COD24', '1'),
(41, 'PYTHON AND ARTIFICIAL INTELLIGENCE', 'COD27', ''),
(42, 'APP DESIGN-KODULAR', 'COD44', ''),
(43, 'HTML,BOOTSTRAP AND WORDPRESS', 'COD48', '');

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

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

CREATE TABLE `classes` (
  `sno` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `subjects` varchar(500) NOT NULL,
  `score` varchar(500) NOT NULL,
  `remarks` varchar(500) NOT NULL,
  `v1` varchar(500) NOT NULL,
  `v2` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `classlms`
--

CREATE TABLE `classlms` (
  `class` varchar(400) NOT NULL,
  `arm` varchar(400) NOT NULL,
  `sno` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `classsubject`
--

CREATE TABLE `classsubject` (
  `sno` int(11) NOT NULL,
  `subjectname` varchar(500) NOT NULL,
  `ai` int(11) NOT NULL,
  `v1` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `fgvbh`
--

CREATE TABLE `fgvbh` (
  `BBB` int(11) NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `moyes shiva` int(11) NOT NULL,
  `NJM` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `isubjects`
--

CREATE TABLE `isubjects` (
  `sno` int(11) NOT NULL,
  `studentno` int(11) NOT NULL,
  `studentname` varchar(500) NOT NULL,
  `score` int(11) NOT NULL,
  `remark` varchar(500) NOT NULL,
  `status` varchar(500) NOT NULL,
  `v1` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `perf`
--

CREATE TABLE `perf` (
  `sno` varchar(700) NOT NULL,
  `name` varchar(500) NOT NULL,
  `subjects` varchar(700) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `score` varchar(500) NOT NULL,
  `status` varchar(500) NOT NULL,
  `vvv` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `perf_cod 2318847`
--

CREATE TABLE `perf_cod 2318847` (
  `sno` varchar(700) NOT NULL,
  `name` varchar(500) NOT NULL,
  `subjects` varchar(700) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `score` varchar(500) NOT NULL,
  `status` varchar(500) NOT NULL,
  `vvv` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `perf_cod2485601`
--

CREATE TABLE `perf_cod2485601` (
  `sno` varchar(700) CHARACTER SET latin1 NOT NULL,
  `name` varchar(500) CHARACTER SET latin1 NOT NULL,
  `subjects` varchar(700) CHARACTER SET latin1 NOT NULL,
  `class` varchar(500) CHARACTER SET latin1 NOT NULL,
  `arm` varchar(500) CHARACTER SET latin1 NOT NULL,
  `score` varchar(500) CHARACTER SET latin1 NOT NULL,
  `status` varchar(500) CHARACTER SET latin1 NOT NULL,
  `vvv` varchar(500) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `perf_cod2485601`
--

INSERT INTO `perf_cod2485601` (`sno`, `name`, `subjects`, `class`, `arm`, `score`, `status`, `vvv`) VALUES
('LCA/23/LCA/002', 'USHIADI ONYINYE', '', 'COD24', '1', '50', 'PASSED', ''),
('LCA/23/LCA/002', 'USHIADI ONYINYE', '', 'COD24', '1', '0', 'FAILED', ''),
('LCA/23/LCA/002', 'USHIADI ONYINYE', '', 'COD24', '1', '0', 'FAILED', '');

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

--
-- Table structure for table `perf_envh33096`
--

CREATE TABLE `perf_envh33096` (
  `sno` varchar(600) NOT NULL,
  `name` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `score` varchar(500) NOT NULL,
  `status` varchar(500) NOT NULL,
  `vvv` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `perf_envh33096`
--

INSERT INTO `perf_envh33096` (`sno`, `name`, `class`, `arm`, `score`, `status`, `vvv`) VALUES
('EHS/EHT/19/001', 'ALIYU IMADODE SERAH', 'ENVH', '100L', '50', 'PASSED', ''),
('0', 'ALIYU IMADODE SERAH', 'ENVH', '100L', '0', 'FAILED', ''),
('EHS/EHT/19/001', 'ALIYU IMADODE SERAH', 'ENVH', '100L', '0', 'FAILED', ''),
('EHS/EHT/19/001', 'ALIYU IMADODE SERAH', 'ENVH', '100L', '0', 'FAILED', '');

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

--
-- Table structure for table `q_cod 2318847`
--

CREATE TABLE `q_cod 2318847` (
  `questionnos` int(3) NOT NULL,
  `questions` longtext NOT NULL,
  `A` varchar(20) NOT NULL,
  `B` varchar(33) NOT NULL,
  `C` varchar(33) NOT NULL,
  `D` varchar(33) NOT NULL,
  `ans` varchar(33) NOT NULL,
  `img` varchar(25) NOT NULL,
  `solimg` varchar(136) NOT NULL,
  `stack` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `q_cod 2318847`
--

INSERT INTO `q_cod 2318847` (`questionnos`, `questions`, `A`, `B`, `C`, `D`, `ans`, `img`, `solimg`, `stack`) VALUES
(1, 'How many type of pins does the Arduino have', '4', '7', '3', '8', 'C', '63e9802e4106d_1676247086.', '', 'RAND'),
(2, 'What does PWM stands for', 'PULSE WIDTH MACHINE', 'PULSE WIDTH MODULATION', 'PRICE WATER MAN', 'PEACE WATER MACHINE', 'B', '63e9806ab3e39_1676247146.', '', 'RAND'),
(3, 'DIGITAL PINS ARE INPUT/OUTPUT PINS', 'YES', 'NO', 'SOME HOW', 'ALL OF THE ABOVE', 'A', '63e981097b289_1676247305.', '', 'RAND');

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

--
-- Table structure for table `q_cod2485601`
--

CREATE TABLE `q_cod2485601` (
  `questionnos` int(3) NOT NULL,
  `questions` longtext CHARACTER SET latin1 NOT NULL,
  `A` varchar(20) CHARACTER SET latin1 NOT NULL,
  `B` varchar(33) CHARACTER SET latin1 NOT NULL,
  `C` varchar(33) CHARACTER SET latin1 NOT NULL,
  `D` varchar(33) CHARACTER SET latin1 NOT NULL,
  `ans` varchar(33) CHARACTER SET latin1 NOT NULL,
  `img` varchar(25) CHARACTER SET latin1 NOT NULL,
  `solimg` varchar(136) CHARACTER SET latin1 NOT NULL,
  `stack` varchar(32) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `q_cod2485601`
--

INSERT INTO `q_cod2485601` (`questionnos`, `questions`, `A`, `B`, `C`, `D`, `ans`, `img`, `solimg`, `stack`) VALUES
(1, 'Who designed Python', 'Gui', 'Rosson', 'Guido van Rossum', 'Mark Zuckerberg', 'C', '651693cb01d41_1695978443.', '', 'RAND'),
(2, 'ddddddddd', 'd', 'df', 'g', 't', 'd', '651721fb50f52_1696014843.', '', 'RAND');

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

--
-- Table structure for table `q_pp`
--

CREATE TABLE `q_pp` (
  `questionnos` int(3) NOT NULL,
  `questions` longtext NOT NULL,
  `A` varchar(20) NOT NULL,
  `B` varchar(33) NOT NULL,
  `C` varchar(33) NOT NULL,
  `D` varchar(33) NOT NULL,
  `ans` varchar(33) NOT NULL,
  `img` varchar(25) NOT NULL,
  `solimg` varchar(136) NOT NULL,
  `stack` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `q_pp`
--

INSERT INTO `q_pp` (`questionnos`, `questions`, `A`, `B`, `C`, `D`, `ans`, `img`, `solimg`, `stack`) VALUES
(1, ' vvvvvvvvvvvvvvvvvvvvvvvvvvv', 'HHH', 'nnnn', 'bbbb', 'bbbbb', 'D', '5efc2e59b8c2b_1593585241.', '', 'RAND'),
(2, 'GHGH', 'BBB', 'BBB', 'BB', 'BBB', 'C', '5efc2e46adfc1_1593585222.', '', 'RAND');

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

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `sno` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `teachername` varchar(500) NOT NULL,
  `sid` int(11) NOT NULL,
  `subjectname` varchar(500) NOT NULL,
  `tip` int(11) NOT NULL,
  `topicname` varchar(500) NOT NULL,
  `filelocation` varchar(500) NOT NULL,
  `v1` int(11) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `score`
--

CREATE TABLE `score` (
  `week` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `score`
--

INSERT INTO `score` (`week`) VALUES
('EXCELLENT'),
('GOOD'),
('POOR');

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

--
-- Table structure for table `sss1023`
--

CREATE TABLE `sss1023` (
  `question` int(11) NOT NULL,
  `sans` varchar(600) NOT NULL,
  `ssans` varchar(600) NOT NULL,
  `corr` varchar(600) NOT NULL,
  `vvv` varchar(600) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ssss_85601lca/23/lca/002`
--

CREATE TABLE `ssss_85601lca/23/lca/002` (
  `question` int(11) NOT NULL,
  `sans` varchar(600) CHARACTER SET latin1 NOT NULL,
  `ssans` varchar(600) CHARACTER SET latin1 NOT NULL,
  `corr` varchar(600) CHARACTER SET latin1 NOT NULL,
  `vvv` varchar(600) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `sss_`
--

CREATE TABLE `sss_` (
  `question` int(11) NOT NULL,
  `sans` varchar(600) NOT NULL,
  `ssans` varchar(600) NOT NULL,
  `corr` varchar(600) NOT NULL,
  `vvv` varchar(600) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sss_lca/23/lca/001`
--

CREATE TABLE `sss_lca/23/lca/001` (
  `question` int(11) NOT NULL,
  `sans` varchar(600) NOT NULL,
  `ssans` varchar(600) NOT NULL,
  `corr` varchar(600) NOT NULL,
  `vvv` varchar(600) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sss_lca/23/lca/002`
--

CREATE TABLE `sss_lca/23/lca/002` (
  `question` int(11) NOT NULL,
  `sans` varchar(600) CHARACTER SET latin1 NOT NULL,
  `ssans` varchar(600) CHARACTER SET latin1 NOT NULL,
  `corr` varchar(600) CHARACTER SET latin1 NOT NULL,
  `vvv` varchar(600) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `sss_lca/23/lca/00285601`
--

CREATE TABLE `sss_lca/23/lca/00285601` (
  `question` int(11) NOT NULL,
  `sans` varchar(600) CHARACTER SET latin1 NOT NULL,
  `ssans` varchar(600) CHARACTER SET latin1 NOT NULL,
  `corr` varchar(600) CHARACTER SET latin1 NOT NULL,
  `vvv` varchar(600) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sss_lca/23/lca/00285601`
--

INSERT INTO `sss_lca/23/lca/00285601` (`question`, `sans`, `ssans`, `corr`, `vvv`) VALUES
(1, 'C', 'C', 'CORRECT', ''),
(2, 'd', 'C', 'WRONG', '');

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

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

CREATE TABLE `subjects` (
  `id` int(11) NOT NULL,
  `subject_name` varchar(50) NOT NULL,
  `userid` int(11) NOT NULL,
  `class` varchar(200) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `date` varchar(200) NOT NULL,
  `vvv` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `subjects` (`id`, `subject_name`, `userid`, `class`, `arm`, `date`, `vvv`) VALUES
(186, 'ROBOTICS', 1002, 'COD 23', '1', '2023-02-09', 1002),
(187, 'PYTHON', 1002, 'PYTHON', 'select arm', '2023-09-29', 1002);

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

--
-- Table structure for table `subjectts`
--

CREATE TABLE `subjectts` (
  `id` int(11) NOT NULL DEFAULT 0,
  `subject_code` varchar(50) NOT NULL,
  `topic` varchar(500) NOT NULL,
  `subject_teacher` int(11) NOT NULL,
  `objective` varchar(500) NOT NULL,
  `subject_resource` int(11) NOT NULL,
  `subject_scope` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subjectts`
--

INSERT INTO `subjectts` (`id`, `subject_code`, `topic`, `subject_teacher`, `objective`, `subject_resource`, `subject_scope`) VALUES
(1, 'CHM231', 'Chemistry of Life', 0, 'to make our life better', 0, 'telephathy operation'),
(2, 'CHM231', 'Chemistry of Life', 0, '', 0, 'telephathy operation');

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

--
-- Table structure for table `subpry`
--

CREATE TABLE `subpry` (
  `id` int(11) NOT NULL DEFAULT 0,
  `subject_name` varchar(50) NOT NULL,
  `userid` int(11) NOT NULL,
  `class` varchar(200) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `date` varchar(200) NOT NULL,
  `vvv` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subpry`
--

INSERT INTO `subpry` (`id`, `subject_name`, `userid`, `class`, `arm`, `date`, `vvv`) VALUES
(1, 'ENGLISH STUDIES', 0, 'regular', 'PRIMARY', '0033-03-31', 0),
(2, 'BASIC SCIENCE AND TECHNOLOGY', 0, 'regular', 'PRIMARY', '5/26/2020', 0),
(3, 'LITERATURE IN ENGLISH', 0, '', 'PRIMARY', '', 0),
(4, 'MATHEMATICS', 0, '', 'PRIMARY', '', 0),
(5, 'PRE-VOCATIONAL STUDIES', 0, '', 'PRIMARY', '', 0),
(6, 'CHRISTIAN RELIGIOUS STUDIES', 0, '', 'PRIMARY', '', 0),
(7, 'NATIONAL VALUES', 0, '', 'PRIMARY', '', 0),
(8, 'INFORMATION AND COMMUNICATION TECHNOLOGY', 0, '', 'PRIMARY', '', 0),
(9, 'IGBO LANGUAGE', 0, '', 'PRIMARY', '', 0),
(10, 'FRENCH LANGUAGE', 0, '', 'PRIMARY', '', 0),
(11, 'GENERAL PAPER', 0, '', 'PRIMARY', '', 0),
(12, 'ENGLISH STUDIES', 0, '', 'NURSERY', '', 0);

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

--
-- Table structure for table `table 140`
--

CREATE TABLE `table 140` (
  `COL 1` varchar(23) DEFAULT NULL,
  `COL 2` varchar(21) DEFAULT NULL,
  `COL 3` varchar(28) DEFAULT NULL,
  `COL 4` varchar(10) DEFAULT NULL,
  `COL 5` varchar(9) DEFAULT NULL,
  `COL 6` varchar(18) DEFAULT NULL,
  `COL 7` varchar(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `table 140`
--

INSERT INTO `table 140` (`COL 1`, `COL 2`, `COL 3`, `COL 4`, `COL 5`, `COL 6`, `COL 7`) VALUES
('EHS/EHT/19/001', 'ALIYU IMADODE SERAH', 'ENVIRONMENTAL HEALTH', 'ENVH', '100L', 'EVT 100L', '34464664'),
('EHS/EHT/19/002', 'MOH\'D NASIR ABUBAKAR', 'ENVIRONMENTAL HEALTH', 'ENVH', '100L', 'EVT 100L', '34464712'),
('EHS/EHT/19/003', 'ISIAKU ISMAIL', 'ENVIRONMENTAL HEALTH', 'ENVH', '100L', 'EVT 100L', '34464760'),
('EHS/EVT/18/001', 'MUSA SARAH', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34464808'),
('EHS/EVT/18/002', 'EMMANUEL GRACE', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34464856'),
('EHS/EVT/18/003', 'YOHANNA HAJARA', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34464904'),
('EHS/EVT/18/004', 'AHMADU POLINA', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34464952'),
('EHS/EVT/18/005', 'ISHAYA ZAZZAU', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465000'),
('EHS/EVT/18/006', 'ISHAKU SARATU', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465048'),
('EHS/EVT/18/007', 'MARTHA SILAS', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465096'),
('EHS/EVT/18/008', 'ANNAH AJAYI', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465144'),
('EHS/EVT/18/009', 'MARYAM DAHIR MUHAMMAD', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465192'),
('EHS/EVT/18/010', 'MOHAMMED MOHAMMAD T', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465240'),
('EHS/EVT/18/012', 'BASHIR MIJINYANA', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465336'),
('EHS/EVT/18/013', 'THOMAS EMMANUEL', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465384'),
('EHS/EVT/18/014', 'LADI YAKUBU', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465432'),
('EHS/EVT/18/015', 'FANYIDA LOVETH', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465480'),
('EHS/EVT/18/016', 'AMINA A. SHEHU', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465528'),
('EHS/EVT/18/017', 'UMAR LAWAL', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465576'),
('EHS/EVT/18/018', 'IBRAHIM ABDULKARIM', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465624'),
('EHS/EVT/18/019', 'MANSUR NURA', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465672'),
('EHS/EVT/18/020', 'USMAN SALLAU', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465720'),
('EHS/EVT/18/021', 'YAKUBU SHEDRACK', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465768'),
('EHS/EVT/18/022', 'ZAINAB M. ADAMU', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465816'),
('EHS/EVT/18/023', 'FARIDA USMAN', 'ENVIRONMENTAL HEALTH', 'ENVH', '200L', 'EVT 200L', '34465864'),
('EHS/EVT/17/001', 'SAMAILA GARBA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34465912'),
('EHS/EVT/17/002', 'SULEIMAN YAHAYA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34465960'),
('EHS/EVT/17/003', 'ASHIRU IRIMIYA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466008'),
('EHS/EVT/17/004', 'SAMAILA MUSA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466056'),
('EHS/EVT/17/005', 'JUMMAI HARUNA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466104'),
('EHS/EVT/17/006', 'ISIYAKU MATO', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466152'),
('EHS/EVT/17/007', 'AMINA AMADU', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466200'),
('EHS/EVT/17/008', 'HAJARA DANLADI', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466248'),
('EHS/EVT/17/009', 'LADI SHUAIBU', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466296'),
('EHS/EVT/17/010', 'FATIMA YUSUF', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466344'),
('EHS/EVT/17/011', 'ZAINAB JAAFAR YAU', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466392'),
('EHS/EVT/17/012', 'RAMLATU SALIHU', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466440'),
('EHS/EVT/17/013', 'FILLO D. AUTA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466488'),
('EHS/EVT/17/014', 'MARYAM JAAFAR YAU', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466536'),
('EHS/EVT/17/015', 'ZULAI AYUBA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466584'),
('EHS/EVT/17/016', 'HAJARA MUAZU JARTU', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466632'),
('EHS/EVT/17/017', 'ASABE GARBA USMAN', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466680'),
('EHS/EVT/17/018', 'NICODEMUS BLESSING', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466728'),
('EHS/EVT/17/019', 'HAJARA JAAFAR YAU', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466776'),
('EHS/EVT/17/020', 'ABDULAZEEZ ABDULKADIR', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466824'),
('EHS/EVT/17/021', 'OSUMENYA FAITH', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466872'),
('EHS/EVT/17/022', 'LABIRU LAWAL', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466920'),
('EHS/EVT/17/023', 'LADI HARUNA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34466968'),
('EHS/EVT/17/024', 'ZAINAB MUHAMMAD ', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34467016'),
('EHS/EVT/17/025', 'AISHA HARUNA', 'ENVIRONMENTAL HEALTH', 'ENVH', '300L', 'EVT 300L', '34467064'),
('DIP/19/HPE/001', 'JOHNSON OKE GIFT', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467112'),
('DIP/19/HPE/002', 'YAHANASU ABDULMIUMIN', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467160'),
('DIP/19/HPE/003', 'MAIMUNAT KABIR', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467208'),
('DIP/19/HPE/004', 'YOSI J. MICAH', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467256'),
('DIP/19/HPE/005', 'BITRUS PRICILIA ', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467304'),
('DIP/19/HPE/006', 'HAFSAT MUHAMMED', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467352'),
('DIP/19/HPE/007', 'SUMAYYA AHMAD', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467400'),
('DIP/19/HPE/008', 'FAIZA ABDULSALAM', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467448'),
('DIP/19/HPE/009', 'DELUWA MUHAMMED', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467496'),
('DIP/19/HPE/010', 'CLAUDIA MESHACH', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467544'),
('DIP/19/HPE/011', 'AISHA YUNUSA', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467592'),
('DIP/19/HPE/012', 'ADESS DORCAS', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467640'),
('DIP/19/HPE/013', 'BASIRU AMINU', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467688'),
('DIP/19/HPE/014', 'LAMI SAMAILA GWARFA', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467736'),
('DIP/19/HPE/015', 'BALA DANJUMMAI', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467784'),
('DIP/19/HPE/016', 'ABUBAKAR HAUWAU .Y.', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467832'),
('DIP/19/HPE/017', 'MAGRET USAINI', 'HEALTH EDUCATION & PROMOTION', 'HPE', '100L', 'HPE 100L', '34467880'),
('DIP/HPE/18/001', 'SAMINU MUNTARI', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34467928'),
('DIP/HPE/18/002', 'BITRUS USMAN', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34467976'),
('DIP/HPE/18/003', 'ABBA M. UBALE', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468024'),
('DIP/HPE/18/004', 'MUNTARI ABUBAKAR', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468072'),
('DIP/HPE/18/005', 'ZAINAB B. USMAN', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468120'),
('DIP/HPE/18/006', 'ZAINAB MUHAMMAD', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468168'),
('DIP/HPE/18/007', 'KHADIJAT ABUBAKAR', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468216'),
('DIP/HPE/18/008', 'ZAINAB M. UMMI', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468264'),
('DIP/HPE/18/009', 'HADIZA YAKUBU', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468312'),
('DIP/HPE/18/010', 'DORCAS STEPHEN', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468360'),
('DIP/HPE/18/011', 'RABIAH UMAR', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468408'),
('DIP/HPE/18/012', 'RABO MARY', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468456'),
('DIP/HPE/18/013', 'HAUWAU ABUBAKAR', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468504'),
('DIP/HPE/18/014', 'HABIBAT ABUBAKAR', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468552'),
('DIP/HPE/18/015', 'HABIBAT ABDULLAHI', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468600'),
('DIP/HPE/18/016', 'MANSUR NUHU', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468648'),
('DIP/HPE/18/017', 'USMAN SALLAU', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468696'),
('DIP/HPE/18/018', 'USMAN U. LAWAL', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468744'),
('DIP/HPE/18/019', 'ABUBAKAR S. ALIYU', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468792'),
('DIP/HPE/18/020', 'IBRAHIM ABDULKARIM', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468840'),
('DIP/HPE/18/021', 'HAUWAU A. YUSUF', 'HEALTH EDUCATION & PROMOTION', 'HPE', '200L', 'HPE 200L', '34468888'),
('DIP/MLX/19/001', 'AUDU NASARA', 'MEDICAL X-RAY', 'MXR', '100L', 'X-RAY 100L', '34468936'),
('DIP/MLX/19/002', 'ZAILANI A. ZAINAB', 'MEDICAL X-RAY', 'MXR', '100L', 'X-RAY 100L', '34468984'),
('DIP/MLX/19/003', 'SALISU MARYAM', 'MEDICAL X-RAY', 'MXR', '100L', 'X-RAY 100L', '34469032'),
('DIP/MLX/19/004', 'IBRAHIM JOSEPH', 'MEDICAL X-RAY', 'MXR', '100L', 'X-RAY 100L', '34469080'),
('DIP/MLX/19/005', 'IBRAHIM BLESSING', 'MEDICAL X-RAY', 'MXR', '100L', 'X-RAY 100L', '34469128'),
('DIP/MLX/19/006', 'AHMAD ALIYU AISHA', 'MEDICAL X-RAY', 'MXR', '100L', 'X-RAY 100L', '34469176'),
('DIP/MLX/19/007', 'DANJUMMAI BALA. K', 'MEDICAL X-RAY', 'MXR', '100L', 'X-RAY 100L', '34469224'),
('DLS/PRY/20/001', 'GIDEON DAGAMA', 'PRIMARY SECTION', 'PRY', 'PRY1', 'PRY ONE', '34469231'),
('DIP/PHM/20/001', 'DAGAMA MICHAEL', 'PHARMACY', 'PHAM', '200L', 'PHAM 200L', '34469238'),
('DLS/KG/20/1', 'DEAR STUDENT', 'KG', 'KG', 'KG 1', 'KG 1', '34488238'),
('DLS/KG/20/2', 'DEAR STUDENT', 'KG', 'KG', 'KG 2', 'KG 2', '38669245'),
('DLS/NUR/20/1', 'DEAR STUDENT', 'NURSERY', 'NUR', 'NUR 1', 'NUR 1', '74469245'),
('DLS/NUR/20/2', 'DEAR STUDENT', 'NURSERY', 'NUR', 'NUR 2', 'NUR 2', '74469587'),
('', '', '', '', '', '', ''),
('DLS/PRY/20/002', 'DEAR STUDENT', 'PRIMARY SECTION', 'PRY', 'PRY TWO', 'PRY TWO', '25587964'),
('DLS/PRY/20/003', 'DEAR STUDENT', 'PRIMARY SECTION', 'PRY', 'PRY THREE', 'PRY THREE', '36649456'),
('DLS/PRY/20/004', 'DEAR STUDENT', 'PRIMARY SECTION', 'PRY', 'PRY FOUR', 'PRY FOUR', '45587896'),
('DLS/PRY/20/005', 'DEAR STUDENT', 'PRIMARY SECTION', 'PRY', 'PRY FIVE', 'PRY FIVE', '85547955'),
('DLS/SEC/20/001', 'DEAR STUDENT', 'SECONDARY SECTION', 'SEC', 'JSS1', 'JSS1', '84445665'),
('DLS/SEC/20/002', 'DEAR STUDENT', 'SECONDARY SECTION', 'SEC', 'JSS2', 'JSS2', '69887564'),
('DLS/SEC/20/003', 'DEAR STUDENT', 'SECONDARY SECTION', 'SEC', 'JSS3', 'JSS3', '87458595'),
('DLS/SEC/20/004', 'DEAR STUDENT', 'SECONDARY SECTION', 'SEC', 'SSS1', 'SSS1', '57789545'),
('DLS/SEC/20/005', 'DEAR STUDENT', 'SECONDARY SECTION', 'SEC', 'SSS2', 'SSS2', '87748595'),
('DLS/SEC/20/006', 'DEAR STUDENT', 'SECONDARY SECTION', 'SEC', 'SSS3', 'SSS3', '59957445'),
('NECO/SEC/20/ALL STUDENT', 'NECO REMEDIAL', 'NECO REVISION CLASS', 'NECO', 'NECO20', 'NECO20', '34469840'),
('SNO', 'NAME', 'DEPARTMENT', 'DEPARTMENT', 'LEVEL', 'DEPARTMENT & LEVEL', 'BFGFHN');

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

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

CREATE TABLE `teachers` (
  `sno` int(11) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `date` varchar(500) NOT NULL,
  `timestart` varchar(500) NOT NULL,
  `timestop` varchar(500) NOT NULL,
  `v1` int(11) NOT NULL,
  `v2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `topics`
--

CREATE TABLE `topics` (
  `id` int(11) NOT NULL,
  `subject_code` varchar(50) NOT NULL,
  `topic` varchar(500) NOT NULL,
  `teacherid` int(11) NOT NULL,
  `objective` varchar(500) NOT NULL,
  `filelocation` varchar(200) NOT NULL,
  `subject_scope` varchar(200) NOT NULL,
  `score` varchar(400) NOT NULL,
  `adminremarks` varchar(400) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(200) NOT NULL,
  `zoom` varchar(600) NOT NULL,
  `videofile2` varchar(600) NOT NULL,
  `videofile` varchar(600) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `topics`
--

INSERT INTO `topics` (`id`, `subject_code`, `topic`, `teacherid`, `objective`, `filelocation`, `subject_scope`, `score`, `adminremarks`, `class`, `arm`, `zoom`, `videofile2`, `videofile`) VALUES
(1, 'subject_code', 'topic', 0, 'objective', 'filelocation', 'subject_scope', 'score', 'adminremarks', 'class', 'arm', 'zoom', 'videofile2', 'videofile'),
(156, 'SCRATCH101', 'Introduction to Scratch', 1002, 'Navigating the Scratch interface.- Creating a new project.\n  Understanding the stage and sprites\n\r\n', '63e97f117ab2c_1676246801.pdf', 'WEEK 4', 'EXCELLENT', 'Create a new project in Scratch,Add a water backdrop, proceed to add a fish sprite of choice.\n					  ', 'COD 23', '1', 'NILL', 'https://www.youtube.com/embed/Hq2Vkmaaoso', ''),
(157, 'SCRATCH101', 'Basic Animation', 0, 'Moving a sprite with simple scripts.Changing costumes and backdrops.\nCreating basic animations.', '', '', '', '', '', '', '', '', ''),
(158, 'SCRATCH101', 'Events and Interactivity', 0, 'Understanding events and triggers.Using the \"when flag clicked\" block.Creating interactive stories and animations.', '', '', '', '', '', '', '', '', ''),
(159, 'SCRATCH101', 'Conditional Statements', 0, 'Introducing if statements and conditions', '', '', '', '', '', '', '', '', ''),
(160, 'SCRATCH101', 'Loops and Repetition', 0, 'Understanding loops ,Creating animations and games that involve repetition.', '', '', '', '', '', '', '', '', ''),
(161, 'SCRATCH101', 'User Input and Variables', 0, 'Accepting user inputs and responding to it', '', '', '', '', '', '', '', '', ''),
(162, 'SCRATCH101', 'Sprites and Costumes', 0, 'Creating custom sprites and costumes. Using the sprite editor. Animate characters and objects.Using Multiple Spirites', '', '', '', '', '', '', '', '', ''),
(163, 'SCRATCH101', 'Broadcasting and Messaging', 0, 'Communicating between sprites using broadcasts. Building collaborative projects.', '', '', '', '', '', '', '', '', ''),
(164, 'SCRATCH101', 'Basic Game Developmen', 0, 'Introducing the concept of games. Building a simple game (e.g., a maze or a catch game).', '', '', '', '', '', '', '', '', ''),
(165, 'SCRATCH101', 'Sound and Music', 0, 'Adding sounds to your projects. Creating music loops. Using sound effects. Linking actions to Sounds', '', '', '', '', '', '', '', '', ''),
(166, 'SCRATCH101', 'Scrolling Backdrops(1)', 0, 'Types of scrolling backdrops. The X and Y coordinate. Horizontal Scroll with Star Wars', '', '', '', '', '', '', '', '', ''),
(167, 'SCRATCH101', 'Scrolling Backdrops(2)', 0, 'Types of scrolling backdrops. The X and Y coordinate. Vertical Scroll with Car Race', '', '', '', '', '', '', '', '', ''),
(168, 'SCRATCH101', 'Project 1', 0, 'Action Girl. Simple running game using loops,movements,sound effects.', '', '', '', '', '', '', '', '', ''),
(169, 'SCRATCH101', 'Project 2', 0, 'Spiderman Game. Platformer game using loops,movements,sound effects.', '', '', '', '', '', '', '', '', ''),
(170, 'SCRATCH101', 'Project 3', 0, 'Simple Maze. Maze game using loops,movements,sound effects. ', '', '', '', '', '', '', '', '', ''),
(171, 'SCRATCH101', 'Project 4', 0, 'Our Planetry System. Simple animation about our Universe. ', '', '', '', '', '', '', '', '', ''),
(172, 'PYTHON101', 'Introduction to Python:', 0, 'What is Python and why it\'s used.Installing Python and setting up the development environment.', '', '', '', '', '', '', '', 'https://www.youtube.com/embed/lvBwKf8-DNM', ''),
(173, 'PYTHON101', ' Basic Syntax:', 0, 'Data types and python Syntax', '', '', '', '', '', '', '', '', ''),
(174, 'PYTHON101', 'User Input and Output', 0, ' Using input() to get user input,  Printing messages with print()', '', '', '', '', '', '', '', '', ''),
(175, 'PYTHON101', 'Conditional Statements', 0, 'Introducing if, else, and elif statements. Creating simple decision-making programs.', '', '', '', '', '', '', '', '', ''),
(176, 'PYTHON101', 'Loops', 0, ' Using for and while loops.Writing programs that repeat actions.', '', '', '', '', '', '', '', '', ''),
(177, 'PYTHON101', ' Functions', 0, ' Defining and using functions.Understanding function parameters and return values.', '', '', '', '', '', '', '', '', ''),
(178, 'PYTHON101', 'Lists and Data Structures', 0, 'Creating and manipulating lists, Introducing dictionaries and sets', '', '', '', '', '', '', '', '', ''),
(179, 'PYTHON101', ' File Handling', 0, ' Reading from and writing to files, Saving and loading data', '', '', '', '', '', '', '', '', ''),
(180, 'PYTHON101', 'Advanced Data Structures', 0, ' Exploring more complex data structures like stacks, queues, and linked lists', '', '', '', '', '', '', '', '', ''),
(181, 'PYTHON101', 'Modules and Libraries', 0, 'Importing and using external Python modules and libraries,  Exploring libraries for specific tasks like graphics or game development.', '', '', '', '', '', '', '', '', ''),
(182, 'PYTHON101', 'Graphical User Interfaces (GUIs)', 0, 'Building simple graphical applications using libraries like Tkinter or PyQT.', '', '', '', '', '', '', '', '', ''),
(183, 'PYTHON101', ' Game Development', 0, ' Building simple games using libraries like Pygame.', '', '', '', '', '', '', '', '', ''),
(184, 'PYTHON101', 'Machine Learning (Optional)', 0, ' Introduction to machine learning concepts and libraries like scikit-learn.', '', '', '', '', '', '', '', '', ''),
(185, 'PYTHON101', 'Project 1:', 0, 'Image Recognition,Simple image recognition system using Machine Leraning', '', '', '', '', '', '', '', '', ''),
(186, 'PYTHON101', 'Project 2:', 0, ' Smart Chat Bots,  Bots to use in resonding to querries.', '', '', '', '', '', '', '', '', ''),
(187, 'PYTHON101', 'Project 3:', 0, 'Simple Python Game.Platformer game using loops,movements,sound effects.', '', '', '', '', '', '', '', '', ''),
(188, 'PYTHON101', 'Project 4:', 0, 'Simple animation about our Universe.', '', '', '', '', '', '', '', '', ''),
(189, '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(190, '', 'Introduction to Kodular', 0, '', '', '', '', '', '', '', '', '', ''),
(191, '', ' Objective', 0, ' Familiarize students with Kodular\'s interface and its capabilities.', '', '', '', '', '', '', '', '', ''),
(192, '', ' User Interface Design', 0, 'Teach students how to design the user interface of an app using Kodular.', '', '', '', '', '', '', '', '', ''),
(193, '', ' Basic App Logic', 0, 'Introduce students to the logic and functionality of their apps.', '', '', '', '', '', '', '', '', ''),
(194, '', 'Data Storage and Variables', 0, 'Teach students how to store and manipulate data within their apps.', '', '', '', '', '', '', '', '', ''),
(195, '', 'App Navigation', 0, 'Show students how to create multiple screens and navigate between them.\n', '', '', '', '', '', '', '', '', ''),
(196, '', ' Sensor and Device Integration', 0, 'Introduce students to using device sensors and features in their apps.', '', '', '', '', '', '', '', '', ''),
(197, '', 'External APIs and Web Connectivity', 0, ' Teach students how to interact with external data sources and web services.', '', '', '', '', '', '', '', '', ''),
(198, '', 'App Testing and Debugging', 0, 'Show students how to test and debug their apps for better functionality.', '', '', '', '', '', '', '', '', ''),
(199, '', 'Publishing and Distribution', 0, ' Guide students on how to publish their apps and share them with others.', '', '', '', '', '', '', '', '', ''),
(200, '', 'Advanced Projects', 0, 'Allow students to work on advanced projects of their choice to apply their skills.', '', '', '', '', '', '', '', '', ''),
(201, '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(202, '', '', 0, 'Throughout the lessons, encourage creativity and problem-solving, and adapt the pace and complexity to the students\' age and skill level. Assign projects and challenges that align with their interests to keep them engaged and motivated.', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `ttt_1001`
--

CREATE TABLE `ttt_1001` (
  `class` varchar(400) NOT NULL,
  `arm` varchar(400) NOT NULL,
  `sno` int(11) NOT NULL,
  `ibv` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `t_`
--

CREATE TABLE `t_` (
  `sno` int(11) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `date` varchar(500) NOT NULL,
  `timestart` varchar(500) NOT NULL,
  `timestop` varchar(500) NOT NULL,
  `v1` int(11) NOT NULL,
  `v2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `t_1`
--

CREATE TABLE `t_1` (
  `sno` int(11) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `date` varchar(500) NOT NULL,
  `timestart` varchar(500) NOT NULL,
  `timestop` varchar(500) NOT NULL,
  `v1` int(11) NOT NULL,
  `v2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `t_1002`
--

CREATE TABLE `t_1002` (
  `sno` int(11) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL,
  `date` varchar(500) NOT NULL,
  `timestart` varchar(500) NOT NULL,
  `timestop` varchar(500) NOT NULL,
  `v1` int(11) NOT NULL,
  `v2` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_1002`
--

INSERT INTO `t_1002` (`sno`, `subject`, `class`, `arm`, `date`, `timestart`, `timestop`, `v1`, `v2`) VALUES
(1, 'ROBOTICS', 'COD 23', '1', '2023-02-09', '', '', 1002, 0);

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

--
-- Table structure for table `t_ss`
--

CREATE TABLE `t_ss` (
  `serialno` varchar(9) NOT NULL,
  `subjects` varchar(35) NOT NULL,
  `class` varchar(15) NOT NULL,
  `type` varchar(123) NOT NULL,
  `date` varchar(24) NOT NULL,
  `extime` int(23) NOT NULL,
  `stdate` varchar(34) NOT NULL,
  `endate` varchar(34) NOT NULL,
  `examref` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `upload`
--

CREATE TABLE `upload` (
  `sno` int(11) NOT NULL,
  `stuid` int(11) NOT NULL,
  `studentname` varchar(500) NOT NULL,
  `sid` int(11) NOT NULL,
  `subjectname` varchar(500) NOT NULL,
  `tid` int(11) NOT NULL,
  `topicname` varchar(500) NOT NULL,
  `filelocation` varchar(500) NOT NULL,
  `v1` int(11) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `upl_`
--

CREATE TABLE `upl_` (
  `sno` int(11) NOT NULL,
  `stuid` int(11) NOT NULL,
  `studentname` varchar(500) NOT NULL,
  `sid` int(11) NOT NULL,
  `subjectname` varchar(500) NOT NULL,
  `tid` int(11) NOT NULL,
  `topicname` varchar(500) NOT NULL,
  `filelocation` varchar(500) NOT NULL,
  `v1` varchar(110) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `upl_1002`
--

CREATE TABLE `upl_1002` (
  `sno` int(11) NOT NULL,
  `stuid` int(11) NOT NULL,
  `studentname` varchar(500) NOT NULL,
  `sid` int(11) NOT NULL,
  `subjectname` varchar(500) NOT NULL,
  `tid` int(11) NOT NULL,
  `topicname` varchar(500) NOT NULL,
  `filelocation` varchar(500) NOT NULL,
  `v1` int(11) NOT NULL,
  `class` varchar(500) NOT NULL,
  `arm` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `weeks`
--

CREATE TABLE `weeks` (
  `week` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `weeks`
--

INSERT INTO `weeks` (`week`) VALUES
('WEEK1'),
('WEEK2'),
('WEEK 3'),
('WEEK 4'),
('WEEK5'),
('WEEK6'),
('WEEK7'),
('WEEK8'),
('WEEK9'),
('WEEK10'),
('WEEK11'),
('WEEK12'),
('WEEK13'),
('WEEK14');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `1002`
--
ALTER TABLE `1002`
  ADD PRIMARY KEY (`questionnos`);

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

--
-- Indexes for table `assignment`
--
ALTER TABLE `assignment`
  ADD PRIMARY KEY (`sno`);

--
-- Indexes for table `ass_`
--
ALTER TABLE `ass_`
  ADD PRIMARY KEY (`sno`);

--
-- Indexes for table `ass_1002`
--
ALTER TABLE `ass_1002`
  ADD PRIMARY KEY (`sno`);

--
-- Indexes for table `cbt_cod24`
--
ALTER TABLE `cbt_cod24`
  ADD PRIMARY KEY (`serialno`);

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

--
-- Indexes for table `classsubject`
--
ALTER TABLE `classsubject`
  ADD PRIMARY KEY (`ai`);

--
-- Indexes for table `fgvbh`
--
ALTER TABLE `fgvbh`
  ADD PRIMARY KEY (`BBB`);

--
-- Indexes for table `score`
--
ALTER TABLE `score`
  ADD PRIMARY KEY (`week`);

--
-- Indexes for table `sss_`
--
ALTER TABLE `sss_`
  ADD PRIMARY KEY (`question`);

--
-- Indexes for table `sss_lca/23/lca/001`
--
ALTER TABLE `sss_lca/23/lca/001`
  ADD PRIMARY KEY (`question`);

--
-- Indexes for table `sss_lca/23/lca/002`
--
ALTER TABLE `sss_lca/23/lca/002`
  ADD PRIMARY KEY (`question`);

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

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

--
-- Indexes for table `ttt_1001`
--
ALTER TABLE `ttt_1001`
  ADD PRIMARY KEY (`ibv`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `classsubject`
--
ALTER TABLE `classsubject`
  MODIFY `ai` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `ttt_1001`
--
ALTER TABLE `ttt_1001`
  MODIFY `ibv` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

