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

CREATE TABLE "country" (
"Code" CHAR(3),
"Region" CHAR(26),
"LifeExpectancy" FLOAT,
PRIMARY KEY ("Code")
);

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





INSERT INTO "city" VALUES ("1", "Central Africa", "500000");
INSERT INTO "city" VALUES ("2", "Central Africa", "1500000");
INSERT INTO "city" VALUES ("3", "Central Africa", "300000");
INSERT INTO "city" VALUES ("4", "West Africa", "800000");
INSERT INTO "city" VALUES ("5", "East Africa", "1200000");
INSERT INTO "city" VALUES ("6", "Central Africa", "700000");
INSERT INTO "city" VALUES ("7", "North Africa", "900000");
INSERT INTO "city" VALUES ("8", "Central Africa", "400000");
INSERT INTO "city" VALUES ("9", "South Africa", "600000");
INSERT INTO "city" VALUES ("10", "Central Africa", "100000");
INSERT INTO "country" VALUES ("CAF", "Central Africa", "52.3");
INSERT INTO "country" VALUES ("CGA", "Central Africa", "54.7");
INSERT INTO "country" VALUES ("CMR", "Central Africa", "56.1");
INSERT INTO "country" VALUES ("NGA", "West Africa", "55.2");
INSERT INTO "country" VALUES ("KEN", "East Africa", "63.4");
INSERT INTO "country" VALUES ("EGY", "North Africa", "71.5");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "64.1");
INSERT INTO "country" VALUES ("GAB", "Central Africa", "59.8");
INSERT INTO "country" VALUES ("TCD", "Central Africa", "50.9");
INSERT INTO "country" VALUES ("SSD", "Central Africa", "57.0");
INSERT INTO "countrylanguage" VALUES ("CAF", "French", "80.0");
INSERT INTO "countrylanguage" VALUES ("CAF", "Sango", "10.0");
INSERT INTO "countrylanguage" VALUES ("CGA", "French", "85.0");
INSERT INTO "countrylanguage" VALUES ("CMR", "English", "30.0");
INSERT INTO "countrylanguage" VALUES ("NGA", "English", "53.0");
INSERT INTO "countrylanguage" VALUES ("KEN", "Swahili", "68.0");
INSERT INTO "countrylanguage" VALUES ("EGY", "Arabic", "90.0");
INSERT INTO "countrylanguage" VALUES ("ZAF", "Zulu", "23.0");
INSERT INTO "countrylanguage" VALUES ("ZAF", "English", "9.0");
INSERT INTO "countrylanguage" VALUES ("GAB", "French", "85.0");
INSERT INTO "countrylanguage" VALUES ("TCD", "French", "40.0");
INSERT INTO "countrylanguage" VALUES ("TCD", "Arabic", "35.0");
INSERT INTO "countrylanguage" VALUES ("SSD", "English", "50.0");
INSERT INTO "countrylanguage" VALUES ("SSD", "Arabic", "20.0");