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,
"Name" CHAR(35),
"Population" INT,
PRIMARY KEY ("ID")
);

CREATE TABLE "country" (
"Code" CHAR(3),
"Name" CHAR(52),
"Continent" TEXT,
"Region" CHAR(26),
"SurfaceArea" FLOAT,
PRIMARY KEY ("Code")
);





INSERT INTO "city" VALUES ("1", "Oranjestad", "30000");
INSERT INTO "city" VALUES ("2", "Willemstad", "125000");
INSERT INTO "city" VALUES ("3", "Havana", "2135000");
INSERT INTO "city" VALUES ("4", "Santo Domingo", "2138000");
INSERT INTO "city" VALUES ("5", "Port-au-Prince", "1729000");
INSERT INTO "city" VALUES ("6", "Kingston", "577000");
INSERT INTO "city" VALUES ("7", "Nassau", "200000");
INSERT INTO "city" VALUES ("8", "Bridgetown", "100000");
INSERT INTO "city" VALUES ("9", "Port of Spain", "50000");
INSERT INTO "city" VALUES ("10", "Castries", "20000");
INSERT INTO "city" VALUES ("11", "Roseau", "15000");
INSERT INTO "city" VALUES ("12", "St. George's", "30000");
INSERT INTO "city" VALUES ("13", "Basseterre", "15000");
INSERT INTO "city" VALUES ("14", "Kingstown", "25000");
INSERT INTO "city" VALUES ("15", "Belmopan", "20000");
INSERT INTO "city" VALUES ("16", "Georgetown", "235000");
INSERT INTO "city" VALUES ("17", "Paramaribo", "240000");
INSERT INTO "city" VALUES ("18", "Cayenne", "60000");
INSERT INTO "city" VALUES ("19", "San Juan", "400000");
INSERT INTO "city" VALUES ("20", "Hamilton", "10000");
INSERT INTO "country" VALUES ("ABW", "Aruba", "North America", "Caribbean", "193.0");
INSERT INTO "country" VALUES ("ANT", "Netherlands Antilles", "North America", "Caribbean", "800.0");
INSERT INTO "country" VALUES ("CUB", "Cuba", "North America", "Caribbean", "110860.0");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "North America", "Caribbean", "48670.0");
INSERT INTO "country" VALUES ("HTI", "Haiti", "North America", "Caribbean", "27750.0");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "North America", "Caribbean", "10991.0");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "North America", "Caribbean", "13878.0");
INSERT INTO "country" VALUES ("BRB", "Barbados", "North America", "Caribbean", "430.0");
INSERT INTO "country" VALUES ("TTO", "Trinidad and Tobago", "North America", "Caribbean", "5130.0");
INSERT INTO "country" VALUES ("LCA", "Saint Lucia", "North America", "Caribbean", "622.0");
INSERT INTO "country" VALUES ("DMA", "Dominica", "North America", "Caribbean", "751.0");
INSERT INTO "country" VALUES ("GRD", "Grenada", "North America", "Caribbean", "344.0");
INSERT INTO "country" VALUES ("KNA", "Saint Kitts and Nevis", "North America", "Caribbean", "261.0");
INSERT INTO "country" VALUES ("VCT", "Saint Vincent and the Grenadines", "North America", "Caribbean", "389.0");
INSERT INTO "country" VALUES ("BLZ", "Belize", "North America", "Central America", "22966.0");
INSERT INTO "country" VALUES ("GUY", "Guyana", "South America", "South America", "214969.0");
INSERT INTO "country" VALUES ("SUR", "Suriname", "South America", "South America", "163265.0");
INSERT INTO "country" VALUES ("GUF", "French Guiana", "South America", "South America", "90000.0");
INSERT INTO "country" VALUES ("PRI", "Puerto Rico", "North America", "Caribbean", "8870.0");
INSERT INTO "country" VALUES ("BMU", "Bermuda", "North America", "North America", "53.0");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "North America", "9631420.0");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "North America", "9984670.0");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "Central America", "1958201.0");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "South America", "2780400.0");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "South America", "8547403.0");
INSERT INTO "country" VALUES ("COL", "Colombia", "South America", "South America", "1138914.0");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "South America", "South America", "912050.0");
INSERT INTO "country" VALUES ("PER", "Peru", "South America", "South America", "1285216.0");
INSERT INTO "country" VALUES ("CHL", "Chile", "South America", "South America", "756102.0");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "South America", "South America", "283561.0");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "South America", "South America", "1098581.0");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "South America", "South America", "406752.0");
INSERT INTO "country" VALUES ("URY", "Uruguay", "South America", "South America", "176215.0");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "Western Europe", "551500.0");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "Western Europe", "357022.0");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "Western Europe", "242900.0");
INSERT INTO "country" VALUES ("ITA", "Italy", "Europe", "Southern Europe", "301316.0");
INSERT INTO "country" VALUES ("ESP", "Spain", "Europe", "Southern Europe", "505992.0");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "Eastern Asia", "9572900.0");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "Southern Asia", "3287263.0");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "Eastern Asia", "377829.0");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "Australia and New Zealand", "7741220.0");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "Oceania", "Australia and New Zealand", "268680.0");