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 "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 ("MAR", "Africa", "Northern Africa", "36910560", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("TUN", "Africa", "Northern Africa", "11818619", "Republic");
INSERT INTO "country" VALUES ("GHA", "Africa", "Western Africa", "31072940", "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 ("CMR", "Africa", "Central Africa", "26545863", "Republic");
INSERT INTO "country" VALUES ("ZMB", "Africa", "Eastern Africa", "18383955", "Republic");
INSERT INTO "country" VALUES ("SEN", "Africa", "Western Africa", "16743927", "Republic");
INSERT INTO "country" VALUES ("AGO", "Africa", "Central Africa", "32866272", "Republic");
INSERT INTO "country" VALUES ("MLI", "Africa", "Western Africa", "20250833", "Republic");
INSERT INTO "country" VALUES ("NMR", "Africa", "Northern Africa", "1000000", "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 ("SWZ", "Africa", "Southern Africa", "1160164", "Absolute Monarchy");
INSERT INTO "country" VALUES ("DJI", "Africa", "Eastern Africa", "988000", "Republic");
INSERT INTO "country" VALUES ("GAB", "Africa", "Central Africa", "2225734", "Republic");
INSERT INTO "country" VALUES ("CPV", "Africa", "Western Africa", "555987", "Republic");
INSERT INTO "country" VALUES ("COM", "Africa", "Eastern Africa", "869601", "Federal Presidential Republic");