Claves

[jegggf]

ahi esta completo:

prueba3
CREATE TABLE `prueba3` (
`objetos` varchar(10) NOT NULL,
`lugares` varchar(10) NOT NULL,
PRIMARY KEY (`objetos`),
KEY `lugares` (`lugares`),
CONSTRAINT `prueba3_ibfk_2` FOREIGN KEY (`lugares`) REFERENCES `prueba2` (`lugares`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `prueba3_ibfk_1` FOREIGN KEY (`objetos`) REFERENCES `prueba1` (`objetos`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8


prueba2
CREATE TABLE `prueba2` (
`lugares` varchar(10) NOT NULL,
`capacidad` int(10) NOT NULL,
PRIMARY KEY (`lugares`),
KEY `capacidad` (`capacidad`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8