-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.5.13


/*!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 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema `cross`
--

CREATE DATABASE IF NOT EXISTS `cross`;
USE `cross`;

--
-- Definition of table `atletas`
--

DROP TABLE IF EXISTS `atletas`;
CREATE TABLE `atletas` (
  `dorsal` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(45) NOT NULL,
  `fecha_nacimiento` date DEFAULT NULL,
  `tiempo` time DEFAULT NULL,
  `cod_equipo` varchar(45) DEFAULT NULL,
  `sexo` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`dorsal`)
) ENGINE=InnoDB AUTO_INCREMENT=1306 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `atletas`
--

/*!40000 ALTER TABLE `atletas` DISABLE KEYS */;
INSERT INTO `atletas` (`dorsal`,`nombre`,`fecha_nacimiento`,`tiempo`,`cod_equipo`,`sexo`) VALUES 
 (1001,'Abel Anton','1964-11-11','23:10:00','ESP','M'),
 (1002,'Fermin Cacho','1967-10-10','23:15:00','ESP','M'),
 (1003,'Juan Palomo','1973-04-04','23:19:00','ESP','M'),
 (1004,'Victor Laseca','1976-03-03','23:14:00','ESP','M'),
 (1005,'Anton Pirulero','1975-02-02','23:13:00','ESP','M'),
 (1006,'Juanita Banana','1985-02-05','20:15:00','ESP','F'),
 (1007,'Petra Picapiedra','1987-04-07',NULL,'ESP','F'),
 (1008,'Maria Gutierrez','1987-11-02','20:16:00','ESP','F'),
 (1009,'Julia Gutierrez','1988-12-12',NULL,'ESP','F'),
 (1010,'Berta Martinez','1986-04-09',NULL,'ESP','F'),
 (1011,'Bernarda Lacasta','1983-11-03','20:18:00','ESP','F'),
 (1012,'Mario Benedit','1992-02-02','17:02:00','ESP','M'),
 (1013,'Julio Jimenez','1991-10-10','17:05:00','ESP','M'),
 (1014,'Bernabe Piedra','1990-03-16','17:03:00','ESP','M'),
 (1015,'Cosme Prenafeta','1991-10-11','17:11:00','ESP','M'),
 (1016,'Perico Palotes','1992-06-21','17:09:00','ESP','M'),
 (1017,'Juliana Hermana','1991-11-10','15:10:00','ESP','F'),
 (1018,'Paula Abad','1990-07-07','15:11:00','ESP','F'),
 (1019,'Maria Mercado','1991-11-04','15:14:00','ESP','F'),
 (1020,'Valeriana Pescado','1990-05-17','15:13:00','ESP','F'),
 (1021,'Luis Piedrahita','1993-12-13',NULL,'ESP','M'),
 (1022,'Julio Villalva','1994-05-23','12:12:00','ESP','M'),
 (1023,'Perico Delgado','1993-11-11',NULL,'ESP','M'),
 (1024,'Martin Berasa','1994-10-17',NULL,'ESP','M'),
 (1025,'Pablo Marmol','1993-08-09','12:33:00','ESP','M'),
 (1026,'Luisa Fernanda','1994-10-11','10:17:00','ESP','F'),
 (1027,'Montserrat Caballe','1993-02-06','10:15:00','ESP','F'),
 (1028,'Esmeralda Diamante','1994-05-11','10:25:00','ESP','F'),
 (1029,'Yolanda Anda','1993-07-11','10:23:00','ESP','F'),
 (1030,'Carmen Merina','1994-04-18',NULL,'ESP','F'),
 (1100,'Francois Holande','1988-01-01','23:18:00','FRA','M'),
 (1101,'Enriq Lemande','1986-11-04','23:21:00','FRA','M'),
 (1102,'Valeri Giscard','1985-10-11','23:11:00','FRA','M'),
 (1103,'Chiquet Lapetre','1986-12-07','23:20:00','FRA','M'),
 (1104,'Bernard Hinault','1986-10-10','23:12:00','FRA','M'),
 (1105,'Marie Curie','1987-01-26','20:19:00','FRA','F'),
 (1106,'Luise Mertel','1988-04-25','20:17:00','FRA','F'),
 (1107,'Corine Nouveau','1986-05-12','20:21:00','FRA','F'),
 (1108,'Julie Novie','1985-11-11','20:20:00','FRA','F'),
 (1109,'Felisse Nisse','1987-10-23','20:22:00','FRA','F'),
 (1200,'Jhonn Walker','1988-03-19','23:22:00','GBR','M'),
 (1201,'Peter Ustinis','1987-10-16','23:16:00','GBR','M'),
 (1202,'Francis Bacon','1986-10-24','23:24:00','GBR','M'),
 (1203,'Charles Boyer','1988-11-21','23:17:00','GBR','M'),
 (1301,'Vladimir Godorov','1988-05-15','23:23:00','RUS','M'),
 (1302,'Maria Yudereva','1988-07-07','20:14:00','RUS','F'),
 (1304,'George Volkov','1991-11-11','16:12:00','RUS','M'),
 (1305,'Vasiliva Gergeva','1990-10-10','15:00:00','RUS','F');
/*!40000 ALTER TABLE `atletas` ENABLE KEYS */;


--
-- Definition of table `categorias`
--

DROP TABLE IF EXISTS `categorias`;
CREATE TABLE `categorias` (
  `cod_categoria` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `denominacion` varchar(45) NOT NULL,
  `edad_inicio` int(10) unsigned NOT NULL,
  `edad_fin` int(10) unsigned NOT NULL,
  PRIMARY KEY (`cod_categoria`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categorias`
--

/*!40000 ALTER TABLE `categorias` DISABLE KEYS */;
INSERT INTO `categorias` (`cod_categoria`,`denominacion`,`edad_inicio`,`edad_fin`) VALUES 
 (1,'Senior',23,99),
 (2,'Promesa',20,22),
 (3,'Junior',18,19);
/*!40000 ALTER TABLE `categorias` ENABLE KEYS */;


--
-- Definition of table `equipos`
--

DROP TABLE IF EXISTS `equipos`;
CREATE TABLE `equipos` (
  `cod_equipo` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `siglas` varchar(45) NOT NULL,
  `nacion` varchar(45) NOT NULL,
  PRIMARY KEY (`cod_equipo`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `equipos`
--

/*!40000 ALTER TABLE `equipos` DISABLE KEYS */;
INSERT INTO `equipos` (`cod_equipo`,`siglas`,`nacion`) VALUES 
 (1,'ESP','España'),
 (2,'FRA','Francia'),
 (3,'GBR','Reino Unido'),
 (4,'RUS','Rusia');
/*!40000 ALTER TABLE `equipos` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
