--
-- Table structure for table `navigation`
--

CREATE TABLE IF NOT EXISTS `navigation` (
  `navigation_id` int(10) unsigned NOT NULL auto_increment COMMENT 'Navigation ID',
  `navigation_parent_id` int(10) unsigned default NULL COMMENT 'Parent ID',
  `acl_privilege_id` smallint(5) unsigned NOT NULL COMMENT 'ACL Privilege ID',
  `navigation_order` tinyint(4) NOT NULL default '0' COMMENT 'Order',
  `navigation_name` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Name',
  PRIMARY KEY  (`navigation_id`),
  KEY `navigation_parent_id` (`navigation_parent_id`),
  KEY `avl_privilege_id` (`acl_privilege_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Navigation' AUTO_INCREMENT=9 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `navigation`
--
ALTER TABLE `navigation`
  ADD CONSTRAINT `navigation_ibfk_1` FOREIGN KEY (`navigation_parent_id`) REFERENCES `navigation` (`navigation_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `navigation_ibfk_2` FOREIGN KEY (`acl_privilege_id`) REFERENCES `acl_privilege` (`acl_privilege_id`) ON DELETE CASCADE ON UPDATE CASCADE;