· 8 years ago · Nov 30, 2017, 10:56 AM
1CREATE TABLE IF NOT EXISTS Personas_Vehiculos(
2 dni char(9),
3 cod_vehiculo int,
4 primary key (dni, cod_vehiculo),
5 foreign key (dni) REFERENCES Personas (dni) on delete cascade on update cascade,
6 foreign key (cod_vehiculo) REFERENCES Vehiculos (cod_vehiculo) on delete cascade on update cascade
7)ENGINE=INNODB;