· 2 years ago · Nov 19, 2022, 12:50 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.9.1-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 11.3.0.6295
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
14
15
16-- Dumping database structure for school
17DROP DATABASE IF EXISTS `school`;
18CREATE DATABASE IF NOT EXISTS `school` /*!40100 DEFAULT CHARACTER SET latin1 */;
19USE `school`;
20
21-- Dumping structure for table school.admin
22DROP TABLE IF EXISTS `admin`;
23CREATE TABLE IF NOT EXISTS `admin` (
24 `ID` int(11) NOT NULL AUTO_INCREMENT,
25 `USERNAME` varchar(30) DEFAULT NULL,
26 `PASSWORD` longtext NOT NULL,
27 PRIMARY KEY (`ID`)
28) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
29
30-- Dumping data for table school.admin: ~2 rows (approximately)
31/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
32REPLACE INTO `admin` (`ID`, `USERNAME`, `PASSWORD`) VALUES
33 (1, 'admin', 'admin'),
34 (2, 'root', 'root'),
35 (3, 'alen', 'alen');
36/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
37
38-- Dumping structure for table school.staff
39DROP TABLE IF EXISTS `staff`;
40CREATE TABLE IF NOT EXISTS `staff` (
41 `ID` int(11) NOT NULL AUTO_INCREMENT,
42 `NAME` varchar(30) DEFAULT NULL,
43 `USERNAME` varchar(30) DEFAULT NULL,
44 `PASSWORD` longtext DEFAULT NULL,
45 `WORK` varchar(30) DEFAULT NULL,
46 `DOB` date DEFAULT NULL,
47 `PHONENUMBER` int(11) NOT NULL DEFAULT 0,
48 PRIMARY KEY (`ID`)
49) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
50
51-- Dumping data for table school.staff: ~0 rows (approximately)
52/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
53REPLACE INTO `staff` (`ID`, `NAME`, `USERNAME`, `PASSWORD`, `WORK`, `DOB`, `PHONENUMBER`) VALUES
54 (1, 'ALEN TL', 'ALENTL', 'Alen@1398', 'RECEPTION', '2005-10-13', 0);
55/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
56
57-- Dumping structure for table school.staff_leave
58DROP TABLE IF EXISTS `staff_leave`;
59CREATE TABLE IF NOT EXISTS `staff_leave` (
60 `ID` int(11) NOT NULL AUTO_INCREMENT,
61 `NAME` varchar(30) DEFAULT NULL,
62 `STARTDATE` date DEFAULT NULL,
63 `ENDDATE` date DEFAULT NULL,
64 `REASON` longtext NOT NULL,
65 PRIMARY KEY (`ID`)
66) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
67
68-- Dumping data for table school.staff_leave: ~0 rows (approximately)
69/*!40000 ALTER TABLE `staff_leave` DISABLE KEYS */;
70REPLACE INTO `staff_leave` (`ID`, `NAME`, `STARTDATE`, `ENDDATE`, `REASON`) VALUES
71 (1, 'ALEN TL', '2022-10-31', '2022-10-31', '');
72/*!40000 ALTER TABLE `staff_leave` ENABLE KEYS */;
73
74-- Dumping structure for table school.students
75DROP TABLE IF EXISTS `students`;
76CREATE TABLE IF NOT EXISTS `students` (
77 `ID` int(11) NOT NULL AUTO_INCREMENT,
78 `NAME` varchar(50) DEFAULT NULL,
79 `USERNAME` varchar(30) DEFAULT NULL,
80 `PASSWORD` longtext NOT NULL,
81 `CLASS` int(11) DEFAULT NULL,
82 `DIVISION` varchar(10) DEFAULT NULL,
83 `STREAM` varchar(255) DEFAULT NULL,
84 `DOB` date DEFAULT NULL,
85 `PHONENUMBR` int(11) NOT NULL DEFAULT 0,
86 `ADDRESS` longtext DEFAULT NULL,
87 PRIMARY KEY (`ID`)
88) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
89
90-- Dumping data for table school.students: ~0 rows (approximately)
91/*!40000 ALTER TABLE `students` DISABLE KEYS */;
92REPLACE INTO `students` (`ID`, `NAME`, `USERNAME`, `PASSWORD`, `CLASS`, `DIVISION`, `STREAM`, `DOB`, `PHONENUMBR`, `ADDRESS`) VALUES
93 (1, 'ALEN TL', 'ALENTL', 'Alen@1398', 12, 'A', 'Computer Science', '2005-10-13', 0, NULL);
94/*!40000 ALTER TABLE `students` ENABLE KEYS */;
95
96-- Dumping structure for table school.stud_leave
97DROP TABLE IF EXISTS `stud_leave`;
98CREATE TABLE IF NOT EXISTS `stud_leave` (
99 `ID` int(11) NOT NULL AUTO_INCREMENT,
100 `NAME` varchar(30) DEFAULT NULL,
101 `CLASS` int(11) DEFAULT NULL,
102 `DIVISION` varchar(2) DEFAULT NULL,
103 `STARTDATE` date DEFAULT NULL,
104 `ENDDATE` date DEFAULT NULL,
105 `REASON` longtext NOT NULL,
106 PRIMARY KEY (`ID`)
107) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
108
109-- Dumping data for table school.stud_leave: ~0 rows (approximately)
110/*!40000 ALTER TABLE `stud_leave` DISABLE KEYS */;
111REPLACE INTO `stud_leave` (`ID`, `NAME`, `CLASS`, `DIVISION`, `STARTDATE`, `ENDDATE`, `REASON`) VALUES
112 (1, 'ALEN TL', 12, 'A', '2022-10-31', '2022-11-01', 'Rain');
113/*!40000 ALTER TABLE `stud_leave` ENABLE KEYS */;
114
115-- Dumping structure for table school.teachers
116DROP TABLE IF EXISTS `teachers`;
117CREATE TABLE IF NOT EXISTS `teachers` (
118 `ID` int(11) NOT NULL AUTO_INCREMENT,
119 `NAME` varchar(30) DEFAULT NULL,
120 `USERNAME` varchar(30) DEFAULT NULL,
121 `PASSWORD` longtext NOT NULL,
122 `subject` varchar(30) DEFAULT NULL,
123 `DOB` date DEFAULT NULL,
124 `PHONENUMBER` int(11) NOT NULL DEFAULT 0,
125 `ADDRESS` longtext DEFAULT NULL,
126 PRIMARY KEY (`ID`)
127) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
128
129-- Dumping data for table school.teachers: ~0 rows (approximately)
130/*!40000 ALTER TABLE `teachers` DISABLE KEYS */;
131REPLACE INTO `teachers` (`ID`, `NAME`, `USERNAME`, `PASSWORD`, `subject`, `DOB`, `PHONENUMBER`, `ADDRESS`) VALUES
132 (1, 'ALEX', 'ALENTL', 'Alen@1398', 'COMPUTER', '2005-10-13', 0, NULL);
133/*!40000 ALTER TABLE `teachers` ENABLE KEYS */;
134
135-- Dumping structure for table school.teacher_leave
136DROP TABLE IF EXISTS `teacher_leave`;
137CREATE TABLE IF NOT EXISTS `teacher_leave` (
138 `ID` int(11) NOT NULL AUTO_INCREMENT,
139 `NAME` varchar(30) DEFAULT NULL,
140 `STARTDATE` date DEFAULT NULL,
141 `ENDDATE` date DEFAULT NULL,
142 `REASON` longtext NOT NULL,
143 PRIMARY KEY (`ID`)
144) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
145
146-- Dumping data for table school.teacher_leave: ~4 rows (approximately)
147/*!40000 ALTER TABLE `teacher_leave` DISABLE KEYS */;
148REPLACE INTO `teacher_leave` (`ID`, `NAME`, `STARTDATE`, `ENDDATE`, `REASON`) VALUES
149 (1, 'ALEN TL', '2022-10-31', '2022-10-31', 'FEVER'),
150 (2, 'ALEN TL', '2022-10-31', '2022-10-31', ''),
151 (3, 'ALEN TL', '2022-10-31', '2022-10-31', ''),
152 (4, 'ALEN TL', '2022-10-31', '2022-10-31', '');
153/*!40000 ALTER TABLE `teacher_leave` ENABLE KEYS */;
154
155/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
156/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
157/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
158/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
159