diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-05 03:07:30 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-05 03:07:30 +0900 |
| commit | 9ff9c151e5defd9eed5cba3c88bc341b4360d09c (patch) | |
| tree | bf5b9e721274ffa58df66823d39f9ceadebc9f98 /backend/fixtures/dev.sql | |
| parent | ff959dadb1f990173b9df3105ccfc96b1c6c092e (diff) | |
| parent | 498ad23eaaae1e856c71f44ad0bf3912a6d7e5b7 (diff) | |
| download | phperkaigi-2025-albatross-9ff9c151e5defd9eed5cba3c88bc341b4360d09c.tar.gz phperkaigi-2025-albatross-9ff9c151e5defd9eed5cba3c88bc341b4360d09c.tar.zst phperkaigi-2025-albatross-9ff9c151e5defd9eed5cba3c88bc341b4360d09c.zip | |
Merge branch 'feat/multiplayer-mode'
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); |
