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

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





INSERT INTO "matches" VALUES ("2016-01-01", "Brisbane International", "2016");
INSERT INTO "matches" VALUES ("2016-01-02", "Brisbane International", "2016");
INSERT INTO "matches" VALUES ("2016-01-03", "Brisbane International", "2016");
INSERT INTO "matches" VALUES ("2016-01-04", "Sydney International", "2016");
INSERT INTO "matches" VALUES ("2016-01-05", "Sydney International", "2016");
INSERT INTO "matches" VALUES ("2017-02-01", "Dubai Tennis Championships", "2017");
INSERT INTO "matches" VALUES ("2017-02-02", "Dubai Tennis Championships", "2017");
INSERT INTO "matches" VALUES ("2017-02-03", "Qatar Open", "2017");
INSERT INTO "matches" VALUES ("2018-03-01", "Indian Wells Masters", "2018");
INSERT INTO "matches" VALUES ("2018-03-02", "Indian Wells Masters", "2018");
INSERT INTO "matches" VALUES ("2018-03-03", "Miami Open", "2018");
INSERT INTO "matches" VALUES ("2018-03-04", "Miami Open", "2018");
INSERT INTO "matches" VALUES ("2018-03-05", "Miami Open", "2018");
INSERT INTO "matches" VALUES ("2019-04-01", "Madrid Open", "2019");
INSERT INTO "matches" VALUES ("2019-04-02", "Madrid Open", "2019");
INSERT INTO "rankings" VALUES ("2016-01-01");
INSERT INTO "rankings" VALUES ("2016-01-08");
INSERT INTO "rankings" VALUES ("2017-02-01");
INSERT INTO "rankings" VALUES ("2017-02-08");
INSERT INTO "rankings" VALUES ("2018-03-01");
INSERT INTO "rankings" VALUES ("2018-03-08");
INSERT INTO "rankings" VALUES ("2019-04-01");