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 ("CHN", "China", "Asia", "1400000000", "76.7", "14342903.0");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1380000000", "69.4", "2875142.0");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "273000000", "71.7", "1119190.0");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "220000000", "67.3", "278221.0");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "165000000", "72.3", "302571.0");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "206000000", "54.3", "448120.0");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "114000000", "66.6", "96120.0");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "102000000", "71.7", "303175.0");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "59000000", "63.9", "351432.0");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "43000000", "76.9", "167555.0");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "126000000", "84.6", "5064873.0");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "51700000", "83.3", "1647125.0");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "97000000", "75.4", "261921.0");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "36000000", "76.3", "119040.0");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "11800000", "76.7", "39700.0");