From b37e49da3698a3c92b214931a23dcdb1ac41587c Mon Sep 17 00:00:00 2001 From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> Date: Thu, 28 Sep 2023 18:40:58 +0300 Subject: feat: improve logs and mod log endpoint (#55) Former-commit-id: 7f2d9100cc4bd78c27544909fe7215913d6a2dfe --- backend/database/init.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'backend/database/init.sql') 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 ( category_id SMALLINT NOT NULL, score_count SMALLINT NOT NULL, description TEXT NOT NULL, - showcase TEXT NOT NULL DEFAULT '-', + showcase TEXT NOT NULL DEFAULT, PRIMARY KEY (id), FOREIGN KEY (map_id) REFERENCES maps(id), FOREIGN KEY (category_id) REFERENCES categories(id), @@ -181,7 +181,7 @@ CREATE TABLE logs ( user_id TEXT NOT NULL, type TEXT NOT NULL, description TEXT NOT NULL, - message TEXT NOT NULL DEFAULT '-', + message TEXT NOT NULL DEFAULT, date TIMESTAMP NOT NULL DEFAULT now(), PRIMARY KEY (id), FOREIGN KEY (user_id) REFERENCES users(steam_id) -- cgit v1.2.3