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

CREATE TABLE "players" (
"player_id" INT,
"country_code" TEXT,
PRIMARY KEY ("player_id")
);





INSERT INTO "matches" VALUES ("PlayerA", "120", "2023-01-15", "Australian Open", "PlayerB");
INSERT INTO "matches" VALUES ("PlayerC", "180", "2023-02-20", "French Open", "PlayerD");
INSERT INTO "matches" VALUES ("PlayerE", "180", "2023-03-10", "Wimbledon", "PlayerF");
INSERT INTO "matches" VALUES ("PlayerG", "90", "2023-04-05", "US Open", "PlayerH");
INSERT INTO "matches" VALUES ("PlayerI", "200", "2023-05-12", "Miami Open", "PlayerJ");
INSERT INTO "matches" VALUES ("PlayerK", "150", "2023-06-01", "Madrid Open", "PlayerL");
INSERT INTO "matches" VALUES ("PlayerM", "200", "2023-07-18", "Cincinnati Open", "PlayerN");
INSERT INTO "matches" VALUES ("PlayerO", "199", "2023-08-25", "Rome Masters", "PlayerP");
INSERT INTO "matches" VALUES ("PlayerQ", "201", "2023-09-01", "Shanghai Masters", "PlayerR");
INSERT INTO "matches" VALUES ("PlayerS", "100", "2023-10-10", "Paris Masters", "PlayerT");