-- phpMyAdmin SQL Dump
-- phpMyAdmin SQL Dump
-- version 3.2.5
--
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 27-08-2010 a las 17:54:15
-- Versión del servidor: 5.1.43
-- Versión de PHP: 5.3.2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de datos: `mundial_2010`
--
CREATE DATABASE `mundial_2010` DEFAULT CHARACTER SET latin1 COLLATE latin1_spanish_ci;
USE `mundial_2010`;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `dt`
--
CREATE TABLE IF NOT EXISTS `dt` (
`id` tinyint(3) unsigned NOT NULL,
`nombre` varchar(23) COLLATE latin1_spanish_ci NOT NULL,
`nacionalidad` varchar(15) COLLATE latin1_spanish_ci NOT NULL,
`id_sel` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `id_sel` (`id_sel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `dt`
--
INSERT INTO `dt` (`id`, `nombre`, `nacionalidad`, `id_sel`) VALUES
(1, 'Joachim LOEW ', 'Alemania', 13),
(2, 'Ottmar HITZFELD', 'Alemania', 30),
(3, 'Otto REHHAGEL', 'Alemania', 8),
(4, 'Rabah SAADANE', 'Algeria', 11),
(5, 'Diego MARADONA', 'Argentina', 5),
(6, 'Gerardo MARTINO', 'Argentina', 22),
(7, 'Marcelo BIELSA', 'Argentina', 32),
(8, 'Carlos Alberto PARREIRA', 'Brasil', 1),
(9, 'DUNGA', 'Brasil', 25),
(10, 'Reinaldo RUEDA', 'Colombia', 31),
(11, 'KIM Jong Hun', 'Corea del Norte', 26),
(12, 'HUH Jung Moo', 'Corea del Sur', 7),
(13, 'Morten OLSEN', 'Dinamarca', 18),
(14, 'Matjaz KEK', 'Eslovenia', 12),
(15, 'Vladimir WEISS', 'Eslovequia', 24),
(16, 'Vicente DEL BOSQUE', 'España', 29),
(17, 'Paul LE GUEN', 'Francia', 20),
(18, 'Raymond DOMENECH', 'Francia', 4),
(19, 'Bert VAN MARWIJK', 'Holanda', 17),
(20, 'Pim VERBEEK', 'Holanda', 14),
(21, 'Fabio CAPELLO', 'Italia', 9),
(22, 'Marcello LIPPI', 'Italia', 21),
(23, 'Takeshi OKADA', 'Japón', 19),
(24, 'Javier AGUIRRE', 'México', 2),
(25, 'Ricki HERBERT', 'Nueva Zelandia', 23),
(26, 'Carlos QUEIROZ', 'Portugal', 28),
(27, 'Milovan RAJEVAC', 'Serbia', 16),
(28, 'Radomir ANTIC', 'Serbia', 15),
(29, 'Lars LAGERBACK', 'Suiza', 6),
(30, 'Sven Göran ERIKSSON', 'Suiza', 27),
(31, 'Oscar TABAREZ', 'Uruguay', 3),
(32, 'Bob BRADLEY', 'USA', 10);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `estadio`
--
CREATE TABLE IF NOT EXISTS `estadio` (
`id` tinyint(3) unsigned NOT NULL,
`nombre` varchar(18) COLLATE latin1_spanish_ci NOT NULL,
`ciudad` varchar(34) COLLATE latin1_spanish_ci NOT NULL,
`capacidad` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `estadio`
--
INSERT INTO `estadio` (`id`, `nombre`, `ciudad`, `capacidad`) VALUES
(1, 'Green Point', 'Cape Town', 64100),
(2, 'Durban Stadium', 'Durban', 62760),
(3, 'Ellis Park Stadium', 'Johannesburg', 55686),
(4, 'Soccer City', 'Johannesburg', 65535),
(5, 'Port Elizabeth', 'Nelson Mandela Bay/Port Elizabeth ', 42486),
(6, 'Mbombela', 'Nelspruit', 40929),
(7, 'Peter Mokaba', 'Polokwane', 41733),
(8, 'Royal Bafokeng', 'Rustenburg', 38646),
(9, 'Loftus Versfeld', 'Tshwane/Pretoria ', 42858),
(10, 'Free State', 'Mangaung / Bloemfontein', 40911);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `gol`
--
CREATE TABLE IF NOT EXISTS `gol` (
`id_partido` tinyint(3) unsigned NOT NULL,
`minuto` tinyint(3) unsigned NOT NULL,
`id_sel` tinyint(3) unsigned NOT NULL,
`nro` tinyint(3) unsigned NOT NULL,
`tipo` char(1) COLLATE latin1_spanish_ci NOT NULL DEFAULT '-',
PRIMARY KEY (`id_partido`,`minuto`),
KEY `id_sel` (`id_sel`,`nro`),
KEY `id_partido` (`id_partido`),
KEY `id_sel_2` (`id_sel`,`nro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `gol`
--
INSERT INTO `gol` (`id_partido`, `minuto`, `id_sel`, `nro`, `tipo`) VALUES
(1, 55, 1, 8, '-'),
(1, 79, 2, 4, '-'),
(3, 6, 5, 6, '-'),
(4, 7, 7, 14, '-'),
(4, 52, 7, 7, '-'),
(5, 4, 9, 4, '-'),
(5, 40, 10, 8, '-'),
(6, 79, 12, 8, '-'),
(7, 8, 13, 10, '-'),
(7, 26, 13, 11, '-'),
(7, 68, 13, 13, '-'),
(7, 70, 13, 19, '-'),
(8, 85, 16, 3, 'P'),
(9, 46, 18, 4, 'E'),
(9, 85, 17, 7, '-'),
(10, 39, 19, 18, '-'),
(11, 39, 22, 21, '-'),
(11, 63, 21, 6, '-'),
(12, 50, 24, 11, '-'),
(12, 93, 23, 4, '-'),
(14, 55, 25, 2, '-'),
(14, 72, 25, 7, '-'),
(14, 89, 26, 8, '-'),
(15, 34, 32, 15, '-'),
(16, 52, 30, 16, '-'),
(17, 24, 3, 10, '-'),
(17, 80, 3, 10, 'P'),
(17, 95, 3, 11, '-'),
(18, 64, 2, 14, '-'),
(18, 79, 2, 10, '-'),
(19, 16, 6, 12, '-'),
(19, 44, 8, 14, '-'),
(19, 71, 8, 15, '-'),
(20, 17, 7, 10, 'E'),
(20, 33, 5, 9, '-'),
(20, 46, 7, 17, '-'),
(20, 76, 5, 9, '-'),
(20, 80, 5, 9, '-'),
(21, 38, 15, 14, '-'),
(22, 13, 12, 10, '-'),
(22, 42, 12, 9, '-'),
(22, 48, 10, 10, '-'),
(22, 82, 10, 4, '-'),
(24, 11, 14, 14, '-'),
(24, 25, 16, 3, 'P'),
(25, 53, 17, 10, '-'),
(26, 10, 20, 9, '-'),
(26, 33, 18, 11, '-'),
(26, 61, 18, 19, '-'),
(27, 27, 22, 13, '-'),
(27, 86, 22, 16, '-'),
(28, 7, 23, 9, '-'),
(28, 29, 21, 9, 'P'),
(29, 25, 25, 9, '-'),
(29, 50, 25, 9, '-'),
(29, 62, 25, 7, '-'),
(29, 79, 27, 11, '-'),
(30, 29, 28, 16, '-'),
(30, 53, 28, 11, '-'),
(30, 56, 28, 18, '-'),
(30, 60, 28, 19, '-'),
(30, 81, 28, 9, '-'),
(30, 87, 28, 7, '-'),
(30, 89, 28, 19, '-'),
(31, 75, 32, 11, '-'),
(32, 17, 29, 7, '-'),
(32, 51, 29, 7, '-'),
(33, 43, 3, 9, '-'),
(34, 20, 1, 20, '-'),
(34, 37, 1, 9, '-'),
(34, 70, 4, 15, '-'),
(35, 12, 6, 12, '-'),
(35, 38, 7, 14, '-'),
(35, 49, 7, 10, '-'),
(35, 69, 6, 8, 'P'),
(36, 77, 5, 2, '-'),
(36, 89, 5, 18, '-'),
(37, 23, 9, 19, '-'),
(38, 91, 10, 10, '-'),
(39, 60, 13, 8, '-'),
(40, 69, 14, 4, '-'),
(40, 73, 14, 14, '-'),
(40, 84, 15, 9, '-'),
(41, 25, 24, 11, '-'),
(41, 73, 24, 11, '-'),
(41, 81, 21, 10, '-'),
(41, 89, 24, 20, '-'),
(41, 92, 21, 18, '-'),
(43, 17, 19, 18, '-'),
(43, 30, 19, 7, '-'),
(43, 81, 18, 9, '-'),
(43, 87, 19, 9, '-'),
(44, 36, 17, 9, '-'),
(44, 65, 20, 9, 'P'),
(44, 83, 17, 21, '-'),
(46, 14, 27, 19, '-'),
(46, 20, 27, 13, '-'),
(46, 82, 27, 8, '-'),
(47, 24, 29, 7, '-'),
(47, 37, 29, 6, '-'),
(47, 47, 32, 20, '-'),
(49, 8, 3, 9, '-'),
(49, 68, 7, 17, '-'),
(49, 80, 3, 9, '-'),
(50, 5, 16, 23, '-'),
(50, 62, 10, 10, 'P'),
(50, 93, 16, 3, '-'),
(51, 20, 13, 11, '-'),
(51, 32, 13, 10, '-'),
(51, 37, 9, 15, '-'),
(51, 67, 13, 13, '-'),
(51, 70, 13, 13, '-'),
(52, 26, 5, 11, '-'),
(52, 33, 5, 9, '-'),
(52, 52, 5, 11, '-'),
(52, 71, 2, 14, '-'),
(53, 18, 17, 11, '-'),
(53, 84, 17, 10, '-'),
(53, 94, 24, 11, 'P'),
(54, 35, 25, 4, '-'),
(54, 38, 25, 9, '-'),
(54, 59, 25, 11, '-'),
(56, 63, 29, 7, '-'),
(57, 10, 25, 11, '-'),
(57, 53, 17, 10, '-'),
(57, 68, 17, 10, '-'),
(58, 47, 16, 11, '-'),
(58, 55, 3, 10, '-'),
(59, 3, 13, 13, '-'),
(59, 68, 13, 11, '-'),
(59, 74, 13, 3, '-'),
(59, 89, 13, 11, '-'),
(60, 83, 29, 7, '-'),
(61, 18, 17, 5, '-'),
(61, 41, 3, 10, '-'),
(61, 70, 17, 10, '-'),
(61, 73, 17, 11, '-'),
(61, 92, 3, 16, '-'),
(62, 73, 29, 5, '-'),
(63, 19, 13, 13, '-'),
(63, 28, 3, 7, '-'),
(63, 51, 3, 10, '-'),
(63, 56, 13, 2, '-'),
(63, 82, 13, 6, '-'),
(64, 116, 29, 6, '-');
-- --------------------------------------------------------
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `jugador`
--
CREATE TABLE IF NOT EXISTS `jugador` (
`id` tinyint(3) unsigned NOT NULL,
`nro` tinyint(3) unsigned NOT NULL,
`nombre` varchar(25) COLLATE latin1_spanish_ci NOT NULL,
`fecha_nac` date NOT NULL,
`posicion` varchar(11) COLLATE latin1_spanish_ci NOT NULL,
`club` varchar(31) COLLATE latin1_spanish_ci NOT NULL,
`altura` decimal(3,2) NOT NULL,
PRIMARY KEY (`id`,`nro`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `jugador`
--
INSERT INTO `jugador` (`id`, `nro`, `nombre`, `fecha_nac`, `posicion`, `club`, `altura`) VALUES
(1, 1, 'Moneeb JOSEPHS', '1980-05-19', 'arquero', 'Orlando Pirates (RSA)', 1.84),
(1, 2, 'Siboniso GAXA', '1984-04-06', 'defensa', 'Mamelodi Sundowns (RSA)', 1.78),
(1, 3, 'Tsepo MASILELA', '1985-05-05', 'defensa', 'Maccabi Haifa (ISR)', 1.74),
(1, 4, 'Aaron MOKOENA', '1980-11-25', 'defensa', 'Portsmouth (ENG)', 1.83),
(1, 5, 'Anele NGCONGCA', '1987-10-20', 'defensa', 'Racing Genk (BEL)', 1.77),
(1, 6, 'MacBeth SIBAYA', '1977-11-25', 'medio', 'Rubin Kazan (RUS)', 1.76),
(1, 7, 'Lance DAVIDS', '1985-04-11', 'medio', 'Ajax Cape Town (RSA)', 1.71),
(1, 8, 'Siphiwe TSHABALALA', '1984-09-25', 'medio', 'Kaizer Chiefs (RSA)', 1.70),
(1, 9, 'Katlego MPHELA', '1984-11-29', 'delantero', 'Mamelodi Sundowns (RSA)', 1.80),
(1, 10, 'Steven PIENAAR', '1982-03-17', 'medio', 'Everton (ENG)', 1.73),
(1, 11, 'Teko MODISE', '1982-12-22', 'medio', 'Orlando Pirates (RSA)', 1.72),
(1, 12, 'Reneilwe LETSHOLONYANE', '1982-06-09', 'medio', 'Kaizer Chiefs (RSA)', 1.73),
(1, 13, 'Kagisho DIKGACOI', '1984-11-24', 'medio', 'Fulham (ENG)', 1.80),
(1, 14, 'Matthew BOOTH', '1977-03-14', 'defensa', 'Mamelodi Sundowns (RSA)', 1.98),
(1, 15, 'Lucas THWALA', '1981-10-19', 'defensa', 'Orlando Pirates (RSA)', 1.70),
(1, 16, 'Itumeleng KHUNE', '1987-06-20', 'arquero', 'Kaizer Chiefs (RSA)', 1.80),
(1, 17, 'Bernard PARKER', '1986-03-16', 'delantero', 'Twente Enschede (NED)', 1.72),
(1, 18, 'Siyabonga NOMVETHE', '1977-12-02', 'delantero', 'Moroka Swallows (RSA)', 1.73),
(1, 19, 'Surprise MORIRI', '1980-03-20', 'medio', 'Mamelodi Sundowns (RSA)', 1.73),
(1, 20, 'Bongani KHUMALO', '1987-01-06', 'defensa', 'SuperSport Utd. (RSA)', 1.84),
(1, 21, 'Siyabonga SANGWENI', '1981-09-29', 'defensa', 'Golden Arrows (RSA)', 1.82),
(1, 22, 'Shu-Aib WALTERS', '1981-12-26', 'arquero', 'Maritzburg Utd. (RSA)', 1.88),
(1, 23, 'Thanduyise KHUBONI', '1986-05-23', 'medio', 'Golden Arrows (RSA)', 1.81),
(2, 1, 'Oscar PEREZ', '1973-02-01', 'arquero', 'Jaguares (MEX)', 1.74),
(2, 2, 'Francisco RODRIGUEZ', '1981-10-20', 'defensa', 'PSV Eindhoven (NED)', 1.91),
(2, 3, 'Carlos SALCIDO', '1980-04-02', 'defensa', 'PSV Eindhoven (NED)', 1.76),
(2, 4, 'Rafael MARQUEZ', '1979-02-13', 'defensa', 'Barcelona (ESP)', 1.82),
(2, 5, 'Ricardo OSORIO', '1980-03-30', 'defensa', 'VfB Stuttgart (GER)', 1.73),
(2, 6, 'Gerardo TORRADO', '1979-04-30', 'medio', 'Cruz Azul (MEX)', 1.74),
(2, 7, 'Pablo BARRERA', '1987-06-21', 'delantero', 'Pumas UNAM (MEX)', 1.72),
(2, 8, 'Israel CASTRO', '1980-12-20', 'medio', 'Pumas UNAM (MEX)', 1.75),
(2, 9, 'Guillermo FRANCO', '1976-11-03', 'delantero', 'West Ham Utd. (ENG)', 1.82),
(2, 10, 'Cuauhtemoc BLANCO', '1973-01-17', 'delantero', 'Veracruz (MEX)', 1.77),
(2, 11, 'Carlos VELA', '1989-03-01', 'delantero', 'Arsenal (ENG)', 1.79),
(2, 12, 'Paul AGUILAR', '1986-03-06', 'defensa', 'Pachuca (MEX)', 1.78),
(2, 13, 'Guillermo OCHOA', '1985-07-13', 'arquero', 'America (MEX)', 1.83),
(2, 14, 'Javier HERNANDEZ', '1988-06-01', 'delantero', 'Chivas (MEX)', 1.75),
(2, 15, 'Hector MORENO', '1988-01-17', 'defensa', 'AZ Alkmaar (NED)', 1.84),
(2, 16, 'Efrain JUAREZ', '1988-02-22', 'defensa', 'Pumas UNAM (MEX)', 1.75),
(2, 17, 'Giovani DOS SANTOS', '1989-05-11', 'delantero', 'Galatasaray (TUR)', 1.75),
(2, 18, 'Andres GUARDADO', '1986-09-28', 'medio', 'Deportivo La Coruna (ESP)', 1.69),
(2, 19, 'Jonny MAGALLON', '1981-11-21', 'defensa', 'Chivas (MEX)', 1.78),
(2, 20, 'Jorge TORRES', '1988-01-16', 'medio', 'Atlas (MEX)', 1.82),
(2, 21, 'Adolfo BAUTISTA', '1979-05-15', 'delantero', 'Chivas (MEX)', 1.85),
(2, 22, 'Alberto MEDINA', '1983-05-29', 'delantero', 'Chivas (MEX)', 1.72),
(2, 23, 'Luis MICHEL', '1979-07-21', 'arquero', 'Chivas (MEX)', 1.83),
(3, 1, 'Fernando MUSLERA', '1986-06-16', 'arquero', 'Lazio (ITA)', 1.90),
(3, 2, 'Diego LUGANO', '1980-11-02', 'defensa', 'Fenerbahce (TUR)', 1.88),
(3, 3, 'Diego GODIN', '1986-02-16', 'defensa', 'Villarreal (ESP)', 1.85),
(3, 4, 'Jorge FUCILE', '1984-11-19', 'defensa', 'Porto (POR)', 1.77),
(3, 5, 'Walter GARGANO', '1984-07-23', 'medio', 'Napoli (ITA)', 1.68),
(3, 6, 'Mauricio VICTORINO', '1982-10-11', 'defensa', 'Univ. de Chile (CHI)', 1.82),
(3, 7, 'Edinson CAVANI', '1987-02-14', 'delantero', 'Palermo (ITA)', 1.88),
(3, 8, 'Sebastian EGUREN', '1981-01-08', 'medio', 'AIK Stockholm (SWE)', 1.86),
(3, 9, 'Luis SUAREZ', '1987-01-24', 'delantero', 'Ajax (NED)', 1.81),
(3, 10, 'Diego FORLAN', '1979-05-19', 'delantero', 'Atletico Madrid (ESP)', 1.81),
(3, 11, 'Alvaro PEREIRA', '1985-11-28', 'medio', 'Porto (POR)', 1.82),
(3, 12, 'Juan CASTILLO', '1978-04-17', 'arquero', 'Deportivo Cali (COL)', 1.81),
(3, 13, 'Sebastian ABREU', '1976-10-17', 'delantero', 'Botafogo (BRA)', 1.93),
(3, 14, 'Nicolas LODEIRO', '1989-03-21', 'medio', 'Ajax (NED)', 1.73),
(3, 15, 'Diego PEREZ', '1980-05-18', 'medio', 'Monaco (FRA)', 1.76),
(3, 16, 'Maximiliano PEREIRA', '1984-06-08', 'defensa', 'Benfica (POR)', 1.73),
(3, 17, 'Egidio AREVALO RÏOS', '1982-01-01', 'medio', 'Peñarol (URU)', 1.68),
(3, 18, 'Ignacio GONZALEZ', '1982-05-14', 'medio', 'Valencia (ESP)', 1.80),
(3, 19, 'Andres SCOTTI', '1975-12-14', 'defensa', 'Colo Colo (CHI)', 1.83),
(3, 20, 'Alvaro FERNANDEZ', '1985-10-11', 'medio', 'Univ. de Chile (CHI)', 1.85),
(3, 21, 'Sebastian FERNANDEZ', '1985-05-23', 'delantero', 'Banfield (ARG)', 1.67),
(3, 22, 'Martin CACERES', '1987-04-07', 'defensa', 'Juventus (ITA)', 1.78),
(3, 23, 'Martin SILVA', '1983-03-25', 'arquero', 'Defensor Sporting (URU)', 1.87),
(4, 1, 'Hugo LLORIS', '1986-12-26', 'arquero', 'Lyon (FRA)', 1.88),
(4, 2, 'Bakari SAGNA', '1983-02-14', 'defensa', 'Arsenal (ENG)', 1.75),
(4, 3, 'Eric ABIDAL', '1979-09-11', 'defensa', 'Barcelona (ESP)', 1.80),
(4, 4, 'Anthony REVEILLERE', '1979-11-10', 'defensa', 'Lyon (FRA)', 1.81),
(4, 5, 'William GALLAS', '1977-08-17', 'defensa', 'Arsenal (ENG)', 1.81),
(4, 6, 'Marc PLANUS', '1982-03-07', 'defensa', 'Bordeaux (FRA)', 1.83),
(4, 7, 'Franck RIBERY', '1983-04-07', 'delantero', 'Bayern Munich (GER)', 1.75),
(4, 8, 'Yoann GOURCUFF', '1986-07-11', 'medio', 'Bordeaux (FRA)', 1.85),
(4, 9, 'Djibril CISSE', '1981-08-12', 'delantero', 'Panathinaikos (GRE)', 1.82),
(4, 10, 'Sidney GOVOU', '1979-07-27', 'delantero', 'Lyon (FRA)', 1.75),
(4, 11, 'Andre Pierre GIGNAC', '1985-12-05', 'delantero', 'Toulouse (FRA)', 1.87),
(4, 12, 'Thierry HENRY', '1977-08-17', 'delantero', 'Barcelona (ESP)', 1.88),
(4, 13, 'Patrice EVRA', '1981-05-15', 'defensa', 'Manchester Utd. (ENG)', 1.71),
(4, 14, 'Jeremy TOULALAN', '1983-09-10', 'medio', 'Lyon (FRA)', 1.83),
(4, 15, 'Florent MALOUDA', '1980-06-13', 'medio', 'Chelsea (ENG)', 1.84),
(4, 16, 'Steve MANDANDA', '1985-03-28', 'arquero', 'Marseille (FRA)', 1.85),
(4, 17, 'Sebastien SQUILLACI', '1980-08-11', 'defensa', 'Sevilla FC (ESP)', 1.84),
(4, 18, 'Alou DIARRA', '1981-07-15', 'medio', 'Bordeaux (FRA)', 1.90),
(4, 19, 'Abou DIABY', '1986-05-11', 'medio', 'Arsenal (ENG)', 1.88),
(4, 20, 'Mathieu VALBUENA', '1984-09-28', 'delantero', 'Marseille (FRA)', 1.67),
(4, 21, 'Nicolas ANELKA', '1979-03-14', 'delantero', 'Chelsea (ENG)', 1.85),
(4, 22, 'Gael CLICHY', '1985-07-26', 'defensa', 'Arsenal (ENG)', 1.81),
(4, 23, 'Cedric CARRASSO', '1981-12-30', 'arquero', 'Bordeaux (FRA)', 1.87),
(5, 1, 'Diego POZO', '1978-02-16', 'arquero', 'Atletico Colon (ARG)', 1.83),
(5, 2, 'Martin DEMICHELIS', '1980-12-20', 'defensa', 'Bayern Munich (GER)', 1.84),
(5, 3, 'Clemente RODRIGUEZ', '1981-07-31', 'defensa', 'Estudiantes La Plata (ARG)', 1.66),
(5, 4, 'Nicolas BURDISSO', '1981-04-12', 'defensa', 'AS Roma (ITA)', 1.74),
(5, 5, 'Mario BOLATTI', '1985-02-17', 'medio', 'Fiorentina (ITA)', 1.89),
(5, 6, 'Gabriel HEINZE', '1978-04-19', 'defensa', 'Marseille (FRA)', 1.78),
(5, 7, 'Angel DI MARIA', '1988-02-14', 'medio', 'Benfica (POR)', 1.80),
(5, 8, 'Juan VERON', '1975-03-09', 'medio', 'Estudiantes La Plata (ARG)', 1.83),
(5, 9, 'Gonzalo HIGUAIN', '1987-12-10', 'delantero', 'Real Madrid (ESP)', 1.82),
(5, 10, 'Lionel MESSI', '1987-06-24', 'delantero', 'Barcelona (ESP)', 1.70),
(5, 11, 'Carlos TEVEZ', '1984-02-05', 'delantero', 'Manchester City (ENG)', 1.73),
(5, 12, 'Ariel GARCE', '1979-07-14', 'defensa', 'Atletico Colon (ARG)', 1.75),
(5, 13, 'Walter SAMUEL', '1978-03-23', 'defensa', 'Inter (ITA)', 1.82),
(5, 14, 'Javier MASCHERANO', '1984-06-08', 'medio', 'Liverpool (ENG)', 1.71),
(5, 15, 'Nicolas OTAMENDI', '1988-02-12', 'defensa', 'Velez Sarsfield (ARG)', 1.71),
(5, 16, 'Sergio AGUERO', '1988-06-02', 'delantero', 'Atletico Madrid (ESP)', 1.70),
(5, 17, 'Jonas GUTIERREZ', '1983-07-05', 'medio', 'Newcastle Utd. (ENG)', 1.82),
(5, 18, 'Martin PALERMO', '1973-11-07', 'delantero', 'Boca Juniors (ARG)', 1.88),
(5, 19, 'Diego MILITO', '1979-06-12', 'delantero', 'Inter (ITA)', 1.77),
(5, 20, 'Maxi RODRIGUEZ', '1981-01-02', 'medio', 'Liverpool (ENG)', 1.73),
(5, 21, 'Mariano ANDUJAR', '1983-07-30', 'arquero', 'Catania (ITA)', 1.80),
(5, 22, 'Sergio ROMERO', '1987-02-22', 'arquero', 'AZ Alkmaar (NED)', 1.91),
(5, 23, 'Javier PASTORE', '1989-06-20', 'medio', 'Palermo (ITA)', 1.73),
(6, 1, 'Vincent ENYEAMA', '1982-08-29', 'arquero', 'Hapoel Tel-Aviv (ISR)', 1.85),
(6, 2, 'Joseph YOBO', '1980-09-06', 'defensa', 'Everton (ENG)', 1.85),
(6, 3, 'Taye TAIWO', '1985-04-16', 'defensa', 'Marseille (FRA)', 1.88),
(6, 4, 'Nwankwo KANU', '1976-08-01', 'medio', 'Portsmouth (ENG)', 1.97),
(6, 5, 'Rabiu AFOLABI', '1980-04-18', 'defensa', 'Red Bull Salzburg (AUT)', 1.83),
(6, 6, 'Danny SHITTU', '1980-09-02', 'defensa', 'Bolton Wanderers (ENG)', 1.90),
(6, 7, 'John UTAKA', '1982-01-08', 'delantero', 'Portsmouth (ENG)', 1.79),
(6, 8, 'Yakubu AYEGBENI', '1982-11-22', 'delantero', 'Everton (ENG)', 1.88),
(6, 9, 'Obafemi MARTINS', '1984-10-28', 'delantero', 'Wolfsburg (GER)', 1.70),
(6, 10, 'Brown IDEYE', '1988-10-10', 'delantero', 'Sochaux (FRA)', 1.80),
(6, 11, 'Peter ODEMWINGIE', '1981-07-15', 'delantero', 'Lokomotiv Moscow (RUS)', 1.81),
(6, 12, 'Kalu UCHE', '1982-11-15', 'medio', 'Almeria (ESP)', 1.71),
(6, 13, 'Yussuf AYILA', '1984-11-04', 'medio', 'Dynamo Kyiv (UKR)', 1.79),
(6, 14, 'Sani KAITA', '1986-05-02', 'medio', 'Alania Vladikavkaz (RUS)', 1.80),
(6, 15, 'Lukman HARUNA', '1990-12-04', 'medio', 'Monaco (FRA)', 1.77),
(6, 16, 'Austin EJIDE', '1984-04-08', 'arquero', 'Hapoel Petah Tikva (ISR)', 1.86),
(6, 17, 'Chidi ODIAH', '1983-12-17', 'defensa', 'CSKA Moscow (RUS)', 1.81),
(6, 18, 'Victor OBINNA', '1987-03-25', 'delantero', 'Malaga (ESP)', 1.78),
(6, 19, 'Chinedu OGBUKE OBASI', '1986-06-01', 'delantero', 'Hoffenheim (GER)', 1.81),
(6, 20, 'Dickson ETUHU', '1982-06-08', 'medio', 'Fulham (ENG)', 1.91),
(6, 21, 'Uwa ECHIEJILE', '1988-01-20', 'defensa', 'Rennes (FRA)', 1.98),
(6, 22, 'Dele ADELEYE', '1988-12-25', 'defensa', 'Sparta Rotterdam (NED)', 1.89),
(6, 23, 'Dele AIYENUGBA', '1983-11-20', 'arquero', 'Bnei Yehuda (ISR)', 1.86),
(7, 1, 'LEE Woon Jae', '1973-04-26', 'arquero', 'Suwon Bluewings (KOR)', 1.82),
(7, 2, 'OH Beom Seok', '1984-07-29', 'defensa', 'Ulsan Hyundai (KOR)', 1.81),
(7, 3, 'KIM Hyung Il', '1984-04-27', 'defensa', 'Pohang Steelers (KOR)', 1.87),
(7, 4, 'CHO Yong Hyung', '1983-11-03', 'defensa', 'Jeju Utd. (KOR)', 1.82),
(7, 5, 'KIM Nam Il', '1977-03-14', 'medio', 'Tom Tomsk (RUS)', 1.80),
(7, 6, 'KIM Bo Kyung', '1989-10-06', 'medio', 'Oita Trinita (JPN)', 1.78),
(7, 7, 'PARK Ji Sung', '1981-02-25', 'medio', 'Manchester Utd. (ENG)', 1.78),
(7, 8, 'KIM Jung Woo', '1982-05-09', 'medio', 'Gwangju Sangmu (KOR)', 1.83),
(7, 9, 'AHN Jung Hwan', '1976-01-27', 'delantero', 'Dalian Shide (CHN)', 1.77),
(7, 10, 'PARK Chu Young', '1985-07-10', 'delantero', 'Monaco (FRA)', 1.83),
(7, 11, 'LEE Seung Yeoul', '1989-03-06', 'delantero', 'FC Seoul (KOR)', 1.83),
(7, 12, 'LEE Young Pyo', '1977-04-23', 'defensa', 'Al Hilal (KSA)', 1.77),
(7, 13, 'KIM Jae Sung', '1983-10-03', 'medio', 'Pohang Steelers (KOR)', 1.80),
(7, 14, 'LEE Jung Soo', '1980-01-08', 'defensa', 'Kashima Antlers (JPN)', 1.85),
(7, 15, 'KIM Dong Jin', '1982-01-29', 'defensa', 'Ulsan Hyundai (KOR)', 1.84),
(7, 16, 'KI Sung Yueng', '1989-01-24', 'medio', 'Celtic (SCO)', 1.87),
(7, 17, 'LEE Chung Yong', '1988-07-02', 'medio', 'Bolton Wanderers (ENG)', 1.80),
(7, 18, 'JUNG Sung Ryong', '1985-01-04', 'arquero', 'Seongnam Ilhwa Chunma (KOR)', 1.90),
(7, 19, 'YEOM Ki Hun', '1983-03-30', 'medio', 'Suwon Bluewings (KOR)', 1.82),
(7, 20, 'LEE Dong Gook', '1979-04-29', 'delantero', 'Jeonbuk Motors (KOR)', 1.87),
(7, 21, 'KIM Young Kwang', '1983-06-28', 'arquero', 'Ulsan Hyundai (KOR)', 1.84),
(7, 22, 'CHA Du Ri', '1980-07-25', 'defensa', 'SC Freiburg (GER)', 1.81),
(7, 23, 'KANG Min Soo', '1986-02-14', 'defensa', 'Suwon Bluewings (KOR)', 1.86),
(8, 1, 'Konstantinos CHALKIAS', '1974-05-30', 'arquero', 'PAOK (GRE)', 1.98),
(8, 2, 'Giourkas SEITARIDIS', '1981-06-04', 'defensa', 'Panathinaikos (GRE)', 1.85),
(8, 3, 'Christos PATSATZOGLOU', '1979-03-19', 'defensa', 'Omonia (CYP)', 1.83),
(8, 4, 'Nikos SPIROPOULOS', '1983-10-10', 'defensa', 'Panathinaikos (GRE)', 1.71),
(8, 5, 'Vangelis MORAS', '1981-08-26', 'defensa', 'Bologna (ITA)', 1.93),
(8, 6, 'Alexandros TZIOLIS', '1985-02-13', 'medio', 'Siena (ITA)', 1.90),
(8, 7, 'Georgios SAMARAS', '1985-02-21', 'delantero', 'Celtic (SCO)', 1.92),
(8, 8, 'Avraam PAPADOPOULOS', '1984-12-03', 'defensa', 'Olympiacos (GRE)', 1.86),
(8, 9, 'Angelos CHARISTEAS', '1980-02-09', 'delantero', 'Nuremberg (GER)', 1.91),
(8, 10, 'Georgios KARAGOUNIS', '1977-03-06', 'medio', 'Panathinaikos (GRE)', 1.76),
(8, 11, 'Loukas VYNTRA', '1981-02-05', 'defensa', 'Panathinaikos (GRE)', 1.84),
(8, 12, 'Alexandros TZORVAS', '1982-08-12', 'arquero', 'Panathinaikos (GRE)', 1.90),
(8, 13, 'Michail SIFAKIS', '1984-09-09', 'arquero', 'Aris Thessaloniki (GRE)', 1.86),
(8, 14, 'Dimitrios SALPINGIDIS', '1981-08-18', 'delantero', 'Panathinaikos (GRE)', 1.71),
(8, 15, 'Vasileios TOROSIDIS', '1985-06-10', 'defensa', 'Olympiacos (GRE)', 1.85),
(8, 16, 'Sotirios KYRGIAKOS', '1979-07-23', 'defensa', 'Liverpool (ENG)', 1.92),
(8, 17, 'Theofanis GEKAS', '1980-05-23', 'delantero', 'Hertha Berlin (GER)', 1.79),
(8, 18, 'Sotiris NINIS', '1990-04-03', 'medio', 'Panathinaikos (GRE)', 1.73),
(8, 19, 'Sokratis PAPASTATHOPOULOS', '1988-06-09', 'defensa', 'Genoa (ITA)', 1.86),
(8, 20, 'Pantelis KAPETANOS', '1983-06-08', 'delantero', 'Steaua (ROU)', 1.90),
(8, 21, 'Konstantinos KATSOURANIS', '1979-06-21', 'medio', 'Panathinaikos (GRE)', 1.83),
(8, 22, 'Stelios MALEZAS', '1985-03-11', 'defensa', 'PAOK (GRE)', 1.92),
(8, 23, 'Athanasios PRITTAS', '1979-01-09', 'medio', 'Aris Thessaloniki (GRE)', 1.85),
(9, 1, 'David JAMES', '1970-08-01', 'arquero', 'Portsmouth (ENG)', 1.96),
(9, 2, 'Glen JOHNSON', '1984-08-23', 'defensa', 'Liverpool (ENG)', 1.78),
(9, 3, 'Ashley COLE', '1980-12-20', 'defensa', 'Chelsea (ENG)', 1.73),
(9, 4, 'Steven GERRARD', '1980-05-30', 'medio', 'Liverpool (ENG)', 1.85),
(9, 5, 'Michael DAWSON', '1983-11-18', 'defensa', 'Tottenham Hotspur (ENG)', 1.88),
(9, 6, 'John TERRY', '1980-12-07', 'defensa', 'Chelsea (ENG)', 1.88),
(9, 7, 'Aaron LENNON', '1987-04-16', 'medio', 'Tottenham Hotspur (ENG)', 1.65),
(9, 8, 'Frank LAMPARD', '1978-06-20', 'medio', 'Chelsea (ENG)', 1.83),
(9, 9, 'Peter CROUCH', '1981-01-30', 'delantero', 'Tottenham Hotspur (ENG)', 2.01),
(9, 10, 'Wayne ROONEY', '1985-10-24', 'delantero', 'Manchester Utd. (ENG)', 1.78),
(9, 11, 'Joe COLE', '1981-11-08', 'medio', 'Chelsea (ENG)', 1.75),
(9, 12, 'Robert GREEN', '1980-01-18', 'arquero', 'West Ham Utd. (ENG)', 1.87),
(9, 13, 'Stephen WARNOCK', '1981-12-12', 'defensa', 'Aston Villa (ENG)', 1.75),
(9, 14, 'Gareth BARRY', '1981-02-23', 'medio', 'Manchester City (ENG)', 1.80),
(9, 15, 'Matt UPSON', '1979-04-18', 'defensa', 'West Ham Utd. (ENG)', 1.85),
(9, 16, 'James MILNER', '1986-01-04', 'medio', 'Aston Villa (ENG)', 1.70),
(9, 17, 'Shaun WRIGHT-PHILLIPS', '1981-10-25', 'medio', 'Manchester City (ENG)', 1.68),
(9, 18, 'Jamie CARRAGHER', '1978-01-28', 'defensa', 'Liverpool (ENG)', 1.85),
(9, 19, 'Jermain DEFOE', '1982-10-07', 'delantero', 'Tottenham Hotspur (ENG)', 1.70),
(9, 20, 'Ledley KING', '1980-10-12', 'defensa', 'Tottenham Hotspur (ENG)', 1.88),
(9, 21, 'Emile HESKEY', '1978-01-11', 'delantero', 'Aston Villa (ENG)', 1.88),
(9, 22, 'Michael CARRICK', '1981-07-28', 'medio', 'Manchester Utd. (ENG)', 1.83),
(9, 23, 'Joe HART', '1987-04-19', 'arquero', 'Birmingham City (ENG)', 1.91),
(10, 1, 'Tim HOWARD', '1979-03-06', 'arquero', 'Everton (ENG)', 1.87),
(10, 2, 'Jonathan SPECTOR', '1986-03-01', 'defensa', 'West Ham Utd. (ENG)', 1.83),
(10, 3, 'Carlos BOCANEGRA', '1979-05-25', 'defensa', 'Rennes (FRA)', 1.84),
(10, 4, 'Michael BRADLEY', '1987-07-31', 'medio', 'Borussia Moenchengladbach (GER)', 1.85),
(10, 5, 'Oguchi ONYEWU', '1982-05-13', 'defensa', 'AC Milan (ITA)', 1.92),
(10, 6, 'Steve CHERUNDOLO', '1979-02-19', 'defensa', 'Hannover 96 (GER)', 1.68),
(10, 7, 'DaMarcus BEASLEY', '1982-05-24', 'medio', 'Rangers (SCO)', 1.70),
(10, 8, 'Clint DEMPSEY', '1983-03-09', 'medio', 'Fulham (ENG)', 1.85),
(10, 9, 'Herculez GOMEZ', '1982-04-06', 'delantero', 'Puebla (MEX)', 1.78),
(10, 10, 'Landon DONOVAN', '1982-03-04', 'medio', 'Los Angeles Galaxy (USA)', 1.73),
(10, 11, 'Stuart HOLDEN', '1985-08-01', 'medio', 'Bolton Wanderers (ENG)', 1.78),
(10, 12, 'Jonathan BORNSTEIN', '1984-11-07', 'defensa', 'Chivas USA (USA)', 1.75),
(10, 13, 'Ricardo CLARK', '1983-02-10', 'medio', 'Eintracht Frankfurt (GER)', 1.78),
(10, 14, 'Edson BUDDLE', '1981-05-21', 'delantero', 'Los Angeles Galaxy (USA)', 1.85),
(10, 15, 'Jay DeMERIT', '1979-12-04', 'defensa', 'Watford (ENG)', 1.80),
(10, 16, 'Francisco TORRES', '1987-10-29', 'medio', 'Pachuca (MEX)', 1.68),
(10, 17, 'Jozy ALTIDORE', '1989-11-06', 'delantero', 'Hull City (ENG)', 1.85),
(10, 18, 'Brad GUZAN', '1984-09-09', 'arquero', 'Aston Villa (ENG)', 1.93),
(10, 19, 'Maurice EDU', '1986-04-18', 'medio', 'Rangers (SCO)', 1.83),
(10, 20, 'Robbie FINDLEY', '1985-08-04', 'delantero', 'Real Salt Lake (USA)', 1.75),
(10, 21, 'Clarence GOODSON', '1982-05-17', 'defensa', 'IK Start (NOR)', 1.93),
(10, 22, 'Benny FEILHABER', '1985-01-19', 'medio', 'AGF Aarhus (DEN)', 1.75),
(10, 23, 'Marcus HAHNEMANN', '1972-06-15', 'arquero', 'Wolverhampton (ENG)', 1.92),
(11, 1, 'Lounes GAOUAOUI', '1977-09-28', 'arquero', 'Chlef (ALG)', 1.88),
(11, 2, 'Madjid BOUGHERRA', '1982-10-07', 'defensa', 'Rangers (SCO)', 1.90),
(11, 3, 'Nadir BELHADJ', '1982-06-18', 'defensa', 'Portsmouth (ENG)', 1.80),
(11, 4, 'Anther YAHIA', '1982-03-21', 'defensa', 'Bochum (GER)', 1.85),
(11, 5, 'Rafik HALLICHE', '1986-09-02', 'defensa', 'Nacional Madeira (POR)', 1.87),
(11, 6, 'Yazid MANSOURI', '1978-02-25', 'medio', 'Lorient (FRA)', 1.75),
(11, 7, 'Ryad BOUDEBOUZ', '1990-02-19', 'medio', 'Sochaux (FRA)', 1.78),
(11, 8, 'Medhi LACEN', '1984-03-15', 'medio', 'Racing Santander (ESP)', 1.78),
(11, 9, 'Abdelkader GHEZZAL', '1984-12-05', 'delantero', 'Siena (ITA)', 1.86),
(11, 10, 'Rafik SAIFI', '1975-02-07', 'delantero', 'Istres (FRA)', 1.78),
(11, 11, 'Rafik DJEBBOUR', '1984-03-08', 'delantero', 'AEK Athens (GRE)', 1.85),
(11, 12, 'Habib BELLAID', '1986-03-28', 'defensa', 'Boulogne (FRA)', 1.89),
(11, 13, 'Karim MATMOUR', '1985-06-25', 'medio', 'Borussia Moenchengladbach (GER)', 1.81),
(11, 14, 'Abdelkader LAIFAOUI', '1981-07-29', 'defensa', 'Setif (ALG)', 1.77),
(11, 15, 'Karim ZIANI', '1982-08-17', 'medio', 'Wolfsburg (GER)', 1.68),
(11, 16, 'Faouzi CHAOUCHI', '1984-12-05', 'arquero', 'Setif (ALG)', 1.80),
(11, 17, 'Adlane GUEDIOURA', '1985-11-12', 'medio', 'Wolverhampton (ENG)', 1.83),
(11, 18, 'Carl MEDJANI', '1985-05-15', 'defensa', 'Ajaccio (FRA)', 1.84),
(11, 19, 'Hassan YEBDA', '1984-05-14', 'medio', 'Portsmouth (ENG)', 1.88),
(11, 20, 'Djamel MESBAH', '1984-10-09', 'defensa', 'Lecce (ITA)', 1.80),
(11, 21, 'Foued KADIR', '1983-12-05', 'medio', 'Valenciennes (FRA)', 1.80),
(11, 22, 'Djamal ABDOUN', '1986-02-14', 'medio', 'Nantes (FRA)', 1.80),
(11, 23, 'Rais M BOLHI', '1986-04-25', 'arquero', 'Slavia Sofia (BUL)', 1.90),
(12, 1, 'Samir HANDANOVIC', '1984-07-14', 'arquero', 'Udinese (ITA)', 1.93),
(12, 2, 'Miso BRECKO', '1984-05-01', 'defensa', 'FC Cologne (GER)', 1.72),
(12, 3, 'Elvedin DZINIC', '1985-08-25', 'defensa', 'Maribor (SVN)', 1.89),
(12, 4, 'Marko SULER', '1983-03-09', 'defensa', 'Gent (BEL)', 1.87),
(12, 5, 'Bostjan CESAR', '1982-07-09', 'defensa', 'Grenoble (FRA)', 1.90),
(12, 6, 'Branko ILIC', '1983-02-06', 'defensa', 'Lokomotiv Moscow (RUS)', 1.86),
(12, 7, 'Nejc PECNIK', '1986-01-03', 'delantero', 'Nacional Madeira (POR)', 1.87),
(12, 8, 'Robert KOREN', '1980-09-20', 'medio', 'West Bromwich Albion (ENG)', 1.73),
(12, 9, 'Zlatan LJUBIJANKIC', '1983-12-15', 'delantero', 'Gent (BEL)', 1.85),
(12, 10, 'Valter BIRSA', '1986-08-07', 'medio', 'Auxerre (FRA)', 1.80),
(12, 11, 'Milivoje NOVAKOVIC', '1979-05-18', 'delantero', 'FC Cologne (GER)', 1.91),
(12, 12, 'Jasmin HANDANOVIC', '1978-01-28', 'arquero', 'Mantova (ITA)', 1.97),
(12, 13, 'Bojan JOKIC', '1986-05-17', 'defensa', 'Chievo (ITA)', 1.71),
(12, 14, 'Zlatko DEDIC', '1984-10-05', 'delantero', 'Bochum (GER)', 1.72),
(12, 15, 'Rene KRHIN', '1990-05-21', 'medio', 'Inter (ITA)', 1.84),
(12, 16, 'Aleksander SELIGA', '1980-02-01', 'arquero', 'Sparta Rotterdam (NED)', 1.87),
(12, 17, 'Andraz KIRM', '1984-09-06', 'medio', 'Wisla Krakow (POL)', 1.85),
(12, 18, 'Aleksandar RADOSAVLJEVIC', '1979-04-25', 'medio', 'Larissa (GRE)', 1.81),
(12, 19, 'Suad FILEKOVIC', '1978-09-16', 'defensa', 'Maribor (SVN)', 1.90),
(12, 20, 'Andrej KOMAC', '1979-12-04', 'medio', 'Maccabi Tel-Aviv (ISR)', 1.70),
(12, 21, 'Dalibor STEVANOVIC', '1984-09-27', 'medio', 'Vitesse Arnhem (NED)', 1.83),
(12, 22, 'Matej MAVRIC', '1979-01-29', 'defensa', 'TuS Koblenz (GER)', 1.86),
(12, 23, 'Tim MATAVZ', '1989-01-13', 'delantero', 'Groningen (NED)', 1.90),
(13, 1, 'Manuel NEUER', '1986-03-27', 'arquero', 'Schalke 04 (GER)', 1.90),
(13, 2, 'Marcell JANSEN', '1985-11-04', 'medio', 'Hamburger SV (GER)', 1.90),
(13, 3, 'Arne FRIEDRICH', '1979-05-29', 'defensa', 'Hertha Berlin (GER)', 1.85),
(13, 4, 'Dennis AOGO', '1987-01-14', 'defensa', 'Hamburger SV (GER)', 1.84),
(13, 5, 'Serdar TASCI', '1987-04-24', 'defensa', 'VfB Stuttgart (GER)', 1.86),
(13, 6, 'Sami KHEDIRA', '1987-04-04', 'medio', 'VfB Stuttgart (GER)', 1.89),
(13, 7, 'Bastian SCHWEINSTEIGER', '1984-08-01', 'medio', 'Bayern Munich (GER)', 1.80),
(13, 8, 'Mesut OEZIL', '1988-10-15', 'medio', 'Werder Bremen (GER)', 1.82),
(13, 9, 'Stefan KIESSLING', '1984-01-25', 'delantero', 'Bayer Leverkusen (GER)', 1.91),
(13, 10, 'Lukas PODOLSKI', '1985-06-04', 'delantero', 'FC Cologne (GER)', 1.80),
(13, 11, 'Miroslav KLOSE', '1978-06-09', 'delantero', 'Bayern Munich (GER)', 1.82),
(13, 12, 'Tim WIESE', '1981-12-17', 'arquero', 'Werder Bremen (GER)', 1.93),
(13, 13, 'Thomas MUELLER', '1989-09-13', 'medio', 'Bayern Munich (GER)', 1.86),
(13, 14, 'Holger BADSTUBER', '1989-03-13', 'defensa', 'Bayern Munich (GER)', 1.90),
(13, 15, 'Piotr TROCHOWSKI', '1984-03-22', 'medio', 'Hamburger SV (GER)', 1.68),
(13, 16, 'Philipp LAHM', '1983-11-11', 'defensa', 'Bayern Munich (GER)', 1.70),
(13, 17, 'Per MERTESACKER', '1984-09-29', 'defensa', 'Werder Bremen (GER)', 1.96),
(13, 18, 'Toni KROOS', '1990-01-04', 'medio', 'Bayer Leverkusen (GER)', 1.80),
(13, 19, 'CACAU', '1981-03-27', 'delantero', 'VfB Stuttgart (GER)', 1.80),
(13, 20, 'Jerome BOATENG', '1988-09-03', 'defensa', 'Hamburger SV (GER)', 1.92),
(13, 21, 'Marko MARIN', '1989-03-13', 'medio', 'Werder Bremen (GER)', 1.69),
(13, 22, 'Hans Joerg BUTT', '1974-05-28', 'arquero', 'Bayern Munich (GER)', 1.91),
(13, 23, 'Mario GOMEZ', '1985-07-10', 'delantero', 'Bayern Munich (GER)', 1.89),
(14, 1, 'Mark SCHWARZER', '1972-10-06', 'arquero', 'Fulham (ENG)', 1.96),
(14, 2, 'Lucas NEILL', '1978-03-09', 'defensa', 'Galatasaray (TUR)', 1.85),
(14, 3, 'Craig MOORE', '1975-12-12', 'defensa', 'no club affiliation (UNK)', 1.86),
(14, 4, 'Tim CAHILL', '1979-12-06', 'delantero', 'Everton (ENG)', 1.80),
(14, 5, 'Jason CULINA', '1980-08-05', 'medio', 'Gold Coast United (AUS)', 1.75),
(14, 6, 'Michael BEAUCHAMP', '1981-03-08', 'defensa', 'Al Jazira (UAE)', 1.91),
(14, 7, 'Brett EMERTON', '1979-02-22', 'medio', 'Blackburn Rovers (ENG)', 1.85),
(14, 8, 'Luke WILKSHIRE', '1981-10-02', 'defensa', 'Dynamo Moscow (RUS)', 1.77),
(14, 9, 'Joshua KENNEDY', '1982-08-20', 'delantero', 'Nagoya Grampus Eight (JPN)', 1.92),
(14, 10, 'Harry KEWELL', '1978-09-22', 'delantero', 'Galatasaray (TUR)', 1.83),
(14, 11, 'Scott CHIPPERFIELD', '1975-12-30', 'defensa', 'Basel (SUI)', 1.80),
(14, 12, 'Adam FEDERICI', '1985-01-31', 'arquero', 'Reading (ENG)', 1.88),
(14, 13, 'Vince GRELLA', '1979-10-05', 'medio', 'Blackburn Rovers (ENG)', 1.83),
(14, 14, 'Brett HOLMAN', '1984-03-27', 'delantero', 'AZ Alkmaar (NED)', 1.76),
(14, 15, 'Mile JEDINAK', '1984-08-03', 'medio', 'Antalyaspor (TUR)', 1.88),
(14, 16, 'Carl VALERI', '1984-08-14', 'medio', 'Sassuolo (ITA)', 1.80),
(14, 17, 'Nikita RUKAVYTSYA', '1987-06-22', 'delantero', 'Twente Enschede (NED)', 1.83),
(14, 18, 'Eugene GALEKOVIC', '1981-06-12', 'arquero', 'Adelaide Utd. (AUS)', 1.86),
(14, 19, 'Richard GARCIA', '1981-09-04', 'delantero', 'Hull City (ENG)', 1.80),
(14, 20, 'Mark MILLIGAN', '1985-08-04', 'defensa', 'JEF United Ichihara (JPN)', 1.78),
(14, 21, 'David CARNEY', '1983-11-30', 'defensa', 'Twente Enschede (NED)', 1.81),
(14, 22, 'Dario VIDOSIC', '1987-04-08', 'medio', 'MSV Duisburg (GER)', 1.85),
(14, 23, 'Marco BRESCIANO', '1980-02-11', 'delantero', 'Palermo (ITA)', 1.82),
(15, 1, 'Vladimir STOJKOVIC', '1983-07-28', 'arquero', 'Wigan (ENG)', 1.95),
(15, 2, 'Antonio RUKAVINA', '1984-01-26', 'defensa', 'Munich 1860 (GER)', 1.77),
(15, 3, 'Aleksandar KOLAROV', '1985-11-10', 'defensa', 'Lazio (ITA)', 1.87),
(15, 4, 'Gojko KACAR', '1987-01-26', 'medio', 'Hertha Berlin (GER)', 1.85),
(15, 5, 'Nemanja VIDIC', '1981-10-21', 'defensa', 'Manchester Utd. (ENG)', 1.85),
(15, 6, 'Branislav IVANOVIC', '1984-02-22', 'defensa', 'Chelsea (ENG)', 1.88),
(15, 7, 'Zoran TOSIC', '1987-04-28', 'medio', 'FC Cologne (GER)', 1.71),
(15, 8, 'Danko LAZOVIC', '1983-05-17', 'delantero', 'Zenit St Petersburg (RUS)', 1.85),
(15, 9, 'Marko PANTELIC', '1978-09-15', 'delantero', 'Ajax (NED)', 1.81),
(15, 10, 'Dejan STANKOVIC', '1978-09-11', 'medio', 'Inter (ITA)', 1.81),
(15, 11, 'Nenad MILIJAS', '1983-04-30', 'medio', 'Wolverhampton (ENG)', 1.82),
(15, 12, 'Bojan ISAILOVIC', '1980-03-25', 'arquero', 'Zaglebie Lubin (POL)', 1.92),
(15, 13, 'Aleksandar LUKOVIC', '1982-10-23', 'defensa', 'Udinese (ITA)', 1.84),
(15, 14, 'Milan JOVANOVIC', '1981-04-18', 'medio', 'Standard Liege (BEL)', 1.83),
(15, 15, 'Nikola ZIGIC', '1980-09-25', 'delantero', 'Valencia (ESP)', 2.02),
(15, 16, 'Ivan OBRADOVIC', '1988-07-25', 'defensa', 'Zaragoza (ESP)', 1.81),
(15, 17, 'Milos KRASIC', '1984-11-01', 'medio', 'CSKA Moscow (RUS)', 1.85),
(15, 18, 'Milos NINKOVIC', '1984-12-25', 'medio', 'Dynamo Kyiv (UKR)', 1.79),
(15, 19, 'Radosav PETROVIC', '1989-03-08', 'medio', 'Partizan (SRB)', 1.93),
(15, 20, 'Neven SUBOTIC', '1988-12-10', 'defensa', 'Borussia Dortmund (GER)', 1.93),
(15, 21, 'Dragan MRDJA', '1984-01-23', 'delantero', 'Vojvodina Novi Sad (SRB)', 1.87),
(15, 22, 'Zdravko KUZMANOVIC', '1987-09-22', 'medio', 'VfB Stuttgart (GER)', 1.87),
(15, 23, 'Andjelko DJURICIC', '1980-11-21', 'arquero', 'Leiria (POR)', 1.94),
(16, 1, 'Daniel AGYEI', '1989-11-10', 'arquero', 'Liberty (GHA)', 1.86),
(16, 2, 'Hans SARPEI', '1976-06-28', 'defensa', 'Bayer Leverkusen (GER)', 1.78),
(16, 3, 'Asamoah GYAN', '1985-11-22', 'delantero', 'Rennes (FRA)', 1.86),
(16, 4, 'John PANTSIL', '1981-06-15', 'defensa', 'Fulham (ENG)', 1.78),
(16, 5, 'John MENSAH', '1982-11-29', 'defensa', 'Sunderland (ENG)', 1.77),
(16, 6, 'Anthony ANNAN', '1986-07-21', 'medio', 'Rosenborg (NOR)', 1.71),
(16, 7, 'Samuel INKOOM', '1989-06-01', 'defensa', 'Basel (SUI)', 1.79),
(16, 8, 'Jonathan MENSAH', '1990-07-13', 'defensa', 'Free State Stars (RSA)', 1.82),
(16, 9, 'Derek BOATENG', '1983-05-02', 'medio', 'Getafe (ESP)', 1.85),
(16, 10, 'Stephen APPIAH', '1980-12-24', 'medio', 'Bologna (ITA)', 1.78),
(16, 11, 'Sulley MUNTARI', '1984-08-27', 'medio', 'Inter (ITA)', 1.80),
(16, 12, 'Prince TAGOE', '1986-11-09', 'delantero', 'Hoffenheim (GER)', 1.79),
(16, 13, 'Andre AYEW', '1989-12-17', 'medio', 'Arles-Avignon (FRA)', 1.75),
(16, 14, 'Matthew AMOAH', '1980-10-24', 'delantero', 'NAC Breda (NED)', 1.75),
(16, 15, 'Isaac VORSAH', '1988-06-21', 'defensa', 'Hoffenheim (GER)', 1.80),
(16, 16, 'Stephen AHORLU', '1988-09-05', 'arquero', 'Heart of Lions (GHA)', 1.79),
(16, 17, 'Ibrahim AYEW', '1988-04-16', 'defensa', 'Zamalek (EGY)', 1.76),
(16, 18, 'Dominic ADIYIAH', '1989-11-29', 'delantero', 'AC Milan (ITA)', 1.70),
(16, 19, 'Lee ADDY', '1990-07-07', 'defensa', 'Bechem Chelsea (GHA)', 1.78),
(16, 20, 'Quincy OWUSU-ABEYIE', '1986-04-15', 'delantero', 'Al Sadd (QAT)', 1.80),
(16, 21, 'Kwadwo ASAMOAH', '1988-12-09', 'medio', 'Udinese (ITA)', 1.68),
(16, 22, 'Richard KINGSON', '1978-06-13', 'arquero', 'Wigan (ENG)', 1.82),
(16, 23, 'Kevin Prince BOATENG', '1987-03-06', 'delantero', 'Portsmouth (ENG)', 1.82),
(17, 1, 'Maarten STEKELENBURG', '1982-09-22', 'arquero', 'Ajax (NED)', 1.97),
(17, 2, 'Gregory VAN DER WIEL', '1988-02-03', 'defensa', 'Ajax (NED)', 1.80),
(17, 3, 'John HEITINGA', '1983-11-15', 'defensa', 'Everton (ENG)', 1.82),
(17, 4, 'Joris MATHIJSEN', '1980-04-05', 'defensa', 'Hamburger SV (GER)', 1.82),
(17, 5, 'Giovanni VAN BRONCKHORST', '1975-02-05', 'defensa', 'Feyenoord (NED)', 1.76),
(17, 6, 'Mark VAN BOMMEL', '1977-04-22', 'medio', 'Bayern Munich (GER)', 1.87),
(17, 7, 'Dirk KUYT', '1980-07-22', 'delantero', 'Liverpool (ENG)', 1.83),
(17, 8, 'Nigel DE JONG', '1984-11-30', 'medio', 'Manchester City (ENG)', 1.74),
(17, 9, 'Robin VAN PERSIE', '1983-08-06', 'delantero', 'Arsenal (ENG)', 1.84),
(17, 10, 'Wesley SNEIJDER', '1984-06-09', 'medio', 'Inter (ITA)', 1.70),
(17, 11, 'Arjen ROBBEN', '1984-01-23', 'delantero', 'Bayern Munich (GER)', 1.80),
(17, 12, 'Khalid BOULAHROUZ', '1981-12-28', 'defensa', 'VfB Stuttgart (GER)', 1.84),
(17, 13, 'Andre OOIJER', '1974-07-11', 'defensa', 'PSV Eindhoven (NED)', 1.84),
(17, 14, 'Demy DE ZEEUW', '1983-05-26', 'medio', 'Ajax (NED)', 1.74),
(17, 15, 'Edson BRAAFHEID', '1983-04-08', 'defensa', 'Celtic (SCO)', 1.74),
(17, 16, 'Michel VORM', '1983-10-20', 'arquero', 'Utrecht (NED)', 1.82),
(17, 17, 'Eljero ELIA', '1987-02-13', 'delantero', 'Hamburger SV (GER)', 1.77),
(17, 18, 'Stijn SCHAARS', '1984-01-11', 'medio', 'AZ Alkmaar (NED)', 1.78),
(17, 19, 'Ryan BABEL', '1986-12-19', 'delantero', 'Liverpool (ENG)', 1.85),
(17, 20, 'Ibrahim AFELLAY', '1986-04-02', 'medio', 'PSV Eindhoven (NED)', 1.84),
(17, 21, 'Klaas Jan HUNTELAAR', '1983-08-12', 'delantero', 'AC Milan (ITA)', 1.85),
(17, 22, 'Sander BOSCHKER', '1970-10-20', 'arquero', 'Twente Enschede (NED)', 1.85),
(17, 23, 'Rafael VAN DER VAART', '1983-02-11', 'medio', 'Real Madrid (ESP)', 1.78),
(18, 1, 'Thomas SORENSEN', '1976-06-12', 'arquero', 'Stoke City (ENG)', 1.85),
(18, 2, 'Christian POULSEN', '1980-02-28', 'medio', 'Juventus (ITA)', 1.82),
(18, 3, 'Simon KJAER', '1989-03-26', 'defensa', 'Palermo (ITA)', 1.91),
(18, 4, 'Daniel AGGER', '1984-12-12', 'defensa', 'Liverpool (ENG)', 1.88),
(18, 5, 'William KVIST', '1985-02-24', 'medio', 'Copenhagen (DEN)', 1.85),
(18, 6, 'Lars JACOBSEN', '1979-09-20', 'defensa', 'Blackburn Rovers (ENG)', 1.84),
(18, 7, 'Daniel JENSEN', '1979-06-25', 'medio', 'Werder Bremen (GER)', 1.80),
(18, 8, 'Jesper GRONKJAER', '1977-08-12', 'delantero', 'Copenhagen (DEN)', 1.87),
(18, 9, 'Jon Dahl TOMASSON', '1976-08-29', 'delantero', 'Feyenoord (NED)', 1.82),
(18, 10, 'Martin JORGENSEN', '1975-10-06', 'medio', 'AGF Aarhus (DEN)', 1.80),
(18, 11, 'Nicklas BENDTNER', '1988-01-16', 'delantero', 'Arsenal (ENG)', 1.94),
(18, 12, 'Thomas KAHLENBERG', '1983-03-20', 'medio', 'Wolfsburg (GER)', 1.85),
(18, 13, 'Per KROLDRUP', '1979-07-31', 'defensa', 'Fiorentina (ITA)', 1.94),
(18, 14, 'Jakob POULSEN', '1983-07-07', 'medio', 'AGF Aarhus (DEN)', 1.85),
(18, 15, 'Simon POULSEN', '1984-04-07', 'defensa', 'AZ Alkmaar (NED)', 1.87),
(18, 16, 'Stephan ANDERSEN', '1981-11-26', 'arquero', 'Brondby (DEN)', 1.88),
(18, 17, 'Mikkel BECKMANN', '1983-10-24', 'delantero', 'Randers (DEN)', 1.78),
(18, 18, 'Soren LARSEN', '1981-09-06', 'delantero', 'MSV Duisburg (GER)', 1.94),
(18, 19, 'Dennis ROMMEDAHL', '1978-07-22', 'delantero', 'Ajax (NED)', 1.78),
(18, 20, 'Thomas ENEVOLDSEN', '1987-07-27', 'medio', 'Groningen (NED)', 1.82),
(18, 21, 'Christian ERIKSEN', '1992-02-14', 'medio', 'Ajax (NED)', 1.81),
(18, 22, 'Jesper CHRISTIANSEN', '1978-04-24', 'arquero', 'Copenhagen (DEN)', 1.92),
(18, 23, 'Patrick MTILIGA', '1981-01-28', 'defensa', 'Malaga (ESP)', 1.70),
(19, 1, 'Seigo NARAZAKI', '1976-04-15', 'arquero', 'Nagoya Grampus Eight (JPN)', 1.87),
(19, 2, 'Yuki ABE', '1981-09-06', 'medio', 'Urawa Reds (JPN)', 1.77),
(19, 3, 'Yuichi KOMANO', '1981-07-25', 'defensa', 'Jubilo Iwata (JPN)', 1.72),
(19, 4, 'Marcus Tulio TANAKA', '1981-04-24', 'defensa', 'Nagoya Grampus Eight (JPN)', 1.85),
(19, 5, 'Yuto NAGATOMO', '1986-09-12', 'defensa', 'FC Tokyo (JPN)', 1.70),
(19, 6, 'Atsuto UCHIDA', '1988-03-27', 'defensa', 'Kashima Antlers (JPN)', 1.76),
(19, 7, 'Yasuhito ENDO', '1980-01-28', 'medio', 'Gamba Osaka (JPN)', 1.78),
(19, 8, 'Daisuke MATSUI', '1981-05-11', 'medio', 'Grenoble (FRA)', 1.75),
(19, 9, 'Shinji OKAZAKI', '1986-04-16', 'delantero', 'Shimizu S-Pulse (JPN)', 1.74),
(19, 10, 'Shunsuke NAKAMURA', '1978-06-24', 'medio', 'Yokohama F Marinos (JPN)', 1.78),
(19, 11, 'Keiji TAMADA', '1980-04-11', 'delantero', 'Nagoya Grampus Eight (JPN)', 1.73),
(19, 12, 'Kisho YANO', '1984-04-05', 'delantero', 'Albirex Niigata (JPN)', 1.85),
(19, 13, 'Daiki IWAMASA', '1982-01-30', 'defensa', 'Kashima Antlers (JPN)', 1.87),
(19, 14, 'Kengo NAKAMURA', '1980-10-31', 'medio', 'Kawasaki Frontale (JPN)', 1.75),
(19, 15, 'Yasuyuki KONNO', '1983-01-25', 'defensa', 'FC Tokyo (JPN)', 1.78),
(19, 16, 'Yoshito OKUBO', '1982-06-09', 'delantero', 'Vissel Kobe (JPN)', 1.70),
(19, 17, 'Makoto HASEBE', '1984-01-18', 'medio', 'Wolfsburg (GER)', 1.77),
(19, 18, 'Keisuke HONDA', '1986-06-13', 'medio', 'CSKA Moscow (RUS)', 1.82),
(19, 19, 'Takayuki MORIMOTO', '1988-05-07', 'delantero', 'Catania (ITA)', 1.80),
(19, 20, 'Junichi INAMOTO', '1979-09-18', 'medio', 'Kawasaki Frontale (JPN)', 1.81),
(19, 21, 'Eiji KAWASHIMA', '1983-03-20', 'arquero', 'Kawasaki Frontale (JPN)', 1.85),
(19, 22, 'Yuji NAKAZAWA', '1978-02-25', 'defensa', 'Yokohama F Marinos (JPN)', 1.87),
(19, 23, 'Yoshikatsu KAWAGUCHI', '1975-08-15', 'arquero', 'Jubilo Iwata (JPN)', 1.80),
(20, 1, 'Idriss KAMENI', '1984-02-18', 'arquero', 'Espanyol (ESP)', 1.85),
(20, 2, 'Benoit ASSOU-EKOTTO', '1984-03-24', 'defensa', 'Tottenham Hotspur (ENG)', 1.78),
(20, 3, 'Nicolas NKOULOU', '1990-03-27', 'defensa', 'Monaco (FRA)', 1.85),
(20, 4, 'Rigobert SONG', '1976-07-01', 'defensa', 'Trabzonspor (TUR)', 1.85),
(20, 5, 'Sebastien BASSONG', '1986-07-09', 'defensa', 'Tottenham Hotspur (ENG)', 1.87),
(20, 6, 'Alexandre SONG', '1987-09-09', 'medio', 'Arsenal (ENG)', 1.83),
(20, 7, 'Landry NGUEMO', '1985-11-28', 'medio', 'Celtic (SCO)', 1.72),
(20, 8, 'GEREMI', '1978-12-20', 'defensa', 'Ankaragucu (TUR)', 1.77),
(20, 9, 'Samuel ETOO', '1981-03-10', 'delantero', 'Inter (ITA)', 1.78),
(20, 10, 'Achille EMANA', '1982-06-05', 'delantero', 'Betis Sevilla (ESP)', 1.80),
(20, 11, 'Jean MAKOUN', '1983-05-29', 'medio', 'Lyon (FRA)', 1.70),
(20, 12, 'Gaetan BONG', '1988-04-25', 'defensa', 'Valenciennes (FRA)', 1.83),
(20, 13, 'Eric CHOUPO MOTING', '1989-03-23', 'delantero', 'Nuremberg (GER)', 1.90),
(20, 14, 'Aurelien CHEDJOU', '1985-06-20', 'defensa', 'Lille (FRA)', 1.85),
(20, 15, 'Pierre WEBO', '1982-01-20', 'delantero', 'Mallorca (ESP)', 1.80),
(20, 16, 'Hamidou SOULEYMANOU', '1973-11-22', 'arquero', 'Kayserispor (TUR)', 1.87),
(20, 17, 'Mohamadou IDRISSOU', '1980-03-08', 'delantero', 'SC Freiburg (GER)', 1.90),
(20, 18, 'Eyong ENOH', '1986-03-23', 'medio', 'Ajax (NED)', 1.80),
(20, 19, 'Stephane MBIA', '1986-05-20', 'defensa', 'Marseille (FRA)', 1.90),
(20, 20, 'Georges MANDJECK', '1988-12-09', 'medio', 'Kaiserslautern (GER)', 1.81),
(20, 21, 'Joel MATIP', '1991-08-08', 'medio', 'Schalke 04 (GER)', 1.94),
(20, 22, 'Guy NDY', '1986-02-28', 'arquero', 'Valenciennes (FRA)', 1.85),
(20, 23, 'Vincent ABOUBAKAR', '1992-01-22', 'delantero', 'Coton Sport (CMR)', 1.76),
(21, 1, 'Gianluigi BUFFON', '1978-01-28', 'arquero', 'Juventus (ITA)', 1.90),
(21, 2, 'Christian MAGGIO', '1982-02-11', 'defensa', 'Napoli (ITA)', 1.84),
(21, 3, 'Domenico CRISCITO', '1986-12-30', 'defensa', 'Genoa (ITA)', 1.75),
(21, 4, 'Giorgio CHIELLINI', '1984-08-14', 'defensa', 'Juventus (ITA)', 1.92),
(21, 5, 'Fabio CANNAVARO', '1973-09-13', 'defensa', 'Juventus (ITA)', 1.75),
(21, 6, 'Daniele DE ROSSI', '1983-07-24', 'medio', 'AS Roma (ITA)', 1.82),
(21, 7, 'Simone PEPE', '1983-08-30', 'medio', 'Udinese (ITA)', 1.79),
(21, 8, 'Gennaro GATTUSO', '1978-01-09', 'medio', 'AC Milan (ITA)', 1.77),
(21, 9, 'Vincenzo IAQUINTA', '1979-11-21', 'delantero', 'Juventus (ITA)', 1.86),
(21, 10, 'Antonio DI NATALE', '1977-10-13', 'delantero', 'Udinese (ITA)', 1.70),
(21, 11, 'Alberto GILARDINO', '1982-07-05', 'delantero', 'Fiorentina (ITA)', 1.84),
(21, 12, 'Federico MARCHETTI', '1983-02-07', 'arquero', 'Cagliari (ITA)', 1.88),
(21, 13, 'Salvatore BOCCHETTI', '1986-11-30', 'defensa', 'Genoa (ITA)', 1.78),
(21, 14, 'Morgan DE SANCTIS', '1977-03-26', 'arquero', 'Napoli (ITA)', 1.90),
(21, 15, 'Claudio MARCHISIO', '1986-01-19', 'medio', 'Juventus (ITA)', 1.79),
(21, 16, 'Mauro CAMORANESI', '1976-10-04', 'medio', 'Juventus (ITA)', 1.74),
(21, 17, 'Angelo PALOMBO', '1981-09-25', 'medio', 'Sampdoria (ITA)', 1.77),
(21, 18, 'Fabio QUAGLIARELLA', '1983-01-31', 'delantero', 'Napoli (ITA)', 1.80),
(21, 19, 'Gianluca ZAMBROTTA', '1977-02-19', 'defensa', 'AC Milan (ITA)', 1.81),
(21, 20, 'Giampaolo PAZZINI', '1984-08-02', 'delantero', 'Sampdoria (ITA)', 1.80),
(21, 21, 'Andrea PIRLO', '1979-05-19', 'medio', 'AC Milan (ITA)', 1.77),
(21, 22, 'Riccardo MONTOLIVO', '1985-01-18', 'medio', 'Fiorentina (ITA)', 1.81),
(21, 23, 'Leonardo BONUCCI', '1987-05-01', 'defensa', 'Bari (ITA)', 1.90),
(22, 1, 'Justo VILLAR', '1977-06-30', 'arquero', 'Valladolid (ESP)', 1.80),
(22, 2, 'Dario VERON', '1979-07-26', 'defensa', 'Pumas UNAM (MEX)', 1.81),
(22, 3, 'Claudio MOREL', '1978-02-02', 'defensa', 'Boca Juniors (ARG)', 1.75),
(22, 4, 'Denis CANIZA', '1974-08-29', 'defensa', 'Leon (MEX)', 1.74),
(22, 5, 'Julio Cesar CACERES', '1979-10-05', 'defensa', 'Atletico Mineiro (BRA)', 1.81),
(22, 6, 'Carlos BONET', '1977-10-02', 'medio', 'Olimpia Asuncion (PAR)', 1.76),
(22, 7, 'Oscar CARDOZO', '1983-05-20', 'delantero', 'Benfica (POR)', 1.92),
(22, 8, 'Edgar BARRETO', '1984-07-15', 'medio', 'Atalanta (ITA)', 1.78),
(22, 9, 'Roque SANTA CRUZ', '1981-08-16', 'delantero', 'Manchester City (ENG)', 1.91),
(22, 10, 'Edgar BENITEZ', '1987-11-08', 'delantero', 'Pachuca (MEX)', 1.76),
(22, 11, 'Jonathan SANTANA', '1981-10-19', 'medio', 'Wolfsburg (GER)', 1.81),
(22, 12, 'Diego BARRETO', '1981-07-16', 'arquero', 'Cerro Porteno (PAR)', 1.82),
(22, 13, 'Enrique VERA', '1979-03-10', 'medio', 'Liga de Quito (ECU)', 1.78),
(22, 14, 'Paulo DA SILVA', '1980-02-01', 'defensa', 'Sunderland (ENG)', 1.84),
(22, 15, 'Victor CACERES', '1985-03-25', 'medio', 'Libertad (PAR)', 1.86),
(22, 16, 'Cristian RIVEROS', '1982-10-16', 'medio', 'Cruz Azul (MEX)', 1.79),
(22, 17, 'Aureliano TORRES', '1982-06-16', 'defensa', 'San Lorenzo (ARG)', 1.78),
(22, 18, 'Nelson VALDEZ', '1983-11-28', 'delantero', 'Borussia Dortmund (GER)', 1.78),
(22, 19, 'Lucas BARRIOS', '1984-11-13', 'delantero', 'Borussia Dortmund (GER)', 1.87),
(22, 20, 'Nestor ORTIGOZA', '1984-10-07', 'medio', 'Argentinos Juniors (ARG)', 1.80),
(22, 21, 'Antolin ALCARAZ', '1982-07-30', 'defensa', 'Club Brugge (BEL)', 1.84),
(22, 22, 'Aldo BOBADILLA', '1976-04-20', 'arquero', 'Independiente Medellin (COL)', 1.92),
(22, 23, 'Rodolfo GAMARRA', '1988-12-10', 'delantero', 'Libertad (PAR)', 1.68),
(23, 1, 'Mark PASTON', '1976-12-13', 'arquero', 'Wellington Phoenix (NZL)', 1.95),
(23, 2, 'Ben SIGMUND', '1981-02-03', 'defensa', 'Wellington Phoenix (NZL)', 1.87),
(23, 3, 'Tony LOCHHEAD', '1982-01-12', 'defensa', 'Wellington Phoenix (NZL)', 1.83),
(23, 4, 'Winston REID', '1988-07-03', 'defensa', 'Midtjylland (DEN)', 1.90),
(23, 5, 'Ivan VICELICH', '1976-09-03', 'defensa', 'Auckland City (NZL)', 1.93),
(23, 6, 'Ryan NELSEN', '1977-10-18', 'defensa', 'Blackburn Rovers (ENG)', 1.85),
(23, 7, 'Simon ELLIOTT', '1974-06-10', 'medio', 'no club affiliation (UNK)', 1.80),
(23, 8, 'Tim BROWN', '1981-03-06', 'medio', 'Wellington Phoenix (NZL)', 1.85),
(23, 9, 'Shane SMELTZ', '1981-09-29', 'delantero', 'Gold Coast United (AUS)', 1.84),
(23, 10, 'Chris KILLEN', '1981-10-08', 'delantero', 'Middlesbrough (ENG)', 1.88),
(23, 11, 'Leo BERTOS', '1981-12-20', 'medio', 'Wellington Phoenix (NZL)', 1.77),
(23, 12, 'Glen MOSS', '1983-01-19', 'arquero', 'Melbourne Victory (AUS)', 1.88),
(23, 13, 'Andy BARRON', '1980-12-24', 'medio', 'Team Wellington (NZL)', 1.78),
(23, 14, 'Rory FALLON', '1982-03-20', 'delantero', 'Plymouth Argyle (ENG)', 1.91),
(23, 15, 'Michael McGLINCHEY', '1987-01-07', 'medio', 'Motherwell (SCO)', 1.73),
(23, 16, 'Aaron CLAPHAM', '1987-01-15', 'medio', 'Canterbury Utd. (NZL)', 1.72),
(23, 17, 'Dave MULLIGAN', '1982-03-24', 'medio', 'no club affiliation (UNK)', 1.73),
(23, 18, 'Andy BOYENS', '1983-09-18', 'defensa', 'New York Red Bulls (USA)', 1.92),
(23, 19, 'Tommy SMITH', '1990-03-31', 'defensa', 'Ipswich Town (ENG)', 1.87),
(23, 20, 'Chris WOOD', '1991-12-07', 'delantero', 'West Bromwich Albion (ENG)', 1.91),
(23, 21, 'Jeremy CHRISTIE', '1983-05-22', 'medio', 'Tampa Bay (USA)', 1.80),
(23, 22, 'Jeremy BROCKIE', '1987-10-07', 'delantero', 'North Queensland Fury (AUS)', 1.82),
(23, 23, 'James BANNATYNE', '1975-06-30', 'arquero', 'Team Wellington (NZL)', 1.95),
(24, 1, 'Jan MUCHA', '1982-12-05', 'arquero', 'Legia Warsaw (POL)', 1.89),
(24, 2, 'Peter PEKARIK', '1986-10-30', 'defensa', 'Wolfsburg (GER)', 1.76),
(24, 3, 'Martin SKRTEL', '1984-12-15', 'defensa', 'Liverpool (ENG)', 1.88),
(24, 4, 'Marek CECH', '1983-01-26', 'defensa', 'West Bromwich Albion (ENG)', 1.81),
(24, 5, 'Radoslav ZABAVNIK', '1980-09-16', 'defensa', 'Mainz 05 (GER)', 1.80),
(24, 6, 'Zdenko STRBA', '1976-06-09', 'medio', 'Xanthi (GRE)', 1.87),
(24, 7, 'Vladimir WEISS', '1989-11-30', 'medio', 'Manchester City (ENG)', 1.76),
(24, 8, 'Jan KOZAK', '1980-04-22', 'medio', 'Timisoara (ROU)', 1.92),
(24, 9, 'Stanislav SESTAK', '1982-12-16', 'delantero', 'Bochum (GER)', 1.78),
(24, 10, 'Marek SAPARA', '1982-07-31', 'medio', 'Ankaragucu (TUR)', 1.76),
(24, 11, 'Robert VITTEK', '1982-04-01', 'delantero', 'Ankaragucu (TUR)', 1.88),
(24, 12, 'Dusan PERNIS', '1984-11-28', 'arquero', 'Dundee Utd. (SCO)', 1.90),
(24, 13, 'Filip HOLOSKO', '1984-01-17', 'delantero', 'Besiktas (TUR)', 1.86),
(24, 14, 'Martin JAKUBKO', '1980-02-26', 'delantero', 'FC Moscow (RUS)', 1.93),
(24, 15, 'Miroslav STOCH', '1989-10-19', 'medio', 'Twente Enschede (NED)', 1.68),
(24, 16, 'Jan DURICA', '1981-12-10', 'defensa', 'Hannover 96 (GER)', 1.87),
(24, 17, 'Marek HAMSIK', '1987-07-27', 'medio', 'Napoli (ITA)', 1.84),
(24, 18, 'Erik JENDRISEK', '1986-10-26', 'delantero', 'Kaiserslautern (GER)', 1.76),
(24, 19, 'Juraj KUCKA', '1987-02-26', 'medio', 'Sparta Prague (CZE)', 1.86),
(24, 20, 'Kamil KOPUNEK', '1984-05-18', 'medio', 'Spartak Trnava (SVK)', 1.80),
(24, 21, 'Kornel SALATA', '1985-01-24', 'defensa', 'Slovan Bratislava (SVK)', 1.90),
(24, 22, 'Martin PETRAS', '1979-11-02', 'defensa', 'Cesena (ITA)', 1.87),
(24, 23, 'Dusan KUCIAK', '1985-05-21', 'arquero', 'Vaslui (ROU)', 1.95),
(25, 1, 'JULIO CESAR', '1979-09-03', 'arquero', 'Inter (ITA)', 1.86),
(25, 2, 'MAICON', '1981-07-26', 'defensa', 'Inter (ITA)', 1.86),
(25, 3, 'LUCIO', '1978-05-08', 'defensa', 'Inter (ITA)', 1.88),
(25, 4, 'JUAN', '1979-02-01', 'defensa', 'AS Roma (ITA)', 1.82),
(25, 5, 'FELIPE MELO', '1983-06-26', 'medio', 'Juventus (ITA)', 1.83),
(25, 6, 'MICHEL BASTOS', '1983-08-02', 'defensa', 'Lyon (FRA)', 1.79),
(25, 7, 'ELANO', '1981-06-14', 'medio', 'Galatasaray (TUR)', 1.74),
(25, 8, 'GILBERTO SILVA', '1976-10-07', 'medio', 'Panathinaikos (GRE)', 1.84),
(25, 9, 'LUIS FABIANO', '1980-11-08', 'delantero', 'Sevilla FC (ESP)', 1.86),
(25, 10, 'KAKA', '1982-04-22', 'medio', 'Real Madrid (ESP)', 1.86),
(25, 11, 'ROBINHO', '1984-01-25', 'delantero', 'Santos (BRA)', 1.75),
(25, 12, 'GOMES', '1981-02-15', 'arquero', 'Tottenham Hotspur (ENG)', 1.91),
(25, 13, 'DANI ALVES', '1983-05-06', 'defensa', 'Barcelona (ESP)', 1.73),
(25, 14, 'LUISAO', '1981-02-13', 'defensa', 'Benfica (POR)', 1.93),
(25, 15, 'THIAGO SILVA', '1984-09-22', 'defensa', 'AC Milan (ITA)', 1.83),
(25, 16, 'GILBERTO MELO', '1976-04-25', 'defensa', 'Cruzeiro (BRA)', 1.80),
(25, 17, 'JOSUE', '1979-07-19', 'medio', 'Wolfsburg (GER)', 1.69),
(25, 18, 'RAMIRES', '1987-03-24', 'medio', 'Benfica (POR)', 1.79),
(25, 19, 'JULIO BAPTISTA', '1981-10-01', 'medio', 'AS Roma (ITA)', 1.85),
(25, 20, 'KLEBERSON', '1979-06-19', 'medio', 'Flamengo (BRA)', 1.75),
(25, 21, 'NILMAR', '1984-07-14', 'delantero', 'Villarreal (ESP)', 1.80),
(25, 22, 'DONI', '1979-10-22', 'arquero', 'AS Roma (ITA)', 1.94),
(25, 23, 'GRAFITE', '1979-04-02', 'delantero', 'Wolfsburg (GER)', 1.89),
(26, 1, 'RI Myong Guk', '1986-09-09', 'arquero', 'Pyongyang City (PRK)', 1.87),
(26, 2, 'CHA Jong Hyok', '1985-09-25', 'defensa', 'Amrokgang (PRK)', 1.78),
(26, 3, 'RI Jun Il', '1987-08-24', 'defensa', 'Sobaeksu (PRK)', 1.78),
(26, 4, 'PAK Nam Chol', '1985-07-02', 'medio', 'April 25 (PRK)', 1.72),
(26, 5, 'RI Kwang Chon', '1985-09-04', 'defensa', 'April 25 (PRK)', 1.83),
(26, 6, 'KIM Kum Il', '1987-10-10', 'medio', 'April 25 (PRK)', 1.70),
(26, 7, 'AN Chol Hyok', '1987-06-27', 'delantero', 'Rimyongsu (PRK)', 1.78),
(26, 8, 'JI Yun Nam', '1976-11-20', 'defensa', 'April 25 (PRK)', 1.72),
(26, 9, 'JONG Tae Se', '1984-03-02', 'delantero', 'Kawasaki Frontale (JPN)', 1.81),
(26, 10, 'HONG Yong Jo', '1982-05-22', 'delantero', 'FK Rostov (RUS)', 1.74),
(26, 11, 'MUN In Guk', '1978-09-29', 'medio', 'April 25 (PRK)', 1.67),
(26, 12, 'CHOE Kum Chol', '1987-02-09', 'delantero', 'April 25 (PRK)', 1.78),
(26, 13, 'PAK Chol Jin', '1985-09-05', 'defensa', 'Amrokgang (PRK)', 1.84),
(26, 14, 'PAK Nam Chol', '1988-10-03', 'defensa', 'Amrokgang (PRK)', 1.83),
(26, 15, 'KIM Yong Jun', '1983-07-19', 'medio', 'Pyongyang City (PRK)', 1.82),
(26, 16, 'NAM Song Chol', '1982-05-07', 'defensa', 'April 25 (PRK)', 1.78),
(26, 17, 'AN Yong Hak', '1978-10-25', 'medio', 'Omiya Ardija (JPN)', 1.82),
(26, 18, 'KIM Myong Gil', '1984-10-16', 'arquero', 'Amrokgang (PRK)', 1.81),
(26, 19, 'RI Chol Myong', '1988-02-18', 'medio', 'Pyongyang City (PRK)', 1.73),
(26, 20, 'KIM Myong Won', '1983-07-15', 'arquero', 'Amrokgang (PRK)', 1.80),
(26, 21, 'RI Kwang Hyok', '1987-08-17', 'defensa', 'Kyonggongop (PRK)', 1.78),
(26, 22, 'KIM Kyong Il', '1988-12-11', 'medio', 'Rimyongsu (PRK)', 1.74),
(26, 23, 'PAK Sung Hyok', '1990-05-30', 'medio', 'Sobaeksu (PRK)', 1.75),
(27, 1, 'Boubacar BARRY', '1979-12-30', 'arquero', 'Lokeren (BEL)', 1.80),
(27, 2, 'Brou ANGOUA', '1986-11-28', 'defensa', 'Valenciennes (FRA)', 1.78),
(27, 3, 'Arthur BOKA', '1983-04-02', 'defensa', 'VfB Stuttgart (GER)', 1.66),
(27, 4, 'Kolo TOURE', '1981-03-19', 'defensa', 'Manchester City (ENG)', 1.83),
(27, 5, 'Didier ZOKORA', '1980-12-14', 'medio', 'Sevilla FC (ESP)', 1.83),
(27, 6, 'Steve GOHOURI', '1981-02-08', 'defensa', 'Wigan (ENG)', 1.87),
(27, 7, 'Seydou DOUMBIA', '1987-12-31', 'delantero', 'Young Boys (SUI)', 1.83),
(27, 8, 'Salomon KALOU', '1985-08-05', 'delantero', 'Chelsea (ENG)', 1.75),
(27, 9, 'Ismael TIOTE', '1986-06-21', 'medio', 'Twente Enschede (NED)', 1.75),
(27, 10, 'GERVINHO', '1987-05-27', 'delantero', 'Lille (FRA)', 1.79),
(27, 11, 'Didier DROGBA', '1978-03-11', 'delantero', 'Chelsea (ENG)', 1.80),
(27, 12, 'Jean Jacques GOSSO', '1983-03-15', 'medio', 'Monaco (FRA)', 1.77),
(27, 13, 'ROMARIC', '1983-06-04', 'medio', 'Sevilla FC (ESP)', 1.87),
(27, 14, 'Emmanuel KONE', '1986-12-31', 'medio', 'International (ROU)', 1.77),
(27, 15, 'Aruna DINDANE', '1980-11-26', 'delantero', 'Portsmouth (ENG)', 1.74),
(27, 16, 'Aristide ZOGBO', '1981-12-30', 'arquero', 'Maccabi Netanya (ISR)', 1.83),
(27, 17, 'Siaka TIENE', '1982-02-22', 'defensa', 'Valenciennes (FRA)', 1.76),
(27, 18, 'Kader KEITA', '1981-08-06', 'delantero', 'Galatasaray (TUR)', 1.84),
(27, 19, 'Yaya TOURE', '1983-05-13', 'medio', 'Barcelona (ESP)', 1.89),
(27, 20, 'Guy DEMEL', '1981-06-13', 'defensa', 'Hamburger SV (GER)', 1.91),
(27, 21, 'Emmanuel EBOUE', '1983-06-04', 'defensa', 'Arsenal (ENG)', 1.78),
(27, 22, 'Souleymane BAMBA', '1985-01-13', 'defensa', 'Hibernian (SCO)', 1.90),
(27, 23, 'Daniel YEBOAH', '1984-11-13', 'arquero', 'ASEC Mimosas (CIV)', 1.87),
(28, 1, 'EDUARDO', '1982-09-19', 'arquero', 'Braga (POR)', 1.87),
(28, 2, 'BRUNO ALVES', '1981-11-27', 'defensa', 'Porto (POR)', 1.87),
(28, 3, 'PAULO FERREIRA', '1979-01-18', 'defensa', 'Chelsea (ENG)', 1.81),
(28, 4, 'ROLANDO', '1985-08-31', 'defensa', 'Porto (POR)', 1.89),
(28, 5, 'DUDA', '1980-06-27', 'defensa', 'Malaga (ESP)', 1.75),
(28, 6, 'RICARDO CARVALHO', '1978-05-18', 'defensa', 'Chelsea (ENG)', 1.83),
(28, 7, 'CRISTIANO RONALDO', '1985-02-05', 'delantero', 'Real Madrid (ESP)', 1.85),
(28, 8, 'PEDRO MENDES', '1979-02-26', 'medio', 'Sporting Lisbon (POR)', 1.77),
(28, 9, 'LIEDSON', '1977-12-17', 'delantero', 'Sporting Lisbon (POR)', 1.73),
(28, 10, 'DANNY', '1983-08-07', 'delantero', 'Zenit St Petersburg (RUS)', 1.79),
(28, 11, 'SIMAO', '1979-10-31', 'delantero', 'Atletico Madrid (ESP)', 1.70),
(28, 12, 'BETO', '1982-05-01', 'arquero', 'Porto (POR)', 1.83),
(28, 13, 'MIGUEL', '1980-01-04', 'defensa', 'Valencia (ESP)', 1.75),
(28, 14, 'MIGUEL VELOSO', '1986-05-11', 'medio', 'Sporting Lisbon (POR)', 1.81),
(28, 15, 'PEPE', '1983-02-26', 'medio', 'Real Madrid (ESP)', 1.86),
(28, 16, 'RAUL MEIRELES', '1983-03-17', 'medio', 'Porto (POR)', 1.79),
(28, 17, 'RUBEN AMORIM', '1985-01-27', 'medio', 'Benfica (POR)', 1.80),
(28, 18, 'HUGO ALMEIDA', '1984-05-23', 'delantero', 'Werder Bremen (GER)', 1.93);
INSERT INTO `jugador` (`id`, `nro`, `nombre`, `fecha_nac`, `posicion`, `club`, `altura`) VALUES
(28, 19, 'TIAGO', '1981-05-02', 'medio', 'Atletico Madrid (ESP)', 1.83),
(28, 20, 'DECO', '1977-08-27', 'medio', 'Chelsea (ENG)', 1.75),
(28, 21, 'RICARDO COSTA', '1981-05-16', 'defensa', 'Lille (FRA)', 1.83),
(28, 22, 'DANIEL FERNANDES', '1983-09-25', 'arquero', 'Iraklis (GRE)', 1.94),
(28, 23, 'FABIO COENTRAO', '1988-03-11', 'defensa', 'Benfica (POR)', 1.81),
(29, 1, 'Iker CASILLAS', '1981-05-20', 'arquero', 'Real Madrid (ESP)', 1.84),
(29, 2, 'Raul ALBIOL', '1985-09-04', 'defensa', 'Real Madrid (ESP)', 1.87),
(29, 3, 'Gerard PIQUE', '1987-02-02', 'defensa', 'Barcelona (ESP)', 1.92),
(29, 4, 'Carlos MARCHENA', '1979-07-31', 'defensa', 'Valencia (ESP)', 1.82),
(29, 5, 'Carles PUYOL', '1978-04-13', 'defensa', 'Barcelona (ESP)', 1.78),
(29, 6, 'Andres INIESTA', '1984-05-11', 'medio', 'Barcelona (ESP)', 1.70),
(29, 7, 'David VILLA', '1981-12-03', 'delantero', 'Valencia (ESP)', 1.75),
(29, 8, 'XAVI', '1980-01-25', 'medio', 'Barcelona (ESP)', 1.70),
(29, 9, 'Fernando TORRES', '1984-03-20', 'delantero', 'Liverpool (ENG)', 1.81),
(29, 10, 'Cesc FABREGAS', '1987-05-04', 'medio', 'Arsenal (ENG)', 1.75),
(29, 11, 'Joan CAPDEVILA', '1978-02-03', 'defensa', 'Villarreal (ESP)', 1.82),
(29, 12, 'Victor VALDES', '1982-01-14', 'arquero', 'Barcelona (ESP)', 1.83),
(29, 13, 'Juan Manuel MATA', '1988-04-28', 'delantero', 'Valencia (ESP)', 1.74),
(29, 14, 'XABI ALONSO', '1981-11-25', 'medio', 'Real Madrid (ESP)', 1.83),
(29, 15, 'SERGIO RAMOS', '1986-03-30', 'defensa', 'Real Madrid (ESP)', 1.83),
(29, 16, 'Sergio BUSQUETS', '1988-07-16', 'medio', 'Barcelona (ESP)', 1.89),
(29, 17, 'Alvaro ARBELOA', '1983-01-17', 'defensa', 'Real Madrid (ESP)', 1.84),
(29, 18, 'PEDRO', '1987-07-28', 'delantero', 'Barcelona (ESP)', 1.69),
(29, 19, 'Fernando LLORENTE', '1985-02-26', 'delantero', 'Athletic Bilbao (ESP)', 1.94),
(29, 20, 'Javier MARTINEZ', '1988-09-02', 'medio', 'Athletic Bilbao (ESP)', 1.90),
(29, 21, 'DAVID SILVA', '1986-01-08', 'medio', 'Valencia (ESP)', 1.77),
(29, 22, 'Jesus NAVAS', '1985-11-21', 'delantero', 'Sevilla FC (ESP)', 1.72),
(29, 23, 'Pepe REINA', '1982-08-31', 'arquero', 'Liverpool (ENG)', 1.87),
(30, 1, 'Diego BENAGLIO', '1983-09-08', 'arquero', 'Wolfsburg (GER)', 1.93),
(30, 2, 'Stephan LICHTSTEINER', '1984-01-16', 'defensa', 'Lazio (ITA)', 1.80),
(30, 3, 'Ludovic MAGNIN', '1979-04-20', 'defensa', 'FC Zurich (SUI)', 1.86),
(30, 4, 'Philippe SENDEROS', '1985-02-14', 'defensa', 'Everton (ENG)', 1.90),
(30, 5, 'Steve VON BERGEN', '1983-06-10', 'defensa', 'Hertha Berlin (GER)', 1.83),
(30, 6, 'Benjamin HUGGEL', '1977-07-07', 'medio', 'Basel (SUI)', 1.90),
(30, 7, 'Tranquillo BARNETTA', '1985-05-22', 'medio', 'Bayer Leverkusen (GER)', 1.78),
(30, 8, 'Gokhan INLER', '1984-06-27', 'medio', 'Udinese (ITA)', 1.83),
(30, 9, 'Alexander FREI', '1979-07-15', 'delantero', 'Basel (SUI)', 1.80),
(30, 10, 'Blaise NKUFO', '1975-05-25', 'delantero', 'Twente Enschede (NED)', 1.86),
(30, 11, 'Valon BEHRAMI', '1985-04-19', 'medio', 'West Ham Utd. (ENG)', 1.84),
(30, 12, 'Marco WOELFLI', '1982-08-22', 'arquero', 'Young Boys (SUI)', 1.85),
(30, 13, 'Stephane GRICHTING', '1979-03-30', 'defensa', 'Auxerre (FRA)', 1.86),
(30, 14, 'Marco PADALINO', '1983-12-08', 'medio', 'Sampdoria (ITA)', 1.77),
(30, 15, 'Hakan YAKIN', '1977-02-22', 'medio', 'Lucerne (SUI)', 1.80),
(30, 16, 'Gelson FERNANDES', '1986-09-02', 'medio', 'Saint-Etienne (FRA)', 1.83),
(30, 17, 'Reto ZIEGLER', '1986-01-16', 'defensa', 'Sampdoria (ITA)', 1.83),
(30, 18, 'Albert BUNJAKU', '1983-11-29', 'delantero', 'Nuremberg (GER)', 1.78),
(30, 19, 'Eren DERDIYOK', '1988-06-12', 'delantero', 'Bayer Leverkusen (GER)', 1.90),
(30, 20, 'Pirmin SCHWEGLER', '1987-03-09', 'medio', 'Eintracht Frankfurt (GER)', 1.78),
(30, 21, 'Johnny LEONI', '1984-06-30', 'arquero', 'FC Zurich (SUI)', 1.89),
(30, 22, 'Mario EGGIMANN', '1981-01-24', 'defensa', 'Hannover 96 (GER)', 1.84),
(30, 23, 'Xherdan SHAQIRI', '1991-10-10', 'medio', 'Basel (SUI)', 1.69),
(31, 1, 'Ricardo CANALES', '1982-05-30', 'arquero', 'Motagua (HON)', 1.80),
(31, 2, 'Osman CHAVEZ', '1984-07-29', 'defensa', 'Platense (HON)', 1.87),
(31, 3, 'Maynor FIGUEROA', '1983-05-02', 'defensa', 'Wigan (ENG)', 1.82),
(31, 4, 'Jhony PALACIOS', '1986-12-20', 'defensa', 'Olimpia Tegucigalpa (HON)', 1.82),
(31, 5, 'Victor BERNARDEZ', '1982-05-24', 'defensa', 'Anderlecht (BEL)', 1.87),
(31, 6, 'Hendry THOMAS', '1985-02-23', 'medio', 'Wigan (ENG)', 1.80),
(31, 7, 'Ramon NUNEZ', '1985-11-14', 'medio', 'Olimpia Tegucigalpa (HON)', 1.69),
(31, 8, 'Wilson PALACIOS', '1984-07-29', 'medio', 'Tottenham Hotspur (ENG)', 1.76),
(31, 9, 'Carlos PAVON', '1973-10-09', 'delantero', 'Real Espana (HON)', 1.80),
(31, 10, 'Jerry PALACIOS', '1982-05-13', 'medio', 'Hangzhou Greentown (CHN)', 1.83),
(31, 11, 'David SUAZO', '1979-11-05', 'delantero', 'Genoa (ITA)', 1.83),
(31, 12, 'Georgie WELCOME', '1985-03-09', 'delantero', 'Motagua (HON)', 1.92),
(31, 13, 'Roger ESPINOZA', '1986-10-25', 'delantero', 'Kansas City Wizards (USA)', 1.78),
(31, 14, 'Oscar GARCIA', '1984-09-04', 'defensa', 'Olimpia Tegucigalpa (HON)', 1.76),
(31, 15, 'Walter MARTINEZ', '1982-03-24', 'delantero', 'Marathon (HON)', 1.66),
(31, 16, 'Mauricio SABILLON', '1978-11-11', 'defensa', 'Hangzhou Greentown (CHN)', 1.80),
(31, 17, 'Edgar ALVAREZ', '1980-01-18', 'medio', 'Bari (ITA)', 1.70),
(31, 18, 'Noel VALLADARES', '1977-05-03', 'arquero', 'Olimpia Tegucigalpa (HON)', 1.79),
(31, 19, 'Danilo TURCIOS', '1978-05-08', 'medio', 'Olimpia Tegucigalpa (HON)', 1.66),
(31, 20, 'Amado GUEVARA', '1976-05-02', 'medio', 'Motagua (HON)', 1.76),
(31, 21, 'Emilio IZAGUIRRE', '1986-05-10', 'defensa', 'Motagua (HON)', 1.78),
(31, 22, 'Donis ESCOBER', '1981-02-03', 'arquero', 'Olimpia Tegucigalpa (HON)', 1.80),
(31, 23, 'Sergio MENDOZA', '1981-05-23', 'defensa', 'Motagua (HON)', 1.77),
(32, 1, 'Claudio BRAVO', '1983-04-13', 'arquero', 'Real Sociedad (ESP)', 1.83),
(32, 2, 'Ismael FUENTES', '1981-08-04', 'defensa', 'Univ. Catolica (CHI)', 1.81),
(32, 3, 'Waldo PONCE', '1982-12-04', 'defensa', 'Univ. Catolica (CHI)', 1.83),
(32, 4, 'Mauricio ISLA', '1988-06-12', 'defensa', 'Udinese (ITA)', 1.77),
(32, 5, 'Pablo CONTRERAS', '1978-09-11', 'defensa', 'PAOK (GRE)', 1.78),
(32, 6, 'Carlos CARMONA', '1987-02-21', 'medio', 'Reggina (ITA)', 1.79),
(32, 7, 'Alexis SANCHEZ', '1988-12-19', 'delantero', 'Udinese (ITA)', 1.68),
(32, 8, 'Arturo VIDAL', '1987-05-22', 'medio', 'Bayer Leverkusen (GER)', 1.78),
(32, 9, 'Humberto SUAZO', '1981-05-10', 'delantero', 'Zaragoza (ESP)', 1.71),
(32, 10, 'Jorge VALDIVIA', '1983-10-19', 'medio', 'Al Ain (UAE)', 1.73),
(32, 11, 'Mark GONZALEZ', '1984-07-10', 'delantero', 'CSKA Moscow (RUS)', 1.75),
(32, 12, 'Miguel PINTO', '1983-07-04', 'arquero', 'Univ. de Chile (CHI)', 1.80),
(32, 13, 'Marco ESTRADA', '1983-05-28', 'medio', 'Univ. de Chile (CHI)', 1.74),
(32, 14, 'Matias FERNANDEZ', '1986-05-15', 'medio', 'Sporting Lisbon (POR)', 1.76),
(32, 15, 'Jean BEAUSEJOUR', '1984-06-01', 'delantero', 'America (MEX)', 1.78),
(32, 16, 'Fabian ORELLANA', '1986-01-27', 'delantero', 'Xerez (ESP)', 1.68),
(32, 17, 'Gary MEDEL', '1987-08-03', 'defensa', 'Boca Juniors (ARG)', 1.71),
(32, 18, 'Gonzalo JARA', '1985-08-29', 'defensa', 'West Bromwich Albion (ENG)', 1.77),
(32, 19, 'Gonzalo FIERRO', '1983-03-21', 'medio', 'Flamengo (BRA)', 1.71),
(32, 20, 'Rodrigo MILLAR', '1981-11-03', 'medio', 'Colo Colo (CHI)', 1.82),
(32, 21, 'Rodrigo TELLO', '1979-10-14', 'medio', 'Besiktas (TUR)', 1.71),
(32, 22, 'Esteban PAREDES', '1980-08-01', 'delantero', 'Colo Colo (CHI)', 1.79),
(32, 23, 'Luis MARIN', '1983-05-18', 'arquero', 'Union Espanola (CHI)', 1.86);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `partido`
--
CREATE TABLE IF NOT EXISTS `partido` (
`id` tinyint(3) unsigned NOT NULL,
`fecha` datetime NOT NULL,
`id_est` tinyint(3) unsigned NOT NULL,
`local` tinyint(3) unsigned NOT NULL,
`visita` tinyint(3) unsigned NOT NULL,
`gol_local` tinyint(3) unsigned NOT NULL,
`gol_visita` tinyint(3) unsigned NOT NULL,
`tipo` enum('grupo','octavos','cuartos','semifinal','tercer puesto','final') COLLATE latin1_spanish_ci NOT NULL DEFAULT 'grupo',
PRIMARY KEY (`id`),
KEY `visita` (`visita`),
KEY `local` (`local`),
KEY `id_est` (`id_est`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `partido`
--
INSERT INTO `partido` (`id`, `fecha`, `id_est`, `local`, `visita`, `gol_local`, `gol_visita`, `tipo`) VALUES
(1, '2010-06-11 16:00:00', 4, 1, 2, 1, 1, 'grupo'),
(2, '2010-06-11 20:30:00', 1, 3, 4, 0, 0, 'grupo'),
(3, '2010-06-12 16:00:00', 3, 5, 6, 1, 0, 'grupo'),
(4, '2010-06-12 13:30:00', 5, 7, 8, 2, 0, 'grupo'),
(5, '2010-06-12 20:30:00', 8, 9, 10, 1, 1, 'grupo'),
(6, '2010-06-13 13:30:00', 7, 11, 12, 0, 1, 'grupo'),
(7, '2010-06-13 20:30:00', 2, 13, 14, 4, 0, 'grupo'),
(8, '2010-06-13 16:00:00', 9, 15, 16, 0, 1, 'grupo'),
(9, '2010-06-14 13:30:00', 4, 17, 18, 2, 0, 'grupo'),
(10, '2010-06-14 16:00:00', 10, 19, 20, 1, 0, 'grupo'),
(11, '2010-06-14 20:30:00', 1, 21, 22, 1, 1, 'grupo'),
(12, '2010-06-15 13:30:00', 8, 23, 24, 1, 1, 'grupo'),
(13, '2010-06-15 16:00:00', 5, 27, 28, 0, 0, 'grupo'),
(14, '2010-06-15 20:30:00', 3, 25, 26, 2, 1, 'grupo'),
(15, '2010-06-16 13:30:00', 6, 31, 32, 0, 1, 'grupo'),
(16, '2010-06-16 16:00:00', 2, 29, 30, 0, 1, 'grupo'),
(17, '2010-06-16 20:30:00', 9, 1, 3, 0, 3, 'grupo'),
(18, '2010-06-17 20:30:00', 7, 4, 2, 0, 2, 'grupo'),
(19, '2010-06-17 16:00:00', 10, 8, 6, 2, 1, 'grupo'),
(20, '2010-06-17 13:30:00', 4, 5, 7, 4, 1, 'grupo'),
(21, '2010-06-18 13:30:00', 5, 13, 15, 0, 1, 'grupo'),
(22, '2010-06-18 16:00:00', 3, 12, 10, 2, 2, 'grupo'),
(23, '2010-06-18 20:30:00', 1, 9, 11, 0, 0, 'grupo'),
(24, '2010-06-19 16:00:00', 8, 16, 14, 1, 1, 'grupo'),
(25, '2010-06-19 13:30:00', 2, 17, 19, 1, 0, 'grupo'),
(26, '2010-06-19 20:30:00', 9, 20, 18, 1, 2, 'grupo'),
(27, '2010-06-20 13:30:00', 10, 24, 22, 0, 2, 'grupo'),
(28, '2010-06-20 16:00:00', 6, 21, 23, 1, 1, 'grupo'),
(29, '2010-06-20 20:30:00', 4, 25, 27, 3, 1, 'grupo'),
(30, '2010-06-21 13:30:00', 1, 28, 26, 7, 0, 'grupo'),
(31, '2010-06-21 16:00:00', 5, 32, 30, 1, 0, 'grupo'),
(32, '2010-06-21 20:30:00', 3, 29, 31, 2, 0, 'grupo'),
(33, '2010-06-22 16:00:00', 8, 2, 3, 0, 1, 'grupo'),
(34, '2010-06-22 16:00:00', 10, 4, 1, 1, 2, 'grupo'),
(35, '2010-06-22 20:30:00', 2, 6, 7, 2, 2, 'grupo'),
(36, '2010-06-22 20:30:00', 7, 8, 5, 0, 2, 'grupo'),
(37, '2010-06-23 16:00:00', 5, 12, 9, 0, 1, 'grupo'),
(38, '2010-06-23 16:00:00', 9, 10, 11, 1, 0, 'grupo'),
(39, '2010-06-23 20:30:00', 4, 16, 13, 0, 1, 'grupo'),
(40, '2010-06-23 20:30:00', 6, 14, 15, 2, 1, 'grupo'),
(41, '2010-06-24 16:00:00', 3, 24, 21, 3, 2, 'grupo'),
(42, '2010-06-24 16:00:00', 7, 22, 23, 0, 0, 'grupo'),
(43, '2010-06-24 20:30:00', 8, 18, 19, 1, 3, 'grupo'),
(44, '2010-06-24 20:30:00', 1, 20, 17, 1, 2, 'grupo'),
(45, '2010-06-25 16:00:00', 2, 28, 25, 0, 0, 'grupo'),
(46, '2010-06-25 16:00:00', 6, 26, 27, 0, 3, 'grupo'),
(47, '2010-06-25 20:30:00', 9, 32, 29, 1, 2, 'grupo'),
(48, '2010-06-25 20:30:00', 10, 30, 31, 0, 0, 'grupo'),
(49, '2010-06-26 16:00:00', 5, 3, 7, 2, 1, 'octavos'),
(50, '2010-06-26 20:30:00', 8, 10, 16, 1, 2, 'octavos'),
(51, '2010-06-27 16:00:00', 10, 13, 9, 4, 1, 'octavos'),
(52, '2010-06-27 20:30:00', 4, 5, 2, 3, 1, 'octavos'),
(53, '2010-06-28 16:00:00', 2, 17, 24, 2, 1, 'octavos'),
(54, '2010-06-28 20:30:00', 3, 25, 32, 3, 0, 'octavos'),
(55, '2010-06-29 16:00:00', 9, 22, 19, 0, 0, 'octavos'),
(56, '2010-06-29 20:30:00', 1, 29, 28, 1, 0, 'octavos'),
(57, '2010-07-02 16:00:00', 5, 17, 25, 2, 1, 'cuartos'),
(58, '2010-07-02 20:30:00', 4, 3, 16, 1, 1, 'cuartos'),
(59, '2010-07-03 16:00:00', 1, 5, 13, 0, 4, 'cuartos'),
(60, '2010-07-03 20:30:00', 3, 22, 29, 0, 1, 'cuartos'),
(61, '2010-07-06 20:30:00', 1, 3, 17, 2, 3, 'semifinal'),
(62, '2010-07-07 20:30:00', 2, 13, 29, 0, 1, 'semifinal'),
(63, '2010-07-10 20:30:00', 5, 3, 13, 2, 3, 'tercer puesto'),
(64, '2010-07-11 20:30:00', 4, 17, 29, 0, 1, 'final');
-- --------------------------------------------------------
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `seleccion`
--
CREATE TABLE IF NOT EXISTS `seleccion` (
`id` tinyint(3) unsigned NOT NULL,
`nombre` varchar(16) COLLATE latin1_spanish_ci NOT NULL,
`grupo` char(1) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`confederacion` char(8) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
--
-- Volcar la base de datos para la tabla `seleccion`
--
INSERT INTO `seleccion` (`id`, `nombre`, `grupo`, `confederacion`) VALUES
(1, 'Sudafrica', 'A', 'CAF'),
(2, 'Mexico', 'A', 'CONCACAF'),
(3, 'Uruguay', 'A', 'CONMEBOL'),
(4, 'Francia', 'A', 'UEFA'),
(5, 'Argentina', 'B', 'CONMEBOL'),
(6, 'Nigeria', 'B', 'CAF'),
(7, 'Corea del Sur', 'B', 'AFC'),
(8, 'Grecia', 'B', 'UEFA'),
(9, 'Inglaterra', 'C', 'UEFA'),
(10, 'U.S.A.', 'C', 'CONCACAF'),
(11, 'Algeria', 'C', 'CAF'),
(12, 'Eslovenia', 'C', 'UEFA'),
(13, 'Alemania', 'D', 'UEFA'),
(14, 'Australia', 'D', 'OFC'),
(15, 'Serbia', 'D', 'UEFA'),
(16, 'Ghana', 'D', 'CAF'),
(17, 'Holanda', 'E', 'UEFA'),
(18, 'Dinamarca', 'E', 'UEFA'),
(19, 'Japon', 'E', 'AFC'),
(20, 'Camerun', 'E', 'CAF'),
(21, 'Italia', 'F', 'UEFA'),
(22, 'Paraguay', 'F', 'CONMEBOL'),
(23, 'Nueva Zelandia', 'F', 'OFC'),
(24, 'Eslovaquia', 'F', 'UEFA'),
(25, 'Brasil', 'G', 'CONMEBOL'),
(26, 'Corea del Norte', 'G', 'AFC'),
(27, 'Costa de Marfil', 'G', 'CAF'),
(28, 'Portugal', 'G', 'UEFA'),
(29, 'España', 'H', 'UEFA'),
(30, 'Suiza', 'H', 'UEFA'),
(31, 'Honduras', 'H', 'CONCACAF'),
(32, 'Chile', 'H', 'CONMEBOL');
-- --------------------------------------------------------
--
-- Filtros para las tablas descargadas (dump)
--
--
-- Filtros para la tabla `dt`
--
ALTER TABLE `dt`
ADD CONSTRAINT `dt_ibfk_1` FOREIGN KEY (`id_sel`) REFERENCES `seleccion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Filtros para la tabla `gol`
--
ALTER TABLE `gol`
ADD CONSTRAINT `gol_ibfk_1` FOREIGN KEY (`id_partido`) REFERENCES `partido` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `gol_ibfk_2` FOREIGN KEY (`id_sel`,`nro`) REFERENCES `jugador` (`id`,`nro`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Filtros para la tabla `jugador`
--
ALTER TABLE `jugador`
ADD CONSTRAINT `jugador_ibfk_1` FOREIGN KEY (`id`) REFERENCES `seleccion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Filtros para la tabla `partido`
--
ALTER TABLE `partido`
ADD CONSTRAINT `partido_ibfk_1` FOREIGN KEY (`id_est`) REFERENCES `estadio` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `partido_ibfk_2` FOREIGN KEY (`local`) REFERENCES `seleccion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `partido_ibfk_3` FOREIGN KEY (`visita`) REFERENCES `seleccion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
Related searches
- heap dump analyzer eclipse
- pineapple mandarin orange dump cake
- dump cake only 3 ingredients
- leon county dump sites
- epub dump free
- city of arlington dump hours
- 3 ingredient dump cake
- 3 ingredient cake mix dump peach cobbler
- 3 ingredient dump cake recipes
- dump truck loan calculator
- eclipse heap dump analyzer
- apple dump cake with canned pie filling