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),
"Population" INT,
PRIMARY KEY ("ID")
);

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

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





INSERT INTO "city" VALUES ("1", "Kabul", "1780000");
INSERT INTO "city" VALUES ("2", "Qandahar", "237500");
INSERT INTO "city" VALUES ("3", "Herat", "186800");
INSERT INTO "city" VALUES ("4", "Mazar-e-Sharif", "237600");
INSERT INTO "city" VALUES ("5", "Amsterdam", "731200");
INSERT INTO "city" VALUES ("6", "Rotterdam", "593321");
INSERT INTO "city" VALUES ("7", "Haag", "440900");
INSERT INTO "city" VALUES ("8", "Utrecht", "234323");
INSERT INTO "city" VALUES ("9", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("10", "Tilburg", "193238");
INSERT INTO "city" VALUES ("11", "Groningen", "172711");
INSERT INTO "city" VALUES ("12", "Breda", "167673");
INSERT INTO "city" VALUES ("13", "Apeldoorn", "153491");
INSERT INTO "city" VALUES ("14", "Nijmegen", "152463");
INSERT INTO "city" VALUES ("15", "Enschede", "149544");
INSERT INTO "city" VALUES ("16", "Haarlem", "148764");
INSERT INTO "city" VALUES ("17", "Almere", "142465");
INSERT INTO "city" VALUES ("18", "Arnhem", "138020");
INSERT INTO "city" VALUES ("19", "Zaanstad", "135621");
INSERT INTO "city" VALUES ("20", "´s-Hertogenbosch", "129170");
INSERT INTO "city" VALUES ("21", "Amersfoort", "126270");
INSERT INTO "city" VALUES ("22", "Maastricht", "122087");
INSERT INTO "city" VALUES ("23", "Dordrecht", "119812");
INSERT INTO "city" VALUES ("24", "Leiden", "117196");
INSERT INTO "city" VALUES ("25", "Zoetermeer", "110915");
INSERT INTO "city" VALUES ("26", "Emmen", "105972");
INSERT INTO "city" VALUES ("27", "Zwolle", "105819");
INSERT INTO "city" VALUES ("28", "Ede", "101574");
INSERT INTO "city" VALUES ("29", "Delft", "96095");
INSERT INTO "city" VALUES ("30", "Heerlen", "95052");
INSERT INTO "city" VALUES ("31", "Alkmaar", "92713");
INSERT INTO "city" VALUES ("32", "Leeuwarden", "91818");
INSERT INTO "city" VALUES ("33", "Venlo", "89721");
INSERT INTO "city" VALUES ("34", "Hilversum", "83737");
INSERT INTO "city" VALUES ("35", "Hengelo", "75640");
INSERT INTO "city" VALUES ("36", "Purmerend", "73737");
INSERT INTO "city" VALUES ("37", "Schiedam", "73454");
INSERT INTO "city" VALUES ("38", "Assen", "49232");
INSERT INTO "city" VALUES ("39", "Barneveld", "27500");
INSERT INTO "city" VALUES ("40", "Vlissingen", "44000");
INSERT INTO "city" VALUES ("41", "Woerden", "34000");
INSERT INTO "city" VALUES ("42", "Zutphen", "25000");
INSERT INTO "city" VALUES ("43", "Curaçao", "149000");
INSERT INTO "city" VALUES ("44", "Oranjestad", "29000");
INSERT INTO "city" VALUES ("45", "Tirana", "270000");
INSERT INTO "city" VALUES ("46", "Alger", "2168000");
INSERT INTO "city" VALUES ("47", "Annaba", "222500");
INSERT INTO "city" VALUES ("48", "Constantine", "443727");
INSERT INTO "city" VALUES ("49", "Batna", "183000");
INSERT INTO "city" VALUES ("50", "Sétif", "179000");
INSERT INTO "city" VALUES ("51", "Sidi Bel Abbès", "153000");
INSERT INTO "city" VALUES ("52", "Skikda", "142000");
INSERT INTO "city" VALUES ("53", "Biskra", "128000");
INSERT INTO "city" VALUES ("54", "Blida", "127000");
INSERT INTO "city" VALUES ("55", "Béjaïa", "144000");
INSERT INTO "city" VALUES ("56", "Mostaganem", "115400");
INSERT INTO "city" VALUES ("57", "Tébessa", "112000");
INSERT INTO "city" VALUES ("58", "Tlemcen", "110000");
INSERT INTO "city" VALUES ("59", "Bechar", "100000");
INSERT INTO "city" VALUES ("60", "Porto-Novo", "179000");
INSERT INTO "city" VALUES ("61", "Cotonou", "536827");
INSERT INTO "city" VALUES ("62", "Ouagadougou", "1000000");
INSERT INTO "city" VALUES ("63", "Bobo-Dioulasso", "300000");
INSERT INTO "city" VALUES ("64", "Bujumbura", "300000");
INSERT INTO "city" VALUES ("65", "Yaoundé", "1430000");
INSERT INTO "city" VALUES ("66", "Douala", "1200000");
INSERT INTO "city" VALUES ("67", "Praia", "94757");
INSERT INTO "city" VALUES ("68", "Bangui", "524000");
INSERT INTO "city" VALUES ("69", "Brazzaville", "1000000");
INSERT INTO "city" VALUES ("70", "Pointe-Noire", "450000");
INSERT INTO "city" VALUES ("71", "Abidjan", "2500000");
INSERT INTO "city" VALUES ("72", "Yamoussoukro", "150000");
INSERT INTO "city" VALUES ("73", "N´Djamena", "750000");
INSERT INTO "city" VALUES ("74", "Moroni", "30000");
INSERT INTO "city" VALUES ("75", "Kinshasa", "5000000");
INSERT INTO "city" VALUES ("76", "Lubumbashi", "850000");
INSERT INTO "city" VALUES ("77", "Mbuji-Mayi", "800000");
INSERT INTO "city" VALUES ("78", "Kisangani", "500000");
INSERT INTO "city" VALUES ("79", "Kananga", "400000");
INSERT INTO "city" VALUES ("80", "Antananarivo", "1400000");
INSERT INTO "city" VALUES ("81", "Toamasina", "127000");
INSERT INTO "city" VALUES ("82", "Lilongwe", "435964");
INSERT INTO "city" VALUES ("83", "Blantyre", "478155");
INSERT INTO "city" VALUES ("84", "Bamako", "800000");
INSERT INTO "city" VALUES ("85", "Timbuktu", "32000");
INSERT INTO "city" VALUES ("86", "Nouakchott", "550000");
INSERT INTO "city" VALUES ("87", "Port Louis", "147688");
INSERT INTO "city" VALUES ("88", "Maputo", "989600");
INSERT INTO "city" VALUES ("89", "Beira", "397368");
INSERT INTO "city" VALUES ("90", "Nampula", "300000");
INSERT INTO "city" VALUES ("91", "Windhoek", "195000");
INSERT INTO "city" VALUES ("92", "Niamey", "420000");
INSERT INTO "city" VALUES ("93", "Abuja", "300000");
INSERT INTO "city" VALUES ("94", "Lagos", "10000000");
INSERT INTO "city" VALUES ("95", "Ibadan", "3000000");
INSERT INTO "city" VALUES ("96", "Ogbomosho", "724000");
INSERT INTO "city" VALUES ("97", "Kano", "674137");
INSERT INTO "city" VALUES ("98", "Oshogbo", "422000");
INSERT INTO "city" VALUES ("99", "Benin City", "410000");
INSERT INTO "city" VALUES ("100", "Port Harcourt", "400000");
INSERT INTO "city" VALUES ("101", "Kaduna", "300000");
INSERT INTO "city" VALUES ("102", "Enugu", "300000");
INSERT INTO "city" VALUES ("103", "Abeokuta", "250000");
INSERT INTO "city" VALUES ("104", "Zaria", "200000");
INSERT INTO "city" VALUES ("105", "Sokoto", "160000");
INSERT INTO "city" VALUES ("106", "Garoua", "150000");
INSERT INTO "city" VALUES ("107", "Maiduguri", "150000");
INSERT INTO "city" VALUES ("108", "Douala", "1200000");
INSERT INTO "city" VALUES ("109", "Kigali", "235000");
INSERT INTO "city" VALUES ("110", "Dakar", "1780000");
INSERT INTO "city" VALUES ("111", "Freetown", "1000000");
INSERT INTO "city" VALUES ("112", "Mogadishu", "1000000");
INSERT INTO "city" VALUES ("113", "Pretoria", "1100000");
INSERT INTO "city" VALUES ("114", "Cape Town", "2500000");
INSERT INTO "city" VALUES ("115", "Durban", "2000000");
INSERT INTO "city" VALUES ("116", "Johannesburg", "1500000");
INSERT INTO "city" VALUES ("117", "Port Elizabeth", "1000000");
INSERT INTO "city" VALUES ("118", "Bloemfontein", "500000");
INSERT INTO "city" VALUES ("119", "East London", "400000");
INSERT INTO "city" VALUES ("120", "Soweto", "1000000");
INSERT INTO "city" VALUES ("121", "Khartoum", "1500000");
INSERT INTO "city" VALUES ("122", "Omdurman", "1200000");
INSERT INTO "city" VALUES ("123", "Port Sudan", "300000");
INSERT INTO "city" VALUES ("124", "Mbabane", "70000");
INSERT INTO "city" VALUES ("125", "Dar es Salaam", "2500000");
INSERT INTO "city" VALUES ("126", "Dodoma", "150000");
INSERT INTO "city" VALUES ("127", "Tunis", "900000");
INSERT INTO "city" VALUES ("128", "Kampala", "1200000");
INSERT INTO "city" VALUES ("129", "Lusaka", "1600000");
INSERT INTO "city" VALUES ("130", "Harare", "1600000");
INSERT INTO "city" VALUES ("131", "Luanda", "2000000");
INSERT INTO "city" VALUES ("132", "Gaborone", "180000");
INSERT INTO "city" VALUES ("133", "Maseru", "150000");
INSERT INTO "city" VALUES ("134", "Monrovia", "1000000");
INSERT INTO "city" VALUES ("135", "Tripoli", "1500000");
INSERT INTO "city" VALUES ("136", "Benghazi", "800000");
INSERT INTO "city" VALUES ("137", "Rabat", "1200000");
INSERT INTO "city" VALUES ("138", "Casablanca", "3000000");
INSERT INTO "city" VALUES ("139", "Marrakech", "900000");
INSERT INTO "city" VALUES ("140", "Fès", "800000");
INSERT INTO "city" VALUES ("141", "Meknès", "700000");
INSERT INTO "city" VALUES ("142", "Agadir", "600000");
INSERT INTO "city" VALUES ("143", "Tangier", "500000");
INSERT INTO "city" VALUES ("144", "Dakhla", "50000");
INSERT INTO "city" VALUES ("145", "El Aaiún", "100000");
INSERT INTO "city" VALUES ("146", "Cairo", "9000000");
INSERT INTO "city" VALUES ("147", "Alexandria", "4000000");
INSERT INTO "city" VALUES ("148", "Giza", "3000000");
INSERT INTO "city" VALUES ("149", "Shubra El-Kheima", "1000000");
INSERT INTO "city" VALUES ("150", "Port Said", "500000");
INSERT INTO "city" VALUES ("151", "Suez", "400000");
INSERT INTO "city" VALUES ("152", "Luxor", "300000");
INSERT INTO "city" VALUES ("153", "Asyut", "200000");
INSERT INTO "city" VALUES ("154", "Faiyum", "150000");
INSERT INTO "city" VALUES ("155", "Ismailia", "100000");
INSERT INTO "city" VALUES ("156", "Aswan", "100000");
INSERT INTO "city" VALUES ("157", "Damietta", "100000");
INSERT INTO "city" VALUES ("158", "Sohag", "100000");
INSERT INTO "city" VALUES ("159", "Minya", "100000");
INSERT INTO "city" VALUES ("160", "Beni Suef", "100000");
INSERT INTO "city" VALUES ("161", "Zagazig", "100000");
INSERT INTO "city" VALUES ("162", "Damanhur", "100000");
INSERT INTO "city" VALUES ("163", "Qena", "100000");
INSERT INTO "city" VALUES ("164", "Suez", "400000");
INSERT INTO "city" VALUES ("165", "Addis Ababa", "3000000");
INSERT INTO "city" VALUES ("166", "Asmara", "400000");
INSERT INTO "city" VALUES ("167", "Djibouti", "500000");
INSERT INTO "city" VALUES ("168", "Accra", "2000000");
INSERT INTO "city" VALUES ("169", "Kumasi", "1500000");
INSERT INTO "city" VALUES ("170", "Conakry", "1500000");
INSERT INTO "city" VALUES ("171", "Bissau", "400000");
INSERT INTO "city" VALUES ("172", "Nairobi", "3000000");
INSERT INTO "city" VALUES ("173", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("174", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("175", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("176", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("177", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("178", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("179", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("180", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("181", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("182", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("183", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("184", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("185", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("186", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("187", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("188", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("189", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("190", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("191", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("192", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("193", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("194", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("195", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("196", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("197", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("198", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("199", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("200", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("201", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("202", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("203", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("204", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("205", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("206", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("207", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("208", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("209", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("210", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("211", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("212", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("213", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("214", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("215", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("216", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("217", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("218", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("219", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("220", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("221", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("222", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("223", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("224", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("225", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("226", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("227", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("228", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("229", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("230", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("231", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("232", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("233", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("234", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("235", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("236", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("237", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("238", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("239", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("240", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("241", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("242", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("243", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("244", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("245", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("246", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("247", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("248", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("249", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("250", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("251", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("252", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("253", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("254", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("255", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("256", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("257", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("258", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("259", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("260", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("261", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("262", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("263", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("264", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("265", "Mombasa", "1000000");
INSERT INTO "city" VALUES ("266", "Mombasa", "1000000");