diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-01-15 02:48:44 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2023-01-15 02:48:44 +0300 |
| commit | 7884ae7ca077082a7d87621aa1f437628f10372d (patch) | |
| tree | 6b134dd44ef40bd1bc1a71904fc1b94ca7a998b1 /backend/database/init.sql | |
| parent | added countries, update country (#4) (diff) | |
| download | lphub-7884ae7ca077082a7d87621aa1f437628f10372d.tar.gz lphub-7884ae7ca077082a7d87621aa1f437628f10372d.tar.bz2 lphub-7884ae7ca077082a7d87621aa1f437628f10372d.zip | |
add wr time to maps database
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 345cee3..f5d380c 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -22,6 +22,7 @@ CREATE TABLE maps ( | |||
| 22 | id SMALLSERIAL, | 22 | id SMALLSERIAL, |
| 23 | map_name TEXT NOT NULL, | 23 | map_name TEXT NOT NULL, |
| 24 | wr_score SMALLINT NOT NULL, | 24 | wr_score SMALLINT NOT NULL, |
| 25 | wr_time INTEGER NOT NULL, | ||
| 25 | is_coop BOOLEAN NOT NULL, | 26 | is_coop BOOLEAN NOT NULL, |
| 26 | is_disabled BOOLEAN NOT NULL DEFAULT false, | 27 | is_disabled BOOLEAN NOT NULL DEFAULT false, |
| 27 | PRIMARY KEY (id) | 28 | PRIMARY KEY (id) |