CREATE TABLE IF NOT EXISTS `xf_br_extra_navigation_menu` (
`extra_id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`icon` int(10) unsigned NOT NULL DEFAULT '0',
`link` varchar(120) NOT NULL,
`follow` tinyint(3) unsigned NOT NULL DEFAULT '0',
`template_id` int(10) unsigned DEFAULT '0',
`location` tinyint(3) unsigned NOT NULL DEFAULT '0',
`target` varchar(20) NOT NULL,
`status` tinyint(3) unsigned NOT NULL DEFAULT '1',
`order` int(10) unsigned NOT NULL DEFAULT '0',
`navigation_tab` tinyint(3) unsigned NOT NULL DEFAULT '0',
`visitor_tab` tinyint(3) unsigned NOT NULL DEFAULT '0',
`display_with_group` text,
`list_template` text,
`display_footer` tinyint(3) unsigned NOT NULL DEFAULT '0',
`key_navigation_tab` varchar(50) DEFAULT NULL,
PRIMARY KEY (`extra_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;