feat: is_coop field on games

Former-commit-id: bf3a5a262557ade646ce8e59db152be8c521ac06

2 files changed, 4 insertions, 3 deletions

diff --git a/backend/database/games.sql b/backend/database/games.sql
index 5e2f4ee..0c2374c 100644
--- a/backend/database/games.sql
+++ b/backend/database/games.sql
@@ -1,3 +1,3 @@
-INSERT INTO games(id, name) VALUES
-(1, 'Portal 2 - Singleplayer'),
-(2, 'Portal 2 - Cooperative');
\ No newline at end of file
+INSERT INTO games(id, name, is_coop) VALUES
+(1, 'Portal 2 - Singleplayer', false),
+(2, 'Portal 2 - Cooperative', true);
\ No newline at end of file
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 76c3aa6..c7d098c 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -11,6 +11,7 @@ CREATE TABLE users (
 CREATE TABLE games (
   id SMALLSERIAL,
   name TEXT NOT NULL,
+  is_coop BOOLEAN NOT NULL,
   PRIMARY KEY (id)
 );