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

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





INSERT INTO "matches" VALUES ("10", "1500", "5");
INSERT INTO "matches" VALUES ("20", "1000", "8");
INSERT INTO "matches" VALUES ("5", "2000", "2");
INSERT INTO "matches" VALUES ("15", "1200", "7");
INSERT INTO "matches" VALUES ("30", "800", "12");
INSERT INTO "matches" VALUES ("1", "3000", "1");
INSERT INTO "matches" VALUES ("25", "900", "10");
INSERT INTO "matches" VALUES ("2", "2500", "1");
INSERT INTO "matches" VALUES ("18", "1100", "6");
INSERT INTO "matches" VALUES ("40", "500", "20");
INSERT INTO "rankings" VALUES ("1");
INSERT INTO "rankings" VALUES ("2");
INSERT INTO "rankings" VALUES ("5");
INSERT INTO "rankings" VALUES ("8");
INSERT INTO "rankings" VALUES ("10");
INSERT INTO "rankings" VALUES ("15");
INSERT INTO "rankings" VALUES ("20");
INSERT INTO "rankings" VALUES ("25");
INSERT INTO "rankings" VALUES ("30");
INSERT INTO "rankings" VALUES ("40");