diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-09-27 22:33:57 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-09-27 22:33:57 +0300 |
| commit | 87113c5fb4c539573a33114581debddecfc9ece9 (patch) | |
| tree | 5c02f05744b85c4218924fb802dcfae745c7a67d /backend/database | |
| parent | feat: check for deleted records in users (#56) (diff) | |
| download | lphub-87113c5fb4c539573a33114581debddecfc9ece9.tar.gz lphub-87113c5fb4c539573a33114581debddecfc9ece9.tar.bz2 lphub-87113c5fb4c539573a33114581debddecfc9ece9.zip | |
feat: detailed logging, db changes (#55)
Former-commit-id: 74219281915f55ac46cff3795edd4364be84d561
Diffstat (limited to 'backend/database')
| -rw-r--r-- | backend/database/init.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 9d7b68c..92ddb07 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, | 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,6 +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 | date TIMESTAMP NOT NULL DEFAULT now(), | 185 | date TIMESTAMP NOT NULL DEFAULT now(), |
| 185 | PRIMARY KEY (id), | 186 | PRIMARY KEY (id), |
| 186 | FOREIGN KEY (user_id) REFERENCES users(steam_id) | 187 | FOREIGN KEY (user_id) REFERENCES users(steam_id) |