diff options
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), |