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





INSERT INTO "city" VALUES ("1", "Springfield", "30000");
INSERT INTO "city" VALUES ("2", "Shelbyville", "25000");
INSERT INTO "city" VALUES ("3", "Ogdenville", "15000");
INSERT INTO "city" VALUES ("4", "North Haverbrook", "10000");
INSERT INTO "city" VALUES ("5", "Capital City", "500000");
INSERT INTO "city" VALUES ("6", "Smallville", "12000");
INSERT INTO "city" VALUES ("7", "Metropolis", "1000000");
INSERT INTO "city" VALUES ("8", "Gotham", "800000");
INSERT INTO "city" VALUES ("9", "Star City", "600000");
INSERT INTO "city" VALUES ("10", "Coast City", "400000");
INSERT INTO "country" VALUES ("AAA", "CountryA", "Region1", "45000");
INSERT INTO "country" VALUES ("BBB", "CountryB", "Region1", "1200000");
INSERT INTO "country" VALUES ("CCC", "CountryC", "Region2", "30000");
INSERT INTO "country" VALUES ("DDD", "CountryD", "Region2", "15000");
INSERT INTO "country" VALUES ("EEE", "CountryE", "Region3", "700000");
INSERT INTO "country" VALUES ("FFF", "CountryF", "Region3", "10000");
INSERT INTO "country" VALUES ("GGG", "CountryG", "Region4", "200000");
INSERT INTO "country" VALUES ("HHH", "CountryH", "Region4", "5000");
INSERT INTO "country" VALUES ("III", "CountryI", "Region5", "25000");
INSERT INTO "country" VALUES ("JJJ", "CountryJ", "Region5", "9000");