aboutsummaryrefslogtreecommitdiff
path: root/backend/database/init.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--backend/database/init.sql7
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;
4DROP TABLE IF EXISTS records_mp; 4DROP TABLE IF EXISTS records_mp;
5DROP TABLE IF EXISTS maps; 5DROP TABLE IF EXISTS maps;
6DROP TABLE IF EXISTS users; 6DROP TABLE IF EXISTS users;
7DROP TABLE IF EXISTS countries;
7 8
8DROP TABLE IF EXISTS demos; 9DROP 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
75CREATE 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