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),
PRIMARY KEY ("ID")
);

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





INSERT INTO "city" VALUES ("1", "Tokyo");
INSERT INTO "city" VALUES ("2", "London");
INSERT INTO "city" VALUES ("3", "Paris");
INSERT INTO "city" VALUES ("4", "Beijing");
INSERT INTO "city" VALUES ("5", "New Delhi");
INSERT INTO "city" VALUES ("6", "Berlin");
INSERT INTO "city" VALUES ("7", "Moscow");
INSERT INTO "city" VALUES ("8", "Cairo");
INSERT INTO "city" VALUES ("9", "Sydney");
INSERT INTO "city" VALUES ("10", "Rio de Janeiro");
INSERT INTO "country" VALUES ("JPN", "Asia", "Eastern Asia", "377975.0", "126476000");
INSERT INTO "country" VALUES ("GBR", "Europe", "Western Europe", "242495.0", "67886000");
INSERT INTO "country" VALUES ("FRA", "Europe", "Western Europe", "551695.0", "65273511");
INSERT INTO "country" VALUES ("CHN", "Asia", "Eastern Asia", "9596961.0", "1439323776");
INSERT INTO "country" VALUES ("IND", "Asia", "Southern Asia", "3287590.0", "1380004385");
INSERT INTO "country" VALUES ("DEU", "Europe", "Western Europe", "357022.0", "83783942");
INSERT INTO "country" VALUES ("RUS", "Europe", "Eastern Europe", "17098242.0", "145934462");
INSERT INTO "country" VALUES ("EGY", "Africa", "Northern Africa", "1010408.0", "102334404");
INSERT INTO "country" VALUES ("AUS", "Oceania", "Australia and New Zealand", "7692024.0", "25499884");
INSERT INTO "country" VALUES ("BRA", "South America", "South America", "8515767.0", "212559417");
INSERT INTO "country" VALUES ("KOR", "Asia", "Eastern Asia", "100210.0", "51269514");
INSERT INTO "country" VALUES ("ITA", "Europe", "Southern Europe", "301340.0", "59554023");
INSERT INTO "country" VALUES ("CAN", "North America", "Northern America", "9984670.0", "37742154");
INSERT INTO "country" VALUES ("MEX", "North America", "Central America", "1964375.0", "128932753");
INSERT INTO "country" VALUES ("ARG", "South America", "South America", "2780400.0", "45195774");
INSERT INTO "country" VALUES ("ZAF", "Africa", "Southern Africa", "1221037.0", "59308690");
INSERT INTO "country" VALUES ("NGA", "Africa", "Western Africa", "923768.0", "206139589");
INSERT INTO "country" VALUES ("SAU", "Asia", "Western Asia", "2149690.0", "34813871");
INSERT INTO "country" VALUES ("IRN", "Asia", "Southern Asia", "1648195.0", "83992949");
INSERT INTO "country" VALUES ("ESP", "Europe", "Southern Europe", "505990.0", "46754778");
INSERT INTO "country" VALUES ("SWE", "Europe", "Northern Europe", "450295.0", "10099265");
INSERT INTO "country" VALUES ("NOR", "Europe", "Northern Europe", "385203.0", "5379475");
INSERT INTO "country" VALUES ("FIN", "Europe", "Northern Europe", "338455.0", "5540720");
INSERT INTO "country" VALUES ("POL", "Europe", "Eastern Europe", "312696.0", "37846611");
INSERT INTO "country" VALUES ("UKR", "Europe", "Eastern Europe", "603500.0", "43795220");
INSERT INTO "country" VALUES ("KAZ", "Asia", "Central Asia", "2724900.0", "18776707");
INSERT INTO "country" VALUES ("MYS", "Asia", "South-Eastern Asia", "330803.0", "32365999");
INSERT INTO "country" VALUES ("IDN", "Asia", "South-Eastern Asia", "1904569.0", "273523615");
INSERT INTO "country" VALUES ("VNM", "Asia", "South-Eastern Asia", "331212.0", "97338579");
INSERT INTO "country" VALUES ("THA", "Asia", "South-Eastern Asia", "513120.0", "69799978");
INSERT INTO "country" VALUES ("PHL", "Asia", "South-Eastern Asia", "300000.0", "109581078");
INSERT INTO "country" VALUES ("PAK", "Asia", "Southern Asia", "796095.0", "220892340");
INSERT INTO "country" VALUES ("BGD", "Asia", "Southern Asia", "147570.0", "164689383");
INSERT INTO "country" VALUES ("TUR", "Asia", "Western Asia", "783562.0", "84339067");
INSERT INTO "country" VALUES ("SYR", "Asia", "Western Asia", "185180.0", "17500657");
INSERT INTO "country" VALUES ("IRQ", "Asia", "Western Asia", "438317.0", "40222493");
INSERT INTO "country" VALUES ("AFG", "Asia", "Southern Asia", "652230.0", "38928346");
INSERT INTO "country" VALUES ("UZB", "Asia", "Central Asia", "447400.0", "33469203");
INSERT INTO "country" VALUES ("GEO", "Asia", "Western Asia", "69700.0", "3989167");
INSERT INTO "country" VALUES ("ARM", "Asia", "Western Asia", "29743.0", "2963243");
INSERT INTO "country" VALUES ("AZE", "Asia", "Western Asia", "86600.0", "10139177");
INSERT INTO "country" VALUES ("CYP", "Asia", "Western Asia", "9251.0", "1207359");
INSERT INTO "country" VALUES ("ISR", "Asia", "Western Asia", "22072.0", "8655535");
INSERT INTO "country" VALUES ("JOR", "Asia", "Western Asia", "89342.0", "10203134");
INSERT INTO "country" VALUES ("LBN", "Asia", "Western Asia", "10452.0", "6825445");
INSERT INTO "country" VALUES ("OMN", "Asia", "Western Asia", "309500.0", "5106626");
INSERT INTO "country" VALUES ("QAT", "Asia", "Western Asia", "11586.0", "2881053");
INSERT INTO "country" VALUES ("ARE", "Asia", "Western Asia", "83600.0", "9890400");
INSERT INTO "country" VALUES ("YEM", "Asia", "Western Asia", "527968.0", "29825968");
INSERT INTO "country" VALUES ("KWT", "Asia", "Western Asia", "17818.0", "4270571");
INSERT INTO "country" VALUES ("BHR", "Asia", "Western Asia", "765.0", "1701575");
INSERT INTO "country" VALUES ("SGP", "Asia", "South-Eastern Asia", "719.0", "5686000");
INSERT INTO "country" VALUES ("BRN", "Asia", "South-Eastern Asia", "5765.0", "437483");
INSERT INTO "country" VALUES ("TLS", "Asia", "South-Eastern Asia", "14874.0", "1318445");
INSERT INTO "country" VALUES ("LAO", "Asia", "South-Eastern Asia", "236800.0", "7275556");
INSERT INTO "country" VALUES ("KHM", "Asia", "South-Eastern Asia", "181035.0", "16718965");
INSERT INTO "country" VALUES ("MMR", "Asia", "South-Eastern Asia", "676578.0", "54045420");
INSERT INTO "country" VALUES ("NPL", "Asia", "Southern Asia", "147181.0", "29136808");
INSERT INTO "country" VALUES ("BTN", "Asia", "Southern Asia", "38394.0", "771612");
INSERT INTO "country" VALUES ("LKA", "Asia", "Southern Asia", "65610.0", "21413247");
INSERT INTO "country" VALUES ("MDV", "Asia", "Southern Asia", "300.0", "540542");
INSERT INTO "country" VALUES ("JPN", "Asia", "Eastern Asia", "377975.0", "126476000");
INSERT INTO "country" VALUES ("PRK", "Asia", "Eastern Asia", "120538.0", "25778816");
INSERT INTO "country" VALUES ("MNG", "Asia", "Eastern Asia", "1564116.0", "3278290");
INSERT INTO "country" VALUES ("TWN", "Asia", "Eastern Asia", "36193.0", "23816775");
INSERT INTO "country" VALUES ("HKG", "Asia", "Eastern Asia", "1104.0", "7496981");
INSERT INTO "country" VALUES ("MAC", "Asia", "Eastern Asia", "30.0", "649335");
INSERT INTO "country" VALUES ("AUT", "Europe", "Western Europe", "83871.0", "9006398");
INSERT INTO "country" VALUES ("BEL", "Europe", "Western Europe", "30528.0", "11589623");
INSERT INTO "country" VALUES ("NLD", "Europe", "Western Europe", "41543.0", "17424978");
INSERT INTO "country" VALUES ("LUX", "Europe", "Western Europe", "2586.0", "625978");
INSERT INTO "country" VALUES ("CHE", "Europe", "Western Europe", "41285.0", "8654622");
INSERT INTO "country" VALUES ("IRL", "Europe", "Northern Europe", "70273.0", "4937786");
INSERT INTO "country" VALUES ("DNK", "Europe", "Northern Europe", "43094.0", "5792202");
INSERT INTO "country" VALUES ("ISL", "Europe", "Northern Europe", "103000.0", "341243");
INSERT INTO "country" VALUES ("EST", "Europe", "Northern Europe", "45227.0", "1326200");
INSERT INTO "country" VALUES ("LVA", "Europe", "Northern Europe", "64589.0", "1886198");
INSERT INTO "country" VALUES ("LTU", "Europe", "Northern Europe", "65300.0", "2722289");
INSERT INTO "country" VALUES ("BLR", "Europe", "Eastern Europe", "207600.0", "9449323");
INSERT INTO "country" VALUES ("MDA", "Europe", "Eastern Europe", "33846.0", "2657637");
INSERT INTO "country" VALUES ("ROU", "Europe", "Eastern Europe", "238391.0", "19237691");
INSERT INTO "country" VALUES ("BGR", "Europe", "Eastern Europe", "110879.0", "6948445");
INSERT INTO "country" VALUES ("HUN", "Europe", "Eastern Europe", "93028.0", "9633991");
INSERT INTO "country" VALUES ("SVK", "Europe", "Eastern Europe", "49035.0", "5458827");
INSERT INTO "country" VALUES ("CZE", "Europe", "Eastern Europe", "78867.0", "10708981");
INSERT INTO "country" VALUES ("SVN", "Europe", "Southern Europe", "20273.0", "2078938");
INSERT INTO "country" VALUES ("HRV", "Europe", "Southern Europe", "56594.0", "4008617");
INSERT INTO "country" VALUES ("BIH", "Europe", "Southern Europe", "51197.0", "3280894");
INSERT INTO "country" VALUES ("SRB", "Europe", "Southern Europe", "88361.0", "6926705");
INSERT INTO "country" VALUES ("MNE", "Europe", "Southern Europe", "13812.0", "628062");
INSERT INTO "country" VALUES ("ALB", "Europe", "Southern Europe", "28748.0", "2877797");
INSERT INTO "country" VALUES ("GRC", "Europe", "Southern Europe", "131957.0", "10423054");
INSERT INTO "country" VALUES ("MKD", "Europe", "Southern Europe", "25713.0", "2083374");
INSERT INTO "country" VALUES ("KOS", "Europe", "Southern Europe", "10887.0", "1793506");
INSERT INTO "country" VALUES ("MLT", "Europe", "Southern Europe", "316.0", "441543");
INSERT INTO "country" VALUES ("VAT", "Europe", "Southern Europe", "0.44", "800");
INSERT INTO "country" VALUES ("SMR", "Europe", "Southern Europe", "61.0", "33938");
INSERT INTO "country" VALUES ("AND", "Europe", "Southern Europe", "468.0", "77265");
INSERT INTO "country" VALUES ("MCO", "Europe", "Western Europe", "2.02", "39244");
INSERT INTO "country" VALUES ("LIE", "Europe", "Western Europe", "160.0", "38128");
INSERT INTO "country" VALUES ("SJM", "Europe", "Northern Europe", "61022.0", "2667");
INSERT INTO "country" VALUES ("GIB", "Europe", "Southern Europe", "6.5", "33691");
INSERT INTO "country" VALUES ("FRO", "Europe", "Northern Europe", "1399.0", "48865");
INSERT INTO "country" VALUES ("GGY", "Europe", "Western Europe", "78.0", "62063");
INSERT INTO "country" VALUES ("JEY", "Europe", "Western Europe", "118.0", "101073");
INSERT INTO "country" VALUES ("IMN", "Europe", "Western Europe", "572.0", "85032");
INSERT INTO "country" VALUES ("ALA", "Europe", "Northern Europe", "1580.0", "29884");
INSERT INTO "country" VALUES ("SGS", "Antarctica", "Antarctica", "3903.0", "30");
INSERT INTO "country" VALUES ("HMD", "Antarctica", "Antarctica", "372.0", "0");
INSERT INTO "country" VALUES ("ATF", "Antarctica", "Antarctica", "43967.0", "0");
INSERT INTO "country" VALUES ("BVT", "Antarctica", "Antarctica", "49.0", "0");
INSERT INTO "country" VALUES ("IOT", "Asia", "Southern Asia", "45.0", "3000");
INSERT INTO "country" VALUES ("CCK", "Oceania", "Australia and New Zealand", "14.0", "544");
INSERT INTO "country" VALUES ("CXR", "Oceania", "Australia and New Zealand", "135.0", "1692");
INSERT INTO "country" VALUES ("NFK", "Oceania", "Australia and New Zealand", "36.0", "1748");
INSERT INTO "country" VALUES ("COK", "Oceania", "Polynesia", "236.0", "17593");
INSERT INTO "country" VALUES ("NIU", "Oceania", "Polynesia", "260.0", "1624");
INSERT INTO "country" VALUES ("TKL", "Oceania", "Polynesia", "12.0", "1411");
INSERT INTO "country" VALUES ("WLF", "Oceania", "Polynesia", "142.0", "11237");
INSERT INTO "country" VALUES ("PYF", "Oceania", "Polynesia", "4167.0", "279200");
INSERT INTO "country" VALUES ("NCL", "Oceania", "Melanesia", "18575.0", "287800");
INSERT INTO "country" VALUES ("PCN", "Oceania", "Polynesia", "47.0", "50");
INSERT INTO "country" VALUES ("FLK", "South America", "South America", "12173.0", "3398");
INSERT INTO "country" VALUES ("SGS", "South America", "South America", "3903.0", "30");
INSERT INTO "country" VALUES ("SHN", "Africa", "Western Africa", "394.0", "6000");
INSERT INTO "country" VALUES ("SPM", "North America", "Northern America", "242.0", "6069");
INSERT INTO "country" VALUES ("GRL", "North America", "Northern America", "2166086.0", "56025");
INSERT INTO "country" VALUES ("BVT", "South America", "South America", "49.0", "0");
INSERT INTO "country" VALUES ("HMD", "Oceania", "Australia and New Zealand", "372.0", "0");
INSERT INTO "country" VALUES ("ATF", "Africa", "Southern Africa", "43967.0", "0");
INSERT INTO "country" VALUES ("IOT", "Africa", "Eastern Africa", "45.0", "3000");