kkpWvptr

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : Zoom-DB
5Source Server Version : 50520
6Source Host           : localhost:3306
7Source Database       : zoomdb
8
9Target Server Type    : MYSQL
10Target Server Version : 50520
11File Encoding         : 65001
12
13Date: 2012-02-28 04:00:12
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `navigator_publics`
20-- ----------------------------
21DROP TABLE IF EXISTS `navigator_publics`;
22CREATE TABLE `navigator_publics` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `ordernum` int(11) NOT NULL DEFAULT '1',
25  `bannertype` enum('0','1') NOT NULL COMMENT '0 = big, 1 = normal',
26  `caption` varchar(100) NOT NULL,
27  `image` text NOT NULL,
28  `image_type` enum('internal','external') NOT NULL DEFAULT 'internal',
29  `room_id` int(10) unsigned NOT NULL,
30  `category_id` int(11) NOT NULL DEFAULT '0',
31  `category_parent_id` int(11) NOT NULL DEFAULT '-1',
32  PRIMARY KEY (`id`)
33) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
34
35-- ----------------------------
36-- Records of navigator_publics
37-- ----------------------------
38INSERT INTO `navigator_publics` VALUES ('1', '1', '0', 'zoomHotel Welcome Room', 'navi/cbX61N.png', 'external', '38', '0', '2');
39INSERT INTO `navigator_publics` VALUES ('2', '1', '0', 'Official Event Room', 'navi/NKvqdh.png', 'external', '1401', '0', '2');
40INSERT INTO `navigator_publics` VALUES ('3', '1', '0', 'zoomHotel Official Maze', 'navi/G96gD1.png', 'external', '1533', '0', '2');
41INSERT INTO `navigator_publics` VALUES ('4', '1', '0', 'Official Casino', 'navi/ge0TEB.png', 'external', '1183', '0', '2');
42INSERT INTO `navigator_publics` VALUES ('5', '1', '0', 'zoomHotel Chill Room', 'navi/UgOSZ3.png', 'external', '1141', '0', '2');