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) UNIQUE,
"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", "Kinshasa", "15000000");
INSERT INTO "city" VALUES ("2", "Douala", "2500000");
INSERT INTO "city" VALUES ("3", "Yaounde", "2200000");
INSERT INTO "city" VALUES ("4", "Bangui", "750000");
INSERT INTO "city" VALUES ("5", "Brazzaville", "1800000");
INSERT INTO "city" VALUES ("6", "Libreville", "700000");
INSERT INTO "city" VALUES ("7", "N'Djamena", "1000000");
INSERT INTO "city" VALUES ("8", "Malabo", "110000");
INSERT INTO "city" VALUES ("9", "Luanda", "8000000");
INSERT INTO "city" VALUES ("10", "Bujumbura", "800000");
INSERT INTO "country" VALUES ("COD", "Central Africa", "60.5");
INSERT INTO "country" VALUES ("CMR", "Central Africa", "58.2");
INSERT INTO "country" VALUES ("CAF", "Central Africa", "52.3");
INSERT INTO "country" VALUES ("COG", "Central Africa", "59.1");
INSERT INTO "country" VALUES ("GAB", "Central Africa", "66.8");
INSERT INTO "country" VALUES ("TCD", "Central Africa", "54.0");
INSERT INTO "country" VALUES ("GNQ", "Central Africa", "0.0");
INSERT INTO "country" VALUES ("AGO", "Central Africa", "61.2");
INSERT INTO "country" VALUES ("BDI", "Central Africa", "55.5");
INSERT INTO "country" VALUES ("ZMB", "Eastern Africa", "63.4");
INSERT INTO "country" VALUES ("NGA", "Western Africa", "54.3");
INSERT INTO "country" VALUES ("EGY", "Northern Africa", "71.5");
INSERT INTO "countrylanguage" VALUES ("COD", "French", "50.0");
INSERT INTO "countrylanguage" VALUES ("COD", "Lingala", "30.0");
INSERT INTO "countrylanguage" VALUES ("CMR", "French", "80.0");
INSERT INTO "countrylanguage" VALUES ("CMR", "English", "10.0");
INSERT INTO "countrylanguage" VALUES ("CAF", "French", "60.0");
INSERT INTO "countrylanguage" VALUES ("CAF", "Sango", "30.0");
INSERT INTO "countrylanguage" VALUES ("COG", "French", "90.0");
INSERT INTO "countrylanguage" VALUES ("GAB", "French", "85.0");
INSERT INTO "countrylanguage" VALUES ("TCD", "French", "40.0");
INSERT INTO "countrylanguage" VALUES ("TCD", "Arabic", "20.0");
INSERT INTO "countrylanguage" VALUES ("GNQ", "Spanish", "60.0");
INSERT INTO "countrylanguage" VALUES ("GNQ", "French", "30.0");
INSERT INTO "countrylanguage" VALUES ("AGO", "Portuguese", "70.0");
INSERT INTO "countrylanguage" VALUES ("BDI", "Kirundi", "90.0");
INSERT INTO "countrylanguage" VALUES ("ZMB", "English", "80.0");
INSERT INTO "countrylanguage" VALUES ("NGA", "English", "60.0");
INSERT INTO "countrylanguage" VALUES ("EGY", "Arabic", "95.0");