forked from Tam-Vu/StudentManagement-backend
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsql syntax.txt
More file actions
107 lines (89 loc) · 7.02 KB
/
Copy pathsql syntax.txt
File metadata and controls
107 lines (89 loc) · 7.02 KB
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
Môn học sẽ tự nhập tay, lần lượt gồm: tên, hệ số điểm 15p, hệ số điểm 45p, hệ số điểm cuối kì, hệ số điểm của môn
------------------------------------------------------------------------------------------------------------
select * from subjectresults
select * from summaries
select * from subjects
select * from tuitions
select * from users
select * from subjectresults
select * from students
select * from teachers
select * from classes
select * from grades
select * from subjects
select * from assignments
select * from params
select * from schoolreports
select * from users
select * from typeinfringes
select * from summariesdetails
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('excellentCore', '8', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('excellentDiscipline', '90', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('goodCore', '7', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('goodDiscipline', '80', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('averageCore', '5', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('averageDiscipline', '70', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('badCore', '3', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('badDiscipline', '60', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('teacherSlug', '1', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('studentSlug', '1', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('term', '2024', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('typeterm', '1', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('changeable', '1', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('maxage', '20', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('minage', '15', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('maxattendances', '40', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('maxtenthclasses', '4', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('maxtwelfthclasses', '3', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`params` (`paramName`, `paramValue`, `paramNote`, `createdAt`, `updatedAt`)
VALUES ('maxeleventhclasses', '2', null, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('vô lễ', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('sử dụng chất kích thích', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('đánh bạc', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('đánh nhau, gây rối', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('nói tục, chửi thề', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('mang vũ khí, vật sắc nhọn, chất nổ', '5',CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('lưu trữ các loại văn hóa phẩm đồi trụy', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('đi xe trong trường', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('đi xe khi chưa có bằng', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('phá hoại tài sản nhà trường', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('áo bỏ ngoài quần', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('nằm, ngồi trên lan can, bàn ghế', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('nhuộm tóc, để tóc quá dài hoặc quá ngắn', '5', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('cấm tô son, sơn móng', '2', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('vẽ lên tường bàn ghế', '2', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO `studentmanagement`.`typeinfringes` (`typename`, `minuspoint`, `createdAt`, `updatedAt`)
VALUES ('đi học trễ', '3', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);