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, 2 insertions, 2 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql
index 51bf2af..11ccd38 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -68,7 +68,7 @@ CREATE TABLE map_history (
68 user_name TEXT NOT NULL, 68 user_name TEXT NOT NULL,
69 score_count SMALLINT NOT NULL, 69 score_count SMALLINT NOT NULL,
70 description TEXT NOT NULL, 70 description TEXT NOT NULL,
71 showcase TEXT NOT NULL DEFAULT, 71 showcase TEXT NOT NULL DEFAULT '',
72 record_date DATE NOT NULL, 72 record_date DATE NOT NULL,
73 PRIMARY KEY (id), 73 PRIMARY KEY (id),
74 FOREIGN KEY (category_id) REFERENCES categories(id), 74 FOREIGN KEY (category_id) REFERENCES categories(id),
@@ -210,7 +210,7 @@ CREATE TABLE audit (
210 old_data JSONB, 210 old_data JSONB,
211 new_data JSONB, 211 new_data JSONB,
212 changed_by TEXT NOT NULL, 212 changed_by TEXT NOT NULL,
213 changed_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, 213 changed_at TIMESTAMP DEFAULT now(),
214 PRIMARY KEY (id), 214 PRIMARY KEY (id),
215 FOREIGN KEY (changed_by) REFERENCES users(steam_id) 215 FOREIGN KEY (changed_by) REFERENCES users(steam_id)
216); 216);