diff options
Diffstat (limited to 'backend/database')
| -rw-r--r-- | backend/database/games.sql | 6 | ||||
| -rw-r--r-- | backend/database/init.sql | 1 |
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 @@ | |||
| 1 | INSERT INTO games(id, name) VALUES | 1 | INSERT 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 ( | |||
| 11 | CREATE TABLE games ( | 11 | CREATE 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 | ||