CREATE TABLE IF NOT EXISTS `pds_core_menu_items` (
|
`menu_id` varchar(32) NOT NULL,
|
`parent_menu_id` int(32) unsigned DEFAULT NULL,
|
`menu_name` varchar(255) DEFAULT NULL,
|
`menu_link` varchar(255) DEFAULT NULL,
|
`plugin` varchar(255) DEFAULT NULL,
|
`menu_type` int(1) DEFAULT NULL,
|
`extend` varchar(255) DEFAULT NULL,
|
`new_window` int(1) DEFAULT NULL,
|
`rank` int(100) DEFAULT NULL,
|
`hide` int(1) DEFAULT NULL,
|
`template_id` int(32) unsigned DEFAULT NULL,
|
`alias` varchar(255) DEFAULT NULL,
|
`layout` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`menu_id`),
|
KEY `index` (`parent_menu_id`,`menu_link`,`plugin`,`alias`)
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|