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





INSERT INTO "city" VALUES ("1", "500000");
INSERT INTO "city" VALUES ("2", "1200000");
INSERT INTO "city" VALUES ("3", "300000");
INSERT INTO "city" VALUES ("4", "800000");
INSERT INTO "city" VALUES ("5", "450000");
INSERT INTO "city" VALUES ("6", "2000000");
INSERT INTO "city" VALUES ("7", "150000");
INSERT INTO "city" VALUES ("8", "700000");
INSERT INTO "city" VALUES ("9", "100000");
INSERT INTO "city" VALUES ("10", "900000");
INSERT INTO "country" VALUES ("USA", "North America", "9834.0", "331000000", "78.9", "21433.0");
INSERT INTO "country" VALUES ("CAN", "North America", "9984.0", "37590000", "82.3", "1736.0");
INSERT INTO "country" VALUES ("MEX", "North America", "1964.0", "128900000", "75.0", "1221.0");
INSERT INTO "country" VALUES ("BLZ", "North America", "229.0", "400000", "74.0", "1.8");
INSERT INTO "country" VALUES ("GTM", "North America", "108.9", "17900000", "74.5", "78.0");
INSERT INTO "country" VALUES ("CUB", "North America", "109.9", "11300000", "79.0", "100.0");
INSERT INTO "country" VALUES ("HTI", "North America", "27.7", "11400000", "64.0", "8.0");
INSERT INTO "country" VALUES ("JAM", "North America", "10.9", "2960000", "74.5", "15.0");
INSERT INTO "country" VALUES ("BRZ", "South America", "8515.0", "211000000", "75.5", "1839.0");
INSERT INTO "country" VALUES ("FRA", "Europe", "643.8", "67000000", "82.5", "2715.0");