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 ("101", "2013-01-15", "AUS01", "2013");
INSERT INTO "matches" VALUES ("102", "2013-01-16", "AUS01", "2013");
INSERT INTO "matches" VALUES ("103", "2014-02-20", "FRA02", "2014");
INSERT INTO "matches" VALUES ("104", "2015-03-10", "USA03", "2015");
INSERT INTO "matches" VALUES ("105", "2016-04-05", "GBR04", "2016");
INSERT INTO "matches" VALUES ("106", "2016-04-06", "GBR04", "2016");
INSERT INTO "matches" VALUES ("107", "2017-05-12", "CAN05", "2017");
INSERT INTO "matches" VALUES ("108", "2013-06-01", "GER06", "2013");
INSERT INTO "matches" VALUES ("109", "2016-07-22", "ITA07", "2016");
INSERT INTO "matches" VALUES ("110", "2018-08-18", "ESP08", "2018");
INSERT INTO "rankings" VALUES ("2013-01-01");
INSERT INTO "rankings" VALUES ("2013-02-01");
INSERT INTO "rankings" VALUES ("2014-01-01");
INSERT INTO "rankings" VALUES ("2015-01-01");
INSERT INTO "rankings" VALUES ("2016-01-01");
INSERT INTO "rankings" VALUES ("2016-02-01");
INSERT INTO "rankings" VALUES ("2017-01-01");
INSERT INTO "rankings" VALUES ("2018-01-01");