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





INSERT INTO "city" VALUES ("1", "100000");
INSERT INTO "city" VALUES ("2", "250000");
INSERT INTO "city" VALUES ("3", "50000");
INSERT INTO "city" VALUES ("4", "1200000");
INSERT INTO "city" VALUES ("5", "80000");
INSERT INTO "city" VALUES ("6", "300000");
INSERT INTO "city" VALUES ("7", "15000");
INSERT INTO "city" VALUES ("8", "700000");
INSERT INTO "city" VALUES ("9", "20000");
INSERT INTO "city" VALUES ("10", "500000");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "330000000", "21000000.0", "Federal Republic");
INSERT INTO "country" VALUES ("PRI", "Puerto Rico", "North America", "3200000", "100000.0", "US territory");
INSERT INTO "country" VALUES ("GUM", "Guam", "Oceania", "170000", "5000.0", "US territory");
INSERT INTO "country" VALUES ("VIR", "U.S. Virgin Islands", "North America", "100000", "2000.0", "US territory");
INSERT INTO "country" VALUES ("ASM", "American Samoa", "Oceania", "55000", "500.0", "US territory");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "38000000", "1700000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "128000000", "1200000.0", "Federal Republic");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "67000000", "2800000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "65000000", "2700000.0", "Republic");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "126000000", "5000000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1400000000", "14000000.0", "Peoples Republic");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1380000000", "2900000.0", "Federal Republic");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "25000000", "1400000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "Oceania", "5000000", "200000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("CUB", "Cuba", "North America", "11000000", "100000.0", "Socialist Republic");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "212000000", "1800000.0", "Federal Republic");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "45000000", "450000.0", "Federal Republic");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "83000000", "3800000.0", "Federal Republic");
INSERT INTO "country" VALUES ("ITA", "Italy", "Europe", "60000000", "2000000.0", "Republic");
INSERT INTO "country" VALUES ("ESP", "Spain", "Europe", "47000000", "1400000.0", "Constitutional Monarchy");