--
-- Table structure for table `menu_group`
--
DROP TABLE IF EXISTS `menu_group`;
CREATE TABLE IF NOT EXISTS `menu_group` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `menu_group`
--
INSERT INTO `menu_group` (`id`, `title`) VALUES
(1, 'Main Menu'),
(2, 'Footer Menu'),
(3, 'Member Menu'),
(4, 'Admin Menu');
-- --------------------------------------------------------
--
-- Table structure for table `menu`
--
DROP TABLE IF EXISTS `menu`;
CREATE TABLE IF NOT EXISTS `menu` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) unsigned NOT NULL DEFAULT 0,
`group_id` int(11) unsigned NOT NULL DEFAULT 1,
`order` int(11) unsigned NOT NULL DEFAULT 0,
`title` varchar(100) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT '',
`icon` varchar(100) NOT NULL DEFAULT '',
`target` enum('none','_blank','_self','_parent','_top') NOT NULL DEFAULT 'none',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `menu`
--
INSERT INTO `menu` (`id`, `parent_id`, `group_id`, `order`, `title`, `url`, `icon`, `target`) VALUES
(1, 0, 1, 1, 'Home', '/', '', 'none'),
(2, 0, 1, 2, 'About', '/about.html', '', 'none'),
(3, 2, 1, 1, 'Company Profile', '/company-profile.html', '', 'none'),
(4, 0, 2, 3, 'Affiliate', '/affiliate.html', '', 'none'),
(5, 0, 2, 2, 'Forum', '/forum', '', 'none'),
(6, 0, 2, 1, 'Make Money', '/make-money.html', '', 'none'),
(7, 0, 1, 5, 'Contact Us', '/contact-us.html', '', 'none'),
(8, 0, 1, 4, 'Blog', '/blog', '', 'none'),
(9, 0, 1, 3, 'Products', '/products', '', 'none'),
(10, 9, 1, 1, 'Handicraft', '/products/handicraft', '', 'none'),
(11, 9, 1, 2, 'Furniture', '/products/furniture', '', 'none'),
(12, 10, 1, 1, 'Tissue Box', '/products/handicraft/tissue', '', 'none'),
(13, 10, 1, 2, 'Frame', '/products/handicraft/frame', '', 'none'),
(14, 11, 1, 1, 'Cabinet', '/products/furniture/cabinet', '', 'none'),
(15, 11, 1, 2, 'Chair', '/products/furniture/chair', '', 'none'),
(16, 11, 1, 3, 'Table', '/products/furniture/table', '', 'none'),
(17, 0, 2, 4, 'Help', '/help', '', 'none'),
(18, 20, 2, 1, 'Support Center', '/support-center.html', '', 'none'),
(19, 20, 2, 1, 'Sitemap', '/sitemap.html', '', 'none'),
(20, 0, 3, 1, 'Author Dashboard', '/author-dashboard', '', 'none'),
(21, 0, 3, 2, 'My Profile', '/member/profile', '', 'none'),
(22, 0, 3, 3, 'Settings', '/member/settings', '', 'none'),
(23, 0, 3, 4, 'Downloads', '/member/downloads', '', 'none'),
(24, 0, 3, 5, 'Bookmarks', '/member/bookmarks', '', 'none'),
(25, 0, 3, 6, 'Logout', '/logout.php', '', 'none'),
(26, 25, 3, 1, 'Profile', '/member/settings/profile', '', 'none'),
(27, 25, 3, 2, 'Change Password', '/member/settings/password', '', 'none'),
(28, 0, 4, 1, 'Menu 1', '#', 'fa fw fa-home', 'none'),
(29, 28, 4, 1, 'Menu 1.1', '#', '', 'none'),
(30, 28, 4, 2, 'Menu 1.2', '#', '', 'none'),
(31, 0, 4, 2, 'Menu 2', '#', '', 'none'),
(32, 31, 4, 1, 'Menu 2.1', '#', '', 'none'),
(33, 31, 4, 1, 'Menu 2.1.1', '#', '', 'none'),
(34, 31, 4, 2, 'Menu 2.1.2', '#', '', 'none'),
(35, 34, 4, 1, 'Menu 2.2', '#', '', 'none'),
(36, 21, 3, 1, 'Popular Files', '/popular', '', 'none'),
(37, 21, 2, 2, 'Top Authors', '/top', '', 'none'),
(38, 21, 2, 3, 'Wordpress', '/wp', '', 'none');