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 "Player" (
"id" INT,
"player_name" TEXT,
"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", "Aaron Ramsey", "1990-12-26", "177", "76");
INSERT INTO "Player" VALUES ("2", "Aaron Lennon", "1987-04-16", "165", "63");
INSERT INTO "Player" VALUES ("3", "Aaron Hunt", "1986-09-04", "183", "73");
INSERT INTO "Player" VALUES ("4", "Aaron Cresswell", "1989-12-15", "170", "66");
INSERT INTO "Player" VALUES ("5", "Aaron Mooy", "1990-09-15", "175", "72");
INSERT INTO "Player" VALUES ("6", "Aaron Leya Iseka", "1997-11-17", "183", "75");
INSERT INTO "Player" VALUES ("7", "Aaron Connolly", "2000-01-28", "178", "70");
INSERT INTO "Player" VALUES ("8", "Aaron Wan-Bissaka", "1997-11-26", "183", "72");
INSERT INTO "Player" VALUES ("9", "Aaron Long", "1992-10-12", "185", "80");
INSERT INTO "Player" VALUES ("10", "Aaron Schoenfeld", "1990-04-17", "191", "86");
INSERT INTO "Player" VALUES ("11", "David Aaron", "1985-03-20", "170", "68");
INSERT INTO "Player" VALUES ("12", "Aaron Smith", "1995-07-01", "180", "75");
INSERT INTO "Player" VALUES ("13", "Aaron Jones", "1991-02-10", "175", "70");
INSERT INTO "Player" VALUES ("14", "Aaron Davies", "1989-06-25", "172", "65");
INSERT INTO "Player" VALUES ("15", "Aaron Taylor", "1998-09-05", "185", "78");
INSERT INTO "Player_Attributes" VALUES ("1", "82");
INSERT INTO "Player_Attributes" VALUES ("2", "78");
INSERT INTO "Player_Attributes" VALUES ("3", "75");
INSERT INTO "Player_Attributes" VALUES ("4", "79");
INSERT INTO "Player_Attributes" VALUES ("5", "77");
INSERT INTO "Player_Attributes" VALUES ("6", "70");
INSERT INTO "Player_Attributes" VALUES ("7", "68");
INSERT INTO "Player_Attributes" VALUES ("8", "80");
INSERT INTO "Player_Attributes" VALUES ("9", "76");
INSERT INTO "Player_Attributes" VALUES ("10", "69");
INSERT INTO "Player_Attributes" VALUES ("11", "72");
INSERT INTO "Player_Attributes" VALUES ("12", "71");
INSERT INTO "Player_Attributes" VALUES ("13", "73");
INSERT INTO "Player_Attributes" VALUES ("14", "67");
INSERT INTO "Player_Attributes" VALUES ("15", "74");