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 "Match" (
"id" INT,
"home_player_1" INT,
PRIMARY KEY ("id")
);

CREATE TABLE "Player" (
"id" INT,
"birthday" TEXT,
"height" INT,
"weight" INT,
PRIMARY KEY ("id")
);

CREATE TABLE "Player_Attributes" (
"id" INT,
"overall_rating" INT,
PRIMARY KEY ("id")
);



INSERT INTO "Player" VALUES ("1", "1989-12-31 23:59:59", "180", "75");
INSERT INTO "Player" VALUES ("2", "1990-01-01 00:00:00", "175", "70");
INSERT INTO "Player" VALUES ("3", "1992-06-15 12:00:00", "182", "78");
INSERT INTO "Player" VALUES ("4", "1994-11-30 08:30:00", "178", "72");
INSERT INTO "Player" VALUES ("5", "1995-12-31 23:59:59", "185", "80");
INSERT INTO "Player" VALUES ("6", "1996-01-01 00:00:00", "177", "74");
INSERT INTO "Player" VALUES ("7", "1985-05-20 14:00:00", "170", "68");
INSERT INTO "Player" VALUES ("8", "1993-03-10 09:45:00", "190", "85");
INSERT INTO "Player" VALUES ("9", "1991-07-22 16:20:00", "165", "65");
INSERT INTO "Player" VALUES ("10", "1990-12-01 11:11:11", "172", "69");
INSERT INTO "Player_Attributes" VALUES ("1", "75");
INSERT INTO "Player_Attributes" VALUES ("2", "80");
INSERT INTO "Player_Attributes" VALUES ("3", "85");
INSERT INTO "Player_Attributes" VALUES ("4", "78");
INSERT INTO "Player_Attributes" VALUES ("5", "90");
INSERT INTO "Player_Attributes" VALUES ("6", "70");
INSERT INTO "Player_Attributes" VALUES ("7", "65");
INSERT INTO "Player_Attributes" VALUES ("8", "88");
INSERT INTO "Player_Attributes" VALUES ("9", "72");
INSERT INTO "Player_Attributes" VALUES ("10", "77");
INSERT INTO "Match" VALUES ("1", "2");
INSERT INTO "Match" VALUES ("2", "3");
INSERT INTO "Match" VALUES ("3", "5");
INSERT INTO "Match" VALUES ("4", "8");
INSERT INTO "Match" VALUES ("5", "9");
INSERT INTO "Match" VALUES ("6", "1");
INSERT INTO "Match" VALUES ("7", "4");
INSERT INTO "Match" VALUES ("8", "10");
INSERT INTO "Match" VALUES ("9", "6");
INSERT INTO "Match" VALUES ("10", "7");