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) UNIQUE,
"Name" CHAR(52),
"Region" CHAR(26),
"Population" INT,
"GNP" FLOAT,
"GovernmentForm" CHAR(45),
"HeadOfState" CHAR(60),
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
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", "450000");
INSERT INTO "city" VALUES ("5", "800000");
INSERT INTO "city" VALUES ("6", "150000");
INSERT INTO "city" VALUES ("7", "200000");
INSERT INTO "city" VALUES ("8", "100000");
INSERT INTO "city" VALUES ("9", "600000");
INSERT INTO "city" VALUES ("10", "250000");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "331000000", "21433226.0", "Federal Republic", "Joe Biden");
INSERT INTO "country" VALUES ("GUM", "Guam", "Oceania", "168000", "5000.0", "US Territory", "Joe Biden");
INSERT INTO "country" VALUES ("PRI", "Puerto Rico", "Caribbean", "3200000", "10400.0", "US Territory", "Joe Biden");
INSERT INTO "country" VALUES ("VIR", "US Virgin Islands", "Caribbean", "104000", "3500.0", "US Territory", "Joe Biden");
INSERT INTO "country" VALUES ("MNP", "Northern Mariana Islands", "Oceania", "57000", "2000.0", "US Territory", "Joe Biden");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "37590000", "1736426.0", "Constitutional Monarchy", "Charles III");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "128900000", "1220700.0", "Federal Republic", "Andrés Manuel López Obrador");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "67060000", "2715518.0", "Republic", "Emmanuel Macron");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "Oceania", "11000", "40.0", "Constitutional Monarchy", "Charles III");
INSERT INTO "country" VALUES ("CUB", "Cuba", "Caribbean", "11300000", "100000.0", "Communist State", "Miguel Díaz-Canel");
INSERT INTO "countrylanguage" VALUES ("USA", "English");
INSERT INTO "countrylanguage" VALUES ("GUM", "English");
INSERT INTO "countrylanguage" VALUES ("GUM", "Chamorro");
INSERT INTO "countrylanguage" VALUES ("PRI", "Spanish");
INSERT INTO "countrylanguage" VALUES ("PRI", "English");
INSERT INTO "countrylanguage" VALUES ("VIR", "English");
INSERT INTO "countrylanguage" VALUES ("MNP", "English");
INSERT INTO "countrylanguage" VALUES ("CAN", "English");
INSERT INTO "countrylanguage" VALUES ("CAN", "French");
INSERT INTO "countrylanguage" VALUES ("MEX", "Spanish");
INSERT INTO "countrylanguage" VALUES ("FRA", "French");
INSERT INTO "countrylanguage" VALUES ("TUV", "Tuvaluan");
INSERT INTO "countrylanguage" VALUES ("CUB", "Spanish");