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", "Central District", "1500000");
INSERT INTO "city" VALUES ("2", "Northern District", "800000");
INSERT INTO "city" VALUES ("3", "Eastern District", "1200000");
INSERT INTO "city" VALUES ("4", "Western District", "500000");
INSERT INTO "city" VALUES ("5", "Southern District", "2000000");
INSERT INTO "city" VALUES ("6", "Central District", "300000");
INSERT INTO "city" VALUES ("7", "Central District", "450000");
INSERT INTO "country" VALUES ("CAF", "Central Africa", "52.3");
INSERT INTO "country" VALUES ("CAG", "Central Africa", "48.7");
INSERT INTO "country" VALUES ("CAH", "Central Africa", "55.1");
INSERT INTO "country" VALUES ("EAS", "East Asia", "76.4");
INSERT INTO "country" VALUES ("WAF", "West Africa", "60.2");
INSERT INTO "country" VALUES ("CAF2", "Central Africa", "50.0");
INSERT INTO "country" VALUES ("EUR", "Europe", "81.5");
INSERT INTO "countrylanguage" VALUES ("CAF", "French", "60.0");
INSERT INTO "countrylanguage" VALUES ("CAF", "English", "20.0");
INSERT INTO "countrylanguage" VALUES ("CAG", "French", "75.0");
INSERT INTO "countrylanguage" VALUES ("CAH", "Portuguese", "90.0");
INSERT INTO "countrylanguage" VALUES ("WAF", "English", "80.0");
INSERT INTO "countrylanguage" VALUES ("CAF2", "French", "50.0");
INSERT INTO "countrylanguage" VALUES ("CAF2", "Lingala", "40.0");
INSERT INTO "countrylanguage" VALUES ("EUR", "English", "70.0");
INSERT INTO "countrylanguage" VALUES ("EUR", "French", "20.0");