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),
"District" CHAR(20),
PRIMARY KEY ("ID")
);

CREATE TABLE "country" (
"Code" CHAR(3) UNIQUE,
"Name" CHAR(52),
"Region" CHAR(26),
"Population" INT,
"GNP" FLOAT,
"LocalName" CHAR(45),
"GovernmentForm" CHAR(45),
PRIMARY KEY ("Code")
);

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





INSERT INTO "city" VALUES ("1", "New York", "New York");
INSERT INTO "city" VALUES ("2", "Los Angeles", "California");
INSERT INTO "city" VALUES ("3", "Chicago", "Illinois");
INSERT INTO "city" VALUES ("4", "Houston", "Texas");
INSERT INTO "city" VALUES ("5", "Phoenix", "Arizona");
INSERT INTO "city" VALUES ("6", "San Antonio", "Texas");
INSERT INTO "city" VALUES ("7", "Philadelphia", "Pennsylvania");
INSERT INTO "city" VALUES ("8", "Dallas", "Texas");
INSERT INTO "city" VALUES ("9", "San Jose", "California");
INSERT INTO "city" VALUES ("10", "Austin", "Texas");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "331000000", "21433226.0", "United States", "Federal Republic");
INSERT INTO "country" VALUES ("GUM", "Guam", "Micronesia", "168000", "5790.0", "Guam", "Territory of the US");
INSERT INTO "country" VALUES ("PRI", "Puerto Rico", "Caribbean", "3194000", "103100.0", "Puerto Rico", "Commonwealth of the US");
INSERT INTO "country" VALUES ("VIR", "U.S. Virgin Islands", "Caribbean", "104000", "3700.0", "United States Virgin Islands", "Territory of the US");
INSERT INTO "country" VALUES ("ASM", "American Samoa", "Polynesia", "55000", "630.0", "American Samoa", "Territory of the US");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "128000000", "1269000.0", "Estados Unidos Mexicanos", "Federal Republic");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "38000000", "1736000.0", "Canada", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("CUB", "Cuba", "Caribbean", "11300000", "100000.0", "Cuba", "Socialist Republic");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "Caribbean", "2900000", "16000.0", "Jamaica", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "Caribbean", "10800000", "88000.0", "República Dominicana", "Republic");
INSERT INTO "countrylanguage" VALUES ("USA", "English");
INSERT INTO "countrylanguage" VALUES ("USA", "Spanish");
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 ("ASM", "Samoan");
INSERT INTO "countrylanguage" VALUES ("ASM", "English");
INSERT INTO "countrylanguage" VALUES ("MEX", "Spanish");
INSERT INTO "countrylanguage" VALUES ("CAN", "English");
INSERT INTO "countrylanguage" VALUES ("CAN", "French");
INSERT INTO "countrylanguage" VALUES ("CUB", "Spanish");
INSERT INTO "countrylanguage" VALUES ("JAM", "English");
INSERT INTO "countrylanguage" VALUES ("DOM", "Spanish");