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_age" FLOAT,
"loser_name" TEXT,
"winner_age" FLOAT,
"winner_name" TEXT
);

CREATE TABLE "players" (
"player_id" INT,
"birth_date" DATE,
PRIMARY KEY ("player_id")
);





INSERT INTO "matches" VALUES ("25.5", "Player A", "30.1", "Player B");
INSERT INTO "matches" VALUES ("28.0", "Player C", "22.7", "Player D");
INSERT INTO "matches" VALUES ("35.2", "Player E", "29.9", "Player F");
INSERT INTO "matches" VALUES ("21.9", "Player G", "26.3", "Player H");
INSERT INTO "matches" VALUES ("31.0", "Player I", "24.5", "Player J");
INSERT INTO "matches" VALUES ("27.8", "Player K", "33.0", "Player L");
INSERT INTO "matches" VALUES ("23.1", "Player M", "28.6", "Player N");
INSERT INTO "matches" VALUES ("29.5", "Player O", "20.0", "Player P");
INSERT INTO "matches" VALUES ("26.0", "Player Q", "31.5", "Player R");
INSERT INTO "matches" VALUES ("30.7", "Player S", "27.2", "Player T");
INSERT INTO "matches" VALUES ("24.0", "Player U", "29.0", "Player V");
INSERT INTO "matches" VALUES ("32.5", "Player W", "25.0", "Player X");
INSERT INTO "matches" VALUES ("20.5", "Player Y", "34.0", "Player Z");
INSERT INTO "matches" VALUES ("36.0", "Player AA", "21.0", "Player BB");
INSERT INTO "matches" VALUES ("22.2", "Player CC", "30.0", "Player DD");
INSERT INTO "players" VALUES ("1", "1998-05-10");
INSERT INTO "players" VALUES ("2", "1993-11-20");
INSERT INTO "players" VALUES ("3", "1995-03-15");
INSERT INTO "players" VALUES ("4", "2000-07-01");
INSERT INTO "players" VALUES ("5", "1988-09-25");
INSERT INTO "players" VALUES ("6", "1994-01-05");
INSERT INTO "players" VALUES ("7", "2001-04-12");
INSERT INTO "players" VALUES ("8", "1997-08-30");
INSERT INTO "players" VALUES ("9", "1992-02-18");
INSERT INTO "players" VALUES ("10", "1999-06-03");
INSERT INTO "players" VALUES ("11", "1996-10-08");
INSERT INTO "players" VALUES ("12", "1991-12-22");
INSERT INTO "players" VALUES ("13", "2002-01-28");
INSERT INTO "players" VALUES ("14", "1987-07-07");
INSERT INTO "players" VALUES ("15", "2000-09-14");