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,
"Region" CHAR(26),
"Population" INT,
PRIMARY KEY ("Code")
);

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





INSERT INTO "city" VALUES ("1", "50000");
INSERT INTO "city" VALUES ("2", "80000");
INSERT INTO "city" VALUES ("3", "120000");
INSERT INTO "city" VALUES ("4", "80000");
INSERT INTO "city" VALUES ("5", "30000");
INSERT INTO "city" VALUES ("6", "150000");
INSERT INTO "city" VALUES ("7", "80000");
INSERT INTO "city" VALUES ("8", "45000");
INSERT INTO "city" VALUES ("9", "90000");
INSERT INTO "city" VALUES ("10", "80000");
INSERT INTO "country" VALUES ("EUR", "Euroland", "Europe", "Western Europe", "80000");
INSERT INTO "country" VALUES ("EUN", "Eunomia", "Europe", "Northern Europe", "79999");
INSERT INTO "country" VALUES ("EUS", "Eusonia", "Europe", "Southern Europe", "80000");
INSERT INTO "country" VALUES ("ASX", "Asiana", "Asia", "Eastern Asia", "80000");
INSERT INTO "country" VALUES ("AFR", "Africana", "Africa", "Northern Africa", "80000");
INSERT INTO "country" VALUES ("EUR2", "Eurovia", "Europe", "Eastern Europe", "80001");
INSERT INTO "country" VALUES ("EUR3", "Europia", "Europe", "Central Europe", "80000");
INSERT INTO "country" VALUES ("EUR4", "Eurolandia", "Europe", "Western Europe", "79999");
INSERT INTO "country" VALUES ("EUR5", "Europica", "Europe", "Northern Europe", "80000");
INSERT INTO "country" VALUES ("EUR6", "Europistan", "Europe", "Southern Europe", "100000");
INSERT INTO "countrylanguage" VALUES ("EUR", "English", "60.0");
INSERT INTO "countrylanguage" VALUES ("EUR", "French", "40.0");
INSERT INTO "countrylanguage" VALUES ("EUN", "German", "90.0");
INSERT INTO "countrylanguage" VALUES ("EUS", "Spanish", "100.0");
INSERT INTO "countrylanguage" VALUES ("ASX", "Mandarin", "95.0");
INSERT INTO "countrylanguage" VALUES ("AFR", "Arabic", "80.0");
INSERT INTO "countrylanguage" VALUES ("EUR2", "Russian", "85.0");
INSERT INTO "countrylanguage" VALUES ("EUR3", "Polish", "70.0");
INSERT INTO "countrylanguage" VALUES ("EUR4", "Dutch", "50.0");
INSERT INTO "countrylanguage" VALUES ("EUR5", "Swedish", "100.0");
INSERT INTO "countrylanguage" VALUES ("EUR6", "Italian", "60.0");