diff options
Diffstat (limited to 'backend/fixtures/dev.sql')
| -rw-r--r-- | backend/fixtures/dev.sql | 24 |
1 files changed, 18 insertions, 6 deletions
diff --git a/backend/fixtures/dev.sql b/backend/fixtures/dev.sql index 5e47386..a468d01 100644 --- a/backend/fixtures/dev.sql +++ b/backend/fixtures/dev.sql @@ -17,14 +17,20 @@ INSERT INTO problems 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'); + ('TEST problem 3', 'This is TEST problem 3'), + ('TEST problem 4', 'This is TEST problem 4'), + ('TEST problem 5', 'This is TEST problem 5'), + ('TEST problem 6', 'This is TEST problem 6'); INSERT INTO games -(state, display_name, duration_seconds, problem_id) +(game_type, 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); + ('1v1', 'waiting_entries', 'TEST game 1', 180, 1), + ('1v1', 'closed', 'TEST game 2', 180, 2), + ('1v1', 'finished', 'TEST game 3', 180, 3), + ('multiplayer', 'waiting_start', 'TEST game 4', 180, 4), + ('multiplayer', 'closed', 'TEST game 5', 180, 5), + ('multiplayer', 'finished', 'TEST game 6', 180, 6); INSERT INTO game_players (game_id, user_id) @@ -34,4 +40,10 @@ VALUES (2, 1), (2, 2), (3, 1), - (3, 2); + (3, 2), + (4, 1), + (4, 2), + (5, 1), + (5, 2), + (6, 1), + (6, 2); |