https://www.icyphoenix.com/viewtopic.php?f=35&t=1615&p=12029#p12029
-----------------------------------
seldon1965
Thu 12 Apr, 2007 13:47

Re: Problem With Dynamic Menu
-----------------------------------
[code linenumbers=false]CREATE TABLE `XXXXXXX_cms_nav_menu` (
  `menu_item_id` mediumint(8) unsigned NOT NULL auto_increment,
  `menu_id` mediumint(8) unsigned NOT NULL default '0',
  `menu_parent_id` mediumint(8) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `cat_parent_id` mediumint(8) unsigned NOT NULL default '0',
  `menu_status` tinyint(1) NOT NULL default '0',
  `menu_order` smallint(5) NOT NULL default '0',
  `menu_icon` varchar(255) default NULL,
  `menu_name_lang` varchar(150) default NULL,
  `menu_name` varchar(150) default NULL,
  `menu_desc` text,
  `menu_link` varchar(255) default NULL,
  `menu_link_external` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_view_group` tinytext NOT NULL,
  PRIMARY KEY  (`menu_item_id`),
  KEY `cat_id` (`cat_id`)
) ;[/code]


replace xxxxxx with your table prefix


