From 69e15976e42ef404f5b0857e0ca2ea3bb8e6159b Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Thu, 31 Oct 2024 22:54:28 +0300
Subject: database: organize sql files

---
 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 51bf2af..11ccd38 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -68,7 +68,7 @@ CREATE TABLE map_history (
   user_name TEXT NOT NULL,
   score_count SMALLINT NOT NULL,
   description TEXT NOT NULL,
-  showcase TEXT NOT NULL DEFAULT,
+  showcase TEXT NOT NULL DEFAULT '',
   record_date DATE NOT NULL,
   PRIMARY KEY (id),
   FOREIGN KEY (category_id) REFERENCES categories(id),
@@ -210,7 +210,7 @@ CREATE TABLE audit (
     old_data JSONB,
     new_data JSONB,
     changed_by TEXT NOT NULL,
-    changed_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
+    changed_at TIMESTAMP DEFAULT now(),
     PRIMARY KEY (id),
     FOREIGN KEY (changed_by) REFERENCES users(steam_id)
 );
-- 
cgit v1.2.3

