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 "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Population" INT,
"GNP" FLOAT,
PRIMARY KEY ("Code")
);





INSERT INTO "country" VALUES ("AFG", "Asia", "22720000", "5976.00");
INSERT INTO "country" VALUES ("NLD", "Europe", "15987000", "371362.00");
INSERT INTO "country" VALUES ("ALB", "Europe", "3401200", "3205.00");
INSERT INTO "country" VALUES ("DZA", "Africa", "31471000", "49982.00");
INSERT INTO "country" VALUES ("ASM", "Oceania", "68000", "0.00");
INSERT INTO "country" VALUES ("AND", "Europe", "78000", "1630.00");
INSERT INTO "country" VALUES ("AGO", "Africa", "12878000", "6648.00");
INSERT INTO "country" VALUES ("AIA", "North America", "8000", "108.00");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "0", "0.00");
INSERT INTO "country" VALUES ("ATG", "North America", "68000", "752.00");
INSERT INTO "country" VALUES ("ARG", "South America", "37032000", "340238.00");
INSERT INTO "country" VALUES ("ARM", "Asia", "3520000", "1813.00");
INSERT INTO "country" VALUES ("ABW", "North America", "103000", "828.00");
INSERT INTO "country" VALUES ("AUS", "Oceania", "18886000", "351100.00");
INSERT INTO "country" VALUES ("AUT", "Europe", "8078900", "211860.00");
INSERT INTO "country" VALUES ("AZE", "Asia", "7734000", "4127.00");
INSERT INTO "country" VALUES ("BHS", "North America", "307000", "3527.00");
INSERT INTO "country" VALUES ("BHR", "Asia", "617000", "6366.00");
INSERT INTO "country" VALUES ("BGD", "Asia", "129155000", "32852.00");
INSERT INTO "country" VALUES ("BRB", "North America", "270000", "2223.00");
INSERT INTO "country" VALUES ("BLR", "Europe", "10236000", "13714.00");
INSERT INTO "country" VALUES ("BEL", "Europe", "10239000", "249704.00");
INSERT INTO "country" VALUES ("BLZ", "North America", "241000", "630.00");
INSERT INTO "country" VALUES ("BEN", "Africa", "6097000", "2357.00");
INSERT INTO "country" VALUES ("BMU", "North America", "65000", "2326.00");
INSERT INTO "country" VALUES ("BTN", "Asia", "2124000", "372.00");
INSERT INTO "country" VALUES ("BOL", "South America", "8329000", "8163.00");
INSERT INTO "country" VALUES ("BIH", "Europe", "3972000", "4107.00");
INSERT INTO "country" VALUES ("BWA", "Africa", "1622000", "4649.00");