DROP TABLE IF EXISTS `navigator_publics`;CREATE TABLE `navigator_publics` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ordernum` int(11) NOT NULL DEFAULT '1',
`bannertype` enum('0','1') NOT NULL COMMENT '0 = big, 1 = normal',
`caption` varchar(100) NOT NULL,
`description` varchar(100) NOT NULL,
`image` text NOT NULL,
`image_type` enum('internal','external') NOT NULL DEFAULT 'internal',
`room_id` int(10) unsigned NOT NULL,
`category_id` int(11) NOT NULL DEFAULT '-1',
`category_parent_id` int(11) NOT NULL DEFAULT '-1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`recommended` enum('0','1') NOT NULL DEFAULT '0',
`typeofdata` int(255) NOT NULL DEFAULT '1',
`tag` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of navigator_publics
-- ----------------------------
INSERT INTO `navigator_publics` VALUES ('1', '1', '1', 'Reception Lounge', 'Håll en trevlig pratstund? Eller kanske en trevlig pratstund med Frank!', 'officialrooms_defaults/hh_room_nlobby.png', 'internal', '1', '-1', '-1', '1', '1', '2', '0');