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) UNIQUE,
"Name" CHAR(52),
"Population" INT,
PRIMARY KEY ("Code")
);

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





INSERT INTO "city" VALUES ("1", "Kabul");
INSERT INTO "city" VALUES ("2", "Qandahar");
INSERT INTO "city" VALUES ("3", "Herat");
INSERT INTO "city" VALUES ("4", "Mazar-e-Sharif");
INSERT INTO "city" VALUES ("5", "Amsterdam");
INSERT INTO "city" VALUES ("6", "Rotterdam");
INSERT INTO "city" VALUES ("7", "The Hague");
INSERT INTO "city" VALUES ("8", "Utrecht");
INSERT INTO "city" VALUES ("9", "Eindhoven");
INSERT INTO "city" VALUES ("10", "Tilburg");
INSERT INTO "city" VALUES ("11", "Groningen");
INSERT INTO "city" VALUES ("12", "Breda");
INSERT INTO "city" VALUES ("13", "Apeldoorn");
INSERT INTO "city" VALUES ("14", "Nijmegen");
INSERT INTO "city" VALUES ("15", "Enschede");
INSERT INTO "city" VALUES ("16", "Haarlem");
INSERT INTO "city" VALUES ("17", "Arnhem");
INSERT INTO "city" VALUES ("18", "Zaanstad");
INSERT INTO "city" VALUES ("19", "Amersfoort");
INSERT INTO "city" VALUES ("20", "Haarlemmermeer");
INSERT INTO "city" VALUES ("21", "'s-Hertogenbosch");
INSERT INTO "city" VALUES ("22", "Dordrecht");
INSERT INTO "city" VALUES ("23", "Leiden");
INSERT INTO "city" VALUES ("24", "Maastricht");
INSERT INTO "city" VALUES ("25", "Zwolle");
INSERT INTO "city" VALUES ("26", "Almere");
INSERT INTO "city" VALUES ("27", "Zoetermeer");
INSERT INTO "city" VALUES ("28", "Emmen");
INSERT INTO "city" VALUES ("29", "Delft");
INSERT INTO "city" VALUES ("30", "Heerlen");
INSERT INTO "city" VALUES ("31", "Alkmaar");
INSERT INTO "city" VALUES ("32", "Leeuwarden");
INSERT INTO "city" VALUES ("33", "Venlo");
INSERT INTO "city" VALUES ("34", "Hilversum");
INSERT INTO "city" VALUES ("35", "Amstelveen");
INSERT INTO "city" VALUES ("36", "Roosendaal");
INSERT INTO "city" VALUES ("37", "Purmerend");
INSERT INTO "city" VALUES ("38", "Gouda");
INSERT INTO "city" VALUES ("39", "Vlaardingen");
INSERT INTO "city" VALUES ("40", "Middelburg");
INSERT INTO "city" VALUES ("41", "Den Helder");
INSERT INTO "city" VALUES ("42", "Doetinchem");
INSERT INTO "city" VALUES ("43", "Hoogeveen");
INSERT INTO "city" VALUES ("44", "Lelystad");
INSERT INTO "city" VALUES ("45", "Alphen aan den Rijn");
INSERT INTO "city" VALUES ("46", "Velsen");
INSERT INTO "city" VALUES ("47", "Bergen op Zoom");
INSERT INTO "city" VALUES ("48", "Assen");
INSERT INTO "city" VALUES ("49", "Drachten");
INSERT INTO "city" VALUES ("50", "Capelle aan den IJssel");
INSERT INTO "city" VALUES ("51", "Katwijk");
INSERT INTO "city" VALUES ("52", "Zeist");
INSERT INTO "city" VALUES ("53", "Nieuwegein");
INSERT INTO "city" VALUES ("54", "Hoorn");
INSERT INTO "city" VALUES ("55", "Heerhugowaard");
INSERT INTO "city" VALUES ("56", "Ede");
INSERT INTO "city" VALUES ("57", "Uden");
INSERT INTO "city" VALUES ("58", "Kampen");
INSERT INTO "city" VALUES ("59", "Woerden");
INSERT INTO "city" VALUES ("60", "Weert");
INSERT INTO "city" VALUES ("61", "Konya");
INSERT INTO "city" VALUES ("62", "Bursa");
INSERT INTO "city" VALUES ("63", "Adana");
INSERT INTO "city" VALUES ("64", "Gaziantep");
INSERT INTO "city" VALUES ("65", "Ankara");
INSERT INTO "city" VALUES ("66", "Istanbul");
INSERT INTO "city" VALUES ("67", "Izmir");
INSERT INTO "city" VALUES ("68", "Antalya");
INSERT INTO "city" VALUES ("69", "Diyarbakir");
INSERT INTO "city" VALUES ("70", "Mersin");
INSERT INTO "city" VALUES ("71", "Kayseri");
INSERT INTO "city" VALUES ("72", "Eskisehir");
INSERT INTO "city" VALUES ("73", "Samsun");
INSERT INTO "city" VALUES ("74", "Denizli");
INSERT INTO "city" VALUES ("75", "Malatya");
INSERT INTO "city" VALUES ("76", "Kahramanmaras");
INSERT INTO "city" VALUES ("77", "Erzurum");
INSERT INTO "city" VALUES ("78", "Van");
INSERT INTO "city" VALUES ("79", "Sivas");
INSERT INTO "city" VALUES ("80", "Trabzon");
INSERT INTO "city" VALUES ("81", "Manisa");
INSERT INTO "city" VALUES ("82", "Balikesir");
INSERT INTO "city" VALUES ("83", "Adiyaman");
INSERT INTO "city" VALUES ("84", "Kütahya");
INSERT INTO "city" VALUES ("85", "Usak");
INSERT INTO "city" VALUES ("86", "Agri");
INSERT INTO "city" VALUES ("87", "Corum");
INSERT INTO "city" VALUES ("88", "Elazig");
INSERT INTO "city" VALUES ("89", "Hatay");
INSERT INTO "city" VALUES ("90", "Isparta");
INSERT INTO "city" VALUES ("91", "Kars");
INSERT INTO "city" VALUES ("92", "Kocaeli");
INSERT INTO "city" VALUES ("93", "Mardin");
INSERT INTO "city" VALUES ("94", "Mugla");
INSERT INTO "city" VALUES ("95", "Ordu");
INSERT INTO "city" VALUES ("96", "Sakarya");
INSERT INTO "city" VALUES ("97", "Sanliurfa");
INSERT INTO "city" VALUES ("98", "Tekirdag");
INSERT INTO "city" VALUES ("99", "Tokat");
INSERT INTO "city" VALUES ("100", "Zonguldak");
INSERT INTO "city" VALUES ("101", "Aydin");
INSERT INTO "city" VALUES ("102", "Bolu");
INSERT INTO "city" VALUES ("103", "Canakkale");
INSERT INTO "city" VALUES ("104", "Edirne");
INSERT INTO "city" VALUES ("105", "Giresun");
INSERT INTO "city" VALUES ("106", "Kirikkale");
INSERT INTO "city" VALUES ("107", "Kirklareli");
INSERT INTO "city" VALUES ("108", "Nevsehir");
INSERT INTO "city" VALUES ("109", "Nigde");
INSERT INTO "city" VALUES ("110", "Rize");
INSERT INTO "city" VALUES ("111", "Siirt");
INSERT INTO "city" VALUES ("112", "Sinop");
INSERT INTO "city" VALUES ("113", "Yozgat");
INSERT INTO "city" VALUES ("114", "Afyonkarahisar");
INSERT INTO "city" VALUES ("115", "Aksaray");
INSERT INTO "city" VALUES ("116", "Amasya");
INSERT INTO "city" VALUES ("117", "Artvin");
INSERT INTO "city" VALUES ("118", "Bartin");
INSERT INTO "city" VALUES ("119", "Bayburt");
INSERT INTO "city" VALUES ("120", "Bilecik");
INSERT INTO "city" VALUES ("121", "Bingöl");
INSERT INTO "city" VALUES ("122", "Bitlis");
INSERT INTO "city" VALUES ("123", "Burdur");
INSERT INTO "city" VALUES ("124", "Cankiri");
INSERT INTO "city" VALUES ("125", "Duzce");
INSERT INTO "city" VALUES ("126", "Erzincan");
INSERT INTO "city" VALUES ("127", "Gümüshane");
INSERT INTO "city" VALUES ("128", "Hakkari");
INSERT INTO "city" VALUES ("129", "Igdir");
INSERT INTO "city" VALUES ("130", "Karabük");
INSERT INTO "city" VALUES ("131", "Karaman");
INSERT INTO "city" VALUES ("132", "Kilis");
INSERT INTO "city" VALUES ("133", "Kirklareli");
INSERT INTO "city" VALUES ("134", "Kirsehir");
INSERT INTO "city" VALUES ("135", "Kütahya");
INSERT INTO "city" VALUES ("136", "Mardin");
INSERT INTO "city" VALUES ("137", "Mugla");
INSERT INTO "city" VALUES ("138", "Mus");
INSERT INTO "city" VALUES ("139", "Nevsehir");
INSERT INTO "city" VALUES ("140", "Nigde");
INSERT INTO "city" VALUES ("141", "Osmaniye");
INSERT INTO "city" VALUES ("142", "Rize");
INSERT INTO "city" VALUES ("143", "Siirt");
INSERT INTO "city" VALUES ("144", "Sinop");
INSERT INTO "city" VALUES ("145", "Sirnak");
INSERT INTO "city" VALUES ("146", "Tunceli");
INSERT INTO "city" VALUES ("147", "Usak");
INSERT INTO "city" VALUES ("148", "Yalova");
INSERT INTO "city" VALUES ("149", "Yozgat");
INSERT INTO "city" VALUES ("150", "Zonguldak");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "22720000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "15864000");
INSERT INTO "country" VALUES ("TUR", "Turkey", "66591000");
INSERT INTO "country" VALUES ("USA", "United States", "278357000");
INSERT INTO "country" VALUES ("CAN", "Canada", "31147000");
INSERT INTO "country" VALUES ("MEX", "Mexico", "98881000");
INSERT INTO "country" VALUES ("BRA", "Brazil", "170115000");
INSERT INTO "country" VALUES ("ARG", "Argentina", "37032000");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "59623000");
INSERT INTO "country" VALUES ("FRA", "France", "59225000");
INSERT INTO "country" VALUES ("DEU", "Germany", "82164000");
INSERT INTO "country" VALUES ("ITA", "Italy", "57680000");
INSERT INTO "country" VALUES ("ESP", "Spain", "39441700");
INSERT INTO "country" VALUES ("CHN", "China", "1277558000");
INSERT INTO "country" VALUES ("IND", "India", "1013662000");
INSERT INTO "country" VALUES ("JPN", "Japan", "126714000");
INSERT INTO "country" VALUES ("AUS", "Australia", "18886000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "68470000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "40377000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "111506000");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "62565000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "30080000");
INSERT INTO "country" VALUES ("DZA", "Algeria", "31471000");
INSERT INTO "country" VALUES ("MAR", "Morocco", "28351000");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "21607000");
INSERT INTO "country" VALUES ("IRN", "Iran", "67191000");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "156487000");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "129155000");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "212107000");
INSERT INTO "country" VALUES ("PHL", "Philippines", "76985000");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "79832000");
INSERT INTO "country" VALUES ("THA", "Thailand", "61399000");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "22244000");
INSERT INTO "country" VALUES ("SGP", "Singapore", "3567000");
INSERT INTO "country" VALUES ("KOR", "South Korea", "46844000");
INSERT INTO "country" VALUES ("PRK", "North Korea", "23370000");
INSERT INTO "country" VALUES ("RUS", "Russian Federation", "146934000");
INSERT INTO "country" VALUES ("UKR", "Ukraine", "50456000");
INSERT INTO "country" VALUES ("POL", "Poland", "38633000");
INSERT INTO "country" VALUES ("ROU", "Romania", "22455000");
INSERT INTO "country" VALUES ("HUN", "Hungary", "10043000");
INSERT INTO "country" VALUES ("CZE", "Czech Republic", "10278000");
INSERT INTO "country" VALUES ("SVK", "Slovakia", "5398700");
INSERT INTO "country" VALUES ("AUT", "Austria", "8091000");
INSERT INTO "country" VALUES ("CHE", "Switzerland", "7160000");
INSERT INTO "country" VALUES ("BEL", "Belgium", "10239000");
INSERT INTO "country" VALUES ("SWE", "Sweden", "8861000");
INSERT INTO "country" VALUES ("NOR", "Norway", "4478000");
INSERT INTO "country" VALUES ("DNK", "Denmark", "5330000");
INSERT INTO "country" VALUES ("FIN", "Finland", "5171000");
INSERT INTO "country" VALUES ("IRL", "Ireland", "3787000");
INSERT INTO "country" VALUES ("GRC", "Greece", "10545000");
INSERT INTO "country" VALUES ("PRT", "Portugal", "9997000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "111506000");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "11669000");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "9169000");
INSERT INTO "country" VALUES ("UGA", "Uganda", "21778000");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "33679000");
INSERT INTO "country" VALUES ("SDN", "Sudan", "35079000");
INSERT INTO "country" VALUES ("SOM", "Somalia", "10100000");
INSERT INTO "country" VALUES ("SEN", "Senegal", "9481000");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "7733000");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "19686000");
INSERT INTO "country" VALUES ("MLI", "Mali", "11241000");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "15942000");
INSERT INTO "country" VALUES ("LBY", "Libya", "5670000");
INSERT INTO "country" VALUES ("LBR", "Liberia", "3154000");
INSERT INTO "country" VALUES ("COD", "DR Congo", "50400000");
INSERT INTO "country" VALUES ("CIV", "Ivory Coast", "16179000");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "15085000");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "11937000");
INSERT INTO "country" VALUES ("BEN", "Benin", "6097000");
INSERT INTO "country" VALUES ("AGO", "Angola", "12878000");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "22720000");
INSERT INTO "country" VALUES ("ALB", "Albania", "3401200");
INSERT INTO "country" VALUES ("AND", "Andorra", "78000");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "2441000");
INSERT INTO "country" VALUES ("ARM", "Armenia", "3520000");
INSERT INTO "country" VALUES ("ATG", "Antigua and Barbuda", "68000");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "7734000");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "307000");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "617000");
INSERT INTO "country" VALUES ("BLR", "Belarus", "10236000");
INSERT INTO "country" VALUES ("BLZ", "Belize", "241000");
INSERT INTO "country" VALUES ("BMU", "Bermuda", "65000");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "8329000");
INSERT INTO "country" VALUES ("BIH", "Bosnia and Herzegovina", "3972000");
INSERT INTO "country" VALUES ("BWA", "Botswana", "1622000");
INSERT INTO "country" VALUES ("BRN", "Brunei", "336000");
INSERT INTO "country" VALUES ("BGR", "Bulgaria", "8190900");
INSERT INTO "country" VALUES ("BDI", "Burundi", "6695000");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "11168000");
INSERT INTO "country" VALUES ("CPV", "Cape Verde", "435000");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "3701000");
INSERT INTO "country" VALUES ("TCD", "Chad", "7615000");
INSERT INTO "country" VALUES ("CHL", "Chile", "15211000");
INSERT INTO "country" VALUES ("COL", "Colombia", "42321000");
INSERT INTO "country" VALUES ("COM", "Comoros", "578000");
INSERT INTO "country" VALUES ("COG", "Congo", "2943000");
INSERT INTO "country" VALUES ("CRI", "Costa Rica", "4023000");
INSERT INTO "country" VALUES ("HRV", "Croatia", "4478000");
INSERT INTO "country" VALUES ("CUB", "Cuba", "11187000");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "759000");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "691000");
INSERT INTO "country" VALUES ("DMA", "Dominica", "71000");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "8495000");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "12646000");
INSERT INTO "country" VALUES ("SLV", "El Salvador", "6218000");
INSERT INTO "country" VALUES ("GNQ", "Equatorial Guinea", "453000");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "3850000");
INSERT INTO "country" VALUES ("EST", "Estonia", "1439200");
INSERT INTO "country" VALUES ("FJI", "Fiji", "817000");
INSERT INTO "country" VALUES ("GAB", "Gabon", "1226000");
INSERT INTO "country" VALUES ("GMB", "Gambia", "1305000");
INSERT INTO "country" VALUES ("GEO", "Georgia", "5404000");
INSERT INTO "country" VALUES ("GHA", "Ghana", "18888000");
INSERT INTO "country" VALUES ("GRD", "Grenada", "94000");
INSERT INTO "country" VALUES ("GTM", "Guatemala", "11385000");
INSERT INTO "country" VALUES ("GIN", "Guinea", "7405000");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "1213000");
INSERT INTO "country" VALUES ("GUY", "Guyana", "765000");
INSERT INTO "country" VALUES ("HTI", "Haiti", "8222000");
INSERT INTO "country" VALUES ("HND", "Honduras", "6485000");
INSERT INTO "country" VALUES ("ISL", "Iceland", "279000");
INSERT INTO "country" VALUES ("ISR", "Israel", "6217000");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "2583000");
INSERT INTO "country" VALUES ("JOR", "Jordan", "4787000");
INSERT INTO "country" VALUES ("KAZ", "Kazakstan", "16223000");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "83000");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "1972000");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "4699000");
INSERT INTO "country" VALUES ("LAO", "Laos", "5433000");
INSERT INTO "country" VALUES ("LVA", "Latvia", "2424000");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "3286000");
INSERT INTO "country" VALUES ("LSO", "Lesotho", "2153000");
INSERT INTO "country" VALUES ("LTU", "Lithuania", "3698000");
INSERT INTO "country" VALUES ("LUX", "Luxembourg", "435000");
INSERT INTO "country" VALUES ("MKD", "Macedonia", "2024000");
INSERT INTO "country" VALUES ("MWI", "Malawi", "10470000");
INSERT INTO "country" VALUES ("MDV", "Maldives", "286000");
INSERT INTO "country" VALUES ("MLT", "Malta", "397000");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "2670000");
INSERT INTO "country" VALUES ("MUS", "Mauritius", "1158000");
INSERT INTO "country" VALUES ("MDA", "Moldova", "4376000");
INSERT INTO "country" VALUES ("MCO", "Monaco", "34000");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "2654000");
INSERT INTO "country" VALUES ("MSR", "Montserrat", "11000");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "45611000");
INSERT INTO "country" VALUES ("NAM", "Namibia", "1726000");
INSERT INTO "country" VALUES ("NRU", "Nauru", "10000");
INSERT INTO "country" VALUES ("NPL", "Nepal", "23949000");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "3862000");
INSERT INTO "country" VALUES ("NIC", "Nicaragua", "5074000");
INSERT INTO "country" VALUES ("NER", "Niger", "10146000");
INSERT INTO "country" VALUES ("OMN", "Oman", "2542000");
INSERT INTO "country" VALUES ("PAN", "Panama", "2856000");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "4807000");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "5496000");
INSERT INTO "country" VALUES ("PER", "Peru", "25662000");
INSERT INTO "country" VALUES ("PLW", "Palau", "19000");
INSERT INTO "country" VALUES ("QAT", "Qatar", "599000");
INSERT INTO "country" VALUES ("WSM", "Samoa", "180000");
INSERT INTO "country" VALUES ("SMR", "San Marino", "27000");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "147000");
INSERT INTO "country" VALUES ("SYC", "Seychelles", "77000");
INSERT INTO "country" VALUES ("SLE", "Sierra Leone", "4516000");
INSERT INTO "country" VALUES ("SVN", "Slovenia", "1987000");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "442000");
INSERT INTO "country" VALUES ("SOM", "Somalia", "10100000");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "18827000");
INSERT INTO "country" VALUES ("KNA", "Saint Kitts and Nevis", "38000");
INSERT INTO "country" VALUES ("LCA", "Saint Lucia", "154000");