database: organize sql files

7 files changed, 3 insertions, 3 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 (
   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)
 );
diff --git a/backend/database/categories.sql b/backend/database/insert/categories.sql
index 6bbf9b0..6bbf9b0 100644
--- a/backend/database/categories.sql
+++ b/backend/database/insert/categories.sql
diff --git a/backend/database/chapters.sql b/backend/database/insert/chapters.sql
index f61d5bf..f61d5bf 100644
--- a/backend/database/chapters.sql
+++ b/backend/database/insert/chapters.sql
diff --git a/backend/database/countries.sql b/backend/database/insert/countries.sql
index 0272f6f..0272f6f 100644
--- a/backend/database/countries.sql
+++ b/backend/database/insert/countries.sql
diff --git a/backend/database/games.sql b/backend/database/insert/games.sql
index 0c2374c..0c2374c 100644
--- a/backend/database/games.sql
+++ b/backend/database/insert/games.sql
diff --git a/backend/database/history.sql b/backend/database/insert/history.sql
index 34fddcb..34fddcb 100644
--- a/backend/database/history.sql
+++ b/backend/database/insert/history.sql
diff --git a/backend/database/maps.sql b/backend/database/insert/maps.sql
index 082c85a..f0235fa 100644
--- a/backend/database/maps.sql
+++ b/backend/database/insert/maps.sql
@@ -118,7 +118,7 @@ INSERT INTO maps(game_id, chapter_id, name, is_disabled, image) VALUES
 (2,15,'Propulsion Retrieval',false,''),
 (2,15,'Vault Entrance',false,''),
 -- 6
-(2,16,'Seperation',false,''),
+(2,16,'Separation',false,''),
 (2,16,'Triple Axis',false,''),
 (2,16,'Catapult Catch',false,''),
 (2,16,'Bridge Gels',false,''),