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" (
"match_num" INT,
"tourney_date" DATE,
"tourney_id" TEXT,
"year" INT
);

CREATE TABLE "rankings" (
"ranking_date" DATE
);





INSERT INTO "matches" VALUES ("1", "2016-01-01", "AUS2016", "2016");
INSERT INTO "matches" VALUES ("2", "2016-01-02", "AUS2016", "2016");
INSERT INTO "matches" VALUES ("3", "2016-01-03", "AUS2016", "2016");
INSERT INTO "matches" VALUES ("4", "2017-02-01", "FRA2017", "2017");
INSERT INTO "matches" VALUES ("5", "2017-02-02", "FRA2017", "2017");
INSERT INTO "matches" VALUES ("6", "2018-03-01", "USA2018", "2018");
INSERT INTO "matches" VALUES ("7", "2018-03-02", "USA2018", "2018");
INSERT INTO "matches" VALUES ("8", "2018-03-03", "USA2018", "2018");
INSERT INTO "matches" VALUES ("9", "2018-03-04", "USA2018", "2018");
INSERT INTO "matches" VALUES ("10", "2019-04-01", "GBR2019", "2019");
INSERT INTO "matches" VALUES ("11", "2019-04-02", "GBR2019", "2019");
INSERT INTO "matches" VALUES ("12", "2020-05-01", "CAN2020", "2020");
INSERT INTO "matches" VALUES ("13", "2020-05-02", "CAN2020", "2020");
INSERT INTO "matches" VALUES ("14", "2020-05-03", "CAN2020", "2020");
INSERT INTO "matches" VALUES ("15", "2020-05-04", "CAN2020", "2020");
INSERT INTO "matches" VALUES ("16", "2020-05-05", "CAN2020", "2020");
INSERT INTO "rankings" VALUES ("2016-01-01");
INSERT INTO "rankings" VALUES ("2017-02-01");
INSERT INTO "rankings" VALUES ("2018-03-01");
INSERT INTO "rankings" VALUES ("2019-04-01");
INSERT INTO "rankings" VALUES ("2020-05-01");