aboutsummaryrefslogtreecommitdiff
path: root/backend/database
diff options
context:
space:
mode:
Diffstat (limited to 'backend/database')
-rw-r--r--backend/database/games.sql6
-rw-r--r--backend/database/init.sql1
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 @@
1INSERT INTO games(id, name) VALUES 1INSERT INTO games(id, name, is_coop) VALUES
2(1, 'Portal 2 - Singleplayer'), 2(1, 'Portal 2 - Singleplayer', false),
3(2, 'Portal 2 - Cooperative'); \ No newline at end of file 3(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 (
11CREATE TABLE games ( 11CREATE TABLE games (
12 id SMALLSERIAL, 12 id SMALLSERIAL,
13 name TEXT NOT NULL, 13 name TEXT NOT NULL,
14 is_coop BOOLEAN NOT NULL,
14 PRIMARY KEY (id) 15 PRIMARY KEY (id)
15); 16);
16 17