From 2705f09f5c52b25af07a1d7ccec546de68ff32e9 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Mon, 5 Aug 2024 02:18:22 +0900
Subject: feat(backend): add `game_type` column to `games`

---
 backend/fixtures/dev.sql | 24 ++++++++++++++++++------
 1 file changed, 18 insertions(+), 6 deletions(-)

(limited to 'backend/fixtures/dev.sql')

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);
-- 
cgit v1.3.1

