DB

CREATE TABLE `capitulos` (
  `id_capitulo` int(11) NOT NULL AUTO_INCREMENT,
  `cod_serie` int(11) DEFAULT NULL,
  `cod_temporada` int(11) DEFAULT NULL,
  `nombre` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id_capitulo`),
  KEY `cod_serie` (`cod_serie`),
  KEY `cod_temporada` (`cod_temporada`),
  CONSTRAINT `capitulos_ibfk_1` FOREIGN KEY (`cod_serie`) REFERENCES `capitulos` (`id_capitulo`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `capitulos_ibfk_2` FOREIGN KEY (`cod_temporada`) REFERENCES `temporadas` (`id_temporada`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;



CREATE TABLE `series` (
  `id_serie` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(30) DEFAULT NULL,
  `enlace` varchar(30) DEFAULT NULL,
  `premium` binary(1) DEFAULT '0',
  `temporada` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_serie`),
  KEY `temporada` (`temporada`),
  CONSTRAINT `series_ibfk_1` FOREIGN KEY (`temporada`) REFERENCES `temporadas` (`id_temporada`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;



CREATE TABLE `temporadas` (
  `id_temporada` int(11) NOT NULL AUTO_INCREMENT,
  `n_temporada` int(11) DEFAULT NULL,
  `serie` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id_temporada`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;