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,
"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", "Haag", "440900");
INSERT INTO "city" VALUES ("8", "Utrecht", "234323");
INSERT INTO "city" VALUES ("9", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("10", "Tilburg", "193238");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "22720000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "15947000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "40350000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "68470000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "30000000");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "1000000");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "300000");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "5700000");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "770000");
INSERT INTO "country" VALUES ("LBR", "Liberia", "Africa", "500000");
INSERT INTO "country" VALUES ("COM", "Comoros", "Africa", "800000");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Asia", "1300000");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "2800000");
INSERT INTO "country" VALUES ("BDI", "Burundi", "Africa", "11000000");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "3500000");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "7200000");
INSERT INTO "countrylanguage" VALUES ("AFG", "Dari");
INSERT INTO "countrylanguage" VALUES ("AFG", "Pashto");
INSERT INTO "countrylanguage" VALUES ("NLD", "Dutch");
INSERT INTO "countrylanguage" VALUES ("ZAF", "Afrikaans");
INSERT INTO "countrylanguage" VALUES ("ZAF", "English");
INSERT INTO "countrylanguage" VALUES ("EGY", "Arabic");
INSERT INTO "countrylanguage" VALUES ("KEN", "Swahili");
INSERT INTO "countrylanguage" VALUES ("KEN", "English");
INSERT INTO "countrylanguage" VALUES ("SOM", "Somali");
INSERT INTO "countrylanguage" VALUES ("MDV", "Dhivehi");
INSERT INTO "countrylanguage" VALUES ("SGP", "Malay");
INSERT INTO "countrylanguage" VALUES ("SGP", "Mandarin Chinese");
INSERT INTO "countrylanguage" VALUES ("BTN", "Dzongkha");
INSERT INTO "countrylanguage" VALUES ("LBR", "English");
INSERT INTO "countrylanguage" VALUES ("COM", "Comorian");
INSERT INTO "countrylanguage" VALUES ("TLS", "Tetum");
INSERT INTO "countrylanguage" VALUES ("QAT", "Arabic");
INSERT INTO "countrylanguage" VALUES ("BDI", "Kirundi");
INSERT INTO "countrylanguage" VALUES ("ERI", "Tigrinya");
INSERT INTO "countrylanguage" VALUES ("LAO", "Lao");