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

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





INSERT INTO "people" VALUES ("1", "Russia", "Ivan Petrov", "1985-07-12");
INSERT INTO "people" VALUES ("2", "United States", "John Smith", "1990-03-22");
INSERT INTO "people" VALUES ("3", "Canada", "Emily Johnson", "1988-11-05");
INSERT INTO "people" VALUES ("4", "Russia", "Dmitry Ivanov", "1979-01-30");
INSERT INTO "people" VALUES ("5", "Brazil", "Carlos Silva", "1992-06-17");
INSERT INTO "people" VALUES ("6", "Germany", "Anna Müller", "1983-09-09");
INSERT INTO "people" VALUES ("7", "Russia", "Olga Sokolova", "1995-12-25");
INSERT INTO "people" VALUES ("8", "Australia", "Liam Brown", "1987-04-14");
INSERT INTO "people" VALUES ("9", "France", "Sophie Dubois", "1991-08-03");
INSERT INTO "people" VALUES ("10", "Russia", "Alexei Smirnov", "1980-05-20");
INSERT INTO "poker_player" VALUES ("1", "3", "150000.00");
INSERT INTO "poker_player" VALUES ("2", "5", "500000.00");
INSERT INTO "poker_player" VALUES ("3", "2", "120000.00");
INSERT INTO "poker_player" VALUES ("4", "4", "300000.00");
INSERT INTO "poker_player" VALUES ("5", "1", "80000.00");
INSERT INTO "poker_player" VALUES ("6", "6", "600000.00");
INSERT INTO "poker_player" VALUES ("7", "0", "20000.00");
INSERT INTO "poker_player" VALUES ("8", "3", "250000.00");
INSERT INTO "poker_player" VALUES ("9", "2", "100000.00");
INSERT INTO "poker_player" VALUES ("10", "5", "450000.00");