From 92d4926ed163e7c242beb90aeca8b1cf69010179 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sat, 14 Jan 2023 17:47:42 +0300
Subject: added countries, update country (#4)

---
 backend/database/init.sql | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'backend/database/init.sql')

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;
 DROP TABLE IF EXISTS records_mp;
 DROP TABLE IF EXISTS maps;
 DROP TABLE IF EXISTS users;
+DROP TABLE IF EXISTS countries;
 
 DROP TABLE IF EXISTS demos;
 
@@ -69,4 +70,10 @@ CREATE TABLE titles (
   title_name TEXT NOT NULL,
   PRIMARY KEY (user_id),
   FOREIGN KEY (user_id) REFERENCES users(steam_id)
+);
+
+CREATE TABLE countries (
+  country_code CHAR(2),
+  country_name TEXT NOT NULL,
+  PRIMARY KEY (country_code)
 );
\ No newline at end of file
-- 
cgit v1.2.3