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", "Virgil van Dijk");
INSERT INTO "Player" VALUES ("8", "Sergio Ramos");
INSERT INTO "Player" VALUES ("9", "Manuel Neuer");
INSERT INTO "Player" VALUES ("10", "Mohamed Salah");
INSERT INTO "Player" VALUES ("11", "Eden Hazard");
INSERT INTO "Player" VALUES ("12", "Luka Modric");
INSERT INTO "Player" VALUES ("13", "Harry Kane");
INSERT INTO "Player" VALUES ("14", "Jan Oblak");
INSERT INTO "Player" VALUES ("15", "Alisson Becker");
INSERT INTO "Player" VALUES ("16", "Marc-Andre ter Stegen");
INSERT INTO "Player" VALUES ("17", "Joshua Kimmich");
INSERT INTO "Player" VALUES ("18", "Trent Alexander-Arnold");
INSERT INTO "Player" VALUES ("19", "Andrew Robertson");
INSERT INTO "Player" VALUES ("20", "Bruno Fernandes");
INSERT INTO "Player" VALUES ("21", "Phil Foden");
INSERT INTO "Player" VALUES ("22", "Erling Haaland");
INSERT INTO "Player" VALUES ("23", "Ansu Fati");
INSERT INTO "Player" VALUES ("24", "Pedri");
INSERT INTO "Player" VALUES ("25", "Jude Bellingham");
INSERT INTO "Player" VALUES ("26", "Bukayo Saka");
INSERT INTO "Player" VALUES ("27", "Mason Mount");
INSERT INTO "Player" VALUES ("28", "Kai Havertz");
INSERT INTO "Player" VALUES ("29", "Federico Valverde");
INSERT INTO "Player" VALUES ("30", "Vinicius Jr.");
INSERT INTO "Player" VALUES ("31", "Rodrygo");
INSERT INTO "Player" VALUES ("32", "Eduardo Camavinga");
INSERT INTO "Player" VALUES ("33", "Gavi");
INSERT INTO "Player" VALUES ("34", "Jamal Musiala");
INSERT INTO "Player" VALUES ("35", "Florian Wirtz");
INSERT INTO "Player" VALUES ("36", "Anthony Elanga");
INSERT INTO "Player" VALUES ("37", "Noni Madueke");
INSERT INTO "Player" VALUES ("38", "Youssoufa Moukoko");
INSERT INTO "Player" VALUES ("39", "Karim Adeyemi");
INSERT INTO "Player" VALUES ("40", "Benjamin Sesko");
INSERT INTO "Player" VALUES ("41", "Fabio Carvalho");
INSERT INTO "Player" VALUES ("42", "Harvey Elliott");
INSERT INTO "Player" VALUES ("43", "Cole Palmer");
INSERT INTO "Player" VALUES ("44", "Rico Lewis");
INSERT INTO "Player" VALUES ("45", "Alejandro Garnacho");
INSERT INTO "Player" VALUES ("46", "Levi Colwill");
INSERT INTO "Player" VALUES ("47", "Armel Bella-Kotchap");
INSERT INTO "Player" VALUES ("48", "Piero Hincapie");
INSERT INTO "Player" VALUES ("49", "Josko Gvardiol");
INSERT INTO "Player" VALUES ("50", "Nuno Mendes");
INSERT INTO "Player" VALUES ("51", "Ryan Gravenberch");
INSERT INTO "Player" VALUES ("52", "Aurélien Tchouaméni");
INSERT INTO "Player" VALUES ("53", "Enzo Fernandez");
INSERT INTO "Player" VALUES ("54", "Moises Caicedo");
INSERT INTO "Player" VALUES ("55", "Alexis Mac Allister");
INSERT INTO "Player" VALUES ("56", "Sandro Tonali");
INSERT INTO "Player" VALUES ("57", "Nicolo Barella");
INSERT INTO "Player" VALUES ("58", "Rafael Leao");
INSERT INTO "Player" VALUES ("59", "Victor Osimhen");
INSERT INTO "Player" VALUES ("60", "Khvicha Kvaratskhelia");
INSERT INTO "Player" VALUES ("61", "A. Smith");
INSERT INTO "Player" VALUES ("62", "B. Jones");
INSERT INTO "Player" VALUES ("63", "C. Davis");
INSERT INTO "Player" VALUES ("64", "D. Miller");
INSERT INTO "Player" VALUES ("65", "E. Wilson");
INSERT INTO "Player" VALUES ("66", "F. Moore");
INSERT INTO "Player" VALUES ("67", "G. Taylor");
INSERT INTO "Player" VALUES ("68", "H. Anderson");
INSERT INTO "Player" VALUES ("69", "I. Thomas");
INSERT INTO "Player" VALUES ("70", "J. Jackson");
INSERT INTO "Player" VALUES ("71", "K. White");
INSERT INTO "Player" VALUES ("72", "L. Harris");
INSERT INTO "Player" VALUES ("73", "M. Martin");
INSERT INTO "Player" VALUES ("74", "N. Thompson");
INSERT INTO "Player" VALUES ("75", "O. Garcia");
INSERT INTO "Player" VALUES ("76", "P. Rodriguez");
INSERT INTO "Player" VALUES ("77", "Q. Martinez");
INSERT INTO "Player" VALUES ("78", "R. Hernandez");
INSERT INTO "Player" VALUES ("79", "S. Lopez");
INSERT INTO "Player" VALUES ("80", "T. Gonzalez");
INSERT INTO "Player" VALUES ("81", "U. Perez");
INSERT INTO "Player" VALUES ("82", "V. Sanchez");
INSERT INTO "Player" VALUES ("83", "W. Rivera");
INSERT INTO "Player" VALUES ("84", "X. Torres");
INSERT INTO "Player" VALUES ("85", "Y. Flores");
INSERT INTO "Player" VALUES ("86", "Z. Ramirez");
INSERT INTO "Player" VALUES ("87", "AA. Gomez");
INSERT INTO "Player" VALUES ("88", "BB. Diaz");
INSERT INTO "Player" VALUES ("89", "CC. Reyes");
INSERT INTO "Player" VALUES ("90", "DD. Cruz");
INSERT INTO "Player" VALUES ("91", "EE. Ortiz");
INSERT INTO "Player" VALUES ("92", "FF. Morales");
INSERT INTO "Player" VALUES ("93", "GG. Gutierrez");
INSERT INTO "Player" VALUES ("94", "HH. Chavez");
INSERT INTO "Player" VALUES ("95", "II. Ramos");
INSERT INTO "Player" VALUES ("96", "JJ. Castillo");
INSERT INTO "Player" VALUES ("97", "KK. Alvarez");
INSERT INTO "Player" VALUES ("98", "LL. Romero");
INSERT INTO "Player" VALUES ("99", "MM. Vargas");
INSERT INTO "Player" VALUES ("100", "NN. Molina");
INSERT INTO "Player_Attributes" VALUES ("1", "93", "93", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("2", "92", "92", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("3", "91", "91", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("4", "91", "91", "high", "high");
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", "medium");
INSERT INTO "Player_Attributes" VALUES ("10", "90", "90", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("11", "89", "89", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("12", "89", "89", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("13", "89", "89", "high", "medium");
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", "91", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("18", "88", "90", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("19", "88", "89", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("20", "88", "88", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("21", "87", "92", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("22", "88", "94", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("23", "80", "90", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("24", "81", "92", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("25", "84", "95", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("26", "83", "90", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("27", "82", "88", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("28", "83", "89", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("29", "84", "91", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("30", "86", "92", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("31", "82", "89", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("32", "80", "90", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("33", "79", "90", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("34", "81", "91", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("35", "80", "90", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("36", "75", "85", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("37", "76", "86", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("38", "74", "88", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("39", "77", "87", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("40", "78", "89", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("41", "73", "84", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("42", "75", "86", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("43", "72", "83", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("44", "70", "85", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("45", "76", "87", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("46", "78", "88", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("47", "77", "87", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("48", "76", "86", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("49", "80", "90", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("50", "81", "90", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("51", "79", "89", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("52", "83", "90", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("53", "84", "91", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("54", "82", "89", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("55", "83", "88", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("56", "84", "89", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("57", "85", "89", "high", "high");
INSERT INTO "Player_Attributes" VALUES ("58", "86", "90", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("59", "87", "91", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("60", "85", "90", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("61", "60", "70", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("62", "61", "71", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("63", "62", "72", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("64", "63", "73", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("65", "64", "74", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("66", "60", "68", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("67", "61", "69", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("68", "62", "70", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("69", "63", "71", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("70", "64", "72", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("71", "60", "67", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("72", "61", "68", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("73", "62", "69", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("74", "63", "70", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("75", "64", "71", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("76", "60", "66", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("77", "61", "67", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("78", "62", "68", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("79", "63", "69", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("80", "64", "70", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("81", "60", "65", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("82", "61", "66", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("83", "62", "67", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("84", "63", "68", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("85", "64", "69", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("86", "60", "64", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("87", "61", "65", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("88", "62", "66", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("89", "63", "67", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("90", "64", "68", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("91", "60", "63", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("92", "61", "64", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("93", "62", "65", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("94", "63", "66", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("95", "64", "67", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("96", "65", "75", "high", "medium");
INSERT INTO "Player_Attributes" VALUES ("97", "59", "65", "high", "low");
INSERT INTO "Player_Attributes" VALUES ("98", "65", "70", "medium", "high");
INSERT INTO "Player_Attributes" VALUES ("99", "60", "70", "medium", "medium");
INSERT INTO "Player_Attributes" VALUES ("100", "64", "70", "high", "medium");