-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathHack.sql
205 lines (195 loc) · 20.8 KB
/
Hack.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
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
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
drop database hack;
create database hack character set 'utf8';
use hack;
GRANT FILE on *.* TO 'root'@'localhost';
-- drop table acc
create table acc(
idacc varchar(15) primary key,
pass varchar(100),
name varchar(30),
gender bool default true,
email varchar(50) unique,
avatar longblob,
admin bool default false,
darkmode bool default false
);
-- select * from acc
insert into acc values('B2111933','ee79976c9380d5e337fc1c095ece8c8f22f91f306ceeb161fa51fecede2c4ba1','Trương Đặng Trúc Lâm',true,'[email protected]',LOAD_FILE("F:/XAMPP/htdocs/Project-Web-CT214H-B2111933/img/blank.png"),false,false);
insert into acc values('B3333333','ee79976c9380d5e337fc1c095ece8c8f22f91f306ceeb161fa51fecede2c4ba1','LS',true,'[email protected]',LOAD_FILE("F:/XAMPP/htdocs/Project-Web-CT214H-B2111933/img/blank.png"),true,true);
insert into acc values('B4444444','ee79976c9380d5e337fc1c095ece8c8f22f91f306ceeb161fa51fecede2c4ba1','Yellow King',true,'[email protected]',LOAD_FILE("F:/XAMPP/htdocs/Project-Web-CT214H-B2111933/img/blank.png"),false,false);
insert into acc values('B2111999','ee79976c9380d5e337fc1c095ece8c8f22f91f306ceeb161fa51fecede2c4ba1','Hưng Gay',false,'[email protected]',LOAD_FILE("F:/XAMPP/htdocs/Project-Web-CT214H-B2111933/img/blank.png"),false,false);
-- drop table ctf
CREATE TABLE ctf(
idctf INT PRIMARY KEY auto_increment,
title VARCHAR(50) UNIQUE NOT NULL,
type VARCHAR(30) NOT NULL,
des TEXT,
hint TEXT,
file VARCHAR(200), -- Stores the filename of the downloadable file
keyfile varchar(30),
time varchar(30),
author varchar(15),
constraint fk_author foreign key (author) references acc(idacc)
);
-- select * from ctf
insert into ctf values(1,'mongki','Reverse Engineering','This is just for testing function download in Web.','Open the eye','monkey.jpg','thekey',sysdate(),'B3333333');
insert into ctf values(2,'dog','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(3,'cow','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(4,'sheep','Web Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(5,'monkey','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(6,'mongki1','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(7,'dog1','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(8,'cow1','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(9,'sheep1','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(10,'monkey1','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(11,'mongki2','Web Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(12,'dog2','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(13,'cow2','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(14,'sheep2','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(15,'monkey2','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(16,'mongki3','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(17,'dog3','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(18,'cow3','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(19,'sheep3','Web Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(20,'monkey3','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(21,'mongki4','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(22,'dog4','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(23,'cow4','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(24,'sheep4','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(25,'monkey4','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(26,'mongki5','Web Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(27,'dog5','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(28,'cow5','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(29,'sheep5','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(30,'monkey5','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(31,'mongki6','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(32,'dog6','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(33,'cow6','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(34,'sheep6','Web Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(35,'monkey6','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(36,'mongki7','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(37,'dog7','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(38,'cow7','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(39,'sheep7','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(40,'monkey7','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(41,'mongki8','Web Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(42,'dog8','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(43,'cow8','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(44,'sheep8','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(45,'monkey8','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(46,'mongki9','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(47,'dog9','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(48,'cow9','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(49,'sheep9','Web Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(50,'monkey9','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(51,'mongki10','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(52,'dog10','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(53,'cow10','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(54,'sheep10','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(55,'monkey10','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(56,'mongki11','Web Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(57,'dog11','Binary Exploitation','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(58,'cow11','Cryptography','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(59,'sheep11','Forensics','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(60,'monkey11','Reverse Engineering','aaaaaa','bbbbbb','cccc','thekey',sysdate(),'B3333333');
insert into ctf values(61,'mongki22','Reverse Engineering','This is just for testing function download in Web.','Open the eye','monkey.jpg','thekey',sysdate(),'B3333333');
-- drop table ctfAttempt
create table ctfAttempt(
idacc varchar(15),
idctf int,
time varchar(30),
constraint fk_attempt_acc foreign key (idacc) references acc(idacc),
constraint fk_attempt_ctf foreign key (idctf) references ctf(idctf)
);
-- select * from ctfAttempt;
insert into ctfAttempt values ('B2111933',1,sysdate());
create table cmt(
idcmt int primary key auto_increment,
content text(500),
time varchar(30),
idacc varchar(15),
constraint fk_idacc foreign key (idacc) references acc(idacc)
);
-- select * from cmt
insert into cmt(content,time,idacc) values('mongki',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('chú bé đần',sysdate(),'B4444444');
insert into cmt(content,time,idacc) values('monkey',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('dog',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('cow',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('sfdfgdvcbhjxfvccvxzhvxbjhgasbdhajnvb xccb zxnc cxbbxcbncxkcnxjkxnccj á á á vjdkvhkkuchvukjhi',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('mongki',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('chú bé đần',sysdate(),'B4444444');
insert into cmt(content,time,idacc) values('monkey',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('dog',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('cow',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('mongki',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('chú bé đần',sysdate(),'B4444444');
insert into cmt(content,time,idacc) values('monkey',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('dog',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('cow',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('sfdfgdvcbhjxfvccvxzhvxbjhgasbdhajnvb xccb zxnc cxbbxcbncxkcnxjkxnccj á á á vjdkvhkkuchvukjhi',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('mongki',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('chú bé đần',sysdate(),'B4444444');
insert into cmt(content,time,idacc) values('monkey',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('dog',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('afcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('ergyrhgrfhsvdgvsvzafhtjhjtjytytdytrysvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('afytyuhthbhgfdxfhcasfcfvdgvsvzafcasfcfvdgddafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('dog',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('cow',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('sfdfgdvcbhjxfvccvxzhvxbjhgasbdhajnvb xccb zxnc cxbbxcbncxkcnxjkxnccj á á á vjdkvhkkuchvukjhi',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('mongki',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('chú bé đần',sysdate(),'B4444444');
insert into cmt(content,time,idacc) values('monkey',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('dog',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('afcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('ergyrhgrfhsvdgvsvzafhtjhjtjytytdytrysvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('afytyuhthbhgfdxfhcasfcfvdgvsvzafcasfcfvdgddafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('dog',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('cow',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('sfdfgdvcbhjxfvccvxzhvxbjhgasbdhajnvb xccb zxnc cxbbxcbncxkcnxjkxnccj á á á vjdkvhkkuchvukjhi',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('mongki',sysdate(),'B2111933');
insert into cmt(content,time,idacc) values('afcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('ergyrhgrfhsvdgvsvzafhtjhjtjytytdytrysvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('afytyuhthbhgfdxfhcasfcfvdgvsvzafcasfcfvdgddafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvdgvsvzafcasfcfvd',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('dog',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('cow',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('sfdfgdvcbhjxfvccvxzhvxbjhgasbdhajnvb xccb zxnc cxbbxcbncxkcnxjkxnccj á á á vjdkvhkkuchvukjhi',sysdate(),'B3333333');
insert into cmt(content,time,idacc) values('mongki',sysdate(),'B2111933');
-- drop table lectures;
create table lectures (
id_lectures int primary key auto_increment,
title VARCHAR(50) NOT NULL,
des text(500),
time varchar(30),
idacc varchar(15) ,
constraint fk_author_lec foreign key (idacc) references acc(idacc)
);
insert into lectures (id_lectures, title, des, time, idacc) values (1, 'Bla Bla Bla', 'Lorem, ipsum dolor sit amet consectetur adipisicing elit. Labore ullam, minus mollitia quidem quos quo nam commodi ipsum optio et eos ad est delectus expedita repellat quisquam vel? Beatae, provident! Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet, repellendus veritatis dolorum, enim esse excepturi quibusdam illo corporis deserunt cumque officiis molestias exercitationem, quis pariatur unde velit. Officiis, saepe ducimus. Lorem ipsum dolor sit amet consectetur adipisicing elit. Consequatur rerum pariatur in excepturi ipsam voluptatibus molestias officiis saepe natus, nihil recusandae autem porro ullam. Et error quasi perspiciatis enim tempora.',sysdate(), 'B3333333');
insert into lectures (id_lectures, title, des, time, idacc) values (2, 'Ha Ha Ha', 'Lorem, ipsum dolor sit amet consectetur adipisicing elit. Labore ullam, minus mollitia quidem quos quo nam commodi ipsum optio et eos ad est delectus expedita repellat quisquam vel? Beatae, provident! Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet, repellendus veritatis dolorum, enim esse excepturi quibusdam illo corporis deserunt cumque officiis molestias exercitationem, quis pariatur unde velit. Officiis, saepe ducimus. Lorem ipsum dolor sit amet consectetur adipisicing elit. Consequatur rerum pariatur in excepturi ipsam voluptatibus molestias officiis saepe natus, nihil recusandae autem porro ullam. Et error quasi perspiciatis enim tempora.',sysdate(),'B3333333');
insert into lectures (id_lectures, title, des, time, idacc) values (3, 'He He He', 'Lorem, ipsum dolor sit amet consectetur adipisicing elit. Labore ullam, minus mollitia quidem quos quo nam commodi ipsum optio et eos ad est delectus expedita repellat quisquam vel? Beatae, provident! Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet, repellendus veritatis dolorum, enim esse excepturi quibusdam illo corporis deserunt cumque officiis molestias exercitationem, quis pariatur unde velit. Officiis, saepe ducimus. Lorem ipsum dolor sit amet consectetur adipisicing elit. Consequatur rerum pariatur in excepturi ipsam voluptatibus molestias officiis saepe natus, nihil recusandae autem porro ullam. Et error quasi perspiciatis enim tempora.',sysdate(), 'B3333333');
insert into lectures (id_lectures, title, des, time, idacc) values (4, 'Hi Hi Hi', 'Lorem, ipsum dolor sit amet consectetur adipisicing elit. Labore ullam, minus mollitia quidem quos quo nam commodi ipsum optio et eos ad est delectus expedita repellat quisquam vel? Beatae, provident! Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet, repellendus veritatis dolorum, enim esse excepturi quibusdam illo corporis deserunt cumque officiis molestias exercitationem, quis pariatur unde velit. Officiis, saepe ducimus. Lorem ipsum dolor sit amet consectetur adipisicing elit. Consequatur rerum pariatur in excepturi ipsam voluptatibus molestias officiis saepe natus, nihil recusandae autem porro ullam. Et error quasi perspiciatis enim tempora.',sysdate(), 'B3333333');
insert into lectures (id_lectures, title, des, time, idacc) values (5, 'One Piece', 'Lorem, ipsum dolor sit amet consectetur adipisicing elit. Labore ullam, minus mollitia quidem quos quo nam commodi ipsum optio et eos ad est delectus expedita repellat quisquam vel? Beatae, provident! Lorem ipsum dolor sit amet consectetur adipisicing elit. Eveniet, repellendus veritatis dolorum, enim esse excepturi quibusdam illo corporis deserunt cumque officiis molestias exercitationem, quis pariatur unde velit. Officiis, saepe ducimus. Lorem ipsum dolor sit amet consectetur adipisicing elit. Consequatur rerum pariatur in excepturi ipsam voluptatibus molestias officiis saepe natus, nihil recusandae autem porro ullam. Et error quasi perspiciatis enim tempora.',sysdate(), 'B3333333');
-- drop table newsfeed;
create table newsfeed (
idnews int primary key auto_increment,
textNews varchar(300) not null,
timeSend varchar(30),
id_lectures int not null,
idacc varchar(15),
constraint fk_nf_lectures foreign key (id_lectures) references lectures(id_lectures),
constraint fk_nf_acc foreign key (idacc) references acc(idacc)
);
select * from newsfeed;
delete from newsfeed where idnews = 3;
-- drop table chats;
create table chats (
idchats int primary key auto_increment,
idacc varchar(15),
textChats varchar(300) not null,
timeSend varchar(30),
id_lectures_chats int not null,
constraint fk_lectures_chats foreign key (id_lectures_chats) references lectures(id_lectures),
constraint fk_lectures_acc foreign key (idacc) references acc(idacc)
);
select * from chats;