-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathinsertDB1.sql
More file actions
185 lines (121 loc) · 8.63 KB
/
insertDB1.sql
File metadata and controls
185 lines (121 loc) · 8.63 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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
insert into "NhanVien"("MaNV","TenNV","SDT_NV","EmailNV","AnhNV","MatKhauNV")
values ('NV001','Trần Ngọc Sang','0123456789','sang1@gmail.com','#','$2b$05$1K8cnnvxyDmOf6/ZuaXJ/eK7TDYbbEbZZP35ugzNnTwmE6OBe9FAG');
-- sang123
-- $2b$05$1K8cnnvxyDmOf6/ZuaXJ/eK7TDYbbEbZZP35ugzNnTwmE6OBe9FAG
insert into "NhanVien"("MaNV","TenNV","SDT_NV","EmailNV","AnhNV","MatKhauNV")
values ('NV002','Lê Thọ','012312415','tho1@gmail.com','#','$2b$05$ETRsQcnO7VsnKCaR/SsO6eaBouseuOFeweRh90Wween9ObQ7WFNBW');
--------------------------------------------------------------------------------
------------------ Insert "GiaiDau"
insert into "GiaiDau"("MaGD","TenGD","DoTuoiTGNhoNhat","DoTuoiTGLonNhat","SoDBThamGia","MaNV","HanCuoiDangKy")
values ('GD001','AFF CUP','10','15','16','NV001','2021-12-26 0:0:0');
insert into "GiaiDau"("MaGD","TenGD","DoTuoiTGNhoNhat","DoTuoiTGLonNhat","SoDBThamGia","MaNV","HanCuoiDangKy")
values ('GD003','World Cup','10','15','16','NV001','2021-12-24 0:0:0');
insert into "GiaiDau"("MaGD","TenGD","DoTuoiTGNhoNhat","DoTuoiTGLonNhat","SoDBThamGia","MaNV","HanCuoiDangKy")
values ('GD004','C1','20','30','16','NV001','2021-12-24 0:0:0');
insert into "GiaiDau"("MaGD","TenGD","DoTuoiTGNhoNhat","DoTuoiTGLonNhat","SoDBThamGia","MaNV","HanCuoiDangKy")
values ('GD005','C2','15','22','16','NV001','2021-12-24 0:0:0');
insert into "GiaiDau"("MaGD","TenGD","DoTuoiTGNhoNhat","DoTuoiTGLonNhat","SoDBThamGia","MaNV","HanCuoiDangKy")
values ('GD006','Euro','12','16','16','NV001','2021-12-24 0:0:0');
insert into "GiaiDau"("MaGD","TenGD","DoTuoiTGNhoNhat","DoTuoiTGLonNhat","SoDBThamGia","MaNV","HanCuoiDangKy")
values ('GD007','Asian Cup','12','20','16','NV001','2021-12-26 0:0:0');
--------------------------------------------------------------------------------
------------------ Insert "NguoiDangKy"
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values ('NDK01','Nguyễn Thị Tiểu Mi','0987654321','mi1@gmail.com','#','$2b$05$uWU7XdaEPdRzz0aDBuajNOhXL4iegu7zj1H2BljrVXmpt6Fn1odgi');
-- miabc123
-- $2b$05$uWU7XdaEPdRzz0aDBuajNOhXL4iegu7zj1H2BljrVXmpt6Fn1odgi
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values ('NDK02','super man','0113114115','super@gmail.com','#','$2b$05$0gfscB95b8kH3fZ8eDRU6uS5FWT/TEuHB918N9gM8br9CyWgYccIS');
-- superxyz
-- $2b$05$0gfscB95b8kH3fZ8eDRU6uS5FWT/TEuHB918N9gM8br9CyWgYccIS
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values ('NDK03','Lê Thọ','012312415','tho1@gmail.com','#','$2b$05$ETRsQcnO7VsnKCaR/SsO6eaBouseuOFeweRh90Wween9ObQ7WFNBW');
-- nhattho123
-- $2b$05$ETRsQcnO7VsnKCaR/SsO6eaBouseuOFeweRh90Wween9ObQ7WFNBW
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values ('NDK04','Huỳnh Tiến','0234235236','tien1@gmail.com','#','$2b$05$.QwWU/Ky2z.7OCmhoefaLOsWv1z3BD7XzgU26RegJFgNdcLB2dL9m');
-- manhtienhjk
-- $2b$05$.QwWU/Ky2z.7OCmhoefaLOsWv1z3BD7XzgU26RegJFgNdcLB2dL9m
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values ('NDK05','Lê an','099988777','an1@gmail.com','#','$2b$05$O0SlEO11yTIK0/kPd1aO/etIBmmTkUCfL5JCQ0vrarGyVZZkcZlFy');
-- sdjfdjsf
-- $2b$05$O0SlEO11yTIK0/kPd1aO/etIBmmTkUCfL5JCQ0vrarGyVZZkcZlFy
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values ('NDK06','Dương Tiêu','0333441411','tieu1@gmail.com','#','$2b$05$edAvkRX71Dbc8lsbHf4X1eDG7DNVYx0VmEYqPm.w3qnD0Cg7VBytK');
-- 3r423424fdfdsf
-- $2b$05$edAvkRX71Dbc8lsbHf4X1eDG7DNVYx0VmEYqPm.w3qnD0Cg7VBytK
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values ('NDK07','Trương Vô Kỵ','0113222453','ky1@gmail.com','#','$2b$05$ugem5dhb1GxsolnJhd1FxeOIQI71SZV09l9X/vQC6L3D0lHxPwQTO');
-----------
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK08','Pham Tra My','0921784356','dnha@qq.com','#','$2b$05$zdGSp.ioqTE6QH/w5AjcruIIphSW7NzsplyIVPYg6vZB2qW0IzgZy');
-- vuahaitac
-- $2b$05$zdGSp.ioqTE6QH/w5AjcruIIphSW7NzsplyIVPYg6vZB2qW0IzgZy
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK09','Vu Quoc Cuong','0939595552','dtbach@apple.com','#','$2b$05$Mb8JsDb/Bu9XJmkcC5Yqp.UIg6GmfjWiWWNDLPynyWrppakPEnyz2');
-- nuhoang123
-- $2b$05$Mb8JsDb/Bu9XJmkcC5Yqp.UIg6GmfjWiWWNDLPynyWrppakPEnyz2
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK10','Ly Van Doan','0792833610','lttrinh@vag.com.vn','#','$2b$05$Y0HnU0lGNSXV3nKH3b0hzuALMZuC/1ZOch2zCTn8JLnYQbE46i4Ku');
-- chienbinhmuadong
-- $2b$05$Y0HnU0lGNSXV3nKH3b0hzuALMZuC/1ZOch2zCTn8JLnYQbE46i4Ku
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK11','Pham Tra Quyen','0328968177','pdtrinh@microsoft.com','#','$2b$05$4i6vwNhL0oGsmqdoqYR2fuKfTCZ8JGLPtMZiCtXLWI.5XB4dMYQv6');
-- nhapmoncnpm
-- $2b$05$4i6vwNhL0oGsmqdoqYR2fuKfTCZ8JGLPtMZiCtXLWI.5XB4dMYQv6
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK12','Ly Thanh An','0852939400','dvduc@apple.com','#','$2b$05$TqSilF2u9mDI6UxUm83K0e/fPqXQWyvcAXF3M4rlYUfzva3FMDZly');
-- deadline
-- $2b$05$TqSilF2u9mDI6UxUm83K0e/fPqXQWyvcAXF3M4rlYUfzva3FMDZly
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK13','Do Dieu Mi','0393889083','dttrinh@gmail.com','#','$2b$05$T8ebaNLgEKafV00ghNAHdOcjSqwuPYM6l3wbgiHK46ALA6hZCzJSS');
-- stressqua
-- $2b$05$T8ebaNLgEKafV00ghNAHdOcjSqwuPYM6l3wbgiHK46ALA6hZCzJSS
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK14','Nguyen Thanh Chien','0387466077','pnvy@zonnet.nl','#','$2b$05$AqdJTz7VD6FOBGrEPNUtqe2/GkueNFVqpZmOIUcyGclK8an6TyjgS');
-- metmoilamroi
-- $2b$05$AqdJTz7VD6FOBGrEPNUtqe2/GkueNFVqpZmOIUcyGclK8an6TyjgS
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK15','Vo Phuong Vy','0944309170','ndha@zonnet.nl','#','$2b$05$i8iEGkyc.qL2.o3lofyDfeBZeEopCPK48m/PV7kfDya0DgT2enihG');
-- conan123
-- $2b$05$i8iEGkyc.qL2.o3lofyDfeBZeEopCPK48m/PV7kfDya0DgT2enihG
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK16','Tran Thao Quyen','0947816181','lndang@yahoo.com','#','$2b$05$TJmhfiWSsQTTl/Q.W8njnuOeA2hJzqXBUz6b8lBa6rUfNjeEu0Yeq');
-- luffabc
-- $2b$05$TJmhfiWSsQTTl/Q.W8njnuOeA2hJzqXBUz6b8lBa6rUfNjeEu0Yeq
insert into "NguoiDangKy"("MaNDK","TenNDK","SDT","Email","AnhNDK","MatKhauNDK")
values('NDK17','Phan Truc Mai','0853276918','htngan@zonnet.nl','#','$2b$05$I2N7UGVnzJtfDDwhz25pk.4LNaFE8mDUn00Ebnz1oBVtKH4FyhWFy');
-- naruto098
-- $2b$05$I2N7UGVnzJtfDDwhz25pk.4LNaFE8mDUn00Ebnz1oBVtKH4FyhWFy
-------------------------------
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB001','Đại học Khoa học Tự nhiên','Đỏ','NDK01','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB002','Đại học Bách Khoa','Đen','NDK02','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB003','Đại học Khoa học Xã hội và Nhân văn','Trắng','NDK03','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB004','Đại học Quốc té','Bạc','NDK04','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB005','Đại học Nông Lâm','Đỏ','NDK05','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB006','Đại học Kinh tế - Luật','Cam','NDK06','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB007','Đại học Kinh tế','Vàng','NDK07','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB008','Đại học Ngoại Thương','Xanh lá','NDK08','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB009','Đại học FPT','Xanh dương','NDK09','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB010','Đại học Văn Lang','Tím','NDK10','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB011','Đại học Tài Chính','Hồng','NDK11','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB012','Đại học Hồng Bàn','Bạc','NDK12','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB013','Đại học Hutech','Cam','NDK13','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB014','Đại học Mở','Xanh','NDK14','GD007');
insert into "DoiBong" ("MaDB", "TenDB", "MauAo", "MaNDK", "MaGD")
values ('DB015','Đại học Giao Thông','Tím','NDK15','GD007');
--------------------------