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),
"GovernmentForm" CHAR(45),
PRIMARY KEY ("Code")
);

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





INSERT INTO "city" VALUES ("1", "Western");
INSERT INTO "city" VALUES ("2", "Eastern");
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", "Federal Republic");
INSERT INTO "country" VALUES ("EGY", "Africa", "Northern Africa", "Republic");
INSERT INTO "country" VALUES ("ZAF", "Africa", "Southern Africa", "Parliamentary Republic");
INSERT INTO "country" VALUES ("KEN", "Africa", "Eastern Africa", "Republic");
INSERT INTO "country" VALUES ("DZA", "Africa", "Northern Africa", "Presidential Republic");
INSERT INTO "country" VALUES ("ETH", "Africa", "Eastern Africa", "Federal Democratic Republic");
INSERT INTO "country" VALUES ("TUN", "Africa", "Northern Africa", "Unitary Republic");
INSERT INTO "country" VALUES ("GHA", "Africa", "Western Africa", "Republic");
INSERT INTO "country" VALUES ("CMR", "Africa", "Central Africa", "Republic");
INSERT INTO "country" VALUES ("ZMB", "Africa", "Eastern Africa", "Republic");
INSERT INTO "country" VALUES ("MOR", "Africa", "Northern Africa", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("SEN", "Africa", "Western Africa", "Republic");
INSERT INTO "country" VALUES ("UGA", "Africa", "Eastern Africa", "Republic");
INSERT INTO "country" VALUES ("SDN", "Africa", "Northern Africa", "Federal Republic");
INSERT INTO "country" VALUES ("AGO", "Africa", "Central Africa", "Republic");
INSERT INTO "countrylanguage" VALUES ("NGA", "English");
INSERT INTO "countrylanguage" VALUES ("EGY", "Arabic");
INSERT INTO "countrylanguage" VALUES ("ZAF", "Zulu");
INSERT INTO "countrylanguage" VALUES ("KEN", "Swahili");
INSERT INTO "countrylanguage" VALUES ("DZA", "Arabic");
INSERT INTO "countrylanguage" VALUES ("ETH", "Amharic");
INSERT INTO "countrylanguage" VALUES ("TUN", "Arabic");
INSERT INTO "countrylanguage" VALUES ("GHA", "English");
INSERT INTO "countrylanguage" VALUES ("CMR", "French");
INSERT INTO "countrylanguage" VALUES ("ZMB", "English");
INSERT INTO "countrylanguage" VALUES ("MOR", "Arabic");
INSERT INTO "countrylanguage" VALUES ("SEN", "French");
INSERT INTO "countrylanguage" VALUES ("UGA", "English");
INSERT INTO "countrylanguage" VALUES ("SDN", "Arabic");
INSERT INTO "countrylanguage" VALUES ("AGO", "Portuguese");