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_rank" INT,
"winner_rank" INT,
"winner_rank_points" INT
);

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





INSERT INTO "matches" VALUES ("50", "10", "1500");
INSERT INTO "matches" VALUES ("30", "5", "2000");
INSERT INTO "matches" VALUES ("100", "20", "800");
INSERT INTO "matches" VALUES ("15", "3", "3000");
INSERT INTO "matches" VALUES ("70", "40", "600");
INSERT INTO "matches" VALUES ("25", "8", "1800");
INSERT INTO "matches" VALUES ("60", "12", "1200");
INSERT INTO "matches" VALUES ("90", "25", "700");
INSERT INTO "matches" VALUES ("45", "7", "2200");
INSERT INTO "matches" VALUES ("80", "18", "900");
INSERT INTO "matches" VALUES ("120", "50", "500");
INSERT INTO "matches" VALUES ("5", "1", "5000");
INSERT INTO "matches" VALUES ("200", "150", "100");
INSERT INTO "matches" VALUES ("1", "2", "2500");
INSERT INTO "matches" VALUES ("10", "1", "4000");
INSERT INTO "rankings" VALUES ("1");
INSERT INTO "rankings" VALUES ("3");
INSERT INTO "rankings" VALUES ("5");
INSERT INTO "rankings" VALUES ("7");
INSERT INTO "rankings" VALUES ("8");
INSERT INTO "rankings" VALUES ("10");
INSERT INTO "rankings" VALUES ("12");
INSERT INTO "rankings" VALUES ("18");
INSERT INTO "rankings" VALUES ("20");
INSERT INTO "rankings" VALUES ("25");
INSERT INTO "rankings" VALUES ("40");
INSERT INTO "rankings" VALUES ("50");
INSERT INTO "rankings" VALUES ("150");