diff options
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 81461c2..51a4881 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -44,13 +44,11 @@ CREATE TABLE maps ( | |||
| 44 | CREATE TABLE map_history ( | 44 | CREATE TABLE map_history ( |
| 45 | id SMALLSERIAL, | 45 | id SMALLSERIAL, |
| 46 | map_id SMALLINT NOT NULL, | 46 | map_id SMALLINT NOT NULL, |
| 47 | user_id TEXT, | ||
| 48 | user_name TEXT NOT NULL, | 47 | user_name TEXT NOT NULL, |
| 49 | score_count SMALLINT NOT NULL, | 48 | score_count SMALLINT NOT NULL, |
| 50 | record_date TIMESTAMP NOT NULL, | 49 | record_date TIMESTAMP NOT NULL, |
| 51 | PRIMARY KEY (id), | 50 | PRIMARY KEY (id), |
| 52 | FOREIGN KEY (map_id) REFERENCES maps(id), | 51 | FOREIGN KEY (map_id) REFERENCES maps(id) |
| 53 | FOREIGN KEY (user_id) REFERENCES users(steam_id) | ||
| 54 | ); | 52 | ); |
| 55 | 53 | ||
| 56 | CREATE TABLE map_ratings ( | 54 | CREATE TABLE map_ratings ( |