aboutsummaryrefslogtreecommitdiff
path: root/backend/database/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'backend/database/init.sql')
-rw-r--r--backend/database/init.sql4
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 (
44CREATE TABLE map_history ( 44CREATE 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
56CREATE TABLE map_ratings ( 54CREATE TABLE map_ratings (