Tag: keys

I am creating a database for a series, but an error is displayed in several tables and I cannot create any more foreign keys and try to vary the tables and give the keys with and without CONSTRAINT different names. I tried to put the boards together to hang out but there is no way. Can you believe that something is wrong with my code?
Thanks in advance

use voltron;
CREATE TABLE IF NOT EXISTS actores (cod_actor INT PRIMARY KEY, nombre VARCHAR(50) NOT NULL, fecha DATE NOT NULL, nacionalidad VARCHAR(20) DEFAULT "Spain");

CREATE TABLE IF NOT EXISTS personajes (cod_per INT PRIMARY KEY, nombre VARCHAR(50) NOT NULL, raza VARCHAR(20) NOT NULL, grado VARCHAR(20) NOT NULL,
codigoactor INT, FOREIGN KEY (codigoactor) REFERENCES actores (cod_actor), codigosuperior INT, FOREIGN KEY (codigosuperior) REFERENCES personajes (cod_per));

CREATE TABLE IF NOT EXISTS planetas (cod_plan INT PRIMARY KEY, galaxia VARCHAR(50), nombre VARCHAR(50) NOT NULL);
CREATE TABLE IF NOT EXISTS capitulos (titulo VARCHAR NOT NULL, fecha DATE NOT NULL, temporada INT, orden INT, PRIMARY KEY(temporada, orden));

CREATE TABLE IF NOT EXISTS peliculas (cod_pel INT PRIMARY KEY, titulo CHAR NOT NULL, director CHAR NOT NULL, fecha DATE);

CREATE TABLE IF NOT EXISTS personajescapitulos (codigopersonaje INT PRIMARY KEY, Temporada INT, Orden INT, FOREIGN KEY (Temporada) 
REFERENCES capitulos (temporada), FOREIGN KEY (Orden) REFERENCES capitulos (orden));

CREATE TABLE IF NOT EXISTS personajespeliculas (cod_personaje INT, cod_pelicula INT, FOREIGN KEY (cod_personaje) REFERENCES personajes (cod_per), FOREIGN KEY 
(cod_pelicula) REFERENCES peliculas (cod_pel));
CREATE TABLE IF NOT EXISTS naves (cod_nave INT PRIMARY KEY, ntripulantes INT, nombre VARCHAR(50) NOT NULL);

CREATE TABLE IF NOT EXISTS visitas (codigonave INT, codigoplaneta INT, tempo INT, ordencap INT, FOREIGN KEY (codigonave) REFERENCES naves (cod_nave), 
FOREIGN KEY (codigoplaneta) REFERENCES planetas (cod_plan), FOREIGN KEY (tempo) REFERENCES personajescapitulos (Temporada), FOREIGN KEY (ordencap) REFERENCES
personajescapitulos (Orden));
CREATE TABLE IF NOT EXISTS lanzaderas (codigoNave INT, numero INT, personas INT, FOREIGN KEY (codigoNave) REFERENCES visitas (codigonave), 
PRIMARY KEY (codigoNave,numero));´´´