CREATE SCHEMA `llanerosdb` DEFAULT CHARACTER SET utf8 ;
      
      
    CREATE TABLE `llanerosdb`.`temporada` (
  `idTemporada` INT NOT NULL AUTO_INCREMENT,
  `nombreTemporada` VARCHAR(250) NOT NULL,
  `temporadaActiva` INT NOT NULL,
  PRIMARY KEY (`idTemporada`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8;
    
   
   
   
   
   
   CREATE TABLE `llanerosdb`.`jugador` (
  `idJugador` INT NOT NULL AUTO_INCREMENT,
  `idTemporada` INT NOT NULL,
  `fotografia` LONGBLOB NULL,
  `nombre` VARCHAR(150) NOT NULL,
  `apellidoPaterno` VARCHAR(150) NOT NULL,
  `apellidoMaterno` VARCHAR(150) NULL,
  `numVecesBat` INT NULL,
  `numHit` INT NULL,
  `fechaUltimoJuego` DATE NULL,
  `porcentaje` DOUBLE NULL,
  PRIMARY KEY (`idJugador`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8;
   
   
   
   CREATE TABLE `llanerosdb`.`usuario` (
  `idUsuario` INT NOT NULL AUTO_INCREMENT,
  `email` VARCHAR(250) NOT NULL,
  `password` VARCHAR(15) NOT NULL,
  PRIMARY KEY (`idUsuario`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8;
   
   
   insert into usuario values(null,'kapo1978@hotmail.com','adminscore');