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),
"Continent" TEXT,
"Population" INT,
"LifeExpectancy" FLOAT,
"GovernmentForm" CHAR(45),
PRIMARY KEY ("Code")
);

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





INSERT INTO "city" VALUES ("1", "500000");
INSERT INTO "city" VALUES ("2", "1200000");
INSERT INTO "city" VALUES ("3", "300000");
INSERT INTO "city" VALUES ("4", "800000");
INSERT INTO "city" VALUES ("5", "450000");
INSERT INTO "city" VALUES ("6", "1000000");
INSERT INTO "city" VALUES ("7", "200000");
INSERT INTO "city" VALUES ("8", "750000");
INSERT INTO "city" VALUES ("9", "600000");
INSERT INTO "city" VALUES ("10", "900000");
INSERT INTO "country" VALUES ("AFR", "Africa", "30000000", "62.5", "Republic");
INSERT INTO "country" VALUES ("AFS", "Africa", "15000000", "58.3", "Republic");
INSERT INTO "country" VALUES ("AFN", "Africa", "25000000", "65.0", "Monarchy");
INSERT INTO "country" VALUES ("AFE", "Africa", "10000000", "55.2", "Republic");
INSERT INTO "country" VALUES ("AFW", "Africa", "5000000", "70.1", "Republic");
INSERT INTO "country" VALUES ("AFG", "Africa", "20000000", "50.0", "Monarchy");
INSERT INTO "country" VALUES ("EUR", "Europe", "40000000", "78.5", "Republic");
INSERT INTO "country" VALUES ("ASA", "Asia", "35000000", "72.0", "Republic");
INSERT INTO "country" VALUES ("AFX", "Africa", "12000000", "60.0", "Republic");
INSERT INTO "country" VALUES ("AFY", "Africa", "8000000", "54.5", "Monarchy");
INSERT INTO "countrylanguage" VALUES ("AFR", "English", "60.0");
INSERT INTO "countrylanguage" VALUES ("AFR", "French", "30.0");
INSERT INTO "countrylanguage" VALUES ("AFS", "Arabic", "80.0");
INSERT INTO "countrylanguage" VALUES ("AFS", "English", "15.0");
INSERT INTO "countrylanguage" VALUES ("AFN", "Swahili", "90.0");
INSERT INTO "countrylanguage" VALUES ("AFE", "Zulu", "70.0");
INSERT INTO "countrylanguage" VALUES ("AFE", "English", "20.0");
INSERT INTO "countrylanguage" VALUES ("AFW", "French", "50.0");
INSERT INTO "countrylanguage" VALUES ("AFW", "English", "40.0");
INSERT INTO "countrylanguage" VALUES ("AFG", "Arabic", "60.0");
INSERT INTO "countrylanguage" VALUES ("EUR", "English", "90.0");
INSERT INTO "countrylanguage" VALUES ("ASA", "Hindi", "85.0");
INSERT INTO "countrylanguage" VALUES ("AFX", "French", "75.0");
INSERT INTO "countrylanguage" VALUES ("AFX", "English", "20.0");
INSERT INTO "countrylanguage" VALUES ("AFY", "Zulu", "65.0");