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", "Huambo");
INSERT INTO "city" VALUES ("3", "Lobito");
INSERT INTO "city" VALUES ("4", "Benguela");
INSERT INTO "city" VALUES ("5", "Malanje");
INSERT INTO "city" VALUES ("6", "Namibe");
INSERT INTO "city" VALUES ("7", "Cabinda");
INSERT INTO "city" VALUES ("8", "Kuito");
INSERT INTO "city" VALUES ("9", "Uige");
INSERT INTO "city" VALUES ("10", "Saurimo");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "Central Africa", "1246700.0", "32866272");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "Southern Africa", "1221037.0", "59308690");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "Southern Africa", "825615.0", "2540905");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "Eastern Africa", "752618.0", "18383956");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "Eastern Africa", "799380.0", "31255435");
INSERT INTO "country" VALUES ("COD", "Congo, The Democratic Republic of the", "Africa", "Central Africa", "2344858.0", "89561403");
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 ("EGY", "Egypt", "Africa", "Northern Africa", "1001450.0", "102334404");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "Northern Africa", "446550.0", "36910560");