Código:
Aqui va toda la tablaScript line: 22 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY ( id_cliente ) REFERENCES clientes( id ) FOREIGN KEY ( id_pelicula ' at line 11
Código:
CREATE TABLE actores( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT , nombre VARCHAR( 25 ) , fecha_nacimiento DATE , biografia LONGTEXT , PRIMARY KEY ( id ) )ENGINE=InnoDB; CREATE TABLE directores( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT , director VARCHAR( 25 ) , biografia LONGTEXT , PRIMARY KEY ( id ) )ENGINE=InnoDB; CREATE TABLE generos( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT , genero VARCHAR( 25 ) , PRIMARY KEY ( id ) )ENGINE=InnoDB; CREATE TABLE pedidos( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT , id_pelicula INTEGER , titulo VARCHAR( 20 ) , editorial VARCHAR( 50 ) , id_cliente INTEGER , fecha_pedido DATE , fecha_devolucion DATE , precio SMALLINT , PRIMARY KEY ( id ) FOREIGN KEY ( id_cliente ) REFERENCES clientes( id ) FOREIGN KEY ( id_pelicula ) REFERENCES peliculas( id ) FOREIGN KEY ( precio ) REFERENCES peliculas( precio ) )ENGINE=InnoDB; CREATE TABLE clientes( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT , nombre VARCHAR( 25 ) , apellidos VARCHAR( 45 ) , direccion VARCHAR( 45 ) , dni VARCHAR( 9 ) , pedido INTEGER , PRIMARY KEY ( id ) FOREIGN KEY (pedido) REFERENCES pedidos(id) )ENGINE=InnoDB; CREATE TABLE peliculas( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT , titulo VARCHAR( 25 ) , genero INTEGER , precio SMALLINT , actor VARCHAR( 25 ) , argumento LONGTEXT , director INTEGER , productora VARCHAR( 25 ), PRIMARY KEY ( id ) FOREIGN KEY ( genero ) REFERENCES generos( id ) FOREIGN KEY ( actor ) REFERENCES actores( id ) FOREIGN KEY ( director ) REFERENCES directores( id ) ON DELETE CASCADE ON UPDATE CASCADE )ENGINE=InnoDB;