aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--backend/database/init.sql4
-rw-r--r--backend/database/insert/categories.sql (renamed from backend/database/categories.sql)0
-rw-r--r--backend/database/insert/chapters.sql (renamed from backend/database/chapters.sql)0
-rw-r--r--backend/database/insert/countries.sql (renamed from backend/database/countries.sql)0
-rw-r--r--backend/database/insert/games.sql (renamed from backend/database/games.sql)0
-rw-r--r--backend/database/insert/history.sql (renamed from backend/database/history.sql)0
-rw-r--r--backend/database/insert/maps.sql (renamed from backend/database/maps.sql)2
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 (
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);
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
118(2,15,'Propulsion Retrieval',false,''), 118(2,15,'Propulsion Retrieval',false,''),
119(2,15,'Vault Entrance',false,''), 119(2,15,'Vault Entrance',false,''),
120-- 6 120-- 6
121(2,16,'Seperation',false,''), 121(2,16,'Separation',false,''),
122(2,16,'Triple Axis',false,''), 122(2,16,'Triple Axis',false,''),
123(2,16,'Catapult Catch',false,''), 123(2,16,'Catapult Catch',false,''),
124(2,16,'Bridge Gels',false,''), 124(2,16,'Bridge Gels',false,''),