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", "2018-01-15", "AUS2018", "2018");
INSERT INTO "matches" VALUES ("2", "2018-01-16", "AUS2018", "2018");
INSERT INTO "matches" VALUES ("3", "2018-01-17", "AUS2018", "2018");
INSERT INTO "matches" VALUES ("4", "2019-02-01", "FRA2019", "2019");
INSERT INTO "matches" VALUES ("5", "2019-02-02", "FRA2019", "2019");
INSERT INTO "matches" VALUES ("6", "2020-03-10", "USA2020", "2020");
INSERT INTO "matches" VALUES ("7", "2020-03-11", "USA2020", "2020");
INSERT INTO "matches" VALUES ("8", "2020-03-12", "USA2020", "2020");
INSERT INTO "matches" VALUES ("9", "2020-03-13", "USA2020", "2020");
INSERT INTO "matches" VALUES ("10", "2021-04-05", "GBR2021", "2021");
INSERT INTO "matches" VALUES ("11", "2021-04-06", "GBR2021", "2021");
INSERT INTO "matches" VALUES ("12", "2022-05-20", "ITA2022", "2022");
INSERT INTO "matches" VALUES ("13", "2022-05-21", "ITA2022", "2022");
INSERT INTO "matches" VALUES ("14", "2022-05-22", "ITA2022", "2022");
INSERT INTO "matches" VALUES ("15", "2022-05-23", "ITA2022", "2022");
INSERT INTO "matches" VALUES ("16", "2022-05-24", "ITA2022", "2022");
INSERT INTO "rankings" VALUES ("2018-01-01");
INSERT INTO "rankings" VALUES ("2019-01-01");
INSERT INTO "rankings" VALUES ("2020-01-01");
INSERT INTO "rankings" VALUES ("2021-01-01");
INSERT INTO "rankings" VALUES ("2022-01-01");