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,
"player_fifa_api_id" INT,
"birthday" TEXT,
"height" INT,
"weight" INT,
PRIMARY KEY ("id")
);



INSERT INTO "Player" VALUES ("1", "Zlatan Ibrahimovic", "101", "1981-10-03", "195", "95");
INSERT INTO "Player" VALUES ("2", "Cristiano Ronaldo", "102", "1985-02-05", "187", "83");
INSERT INTO "Player" VALUES ("3", "Lionel Messi", "103", "1987-06-24", "170", "72");
INSERT INTO "Player" VALUES ("4", "Robert Lewandowski", "104", "1988-08-21", "185", "80");
INSERT INTO "Player" VALUES ("5", "Neymar Jr", "105", "1992-02-05", "175", "68");
INSERT INTO "Player" VALUES ("6", "Paul Pogba", "106", "1993-03-15", "191", "84");
INSERT INTO "Player" VALUES ("7", "Sergio Ramos", "107", "1986-03-30", "184", "82");
INSERT INTO "Player" VALUES ("8", "Kylian Mbappe", "108", "1998-12-20", "178", "73");
INSERT INTO "Player" VALUES ("9", "Virgil van Dijk", "109", "1991-07-08", "193", "92");
INSERT INTO "Player" VALUES ("10", "Toni Kroos", "110", "1990-01-04", "183", "78");
INSERT INTO "Player" VALUES ("11", "Andres Iniesta", "111", "1984-05-11", "171", "68");
INSERT INTO "Player" VALUES ("12", "Gareth Bale", "112", "1989-07-16", "183", "80");
INSERT INTO "Player" VALUES ("13", "Edinson Cavani", "113", "1987-02-14", "184", "75");
INSERT INTO "Player" VALUES ("14", "Harry Kane", "114", "1993-07-28", "188", "86");
INSERT INTO "Player" VALUES ("15", "Luis Suarez", "115", "1987-01-24", "182", "86");