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 "Country" (
"id" INT,
"name" TEXT,
PRIMARY KEY ("id")
);

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

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

CREATE TABLE "Team" (
"id" INT,
"team_long_name" TEXT,
PRIMARY KEY ("id")
);



INSERT INTO "Country" VALUES ("1", "England");
INSERT INTO "Country" VALUES ("2", "France");
INSERT INTO "Country" VALUES ("3", "Germany");
INSERT INTO "Player" VALUES ("1", "Aaron Lennon", "1987-04-16");
INSERT INTO "Player" VALUES ("2", "Abdelaziz Barrada", "1989-03-19");
INSERT INTO "Player" VALUES ("3", "John Smith", "1990-01-01");
INSERT INTO "Player" VALUES ("4", "Michael Johnson", "1985-12-12");
INSERT INTO "Player_Attributes" VALUES ("1", "2020-01-01");
INSERT INTO "Player_Attributes" VALUES ("2", "2020-01-01");
INSERT INTO "Player_Attributes" VALUES ("3", "2020-01-01");
INSERT INTO "Player_Attributes" VALUES ("4", "2020-01-01");
INSERT INTO "Team" VALUES ("1", "Tottenham Hotspur");
INSERT INTO "Team" VALUES ("2", "Olympique de Marseille");
INSERT INTO "Team" VALUES ("3", "Bayern Munich");