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,
"tourney_name" TEXT,
"winner_name" TEXT
);





INSERT INTO "matches" VALUES ("1", "2023-01-01", "AUSOPEN2023", "Australian Open", "Aryna Sabalenka");
INSERT INTO "matches" VALUES ("2", "2023-01-02", "AUSOPEN2023", "Australian Open", "Elena Rybakina");
INSERT INTO "matches" VALUES ("3", "2023-01-03", "AUSOPEN2023", "Australian Open", "Victoria Azarenka");
INSERT INTO "matches" VALUES ("4", "2023-01-04", "AUSOPEN2023", "Australian Open", "Magda Linette");
INSERT INTO "matches" VALUES ("5", "2023-01-05", "AUSOPEN2023", "Australian Open", "Karolina Pliskova");
INSERT INTO "matches" VALUES ("6", "2023-01-06", "AUSOPEN2023", "Australian Open", "Donna Vekic");
INSERT INTO "matches" VALUES ("7", "2023-01-07", "AUSOPEN2023", "Australian Open", "Belinda Bencic");
INSERT INTO "matches" VALUES ("8", "2023-01-08", "AUSOPEN2023", "Australian Open", "Caroline Garcia");
INSERT INTO "matches" VALUES ("9", "2023-01-09", "AUSOPEN2023", "Australian Open", "Jessica Pegula");
INSERT INTO "matches" VALUES ("10", "2023-01-10", "AUSOPEN2023", "Australian Open", "Coco Gauff");
INSERT INTO "matches" VALUES ("11", "2023-01-11", "AUSOPEN2023", "Australian Open", "Iga Swiatek");
INSERT INTO "matches" VALUES ("12", "2023-01-12", "AUSOPEN2023", "Australian Open", "Ons Jabeur");
INSERT INTO "matches" VALUES ("1", "2023-02-01", "DUBAI2023", "Dubai Tennis Championships", "Barbora Krejcikova");
INSERT INTO "matches" VALUES ("2", "2023-02-02", "DUBAI2023", "Dubai Tennis Championships", "Iga Swiatek");
INSERT INTO "matches" VALUES ("3", "2023-02-03", "DUBAI2023", "Dubai Tennis Championships", "Jessica Pegula");
INSERT INTO "matches" VALUES ("4", "2023-02-04", "DUBAI2023", "Dubai Tennis Championships", "Coco Gauff");
INSERT INTO "matches" VALUES ("5", "2023-02-05", "DUBAI2023", "Dubai Tennis Championships", "Aryna Sabalenka");
INSERT INTO "matches" VALUES ("6", "2023-02-06", "DUBAI2023", "Dubai Tennis Championships", "Elena Rybakina");
INSERT INTO "matches" VALUES ("7", "2023-02-07", "DUBAI2023", "Dubai Tennis Championships", "Belinda Bencic");
INSERT INTO "matches" VALUES ("8", "2023-02-08", "DUBAI2023", "Dubai Tennis Championships", "Karolina Muchova");
INSERT INTO "matches" VALUES ("1", "2023-03-01", "INDIANWELLS2023", "Indian Wells Open", "Elena Rybakina");
INSERT INTO "matches" VALUES ("2", "2023-03-02", "INDIANWELLS2023", "Indian Wells Open", "Aryna Sabalenka");
INSERT INTO "matches" VALUES ("3", "2023-03-03", "INDIANWELLS2023", "Indian Wells Open", "Iga Swiatek");
INSERT INTO "matches" VALUES ("4", "2023-03-04", "INDIANWELLS2023", "Indian Wells Open", "Maria Sakkari");
INSERT INTO "matches" VALUES ("5", "2023-03-05", "INDIANWELLS2023", "Indian Wells Open", "Coco Gauff");
INSERT INTO "matches" VALUES ("6", "2023-03-06", "INDIANWELLS2023", "Indian Wells Open", "Ons Jabeur");
INSERT INTO "matches" VALUES ("7", "2023-03-07", "INDIANWELLS2023", "Indian Wells Open", "Caroline Garcia");
INSERT INTO "matches" VALUES ("8", "2023-03-08", "INDIANWELLS2023", "Indian Wells Open", "Petra Kvitova");
INSERT INTO "matches" VALUES ("9", "2023-03-09", "INDIANWELLS2023", "Indian Wells Open", "Jessica Pegula");
INSERT INTO "matches" VALUES ("10", "2023-03-10", "INDIANWELLS2023", "Indian Wells Open", "Marketa Vondrousova");
INSERT INTO "matches" VALUES ("11", "2023-03-11", "INDIANWELLS2023", "Indian Wells Open", "Sorana Cirstea");
INSERT INTO "matches" VALUES ("12", "2023-03-12", "INDIANWELLS2023", "Indian Wells Open", "Beatriz Haddad Maia");
INSERT INTO "matches" VALUES ("13", "2023-03-13", "INDIANWELLS2023", "Indian Wells Open", "Elena Rybakina");
INSERT INTO "matches" VALUES ("1", "2023-04-01", "MIAMI2023", "Miami Open", "Petra Kvitova");
INSERT INTO "matches" VALUES ("2", "2023-04-02", "MIAMI2023", "Miami Open", "Elena Rybakina");
INSERT INTO "matches" VALUES ("3", "2023-04-03", "MIAMI2023", "Miami Open", "Jessica Pegula");
INSERT INTO "matches" VALUES ("4", "2023-04-04", "MIAMI2023", "Miami Open", "Aryna Sabalenka");
INSERT INTO "matches" VALUES ("5", "2023-04-05", "MIAMI2023", "Miami Open", "Sorana Cirstea");
INSERT INTO "matches" VALUES ("6", "2023-04-06", "MIAMI2023", "Miami Open", "Ekaterina Alexandrova");
INSERT INTO "matches" VALUES ("7", "2023-04-07", "MIAMI2023", "Miami Open", "Martina Trevisan");
INSERT INTO "matches" VALUES ("8", "2023-04-08", "MIAMI2023", "Miami Open", "Bianca Andreescu");
INSERT INTO "matches" VALUES ("9", "2023-04-09", "MIAMI2023", "Miami Open", "Barbora Krejcikova");
INSERT INTO "matches" VALUES ("10", "2023-04-10", "MIAMI2023", "Miami Open", "Coco Gauff");
INSERT INTO "matches" VALUES ("11", "2023-04-11", "MIAMI2023", "Miami Open", "Ons Jabeur");
INSERT INTO "matches" VALUES ("12", "2023-04-12", "MIAMI2023", "Miami Open", "Iga Swiatek");
INSERT INTO "matches" VALUES ("13", "2023-04-13", "MIAMI2023", "Miami Open", "Caroline Garcia");
INSERT INTO "matches" VALUES ("14", "2023-04-14", "MIAMI2023", "Miami Open", "Petra Kvitova");
INSERT INTO "matches" VALUES ("1", "2023-05-01", "MADRID2023", "Madrid Open", "Aryna Sabalenka");
INSERT INTO "matches" VALUES ("2", "2023-05-02", "MADRID2023", "Madrid Open", "Iga Swiatek");
INSERT INTO "matches" VALUES ("3", "2023-05-03", "MADRID2023", "Madrid Open", "Jessica Pegula");
INSERT INTO "matches" VALUES ("4", "2023-05-04", "MADRID2023", "Madrid Open", "Ons Jabeur");
INSERT INTO "matches" VALUES ("5", "2023-05-05", "MADRID2023", "Madrid Open", "Elena Rybakina");
INSERT INTO "matches" VALUES ("6", "2023-05-06", "MADRID2023", "Madrid Open", "Coco Gauff");
INSERT INTO "matches" VALUES ("7", "2023-05-07", "MADRID2023", "Madrid Open", "Caroline Garcia");
INSERT INTO "matches" VALUES ("8", "2023-05-08", "MADRID2023", "Madrid Open", "Maria Sakkari");
INSERT INTO "matches" VALUES ("9", "2023-05-09", "MADRID2023", "Madrid Open", "Veronika Kudermetova");
INSERT INTO "matches" VALUES ("10", "2023-05-10", "MADRID2023", "Madrid Open", "Daria Kasatkina");
INSERT INTO "matches" VALUES ("11", "2023-05-11", "MADRID2023", "Madrid Open", "Paula Badosa");
INSERT INTO "matches" VALUES ("12", "2023-05-12", "MADRID2023", "Madrid Open", "Victoria Azarenka");
INSERT INTO "matches" VALUES ("13", "2023-05-13", "MADRID2023", "Madrid Open", "Aryna Sabalenka");
INSERT INTO "matches" VALUES ("14", "2023-05-14", "MADRID2023", "Madrid Open", "Iga Swiatek");
INSERT INTO "matches" VALUES ("15", "2023-05-15", "MADRID2023", "Madrid Open", "Jessica Pegula");