diff options
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 4 |
1 files changed, 2 insertions, 2 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 | ); |