diff options
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 196cb71..50e7c15 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -9,14 +9,14 @@ CREATE TABLE users ( | |||
| 9 | ); | 9 | ); |
| 10 | 10 | ||
| 11 | CREATE TABLE games ( | 11 | CREATE TABLE games ( |
| 12 | id SMALLSERIAL, | 12 | id SERIAL, |
| 13 | name TEXT NOT NULL, | 13 | name TEXT NOT NULL, |
| 14 | is_coop BOOLEAN NOT NULL, | 14 | is_coop BOOLEAN NOT NULL, |
| 15 | PRIMARY KEY (id) | 15 | PRIMARY KEY (id) |
| 16 | ); | 16 | ); |
| 17 | 17 | ||
| 18 | CREATE TABLE chapters ( | 18 | CREATE TABLE chapters ( |
| 19 | id SMALLSERIAL, | 19 | id SERIAL, |
| 20 | game_id SMALLINT NOT NULL, | 20 | game_id SMALLINT NOT NULL, |
| 21 | name TEXT NOT NULL, | 21 | name TEXT NOT NULL, |
| 22 | PRIMARY KEY (id), | 22 | PRIMARY KEY (id), |
| @@ -24,13 +24,13 @@ CREATE TABLE chapters ( | |||
| 24 | ); | 24 | ); |
| 25 | 25 | ||
| 26 | CREATE TABLE categories ( | 26 | CREATE TABLE categories ( |
| 27 | id SMALLSERIAL, | 27 | id SERIAL, |
| 28 | name TEXT NOT NULL, | 28 | name TEXT NOT NULL, |
| 29 | PRIMARY KEY (id) | 29 | PRIMARY KEY (id) |
| 30 | ); | 30 | ); |
| 31 | 31 | ||
| 32 | CREATE TABLE maps ( | 32 | CREATE TABLE maps ( |
| 33 | id SMALLSERIAL, | 33 | id SERIAL, |
| 34 | game_id SMALLINT NOT NULL, | 34 | game_id SMALLINT NOT NULL, |
| 35 | chapter_id SMALLINT NOT NULL, | 35 | chapter_id SMALLINT NOT NULL, |
| 36 | name TEXT NOT NULL, | 36 | name TEXT NOT NULL, |
| @@ -41,7 +41,7 @@ CREATE TABLE maps ( | |||
| 41 | ); | 41 | ); |
| 42 | 42 | ||
| 43 | CREATE TABLE map_routes ( | 43 | CREATE TABLE map_routes ( |
| 44 | id SMALLSERIAL, | 44 | id SERIAL, |
| 45 | map_id SMALLINT NOT NULL, | 45 | map_id SMALLINT NOT NULL, |
| 46 | category_id SMALLINT NOT NULL, | 46 | category_id SMALLINT NOT NULL, |
| 47 | score_count SMALLINT NOT NULL, | 47 | score_count SMALLINT NOT NULL, |
| @@ -54,7 +54,7 @@ CREATE TABLE map_routes ( | |||
| 54 | ); | 54 | ); |
| 55 | 55 | ||
| 56 | CREATE TABLE map_history ( | 56 | CREATE TABLE map_history ( |
| 57 | id SMALLSERIAL, | 57 | id SERIAL, |
| 58 | map_id SMALLINT NOT NULL, | 58 | map_id SMALLINT NOT NULL, |
| 59 | category_id SMALLINT NOT NULL, | 59 | category_id SMALLINT NOT NULL, |
| 60 | user_name TEXT NOT NULL, | 60 | user_name TEXT NOT NULL, |