7h1qF8Ly

1-- ----------------------------
2-- Table structure for navigator_categories
3-- ----------------------------
4DROP TABLE IF EXISTS `navigator_categories`;
5CREATE TABLE `navigator_categories` (
6  `id` int(11) NOT NULL,
7  `category` enum('events_view','official_view','hotel_view','myworld_view','roomads_view','query') NOT NULL DEFAULT 'hotel_view',
8  `category_identifier` varchar(35) NOT NULL DEFAULT '',
9  `public_name` varchar(35) NOT NULL DEFAULT '',
10  `view_mode` enum('REGULAR','THUMBNAIL') NOT NULL DEFAULT 'REGULAR',
11  `required_rank` int(11) NOT NULL DEFAULT '1',
12  `category_type` varchar(25) NOT NULL DEFAULT 'category',
13  `search_allowance` enum('NOTHING','SHOW_MORE') NOT NULL DEFAULT 'SHOW_MORE',
14  `enabled` enum('0','1') NOT NULL DEFAULT '1',
15  `order_id` int(11) NOT NULL DEFAULT '0',
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1;
18
19-- ----------------------------
20-- Records of navigator_categories
21-- ----------------------------
22INSERT INTO `navigator_categories` VALUES ('0', 'query', 'query', '', 'REGULAR', '1', 'query', 'NOTHING', '1', '0');
23INSERT INTO `navigator_categories` VALUES ('1', 'official_view', 'official-root', 'Public rooms', 'THUMBNAIL', '1', 'featured', 'NOTHING', '1', '0');
24INSERT INTO `navigator_categories` VALUES ('2', 'hotel_view', 'popular', '', 'REGULAR', '1', 'popular', 'SHOW_MORE', '0', '1');
25INSERT INTO `navigator_categories` VALUES ('4', 'myworld_view', 'my', '', 'REGULAR', '1', 'my_rooms', 'NOTHING', '1', '0');
26INSERT INTO `navigator_categories` VALUES ('5', 'myworld_view', 'favorites', '', 'REGULAR', '1', 'my_favorites', 'SHOW_MORE', '1', '0');
27INSERT INTO `navigator_categories` VALUES ('6', 'myworld_view', 'my_groups', '', 'REGULAR', '1', 'my_groups', 'SHOW_MORE', '1', '0');
28INSERT INTO `navigator_categories` VALUES ('7', 'myworld_view', 'history', '', 'REGULAR', '1', 'my_history', 'SHOW_MORE', '0', '0');
29INSERT INTO `navigator_categories` VALUES ('9', 'myworld_view', 'history_freq', '', 'REGULAR', '1', 'my_history_freq', 'SHOW_MORE', '0', '0');
30INSERT INTO `navigator_categories` VALUES ('28', 'hotel_view', 'staff_rooms', 'Staff kamers', 'REGULAR', '1', 'category', 'SHOW_MORE', '0', '0');
31INSERT INTO `navigator_categories` VALUES ('35', 'events_view', 'evenementen', 'Hotel Evenementen', 'THUMBNAIL', '1', 'category', 'NOTHING', '0', '0');
32INSERT INTO `navigator_categories` VALUES ('36', 'hotel_view', 'all_other_rooms', 'Hotel Gastenkamers', 'REGULAR', '1', 'category', 'NOTHING', '1', '0');
33INSERT INTO `navigator_categories` VALUES ('37', 'official_view', 'official-games', 'Bobba games', 'THUMBNAIL', '6', 'category', 'SHOW_MORE', '1', '0');