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,
"loser_rank" INT,
"winner_age" FLOAT,
"winner_name" TEXT,
"winner_rank" INT
);





INSERT INTO "matches" VALUES ("25.1", "PlayerA", "50", "20.5", "WinnerX", "10");
INSERT INTO "matches" VALUES ("28.3", "PlayerB", "30", "22.1", "WinnerY", "5");
INSERT INTO "matches" VALUES ("30.0", "PlayerC", "70", "19.8", "WinnerZ", "15");
INSERT INTO "matches" VALUES ("22.0", "PlayerD", "10", "21.0", "WinnerA", "20");
INSERT INTO "matches" VALUES ("26.5", "PlayerE", "40", "23.7", "WinnerB", "8");
INSERT INTO "matches" VALUES ("35.2", "PlayerF", "60", "20.0", "WinnerC", "12");
INSERT INTO "matches" VALUES ("29.1", "PlayerG", "25", "24.5", "WinnerD", "3");
INSERT INTO "matches" VALUES ("21.5", "PlayerH", "80", "18.9", "WinnerE", "25");
INSERT INTO "matches" VALUES ("27.8", "PlayerI", "35", "26.0", "WinnerF", "7");
INSERT INTO "matches" VALUES ("31.9", "PlayerJ", "45", "22.9", "WinnerG", "18");
INSERT INTO "matches" VALUES ("24.0", "PlayerK", "55", "19.5", "WinnerH", "11");
INSERT INTO "matches" VALUES ("23.3", "PlayerL", "65", "21.8", "WinnerI", "14");
INSERT INTO "matches" VALUES ("20.0", "PlayerM", "90", "17.5", "WinnerJ", "30");
INSERT INTO "matches" VALUES ("28.0", "PlayerN", "20", "25.0", "WinnerK", "2");
INSERT INTO "matches" VALUES ("33.0", "PlayerO", "75", "20.2", "WinnerL", "16");