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





INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "Central Africa", "24383301", "52.4");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "Central Africa", "23737000", "57.3");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Africa", "Central Africa", "4594621", "51.5");
INSERT INTO "country" VALUES ("TCD", "Chad", "Africa", "Central Africa", "14497000", "53.2");
INSERT INTO "country" VALUES ("COG", "Congo", "Africa", "Central Africa", "5260000", "62.9");
INSERT INTO "country" VALUES ("COD", "Congo, The Democratic Republic of the", "Africa", "Central Africa", "81340000", "NULL");
INSERT INTO "country" VALUES ("GNQ", "Equatorial Guinea", "Africa", "Central Africa", "1222442", "57.9");
INSERT INTO "country" VALUES ("GAB", "Gabon", "Africa", "Central Africa", "2025000", "66.0");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "Africa", "Central Africa", "204000", "69.0");
INSERT INTO "country" VALUES ("BDI", "Burundi", "Africa", "Eastern Africa", "10864245", "60.0");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "Africa", "Eastern Africa", "12208407", "67.8");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "Eastern Africa", "49700000", "63.4");
INSERT INTO "country" VALUES ("UGA", "Uganda", "Africa", "Eastern Africa", "42862958", "63.4");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "Africa", "Eastern Africa", "55572201", "65.6");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "Eastern Africa", "14742000", "55.0");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "Africa", "Eastern Africa", "956985", "64.0");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "Eastern Africa", "5073000", "64.0");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "Eastern Africa", "105000000", "65.0");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "Northern Africa", "40813399", "64.0");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "Northern Africa", "97553151", "71.0");
INSERT INTO "country" VALUES ("LBY", "Libya", "Africa", "Northern Africa", "6374616", "72.0");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "Northern Africa", "11532127", "75.0");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "Northern Africa", "41318142", "76.0");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "Northern Africa", "35740000", "76.0");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "Southern Africa", "56717156", "63.0");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "Southern Africa", "2533794", "65.0");
INSERT INTO "country" VALUES ("BWA", "Botswana", "Africa", "Southern Africa", "2291661", "67.0");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "Southern Africa", "16529904", "61.0");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "Southern Africa", "29668834", "59.0");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "Africa", "Eastern Africa", "25570000", "66.0");
INSERT INTO "country" VALUES ("COM", "Comoros", "Africa", "Eastern Africa", "832322", "64.0");
INSERT INTO "country" VALUES ("MUS", "Mauritius", "Africa", "Eastern Africa", "1264000", "75.0");
INSERT INTO "country" VALUES ("SYC", "Seychelles", "Africa", "Eastern Africa", "95843", "73.0");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "Eastern Africa", "17351822", "62.0");
INSERT INTO "country" VALUES ("MWI", "Malawi", "Africa", "Eastern Africa", "18622104", "64.0");
INSERT INTO "country" VALUES ("LSO", "Lesotho", "Africa", "Southern Africa", "2233339", "53.0");
INSERT INTO "country" VALUES ("SWZ", "Eswatini", "Africa", "Southern Africa", "1367254", "58.0");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "Western Africa", "190886311", "54.0");
INSERT INTO "country" VALUES ("GHA", "Ghana", "Africa", "Western Africa", "28833629", "63.0");
INSERT INTO "country" VALUES ("CIV", "Cote dIvoire", "Africa", "Western Africa", "24294850", "58.0");
INSERT INTO "country" VALUES ("SEN", "Senegal", "Africa", "Western Africa", "15854360", "67.0");
INSERT INTO "country" VALUES ("MLI", "Mali", "Africa", "Western Africa", "18541980", "58.0");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "Africa", "Western Africa", "19193382", "61.0");
INSERT INTO "country" VALUES ("NER", "Niger", "Africa", "Western Africa", "21477348", "62.0");
INSERT INTO "country" VALUES ("BEN", "Benin", "Africa", "Western Africa", "11192600", "61.0");
INSERT INTO "country" VALUES ("TGO", "Togo", "Africa", "Western Africa", "7698000", "60.0");
INSERT INTO "country" VALUES ("SLE", "Sierra Leone", "Africa", "Western Africa", "7557212", "53.0");
INSERT INTO "country" VALUES ("LBR", "Liberia", "Africa", "Western Africa", "4743220", "62.0");
INSERT INTO "country" VALUES ("GIN", "Guinea", "Africa", "Western Africa", "12414000", "60.0");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "Africa", "Western Africa", "1861283", "58.0");