diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2022-10-26 00:33:12 +0300 |
|---|---|---|
| committer | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2022-10-26 00:33:12 +0300 |
| commit | 623a553e8a03d36c074e23b9ad259a9942a7241a (patch) | |
| tree | 49cea5a573b700e598b6ecfaaab4fab17de47104 /backend/database/init.sql | |
| parent | update .env example (diff) | |
| download | lphub-623a553e8a03d36c074e23b9ad259a9942a7241a.tar.gz lphub-623a553e8a03d36c074e23b9ad259a9942a7241a.tar.bz2 lphub-623a553e8a03d36c074e23b9ad259a9942a7241a.zip | |
init sql for users
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql new file mode 100644 index 0000000..bf10948 --- /dev/null +++ b/backend/database/init.sql | |||
| @@ -0,0 +1,11 @@ | |||
| 1 | DROP TABLE IF EXISTS users; | ||
| 2 | CREATE TABLE users ( | ||
| 3 | steam_id BIGINT, | ||
| 4 | username VARCHAR(128) NOT NULL, | ||
| 5 | avatar_link VARCHAR(128) NOT NULL, | ||
| 6 | country_code CHAR(2) NOT NULL DEFAULT 'X', | ||
| 7 | created_at TIMESTAMP NOT NULL, | ||
| 8 | updated_at TIMESTAMP, | ||
| 9 | user_type SMALLINT NOT NULL, | ||
| 10 | PRIMARY KEY (steam_id) | ||
| 11 | ); \ No newline at end of file | ||