diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2024-10-31 22:54:28 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2024-10-31 22:54:28 +0300 |
| commit | 69e15976e42ef404f5b0857e0ca2ea3bb8e6159b (patch) | |
| tree | 7f17f86b19f25a4e3e47a8edf5104ec3ab5256a4 /backend/database/init.sql | |
| parent | backend: add rate limiting (diff) | |
| download | lphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.tar.gz lphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.tar.bz2 lphub-69e15976e42ef404f5b0857e0ca2ea3bb8e6159b.zip | |
database: organize sql files
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 | ); |