From 3ad53aeeffec00f85bf1f3168d0e9d61c65eecb7 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Mon, 10 Jul 2023 16:06:29 +0300
Subject: feat: is_coop field on games

Former-commit-id: bf3a5a262557ade646ce8e59db152be8c521ac06
---
 backend/database/games.sql | 6 +++---
 backend/database/init.sql  | 1 +
 2 files changed, 4 insertions(+), 3 deletions(-)

(limited to 'backend/database')

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