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.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 9d7b68c..92ddb07 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, 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,6 +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 date TIMESTAMP NOT NULL DEFAULT now(), 185 date TIMESTAMP NOT NULL DEFAULT now(),
185 PRIMARY KEY (id), 186 PRIMARY KEY (id),
186 FOREIGN KEY (user_id) REFERENCES users(steam_id) 187 FOREIGN KEY (user_id) REFERENCES users(steam_id)