diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-09-02 11:09:42 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-09-02 11:09:42 +0300 |
| commit | 69c5423f7954b641109166e03ad0ab174b3d55c6 (patch) | |
| tree | c53539e4b0ee17620422de3761dba70277c417c9 /backend/database | |
| parent | docs: added privacy policy (diff) | |
| download | lphub-69c5423f7954b641109166e03ad0ab174b3d55c6.tar.gz lphub-69c5423f7954b641109166e03ad0ab174b3d55c6.tar.bz2 lphub-69c5423f7954b641109166e03ad0ab174b3d55c6.zip | |
feat: testing logging system (#55)
Former-commit-id: d8c5fda30ab08b42218aead1febdf83200948763
Diffstat (limited to 'backend/database')
| -rw-r--r-- | backend/database/init.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 25de872..abace5c 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -139,3 +139,13 @@ CREATE TABLE countries ( | |||
| 139 | country_name TEXT NOT NULL, | 139 | country_name TEXT NOT NULL, |
| 140 | PRIMARY KEY (country_code) | 140 | PRIMARY KEY (country_code) |
| 141 | ); | 141 | ); |
| 142 | |||
| 143 | CREATE TABLE logs ( | ||
| 144 | id SERIAL, | ||
| 145 | user_id TEXT NOT NULL, | ||
| 146 | type TEXT NOT NULL, | ||
| 147 | description TEXT NOT NULL, | ||
| 148 | date TIMESTAMP NOT NULL DEFAULT now(), | ||
| 149 | PRIMARY KEY (id), | ||
| 150 | FOREIGN KEY (user_id) REFERENCES users(steam_id) | ||
| 151 | ); \ No newline at end of file | ||