feat(backend): add `game_type` column to `games`

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);