-
Notifications
You must be signed in to change notification settings - Fork 0
/
create.sql
446 lines (438 loc) · 26.4 KB
/
create.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
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
create database DB2024Team01;
use DB2024Team01;
-- User Table
create table User(
handle VARCHAR(50) NOT NULL PRIMARY KEY,
userlink VARCHAR(50) NOT NULL ,
solvednum INT NOT NULL ,
tier ENUM('0', '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') NOT NULL,
rank_ingroup INT NOT NULL
);
-- uGroup Table (Group은 예약어라서 불편)
CREATE TABLE uGroup (
groupName VARCHAR(40) NOT NULL PRIMARY KEY,
solvedNum INT NOT NULL ,
ranking INT NOT NULL
);
-- Problems
CREATE TABLE Problems (
pid VARCHAR(40) NOT NULL PRIMARY KEY,
pTitle VARCHAR(100),
tier ENUM('0', '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') NOT NULL,
tags JSON NOT NULL ,
solvednum INT NOT NULL ,
link VARCHAR(200) NOT NULL
);
-- TodayPS
CREATE TABLE TodayPS (
todayid INT NOT NULL PRIMARY KEY,
pid VARCHAR(40) NOT NULL,
picked BOOLEAN,
handle VARCHAR(50),
FOREIGN KEY (pid) REFERENCES Problems(pid),
FOREIGN KEY (handle) REFERENCES User(handle)
);
-- PStogether
CREATE TABLE PStogether (
togetherid VARCHAR(40) NOT NULL PRIMARY KEY,
pid VARCHAR(40) NOT NULL,
link VARCHAR(100) NOT NULL ,
handle VARCHAR(50) ,
FOREIGN KEY (pid) REFERENCES Problems(pid),
FOREIGN KEY (handle) REFERENCES User(handle)
);
-- 스키마 확인
select * from User order by rank_ingroup;
select * from uGroup;
select * from Problems;
select * from TodayPS;
select * from PStogether;
-- INSERT
INSERT INTO User (handle, userlink, solvednum, tier, rank_ingroup) VALUES
('babeeboo2000', 'https://solved.ac/profile/babeeboo2000', 1000, '19', 1),
('kwakhj0205', 'https://solved.ac/profile/kwakhj0205', 753, '18', 2),
('kha0318', 'https://solved.ac/profile/kha0318', 602, '17', 3),
('fungod12', 'https://solved.ac/profile/fungod12', 476, '17', 4),
('pearl55', 'https://solved.ac/profile/pearl55', 796, '17', 5),
('amy03', 'https://solved.ac/profile/amy03', 334, '17', 6),
('iw0406', 'https://solved.ac/profile/iw0406', 773, '17', 7),
('meanjung', 'https://solved.ac/profile/meanjung', 621, '17', 8),
('mummyee', 'https://solved.ac/profile/mummyee', 535, '17', 9),
('2000flora', 'https://solved.ac/profile/2000flora', 510, '17', 10),
('dk03006', 'https://solved.ac/profile/dk03006', 540, '16', 11),
('jessica9685', 'https://solved.ac/profile/jessica9685', 299, '16', 12),
('ye1111k', 'https://solved.ac/profile/ye1111k', 524, '16', 13),
('yrh0711', 'https://solved.ac/profile/yrh0711', 338, '16', 14),
('gaon0628', 'https://solved.ac/profile/gaon0628', 556, '16', 15),
('healing5746', 'https://solved.ac/profile/healing5746', 568, '16', 16),
('bje5774', 'https://solved.ac/profile/bje5774', 335, '16', 17),
('celina324', 'https://solved.ac/profile/celina324', 1046, '16', 18),
('kikititi0510', 'https://solved.ac/profile/kikititi0510', 389, '16', 19),
('cse', 'https://solved.ac/profile/cse', 360, '16', 20),
('shjj09', 'https://solved.ac/profile/shjj09', 415, '16', 21),
('rgkim1110', 'https://solved.ac/profile/rgkim1110', 322, '15', 22),
('xodms0309', 'https://solved.ac/profile/xodms0309', 435, '15', 23),
('soultreeforgood', 'https://solved.ac/profile/soultreeforgood', 470, '15', 24),
('zeomzzz', 'https://solved.ac/profile/zeomzzz', 461, '15', 25),
('hhj227', 'https://solved.ac/profile/hhj227', 325, '15', 26),
('lcheun', 'https://solved.ac/profile/lcheun', 347, '15', 27),
('tjdls513', 'https://solved.ac/profile/tjdls513', 306, '15', 28),
('fos0805', 'https://solved.ac/profile/fos0805', 376, '15', 29),
('worung', 'https://solved.ac/profile/worung', 437, '15', 30),
('mkkw0228', 'https://solved.ac/profile/mkkw0228', 456, '15', 31),
('challenger214', 'https://solved.ac/profile/challenger214', 194, '15', 32),
('starlover27', 'https://solved.ac/profile/starlover27', 266, '15', 33),
('hoit1302', 'https://solved.ac/profile/hoit1302', 424, '15', 34),
('sophia5460', 'https://solved.ac/profile/sophia5460', 293, '15', 35),
('0909oje', 'https://solved.ac/profile/0909oje', 434, '15', 36),
('lop080', 'https://solved.ac/profile/lop080', 260, '15', 37),
('ysgg5045', 'https://solved.ac/profile/ysgg5045', 326, '15', 38),
('bae12', 'https://solved.ac/profile/bae12', 218, '15', 39),
('haun321', 'https://solved.ac/profile/haun321', 322, '15', 40),
('aseoyeon', 'https://solved.ac/profile/aseoyeon', 244, '15', 41),
('mminjg', 'https://solved.ac/profile/mminjg', 292, '15', 42),
('ssonge413', 'https://solved.ac/profile/ssonge413', 246, '15', 43),
('yunyun3599', 'https://solved.ac/profile/yunyun3599', 233, '15', 44),
('jikmomo', 'https://solved.ac/profile/jikmomo', 306, '15', 45),
('pawken', 'https://solved.ac/profile/pawken', 449, '15', 46),
('yunji118', 'https://solved.ac/profile/yunji118', 300, '15', 47),
('amunt20', 'https://solved.ac/profile/amunt20', 349, '15', 48),
('emmajane', 'https://solved.ac/profile/emmajane', 603, '15', 49),
('yellowrectangle', 'https://solved.ac/profile/yellowrectangle', 207, '15', 50),
('emily2307', 'https://solved.ac/profile/emily2307', 342, '15', 51),
('itstt', 'https://solved.ac/profile/itstt', 367, '14', 52),
('cyan22g', 'https://solved.ac/profile/cyan22g', 267, '14', 53),
('pooh0407', 'https://solved.ac/profile/pooh0407', 167, '14', 54),
('eunga', 'https://solved.ac/profile/eunga', 205, '14', 55),
('haeun28', 'https://solved.ac/profile/haeun28', 257, '14', 56),
('kados22', 'https://solved.ac/profile/kados22', 303, '14', 57),
('cdjin6911', 'https://solved.ac/profile/cdjin6911', 164, '14', 58),
('jungh150', 'https://solved.ac/profile/jungh150', 265, '14', 59),
('sunday0516', 'https://solved.ac/profile/sunday0516', 298, '14', 60),
('silver4550', 'https://solved.ac/profile/silver4550', 265, '14', 61),
('2835223', 'https://solved.ac/profile/2835223', 224, '14', 62),
('kyrin1103', 'https://solved.ac/profile/kyrin1103', 270, '14', 63),
('pha1172', 'https://solved.ac/profile/pha1172', 283, '14', 64),
('ceyegirl', 'https://solved.ac/profile/ceyegirl', 164, '14', 65),
('dbs11', 'https://solved.ac/profile/dbs11', 202, '14', 66),
('chws', 'https://solved.ac/profile/chws', 220, '14', 67),
('toulim0620', 'https://solved.ac/profile/toulim0620', 278, '14', 68),
('sua005', 'https://solved.ac/profile/sua005', 224, '14', 69),
('pip2357', 'https://solved.ac/profile/pip2357', 246, '14', 70),
('easy8ch', 'https://solved.ac/profile/easy8ch', 222, '14', 71),
('maggie0810', 'https://solved.ac/profile/maggie0810', 257, '14', 72),
('yurimjang', 'https://solved.ac/profile/yurimjang', 146, '14', 73),
('student_ji', 'https://solved.ac/profile/student_ji', 148, '14', 74),
('innysong', 'https://solved.ac/profile/innysong', 273, '14', 75),
('koh216', 'https://solved.ac/profile/koh216', 290, '14', 76),
('a0903', 'https://solved.ac/profile/a0903', 134, '14', 77),
('junmin0118', 'https://solved.ac/profile/junmin0118', 261, '14', 78),
('zoey04', 'https://solved.ac/profile/zoey04', 169, '14', 79),
('seoyun1011', 'https://solved.ac/profile/seoyun1011', 180, '14', 80),
('chaerinikim', 'https://solved.ac/profile/chaerinikim', 200, '14', 81),
('woomin1002', 'https://solved.ac/profile/woomin1002', 184, '14', 82),
('yeobae', 'https://solved.ac/profile/yeobae', 232, '14', 83),
('holim0', 'https://solved.ac/profile/holim0', 167, '14', 84),
('skylife', 'https://solved.ac/profile/skylife', 196, '14', 85),
('jin0410', 'https://solved.ac/profile/jin0410', 181, '14', 86),
('ddu', 'https://solved.ac/profile/ddu', 160, '14', 87),
('matthew08', 'https://solved.ac/profile/matthew08', 263, '14', 88),
('sophia1007', 'https://solved.ac/profile/sophia1007', 233, '14', 89),
('elizachoi27', 'https://solved.ac/profile/elizachoi27', 164, '14', 90),
('robinho', 'https://solved.ac/profile/robinho', 187, '14', 91),
('jihoon808', 'https://solved.ac/profile/jihoon808', 176, '14', 92),
('scofield2', 'https://solved.ac/profile/scofield2', 195, '14', 93),
('dudu0403', 'https://solved.ac/profile/dudu0403', 158, '14', 94),
('sean0915', 'https://solved.ac/profile/sean0915', 181, '14', 95),
('grace', 'https://solved.ac/profile/grace', 222, '14', 96),
('juyeong0715', 'https://solved.ac/profile/juyeong0715', 171, '14', 97),
('ffom7717', 'https://solved.ac/profile/ffom7717', 161, '14', 98),
('sae_l', 'https://solved.ac/profile/sae_l', 181, '14', 99),
('swelbbang', 'https://solved.ac/profile/swelbbang', 165, '14', 100),
('sycy30', 'https://solved.ac/profile/sycy30', 969, '13', 101),
('hialgo', 'https://solved.ac/profile/hialgo', 202, '13', 102),
('sunsky', 'https://solved.ac/profile/sunsky', 262, '13', 103),
('surisu', 'https://solved.ac/profile/surisu', 151, '13', 104),
('song_jh', 'https://solved.ac/profile/song_jh', 208, '13', 105),
('js8662', 'https://solved.ac/profile/js8662', 269, '13', 106),
('icecream7593', 'https://solved.ac/profile/icecream7593', 194, '13', 107),
('dldbwjd24', 'https://solved.ac/profile/dldbwjd24', 165, '13', 108),
('00blowup', 'https://solved.ac/profile/00blowup', 361, '13', 109),
('devjin0122', 'https://solved.ac/profile/devjin0122', 112, '13', 110),
('esther005', 'https://solved.ac/profile/esther005', 212, '13', 111),
('katevalen', 'https://solved.ac/profile/katevalen', 139, '13', 112),
('cje1903', 'https://solved.ac/profile/cje1903', 146, '12', 113),
('cofla159', 'https://solved.ac/profile/cofla159', 138, '12', 114),
('nitronium', 'https://solved.ac/profile/nitronium', 175, '12', 115),
('kateking001130', 'https://solved.ac/profile/kateking001130', 218, '12', 116),
('hjs', 'https://solved.ac/profile/hjs', 134, '12', 117),
('lisa_tera', 'https://solved.ac/profile/lisa_tera', 133, '12', 118),
('junghk0115', 'https://solved.ac/profile/junghk0115', 152, '12', 119),
('xwcjw13', 'https://solved.ac/profile/xwcjw13', 280, '12', 120),
('chorome', 'https://solved.ac/profile/chorome', 103, '12', 121),
('rladlqkr0113', 'https://solved.ac/profile/rladlqkr0113', 94, '12', 122),
('akimcse', 'https://solved.ac/profile/akimcse', 159, '12', 123),
('jiddoly', 'https://solved.ac/profile/jiddoly', 103, '12', 124),
('sha0809', 'https://solved.ac/profile/sha0809', 148, '12', 125),
('devheyrin', 'https://solved.ac/profile/devheyrin', 338, '12', 126),
('away', 'https://solved.ac/profile/away', 152, '12', 127),
('cgc8016', 'https://solved.ac/profile/cgc8016', 103, '12', 128),
('corinthionia', 'https://solved.ac/profile/corinthionia', 184, '12', 129),
('grace1195', 'https://solved.ac/profile/grace1195', 102, '12', 130),
('musk82155', 'https://solved.ac/profile/musk82155', 112, '12', 131),
('hello147', 'https://solved.ac/profile/hello147', 203, '12', 132),
('qwepoiq', 'https://solved.ac/profile/qwepoiq', 209, '12', 133),
('givingj9902', 'https://solved.ac/profile/givingj9902', 172, '12', 134),
('beth52', 'https://solved.ac/profile/beth52', 153, '11', 135),
('ab01', 'https://solved.ac/profile/ab01', 114, '11', 136),
('mingcco2', 'https://solved.ac/profile/mingcco2', 168, '11', 137),
('splendoes', 'https://solved.ac/profile/splendoes', 140, '11', 138),
('yekim0808', 'https://solved.ac/profile/yekim0808', 96, '11', 139),
('yhj9855', 'https://solved.ac/profile/yhj9855', 146, '11', 140),
('kkjjyy', 'https://solved.ac/profile/kkjjyy', 113, '11', 141),
('pcy0711', 'https://solved.ac/profile/pcy0711', 219, '11', 142),
('tonge', 'https://solved.ac/profile/tonge', 165, '11', 143),
('yubin9812', 'https://solved.ac/profile/yubin9812', 175, '11', 144),
('your_zinc', 'https://solved.ac/profile/your_zinc', 132, '11', 145),
('zolio', 'https://solved.ac/profile/zolio', 128, '11', 146),
('sua917', 'https://solved.ac/profile/sua917', 135, '11', 147),
('chodakk', 'https://solved.ac/profile/chodakk', 152, '11', 148),
('fhflwhwl5', 'https://solved.ac/profile/fhflwhwl5', 115, '11', 149),
('y_e_99', 'https://solved.ac/profile/y_e_99', 175, '11', 150),
('tooma22', 'https://solved.ac/profile/tooma22', 131, '11', 151),
('his0si', 'https://solved.ac/profile/his0si', 135, '11', 152),
('380380380', 'https://solved.ac/profile/380380380', 114, '11', 153),
('jane524', 'https://solved.ac/profile/jane524', 142, '11', 154),
('dbsgkdudchlr', 'https://solved.ac/profile/dbsgkdudchlr', 128, '11', 155),
('dlagkgud', 'https://solved.ac/profile/dlagkgud', 153, '11', 156),
('stargirl03', 'https://solved.ac/profile/stargirl03', 133, '11', 157),
('myalgo', 'https://solved.ac/profile/myalgo', 148, '11', 158),
('sujin0970', 'https://solved.ac/profile/sujin0970', 108, '11', 159),
('bonita99', 'https://solved.ac/profile/bonita99', 98, '11', 160),
('xrabcde', 'https://solved.ac/profile/xrabcde', 113, '11', 161),
('sheecho0804', 'https://solved.ac/profile/sheecho0804', 87, '11', 162),
('dongdong7251', 'https://solved.ac/profile/dongdong7251', 134, '11', 163),
('beh1016', 'https://solved.ac/profile/beh1016', 139, '10', 164),
('eileen0228', 'https://solved.ac/profile/eileen0228', 89, '10', 165),
('isc10120', 'https://solved.ac/profile/isc10120', 88, '10', 166),
('yourain0416', 'https://solved.ac/profile/yourain0416', 140, '10', 167),
('yeppi6059', 'https://solved.ac/profile/yeppi6059', 126, '10', 168),
('backalex', 'https://solved.ac/profile/backalex', 78, '10', 169),
('gardenia', 'https://solved.ac/profile/gardenia', 119, '10', 170),
('devzzzin', 'https://solved.ac/profile/devzzzin', 79, '10', 171),
('hope1053', 'https://solved.ac/profile/hope1053', 80, '10', 172),
('airline333', 'https://solved.ac/profile/airline333', 190, '10', 173),
('rzlzlq', 'https://solved.ac/profile/rzlzlq', 79, '10', 174),
('elf625', 'https://solved.ac/profile/elf625', 160, '10', 175),
('estherliu919', 'https://solved.ac/profile/estherliu919', 93, '10', 176),
('cha2y0ung', 'https://solved.ac/profile/cha2y0ung', 127, '10', 177),
('gongkeo', 'https://solved.ac/profile/gongkeo', 131, '10', 178),
('khjyj12', 'https://solved.ac/profile/khjyj12', 62, '10', 179),
('sooooscode', 'https://solved.ac/profile/sooooscode', 96, '10', 180),
('02ruby', 'https://solved.ac/profile/02ruby', 84, '10', 181),
('hse801', 'https://solved.ac/profile/hse801', 72, '10', 182),
('tjsgh1210', 'https://solved.ac/profile/tjsgh1210', 73, '10', 183),
('howdy1227', 'https://solved.ac/profile/howdy1227', 121, '10', 184),
('chel0412', 'https://solved.ac/profile/chel0412', 104, '10', 185),
('clairewoo', 'https://solved.ac/profile/clairewoo', 83, '10', 186),
('qwe1357902', 'https://solved.ac/profile/qwe1357902', 96, '10', 187),
('so_hyeon', 'https://solved.ac/profile/so_hyeon', 108, '9', 188),
('awslik', 'https://solved.ac/profile/awslik', 85, '9', 189),
('idrealist', 'https://solved.ac/profile/idrealist', 164, '9', 190),
('atz999', 'https://solved.ac/profile/atz999', 77, '9', 191),
('conjs1', 'https://solved.ac/profile/conjs1', 109, '9', 192),
('dyb', 'https://solved.ac/profile/dyb', 126, '9', 193),
('zion0117', 'https://solved.ac/profile/zion0117', 111, '9', 194),
('sch0991', 'https://solved.ac/profile/sch0991', 90, '9', 195),
('fn0809', 'https://solved.ac/profile/fn0809', 119, '9', 196),
('djagksmf0817', 'https://solved.ac/profile/djagksmf0817', 69, '9', 197),
('dhh1021', 'https://solved.ac/profile/dhh1021', 95, '9', 198),
('donyy', 'https://solved.ac/profile/donyy', 134, '9', 199),
('altis', 'https://solved.ac/profile/altis', 103, '9', 200),
('jiyoon1156', 'https://solved.ac/profile/jiyoon1156', 82, '9', 201),
('chacha09', 'https://solved.ac/profile/chacha09', 81, '9', 202),
('rnem019', 'https://solved.ac/profile/rnem019', 190, '9', 203),
('cny1357', 'https://solved.ac/profile/cny1357', 124, '9', 204),
('ioolvv', 'https://solved.ac/profile/ioolvv', 100, '9', 205),
('zzunvely', 'https://solved.ac/profile/zzunvely', 63, '9', 206),
('allison1998', 'https://solved.ac/profile/allison1998', 68, '9', 207),
('gpwl1374', 'https://solved.ac/profile/gpwl1374', 108, '9', 208),
('soomin200', 'https://solved.ac/profile/soomin200', 55, '9', 209),
('celeste7297', 'https://solved.ac/profile/celeste7297', 56, '9', 210),
('arovo', 'https://solved.ac/profile/arovo', 95, '9', 211),
('astralfinance', 'https://solved.ac/profile/astralfinance', 69, '9', 212),
('okcathy', 'https://solved.ac/profile/okcathy', 65, '9', 213),
('mary000605', 'https://solved.ac/profile/mary000605', 75, '9', 214),
('himtows', 'https://solved.ac/profile/himtows', 93, '8', 215),
('129lovely', 'https://solved.ac/profile/129lovely', 59, '8', 216),
('songing01', 'https://solved.ac/profile/songing01', 64, '8', 217),
('bottle1886', 'https://solved.ac/profile/bottle1886', 85, '8', 218),
('10880mp', 'https://solved.ac/profile/10880mp', 59, '8', 219),
('youdid', 'https://solved.ac/profile/youdid', 152, '8', 220),
('rin4321', 'https://solved.ac/profile/rin4321', 58, '8', 221),
('jasook_learning', 'https://solved.ac/profile/jasook_learning', 122, '8', 222),
('jungin914', 'https://solved.ac/profile/jungin914', 85, '8', 223),
('melonia', 'https://solved.ac/profile/melonia', 107, '8', 224),
('yujin2e', 'https://solved.ac/profile/yujin2e', 94, '8', 225),
('songgang4579', 'https://solved.ac/profile/songgang4579', 108, '8', 226),
('jeekyung00', 'https://solved.ac/profile/jeekyung00', 109, '8', 227),
('leehahj', 'https://solved.ac/profile/leehahj', 88, '8', 228),
('alswn299842', 'https://solved.ac/profile/alswn299842', 83, '8', 229),
('jo4921', 'https://solved.ac/profile/jo4921', 39, '8', 230),
('wlgus253254', 'https://solved.ac/profile/wlgus253254', 82, '8', 231),
('anu978', 'https://solved.ac/profile/anu978', 40, '8', 232),
('yumme', 'https://solved.ac/profile/yumme', 48, '7', 233),
('yerim514', 'https://solved.ac/profile/yerim514', 104, '7', 234),
('ddoni', 'https://solved.ac/profile/ddoni', 98, '7', 235),
('myjinsuk5', 'https://solved.ac/profile/myjinsuk5', 54, '7', 236),
('kshjessica', 'https://solved.ac/profile/kshjessica', 84, '7', 237),
('shl_4869', 'https://solved.ac/profile/shl_4869', 38, '7', 238),
('inbrain144', 'https://solved.ac/profile/inbrain144', 99, '7', 239),
('comgongdaeng', 'https://solved.ac/profile/comgongdaeng', 43, '7', 240),
('gia', 'https://solved.ac/profile/gia', 85, '7', 241),
('karmanx', 'https://solved.ac/profile/karmanx', 75, '7', 242),
('chlqls02', 'https://solved.ac/profile/chlqls02', 58, '7', 243),
('hello_im_yj', 'https://solved.ac/profile/hello_im_yj', 35, '7', 244),
('55wldms', 'https://solved.ac/profile/55wldms', 34, '7', 245),
('suzie4831', 'https://solved.ac/profile/suzie4831', 75, '7', 246),
('1210ji', 'https://solved.ac/profile/1210ji', 93, '7', 247),
('sml09181', 'https://solved.ac/profile/sml09181', 80, '7', 248),
('minji1289', 'https://solved.ac/profile/minji1289', 48, '7', 249),
('hananim3324', 'https://solved.ac/profile/hananim3324', 55, '7', 250),
('una0409', 'https://solved.ac/profile/una0409', 80, '7', 251),
('hkcode23', 'https://solved.ac/profile/hkcode23', 70, '7', 252),
('gee1suu', 'https://solved.ac/profile/gee1suu', 78, '7', 253),
('rachelses', 'https://solved.ac/profile/rachelses', 46, '7', 254),
('rinarina0429', 'https://solved.ac/profile/rinarina0429', 93, '7', 255),
('syoub', 'https://solved.ac/profile/syoub', 46, '7', 256),
('dazzlynn', 'https://solved.ac/profile/dazzlynn', 69, '7', 257),
('wowalswjd', 'https://solved.ac/profile/wowalswjd', 46, '7', 258),
('dkscodus12', 'https://solved.ac/profile/dkscodus12', 55, '7', 259),
('kimjiwon', 'https://solved.ac/profile/kimjiwon', 32, '7', 260),
('eb0313', 'https://solved.ac/profile/eb0313', 74, '7', 261),
('ella0106', 'https://solved.ac/profile/ella0106', 84, '6', 262),
('eugenie', 'https://solved.ac/profile/eugenie', 30, '6', 263),
('lastdance39', 'https://solved.ac/profile/lastdance39', 125, '6', 264),
('kyungin0528', 'https://solved.ac/profile/kyungin0528', 64, '6', 265),
('shrimptaco', 'https://solved.ac/profile/shrimptaco', 73, '6', 266),
('yudility', 'https://solved.ac/profile/yudility', 49, '6', 267),
('ghdwlgud330', 'https://solved.ac/profile/ghdwlgud330', 72, '6', 268),
('kimhyunsu11', 'https://solved.ac/profile/kimhyunsu11', 62, '6', 269),
('gabin01', 'https://solved.ac/profile/gabin01', 69, '6', 270),
('mor2222', 'https://solved.ac/profile/mor2222', 40, '6', 271),
('semin131', 'https://solved.ac/profile/semin131', 29, '6', 272),
('binable43', 'https://solved.ac/profile/binable43', 59, '6', 273),
('z00m_1n', 'https://solved.ac/profile/z00m_1n', 68, '6', 274),
('monimoni12', 'https://solved.ac/profile/monimoni12', 49, '6', 275),
('jhn0125', 'https://solved.ac/profile/jhn0125', 44, '6', 276),
('vikira', 'https://solved.ac/profile/vikira', 68, '6', 277),
('jjangdaye', 'https://solved.ac/profile/jjangdaye', 31, '6', 278),
('yzx', 'https://solved.ac/profile/yzx', 51, '6', 279),
('chrpark11', 'https://solved.ac/profile/chrpark11', 28, '6', 280),
('eeeg1004', 'https://solved.ac/profile/eeeg1004', 25, '6', 281),
('new7932', 'https://solved.ac/profile/new7932', 57, '6', 282),
('rowenna03', 'https://solved.ac/profile/rowenna03', 55, '6', 283),
('hch011007', 'https://solved.ac/profile/hch011007', 57, '6', 284),
('lilybell77', 'https://solved.ac/profile/lilybell77', 32, '6', 285),
('helloworld3312', 'https://solved.ac/profile/helloworld3312', 29, '5', 286),
('jeemin0506', 'https://solved.ac/profile/jeemin0506', 57, '5', 287),
('cybergangster', 'https://solved.ac/profile/cybergangster', 52, '5', 288),
('rwhui', 'https://solved.ac/profile/rwhui', 31, '5', 289),
('hseojung', 'https://solved.ac/profile/hseojung', 52, '5', 290),
('sch8769', 'https://solved.ac/profile/sch8769', 51, '5', 291),
('uiop56', 'https://solved.ac/profile/uiop56', 38, '5', 292),
('minmiin', 'https://solved.ac/profile/minmiin', 50, '5', 293),
('vein000', 'https://solved.ac/profile/vein000', 56, '5', 294),
('rdh0827', 'https://solved.ac/profile/rdh0827', 47, '5', 295),
('mayparksy', 'https://solved.ac/profile/mayparksy', 52, '5', 296),
('winterbaek', 'https://solved.ac/profile/winterbaek', 23, '5', 297),
('curope25', 'https://solved.ac/profile/curope25', 50, '5', 298),
('dahye1020', 'https://solved.ac/profile/dahye1020', 22, '5', 299),
('nancy1124', 'https://solved.ac/profile/nancy1124', 38, '4', 300),
('sb06033', 'https://solved.ac/profile/sb06033', 31, '4', 301),
('junaniii', 'https://solved.ac/profile/junaniii', 45, '4', 302),
('adan', 'https://solved.ac/profile/adan', 17, '4', 303),
('dltjwls0529', 'https://solved.ac/profile/dltjwls0529', 20, '4', 304),
('osaa', 'https://solved.ac/profile/osaa', 13, '4', 305),
('ckckckkck', 'https://solved.ac/profile/ckckckkck', 33, '4', 306),
('tff416', 'https://solved.ac/profile/tff416', 41, '4', 307),
('my06', 'https://solved.ac/profile/my06', 42, '4', 308),
('kimgyulim', 'https://solved.ac/profile/kimgyulim', 40, '4', 309),
('vicky4sky', 'https://solved.ac/profile/vicky4sky', 38, '3', 310),
('jadely', 'https://solved.ac/profile/jadely', 32, '3', 311),
('kya202', 'https://solved.ac/profile/kya202', 34, '3', 312),
('yesilver', 'https://solved.ac/profile/yesilver', 36, '3', 313),
('stac_cato', 'https://solved.ac/profile/stac_cato', 25, '3', 314),
('estelle99', 'https://solved.ac/profile/estelle99', 38, '3', 315),
('tmdgml110806', 'https://solved.ac/profile/tmdgml110806', 32, '3', 316),
('mulan', 'https://solved.ac/profile/mulan', 10, '3', 317),
('nhi3373', 'https://solved.ac/profile/nhi3373', 17, '3', 318),
('songyeajin', 'https://solved.ac/profile/songyeajin', 28, '3', 319),
('green6150', 'https://solved.ac/profile/green6150', 33, '3', 320),
('shnystar', 'https://solved.ac/profile/shnystar', 34, '3', 321),
('jyshin398', 'https://solved.ac/profile/jyshin398', 10, '3', 322),
('oranberry', 'https://solved.ac/profile/oranberry', 40, '3', 323),
('aefyjo982', 'https://solved.ac/profile/aefyjo982', 26, '3', 324),
('ami0207', 'https://solved.ac/profile/ami0207', 25, '3', 325),
('miadmlae10', 'https://solved.ac/profile/miadmlae10', 18, '3', 326),
('bl00mfl0wer', 'https://solved.ac/profile/bl00mfl0wer', 27, '3', 327),
('ksh04', 'https://solved.ac/profile/ksh04', 33, '3', 328),
('sueandcream', 'https://solved.ac/profile/sueandcream', 25, '3', 329),
('yoyelynn', 'https://solved.ac/profile/yoyelynn', 10, '2', 330),
('kth8094', 'https://solved.ac/profile/kth8094', 26, '2', 331),
('jiwoo1031', 'https://solved.ac/profile/jiwoo1031', 23, '2', 332),
('hello820820', 'https://solved.ac/profile/hello820820', 18, '2', 333),
('chaengine', 'https://solved.ac/profile/chaengine', 26, '2', 334),
('riwoo098', 'https://solved.ac/profile/riwoo098', 22, '2', 335),
('eon2world', 'https://solved.ac/profile/eon2world', 24, '2', 336),
('wonnn12', 'https://solved.ac/profile/wonnn12', 8, '2', 337),
('yoona2023', 'https://solved.ac/profile/yoona2023', 9, '2', 338),
('yoonjk03', 'https://solved.ac/profile/yoonjk03', 10, '2', 339),
('cse_pebb', 'https://solved.ac/profile/cse_pebb', 9, '1', 340),
('dadadat', 'https://solved.ac/profile/dadadat', 5, '1', 341),
('songheecho', 'https://solved.ac/profile/songheecho', 8, '1', 342),
('lauren11', 'https://solved.ac/profile/lauren11', 16, '0', 343),
('tjdbs929', 'https://solved.ac/profile/tjdbs929', 14, '0', 344),
('ddakdae', 'https://solved.ac/profile/ddakdae', 10, '0', 345),
('jasoomin', 'https://solved.ac/profile/jasoomin', 12, '0', 346),
('sarah3561', 'https://solved.ac/profile/sarah3561', 11, '0', 347),
('hyunroh', 'https://solved.ac/profile/hyunroh', 7, '0', 348),
('oneglass', 'https://solved.ac/profile/oneglass', 10, '0', 349),
('hjson', 'https://solved.ac/profile/hjson', 10, '0', 350),
('inortho0909', 'https://solved.ac/profile/inortho0909', 8, '0', 351),
('je324', 'https://solved.ac/profile/je324', 8, '0', 352),
('skylark6918', 'https://solved.ac/profile/skylark6918', 7, '0', 353),
('cdh030303', 'https://solved.ac/profile/cdh030303', 7, '0', 354),
('ldy0250', 'https://solved.ac/profile/ldy0250', 5, '0', 355),
('7103sy', 'https://solved.ac/profile/7103sy', 3, '0', 356),
('ihj0303', 'https://solved.ac/profile/ihj0303', 2, '0', 357),
('juree1226', 'https://solved.ac/profile/juree1226', 4, '0', 358),
('rhalswl1016', 'https://solved.ac/profile/rhalswl1016', 4, '0', 359),
('warigarikun9', 'https://solved.ac/profile/warigarikun9', 4, '0', 360),
('zroe', 'https://solved.ac/profile/zroe', 4, '0', 361),
('doongle96', 'https://solved.ac/profile/doongle96', 3, '0', 362),
('hi_yujeong', 'https://solved.ac/profile/hi_yujeong', 3, '0', 363),
('kdudms712', 'https://solved.ac/profile/kdudms712', 3, '0', 364),
('boolean30', 'https://solved.ac/profile/boolean30', 3, '0', 365),
('lovejoohero', 'https://solved.ac/profile/lovejoohero', 3, '0', 366),
('lllm', 'https://solved.ac/profile/lllm', 2, '0', 367),
('dojmj', 'https://solved.ac/profile/dojmj', 1, '0', 368),
('dyisback00', 'https://solved.ac/profile/dyisback00', 1, '0', 369),
('inez11', 'https://solved.ac/profile/inez11', 1, '0', 370),
('milkteago', 'https://solved.ac/profile/milkteago', 1, '0', 371),
('molab0429', 'https://solved.ac/profile/molab0429', 1, '0', 372),
('tina1231', 'https://solved.ac/profile/tina1231', 1, '0', 373),
('bihunheay1', 'https://solved.ac/profile/bihunheay1', 0, '0', 374),
('egg_yejin', 'https://solved.ac/profile/egg_yejin', 0, '0', 375);
-- Drop
drop table PStogether;
drop table TodayPS;
drop table problems;
drop table uGroup;
drop table User;