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", "1000", "5");
INSERT INTO "matches" VALUES ("20", "500", "15");
INSERT INTO "matches" VALUES ("30", "200", "25");
INSERT INTO "matches" VALUES ("5", "1500", "1");
INSERT INTO "matches" VALUES ("25", "300", "10");
INSERT INTO "matches" VALUES ("1", "2000", "2");
INSERT INTO "matches" VALUES ("40", "100", "35");
INSERT INTO "matches" VALUES ("15", "700", "8");
INSERT INTO "matches" VALUES ("22", "450", "18");
INSERT INTO "matches" VALUES ("33", "180", "28");
INSERT INTO "rankings" VALUES ("1");
INSERT INTO "rankings" VALUES ("5");
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 ("35");
INSERT INTO "rankings" VALUES ("40");
INSERT INTO "rankings" VALUES ("2");