-- Batch 1 Starts Here
 CREATE TABLE `scholars` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL,
  `Sclass` varchar(100) NOT NULL,
  `RegDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `teachers` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `tclass` varchar(100) NOT NULL,
  `Subjects` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `newscholars` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL,
  `Rclass` varchar(100) NOT NULL ,
  `Sclass` varchar(100) NOT NULL DEFAULT "newtake",
  `RegDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Index for Primary keys & Unique keys
 ALTER TABLE `scholars` 
 ADD PRIMARY KEY (`id`),
 ADD UNIQUE KEY `RegNumber`(`RegNumber`);

 ALTER TABLE `newscholars` 
 ADD PRIMARY KEY (`id`),
 ADD UNIQUE KEY `RegNumber`(`RegNumber`);

 ALTER TABLE `teachers` 
 ADD PRIMARY KEY (`id`);

 -- Index for AUTO_INCREMENT
 ALTER TABLE `scholars`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `newscholars`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `teachers`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;
-- Batch 1 Close  Here





-- Batch 2 Starts  Here

CREATE TABLE `times` (
  `id` int NOT NULL,
  `sclass` varchar(100) NOT NULL,
  `Hours` varchar(100) NOT NULL DEFAULT 0,
  `Minutes` varchar(100) NOT NULL DEFAULT 10,
  `Seconds` varchar(100) NOT NULL DEFAULT 60
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `subjects` (
  `id` int NOT NULL,
  `sclass` varchar(100) NOT NULL,
  `Allsubjects` varchar(100) NOT NULL DEFAULT 'SSS3'
  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `qgrade1` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
 
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `qgrade2` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
 
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `times` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `subjects` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `times`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `subjects`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

INSERT INTO `times`( `sclass`) values ( 'Grade1');
INSERT INTO `times`( `sclass`) values ( 'Grade2');
INSERT INTO `times`( `sclass`) values ( 'Grade3');
INSERT INTO `times`( `sclass`) values ( 'Grade4');
INSERT INTO `times`( `sclass`) values ( 'Grade5');

INSERT INTO `times`( `sclass`) values ('Jss1');
INSERT INTO `times`( `sclass`) values ('Jss2');
INSERT INTO `times`( `sclass`) values ('Jss3');

INSERT INTO `times`( `sclass`) values ('sss1');
INSERT INTO `times`( `sclass`) values ('sss2');
INSERT INTO `times`( `sclass`) values ('sss3');
INSERT INTO `times`( `sclass`) values ('Newtake');

INSERT INTO `times`( `sclass`) values ('nursery1');
INSERT INTO `times`( `sclass`) values ('nursery2');
INSERT INTO `times`( `sclass`) values ('foundation');

INSERT INTO `subjects`( `sclass`) values ( 'Grade1');
INSERT INTO `subjects`( `sclass`) values ( 'Grade2');
INSERT INTO `subjects`( `sclass`) values ( 'Grade3');
INSERT INTO `subjects`( `sclass`) values ( 'Grade4');
INSERT INTO `subjects`( `sclass`) values ( 'Grade5');

INSERT INTO `subjects`( `sclass`) values ('Jss1');
INSERT INTO `subjects`( `sclass`) values ('Jss2');
INSERT INTO `subjects`( `sclass`) values ('Jss3');

INSERT INTO `subjects`( `sclass`) values ('sss1');
INSERT INTO `subjects`( `sclass`) values ('sss2');
INSERT INTO `subjects`( `sclass`) values ('sss3');
INSERT INTO `subjects`( `sclass`) values ('Newtake');

INSERT INTO `subjects`( `sclass`) values ('nursery1');
INSERT INTO `subjects`( `sclass`) values ('nursery2');
INSERT INTO `subjects`( `sclass`) values ('foundation');

-- Batch 2 Close  Here





-- Batch 3 Starts  Here

 CREATE TABLE `qgrade3` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,

  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
 
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qgrade4` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qgrade5` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qjss1` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qjss2` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qjss3` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 -- Batch 3 Close  Here








 -- Batch 4 Start  Here

CREATE TABLE `qsss1` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qsss2` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qsss3` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qnursery1` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qnursery2` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qfoundation` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `qnewtake` (
  `id` int NOT NULL,
  `Teacherq` varchar(255) NOT NULL,
  `OptA` varchar(100) NOT NULL,
  `OptB` varchar(100) NOT NULL,
  `OptC` varchar(100) NOT NULL,
  `OptD` varchar(100) NOT NULL,
  `ValA` varchar(100) NOT NULL,
  `ValB` varchar(100) NOT NULL,
  `ValC` varchar(100) NOT NULL,
  `ValD` varchar(100) NOT NULL,
  `Date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


 -- Batch 4 Close  Here







 -- Batch 5 Close  Here

CREATE TABLE `grade1` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `Science` varchar(50) NOT NULL DEFAULT 0,
  `Humanities` varchar(50) NOT NULL DEFAULT 0,
  `CCA` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0
  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `grade2` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `Science` varchar(50) NOT NULL DEFAULT 0,
  `Humanities` varchar(50) NOT NULL DEFAULT 0,
  `CCA` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `grade3` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `Science` varchar(50) NOT NULL DEFAULT 0,
  `Humanities` varchar(50) NOT NULL DEFAULT 0,
  `CCA` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `Prevocational` varchar(50) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `grade4` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `Science` varchar(50) NOT NULL DEFAULT 0,
  `Humanities` varchar(50) NOT NULL DEFAULT 0,
  `CCA` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `Prevocational` varchar(50) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `grade5` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `Science` varchar(50) NOT NULL DEFAULT 0,
  `Humanities` varchar(50) NOT NULL DEFAULT 0,
  `CCA` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `Prevocational` varchar(50) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `grade1` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `grade2` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `grade3` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `grade4` 
 ADD PRIMARY KEY (`id`);

ALTER TABLE `grade5` 
 ADD PRIMARY KEY (`id`);

ALTER TABLE `grade1`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `grade2`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `grade3`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `grade4`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `grade5`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 -- Batch 5 Close  Here






-- Batch 6 Start Here

CREATE TABLE `jss1` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `CRK` varchar(50) NOT NULL DEFAULT 0,
  `IRK` varchar(50) NOT NULL DEFAULT 0,
  `CCA` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `BasicTech` varchar(50) NOT NULL DEFAULT 0,
  `PHE` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `BasicSci` varchar(50) NOT NULL DEFAULT 0,
  `Hausa` varchar(50) NOT NULL DEFAULT 0,
  `BusinessStudies` varchar(50) NOT NULL DEFAULT 0,
  `Prevocational` varchar(50) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `jss2` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `CRK` varchar(50) NOT NULL DEFAULT 0,
  `IRK` varchar(50) NOT NULL DEFAULT 0,
  `CCA` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `BasicTech` varchar(50) NOT NULL DEFAULT 0,
  `PHE` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `BasicSci` varchar(50) NOT NULL DEFAULT 0,
  `Hausa` varchar(50) NOT NULL DEFAULT 0,
  `BusinessStudies` varchar(50) NOT NULL DEFAULT 0,
  `Prevocational` varchar(50) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `jss3` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `CRK` varchar(50) NOT NULL DEFAULT 0,
  `IRK` varchar(50) NOT NULL DEFAULT 0,
  `CCA` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `BasicTech` varchar(50) NOT NULL DEFAULT 0,
  `PHE` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `BasicSci` varchar(50) NOT NULL DEFAULT 0,
  `Hausa` varchar(50) NOT NULL DEFAULT 0,
  `BusinessStudies` varchar(50) NOT NULL DEFAULT 0,
  `Prevocational` varchar(50) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `newtake` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `Generalstudies` varchar(50) NOT NULL DEFAULT 0
  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `nursery1` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Literacy` varchar(50) NOT NULL DEFAULT 0,
  `Numeracy` varchar(50) NOT NULL DEFAULT 0,
  `KUW` varchar(50) NOT NULL DEFAULT 0,
  `Phonics` varchar(50) NOT NULL DEFAULT 0,
  `HandWritting` varchar(50) NOT NULL DEFAULT 0,
  `Rhymes` varchar(50) NOT NULL DEFAULT 0,
  `ShapesColo` varchar(50) NOT NULL DEFAULT 0,
  `PSED` varchar(50) NOT NULL DEFAULT 0,
  `HealthHabit` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0
  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `nursery2` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Literacy` varchar(50) NOT NULL DEFAULT 0,
  `Numeracy` varchar(50) NOT NULL DEFAULT 0,
  `KUW` varchar(50) NOT NULL DEFAULT 0,
  `Phonics` varchar(50) NOT NULL DEFAULT 0,
  `HandWritting` varchar(50) NOT NULL DEFAULT 0,
  `Rhymes` varchar(50) NOT NULL DEFAULT 0,
  `ShapesColo` varchar(50) NOT NULL DEFAULT 0,
  `PSED` varchar(50) NOT NULL DEFAULT 0,
  `HealthHabit` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0
  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `foundation` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Literacy` varchar(50) NOT NULL DEFAULT 0,
  `Numeracy` varchar(50) NOT NULL DEFAULT 0,
  `KUW` varchar(50) NOT NULL DEFAULT 0,
  `Phonics` varchar(50) NOT NULL DEFAULT 0,
  `HandWritting` varchar(50) NOT NULL DEFAULT 0,
  `Rhymes` varchar(50) NOT NULL DEFAULT 0,
  `ShapesColo` varchar(50) NOT NULL DEFAULT 0,
  `PSED` varchar(50) NOT NULL DEFAULT 0,
  `HealthHabit` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `ICT` varchar(50) NOT NULL DEFAULT 0
  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 ALTER TABLE `jss1` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `jss2` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `jss3` 
 ADD PRIMARY KEY (`id`);

ALTER TABLE `newtake` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `nursery1` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `nursery2` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `foundation` 
 ADD PRIMARY KEY (`id`);

ALTER TABLE `jss1`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;
 ALTER TABLE `jss2`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;
 ALTER TABLE `jss3`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `newtake`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `nursery1`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `nursery2`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `foundation`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

-- Batch 6 Close  Here







-- Batch 7 Close  Here

CREATE TABLE `sss1` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `CRK` varchar(50) NOT NULL DEFAULT 0,
  `IRK` varchar(50) NOT NULL DEFAULT 0,
  `Biology` varchar(50) NOT NULL DEFAULT 0,
  `ComputerSci` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `Commerce` varchar(50) NOT NULL DEFAULT 0,
  `Accounting` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `Arabic` varchar(50) NOT NULL DEFAULT 0,
  `Hausa` varchar(50) NOT NULL DEFAULT 0,
  `Economics` varchar(50) NOT NULL DEFAULT 0,
  `Geography` varchar(50) NOT NULL DEFAULT 0,
  `History` varchar(50) NOT NULL DEFAULT 0,
  `Government` varchar(50) NOT NULL DEFAULT 0,
  `Marketing` varchar(50) NOT NULL DEFAULT 0,
  `FurtherMath` varchar(50) NOT NULL DEFAULT 0,
  `TechDrawing` varchar(50) NOT NULL DEFAULT 0,
  `Physics` varchar(50) NOT NULL DEFAULT 0,
  `Chemistry` varchar(50) NOT NULL DEFAULT 0,
  `Literature` varchar(50) NOT NULL DEFAULT 0,
  `FoodNutri` varchar(50) NOT NULL DEFAULT 0,
  `DataPro` varchar(50) NOT NULL DEFAULT 0
  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `sss2` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `CRK` varchar(50) NOT NULL DEFAULT 0,
  `IRK` varchar(50) NOT NULL DEFAULT 0,
  `Biology` varchar(50) NOT NULL DEFAULT 0,
  `ComputerSci` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `Commerce` varchar(50) NOT NULL DEFAULT 0,
  `Accounting` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `Arabic` varchar(50) NOT NULL DEFAULT 0,
  `Hausa` varchar(50) NOT NULL DEFAULT 0,
  `Economics` varchar(50) NOT NULL DEFAULT 0,
  `Geography` varchar(50) NOT NULL DEFAULT 0,
  `History` varchar(50) NOT NULL DEFAULT 0,
  `Government` varchar(50) NOT NULL DEFAULT 0,
  `Marketing` varchar(50) NOT NULL DEFAULT 0,
  `FurtherMath` varchar(50) NOT NULL DEFAULT 0,
  `TechDrawing` varchar(50) NOT NULL DEFAULT 0,
  `Physics` varchar(50) NOT NULL DEFAULT 0,
  `Chemistry` varchar(50) NOT NULL DEFAULT 0,
  `Literature` varchar(50) NOT NULL DEFAULT 0,
  `FoodNutri` varchar(50) NOT NULL DEFAULT 0,
  `DataPro` varchar(50) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 CREATE TABLE `sss3` (
  `id` int NOT NULL,
  `Names` varchar(255) NOT NULL,
  `RegNumber` varchar(100) NOT NULL ,
  `Mathematics` varchar(50) NOT NULL DEFAULT 0,
  `English` varchar(50) NOT NULL DEFAULT 0,
  `CRK` varchar(50) NOT NULL DEFAULT 0,
  `IRK` varchar(50) NOT NULL DEFAULT 0,
  `Biology` varchar(50) NOT NULL DEFAULT 0,
  `ComputerSci` varchar(50) NOT NULL DEFAULT 0,
  `Civic` varchar(50) NOT NULL DEFAULT 0,
  `Commerce` varchar(50) NOT NULL DEFAULT 0,
  `Accounting` varchar(50) NOT NULL DEFAULT 0,
  `French` varchar(50) NOT NULL DEFAULT 0,
  `Arabic` varchar(50) NOT NULL DEFAULT 0,
  `Hausa` varchar(50) NOT NULL DEFAULT 0,
  `Economics` varchar(50) NOT NULL DEFAULT 0,
  `Geography` varchar(50) NOT NULL DEFAULT 0,
  `History` varchar(50) NOT NULL DEFAULT 0,
  `Government` varchar(50) NOT NULL DEFAULT 0,
  `Marketing` varchar(50) NOT NULL DEFAULT 0,
  `FurtherMath` varchar(50) NOT NULL DEFAULT 0,
  `TechDrawing` varchar(50) NOT NULL DEFAULT 0,
  `Physics` varchar(50) NOT NULL DEFAULT 0,
  `Chemistry` varchar(50) NOT NULL DEFAULT 0,
  `Literature` varchar(50) NOT NULL DEFAULT 0,
  `FoodNutri` varchar(50) NOT NULL DEFAULT 0,
  `DataPro` varchar(50) NOT NULL DEFAULT 0

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


ALTER TABLE `sss1` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `sss2` 
 ADD PRIMARY KEY (`id`);   

 ALTER TABLE `sss3` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `sss1`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `sss2`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

 ALTER TABLE `sss3`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

-- Batch 7 Close  Here




-- Batch 8 Start  Here

CREATE TABLE `assignment` (
  `id` int NOT NULL,
  `subjects` varchar(20) NOT NULL,
  `assignment` longtext NOT NULL ,
  `sclass` varchar(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
CREATE TABLE `note` (
  `id` int NOT NULL,
  `subjects` varchar(20) NOT NULL,
  `note` longtext NOT NULL ,
  `sclass` varchar(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `submitass` (
  `id` int NOT NULL,
  `names` varchar(20) NOT NULL,
  `regNumber` varchar(20) NOT NULL,
  `sclass` varchar(20) NOT NULL,
  `subjects` varchar(20) NOT NULL,
  `ans` longtext NOT NULL,
  `RegDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP 

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `uploadedresult` (
  `id` int NOT NULL,
  `regNumber` varchar(20) NOT NULL,
  `resultName` varchar(255) NOT NULL,
  `resultid` varchar(255) NOT NULL,
  `RegDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `assignment` 
 ADD PRIMARY KEY (`id`);

 ALTER TABLE `note` 
 ADD PRIMARY KEY (`id`); 

 ALTER TABLE `submitass` 
 ADD PRIMARY KEY (`id`);

ALTER TABLE `uploadedresult` 
 ADD PRIMARY KEY (`id`);

ALTER TABLE `assignment`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `note`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `submitass`
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

ALTER TABLE `uploadedresult` 
 MODIFY `id` int NOT NULL AUTO_INCREMENT;

-- Batch 8 Close  Here






















