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

CREATE TABLE "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Population" INT,
"LifeExpectancy" FLOAT,
"GovernmentForm" CHAR(45),
"HeadOfState" CHAR(60),
PRIMARY KEY ("Code")
);





INSERT INTO "country" VALUES ("AFG", "Asia", "22720000", "45.9", "Islamic Emirate", "Mohammad Omar");
INSERT INTO "country" VALUES ("NGA", "Africa", "123000000", "51.6", "Federal Republic", "Olusegun Obasanjo");
INSERT INTO "country" VALUES ("ZAF", "Africa", "40350000", "59.1", "Republic", "Thabo Mbeki");
INSERT INTO "country" VALUES ("EGY", "Africa", "68470000", "63.3", "Republic", "Hosni Mubarak");
INSERT INTO "country" VALUES ("KEN", "Africa", "30340000", "48.0", "Republic", "Daniel arap Moi");
INSERT INTO "country" VALUES ("DZA", "Africa", "31471000", "69.7", "Republic", "Abdelaziz Bouteflika");
INSERT INTO "country" VALUES ("MAR", "Africa", "29890000", "69.1", "Constitutional Monarchy", "Mohammed VI");
INSERT INTO "country" VALUES ("TUN", "Africa", "9522000", "73.7", "Republic", "Zine al-Abidine Ben Ali");
INSERT INTO "country" VALUES ("LBY", "Africa", "5670000", "75.5", "Socialist Peoples Libyan Arab Jamahiriya", "Muammar al-Gaddafi");
INSERT INTO "country" VALUES ("SDN", "Africa", "29490000", "56.5", "Federal Republic", "Omar Hassan Ahmad al-Bashir");
INSERT INTO "country" VALUES ("ETH", "Africa", "62560000", "45.2", "Federal Republic", "Negasso Gidada");
INSERT INTO "country" VALUES ("SOM", "Africa", "10090000", "46.2", "Republic", "Abdiqasim Salad Hassan");