-
Notifications
You must be signed in to change notification settings - Fork 0
/
SIMS Database Sql .txt
125 lines (94 loc) · 2.98 KB
/
SIMS Database Sql .txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
-- Create the school_management_system database
CREATE DATABASE schoolmanagementsystem;
-- Use the schoolmanagementsystemdatabase
USE schoolmanagementsystem;
CREATE TABLE `admin` (
`AID` int NOT NULL,
`name` varchar(45) DEFAULT NULL,
`age` int DEFAULT NULL,
`address` varchar(45) DEFAULT NULL,
`phone` int DEFAULT NULL,
`nic` varchar(45) DEFAULT NULL,
`email` varchar(45) DEFAULT NULL,
`position` varchar(45) DEFAULT NULL,
`salary` double DEFAULT NULL,
`username` varchar(45) DEFAULT NULL,
`password` varchar(45) DEFAULT NULL,
PRIMARY KEY (`AID`)
) ;
INSERT INTO `admin` VALUES (1,'John Doe',30,'123 Main St',1234567890,'ABC123456','john@example.com','Administrator',50000,'admin','password');
CREATE TABLE `garde` (
`gId` int NOT NULL,
`garde` varchar(45) DEFAULT NULL,
`amount` varchar(45) DEFAULT NULL,
PRIMARY KEY (`gId`)
) ;
CREATE TABLE `notices` (
`noticeID` int NOT NULL AUTO_INCREMENT,
`title` varchar(145) DEFAULT NULL,
`description` varchar(500) DEFAULT NULL,
PRIMARY KEY (`noticeID`)
) ;
CREATE TABLE `payment` (
`payID` int NOT NULL,
`cardNo` varchar(45) DEFAULT NULL,
`name` varchar(45) DEFAULT NULL,
`expiryDate` varchar(45) DEFAULT NULL,
`cvv` int DEFAULT NULL,
PRIMARY KEY (`payID`)
) ;
CREATE TABLE `student` (
`sid` int NOT NULL,
`name`varchar(75) DEFAULT NULL,
`age` int DEFAULT NULL,
`address` varchar(75) DEFAULT NULL,
`phone` int DEFAULT NULL,
`grade` int DEFAULT NULL,
`regstatus` varchar(45) DEFAULT NULL,
`username` varchar(75) DEFAULT NULL,
`password` varchar(45) DEFAULT NULL,
PRIMARY KEY (`sid`)
) ;
CREATE TABLE `subject` (
`subjectID` varchar(50) NOT NULL,
`teacherID` int DEFAULT NULL,
`name` varchar(45) DEFAULT NULL,
`description` varchar(495) DEFAULT NULL,
`hours` int DEFAULT NULL,
PRIMARY KEY (`subjectID`)
);
CREATE TABLE `teacher` (
`teacherID` int NOT NULL,
`name` varchar(45) DEFAULT NULL,
`age` int DEFAULT NULL,
`nic` varchar(45) DEFAULT NULL,
`address` varchar(45) DEFAULT NULL,
`phone` int DEFAULT NULL,
`email` varchar(45) DEFAULT NULL,
`salary` double DEFAULT NULL,
`username` varchar(45) DEFAULT NULL,
`password` varchar(45) DEFAULT NULL,
PRIMARY KEY (`teacherID`)
) ;
INSERT INTO `teacher` VALUES (0,'Jane Smith ',22,'200056492916','kandy',776543321,'jane.smith@email.com',70000,'Jane Smith','321');
CREATE TABLE `user` (
`username` int NOT NULL,
`password` varchar(15) DEFAULT NULL,
`name` varchar(45) DEFAULT NULL,
`age` int DEFAULT NULL,
`address` varchar(45) DEFAULT NULL,
`phone` int DEFAULT NULL,
PRIMARY KEY (`username`)
) ;
CREATE TABLE `principle` (
`PID` int NOT NULL AUTO_INCREMENT,
`name` varchar(45) DEFAULT NULL,
`age` int DEFAULT NULL,
`address` varchar(45) DEFAULT NULL,
`phone` int DEFAULT NULL,
`nic` varchar(45) DEFAULT NULL,
`username` varchar(45) DEFAULT NULL,
`password` varchar(45) DEFAULT NULL,
PRIMARY KEY (`PID`)
) ;
INSERT INTO `principle` VALUES (1,'kasun',55,'kandy',787710175,'997633765V','kasun','111222');