Create table with Fk

0

I'm having trouble creating a table with several Foreign keys

The tables are the following

CREATE TABLE tbl_Autor(

nAutorID INT AUTO_INCREMENT PRIMARY KEY NOT NULL UNIQUE,
cNombre VARCHAR(20),
cApellidos VARCHAR(50)
);

CREATE TABLE tbl_Libro(

nLibroID INT AUTO_INCREMENT PRIMARY KEY NOT NULL UNIQUE,
cTitulo VARCHAR(20),
nAnyoPublicacion DATE,
nEditorial INT,
CONSTRAINT fk_Editorial FOREIGN KEY(nEditorial) REFERENCES tbl_Editorial(nEditorialID)
ON DELETE SET NULL

);

and this is the one that gives me problems

CREATE TABLE tbl_LibroAutor(

nLibroID INT,
nAutorID INT,
CONSTRAINT pk_LibroAutor PRIMARY KEY(nLibroID, nAutorID),
CONSTRAINT fk_Libro FOREIGN KEY(nLibroID) REFERENCES tbl_Libro(nLibroID)
ON DELETE SET NULL,
CONSTRAINT fk_Autor FOREIGN KEY(nAutorID) REFERENCES tbl_Autor(nAutorID)
ON DELETE SET NULL
);
    
asked by D3n3cry 27.01.2018 в 21:08
source

0 answers