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

CREATE TABLE "Player_Attributes" (
"id" INT,
"player_api_id" INT,
"overall_rating" INT,
"preferred_foot" TEXT,
PRIMARY KEY ("id"),
FOREIGN KEY ("player_api_id") REFERENCES "Player"("player_api_id")
);



INSERT INTO "Player" VALUES ("1", "1001", "Lionel Messi", "1987-06-24", "159");
INSERT INTO "Player" VALUES ("2", "1002", "Antoine Griezmann", "1991-03-21", "161");
INSERT INTO "Player" VALUES ("3", "1003", "Neymar Jr.", "1992-02-05", "150");
INSERT INTO "Player" VALUES ("4", "1004", "Eden Hazard", "1991-01-07", "163");
INSERT INTO "Player" VALUES ("5", "1005", "Sergio Aguero", "1988-06-02", "150");
INSERT INTO "Player" VALUES ("6", "1006", "Marco Verratti", "1992-11-05", "132");
INSERT INTO "Player" VALUES ("7", "1007", "Jordi Alba", "1989-03-21", "150");
INSERT INTO "Player" VALUES ("8", "1008", "Philippe Coutinho", "1992-06-12", "150");
INSERT INTO "Player" VALUES ("9", "1009", "Lorenzo Insigne", "1991-06-04", "130");
INSERT INTO "Player" VALUES ("10", "1010", "Alexis Sanchez", "1988-12-19", "150");
INSERT INTO "Player" VALUES ("11", "1011", "David Silva", "1986-01-08", "148");
INSERT INTO "Player" VALUES ("12", "1012", "Santi Cazorla", "1984-12-13", "145");
INSERT INTO "Player" VALUES ("13", "1013", "NGolo Kante", "1991-03-29", "150");
INSERT INTO "Player" VALUES ("14", "1014", "Riyad Mahrez", "1991-02-21", "150");
INSERT INTO "Player" VALUES ("15", "1015", "Paulo Dybala", "1993-11-15", "165");
INSERT INTO "Player" VALUES ("16", "1016", "Kylian Mbappe", "1998-12-20", "161");
INSERT INTO "Player" VALUES ("17", "1017", "Christian Eriksen", "1992-02-14", "168");
INSERT INTO "Player" VALUES ("18", "1018", "Bernardo Silva", "1994-08-10", "143");
INSERT INTO "Player" VALUES ("19", "1019", "Raheem Sterling", "1994-12-08", "152");
INSERT INTO "Player" VALUES ("20", "1020", "Kai Havertz", "1999-06-11", "183");
INSERT INTO "Player" VALUES ("21", "1021", "Pedri", "2002-11-25", "159");
INSERT INTO "Player" VALUES ("22", "1022", "Gavi", "2004-08-05", "150");
INSERT INTO "Player" VALUES ("23", "1023", "Ansu Fati", "2002-10-31", "148");
INSERT INTO "Player" VALUES ("24", "1024", "Jamal Musiala", "2003-02-26", "154");
INSERT INTO "Player" VALUES ("25", "1025", "Florian Wirtz", "2003-05-03", "150");
INSERT INTO "Player" VALUES ("26", "1026", "Jude Bellingham", "2003-06-29", "170");
INSERT INTO "Player" VALUES ("27", "1027", "Bukayo Saka", "2001-09-05", "150");
INSERT INTO "Player" VALUES ("28", "1028", "Phil Foden", "2000-05-28", "154");
INSERT INTO "Player" VALUES ("29", "1029", "Mason Mount", "1999-01-10", "163");
INSERT INTO "Player" VALUES ("30", "1030", "Emile Smith Rowe", "2000-07-28", "150");
INSERT INTO "Player" VALUES ("31", "1031", "Cole Palmer", "2002-05-06", "143");
INSERT INTO "Player" VALUES ("32", "1032", "Rico Lewis", "2004-11-21", "130");
INSERT INTO "Player" VALUES ("33", "1033", "Alejandro Garnacho", "2004-07-01", "150");
INSERT INTO "Player" VALUES ("34", "1034", "Lamine Yamal", "2007-07-13", "130");
INSERT INTO "Player" VALUES ("35", "1035", "Endrick", "2006-07-21", "140");
INSERT INTO "Player" VALUES ("36", "1036", "Warren Zaire-Emery", "2006-03-08", "150");
INSERT INTO "Player" VALUES ("37", "1037", "Arda Guler", "2005-02-25", "140");
INSERT INTO "Player" VALUES ("38", "1038", "Mathys Tel", "2005-04-27", "160");
INSERT INTO "Player" VALUES ("39", "1039", "Youssoufa Moukoko", "2004-11-20", "140");
INSERT INTO "Player" VALUES ("40", "1040", "Benjamin Sesko", "2003-05-31", "190");
INSERT INTO "Player" VALUES ("41", "1041", "Xavi Simons", "2003-04-21", "140");
INSERT INTO "Player" VALUES ("42", "1042", "Carney Chukwuemeka", "2003-10-20", "160");
INSERT INTO "Player" VALUES ("43", "1043", "Romeo Lavia", "2004-01-06", "150");
INSERT INTO "Player" VALUES ("44", "1044", "Levi Colwill", "2003-02-26", "170");
INSERT INTO "Player" VALUES ("45", "1045", "Destiny Udogie", "2002-11-28", "160");
INSERT INTO "Player" VALUES ("46", "1046", "Giorgio Scalvini", "2003-12-11", "180");
INSERT INTO "Player" VALUES ("47", "1047", "Antonio Nusa", "2005-04-17", "150");
INSERT INTO "Player" VALUES ("48", "1048", "Evan Ferguson", "2004-10-19", "180");
INSERT INTO "Player" VALUES ("49", "1049", "Julien Duranville", "2006-05-05", "140");
INSERT INTO "Player" VALUES ("50", "1050", "Gabriel Martinelli", "2001-06-18", "150");
INSERT INTO "Player_Attributes" VALUES ("1", "1001", "93", "left");
INSERT INTO "Player_Attributes" VALUES ("2", "1002", "88", "left");
INSERT INTO "Player_Attributes" VALUES ("3", "1003", "91", "right");
INSERT INTO "Player_Attributes" VALUES ("4", "1004", "90", "right");
INSERT INTO "Player_Attributes" VALUES ("5", "1005", "89", "right");
INSERT INTO "Player_Attributes" VALUES ("6", "1006", "87", "right");
INSERT INTO "Player_Attributes" VALUES ("7", "1007", "86", "left");
INSERT INTO "Player_Attributes" VALUES ("8", "1008", "87", "right");
INSERT INTO "Player_Attributes" VALUES ("9", "1009", "86", "right");
INSERT INTO "Player_Attributes" VALUES ("10", "1010", "85", "right");
INSERT INTO "Player_Attributes" VALUES ("11", "1011", "88", "left");
INSERT INTO "Player_Attributes" VALUES ("12", "1012", "84", "right");
INSERT INTO "Player_Attributes" VALUES ("13", "1013", "89", "right");
INSERT INTO "Player_Attributes" VALUES ("14", "1014", "86", "left");
INSERT INTO "Player_Attributes" VALUES ("15", "1015", "87", "left");
INSERT INTO "Player_Attributes" VALUES ("16", "1016", "91", "right");
INSERT INTO "Player_Attributes" VALUES ("17", "1017", "88", "right");
INSERT INTO "Player_Attributes" VALUES ("18", "1018", "88", "left");
INSERT INTO "Player_Attributes" VALUES ("19", "1019", "88", "right");
INSERT INTO "Player_Attributes" VALUES ("20", "1020", "87", "left");
INSERT INTO "Player_Attributes" VALUES ("21", "1021", "86", "right");
INSERT INTO "Player_Attributes" VALUES ("22", "1022", "84", "right");
INSERT INTO "Player_Attributes" VALUES ("23", "1023", "82", "left");
INSERT INTO "Player_Attributes" VALUES ("24", "1024", "85", "right");
INSERT INTO "Player_Attributes" VALUES ("25", "1025", "85", "right");
INSERT INTO "Player_Attributes" VALUES ("26", "1026", "86", "right");
INSERT INTO "Player_Attributes" VALUES ("27", "1027", "84", "left");
INSERT INTO "Player_Attributes" VALUES ("28", "1028", "85", "left");
INSERT INTO "Player_Attributes" VALUES ("29", "1029", "83", "right");
INSERT INTO "Player_Attributes" VALUES ("30", "1030", "81", "right");
INSERT INTO "Player_Attributes" VALUES ("31", "1031", "78", "left");
INSERT INTO "Player_Attributes" VALUES ("32", "1032", "75", "right");
INSERT INTO "Player_Attributes" VALUES ("33", "1033", "76", "right");
INSERT INTO "Player_Attributes" VALUES ("34", "1034", "74", "left");
INSERT INTO "Player_Attributes" VALUES ("35", "1035", "75", "right");
INSERT INTO "Player_Attributes" VALUES ("36", "1036", "76", "right");
INSERT INTO "Player_Attributes" VALUES ("37", "1037", "75", "left");
INSERT INTO "Player_Attributes" VALUES ("38", "1038", "74", "right");
INSERT INTO "Player_Attributes" VALUES ("39", "1039", "73", "right");
INSERT INTO "Player_Attributes" VALUES ("40", "1040", "78", "right");
INSERT INTO "Player_Attributes" VALUES ("41", "1041", "77", "right");
INSERT INTO "Player_Attributes" VALUES ("42", "1042", "74", "right");
INSERT INTO "Player_Attributes" VALUES ("43", "1043", "75", "right");
INSERT INTO "Player_Attributes" VALUES ("44", "1044", "76", "left");
INSERT INTO "Player_Attributes" VALUES ("45", "1045", "75", "left");
INSERT INTO "Player_Attributes" VALUES ("46", "1046", "77", "right");
INSERT INTO "Player_Attributes" VALUES ("47", "1047", "73", "right");
INSERT INTO "Player_Attributes" VALUES ("48", "1048", "76", "right");
INSERT INTO "Player_Attributes" VALUES ("49", "1049", "72", "right");
INSERT INTO "Player_Attributes" VALUES ("50", "1050", "84", "right");