-- MySQL dump 10.13  Distrib 5.5.62, for linux-glibc2.12 (x86_64)
--
-- Host: localhost    Database: sdcs
-- ------------------------------------------------------
-- Server version	5.5.62

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `subject`
--

DROP TABLE IF EXISTS `subject`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class` varchar(33) NOT NULL,
  `subject_name` varchar(33) NOT NULL,
  `subject_short_name` varchar(33) NOT NULL,
  `subject_code` varchar(33) NOT NULL,
  `priority` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `username` varchar(33) NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  `applicable_year` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=112 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subject`
--

LOCK TABLES `subject` WRITE;
/*!40000 ALTER TABLE `subject` DISABLE KEYS */;
INSERT INTO `subject` VALUES (1,'2','English','Eng','101',0,1,'admin2','1536052620','2021,2022,2023,2024'),(2,'2','Maths ','Mat','201',0,1,'admin2','1536052639','2021,2022,2023,2024'),(3,'2','Personal Development ','PD','301',0,1,'admin2','1536052651','2021,2022,2023,2024'),(4,'2','Science ','Sci','401',0,1,'admin2','1536052664','2021,2022,2023,2024'),(5,'2','Social Science ','SSci','501',0,1,'admin2','1536052676','2021,2022,2023,2024'),(6,'2','Business Studies ','BS','511',0,1,'admin2','1536052699','2021,2022,2023,2024'),(7,'2','Agriculture ','Ag','521',0,1,'admin2','1536052761','2021,2022,2023,2024'),(8,'2','Arts','Arts','531',0,1,'admin2','1536052839','2021,2022,2023,2024'),(10,'2','Design And Technology ','DT','541',0,1,'admin2','1536052956','2021,2022,2023,2024'),(11,'2','Home Economics ','HE','551',0,1,'admin2','1536052968','2021,2022,2023,2024'),(12,'2','Practical Skills ','PS','561',0,1,'admin2','1536052982','2021,2022,2023,2024'),(13,'2','Information Technology ','IT','571',0,1,'admin2','1536053002','2021,2022,2023,2024'),(14,'5','Written Expression ','WEX','102',0,1,'admin2','1536052620','2021,2022,2023,2024,2025'),(15,'5','Objective English ','ObjEng','101',0,1,'admin2','1536052639','2021,2022,2023,2024,2025'),(16,'5','Maths ','Mat','201',0,1,'admin2','1536052651','2021,2022,2023,2024,2025'),(17,'5','Combined Subjects ','Comb','601',0,1,'admin2','1536052664','2021,2022,2023,2024,2025'),(18,'5','Science ','Sci','301',0,1,'admin2','1536052676','2021,2022,2023,2024,2025'),(19,'5','Social Science ','SSci','401',0,1,'admin2','1536052699','2021,2022,2023,2024,2025'),(20,'5','Making a Living','MAL','421',0,1,'admin2','1536052761','2021,2022,2023,2024,2025'),(21,'4','Language & Literature ','LL','101',0,1,'admin2','1536052839','2021,2022,2023,2024,2025'),(22,'4','Applied English ','AE','102',0,1,'admin2','1536052956','2021,2022,2023,2024,2025'),(23,'4','Advance Maths ','AM','201',0,1,'admin2','1536052968','2021,2022,2023,2024,2025'),(24,'4','General Maths ','GM','202',0,1,'admin2','1536052982','2021,2022,2023,2024,2025'),(25,'4','Biology ','BIO','301',0,1,'admin2','1536053002','2021,2022,2023,2024,2025'),(26,'4','Chemistry ','CHE','302',0,1,'admin3','1536053002','2021,2022,2023,2024,2025'),(27,'4','Physics ','PHY','303',0,1,'admin4','1536053002','2021,2022,2023,2024,2025'),(28,'4','Applied Science ','AS','304',0,1,'admin5','1536053002','2021,2022,2023,2024,2025'),(29,'4','Geology ','GL','305',0,1,'admin6','1536053002','2021,2022,2023,2024,2025'),(30,'4','Economics ','ECO','401',0,1,'admin7','1536053002','2021,2022,2023,2024,2025'),(31,'4','Business Studies ','BS','402',0,1,'admin8','1536053002','2021,2022,2023,2024,2025'),(32,'4','Accounting ','ACC','403',0,1,'admin9','1536053002','2021,2022,2023,2024,2025'),(33,'4','Geography','GG','404',0,1,'admin10','1536053002','2021,2022,2023,2024,2025'),(34,'4','History','HIS','405',0,1,'admin11','1536053002','2021,2022,2023,2024,2025'),(35,'4','Legal Studies ','LS','406',0,1,'admin12','1536053002','2021,2022,2023,2024,2025'),(36,'4','Information  Communication Tech','IT','407',0,1,'admin13','1536053002','2021,2022,2023,2024,2025'),(37,'5','Agriculture','AG','501',0,2,'admin2','1536053615','2021,2022,2023,2024,2025'),(38,'5','Commerce','COMM','511',0,2,'admin2','1536053631','2021,2022,2023,2024,2025'),(39,'5','Religion','RE','521',0,2,'admin2','1536053642','2021,2022,2023,2024,2025'),(40,'4','Physical Education','PE','501',0,2,'admin2','1536053669','2021,2022,2023,2024,2025'),(41,'4','Agriculture','Ag','502',0,2,'admin2','1536053680','2021,2022,2023,2024,2025'),(42,'4','Forestry','FO','503',0,2,'admin2','1536053695','2021,2022,2023,2024,2025'),(43,'4','Fisheries','FI','504',0,2,'admin2','1536053710','2021,2022,2023,2024,2025'),(44,'4','Applied Nat. Resources Mgt','ANRM','505',0,2,'admin2','1536053730','2021,2022,2023,2024,2025'),(45,'4','Music','MU','506',0,2,'admin2','1536053740','2021,2022,2023,2024,2025'),(46,'4','Theatre Arts','TA','507',0,2,'admin2','1536053753','2021,2022,2023,2024,2025'),(47,'4','Visual Arts','VA','508',0,2,'admin2','1536053767','2021,2022,2023,2024,2025'),(48,'4','Design And Technology','DT','509',0,2,'admin2','1536053780','2021,2022,2023,2024,2025'),(49,'4','Practical Skills','PS','510',0,2,'admin2','1536053793','2021,2022,2023,2024,2025'),(50,'4','Food Technology','FT','511',0,2,'admin2','1536053804','2021,2022,2023,2024,2025'),(51,'4','Textile Technology','TT','512',0,2,'admin2','1536053816','2021,2022,2023,2024,2025'),(52,'4','Tourism Studies','TS','513',0,2,'admin2','1536053826','2021,2022,2023,2024,2025'),(53,'4','Computer Studies','CS','514',0,2,'admin2','1536053835','2021,2022,2023,2024,2025'),(54,'4','Personality Development','PD','515',0,2,'admin2','1536053845','2021,2022,2023,2024,2025'),(55,'4','Religious Education','RE','516',0,2,'admin2','1536053855','2021,2022,2023,2024,2025'),(56,'5','Personality Development','PD','411',0,1,'admin2','1536053845','2021,2022,2023,2024,2025'),(57,'5','Arts','ART','431',0,1,'admin2','1536053845','2021,2022,2023,2024,2025'),(102,'2','Maths ','Mat','201',0,1,'admin2','1536052639','2025'),(101,'2','English','Eng','101',0,1,'admin2','1536052620','2025'),(103,'2','CCVE','CCVE','301',0,1,'admin2','1536052651','2025'),(104,'2','Science ','Sci','401',0,1,'admin2','1536052664','2025'),(105,'2','Social Science ','SSci','501',0,1,'admin2','1536052676','2025'),(106,'2','Business Studies ','BS','511',0,1,'admin2','1536052699','2025'),(107,'2','Agriculture ','Ag','521',0,1,'admin2','1536052761','2025'),(108,'2','Arts','Arts','531',0,1,'admin2','1536052839','2025'),(109,'2','Tech And Industrial Arts','TIA','541',0,1,'admin2','1536052956','2025'),(110,'2','ICCT','ICCT','551',0,1,'admin2','1536052968','2025');
/*!40000 ALTER TABLE `subject` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-09 22:00:09
