diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2022-10-29 00:37:39 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2022-10-29 00:37:39 +0300 |
| commit | 27feaa383a357b1a391c466295b0b8c3287599d3 (patch) | |
| tree | 88d2c561c8afd655a94faa6f8d911ff293048af6 /backend/database/init.sql | |
| parent | actually use port env (diff) | |
| download | lphub-27feaa383a357b1a391c466295b0b8c3287599d3.tar.gz lphub-27feaa383a357b1a391c466295b0b8c3287599d3.tar.bz2 lphub-27feaa383a357b1a391c466295b0b8c3287599d3.zip | |
change default country_code to 'XX'
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 bf10948..e877db3 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -3,7 +3,7 @@ CREATE TABLE users ( | |||
| 3 | steam_id BIGINT, | 3 | steam_id BIGINT, |
| 4 | username VARCHAR(128) NOT NULL, | 4 | username VARCHAR(128) NOT NULL, |
| 5 | avatar_link VARCHAR(128) NOT NULL, | 5 | avatar_link VARCHAR(128) NOT NULL, |
| 6 | country_code CHAR(2) NOT NULL DEFAULT 'X', | 6 | country_code CHAR(2) NOT NULL DEFAULT 'XX', |
| 7 | created_at TIMESTAMP NOT NULL, | 7 | created_at TIMESTAMP NOT NULL, |
| 8 | updated_at TIMESTAMP, | 8 | updated_at TIMESTAMP, |
| 9 | user_type SMALLINT NOT NULL, | 9 | user_type SMALLINT NOT NULL, |