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
|
INSERT INTO users
(username, display_name, icon_path, is_admin)
VALUES
('a', 'TEST A', NULL, FALSE),
('b', 'TEST B', NULL, FALSE),
('c', 'TEST C', NULL, TRUE);
INSERT INTO user_auths
(user_id, auth_type, password_hash)
VALUES
(1, 'password', '$2a$10$5FzjoitnZSFFpIPHEqmnXOQkSKWTLwpR.gqPy50iFg5itOZcqARHq'),
(2, 'password', '$2a$10$4Wl1M4jQs.GwkB4oT32KvuMQtF.EdqKuOc8z8KKOupnuMJRAVk32W'),
(3, 'password', '$2a$10$F/TePpu1pyJRWgn0e6A14.VL9D/17sRxT/2DyZ2Oi4Eg/lR6n7JcK');
INSERT INTO problems
(title, description)
VALUES
('TEST problem 1', 'This is TEST problem 1'),
('TEST problem 2', 'This is TEST problem 2'),
('TEST problem 3', 'This is TEST problem 3');
INSERT INTO games
(state, display_name, duration_seconds, problem_id)
VALUES
('waiting_entries', 'TEST game 1', 180, 1),
('closed', 'TEST game 2', 180, 2),
('finished', 'TEST game 3', 180, 3);
INSERT INTO game_players
(game_id, user_id)
VALUES
(1, 1),
(1, 2),
(2, 1),
(2, 2),
(3, 1),
(3, 2);
|
