diff options
Diffstat (limited to 'backend/database/init.sql')
| -rw-r--r-- | backend/database/init.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/backend/database/init.sql b/backend/database/init.sql index 12a2487..345cee3 100644 --- a/backend/database/init.sql +++ b/backend/database/init.sql | |||
| @@ -4,6 +4,7 @@ DROP TABLE IF EXISTS records_sp; | |||
| 4 | DROP TABLE IF EXISTS records_mp; | 4 | DROP TABLE IF EXISTS records_mp; |
| 5 | DROP TABLE IF EXISTS maps; | 5 | DROP TABLE IF EXISTS maps; |
| 6 | DROP TABLE IF EXISTS users; | 6 | DROP TABLE IF EXISTS users; |
| 7 | DROP TABLE IF EXISTS countries; | ||
| 7 | 8 | ||
| 8 | DROP TABLE IF EXISTS demos; | 9 | DROP TABLE IF EXISTS demos; |
| 9 | 10 | ||
| @@ -69,4 +70,10 @@ CREATE TABLE titles ( | |||
| 69 | title_name TEXT NOT NULL, | 70 | title_name TEXT NOT NULL, |
| 70 | PRIMARY KEY (user_id), | 71 | PRIMARY KEY (user_id), |
| 71 | FOREIGN KEY (user_id) REFERENCES users(steam_id) | 72 | FOREIGN KEY (user_id) REFERENCES users(steam_id) |
| 73 | ); | ||
| 74 | |||
| 75 | CREATE TABLE countries ( | ||
| 76 | country_code CHAR(2), | ||
| 77 | country_name TEXT NOT NULL, | ||
| 78 | PRIMARY KEY (country_code) | ||
| 72 | ); \ No newline at end of file | 79 | ); \ No newline at end of file |