-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathqlcc.sql
117 lines (109 loc) · 6.54 KB
/
qlcc.sql
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
drop database if exists qlcc;
create database qlcc ;
use qlcc;
CREATE TABLE gv(
magv varchar(6) not null primary key,
tengv varchar(50) not null COLLATE utf8_unicode_ci,
gmail varchar(50) not null
)ENGINE=InnoDB;
-- CREATE TABLE bangchamcong(
-- mabcc varchar(10) not null primary key,
-- diengiai varchar(100) COLLATE utf8_unicode_ci
-- )ENGINE=InnoDB;
CREATE TABLE congviec(
macongviec varchar(3) CHARACTER SET utf8 COLLATE utf8_bin not null primary key,
noidung varchar(200) COLLATE utf8_unicode_ci
)ENGINE=InnoDB;
-- CREATE TABLE ctbangchamcong(
-- mactbcc int auto_increment not null,
-- mabcc varchar(10),
-- macongviec varchar(3) CHARACTER SET utf8 COLLATE utf8_bin,
-- primary key(mactbcc,mabcc,macongviec),
-- foreign key(mabcc) references bangchamcong(mabcc),
-- foreign key(macongviec) references congviec(macongviec)
-- )ENGINE=InnoDB;
CREATE TABLE ctcongviec(
magv varchar(6),
macongviec varchar(3) CHARACTER SET utf8 COLLATE utf8_bin,
ngaythuchien date,
buoi varchar(6),
ghichu varchar(200) COLLATE utf8_unicode_ci,
primary key(magv,ngaythuchien,buoi),
foreign key (macongviec) references congviec(macongviec),
foreign key (magv) references gv(magv)
)ENGINE=InnoDB;
-- isert giang vien
INSERT INTO gv(magv,tengv,gmail) VALUES('12661','Võ Phước Hưng','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00241','Nguyễn Hoàng Duy Thiện','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('14204','Nguyễn Bá Nhiệm','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00245','Nguyễn Bảo Ân','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00250','Võ Thành C','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00248','Phạm Minh Đương','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('12705','Nguyễn Trần Diễm Hạnh','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00257','Nguyễn Mộng Hiền','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00254','Ngô Thanh Huy','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00242','Dương Ngọc Vân Khanh','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00244','Nguyễn Nhứt Lam','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00255','Phạm Thị Trúc Mai','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00253','Đoàn Phước Miền','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('12701','Trần Văn Nam','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00252','Trầm Hoàng Nam','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('03546','Phan Thị Phương Nam','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('12700','Khấu Văn Nhựt','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00258','Nhan Minh Phúc','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('03562','Nguyễn Khắc Quốc','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('12702','Nguyễn Thừa Phát Tài','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00243','Huỳnh Văn Thanh','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00246','Nguyễn Ngọc Đan Thanh','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('03539','Lê Minh Tự','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00249','Hà Thị Thúy Vi','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('00251','Trịnh Quốc Việt','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('123456','Mai Ngọc Thanh Tân','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('654321','Ngô Quốc Anh','[email protected]');
INSERT INTO gv(magv,tengv,gmail) VALUES('456789','Lâm Công Đỉnh','[email protected]');
-- isert macongviec
INSERT INTO congviec(macongviec,noidung) VALUES('+','');
INSERT INTO congviec(macongviec,noidung) VALUES('X','');
INSERT INTO congviec(macongviec,noidung) VALUES('S1','');
INSERT INTO congviec(macongviec,noidung) VALUES('S2','');
INSERT INTO congviec(macongviec,noidung) VALUES('S3','');
INSERT INTO congviec(macongviec,noidung) VALUES('S4','');
INSERT INTO congviec(macongviec,noidung) VALUES('S5','');
INSERT INTO congviec(macongviec,noidung) VALUES('C1','');
INSERT INTO congviec(macongviec,noidung) VALUES('C2','');
INSERT INTO congviec(macongviec,noidung) VALUES('C3','');
INSERT INTO congviec(macongviec,noidung) VALUES('C4','');
INSERT INTO congviec(macongviec,noidung) VALUES('C5','');
INSERT INTO congviec(macongviec,noidung) VALUES('T1','');
INSERT INTO congviec(macongviec,noidung) VALUES('T2','');
INSERT INTO congviec(macongviec,noidung) VALUES('T3','');
INSERT INTO congviec(macongviec,noidung) VALUES('T4','');
INSERT INTO congviec(macongviec,noidung) VALUES('T5','');
INSERT INTO congviec(macongviec,noidung) VALUES('Ts','');
INSERT INTO congviec(macongviec,noidung) VALUES('Ds','');
INSERT INTO congviec(macongviec,noidung) VALUES('Nb','');
INSERT INTO congviec(macongviec,noidung) VALUES('L','');
INSERT INTO congviec(macongviec,noidung) VALUES('V','');
INSERT INTO congviec(macongviec,noidung) VALUES('R','');
INSERT INTO congviec(macongviec,noidung) VALUES('P1','');
INSERT INTO congviec(macongviec,noidung) VALUES('P2','');
INSERT INTO congviec(macongviec,noidung) VALUES('P3','');
INSERT INTO congviec(macongviec,noidung) VALUES('P4','');
INSERT INTO congviec(macongviec,noidung) VALUES('P5','');
INSERT INTO congviec(macongviec,noidung) VALUES('No','');
INSERT INTO congviec(macongviec,noidung) VALUES('TS','');
INSERT INTO congviec(macongviec,noidung) VALUES('P','');
INSERT INTO congviec(macongviec,noidung) VALUES('NH','');
INSERT INTO congviec(macongviec,noidung) VALUES('xx','');
INSERT INTO congviec(macongviec,noidung) VALUES('Cô','');
INSERT INTO congviec(macongviec,noidung) VALUES('Ô','');
INSERT INTO congviec(macongviec,noidung) VALUES('CT','');
INSERT INTO congviec(macongviec,noidung) VALUES('ct','');
INSERT INTO congviec(macongviec,noidung) VALUES('TR','');
INSERT INTO congviec(macongviec,noidung) VALUES('Đ','');
INSERT INTO congviec(macongviec,noidung) VALUES('DL','');
INSERT INTO congviec(macongviec,noidung) VALUES('DT','');
INSERT INTO congviec(macongviec,noidung) VALUES('TC','');
INSERT INTO congviec(macongviec,noidung) VALUES('c','');
INSERT INTO congviec(macongviec,noidung) VALUES('H','');
INSERT INTO congviec(macongviec,noidung) VALUES('','Không có lịch');