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,
"Name" CHAR(35),
PRIMARY KEY ("ID")
);

CREATE TABLE "country" (
"Code" CHAR(3),
"Name" CHAR(52),
"Continent" TEXT,
"Region" CHAR(26),
"SurfaceArea" FLOAT,
"Population" INT,
PRIMARY KEY ("Code")
);





INSERT INTO "city" VALUES ("1", "Luanda");
INSERT INTO "city" VALUES ("2", "Maputo");
INSERT INTO "city" VALUES ("3", "Pretoria");
INSERT INTO "city" VALUES ("4", "Cairo");
INSERT INTO "city" VALUES ("5", "Nairobi");
INSERT INTO "city" VALUES ("6", "Lagos");
INSERT INTO "city" VALUES ("7", "Accra");
INSERT INTO "city" VALUES ("8", "Addis Ababa");
INSERT INTO "city" VALUES ("9", "Kinshasa");
INSERT INTO "city" VALUES ("10", "Harare");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "Southern Africa", "1246700.0", "32866272");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "Southern Africa", "1221037.0", "59308690");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "Eastern Africa", "799380.0", "31255435");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "Northern Africa", "1001450.0", "102334404");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "Eastern Africa", "580367.0", "53771296");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "Western Africa", "923768.0", "206139589");
INSERT INTO "country" VALUES ("GHA", "Ghana", "Africa", "Western Africa", "238533.0", "31072940");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "Eastern Africa", "1104300.0", "114963588");
INSERT INTO "country" VALUES ("COD", "DR Congo", "Africa", "Central Africa", "2344858.0", "89561403");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "Eastern Africa", "390757.0", "14862927");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "South America", "8515767.0", "212559417");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "North America", "9984670.0", "37742154");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "Australia and New Zealand", "7741220.0", "25499884");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "Eastern Asia", "9596961.0", "1439323776");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "Southern Asia", "3287590.0", "1380004385");