diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-09-28 18:40:58 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-09-28 18:40:58 +0300 |
| commit | b37e49da3698a3c92b214931a23dcdb1ac41587c (patch) | |
| tree | 569d8e3e7fdffe5dd67919ce82853aaed69f69e9 /backend/database/init.sql | |
| parent | fix: check for category id for map history when deleting summary (#106) (diff) | |
| download | lphub-b37e49da3698a3c92b214931a23dcdb1ac41587c.tar.gz lphub-b37e49da3698a3c92b214931a23dcdb1ac41587c.tar.bz2 lphub-b37e49da3698a3c92b214931a23dcdb1ac41587c.zip | |
feat: improve logs and mod log endpoint (#55)
Former-commit-id: 7f2d9100cc4bd78c27544909fe7215913d6a2dfe
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 92ddb07..17a0ce5 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -50,7 +50,7 @@ CREATE TABLE map_routes ( | |||
| 50 | category_id SMALLINT NOT NULL, | 50 | category_id SMALLINT NOT NULL, |
| 51 | score_count SMALLINT NOT NULL, | 51 | score_count SMALLINT NOT NULL, |
| 52 | description TEXT NOT NULL, | 52 | description TEXT NOT NULL, |
| 53 | showcase TEXT NOT NULL DEFAULT '-', | 53 | showcase TEXT NOT NULL DEFAULT, |
| 54 | PRIMARY KEY (id), | 54 | PRIMARY KEY (id), |
| 55 | FOREIGN KEY (map_id) REFERENCES maps(id), | 55 | FOREIGN KEY (map_id) REFERENCES maps(id), |
| 56 | FOREIGN KEY (category_id) REFERENCES categories(id), | 56 | FOREIGN KEY (category_id) REFERENCES categories(id), |
| @@ -181,7 +181,7 @@ CREATE TABLE logs ( | |||
| 181 | user_id TEXT NOT NULL, | 181 | user_id TEXT NOT NULL, |
| 182 | type TEXT NOT NULL, | 182 | type TEXT NOT NULL, |
| 183 | description TEXT NOT NULL, | 183 | description TEXT NOT NULL, |
| 184 | message TEXT NOT NULL DEFAULT '-', | 184 | message TEXT NOT NULL DEFAULT, |
| 185 | date TIMESTAMP NOT NULL DEFAULT now(), | 185 | date TIMESTAMP NOT NULL DEFAULT now(), |
| 186 | PRIMARY KEY (id), | 186 | PRIMARY KEY (id), |
| 187 | FOREIGN KEY (user_id) REFERENCES users(steam_id) | 187 | FOREIGN KEY (user_id) REFERENCES users(steam_id) |