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", "Amsterdam", "741636");
INSERT INTO "city" VALUES ("2", "Rotterdam", "592673");
INSERT INTO "city" VALUES ("3", "The Hague", "440979");
INSERT INTO "city" VALUES ("4", "Utrecht", "234323");
INSERT INTO "city" VALUES ("5", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("6", "Groningen", "173139");
INSERT INTO "city" VALUES ("7", "Tilburg", "193232");
INSERT INTO "city" VALUES ("8", "Almere", "142465");
INSERT INTO "city" VALUES ("9", "Breda", "160821");
INSERT INTO "city" VALUES ("10", "Nijmegen", "152463");
INSERT INTO "city" VALUES ("11", "Apeldoorn", "153491");
INSERT INTO "city" VALUES ("12", "Enschede", "149571");
INSERT INTO "city" VALUES ("13", "Haarlem", "148781");
INSERT INTO "city" VALUES ("14", "Arnhem", "138154");
INSERT INTO "city" VALUES ("15", "Zaanstad", "135621");
INSERT INTO "city" VALUES ("16", "s-Hertogenbosch", "129170");
INSERT INTO "city" VALUES ("17", "Amersfoort", "126270");
INSERT INTO "city" VALUES ("18", "Maastricht", "120961");
INSERT INTO "city" VALUES ("19", "Dordrecht", "119821");
INSERT INTO "city" VALUES ("20", "Leiden", "117196");
INSERT INTO "city" VALUES ("21", "Zoetermeer", "110987");
INSERT INTO "city" VALUES ("22", "Zwolle", "105801");
INSERT INTO "city" VALUES ("23", "Emmen", "105775");
INSERT INTO "city" VALUES ("24", "Ede", "101574");
INSERT INTO "city" VALUES ("25", "Delft", "96095");
INSERT INTO "city" VALUES ("26", "Heerlen", "95053");
INSERT INTO "city" VALUES ("27", "Alkmaar", "92836");
INSERT INTO "city" VALUES ("28", "Leeuwarden", "91817");
INSERT INTO "city" VALUES ("29", "Venlo", "88274");
INSERT INTO "city" VALUES ("30", "Hilversum", "82177");
INSERT INTO "city" VALUES ("31", "Hengelo", "79751");
INSERT INTO "city" VALUES ("32", "Purmerend", "75161");
INSERT INTO "city" VALUES ("33", "Gouda", "71918");
INSERT INTO "city" VALUES ("34", "Schiedam", "75471");
INSERT INTO "city" VALUES ("35", "Vlaardingen", "74398");
INSERT INTO "city" VALUES ("36", "Spijkenisse", "73076");
INSERT INTO "city" VALUES ("37", "Alphen aan den Rijn", "69719");
INSERT INTO "city" VALUES ("38", "Hoogeveen", "52758");
INSERT INTO "city" VALUES ("39", "Capelle aan den IJssel", "63708");
INSERT INTO "city" VALUES ("40", "Katwijk", "61417");
INSERT INTO "city" VALUES ("41", "Zeist", "60337");
INSERT INTO "city" VALUES ("42", "Nieuwegein", "60360");
INSERT INTO "city" VALUES ("43", "Roosendaal", "75709");
INSERT INTO "city" VALUES ("44", "Den Helder", "59773");
INSERT INTO "city" VALUES ("45", "Doetinchem", "49971");
INSERT INTO "city" VALUES ("46", "Hoorn", "64162");
INSERT INTO "city" VALUES ("47", "Lelystad", "63043");
INSERT INTO "city" VALUES ("48", "Almelo", "72093");
INSERT INTO "city" VALUES ("49", "Middelburg", "46485");
INSERT INTO "city" VALUES ("50", "Velsen", "60383");
INSERT INTO "city" VALUES ("51", "Rijswijk", "47700");
INSERT INTO "city" VALUES ("52", "Veenendaal", "39020");
INSERT INTO "city" VALUES ("53", "Bushbuckridge", "49000");
INSERT INTO "city" VALUES ("54", "Centurion", "200000");
INSERT INTO "city" VALUES ("55", "Durban", "2500000");
INSERT INTO "city" VALUES ("56", "East London", "400000");
INSERT INTO "city" VALUES ("57", "Bloemfontein", "350000");
INSERT INTO "city" VALUES ("58", "Johannesburg", "2000000");
INSERT INTO "city" VALUES ("59", "Kimberley", "200000");
INSERT INTO "city" VALUES ("60", "Klerksdorp", "150000");
INSERT INTO "city" VALUES ("61", "Mamelodi", "300000");
INSERT INTO "city" VALUES ("62", "Nelspruit", "150000");
INSERT INTO "city" VALUES ("63", "Pietermaritzburg", "400000");
INSERT INTO "city" VALUES ("64", "Polokwane", "200000");
INSERT INTO "city" VALUES ("65", "Port Elizabeth", "1500000");
INSERT INTO "city" VALUES ("66", "Pretoria", "1500000");
INSERT INTO "city" VALUES ("67", "Soweto", "1000000");
INSERT INTO "city" VALUES ("68", "Tembisa", "500000");
INSERT INTO "city" VALUES ("69", "Umlazi", "500000");
INSERT INTO "city" VALUES ("70", "Vryheid", "100000");
INSERT INTO "city" VALUES ("71", "Welkom", "200000");
INSERT INTO "city" VALUES ("72", "Thohoyandou", "50000");
INSERT INTO "city" VALUES ("73", "Upington", "100000");
INSERT INTO "city" VALUES ("74", "Virginia", "100000");
INSERT INTO "city" VALUES ("75", "Worcester", "100000");
INSERT INTO "city" VALUES ("76", "Bisho", "100000");
INSERT INTO "city" VALUES ("77", "Grahamstown", "100000");
INSERT INTO "city" VALUES ("78", "Potchefstroom", "100000");
INSERT INTO "city" VALUES ("79", "Rustenburg", "100000");
INSERT INTO "city" VALUES ("80", "Springbok", "10000");
INSERT INTO "city" VALUES ("81", "Warrenton", "10000");
INSERT INTO "city" VALUES ("82", "Alexander Bay", "1000");
INSERT INTO "city" VALUES ("83", "Boksburg", "200000");
INSERT INTO "city" VALUES ("84", "Brandfort", "10000");
INSERT INTO "city" VALUES ("85", "Bronkhorstspruit", "10000");
INSERT INTO "city" VALUES ("86", "Carletonville", "100000");
INSERT INTO "city" VALUES ("87", "Delmas", "10000");
INSERT INTO "city" VALUES ("88", "Fochville", "10000");
INSERT INTO "city" VALUES ("89", "Ga-Rankuwa", "100000");
INSERT INTO "city" VALUES ("90", "Giyani", "10000");
INSERT INTO "city" VALUES ("91", "Komatipoort", "10000");
INSERT INTO "city" VALUES ("92", "Lebowakgomo", "10000");
INSERT INTO "city" VALUES ("93", "Louis Trichardt", "10000");
INSERT INTO "city" VALUES ("94", "Mabopane", "100000");
INSERT INTO "city" VALUES ("95", "Midrand", "100000");
INSERT INTO "city" VALUES ("96", "Modimolle", "10000");
INSERT INTO "city" VALUES ("97", "Mpumalanga", "10000");
INSERT INTO "city" VALUES ("98", "Nylstroom", "10000");
INSERT INTO "city" VALUES ("99", "Phalaborwa", "10000");
INSERT INTO "city" VALUES ("100", "Piet Retief", "10000");
INSERT INTO "city" VALUES ("101", "Pietersburg", "100000");
INSERT INTO "city" VALUES ("102", "Secunda", "10000");
INSERT INTO "city" VALUES ("103", "Siyabuswa", "10000");
INSERT INTO "city" VALUES ("104", "Stanger", "10000");
INSERT INTO "city" VALUES ("105", "Standerton", "10000");
INSERT INTO "city" VALUES ("106", "Tzaneen", "10000");
INSERT INTO "city" VALUES ("107", "Vanderbijlpark", "100000");
INSERT INTO "city" VALUES ("108", "Vereeniging", "100000");
INSERT INTO "city" VALUES ("109", "Witbank", "100000");
INSERT INTO "city" VALUES ("110", "Zwelitsha", "10000");
INSERT INTO "city" VALUES ("111", "Adelaide", "10000");
INSERT INTO "city" VALUES ("112", "Alice", "10000");
INSERT INTO "city" VALUES ("113", "Butterworth", "10000");
INSERT INTO "city" VALUES ("114", "Cradock", "10000");
INSERT INTO "city" VALUES ("115", "Fort Beaufort", "10000");
INSERT INTO "city" VALUES ("116", "King William's Town", "10000");
INSERT INTO "city" VALUES ("117", "Mthatha", "10000");
INSERT INTO "city" VALUES ("118", "Port Alfred", "10000");
INSERT INTO "city" VALUES ("119", "Queenstown", "10000");
INSERT INTO "city" VALUES ("120", "Somerset East", "10000");
INSERT INTO "city" VALUES ("121", "Uitenhage", "100000");
INSERT INTO "city" VALUES ("122", "Aliwal North", "10000");
INSERT INTO "city" VALUES ("123", "Bethlehem", "10000");
INSERT INTO "city" VALUES ("124", "Botshabelo", "100000");
INSERT INTO "city" VALUES ("125", "Ficksburg", "10000");
INSERT INTO "city" VALUES ("126", "Kroonstad", "100000");
INSERT INTO "city" VALUES ("127", "Odendaalsrus", "10000");
INSERT INTO "city" VALUES ("128", "Parys", "10000");
INSERT INTO "city" VALUES ("129", "Phuthaditjhaba", "100000");
INSERT INTO "city" VALUES ("130", "Sasolburg", "10000");
INSERT INTO "city" VALUES ("131", "Senekal", "10000");
INSERT INTO "city" VALUES ("132", "Viljoenskroon", "10000");
INSERT INTO "city" VALUES ("133", "Zastron", "10000");
INSERT INTO "city" VALUES ("134", "Atlantis", "10000");
INSERT INTO "city" VALUES ("135", "Ceres", "10000");
INSERT INTO "city" VALUES ("136", "De Aar", "10000");
INSERT INTO "city" VALUES ("137", "George", "100000");
INSERT INTO "city" VALUES ("138", "Knysna", "10000");
INSERT INTO "city" VALUES ("139", "Malmesbury", "10000");
INSERT INTO "city" VALUES ("140", "Mitchell's Plain", "100000");
INSERT INTO "city" VALUES ("141", "Paarl", "100000");
INSERT INTO "city" VALUES ("142", "Plettenberg Bay", "10000");
INSERT INTO "city" VALUES ("143", "Simon's Town", "10000");
INSERT INTO "city" VALUES ("144", "Stellenbosch", "10000");
INSERT INTO "city" VALUES ("145", "Strand", "10000");
INSERT INTO "city" VALUES ("146", "Vredenburg", "10000");
INSERT INTO "city" VALUES ("147", "Vryburg", "10000");
INSERT INTO "city" VALUES ("148", "Kuruman", "10000");
INSERT INTO "city" VALUES ("149", "Port Nolloth", "1000");
INSERT INTO "city" VALUES ("150", "Springbok", "10000");
INSERT INTO "city" VALUES ("151", "Upington", "100000");
INSERT INTO "city" VALUES ("152", "Warrenton", "10000");
INSERT INTO "city" VALUES ("153", "Witbank", "100000");
INSERT INTO "city" VALUES ("154", "Zwelitsha", "10000");
INSERT INTO "city" VALUES ("155", "Adelaide", "10000");
INSERT INTO "city" VALUES ("156", "Alice", "10000");
INSERT INTO "city" VALUES ("157", "Butterworth", "10000");
INSERT INTO "city" VALUES ("158", "Cradock", "10000");
INSERT INTO "city" VALUES ("159", "Fort Beaufort", "10000");
INSERT INTO "city" VALUES ("160", "King William's Town", "10000");
INSERT INTO "city" VALUES ("161", "Mthatha", "10000");
INSERT INTO "city" VALUES ("162", "Port Alfred", "10000");
INSERT INTO "city" VALUES ("163", "Queenstown", "10000");
INSERT INTO "city" VALUES ("164", "Somerset East", "10000");
INSERT INTO "city" VALUES ("165", "Uitenhage", "100000");
INSERT INTO "city" VALUES ("166", "Aliwal North", "10000");
INSERT INTO "city" VALUES ("167", "Bethlehem", "10000");
INSERT INTO "city" VALUES ("168", "Botshabelo", "100000");
INSERT INTO "city" VALUES ("169", "Ficksburg", "10000");
INSERT INTO "city" VALUES ("170", "Kroonstad", "100000");
INSERT INTO "city" VALUES ("171", "Odendaalsrus", "10000");
INSERT INTO "city" VALUES ("172", "Parys", "10000");
INSERT INTO "city" VALUES ("173", "Phuthaditjhaba", "100000");
INSERT INTO "city" VALUES ("174", "Sasolburg", "10000");
INSERT INTO "city" VALUES ("175", "Senekal", "10000");
INSERT INTO "city" VALUES ("176", "Viljoenskroon", "10000");
INSERT INTO "city" VALUES ("177", "Zastron", "10000");
INSERT INTO "city" VALUES ("178", "Atlantis", "10000");
INSERT INTO "city" VALUES ("179", "Ceres", "10000");
INSERT INTO "city" VALUES ("180", "De Aar", "10000");
INSERT INTO "city" VALUES ("181", "George", "100000");
INSERT INTO "city" VALUES ("182", "Knysna", "10000");
INSERT INTO "city" VALUES ("183", "Malmesbury", "10000");
INSERT INTO "city" VALUES ("184", "Mitchell's Plain", "100000");
INSERT INTO "city" VALUES ("185", "Paarl", "100000");
INSERT INTO "city" VALUES ("186", "Plettenberg Bay", "10000");
INSERT INTO "city" VALUES ("187", "Simon's Town", "10000");
INSERT INTO "city" VALUES ("188", "Stellenbosch", "10000");
INSERT INTO "city" VALUES ("189", "Strand", "10000");
INSERT INTO "city" VALUES ("190", "Vredenburg", "10000");
INSERT INTO "city" VALUES ("191", "Vryburg", "10000");
INSERT INTO "city" VALUES ("192", "Kuruman", "10000");
INSERT INTO "city" VALUES ("193", "Port Nolloth", "1000");
INSERT INTO "city" VALUES ("194", "Springbok", "10000");
INSERT INTO "city" VALUES ("195", "Upington", "100000");
INSERT INTO "city" VALUES ("196", "Warrenton", "10000");
INSERT INTO "city" VALUES ("197", "Witbank", "100000");
INSERT INTO "city" VALUES ("198", "Zwelitsha", "10000");
INSERT INTO "city" VALUES ("199", "Adelaide", "10000");
INSERT INTO "city" VALUES ("200", "Alice", "10000");
INSERT INTO "city" VALUES ("201", "Butterworth", "10000");
INSERT INTO "city" VALUES ("202", "Cradock", "10000");
INSERT INTO "city" VALUES ("203", "Fort Beaufort", "10000");
INSERT INTO "city" VALUES ("204", "King William's Town", "10000");
INSERT INTO "city" VALUES ("205", "Mthatha", "10000");
INSERT INTO "city" VALUES ("206", "Port Alfred", "10000");
INSERT INTO "city" VALUES ("207", "Queenstown", "10000");
INSERT INTO "city" VALUES ("208", "Somerset East", "10000");
INSERT INTO "city" VALUES ("209", "Uitenhage", "100000");
INSERT INTO "city" VALUES ("210", "Aliwal North", "10000");
INSERT INTO "city" VALUES ("211", "Bethlehem", "10000");
INSERT INTO "city" VALUES ("212", "Botshabelo", "100000");
INSERT INTO "city" VALUES ("213", "Ficksburg", "10000");
INSERT INTO "city" VALUES ("214", "Kroonstad", "100000");
INSERT INTO "city" VALUES ("215", "Odendaalsrus", "10000");
INSERT INTO "city" VALUES ("216", "Parys", "10000");
INSERT INTO "city" VALUES ("217", "Phuthaditjhaba", "100000");
INSERT INTO "city" VALUES ("218", "Sasolburg", "10000");
INSERT INTO "city" VALUES ("219", "Senekal", "10000");
INSERT INTO "city" VALUES ("220", "Viljoenskroon", "10000");
INSERT INTO "city" VALUES ("221", "Zastron", "10000");
INSERT INTO "city" VALUES ("222", "Atlantis", "10000");
INSERT INTO "city" VALUES ("223", "Ceres", "10000");
INSERT INTO "city" VALUES ("224", "De Aar", "10000");
INSERT INTO "city" VALUES ("225", "George", "100000");
INSERT INTO "city" VALUES ("226", "Knysna", "10000");
INSERT INTO "city" VALUES ("227", "Malmesbury", "10000");
INSERT INTO "city" VALUES ("228", "Mitchell's Plain", "100000");
INSERT INTO "city" VALUES ("229", "Paarl", "100000");
INSERT INTO "city" VALUES ("230", "Plettenberg Bay", "10000");
INSERT INTO "city" VALUES ("231", "Simon's Town", "10000");
INSERT INTO "city" VALUES ("232", "Stellenbosch", "10000");
INSERT INTO "city" VALUES ("233", "Strand", "10000");
INSERT INTO "city" VALUES ("234", "Vredenburg", "10000");
INSERT INTO "city" VALUES ("235", "Vryburg", "10000");
INSERT INTO "city" VALUES ("236", "Kuruman", "10000");
INSERT INTO "city" VALUES ("237", "Port Nolloth", "1000");
INSERT INTO "city" VALUES ("238", "Springbok", "10000");
INSERT INTO "city" VALUES ("239", "Upington", "100000");
INSERT INTO "city" VALUES ("240", "Warrenton", "10000");
INSERT INTO "city" VALUES ("241", "Witbank", "100000");
INSERT INTO "city" VALUES ("242", "Zwelitsha", "10000");
INSERT INTO "city" VALUES ("243", "Adelaide", "10000");
INSERT INTO "city" VALUES ("244", "Alice", "10000");
INSERT INTO "city" VALUES ("245", "Butterworth", "10000");
INSERT INTO "city" VALUES ("246", "Cradock", "10000");
INSERT INTO "city" VALUES ("247", "Fort Beaufort", "10000");
INSERT INTO "city" VALUES ("248", "King William's Town", "10000");
INSERT INTO "city" VALUES ("249", "Mthatha", "10000");
INSERT INTO "city" VALUES ("250", "Port Alfred", "10000");
INSERT INTO "city" VALUES ("251", "Queenstown", "10000");
INSERT INTO "city" VALUES ("252", "Somerset East", "10000");
INSERT INTO "city" VALUES ("253", "Uitenhage", "100000");
INSERT INTO "city" VALUES ("254", "Aliwal North", "10000");
INSERT INTO "city" VALUES ("255", "Bethlehem", "10000");
INSERT INTO "city" VALUES ("256", "Botshabelo", "100000");
INSERT INTO "city" VALUES ("257", "Ficksburg", "10000");
INSERT INTO "city" VALUES ("258", "Kroonstad", "100000");
INSERT INTO "city" VALUES ("259", "Odendaalsrus", "10000");
INSERT INTO "city" VALUES ("260", "Parys", "10000");
INSERT INTO "city" VALUES ("261", "Phuthaditjhaba", "100000");
INSERT INTO "city" VALUES ("262", "Sasolburg", "10000");
INSERT INTO "city" VALUES ("263", "Senekal", "10000");
INSERT INTO "city" VALUES ("264", "Viljoenskroon", "10000");
INSERT INTO "city" VALUES ("265", "Zastron", "10000");
INSERT INTO "city" VALUES ("266", "Atlantis", "10000");
INSERT INTO "city" VALUES ("267", "Ceres", "10000");
INSERT INTO "city" VALUES ("268", "De Aar", "10000");
INSERT INTO "city" VALUES ("269", "George", "100000");
INSERT INTO "city" VALUES ("270", "Knysna", "10000");
INSERT INTO "city" VALUES ("271", "Malmesbury", "10000");
INSERT INTO "city" VALUES ("272", "Mitchell's Plain", "100000");
INSERT INTO "city" VALUES ("273", "Paarl", "100000");
INSERT INTO "city" VALUES ("274", "Plettenberg Bay", "10000");