diff options
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 92ddb07..17a0ce5 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -50,7 +50,7 @@ CREATE TABLE map_routes ( | |||
| 50 | category_id SMALLINT NOT NULL, | 50 | category_id SMALLINT NOT NULL, |
| 51 | score_count SMALLINT NOT NULL, | 51 | score_count SMALLINT NOT NULL, |
| 52 | description TEXT NOT NULL, | 52 | description TEXT NOT NULL, |
| 53 | showcase TEXT NOT NULL DEFAULT '-', | 53 | showcase TEXT NOT NULL DEFAULT, |
| 54 | PRIMARY KEY (id), | 54 | PRIMARY KEY (id), |
| 55 | FOREIGN KEY (map_id) REFERENCES maps(id), | 55 | FOREIGN KEY (map_id) REFERENCES maps(id), |
| 56 | FOREIGN KEY (category_id) REFERENCES categories(id), | 56 | FOREIGN KEY (category_id) REFERENCES categories(id), |
| @@ -181,7 +181,7 @@ CREATE TABLE logs ( | |||
| 181 | user_id TEXT NOT NULL, | 181 | user_id TEXT NOT NULL, |
| 182 | type TEXT NOT NULL, | 182 | type TEXT NOT NULL, |
| 183 | description TEXT NOT NULL, | 183 | description TEXT NOT NULL, |
| 184 | message TEXT NOT NULL DEFAULT '-', | 184 | message TEXT NOT NULL DEFAULT, |
| 185 | date TIMESTAMP NOT NULL DEFAULT now(), | 185 | date TIMESTAMP NOT NULL DEFAULT now(), |
| 186 | PRIMARY KEY (id), | 186 | PRIMARY KEY (id), |
| 187 | FOREIGN KEY (user_id) REFERENCES users(steam_id) | 187 | FOREIGN KEY (user_id) REFERENCES users(steam_id) |