diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-08-20 12:36:34 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-08-20 12:36:34 +0300 |
| commit | 9f7b5a836c8aeb83b66e0b41b8533443b5e99380 (patch) | |
| tree | 17132fc02ff6b2a397ef13e1e1dda13977243d49 /backend/database/init.sql | |
| parent | docs: update license name in disclaimer (diff) | |
| download | lphub-9f7b5a836c8aeb83b66e0b41b8533443b5e99380.tar.gz lphub-9f7b5a836c8aeb83b66e0b41b8533443b5e99380.tar.bz2 lphub-9f7b5a836c8aeb83b66e0b41b8533443b5e99380.zip | |
fix: change map history from timestamp to date
Former-commit-id: 8a46950e919891f380dda5502e40434383c91245
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 50e7c15..11d4944 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -59,7 +59,7 @@ CREATE TABLE map_history ( | |||
| 59 | category_id SMALLINT NOT NULL, | 59 | category_id SMALLINT NOT NULL, |
| 60 | user_name TEXT NOT NULL, | 60 | user_name TEXT NOT NULL, |
| 61 | score_count SMALLINT NOT NULL, | 61 | score_count SMALLINT NOT NULL, |
| 62 | record_date TIMESTAMP NOT NULL, | 62 | record_date DATE NOT NULL, |
| 63 | PRIMARY KEY (id), | 63 | PRIMARY KEY (id), |
| 64 | FOREIGN KEY (category_id) REFERENCES categories(id), | 64 | FOREIGN KEY (category_id) REFERENCES categories(id), |
| 65 | FOREIGN KEY (map_id) REFERENCES maps(id), | 65 | FOREIGN KEY (map_id) REFERENCES maps(id), |