From 87113c5fb4c539573a33114581debddecfc9ece9 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Wed, 27 Sep 2023 22:33:57 +0300
Subject: feat: detailed logging, db changes (#55)

Former-commit-id: 74219281915f55ac46cff3795edd4364be84d561
---
 backend/database/init.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'backend/database/init.sql')

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 (
   category_id SMALLINT NOT NULL,
   score_count SMALLINT NOT NULL,
   description TEXT NOT NULL,
-  showcase TEXT NOT NULL,
+  showcase TEXT NOT NULL DEFAULT '-',
   PRIMARY KEY (id),
   FOREIGN KEY (map_id) REFERENCES maps(id),
   FOREIGN KEY (category_id) REFERENCES categories(id),
@@ -181,6 +181,7 @@ CREATE TABLE logs (
   user_id TEXT NOT NULL,
   type TEXT NOT NULL,
   description TEXT NOT NULL,
+  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