diff options
| -rw-r--r-- | backend/database/init.sql | 4 | ||||
| -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,''), |