El ENGINE deber ser InnoDB
De esta manera
Código sql:
Ver originalCREATE TABLE contentlanguage (
id_contentlanguage INT(11) NOT NULL,
id_content INT(11) NOT NULL,
title VARCHAR(50) NOT NULL,
LANGUAGE VARCHAR(10) NOT NULL,
content0 text,
content1 text,
CONSTRAINT PRIMARY KEY (id_contentlanguage),
CONSTRAINT FOREIGN KEY(id_content)REFERENCES content(id_content) ON DELETE CASCADE
) ENGINE=InnoDB ;
La table hijo tambíen debe ser innoDb
Saludos!