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

CREATE TABLE "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Region" CHAR(26),
"Population" INT,
"GovernmentForm" CHAR(45),
PRIMARY KEY ("Code")
);





INSERT INTO "city" VALUES ("1", "Eastern");
INSERT INTO "city" VALUES ("2", "Western");
INSERT INTO "city" VALUES ("3", "Northern");
INSERT INTO "city" VALUES ("4", "Southern");
INSERT INTO "city" VALUES ("5", "Central");
INSERT INTO "city" VALUES ("6", "Coastal");
INSERT INTO "city" VALUES ("7", "Highland");
INSERT INTO "city" VALUES ("8", "Savannah");
INSERT INTO "city" VALUES ("9", "Desert");
INSERT INTO "city" VALUES ("10", "Rainforest");
INSERT INTO "country" VALUES ("NGA", "Africa", "Western Africa", "206139589", "Federal Republic");
INSERT INTO "country" VALUES ("EGY", "Africa", "Northern Africa", "102334404", "Republic");
INSERT INTO "country" VALUES ("ZAF", "Africa", "Southern Africa", "59308690", "Parliamentary Republic");
INSERT INTO "country" VALUES ("KEN", "Africa", "Eastern Africa", "53771296", "Republic");
INSERT INTO "country" VALUES ("DZA", "Africa", "Northern Africa", "43851044", "Presidential Republic");
INSERT INTO "country" VALUES ("ETH", "Africa", "Eastern Africa", "114963588", "Federal Parliamentary Republic");
INSERT INTO "country" VALUES ("TUN", "Africa", "Northern Africa", "11818619", "Semi-Presidential Republic");
INSERT INTO "country" VALUES ("GHA", "Africa", "Western Africa", "31072940", "Republic");
INSERT INTO "country" VALUES ("CMR", "Africa", "Central Africa", "26545863", "Republic");
INSERT INTO "country" VALUES ("MAR", "Africa", "Northern Africa", "36910560", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("ZMB", "Africa", "Eastern Africa", "18383955", "Republic");
INSERT INTO "country" VALUES ("UGA", "Africa", "Eastern Africa", "45741007", "Republic");
INSERT INTO "country" VALUES ("SDN", "Africa", "Northern Africa", "43849260", "Federal Republic");
INSERT INTO "country" VALUES ("SEN", "Africa", "Western Africa", "16743927", "Republic");
INSERT INTO "country" VALUES ("BWA", "Africa", "Southern Africa", "2351627", "Parliamentary Republic");
INSERT INTO "country" VALUES ("LSO", "Africa", "Southern Africa", "2142249", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("MDG", "Africa", "Eastern Africa", "27691018", "Republic");
INSERT INTO "country" VALUES ("MWI", "Africa", "Eastern Africa", "19129952", "Republic");
INSERT INTO "country" VALUES ("NAM", "Africa", "Southern Africa", "2540905", "Republic");
INSERT INTO "country" VALUES ("RWA", "Africa", "Eastern Africa", "12952218", "Republic");
INSERT INTO "country" VALUES ("SOM", "Africa", "Eastern Africa", "15893222", "Federal Republic");
INSERT INTO "country" VALUES ("TZA", "Africa", "Eastern Africa", "59734218", "Republic");
INSERT INTO "country" VALUES ("ZWE", "Africa", "Eastern Africa", "14862924", "Republic");
INSERT INTO "country" VALUES ("AGO", "Africa", "Central Africa", "32866272", "Republic");
INSERT INTO "country" VALUES ("BFA", "Africa", "Western Africa", "20903273", "Republic");
INSERT INTO "country" VALUES ("BDI", "Africa", "Eastern Africa", "11890784", "Republic");
INSERT INTO "country" VALUES ("CPV", "Africa", "Western Africa", "555987", "Republic");
INSERT INTO "country" VALUES ("DJI", "Africa", "Eastern Africa", "988000", "Republic");
INSERT INTO "country" VALUES ("ERI", "Africa", "Eastern Africa", "3546064", "Federal Republic");
INSERT INTO "country" VALUES ("GAB", "Africa", "Central Africa", "2225734", "Republic");
INSERT INTO "country" VALUES ("GMB", "Africa", "Western Africa", "2416668", "Republic");
INSERT INTO "country" VALUES ("GIN", "Africa", "Western Africa", "13132795", "Republic");
INSERT INTO "country" VALUES ("GNB", "Africa", "Western Africa", "1968001", "Republic");
INSERT INTO "country" VALUES ("LSO", "Africa", "Southern Africa", "2142249", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("MDG", "Africa", "Eastern Africa", "27691018", "Republic");
INSERT INTO "country" VALUES ("MLI", "Africa", "Western Africa", "20250833", "Republic");
INSERT INTO "country" VALUES ("MRT", "Africa", "Western Africa", "4649658", "Republic");
INSERT INTO "country" VALUES ("MUS", "Africa", "Eastern Africa", "1271768", "Parliamentary Republic");
INSERT INTO "country" VALUES ("MOZ", "Africa", "Eastern Africa", "31255435", "Republic");
INSERT INTO "country" VALUES ("NER", "Africa", "Western Africa", "24206644", "Republic");
INSERT INTO "country" VALUES ("NGA", "Africa", "Western Africa", "206139589", "Federal Republic");
INSERT INTO "country" VALUES ("STP", "Africa", "Central Africa", "219159", "Republic");
INSERT INTO "country" VALUES ("SYC", "Africa", "Eastern Africa", "98347", "Republic");
INSERT INTO "country" VALUES ("TCD", "Africa", "Central Africa", "16425864", "Republic");
INSERT INTO "country" VALUES ("TGO", "Africa", "Western Africa", "8278724", "Republic");
INSERT INTO "country" VALUES ("TUN", "Africa", "Northern Africa", "11818619", "Semi-Presidential Republic");
INSERT INTO "country" VALUES ("ZAF", "Africa", "Southern Africa", "59308690", "Parliamentary Republic");
INSERT INTO "country" VALUES ("ZMB", "Africa", "Eastern Africa", "18383955", "Republic");
INSERT INTO "country" VALUES ("ZWE", "Africa", "Eastern Africa", "14862924", "Republic");