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

CREATE TABLE "Player_Attributes" (
"id" INT,
"overall_rating" INT,
"potential" INT,
"attacking_work_rate" TEXT,
"defensive_work_rate" TEXT,
PRIMARY KEY ("id")
);



INSERT INTO "Player" VALUES ("1", "Lionel Messi");
INSERT INTO "Player" VALUES ("2", "Cristiano Ronaldo");
INSERT INTO "Player" VALUES ("3", "Neymar Jr.");
INSERT INTO "Player" VALUES ("4", "Kevin De Bruyne");
INSERT INTO "Player" VALUES ("5", "Robert Lewandowski");
INSERT INTO "Player" VALUES ("6", "Kylian Mbappe");
INSERT INTO "Player" VALUES ("7", "Sergio Ramos");
INSERT INTO "Player" VALUES ("8", "Virgil van Dijk");
INSERT INTO "Player" VALUES ("9", "Luka Modric");
INSERT INTO "Player" VALUES ("10", "Mohamed Salah");
INSERT INTO "Player" VALUES ("11", "Antoine Griezmann");
INSERT INTO "Player" VALUES ("12", "Harry Kane");
INSERT INTO "Player" VALUES ("13", "Eden Hazard");
INSERT INTO "Player" VALUES ("14", "Jan Oblak");
INSERT INTO "Player" VALUES ("15", "Marc-Andre ter Stegen");
INSERT INTO "Player" VALUES ("16", "Alisson Becker");
INSERT INTO "Player" VALUES ("17", "Manuel Neuer");
INSERT INTO "Player" VALUES ("18", "Thibaut Courtois");
INSERT INTO "Player" VALUES ("19", "Joshua Kimmich");
INSERT INTO "Player" VALUES ("20", "Trent Alexander-Arnold");
INSERT INTO "Player" VALUES ("21", "Andrew Robertson");
INSERT INTO "Player" VALUES ("22", "Achraf Hakimi");
INSERT INTO "Player" VALUES ("23", "Alphonso Davies");
INSERT INTO "Player" VALUES ("24", "Frenkie de Jong");
INSERT INTO "Player" VALUES ("25", "Bruno Fernandes");
INSERT INTO "Player" VALUES ("26", "Kai Havertz");
INSERT INTO "Player" VALUES ("27", "Jadon Sancho");
INSERT INTO "Player" VALUES ("28", "Erling Haaland");
INSERT INTO "Player" VALUES ("29", "Ansu Fati");
INSERT INTO "Player" VALUES ("30", "Phil Foden");
INSERT INTO "Player" VALUES ("31", "Pedri");
INSERT INTO "Player" VALUES ("32", "Jamal Musiala");
INSERT INTO "Player" VALUES ("33", "Jude Bellingham");
INSERT INTO "Player" VALUES ("34", "Gavi");
INSERT INTO "Player" VALUES ("35", "Florian Wirtz");
INSERT INTO "Player" VALUES ("36", "Eduardo Camavinga");
INSERT INTO "Player" VALUES ("37", "Bukayo Saka");
INSERT INTO "Player" VALUES ("38", "Gabriel Martinelli");
INSERT INTO "Player" VALUES ("39", "Mykhailo Mudryk");
INSERT INTO "Player" VALUES ("40", "Enzo Fernandez");
INSERT INTO "Player" VALUES ("41", "Julian Alvarez");
INSERT INTO "Player" VALUES ("42", "Vinicius Jr.");
INSERT INTO "Player" VALUES ("43", "Rodrygo");
INSERT INTO "Player" VALUES ("44", "Federico Valverde");
INSERT INTO "Player" VALUES ("45", "Eder Militao");
INSERT INTO "Player" VALUES ("46", "Ronald Araujo");
INSERT INTO "Player" VALUES ("47", "Jules Kounde");
INSERT INTO "Player" VALUES ("48", "Matthijs de Ligt");
INSERT INTO "Player" VALUES ("49", "Ruben Dias");
INSERT INTO "Player" VALUES ("50", "Marquinhos");
INSERT INTO "Player" VALUES ("51", "Milan Skriniar");
INSERT INTO "Player" VALUES ("52", "Kalidou Koulibaly");
INSERT INTO "Player" VALUES ("53", "Presnel Kimpembe");
INSERT INTO "Player" VALUES ("54", "Dayot Upamecano");
INSERT INTO "Player" VALUES ("55", "William Saliba");
INSERT INTO "Player" VALUES ("56", "Lisandro Martinez");
INSERT INTO "Player" VALUES ("57", "Casemiro");
INSERT INTO "Player" VALUES ("58", "Rodri");
INSERT INTO "Player" VALUES ("59", "N'Golo Kante");
INSERT INTO "Player" VALUES ("60", "Declan Rice");
INSERT INTO "Player" VALUES ("61", "Fabinho");
INSERT INTO "Player" VALUES ("62", "Thomas Partey");
INSERT INTO "Player" VALUES ("63", "Marcelo Brozovic");
INSERT INTO "Player" VALUES ("64", "Marco Verratti");
INSERT INTO "Player" VALUES ("65", "Sergej Milinkovic-Savic");
INSERT INTO "Player" VALUES ("66", "Nicolo Barella");
INSERT INTO "Player" VALUES ("67", "Mason Mount");
INSERT INTO "Player" VALUES ("68", "Jack Grealish");
INSERT INTO "Player" VALUES ("69", "Raheem Sterling");
INSERT INTO "Player" VALUES ("70", "Son Heung-min");
INSERT INTO "Player" VALUES ("71", "Sadio Mane");
INSERT INTO "Player" VALUES ("72", "Karim Benzema");
INSERT INTO "Player" VALUES ("73", "Romelu Lukaku");
INSERT INTO "Player" VALUES ("74", "Dusan Vlahovic");
INSERT INTO "Player" VALUES ("75", "Victor Osimhen");
INSERT INTO "Player" VALUES ("76", "Rafael Leao");
INSERT INTO "Player" VALUES ("77", "Khvicha Kvaratskhelia");
INSERT INTO "Player" VALUES ("78", "Christopher Nkunku");
INSERT INTO "Player" VALUES ("79", "Randal Kolo Muani");
INSERT INTO "Player" VALUES ("80", "Goncalo Ramos");
INSERT INTO "Player" VALUES ("81", "Youssoufa Moukoko");
INSERT INTO "Player" VALUES ("82", "Gavi");
INSERT INTO "Player" VALUES ("83", "Pedri");
INSERT INTO "Player" VALUES ("84", "Ansu Fati");
INSERT INTO "Player" VALUES ("85", "Jamal Musiala");
INSERT INTO "Player" VALUES ("86", "Jude Bellingham");
INSERT INTO "Player" VALUES ("87", "Florian Wirtz");
INSERT INTO "Player" VALUES ("88", "Eduardo Camavinga");
INSERT INTO "Player" VALUES ("89", "Bukayo Saka");
INSERT INTO "Player" VALUES ("90", "Gabriel Martinelli");
INSERT INTO "Player" VALUES ("91", "Mykhailo Mudryk");
INSERT INTO "Player" VALUES ("92", "Enzo Fernandez");
INSERT INTO "Player" VALUES ("93", "Julian Alvarez");
INSERT INTO "Player" VALUES ("94", "Vinicius Jr.");
INSERT INTO "Player" VALUES ("95", "Rodrygo");
INSERT INTO "Player" VALUES ("96", "Federico Valverde");
INSERT INTO "Player" VALUES ("97", "Eder Militao");
INSERT INTO "Player" VALUES ("98", "Ronald Araujo");
INSERT INTO "Player" VALUES ("99", "Jules Kounde");
INSERT INTO "Player" VALUES ("100", "Matthijs de Ligt");
INSERT INTO "Player" VALUES ("101", "Ruben Dias");
INSERT INTO "Player" VALUES ("102", "Marquinhos");
INSERT INTO "Player" VALUES ("103", "Milan Skriniar");
INSERT INTO "Player" VALUES ("104", "Kalidou Koulibaly");
INSERT INTO "Player" VALUES ("105", "Presnel Kimpembe");
INSERT INTO "Player" VALUES ("106", "Dayot Upamecano");
INSERT INTO "Player" VALUES ("107", "William Saliba");
INSERT INTO "Player" VALUES ("108", "Lisandro Martinez");
INSERT INTO "Player" VALUES ("109", "Casemiro");
INSERT INTO "Player" VALUES ("110", "Rodri");
INSERT INTO "Player" VALUES ("111", "N'Golo Kante");
INSERT INTO "Player" VALUES ("112", "Declan Rice");
INSERT INTO "Player" VALUES ("113", "Fabinho");
INSERT INTO "Player" VALUES ("114", "Thomas Partey");
INSERT INTO "Player" VALUES ("115", "Marcelo Brozovic");
INSERT INTO "Player" VALUES ("116", "Marco Verratti");
INSERT INTO "Player" VALUES ("117", "Sergej Milinkovic-Savic");
INSERT INTO "Player" VALUES ("118", "Nicolo Barella");
INSERT INTO "Player" VALUES ("119", "Mason Mount");
INSERT INTO "Player" VALUES ("120", "Jack Grealish");
INSERT INTO "Player" VALUES ("121", "Raheem Sterling");
INSERT INTO "Player" VALUES ("122", "Son Heung-min");
INSERT INTO "Player" VALUES ("123", "Sadio Mane");
INSERT INTO "Player" VALUES ("124", "Karim Benzema");
INSERT INTO "Player" VALUES ("125", "Romelu Lukaku");
INSERT INTO "Player" VALUES ("126", "Dusan Vlahovic");
INSERT INTO "Player" VALUES ("127", "Victor Osimhen");
INSERT INTO "Player" VALUES ("128", "Rafael Leao");
INSERT INTO "Player" VALUES ("129", "Khvicha Kvaratskhelia");
INSERT INTO "Player" VALUES ("130", "Christopher Nkunku");
INSERT INTO "Player" VALUES ("131", "Randal Kolo Muani");
INSERT INTO "Player" VALUES ("132", "Goncalo Ramos");
INSERT INTO "Player" VALUES ("133", "Youssoufa Moukoko");
INSERT INTO "Player" VALUES ("134", "Young Player A");
INSERT INTO "Player" VALUES ("135", "Young Player B");
INSERT INTO "Player" VALUES ("136", "Young Player C");
INSERT INTO "Player" VALUES ("137", "Young Player D");
INSERT INTO "Player" VALUES ("138", "Young Player E");
INSERT INTO "Player" VALUES ("139", "Young Player F");
INSERT INTO "Player" VALUES ("140", "Young Player G");
INSERT INTO "Player" VALUES ("141", "Young Player H");
INSERT INTO "Player" VALUES ("142", "Young Player I");
INSERT INTO "Player" VALUES ("143", "Young Player J");
INSERT INTO "Player" VALUES ("144", "Young Player K");
INSERT INTO "Player" VALUES ("145", "Young Player L");
INSERT INTO "Player" VALUES ("146", "Young Player M");
INSERT INTO "Player" VALUES ("147", "Young Player N");
INSERT INTO "Player" VALUES ("148", "Young Player O");
INSERT INTO "Player" VALUES ("149", "Young Player P");
INSERT INTO "Player" VALUES ("150", "Young Player Q");
INSERT INTO "Player" VALUES ("151", "Young Player R");
INSERT INTO "Player" VALUES ("152", "Young Player S");
INSERT INTO "Player" VALUES ("153", "Young Player T");
INSERT INTO "Player" VALUES ("154", "Young Player U");
INSERT INTO "Player" VALUES ("155", "Young Player V");
INSERT INTO "Player" VALUES ("156", "Young Player W");
INSERT INTO "Player" VALUES ("157", "Young Player X");
INSERT INTO "Player" VALUES ("158", "Young Player Y");
INSERT INTO "Player" VALUES ("159", "Young Player Z");
INSERT INTO "Player" VALUES ("160", "Veteran Player A");
INSERT INTO "Player" VALUES ("161", "Veteran Player B");
INSERT INTO "Player" VALUES ("162", "Veteran Player C");
INSERT INTO "Player" VALUES ("163", "Veteran Player D");
INSERT INTO "Player" VALUES ("164", "Veteran Player E");
INSERT INTO "Player" VALUES ("165", "Veteran Player F");
INSERT INTO "Player" VALUES ("166", "Veteran Player G");
INSERT INTO "Player" VALUES ("167", "Veteran Player H");
INSERT INTO "Player" VALUES ("168", "Veteran Player I");
INSERT INTO "Player" VALUES ("169", "Veteran Player J");
INSERT INTO "Player" VALUES ("170", "Veteran Player K");
INSERT INTO "Player" VALUES ("171", "Veteran Player L");
INSERT INTO "Player" VALUES ("172", "Veteran Player M");
INSERT INTO "Player" VALUES ("173", "Veteran Player N");
INSERT INTO "Player" VALUES ("174", "Veteran Player O");
INSERT INTO "Player" VALUES ("175", "Veteran Player P");
INSERT INTO "Player" VALUES ("176", "Veteran Player Q");
INSERT INTO "Player" VALUES ("177", "Veteran Player R");
INSERT INTO "Player" VALUES ("178", "Veteran Player S");
INSERT INTO "Player" VALUES ("179", "Veteran Player T");
INSERT INTO "Player" VALUES ("180", "Veteran Player U");
INSERT INTO "Player" VALUES ("181", "Veteran Player V");
INSERT INTO "Player" VALUES ("182", "Veteran Player W");
INSERT INTO "Player" VALUES ("183", "Veteran Player X");
INSERT INTO "Player" VALUES ("184", "Veteran Player Y");
INSERT INTO "Player" VALUES ("185", "Veteran Player Z");
INSERT INTO "Player" VALUES ("186", "Mid-tier Player A");
INSERT INTO "Player" VALUES ("187", "Mid-tier Player B");
INSERT INTO "Player" VALUES ("188", "Mid-tier Player C");
INSERT INTO "Player" VALUES ("189", "Mid-tier Player D");
INSERT INTO "Player" VALUES ("190", "Mid-tier Player E");
INSERT INTO "Player" VALUES ("191", "Mid-tier Player F");
INSERT INTO "Player" VALUES ("192", "Mid-tier Player G");
INSERT INTO "Player" VALUES ("193", "Mid-tier Player H");
INSERT INTO "Player" VALUES ("194", "Mid-tier Player I");
INSERT INTO "Player" VALUES ("195", "Mid-tier Player J");
INSERT INTO "Player" VALUES ("196", "Mid-tier Player K");
INSERT INTO "Player" VALUES ("197", "Mid-tier Player L");
INSERT INTO "Player" VALUES ("198", "Mid-tier Player M");
INSERT INTO "Player" VALUES ("199", "Mid-tier Player N");
INSERT INTO "Player" VALUES ("200", "Mid-tier Player O");
INSERT INTO "Player_Attributes" VALUES ("1", "93", "93", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("2", "92", "92", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("3", "91", "91", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("4", "91", "91", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("5", "91", "91", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("6", "91", "95", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("7", "90", "90", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("8", "90", "90", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("9", "90", "90", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("10", "90", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("11", "89", "89", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("12", "89", "89", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("13", "89", "89", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("14", "89", "89", "Medium", "Medium");
INSERT INTO "Player_Attributes" VALUES ("15", "89", "89", "Medium", "Medium");
INSERT INTO "Player_Attributes" VALUES ("16", "89", "89", "Medium", "Medium");
INSERT INTO "Player_Attributes" VALUES ("17", "89", "89", "Medium", "Medium");
INSERT INTO "Player_Attributes" VALUES ("18", "89", "89", "Medium", "Medium");
INSERT INTO "Player_Attributes" VALUES ("19", "89", "90", "High", "High");
INSERT INTO "Player_Attributes" VALUES ("20", "88", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("21", "88", "89", "High", "High");
INSERT INTO "Player_Attributes" VALUES ("22", "87", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("23", "87", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("24", "87", "90", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("25", "87", "88", "High", "High");
INSERT INTO "Player_Attributes" VALUES ("26", "86", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("27", "86", "90", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("28", "86", "91", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("29", "80", "90", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("30", "82", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("31", "81", "92", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("32", "80", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("33", "84", "92", "High", "High");
INSERT INTO "Player_Attributes" VALUES ("34", "79", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("35", "80", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("36", "78", "89", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("37", "83", "89", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("38", "81", "88", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("39", "79", "88", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("40", "84", "90", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("41", "83", "89", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("42", "86", "91", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("43", "84", "90", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("44", "85", "90", "High", "High");
INSERT INTO "Player_Attributes" VALUES ("45", "86", "90", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("46", "85", "90", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("47", "84", "89", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("48", "85", "89", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("49", "88", "89", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("50", "87", "88", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("51", "86", "87", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("52", "86", "87", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("53", "85", "86", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("54", "84", "88", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("55", "83", "89", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("56", "82", "88", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("57", "89", "89", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("58", "88", "89", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("59", "88", "88", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("60", "85", "88", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("61", "85", "86", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("62", "84", "85", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("63", "84", "84", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("64", "84", "84", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("65", "84", "85", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("66", "84", "86", "High", "High");
INSERT INTO "Player_Attributes" VALUES ("67", "83", "87", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("68", "83", "84", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("69", "83", "83", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("70", "89", "89", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("71", "88", "88", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("72", "91", "91", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("73", "86", "86", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("74", "85", "89", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("75", "84", "89", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("76", "84", "89", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("77", "83", "89", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("78", "86", "88", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("79", "82", "87", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("80", "81", "87", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("81", "79", "89", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("82", "79", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("83", "81", "92", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("84", "80", "90", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("85", "80", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("86", "84", "92", "High", "High");
INSERT INTO "Player_Attributes" VALUES ("87", "80", "90", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("88", "78", "89", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("89", "83", "89", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("90", "81", "88", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("91", "79", "88", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("92", "84", "90", "Medium", "High");
INSERT INTO "Player_Attributes" VALUES ("93", "83", "89", "High", "Medium");
INSERT INTO "Player_Attributes" VALUES ("94", "86", "91", "High", "low");
INSERT INTO "Player_Attributes" VALUES ("95", "84", "90", "High", "low");