PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "city" (
"ID" INT,
"CountryCode" CHAR(3),
PRIMARY KEY ("ID"),
FOREIGN KEY ("CountryCode") REFERENCES "country"("Code")
);

CREATE TABLE "country" (
"Code" CHAR(3) UNIQUE,
"Name" CHAR(52),
"Continent" TEXT,
"Region" CHAR(26),
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
PRIMARY KEY ("CountryCode", "Language"),
FOREIGN KEY ("CountryCode") REFERENCES "country"("Code")
);





INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "Western Europe");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "North America");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "Eastern Asia");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "Eastern Asia");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "South America");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "North America");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "Australia and New Zealand");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "Western Europe");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "Western Europe");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "Western Europe");
INSERT INTO "country" VALUES ("RUS", "Russian Federation", "Europe", "Eastern Europe");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "Northern Africa");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "Southern Africa");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "Central America");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "South America");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "Eastern Asia");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "Middle East");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "Middle East");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "Middle East");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "Middle East");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "Middle East");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "Eastern Asia");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Asia", "Southeast Asia");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("KAZ", "Kazakstan", "Asia", "Southern and Central Asia");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "Middle East");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "Middle East");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "Middle East");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "Middle East");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "Middle East");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "Middle East");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "Middle East");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "Middle East");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "Middle East");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "Middle East");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "Middle East");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "Middle East");
INSERT INTO "country" VALUES ("PSE", "Palestine", "Asia", "Middle East");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "Asia", "Eastern Asia");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "Eastern Asia");
INSERT INTO "country" VALUES ("HKG", "Hong Kong", "Asia", "Eastern Asia");
INSERT INTO "country" VALUES ("MAC", "Macao", "Asia", "Eastern Asia");
INSERT INTO "city" VALUES ("1", "AFG");
INSERT INTO "city" VALUES ("2", "NLD");
INSERT INTO "city" VALUES ("3", "USA");
INSERT INTO "city" VALUES ("4", "CHN");
INSERT INTO "city" VALUES ("5", "IND");
INSERT INTO "city" VALUES ("6", "JPN");
INSERT INTO "city" VALUES ("7", "BRA");
INSERT INTO "city" VALUES ("8", "CAN");
INSERT INTO "city" VALUES ("9", "AUS");
INSERT INTO "city" VALUES ("10", "DEU");
INSERT INTO "city" VALUES ("11", "FRA");
INSERT INTO "city" VALUES ("12", "GBR");
INSERT INTO "city" VALUES ("13", "RUS");
INSERT INTO "city" VALUES ("14", "EGY");
INSERT INTO "city" VALUES ("15", "ZAF");
INSERT INTO "city" VALUES ("16", "MEX");
INSERT INTO "city" VALUES ("17", "ARG");
INSERT INTO "city" VALUES ("18", "KOR");
INSERT INTO "city" VALUES ("19", "IDN");
INSERT INTO "city" VALUES ("20", "PAK");
INSERT INTO "city" VALUES ("21", "SAU");
INSERT INTO "city" VALUES ("22", "TUR");
INSERT INTO "city" VALUES ("23", "VNM");
INSERT INTO "city" VALUES ("24", "THA");
INSERT INTO "city" VALUES ("25", "MYS");
INSERT INTO "city" VALUES ("26", "PHL");
INSERT INTO "city" VALUES ("27", "IRN");
INSERT INTO "city" VALUES ("28", "IRQ");
INSERT INTO "city" VALUES ("29", "ISR");
INSERT INTO "city" VALUES ("30", "ARE");
INSERT INTO "city" VALUES ("31", "SGP");
INSERT INTO "city" VALUES ("32", "PRK");
INSERT INTO "city" VALUES ("33", "BGD");
INSERT INTO "city" VALUES ("34", "NPL");
INSERT INTO "city" VALUES ("35", "LKA");
INSERT INTO "city" VALUES ("36", "MMR");
INSERT INTO "city" VALUES ("37", "KHM");
INSERT INTO "city" VALUES ("38", "LAO");
INSERT INTO "city" VALUES ("39", "BRN");
INSERT INTO "city" VALUES ("40", "TLS");
INSERT INTO "city" VALUES ("41", "BTN");
INSERT INTO "city" VALUES ("42", "MDV");
INSERT INTO "city" VALUES ("43", "KGZ");
INSERT INTO "city" VALUES ("44", "TJK");
INSERT INTO "city" VALUES ("45", "TKM");
INSERT INTO "city" VALUES ("46", "UZB");
INSERT INTO "city" VALUES ("47", "KAZ");
INSERT INTO "city" VALUES ("48", "GEO");
INSERT INTO "city" VALUES ("49", "ARM");
INSERT INTO "city" VALUES ("50", "AZE");
INSERT INTO "city" VALUES ("51", "CYP");
INSERT INTO "city" VALUES ("52", "SYR");
INSERT INTO "city" VALUES ("53", "LBN");
INSERT INTO "city" VALUES ("54", "JOR");
INSERT INTO "city" VALUES ("55", "QAT");
INSERT INTO "city" VALUES ("56", "BHR");
INSERT INTO "city" VALUES ("57", "KWT");
INSERT INTO "city" VALUES ("58", "OMN");
INSERT INTO "city" VALUES ("59", "YEM");
INSERT INTO "city" VALUES ("60", "PSE");
INSERT INTO "city" VALUES ("61", "TWN");
INSERT INTO "city" VALUES ("62", "MNG");
INSERT INTO "city" VALUES ("63", "HKG");
INSERT INTO "city" VALUES ("64", "MAC");
INSERT INTO "countrylanguage" VALUES ("AFG", "Dari");
INSERT INTO "countrylanguage" VALUES ("AFG", "Pashto");
INSERT INTO "countrylanguage" VALUES ("NLD", "Dutch");
INSERT INTO "countrylanguage" VALUES ("USA", "English");
INSERT INTO "countrylanguage" VALUES ("CHN", "Chinese");
INSERT INTO "countrylanguage" VALUES ("IND", "Hindi");
INSERT INTO "countrylanguage" VALUES ("IND", "English");
INSERT INTO "countrylanguage" VALUES ("JPN", "Japanese");
INSERT INTO "countrylanguage" VALUES ("BRA", "Portuguese");
INSERT INTO "countrylanguage" VALUES ("CAN", "English");
INSERT INTO "countrylanguage" VALUES ("CAN", "French");
INSERT INTO "countrylanguage" VALUES ("AUS", "English");
INSERT INTO "countrylanguage" VALUES ("DEU", "German");
INSERT INTO "countrylanguage" VALUES ("FRA", "French");
INSERT INTO "countrylanguage" VALUES ("GBR", "English");
INSERT INTO "countrylanguage" VALUES ("RUS", "Russian");
INSERT INTO "countrylanguage" VALUES ("EGY", "Arabic");
INSERT INTO "countrylanguage" VALUES ("ZAF", "Afrikaans");
INSERT INTO "countrylanguage" VALUES ("ZAF", "English");
INSERT INTO "countrylanguage" VALUES ("MEX", "Spanish");
INSERT INTO "countrylanguage" VALUES ("ARG", "Spanish");
INSERT INTO "countrylanguage" VALUES ("KOR", "Korean");
INSERT INTO "countrylanguage" VALUES ("IDN", "Indonesian");
INSERT INTO "countrylanguage" VALUES ("PAK", "Urdu");
INSERT INTO "countrylanguage" VALUES ("PAK", "English");
INSERT INTO "countrylanguage" VALUES ("SAU", "Arabic");
INSERT INTO "countrylanguage" VALUES ("TUR", "Turkish");
INSERT INTO "countrylanguage" VALUES ("VNM", "Vietnamese");
INSERT INTO "countrylanguage" VALUES ("THA", "Thai");
INSERT INTO "countrylanguage" VALUES ("MYS", "Malay");
INSERT INTO "countrylanguage" VALUES ("MYS", "English");
INSERT INTO "countrylanguage" VALUES ("PHL", "Filipino");
INSERT INTO "countrylanguage" VALUES ("PHL", "English");
INSERT INTO "countrylanguage" VALUES ("IRN", "Persian");
INSERT INTO "countrylanguage" VALUES ("IRQ", "Arabic");
INSERT INTO "countrylanguage" VALUES ("IRQ", "Kurdish");
INSERT INTO "countrylanguage" VALUES ("ISR", "Hebrew");
INSERT INTO "countrylanguage" VALUES ("ISR", "Arabic");
INSERT INTO "countrylanguage" VALUES ("ARE", "Arabic");
INSERT INTO "countrylanguage" VALUES ("SGP", "Malay");
INSERT INTO "countrylanguage" VALUES ("SGP", "English");
INSERT INTO "countrylanguage" VALUES ("SGP", "Mandarin Chinese");
INSERT INTO "countrylanguage" VALUES ("SGP", "Tamil");
INSERT INTO "countrylanguage" VALUES ("PRK", "Korean");
INSERT INTO "countrylanguage" VALUES ("BGD", "Bengali");
INSERT INTO "countrylanguage" VALUES ("NPL", "Nepali");
INSERT INTO "countrylanguage" VALUES ("LKA", "Sinhala");
INSERT INTO "countrylanguage" VALUES ("LKA", "Tamil");
INSERT INTO "countrylanguage" VALUES ("MMR", "Burmese");
INSERT INTO "countrylanguage" VALUES ("KHM", "Khmer");
INSERT INTO "countrylanguage" VALUES ("LAO", "Lao");
INSERT INTO "countrylanguage" VALUES ("BRN", "Malay");
INSERT INTO "countrylanguage" VALUES ("TLS", "Tetum");
INSERT INTO "countrylanguage" VALUES ("TLS", "Portuguese");
INSERT INTO "countrylanguage" VALUES ("BTN", "Dzongkha");
INSERT INTO "countrylanguage" VALUES ("MDV", "Dhivehi");
INSERT INTO "countrylanguage" VALUES ("KGZ", "Kyrgyz");
INSERT INTO "countrylanguage" VALUES ("KGZ", "Russian");
INSERT INTO "countrylanguage" VALUES ("TJK", "Tajik");
INSERT INTO "countrylanguage" VALUES ("TKM", "Turkmen");
INSERT INTO "countrylanguage" VALUES ("UZB", "Uzbek");
INSERT INTO "countrylanguage" VALUES ("KAZ", "Kazakh");
INSERT INTO "countrylanguage" VALUES ("KAZ", "Russian");
INSERT INTO "countrylanguage" VALUES ("GEO", "Georgian");
INSERT INTO "countrylanguage" VALUES ("ARM", "Armenian");
INSERT INTO "countrylanguage" VALUES ("AZE", "Azerbaijani");
INSERT INTO "countrylanguage" VALUES ("CYP", "Greek");
INSERT INTO "countrylanguage" VALUES ("CYP", "Turkish");
INSERT INTO "countrylanguage" VALUES ("SYR", "Arabic");
INSERT INTO "countrylanguage" VALUES ("LBN", "Arabic");
INSERT INTO "countrylanguage" VALUES ("JOR", "Arabic");
INSERT INTO "countrylanguage" VALUES ("QAT", "Arabic");
INSERT INTO "countrylanguage" VALUES ("BHR", "Arabic");
INSERT INTO "countrylanguage" VALUES ("KWT", "Arabic");
INSERT INTO "countrylanguage" VALUES ("OMN", "Arabic");
INSERT INTO "countrylanguage" VALUES ("YEM", "Arabic");
INSERT INTO "countrylanguage" VALUES ("PSE", "Arabic");
INSERT INTO "countrylanguage" VALUES ("TWN", "Chinese");
INSERT INTO "countrylanguage" VALUES ("MNG", "Mongolian");
INSERT INTO "countrylanguage" VALUES ("HKG", "Chinese");
INSERT INTO "countrylanguage" VALUES ("HKG", "English");
INSERT INTO "countrylanguage" VALUES ("MAC", "Chinese");
INSERT INTO "countrylanguage" VALUES ("MAC", "Portuguese");