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 "matches" (
"loser_hand" TEXT
);

CREATE TABLE "players" (
"player_id" INT,
"first_name" TEXT,
"last_name" TEXT,
"hand" TEXT,
"birth_date" DATE,
PRIMARY KEY ("player_id")
);

CREATE TABLE "rankings" (
"ranking_points" INT
);





INSERT INTO "matches" VALUES ("L");
INSERT INTO "matches" VALUES ("R");
INSERT INTO "matches" VALUES ("L");
INSERT INTO "matches" VALUES ("R");
INSERT INTO "matches" VALUES ("L");
INSERT INTO "players" VALUES ("1", "Alice", "Smith", "L", "1990-05-12");
INSERT INTO "players" VALUES ("2", "Bob", "Johnson", "R", "1988-11-23");
INSERT INTO "players" VALUES ("3", "Clara", "Williams", "L", "1992-07-30");
INSERT INTO "players" VALUES ("4", "David", "Brown", "R", "1985-03-15");
INSERT INTO "players" VALUES ("5", "Eva", "Jones", "L", "1989-12-01");
INSERT INTO "players" VALUES ("6", "Frank", "Garcia", "R", "1991-08-20");
INSERT INTO "players" VALUES ("7", "Grace", "Miller", "L", "1987-01-05");
INSERT INTO "players" VALUES ("8", "Hank", "Davis", "R", "1993-04-10");
INSERT INTO "players" VALUES ("9", "Ivy", "Martinez", "L", "1990-05-12");
INSERT INTO "players" VALUES ("10", "Jack", "Rodriguez", "R", "1986-09-17");
INSERT INTO "rankings" VALUES ("2500");
INSERT INTO "rankings" VALUES ("1800");
INSERT INTO "rankings" VALUES ("2200");
INSERT INTO "rankings" VALUES ("3000");
INSERT INTO "rankings" VALUES ("2700");
INSERT INTO "rankings" VALUES ("1500");
INSERT INTO "rankings" VALUES ("2100");
INSERT INTO "rankings" VALUES ("1900");
INSERT INTO "rankings" VALUES ("2300");
INSERT INTO "rankings" VALUES ("1600");