aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/fixtures/dev.sql
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2024-08-05 03:07:30 +0900
committernsfisis <nsfisis@gmail.com>2024-08-05 03:07:30 +0900
commit9ff9c151e5defd9eed5cba3c88bc341b4360d09c (patch)
treebf5b9e721274ffa58df66823d39f9ceadebc9f98 /backend/fixtures/dev.sql
parentff959dadb1f990173b9df3105ccfc96b1c6c092e (diff)
parent498ad23eaaae1e856c71f44ad0bf3912a6d7e5b7 (diff)
downloadphperkaigi-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.sql24
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);