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

CREATE TABLE "poker_player" (
"Poker_Player_ID" INT,
"Earnings" FLOAT,
PRIMARY KEY ("Poker_Player_ID")
);





INSERT INTO "people" VALUES ("1", "American", "John Smith");
INSERT INTO "people" VALUES ("2", "Canadian", "Alice Johnson");
INSERT INTO "people" VALUES ("3", "British", "Robert Brown");
INSERT INTO "people" VALUES ("4", "Australian", "Emily Davis");
INSERT INTO "people" VALUES ("5", "German", "Michael Müller");
INSERT INTO "people" VALUES ("6", "French", "Sophie Martin");
INSERT INTO "people" VALUES ("7", "Brazilian", "Carlos Silva");
INSERT INTO "people" VALUES ("8", "Japanese", "Yuki Tanaka");
INSERT INTO "people" VALUES ("9", "South African", "Thabo Nkosi");
INSERT INTO "people" VALUES ("10", "Indian", "Priya Patel");
INSERT INTO "people" VALUES ("11", "Mexican", "Luis Hernandez");
INSERT INTO "people" VALUES ("12", "Russian", "Anastasia Ivanova");
INSERT INTO "people" VALUES ("13", "Irish", "Sean O'Connor");
INSERT INTO "people" VALUES ("14", "Italian", "Giulia Romano");
INSERT INTO "people" VALUES ("15", "Dutch", "Jeroen de Vries");
INSERT INTO "people" VALUES ("16", "Swedish", "Anna Svensson");
INSERT INTO "people" VALUES ("17", "Chinese", "Li Wei");
INSERT INTO "people" VALUES ("18", "New Zealander", "Olivia Wilson");
INSERT INTO "people" VALUES ("19", "Mixed American-Canadian", "David Lee");
INSERT INTO "people" VALUES ("20", "Mixed British-Australian", "Emma Clark");
INSERT INTO "people" VALUES ("21", "NULL", "Unknown Player");
INSERT INTO "people" VALUES ("22", "", "Anonymous");
INSERT INTO "people" VALUES ("23", "Norwegian", "Erik Hansen");
INSERT INTO "people" VALUES ("24", "Polish", "Katarzyna Nowak");
INSERT INTO "people" VALUES ("25", "Argentinian", "Sofia Gomez");