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,
"Name" CHAR(35),
PRIMARY KEY ("ID")
);

CREATE TABLE "country" (
"Code" CHAR(3),
"Name" CHAR(52),
"Continent" TEXT,
"SurfaceArea" FLOAT,
"Population" INT,
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
PRIMARY KEY ("CountryCode", "Language")
);





INSERT INTO "city" VALUES ("1", "Kabul");
INSERT INTO "city" VALUES ("2", "Amsterdam");
INSERT INTO "city" VALUES ("3", "Berlin");
INSERT INTO "city" VALUES ("4", "Paris");
INSERT INTO "city" VALUES ("5", "London");
INSERT INTO "city" VALUES ("6", "Rome");
INSERT INTO "city" VALUES ("7", "Madrid");
INSERT INTO "city" VALUES ("8", "Moscow");
INSERT INTO "city" VALUES ("9", "Beijing");
INSERT INTO "city" VALUES ("10", "Tokyo");
INSERT INTO "city" VALUES ("11", "New York");
INSERT INTO "city" VALUES ("12", "Sydney");
INSERT INTO "city" VALUES ("13", "Cairo");
INSERT INTO "city" VALUES ("14", "Brasilia");
INSERT INTO "city" VALUES ("15", "Ottawa");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "652230.00", "22720000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "41526.00", "15988000");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "357022.00", "82164700");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "551500.00", "59225700");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "242900.00", "59623400");
INSERT INTO "country" VALUES ("ITA", "Italy", "Europe", "301316.00", "57680700");
INSERT INTO "country" VALUES ("ESP", "Spain", "Europe", "505992.00", "39441700");
INSERT INTO "country" VALUES ("RUS", "Russian Federation", "Europe", "17075400.00", "146934000");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "9572900.00", "1277558000");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "377829.00", "126714000");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "9631420.00", "278357000");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "7741220.00", "18886000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "1001450.00", "68470000");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "8547403.00", "170115000");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "9984670.00", "31147000");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "3287263.00", "1013662000");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "2780400.00", "37032000");
INSERT INTO "country" VALUES ("KAZ", "Kazakstan", "Asia", "2717300.00", "16223000");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "2381741.00", "31471000");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "2505813.00", "35079000");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "1958201.00", "98881000");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "1904569.00", "212107000");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "2149690.00", "21607000");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "1648195.00", "67702000");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "1566500.00", "2662000");
INSERT INTO "country" VALUES ("PER", "Peru", "South America", "1285216.00", "25232000");
INSERT INTO "country" VALUES ("COL", "Colombia", "South America", "1138914.00", "42321000");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "South America", "1098581.00", "8329000");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "1104300.00", "62565000");
INSERT INTO "country" VALUES ("ZAR", "Congo, The Democratic Republic of the", "Africa", "2344858.00", "50416000");
INSERT INTO "country" VALUES ("LBY", "Libyan Arab Jamahiriya", "Africa", "1759540.00", "5600000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "923768.00", "111506000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "1221037.00", "40377000");
INSERT INTO "country" VALUES ("MLI", "Mali", "Africa", "1240192.00", "11241000");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "Africa", "1025520.00", "2670000");
INSERT INTO "country" VALUES ("NER", "Niger", "Africa", "1267000.00", "10730000");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "1246700.00", "12878000");
INSERT INTO "country" VALUES ("TCD", "Chad", "Africa", "1284000.00", "7615000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "1001450.00", "68470000");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "637657.00", "10100000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "582646.00", "30339000");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "Africa", "945087.00", "33518000");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "752618.00", "9169000");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "801590.00", "19686000");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "824292.00", "1729000");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Africa", "622984.00", "3701000");
INSERT INTO "country" VALUES ("BWA", "Botswana", "Africa", "581730.00", "1622000");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "Africa", "587041.00", "15942000");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "390757.00", "11669000");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "475442.00", "15085000");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "446550.00", "28351000");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "163610.00", "9586000");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "2381741.00", "31471000");
INSERT INTO "country" VALUES ("LBY", "Libyan Arab Jamahiriya", "Africa", "1759540.00", "5600000");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "2505813.00", "35079000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "923768.00", "111506000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "1221037.00", "40377000");
INSERT INTO "country" VALUES ("MLI", "Mali", "Africa", "1240192.00", "11241000");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "Africa", "1025520.00", "2670000");
INSERT INTO "country" VALUES ("NER", "Niger", "Africa", "1267000.00", "10730000");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "1246700.00", "12878000");
INSERT INTO "country" VALUES ("TCD", "Chad", "Africa", "1284000.00", "7615000");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "1104300.00", "62565000");
INSERT INTO "country" VALUES ("ZAR", "Congo, The Democratic Republic of the", "Africa", "2344858.00", "50416000");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "637657.00", "10100000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "582646.00", "30339000");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "Africa", "945087.00", "33518000");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "752618.00", "9169000");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "801590.00", "19686000");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "824292.00", "1729000");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Africa", "622984.00", "3701000");
INSERT INTO "country" VALUES ("BWA", "Botswana", "Africa", "581730.00", "1622000");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "Africa", "587041.00", "15942000");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "390757.00", "11669000");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "475442.00", "15085000");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "446550.00", "28351000");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "163610.00", "9586000");
INSERT INTO "countrylanguage" VALUES ("AFG", "Dari");
INSERT INTO "countrylanguage" VALUES ("AFG", "Pashto");
INSERT INTO "countrylanguage" VALUES ("NLD", "Dutch");
INSERT INTO "countrylanguage" VALUES ("DEU", "German");
INSERT INTO "countrylanguage" VALUES ("FRA", "French");
INSERT INTO "countrylanguage" VALUES ("GBR", "English");
INSERT INTO "countrylanguage" VALUES ("ITA", "Italian");
INSERT INTO "countrylanguage" VALUES ("ESP", "Spanish");
INSERT INTO "countrylanguage" VALUES ("RUS", "Russian");
INSERT INTO "countrylanguage" VALUES ("CHN", "Chinese");
INSERT INTO "countrylanguage" VALUES ("JPN", "Japanese");
INSERT INTO "countrylanguage" VALUES ("USA", "English");
INSERT INTO "countrylanguage" VALUES ("AUS", "English");
INSERT INTO "countrylanguage" VALUES ("EGY", "Arabic");
INSERT INTO "countrylanguage" VALUES ("BRA", "Portuguese");
INSERT INTO "countrylanguage" VALUES ("CAN", "English");
INSERT INTO "countrylanguage" VALUES ("CAN", "French");
INSERT INTO "countrylanguage" VALUES ("IND", "Hindi");
INSERT INTO "countrylanguage" VALUES ("IND", "English");
INSERT INTO "countrylanguage" VALUES ("ARG", "Spanish");
INSERT INTO "countrylanguage" VALUES ("KAZ", "Kazakh");
INSERT INTO "countrylanguage" VALUES ("KAZ", "Russian");
INSERT INTO "countrylanguage" VALUES ("DZA", "Arabic");
INSERT INTO "countrylanguage" VALUES ("DZA", "Berber");
INSERT INTO "countrylanguage" VALUES ("SDN", "Arabic");
INSERT INTO "countrylanguage" VALUES ("SDN", "English");
INSERT INTO "countrylanguage" VALUES ("MEX", "Spanish");
INSERT INTO "countrylanguage" VALUES ("IDN", "Indonesian");
INSERT INTO "countrylanguage" VALUES ("SAU", "Arabic");
INSERT INTO "countrylanguage" VALUES ("IRN", "Persian");
INSERT INTO "countrylanguage" VALUES ("MNG", "Mongolian");
INSERT INTO "countrylanguage" VALUES ("PER", "Spanish");
INSERT INTO "countrylanguage" VALUES ("COL", "Spanish");
INSERT INTO "countrylanguage" VALUES ("BOL", "Spanish");
INSERT INTO "countrylanguage" VALUES ("BOL", "Aymara");
INSERT INTO "countrylanguage" VALUES ("BOL", "Quechua");
INSERT INTO "countrylanguage" VALUES ("ETH", "Amharic");
INSERT INTO "countrylanguage" VALUES ("ZAR", "French");
INSERT INTO "countrylanguage" VALUES ("LBY", "Arabic");
INSERT INTO "countrylanguage" VALUES ("NGA", "English");
INSERT INTO "countrylanguage" VALUES ("ZAF", "Afrikaans");
INSERT INTO "countrylanguage" VALUES ("ZAF", "English");
INSERT INTO "countrylanguage" VALUES ("MLI", "French");
INSERT INTO "countrylanguage" VALUES ("MRT", "Arabic");
INSERT INTO "countrylanguage" VALUES ("NER", "French");
INSERT INTO "countrylanguage" VALUES ("AGO", "Portuguese");
INSERT INTO "countrylanguage" VALUES ("TCD", "Arabic");
INSERT INTO "countrylanguage" VALUES ("TCD", "French");
INSERT INTO "countrylanguage" VALUES ("SOM", "Somali");
INSERT INTO "countrylanguage" VALUES ("SOM", "Arabic");
INSERT INTO "countrylanguage" VALUES ("KEN", "Swahili");
INSERT INTO "countrylanguage" VALUES ("KEN", "English");
INSERT INTO "countrylanguage" VALUES ("TZA", "Swahili");
INSERT INTO "countrylanguage" VALUES ("TZA", "English");
INSERT INTO "countrylanguage" VALUES ("ZMB", "English");
INSERT INTO "countrylanguage" VALUES ("MOZ", "Portuguese");
INSERT INTO "countrylanguage" VALUES ("NAM", "English");
INSERT INTO "countrylanguage" VALUES ("CAF", "French");
INSERT INTO "countrylanguage" VALUES ("BWA", "English");
INSERT INTO "countrylanguage" VALUES ("MDG", "Malagasy");
INSERT INTO "countrylanguage" VALUES ("MDG", "French");
INSERT INTO "countrylanguage" VALUES ("ZWE", "English");
INSERT INTO "countrylanguage" VALUES ("CMR", "English");
INSERT INTO "countrylanguage" VALUES ("CMR", "French");
INSERT INTO "countrylanguage" VALUES ("MAR", "Arabic");
INSERT INTO "countrylanguage" VALUES ("TUN", "Arabic");