Query.sql

-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.9.1-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 */;


-- Dumping database structure for school
DROP DATABASE IF EXISTS `school`;
CREATE DATABASE IF NOT EXISTS `school` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `school`;

-- Dumping structure for table school.admin
DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `USERNAME` VARCHAR(30) DEFAULT NULL,
  `PASSWORD` longtext NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Dumping data for table school.admin: ~2 rows (approximately)
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
REPLACE INTO `admin` (`ID`, `USERNAME`, `PASSWORD`) VALUES
    (1, 'admin', 'admin'),
    (2, 'root', 'root'),
    (3, 'alen', 'alen');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;

-- Dumping structure for table school.staff
DROP TABLE IF EXISTS `staff`;
CREATE TABLE IF NOT EXISTS `staff` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(30) DEFAULT NULL,
  `USERNAME` VARCHAR(30) DEFAULT NULL,
  `PASSWORD` longtext DEFAULT NULL,
  `WORK` VARCHAR(30) DEFAULT NULL,
  `DOB` DATE DEFAULT NULL,
  `PHONENUMBER` INT(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table school.staff: ~0 rows (approximately)
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
REPLACE INTO `staff` (`ID`, `NAME`, `USERNAME`, `PASSWORD`, `WORK`, `DOB`, `PHONENUMBER`) VALUES
    (1, 'ALEN TL', 'ALENTL', 'Alen@1398', 'RECEPTION', '2005-10-13', 0);
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;

-- Dumping structure for table school.staff_leave
DROP TABLE IF EXISTS `staff_leave`;
CREATE TABLE IF NOT EXISTS `staff_leave` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(30) DEFAULT NULL,
  `STARTDATE` DATE DEFAULT NULL,
  `ENDDATE` DATE DEFAULT NULL,
  `REASON` longtext NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table school.staff_leave: ~0 rows (approximately)
/*!40000 ALTER TABLE `staff_leave` DISABLE KEYS */;
REPLACE INTO `staff_leave` (`ID`, `NAME`, `STARTDATE`, `ENDDATE`, `REASON`) VALUES
    (1, 'ALEN TL', '2022-10-31', '2022-10-31', '');
/*!40000 ALTER TABLE `staff_leave` ENABLE KEYS */;

-- Dumping structure for table school.students
DROP TABLE IF EXISTS `students`;
CREATE TABLE IF NOT EXISTS `students` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(50) DEFAULT NULL,
  `USERNAME` VARCHAR(30) DEFAULT NULL,
  `PASSWORD` longtext NOT NULL,
  `CLASS` INT(11) DEFAULT NULL,
  `DIVISION` VARCHAR(10) DEFAULT NULL,
  `STREAM` VARCHAR(255) DEFAULT NULL,
  `DOB` DATE DEFAULT NULL,
  `PHONENUMBR` INT(11) NOT NULL DEFAULT 0,
  `ADDRESS` longtext DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table school.students: ~0 rows (approximately)
/*!40000 ALTER TABLE `students` DISABLE KEYS */;
REPLACE INTO `students` (`ID`, `NAME`, `USERNAME`, `PASSWORD`, `CLASS`, `DIVISION`, `STREAM`, `DOB`, `PHONENUMBR`, `ADDRESS`) VALUES
    (1, 'ALEN TL', 'ALENTL', 'Alen@1398', 12, 'A', 'Computer Science', '2005-10-13', 0, NULL);
/*!40000 ALTER TABLE `students` ENABLE KEYS */;

-- Dumping structure for table school.stud_leave
DROP TABLE IF EXISTS `stud_leave`;
CREATE TABLE IF NOT EXISTS `stud_leave` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(30) DEFAULT NULL,
  `CLASS` INT(11) DEFAULT NULL,
  `DIVISION` VARCHAR(2) DEFAULT NULL,
  `STARTDATE` DATE DEFAULT NULL,
  `ENDDATE` DATE DEFAULT NULL,
  `REASON` longtext NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table school.stud_leave: ~0 rows (approximately)
/*!40000 ALTER TABLE `stud_leave` DISABLE KEYS */;
REPLACE INTO `stud_leave` (`ID`, `NAME`, `CLASS`, `DIVISION`, `STARTDATE`, `ENDDATE`, `REASON`) VALUES
    (1, 'ALEN TL', 12, 'A', '2022-10-31', '2022-11-01', 'Rain');
/*!40000 ALTER TABLE `stud_leave` ENABLE KEYS */;

-- Dumping structure for table school.teachers
DROP TABLE IF EXISTS `teachers`;
CREATE TABLE IF NOT EXISTS `teachers` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(30) DEFAULT NULL,
  `USERNAME` VARCHAR(30) DEFAULT NULL,
  `PASSWORD` longtext NOT NULL,
  `subject` VARCHAR(30) DEFAULT NULL,
  `DOB` DATE DEFAULT NULL,
  `PHONENUMBER` INT(11) NOT NULL DEFAULT 0,
  `ADDRESS` longtext DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table school.teachers: ~0 rows (approximately)
/*!40000 ALTER TABLE `teachers` DISABLE KEYS */;
REPLACE INTO `teachers` (`ID`, `NAME`, `USERNAME`, `PASSWORD`, `subject`, `DOB`, `PHONENUMBER`, `ADDRESS`) VALUES
    (1, 'ALEX', 'ALENTL', 'Alen@1398', 'COMPUTER', '2005-10-13', 0, NULL);
/*!40000 ALTER TABLE `teachers` ENABLE KEYS */;

-- Dumping structure for table school.teacher_leave
DROP TABLE IF EXISTS `teacher_leave`;
CREATE TABLE IF NOT EXISTS `teacher_leave` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `NAME` VARCHAR(30) DEFAULT NULL,
  `STARTDATE` DATE DEFAULT NULL,
  `ENDDATE` DATE DEFAULT NULL,
  `REASON` longtext NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table school.teacher_leave: ~4 rows (approximately)
/*!40000 ALTER TABLE `teacher_leave` DISABLE KEYS */;
REPLACE INTO `teacher_leave` (`ID`, `NAME`, `STARTDATE`, `ENDDATE`, `REASON`) VALUES
    (1, 'ALEN TL', '2022-10-31', '2022-10-31', 'FEVER'),
    (2, 'ALEN TL', '2022-10-31', '2022-10-31', ''),
    (3, 'ALEN TL', '2022-10-31', '2022-10-31', ''),
    (4, 'ALEN TL', '2022-10-31', '2022-10-31', '');
/*!40000 ALTER TABLE `teacher_leave` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;