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) UNIQUE,
"Name" CHAR(52),
"Continent" TEXT,
"Population" INT,
"LifeExpectancy" FLOAT,
"GNP" FLOAT,
PRIMARY KEY ("Code")
);





INSERT INTO "city" VALUES ("1", "5000000");
INSERT INTO "city" VALUES ("2", "12000000");
INSERT INTO "city" VALUES ("3", "8000000");
INSERT INTO "city" VALUES ("4", "3000000");
INSERT INTO "city" VALUES ("5", "15000000");
INSERT INTO "city" VALUES ("6", "7000000");
INSERT INTO "city" VALUES ("7", "2000000");
INSERT INTO "city" VALUES ("8", "10000000");
INSERT INTO "city" VALUES ("9", "4000000");
INSERT INTO "city" VALUES ("10", "6000000");
INSERT INTO "country" VALUES ("AFR", "Africana", "Africa", "25000000", "60.5", "15000.0");
INSERT INTO "country" VALUES ("AFS", "Afrisia", "Africa", "30000000", "58.0", "12000.0");
INSERT INTO "country" VALUES ("AFN", "Afron", "Africa", "28000000", "62.0", "18000.0");
INSERT INTO "country" VALUES ("ASI", "Asiana", "Asia", "35000000", "70.0", "25000.0");
INSERT INTO "country" VALUES ("ASJ", "Asijon", "Asia", "40000000", "72.5", "30000.0");
INSERT INTO "country" VALUES ("ASK", "Askara", "Asia", "27000000", "68.0", "22000.0");
INSERT INTO "country" VALUES ("EUR", "Europia", "Europe", "45000000", "75.0", "35000.0");
INSERT INTO "country" VALUES ("NAM", "Namica", "North America", "32000000", "78.0", "40000.0");
INSERT INTO "country" VALUES ("SAM", "Samica", "South America", "28000000", "65.0", "20000.0");
INSERT INTO "country" VALUES ("AUS", "Australis", "Oceania", "15000000", "80.0", "45000.0");