CREATE TABLE TreeMenuDataType_lang
(
    nodeId BIGINT NOT NULL,
    myId BIGINT NOT NULL,
    lang_id CHAR(3) NOT NULL,
    title VARCHAR(250) DEFAULT NULL,
    PRIMARY KEY ( nodeId,myId,lang_id ),
    KEY nodeId ( nodeId,lang_id,myId )
    /* Adding a foreign key here breaks translations as translations are wiped when wiping TreeMenuDataType */


    /* FOREIGN KEY ( nodeId ) REFERENCES TreeMenuDataType ( nodeId) ON DELETE CASCADE ON UPDATE CASCADE */

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Language specific data for tree-like data";
