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 "people" (
"People_ID" INT UNIQUE,
"Nationality" TEXT,
PRIMARY KEY ("People_ID")
);

CREATE TABLE "poker_player" (
"Poker_Player_ID" INT,
"People_ID" INT,
"Money_Rank" FLOAT,
"Earnings" FLOAT,
PRIMARY KEY ("Poker_Player_ID"),
FOREIGN KEY ("People_ID") REFERENCES "people"("People_ID")
);





INSERT INTO "people" VALUES ("1", "United States");
INSERT INTO "people" VALUES ("2", "Brazil");
INSERT INTO "people" VALUES ("3", "France");
INSERT INTO "people" VALUES ("4", "México");
INSERT INTO "people" VALUES ("5", "South Korea");
INSERT INTO "people" VALUES ("6", "United Kingdom");
INSERT INTO "people" VALUES ("7", "Canada");
INSERT INTO "people" VALUES ("8", "Australia");
INSERT INTO "people" VALUES ("9", "New Zealand");
INSERT INTO "people" VALUES ("10", "Germany");
INSERT INTO "people" VALUES ("11", "Argentina");
INSERT INTO "people" VALUES ("12", "España");
INSERT INTO "people" VALUES ("13", "Italy");
INSERT INTO "people" VALUES ("14", "Ireland");
INSERT INTO "people" VALUES ("15", "Côte d'Ivoire");
INSERT INTO "people" VALUES ("16", "United Arab Emirates");
INSERT INTO "people" VALUES ("17", "South Africa");
INSERT INTO "people" VALUES ("18", "null");
INSERT INTO "people" VALUES ("19", "Puerto Rico");
INSERT INTO "people" VALUES ("20", "New Caledonia");
INSERT INTO "poker_player" VALUES ("1", "1", "1", "15000000");
INSERT INTO "poker_player" VALUES ("2", "2", "5", "3500000");
INSERT INTO "poker_player" VALUES ("3", "3", "3", "7000000");
INSERT INTO "poker_player" VALUES ("4", "4", "10", "1200000");
INSERT INTO "poker_player" VALUES ("5", "5", "7", "2500000");
INSERT INTO "poker_player" VALUES ("6", "6", "2", "9000000");
INSERT INTO "poker_player" VALUES ("7", "7", "15", "800000");
INSERT INTO "poker_player" VALUES ("8", "8", "20", "500000");
INSERT INTO "poker_player" VALUES ("9", "9", "12", "1100000");
INSERT INTO "poker_player" VALUES ("10", "10", "8", "2000000");
INSERT INTO "poker_player" VALUES ("11", "11", "18", "600000");
INSERT INTO "poker_player" VALUES ("12", "12", "4", "6000000");
INSERT INTO "poker_player" VALUES ("13", "13", "6", "3000000");
INSERT INTO "poker_player" VALUES ("14", "14", "9", "1500000");
INSERT INTO "poker_player" VALUES ("15", "15", "11", "1000000");
INSERT INTO "poker_player" VALUES ("16", "16", "13", "900000");
INSERT INTO "poker_player" VALUES ("17", "17", "14", "850000");
INSERT INTO "poker_player" VALUES ("18", "18", "16", "700000");
INSERT INTO "poker_player" VALUES ("19", "19", "17", "650000");
INSERT INTO "poker_player" VALUES ("20", "20", "19", "400000");