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 ("2013-01-01", "Australian Open", "2013");
INSERT INTO "matches" VALUES ("2013-01-08", "Brisbane International", "2013");
INSERT INTO "matches" VALUES ("2013-01-15", "Sydney International", "2013");
INSERT INTO "matches" VALUES ("2014-02-01", "Dubai Tennis Championships", "2014");
INSERT INTO "matches" VALUES ("2015-03-01", "Indian Wells Masters", "2015");
INSERT INTO "matches" VALUES ("2016-04-01", "Miami Open", "2016");
INSERT INTO "matches" VALUES ("2016-04-08", "Charleston Open", "2016");
INSERT INTO "matches" VALUES ("2017-05-01", "Madrid Open", "2017");
INSERT INTO "matches" VALUES ("2018-06-01", "Italian Open", "2018");
INSERT INTO "matches" VALUES ("2013-07-01", "French Open", "2013");
INSERT INTO "matches" VALUES ("2016-08-01", "Wimbledon", "2016");
INSERT INTO "matches" VALUES ("2016-09-01", "US Open", "2016");
INSERT INTO "matches" VALUES ("2013-10-01", "China Open", "2013");
INSERT INTO "matches" VALUES ("2013-11-01", "WTA Finals", "2013");
INSERT INTO "matches" VALUES ("2016-12-01", "Elite Trophy", "2016");
INSERT INTO "rankings" VALUES ("2013-01-07");
INSERT INTO "rankings" VALUES ("2013-01-14");
INSERT INTO "rankings" VALUES ("2013-01-21");
INSERT INTO "rankings" VALUES ("2014-02-03");
INSERT INTO "rankings" VALUES ("2015-03-02");
INSERT INTO "rankings" VALUES ("2016-04-04");
INSERT INTO "rankings" VALUES ("2016-04-11");
INSERT INTO "rankings" VALUES ("2017-05-08");
INSERT INTO "rankings" VALUES ("2018-06-04");
INSERT INTO "rankings" VALUES ("2013-07-01");
INSERT INTO "rankings" VALUES ("2016-08-01");
INSERT INTO "rankings" VALUES ("2016-09-05");
INSERT INTO "rankings" VALUES ("2013-10-07");
INSERT INTO "rankings" VALUES ("2013-11-04");
INSERT INTO "rankings" VALUES ("2016-12-05");