copa_do_mundo.sql

CREATE TABLE `tb_jogadores` (
  `id` int(11) NOT NULL,
  `nome_jogadores` text DEFAULT NULL,
  `alt` float DEFAULT NULL,
  `peso` int(11) DEFAULT NULL,
  `nascimento` date DEFAULT NULL,
  `posicao` text DEFAULT NULL,
  `id_times` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `tb_jogadores`
--

INSERT INTO `tb_jogadores` (`id`, `Player`, `Height`, `Weight`, `BirthDate`, `Position`, `id_times`) VALUES
(1, 'Saad Al Sheeb', 1.88, 83, '1990-02-19', 'Goleiro', 1),
(2, 'Bassam Alrawi', 1.74, 77, '1997-12-16', 'Zagueiro', 1),
(3, 'Abdulkarim Hassan', 1.85, 82, '1993-08-28', 'Zagueiro', 1),
(4, 'Boualem Khoukhi', 1.84, 78, '1990-07-09', 'Zagueiro', 1),
(5, 'Pedro Miguel', 1.8, 73, '1990-08-06', 'Zagueiro', 1),
(6, 'Tarek Salman', 1.79, 69, '1997-12-05', 'Zagueiro', 1),
(7, 'Karim Boudiaf', 1.9, 87, '1990-09-16', 'Meia', 1),
(8, 'Abdulaziz Hatem', 1.82, 76, '1990-10-28', 'Meia', 1),
(9, 'Akram Hassan Afif', 1.76, 68, '1996-11-18', 'Atacante', 1),
(10, 'Hasan Al-Haydos', 1.7, 58, '1990-12-11', 'Atacante', 1),
(11, 'Almoez Ali', 1.8, 68, '1996-08-19', 'Atacante', 1),
(12, 'Hernán Galíndez', 1.9, 90, '1987-03-30', 'Goleiro', 2),
(13, 'Pervis Estupiñán', 1.75, 78, '1998-01-21', 'Zagueiro', 2),
(14, 'Piero Hincapié', 1.83, 66, '2002-01-09', 'Zagueiro', 2),
(15, 'Ángelo Preciado', 1.73, 73, '1998-02-18', 'Zagueiro', 2),
(16, 'Félix Torres', 1.87, 78, '1997-01-11', 'Zagueiro', 2),
(17, 'Moisés Caicedo', 1.78, 73, '2001-11-02', 'Meia', 2),
(18, 'Carlos Gruezo', 1.73, 71, '1995-04-19', 'Meia', 2),
(19, 'Michael Estrada', 1.87, 85, '1996-04-07', 'Atacante', 2),
(20, 'Ángel Mena', 1.68, 70, '1988-01-21', 'Atacante', 2),
(21, 'Gonzalo Plata', 1.78, 65, '2000-11-01', 'Atacante', 2),
(22, 'Enner Valencia', 1.77, 76, '1989-11-04', 'Atacante', 2),
(23, 'Édouard Mendy', 1.97, 93, '1992-03-01', 'Goleiro', 3),
(24, 'Saliou Ciss', 1.75, 70, '1989-09-15', 'Zagueiro', 3),
(25, 'Abdou Diallo', 1.87, 79, '1996-05-04', 'Zagueiro', 3),
(26, 'Kalidou Koulibaly', 1.95, 89, '1991-06-20', 'Zagueiro', 3),
(27, 'Bouna Sarr', 1.78, 71, '1992-01-31', 'Zagueiro', 3),
(28, 'Idrissa Gueye', 1.74, 66, '1989-09-26', 'Meia', 3),
(29, 'Cheikhou Kouyaté', 1.89, 83, '1989-12-21', 'Meia', 3),
(30, 'Nampalys Mendy', 1.67, 73, '1992-06-23', 'Meia', 3),
(31, 'Boulaye Dia', 1.8, 75, '1992-04-10', 'Atacante', 3),
(32, 'Sadio Mané', 1.75, 69, '1992-04-10', 'Atacante', 3),
(33, 'Ismaila Sarr', 1.85, 76, '1998-02-25', 'Atacante', 3),
(34, 'Justin Bijlow', 1.9, 84, '1998-01-22', 'Goleiro', 4),
(35, 'Daley Blind', 1.8, 72, '1990-03-09', 'Zagueiro', 4),
(36, 'Matthijs de Ligt', 1.88, 96, '1999-08-12', 'Zagueiro', 4),
(37, 'Stefan de Vrij', 1.89, 78, '1992-02-05', 'Zagueiro', 4),
(38, 'Denzel Dumfries', 1.88, 80, '1996-04-18', 'Zagueiro', 4),
(39, 'Virgil Van Dijk', 1.93, 92, '1991-07-08', 'Zagueiro', 4),
(40, 'Frenkie de Jong', 1.8, 74, '1997-05-12', 'Meia', 4),
(41, 'Davy Klaassen', 1.79, 70, '1993-02-21', 'Meia', 4),
(42, 'Georginio Wijnaldum', 1.73, 74, '1990-11-11', 'Meia', 4),
(43, 'Steven Bergwijn', 1.78, 74, '1997-10-08', 'Atacante', 4),
(44, 'Memphis Depay', 1.76, 78, '1994-02-13', 'Atacante', 4),
(45, 'Jordan PickFord', 1.85, 77, '1994-03-07', 'Goleiro', 5),
(46, 'Harry Maguire', 1.94, 100, '1993-03-05', 'Zagueiro', 5),
(47, 'Luke Shaw', 1.85, 75, '1995-07-12', 'Zagueiro', 5),
(48, 'John Stones', 1.88, 70, '1994-05-28', 'Zagueiro', 5),
(49, 'Kyle Walker', 1.78, 70, '1990-05-28', 'Zagueiro', 5),
(50, 'Mason Mount', 1.78, 70, '1999-01-10', 'Meia', 5),
(51, 'Kalvin Phillips', 1.78, 73, '1995-12-02', 'Meia', 5),
(52, 'Declan Rice', 1.85, 80, '1999-01-14', 'Meia', 5),
(53, 'Phil Foden', 1.71, 70, '2000-05-28', 'Atacante', 5),
(54, 'Harry Kane', 1.88, 85, '1993-07-28', 'Atacante', 5),
(55, 'Raheem', 1.7, 69, '1994-12-08', 'Atacante', 5),
(56, 'Alireza Beiranvand', 1.95, 79, '1992-09-21', 'Goleiro', 6),
(57, 'Hossein Kannani', 1.88, 81, '1994-03-23', 'Zagueiro', 6),
(58, 'Shoja Khalilzadeh', 1.83, 80, '1989-05-14', 'Zagueiro', 6),
(59, 'Milad Mohammadi', 1.78, 79, '1993-09-29', 'Zagueiro', 6),
(60, 'Omid Noorafkan', 1.82, 78, '1997-04-09', 'Zagueiro', 6),
(61, 'Saeid Ezatolahi', 1.9, 78, '1996-10-01', 'Meia', 6),
(62, 'Ali Gholizadeh', 1.76, 69, '1996-03-10', 'Meia', 6),
(63, 'Alireza Jahanbakhsh', 1.8, 76, '1993-08-11', 'Meia', 6),
(64, 'Ahmad Nourollahi', 1.83, 74, '1993-02-01', 'Meia', 6),
(65, 'Sardar Azmoun', 1.86, 79, '1995-01-01', 'Atacante', 6),
(66, 'Mehdi Taremi', 1.87, 79, '1992-07-18', 'Atacante', 6),
(67, 'Matt Turner', 1.9, 79, '1994-06-24', 'Goleiro', 7),
(68, 'Sergiño Dest', 1.75, 62, '2000-11-03', 'Zagueiro', 7),
(69, 'Antonee Robinson', 1.83, 70, '1997-08-08', 'Zagueiro', 7),
(70, 'DeAndre Yedlin', 1.72, 74, '1993-07-09', 'Zagueiro', 7),
(71, 'Walker Zimmerman', 1.9, 89, '1993-05-19', 'Zagueiro', 7),
(72, 'Tyler Adams', 1.75, 72, '1999-02-14', 'Meia', 7),
(73, 'Weston McKennie', 1.8, 86, '1998-08-28', 'Meia', 7),
(74, 'Ricardo Pepi', 1.85, 74, '2003-01-09', 'Atacante', 7),
(75, 'Christian Pulisic', 1.77, 73, '1998-09-18', 'Atacante', 7),
(76, 'Giovanni Reyna', 1.85, 79, '2002-11-13', 'Atacante', 7),
(77, 'Timothy Weah', 1.85, 66, '2000-02-22', 'Atacante', 7),
(78, 'Wayne Hennessey', 1.98, 90, '1987-01-24', 'Goleiro', 8),
(79, 'Ethan Ampadu', 1.83, 78, '2000-09-14', 'Zagueiro', 8),
(80, 'Ben Davies', 1.81, 76, '1993-04-24', 'Zagueiro', 8),
(81, 'Connor Roberts', 1.73, 75, '1995-09-23', 'Zagueiro', 8),
(82, 'Joe Rodon', 1.92, 87, '1997-10-22', 'Zagueiro', 8),
(83, 'Neco Williams', 1.83, 72, '2001-04-13', 'Zagueiro', 8),
(84, 'Joe Allen', 1.68, 62, '1990-03-14', 'Meia', 8),
(85, 'Aaron Ramsey', 1.8, 78, '1990-12-26', 'Meia', 8),
(86, 'Gareth Bale', 1.85, 81, '1989-07-16', 'Atacante', 8),
(87, 'Daniel James', 1.7, 76, '1997-11-10', 'Atacante', 8),
(88, 'Keiffer Moore', 1.96, 83, '1992-08-08', 'Atacante', 8),
(89, 'Emiliano Martínez', 1.95, 88, '1992-09-02', 'Goleiro', 9),
(90, 'Marcos Acuña', 1.72, 69, '1991-10-28', 'Zagueiro', 9),
(91, 'Nahuel Molina', 1.75, 70, '1998-04-06', 'Zagueiro', 9),
(92, 'Nicolás Otamendi', 1.83, 81, '1988-02-12', 'Zagueiro', 9),
(93, 'Cristian Romero', 1.85, 79, '1998-04-27', 'Zagueiro', 9),
(94, 'Rodrigo De Paul', 1.8, 70, '1994-05-24', 'Meia', 9),
(95, 'Ángel Di Maria', 1.8, 75, '1988-02-14', 'Meia', 9),
(96, 'Giovani Lo Celso', 1.77, 70, '1996-04-09', 'Meia', 9),
(97, 'Leandro Paredes', 1.8, 75, '1994-06-29', 'Meia', 9),
(98, 'Lautaro Martínez', 1.74, 72, '1992-08-22', 'Atacante', 9),
(99, 'Lionel Messi', 1.7, 72, '1987-06-24', 'Atacante', 9),
(100, 'Mohammed Al-Owais', 1.85, 70, '1991-10-10', 'Goleiro', 10),
(101, 'Abdulelah Al-Amri', 1.85, 74, '1997-01-15', 'Zagueiro', 10),
(102, 'Sultan Al-Ghannam', 1.73, 67, '1994-05-06', 'Zagueiro', 10),
(103, 'Yasser Al-Shahrani', 1.71, 62, '1992-05-25', 'Zagueiro', 10),
(104, 'Hassan Al-TAmbakti', 1.82, 73, '1999-02-09', 'Zagueiro', 10),
(105, 'Abdullah Madu', 1.87, 77, '1993-07-15', 'Zagueiro', 10),
(106, 'Salman Al-Faraj', 1.8, 62, '1989-08-01', 'Meia', 10),
(107, 'Abdulelah Al-Malki', 1.76, 69, '1994-10-11', 'Meia', 10),
(108, 'Mohamed Kanno', 1.91, 73, '1994-09-22', 'Meia', 10),
(109, 'Salem Al-Dawsari', 1.71, 72, '1991-08-19', 'Atacante', 10),
(110, 'Khalid Al-Ghannam', 1.71, 64, '2000-11-04', 'Atacante', 10),
(111, 'Guillermo Ochoa', 1.83, 78, '1985-07-13', 'Goleiro', 11),
(112, 'Néstor Araújo', 1.88, 87, '1991-08-29', 'Zagueiro', 11),
(113, 'Jesús Gallardo', 1.76, 73, '1994-08-15', 'Zagueiro', 11),
(114, 'César Montes', 1.91, 70, '1997-02-24', 'Zagueiro', 11),
(115, 'Joger Sánchez', 1.75, 71, '1997-12-10', 'Zagueiro', 11),
(116, 'Edson Álvarez', 1.87, 73, '1997-10-24', 'Meia', 11),
(117, 'Jesús Manuel Corona', 1.73, 62, '1993-01-06', 'Meia', 11),
(118, 'Hétor Herrera', 1.85, 78, '1990-04-19', 'Meia', 11),
(119, 'Carlos Rodríguez', 1.75, 66, '1997-01-03', 'Meia', 11),
(120, 'Raúl Jiménez', 1.9, 76, '1991-05-05', 'Atacante', 11),
(121, 'Hirving Lozano', 1.77, 70, '1995-07-30', 'Atacante', 11),
(122, 'Wojciech Szczesny', 1.92, 96, '1990-04-18', 'Goleiro', 12),
(123, 'Jan Bednarek', 1.89, 77, '1996-04-12', 'Zagueiro', 12),
(124, 'Bartosz Bereszynski', 1.83, 77, '1992-07-12', 'Zagueiro', 12),
(125, 'Matty Cash', 1.85, 64, '1997-08-07', 'Zagueiro', 12),
(126, 'Kamil Glik', 1.9, 80, '1988-02-03', 'Zagueiro', 12),
(127, 'Kamil Józwiak', 1.76, 70, '1998-04-22', 'Meia', 12),
(128, 'Grzegorz', 1.87, 84, '1990-01-29', 'Meia', 12),
(129, 'Jakub Moder', 1.88, 78, '1999-04-07', 'Meia', 12),
(130, 'Piotr Zielinski', 1.8, 75, '1994-05-20', 'Meia', 12),
(131, 'Robert Lewandowski', 1.84, 80, '1988-08-21', 'Atacante', 12),
(132, 'Arkadiusz Milik', 1.86, 76, '1994-02-28', 'Atacante', 12),
(133, 'Hugo Lloris', 1.88, 82, '1986-12-26', 'Goleiro', 13),
(134, 'Theo Hernández', 1.84, 81, '1997-10-06', 'Zagueiro', 13),
(135, 'Presnel Kimpembe', 1.82, 79, '1995-08-13', 'Zagueiro', 13),
(136, 'Jules Koundé', 1.8, 75, '1998-11-12', 'Zagueiro', 13),
(137, 'Raphael Varane', 1.91, 81, '1993-04-25', 'Zagueiro', 13),
(138, 'NGolo Kanté', 1.68, 70, '1991-03-29', 'Meia', 13),
(139, 'Paul Pogba', 1.91, 87, '1993-03-15', 'Meia', 13),
(140, 'Adrien Rabiot', 1.88, 72, '1995-04-03', 'Meia', 13),
(141, 'Karim Benzema', 1.85, 81, '1987-12-19', 'Atacante', 13),
(142, 'Antoine Griezmann', 1.76, 73, '1991-03-21', 'Atacante', 13),
(143, 'Kylian Mbappé', 1.78, 73, '1998-12-20', 'Atacante', 13),
(144, 'Mathew Ryan', 1.84, 82, '1992-04-08', 'Goleiro', 14),
(145, 'Aziz Behich', 1.7, 63, '1990-12-16', 'Zagueiro', 14),
(146, 'Rhyan Grant', 1.76, 79, '1991-02-26', 'Zagueiro', 14),
(147, 'Trent Sainsbury', 1.83, 76, '1992-01-05', 'Zagueiro', 14),
(148, 'Harry Souttar', 1.98, 79, '1998-10-22', 'Zagueiro', 14),
(149, 'Ajdin Hrustic', 1.83, 74, '1996-07-05', 'Meia', 14),
(150, 'Jackson Irvine', 1.89, 70, '1993-03-07', 'Meia', 14),
(151, 'Aaron Mooy', 1.74, 68, '1990-09-15', 'Meia', 14),
(152, 'Martin Boyle', 1.72, 53, '1993-04-25', 'Atacante', 14),
(153, 'Mitchel Duke', 1.86, 84, '1991-01-18', 'Atacante', 14),
(154, 'Mathew Leckie', 1.81, 82, '1991-02-04', 'Atacante', 14),
(155, 'Kasper Schmeichel', 1.89, 89, '1986-11-05', 'Goleiro', 15),
(156, 'Andreas Christensen', 1.87, 82, '1996-04-10', 'Zagueiro', 15),
(157, 'Simon Kjaer', 1.89, 82, '1989-03-26', 'Zagueiro', 15),
(158, 'Joakim Maehle', 1.84, 79, '1997-05-20', 'Zagueiro', 15),
(159, 'Jannik Vestergaad', 1.99, 96, '1992-08-03', 'Zagueiro', 15),
(160, 'Thomas Delaney', 1.82, 79, '1991-09-03', 'Meia', 15),
(161, 'Christian Eriksen', 1.82, 76, '1992-02-14', 'Meia', 15),
(162, 'Pierre Emile Hojbjerg', 1.87, 84, '1995-08-05', 'Meia', 15),
(163, 'Daniel Wass', 1.81, 74, '1989-05-31', 'Meia', 15),
(164, 'Martin Braithwaite', 1.77, 73, '1991-06-05', 'Atacante', 15),
(165, 'Yussuf Poulsen', 1.93, 78, '1994-06-15', 'Atacante', 15),
(166, 'Benchir Ben Said', 1.88, 80, '1994-11-29', 'Goleiro', 16),
(167, 'Dylan Bronn', 1.85, 76, '1995-06-19', 'Zagueiro', 16),
(168, 'Mohamed Drager', 1.78, 74, '1996-06-25', 'Zagueiro', 16),
(169, 'Ali Maâloul', 1.75, 72, '1990-01-01', 'Zagueiro', 16),
(170, 'Montassar Talbi', 1.9, 81, '1998-05-26', 'Zagueiro', 16),
(171, 'Wahbi Khazri', 1.82, 76, '1991-02-08', 'Meia', 16),
(172, 'Aissa Laidouni', 1.83, 75, '1996-12-13', 'Meia', 16),
(173, 'Ellyes Skhiri', 1.85, 73, '1995-05-10', 'Meia', 16),
(174, 'Anis Slimane', 1.88, 82, '2001-03-16', 'Meia', 16),
(175, 'Seifeddine Jaziri', 1.8, 71, '1993-02-12', 'Atacante', 16),
(176, 'Youssef Msakni', 1.79, 74, '1990-10-28', 'Atacante', 16),
(177, 'Unai Simon', 1.9, 88, '1997-06-11', 'Goleiro', 17),
(178, 'Eric Garcia', 1.82, 79, '2001-01-09', 'Zagueiro', 17),
(179, 'Jordi Alba', 1.7, 68, '1989-03-21', 'Zagueiro', 17),
(180, 'Aymeric Laporte', 1.89, 85, '1994-05-27', 'Zagueiro', 17),
(181, 'Cesar Azpilicueta', 1.78, 77, '1989-08-28', 'Zagueiro', 17),
(182, 'Sergio Busquets', 1.89, 76, '1988-07-16', 'Meia', 17),
(183, 'Gavi', 1.73, 68, '2004-08-05', 'Meia', 17),
(184, 'Pedri', 1.74, 60, '2002-11-25', 'Meia', 17),
(185, 'Dani Olmo', 1.79, 72, '1998-05-07', 'Atacante', 17),
(186, 'Ferran Torres', 1.84, 77, '2000-02-29', 'Atacante', 17),
(187, 'Alvaro Morata', 1.89, 82, '1992-10-23', 'Atacante', 17),
(188, 'Keylor Navas', 1.85, 80, '1986-12-15', 'Goleiro', 18),
(189, 'Francisco Calvo', 1.8, 88, '1992-07-08', 'Zagueiro', 18),
(190, 'Oscar Duarte', 1.86, 81, '1989-06-03', 'Zagueiro', 18),
(191, 'Keysher Fuller', 1.83, 78, '1994-07-12', 'Zagueiro', 18),
(192, 'Bryan Oviedo', 1.72, 70, '1990-02-18', 'Zagueiro', 18),
(193, 'Celso Borges', 1.82, 79, '1988-05-27', 'Meia', 18),
(194, 'Bryan Ruiz', 1.88, 81, '1985-08-18', 'Meia', 18),
(195, 'Yeltsin Tejeda', 1.79, 66, '1992-03-17', 'Meia', 18),
(196, 'Jewison Bennette', 1.75, 70, '2004-06-15', 'Atacante', 18),
(197, 'Joel Campbell', 1.78, 71, '1992-06-26', 'Atacante', 18),
(198, 'Anthony Contreras', 1.8, 72, '2000-01-29', 'Atacante', 18),
(199, 'Manuel Neuer', 1.93, 92, '1986-03-27', 'Goleiro', 19),
(200, 'Thilo Kehrer', 1.86, 76, '1996-09-21', 'Zagueiro', 19),
(201, 'David Raum', 1.8, 75, '1998-04-22', 'Zagueiro', 19),
(202, 'Antonio Rudiger', 1.9, 85, '1993-03-03', 'Zagueiro', 19),
(203, 'Niklas Sule', 1.95, 97, '1995-09-03', 'Zagueiro', 19),
(204, 'Leon Goretzka', 1.89, 79, '1995-02-06', 'Meia', 19),
(205, 'Kai Havertz', 1.89, 82, '1999-06-11', 'Meia', 19),
(206, 'Joshua Kimmich', 1.76, 73, '1995-02-08', 'Meia', 19),
(207, 'Serge Gnabry', 1.75, 75, '1995-07-14', 'Atacante', 19),
(208, 'Thomas Muller', 1.86, 75, '1989-09-13', 'Atacante', 19),
(209, 'Timo Werner', 1.8, 75, '1996-03-06', 'Atacante', 19),
(210, 'Shuichi Gonda', 1.87, 84, '1989-03-03', 'Goleiro', 20),
(211, 'Yuto Nagatomo', 1.7, 68, '1986-09-12', 'Zagueiro', 20),
(212, 'Takehiro Tomiyasu', 1.87, 84, '1998-11-05', 'Zagueiro', 20),
(213, 'Miki Yamane', 1.78, 72, '1993-12-22', 'Zagueiro', 20),
(214, 'Maya Yoshida', 1.89, 87, '1988-08-24', 'Zagueiro', 20),
(215, 'Wataru Endo', 1.78, 76, '1993-02-09', 'Meia', 20),
(216, 'Gaku Shibasaki', 1.75, 64, '1992-05-28', 'Meia', 20),
(217, 'Ao Tanaka', 1.8, 69, '1998-09-10', 'Meia', 20),
(218, 'Junya Ito', 1.76, 66, '1993-03-09', 'Atacante', 20),
(219, 'Takumi Minamino', 1.74, 68, '1995-01-16', 'Atacante', 20),
(220, 'Yuya Osako', 1.82, 71, '1990-05-18', 'Atacante', 20),
(221, 'Thibaut Courtois', 1.99, 96, '1992-05-11', 'Goleiro', 21),
(222, 'Toby Alderweireld', 1.86, 81, '1989-03-02', 'Zagueiro', 21),
(223, 'Jason Denayer', 1.84, 80, '1995-06-28', 'Zagueiro', 21),
(224, 'Thomas Meunier', 1.9, 82, '1991-09-12', 'Zagueiro', 21),
(225, 'Jan Vertonghen', 1.89, 86, '1987-04-24', 'Zagueiro', 21),
(226, 'Yannick Carrasco', 1.81, 73, '1993-09-04', 'Meia', 21),
(227, 'Kevin de Bruyne', 1.81, 68, '1991-06-28', 'Meia', 21),
(228, 'Youri Tielemans', 1.76, 72, '1997-05-07', 'Meia', 21),
(229, 'Axel Witsel', 1.86, 81, '1989-01-12', 'Meia', 21),
(230, 'Eden Hazard', 1.75, 74, '1991-01-07', 'Atacante', 21),
(231, 'Romelu Lukaku', 1.91, 94, '1993-05-13', 'Atacante', 21),
(232, 'Milan Borjan', 1.95, 80, '1987-10-23', 'Goleiro', 22),
(233, 'Alistair Johnston', 1.8, 77, '1998-10-08', 'Zagueiro', 22),
(234, 'Richie Laryea', 1.75, 68, '1995-01-07', 'Zagueiro', 22),
(235, 'Kamal Miller', 1.83, 84, '1997-05-16', 'Zagueiro', 22),
(236, 'Steven Vitoria', 1.95, 86, '1987-01-11', 'Zagueiro', 22),
(237, 'Tajon Buchanan', 1.83, 71, '1999-02-08', 'Meia', 22),
(238, 'Alphonso Davies', 1.83, 75, '2000-11-02', 'Meia', 22),
(239, 'Stephen Eustaquio', 1.75, 66, '1996-12-21', 'Meia', 22),
(240, 'Atiba Hutchinson', 1.85, 72, '1983-02-08', 'Meia', 22),
(241, 'Jonathan David', 1.8, 73, '2000-01-14', 'Atacante', 22),
(242, 'Cyle Larin', 1.88, 86, '1995-04-17', 'Atacante', 22),
(243, 'Yassine Bounou', 1.95, 78, '1991-04-05', 'Goleiro', 23),
(244, 'Nayef Aguerd', 1.88, 76, '1996-03-30', 'Zagueiro', 23),
(245, 'Achraf Hakimi', 1.81, 73, '1998-11-04', 'Zagueiro', 23),
(246, 'Adam Masina', 1.89, 78, '1994-01-02', 'Zagueiro', 23),
(247, 'Romain Saiss', 1.88, 84, '1990-03-26', 'Zagueiro', 23),
(248, 'Selim Amallah', 1.86, 82, '1996-11-15', 'Meia', 23),
(249, 'Sofyan Amrabat', 1.83, 70, '1996-08-21', 'Meia', 23),
(250, 'Imran Louza', 1.78, 65, '1999-05-01', 'Meia', 23),
(251, 'Sofiane Boufal', 1.75, 60, '1993-09-17', 'Atacante', 23),
(252, 'Youssef En-Nesyri', 1.89, 73, '1997-06-01', 'Atacante', 23),
(253, 'Ryan Mmaee', 1.88, 85, '1997-11-01', 'Atacante', 23),
(254, 'Dominik Livakovic', 1.87, 79, '1959-01-09', 'Goleiro', 24),
(255, 'Josko Gvardiol', 1.85, 80, '2002-01-23', 'Zagueiro', 24),
(256, 'Josip Juranovic', 1.75, 68, '1995-08-16', 'Zagueiro', 24),
(257, 'Dejan Lovren', 1.88, 84, '1989-07-05', 'Zagueiro', 24),
(258, 'Borna Sosa', 1.87, 79, '1998-01-21', 'Zagueiro', 24),
(259, 'Marcelo Brozovic', 1.81, 68, '1992-11-16', 'Meia', 24),
(260, 'Mateo Kovacic', 1.76, 80, '1994-05-06', 'Meia', 24),
(261, 'Luka Modric', 1.72, 66, '1985-09-09', 'Meia', 24),
(262, 'Ivan Perisic', 1.86, 80, '1989-02-02', 'Meia', 24),
(263, 'Nikola Vlasic', 1.78, 79, '1997-10-04', 'Meia', 24),
(264, 'Andrej Kramaric', 1.77, 73, '1991-06-19', 'Atacante', 24),
(265, 'Alisson', 1.91, 91, '1992-10-02', 'Goleiro', 25),
(266, 'Alez Sandro', 1.8, 80, '1991-01-26', 'Zagueiro', 25),
(267, 'Danilo', 1.84, 84, '1991-07-15', 'Zagueiro', 25),
(268, 'Marquinhos', 1.83, 75, '1994-05-14', 'Zagueio', 25),
(269, 'Thiago Silva', 1.83, 79, '1984-09-22', 'Zagueiro', 25),
(270, 'Casemiro', 1.85, 84, '1992-02-23', 'Meia', 25),
(271, 'Fred', 1.69, 72, '1993-03-05', 'Meia', 25),
(272, 'Lucas Paqueta', 1.8, 72, '1997-08-27', 'Meia', 25),
(273, 'Gabriel Jesus', 1.75, 68, '1994-04-27', 'Atacante', 25),
(274, 'Neymar Jr', 1.75, 68, '1992-02-05', 'Atacante', 25),
(275, 'Vinicius Jr', 1.76, 73, '2000-07-12', 'Atacante', 25),
(276, 'Predrag Rajkovic', 1.91, 85, '1995-10-31', 'Goleiro', 26),
(277, 'Nikola Milenkovic', 1.95, 92, '1997-10-12', 'Zagueiro', 26),
(278, 'Strahinja Pavlovic', 1.94, 84, '2001-05-24', 'Zagueiro', 26),
(279, 'Milos Veljkovic', 1.88, 85, '1995-09-26', 'Zagueiro', 26),
(280, 'Nemanja Gudelj', 1.87, 73, '1991-11-16', 'Meia', 26),
(281, 'Filip Kostic', 1.84, 82, '1992-11-01', 'Meia', 26),
(282, 'Darko Lazovic', 1.81, 66, '1990-09-15', 'Meia', 26),
(283, 'Sergej Milinkovic-Savic', 1.91, 76, '1995-02-27', 'Meia', 26),
(284, 'Aleksandar Mitrovic', 1.88, 90, '1994-09-16', 'Atacante', 26),
(285, 'Dusan Tadic', 1.81, 74, '1988-11-20', 'Atacante', 26),
(286, 'Dusan Vlahovic', 1.9, 75, '2000-01-28', 'Atacante', 26),
(287, 'Yann Sommer', 1, 79, '1988-12-17', 'Goleiro', 27),
(288, 'Manuel Akanji', 1.87, 91, '1995-07-19', 'Zagueiro', 27),
(289, 'Nico Elvedi', 1.89, 78, '1996-09-30', 'Zagueiro', 27),
(290, 'Ricardo Rodriguez', 1.82, 77, '1992-08-25', 'Zagueiro', 27),
(291, 'Silvan Widmer', 1.83, 79, '1993-03-05', 'Zagueiro', 27),
(292, 'Remo Freuler', 1.81, 77, '1992-04-15', 'Meia', 27),
(293, 'Xherdan Shaqiri', 1.69, 72, '1991-10-10', 'Meia', 27),
(294, 'Granit Xhaka', 1.85, 82, '1992-09-27', 'Meia', 27),
(295, 'Denis Zakaria', 1.9, 80, '1996-11-20', 'Meia', 27),
(296, 'Breel Embolo', 1.85, 84, '1997-02-14', 'Atacante', 27),
(297, 'Haris Seferovic', 1.87, 88, '1992-02-22', 'Atacante', 27),
(298, 'Andre Orana', 1.9, 93, '1996-04-02', 'Goleiro', 28),
(299, 'Jean-Charles Castelletto', 1.86, 78, '1995-01-26', 'Zagueiro', 28),
(300, 'Collins Fai', 1.65, 70, '1992-08-13', 'Zagueiro', 28),
(301, 'Michael Ngadeu', 1.9, 93, '1990-11-23', 'Zagueiro', 28),
(302, 'Nouhou', 1.78, 79, '1997-06-23', 'Zagueiro', 28),
(303, 'Samuel Oum Gouet', 1.85, 74, '1997-12-14', 'Meia', 28),
(304, 'Andre-Frank Zambo Anguissa', 1.84, 83, '1995-11-16', 'Meia', 28),
(305, 'Vincent Aboubakar', 1.83, 78, '1992-01-22', 'Atacante', 28),
(306, 'Eric Maxim Choupo-Moting', 1.91, 82, '1989-03-23', 'Atacante', 28),
(307, 'Nicolas Moumi Ngamaleu', 1.81, 74, '1994-07-09', 'Atacante', 28),
(308, 'Karl Toko Ekambi', 1.85, 78, '1992-09-14', 'Atacante', 28),
(309, 'Diogo Costa', 1.87, 81, '1999-09-19', 'Goleiro', 29),
(310, 'Joao Cancelo', 1.82, 74, '1994-05-27', 'Zagueiro', 29),
(311, 'Pepe', 1.88, 81, '1983-02-26', 'Zagueiro', 29),
(312, 'Raphael Guerreiro', 1.7, 71, '1993-12-22', 'Zagueiro', 29),
(313, 'Ruben Dias', 1.86, 83, '1997-05-14', 'Zagueiro', 29),
(314, 'Bernado Silva', 1.73, 64, '1994-08-10', 'Meia', 29),
(315, 'Bruno Fernandes', 1.79, 69, '1994-09-08', 'Meia', 29),
(316, 'Danilo Pereira', 1.88, 83, '1991-09-09', 'Meia', 29),
(317, 'Joao Moutinho', 1.7, 61, '1986-09-08', 'Meia', 29),
(318, 'Cristiano Ronaldo', 1.87, 83, '1985-02-05', 'Atacante', 29),
(319, 'Diogo Jota', 1.78, 73, '1996-12-04', 'Atacante', 29),
(320, 'Joe Wollacott', 1.9, 80, '1996-09-08', 'Goleiro', 30),
(321, 'Daniel Amartey', 1.86, 79, '1994-12-21', 'Zagueiro', 30),
(322, 'Abdul-Rahman Baba', 1.8, 72, '1994-07-02', 'Zagueiro', 30),
(323, 'Alexander Djiku', 1.82, 81, '1994-08-09', 'Zagueiro', 30),
(324, 'Andy Yiadom', 1.8, 75, '1991-12-02', 'Zagueiro', 30),
(325, 'Iddrisu Baba', 1.82, 73, '1996-01-22', 'Meia', 30),
(326, 'Mohammed Kudus', 1.77, 70, '2000-08-02', 'Meia', 30),
(327, 'Thomas Parttey', 1.85, 77, '1993-06-13', 'Meia', 30),
(328, 'Andre Ayew', 1.76, 72, '1089-12-17', 'Atacante', 30),
(329, 'Jordan Ayew', 1.82, 80, '1991-09-11', 'Atacante', 30),
(330, 'Kamaldeen Sulemana', 1.75, 70, '2002-02-15', 'Atacante', 30),
(331, 'Fernando Muslera', 1.9, 74, '1986-06-16', 'Goleiro', 31),
(332, 'Ronald Araujo', 1, 79, '1999-03-07', 'Zagueiro', 31),
(333, 'Jose Maria Gimenez', 1.85, 80, '1995-01-20', 'Zagueiro', 31),
(334, 'Diego Godin', 1.87, 79, '1986-02-16', 'Zagueiro', 31),
(335, 'Mathias Olivera', 1.85, 78, '1997-10-31', 'Zagueiro', 31),
(336, 'Rodrigo Bentancur', 1.87, 77, '1997-06-25', 'Meia', 31),
(337, 'Giorgian De Arrascaeta', 1.72, 70, '1994-06-01', 'Meia', 31),
(338, 'Nicolas De La Cruz', 1.67, 65, '1997-06-01', 'Meia', 31),
(339, 'Federico Valverde', 1, 78, '1998-07-22', 'Meia', 31),
(340, 'Edinson Cavani', 1.84, 71, '1987-02-14', 'Atacante', 31),
(341, 'Luis Suarez', 1.82, 86, '1987-01-24', 'Atacante', 31),
(342, 'Seung-Gyu Kim', 1.87, 84, '1990-09-30', 'Goleiro', 32),
(343, 'Min-Jae Kim', 1.9, 88, '1996-11-15', 'Zagueiro', 32),
(344, 'Young-Gwon Kim', 1.86, 83, '1990-02-27', 'Zagueiro', 32),
(345, 'Jin-Sun Kim', 1.77, 68, '1992-06-13', 'Zagueiro', 32),
(346, 'Young Lee', 1.8, 74, '1986-12-24', 'Zagueiro', 32),
(347, 'In-Beom Hwang', 1.77, 70, '1996-09-02', 'Meia', 32),
(348, 'Woo-Young Jung', 1.86, 78, '1989-12-14', 'Meia', 32),
(349, 'Jae-Sung Lee', 1.8, 70, '1992-08-10', 'Meia', 32),
(350, 'Hee-Chan Hwang', 1.77, 77, '1996-01-26', 'Atacante', 32),
(351, 'Ui-Jo Hwang', 1.83, 73, '1992-08-28', 'Atacante', 32),
(352, 'Heung-Min Son', 1.83, 78, '1992-07-08', 'Atacante', 32);

-- --------------------------------------------------------

--
-- Estrutura da tabela `tb_times`
--

CREATE TABLE `tb_times` (
  `id` int(11) NOT NULL,
  `abrv` text DEFAULT NULL,
  `nome_times` text DEFAULT NULL,
  `grupo` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `tb_times`
--

INSERT INTO `tb_times` (`id`, `abrv`, `nome_times`, `grupo`) VALUES
(1, 'QAT', 'Qatar', 'A'),
(2, 'ECU', 'Ecuador', 'A'),
(3, 'SEN', 'Senegal', 'A'),
(4, 'NED', 'Netherlands', 'A'),
(5, 'ENG', 'England', 'B'),
(6, 'IRN', 'Iran', 'B'),
(7, 'USA', 'USA', 'B'),
(8, 'WAL', 'Wales', 'B'),
(9, 'ARG', 'Argentina', 'C'),
(10, 'KSA', 'Saudi Arabia', 'C'),
(11, 'MEX', 'Mexico', 'C'),
(12, 'POL', 'Poland', 'C'),
(13, 'FRA', 'France', 'D'),
(14, 'AUS', 'Australia', 'D'),
(15, 'DEN', 'Denmark', 'D'),
(16, 'TUN', 'Tunisia', 'D'),
(17, 'ESP', 'Spain', 'E'),
(18, 'CRC', 'Costa Rica', 'E'),
(19, 'GER', 'Germany', 'E'),
(20, 'JPN', 'Japan', 'E'),
(21, 'BEL', 'Belgium', 'F'),
(22, 'CAN', 'Canada', 'F'),
(23, 'MAR', 'Morocco', 'F'),
(24, 'CRO', 'Croatia', 'F'),
(25, 'BRA', 'Brazil', 'G'),
(26, 'SRB', 'Serbia', 'G'),
(27, 'SUI', 'Switzerland', 'G'),
(28, 'CMR', 'Cameroon', 'G'),
(29, 'POR', 'Portugal', 'H'),
(30, 'GHA', 'Ghana', 'H'),
(31, 'URU', 'Uruguay', 'H'),
(32, 'KOR', 'Korea Republic', 'H');

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `tb_jogadores`
--
ALTER TABLE `tb_jogadores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_times` (`id_times`);

--
-- Índices para tabela `tb_times`
--
ALTER TABLE `tb_times`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `tb_jogadores`
--
ALTER TABLE `tb_jogadores`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=353;

--
-- AUTO_INCREMENT de tabela `tb_times`
--
ALTER TABLE `tb_times`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- Restrições para despejos de tabelas
--

--
-- Limitadores para a tabela `tb_jogadores`
--
ALTER TABLE `tb_jogadores`
  ADD CONSTRAINT `tb_jogadores_ibfk_1` FOREIGN KEY (`id_times`) REFERENCES `tb_times` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;