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,
"year" INT
);

CREATE TABLE "players" (
"player_id" INT,
"birth_date" DATE,
PRIMARY KEY ("player_id")
);

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





INSERT INTO "matches" VALUES ("2013-01-01", "2013");
INSERT INTO "matches" VALUES ("2013-06-15", "2013");
INSERT INTO "matches" VALUES ("2013-12-31", "2013");
INSERT INTO "matches" VALUES ("2013-12-31", "2013");
INSERT INTO "matches" VALUES ("2014-01-01", "2014");
INSERT INTO "matches" VALUES ("2015-07-20", "2015");
INSERT INTO "matches" VALUES ("2016-01-01", "2016");
INSERT INTO "matches" VALUES ("2016-03-10", "2016");
INSERT INTO "matches" VALUES ("2016-12-31", "2016");
INSERT INTO "matches" VALUES ("2016-12-31", "2016");
INSERT INTO "matches" VALUES ("2017-01-01", "2017");
INSERT INTO "matches" VALUES ("2012-12-31", "2012");