CREATE TABLE TreeMenuDataType
(
    nodeId BIGINT NOT NULL,
    sortOrder INT UNSIGNED DEFAULT NULL,
    parentId BIGINT NOT NULL,
    myId BIGINT NOT NULL,
    type VARCHAR(50) NOT NULL,
    action VARCHAR(255) DEFAULT NULL,
   node BIGINT DEFAULT NULL,
    isPopup TINYINT DEFAULT 0,
    isForeign TINYINT DEFAULT 0,
    IsLonerDeleted TINYINT DEFAULT 0,
    PRIMARY KEY ( nodeId,myId ),
    KEY sysName ( myId )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Flat storage for tree-like data used in web menus";
