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", "800000");
INSERT INTO "city" VALUES ("4", "300000");
INSERT INTO "city" VALUES ("5", "450000");
INSERT INTO "country" VALUES ("USA", "North America", "9833517.0", "331000000", "78.9", "21433226.0");
INSERT INTO "country" VALUES ("CAN", "North America", "9984670.0", "37590000", "82.3", "1736426.0");
INSERT INTO "country" VALUES ("MEX", "North America", "1964375.0", "128932000", "75.0", "1220703.0");
INSERT INTO "country" VALUES ("BLZ", "North America", "22966.0", "397628", "73.0", "1780.0");
INSERT INTO "country" VALUES ("GTM", "North America", "108889.0", "17915568", "74.5", "7750.0");
INSERT INTO "country" VALUES ("BAH", "North America", "13943.0", "393244", "73.5", "12300.0");
INSERT INTO "country" VALUES ("CUB", "North America", "109884.0", "11326616", "79.1", "10000.0");
INSERT INTO "country" VALUES ("HTI", "North America", "27750.0", "11402533", "64.0", "870.0");
INSERT INTO "country" VALUES ("DOM", "North America", "48671.0", "10847910", "74.0", "8500.0");
INSERT INTO "country" VALUES ("CRI", "North America", "51100.0", "5094114", "80.0", "6100.0");
INSERT INTO "country" VALUES ("PAN", "North America", "75417.0", "4314767", "78.0", "6600.0");
INSERT INTO "country" VALUES ("JAM", "North America", "10991.0", "2961161", "74.0", "1500.0");
INSERT INTO "country" VALUES ("TTO", "North America", "5130.0", "1394973", "72.0", "2300.0");
INSERT INTO "country" VALUES ("GRD", "North America", "344.0", "112523", "72.0", "300.0");
INSERT INTO "country" VALUES ("VCT", "North America", "389.0", "110211", "72.0", "280.0");
INSERT INTO "country" VALUES ("BRB", "North America", "430.0", "287375", "73.0", "450.0");
INSERT INTO "country" VALUES ("LCA", "North America", "616.0", "183627", "73.0", "400.0");
INSERT INTO "country" VALUES ("DMA", "North America", "754.0", "71991", "72.0", "250.0");
INSERT INTO "country" VALUES ("USA2", "North America", "2999.0", "1000000", "70.0", "50000.0");
INSERT INTO "country" VALUES ("USA3", "North America", "3001.0", "2000000", "70.0", "60000.0");
INSERT INTO "country" VALUES ("FRA", "Europe", "551695.0", "67000000", "82.0", "2700000.0");
INSERT INTO "country" VALUES ("BRA", "South America", "8515767.0", "211000000", "75.0", "1839758.0");