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),
"SurfaceArea" FLOAT,
"IndepYear" INT,
"Population" INT,
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
PRIMARY KEY ("CountryCode", "Language")
);





INSERT INTO "city" VALUES ("1", "Kabul", "1780000");
INSERT INTO "city" VALUES ("2", "Qandahar", "237500");
INSERT INTO "city" VALUES ("3", "Herat", "186800");
INSERT INTO "city" VALUES ("4", "Mazar-e-Sharif", "237600");
INSERT INTO "city" VALUES ("5", "Amsterdam", "731200");
INSERT INTO "city" VALUES ("6", "Rotterdam", "593321");
INSERT INTO "city" VALUES ("7", "The Hague", "440900");
INSERT INTO "city" VALUES ("8", "Utrecht", "234323");
INSERT INTO "city" VALUES ("9", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("10", "Groningen", "172700");
INSERT INTO "city" VALUES ("11", "Tilburg", "193232");
INSERT INTO "city" VALUES ("12", "Haarlem", "148700");
INSERT INTO "city" VALUES ("13", "Arnhem", "138000");
INSERT INTO "city" VALUES ("14", "Breda", "160000");
INSERT INTO "city" VALUES ("15", "Nijmegen", "152400");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "652090", "1919", "22720000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "41526", "1581", "15988000");
INSERT INTO "country" VALUES ("VAT", "Vatican City", "0.44", "1929", "1000");
INSERT INTO "country" VALUES ("PLW", "Palau", "459", "1994", "19000");
INSERT INTO "country" VALUES ("NRU", "Nauru", "21", "1968", "12000");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "26", "1978", "11000");
INSERT INTO "country" VALUES ("SMR", "San Marino", "61", "301", "27000");
INSERT INTO "country" VALUES ("MCO", "Monaco", "1.5", "1861", "34000");
INSERT INTO "country" VALUES ("LIE", "Liechtenstein", "160", "1806", "32000");
INSERT INTO "countrylanguage" VALUES ("AFG", "Dari");
INSERT INTO "countrylanguage" VALUES ("AFG", "Pashto");
INSERT INTO "countrylanguage" VALUES ("NLD", "Dutch");
INSERT INTO "countrylanguage" VALUES ("VAT", "Italian");
INSERT INTO "countrylanguage" VALUES ("VAT", "Latin");
INSERT INTO "countrylanguage" VALUES ("PLW", "English");
INSERT INTO "countrylanguage" VALUES ("PLW", "Palauan");
INSERT INTO "countrylanguage" VALUES ("NRU", "Nauruan");
INSERT INTO "countrylanguage" VALUES ("NRU", "English");
INSERT INTO "countrylanguage" VALUES ("TUV", "Tuvaluan");
INSERT INTO "countrylanguage" VALUES ("TUV", "English");
INSERT INTO "countrylanguage" VALUES ("SMR", "Italian");
INSERT INTO "countrylanguage" VALUES ("MCO", "French");
INSERT INTO "countrylanguage" VALUES ("LIE", "German");