jFjAbU7V

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : Brick Hotel Official
5Source Server Version : 50523
6Source Host           : localhost:3306
7Source Database       : bricked
8
9Target Server Type    : MYSQL
10Target Server Version : 50523
11File Encoding         : 65001
12
13Date: 2012-07-02 07:44:45
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `navigator_flatcats`
20-- ----------------------------
21DROP TABLE IF EXISTS `navigator_flatcats`;
22CREATE TABLE `navigator_flatcats` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `caption` varchar(100) NOT NULL,
25  `enabled` enum('0','1') NOT NULL DEFAULT '1',
26  `min_rank` int(11) NOT NULL DEFAULT '1',
27  PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
29
30-- ----------------------------
31-- Records of navigator_flatcats
32-- ----------------------------
33INSERT INTO `navigator_flatcats` VALUES ('1', 'Fourth of Staff', '1', '4');
34INSERT INTO `navigator_flatcats` VALUES ('2', 'Competitions', '0', '1');
35INSERT INTO `navigator_flatcats` VALUES ('3', 'Work and Jobs', '0', '1');
36INSERT INTO `navigator_flatcats` VALUES ('4', 'Themed Rooms', '1', '1');
37INSERT INTO `navigator_flatcats` VALUES ('5', 'Restaurant, Bar, & Night Club', '1', '1');
38INSERT INTO `navigator_flatcats` VALUES ('6', 'Habbo Club', '1', '1');
39INSERT INTO `navigator_flatcats` VALUES ('7', 'Chat, and discussion rooms', '1', '1');
40INSERT INTO `navigator_flatcats` VALUES ('8', 'Maze Rooms and Theme Parks', '1', '1');
41INSERT INTO `navigator_flatcats` VALUES ('9', 'Exchanges', '1', '1');
42INSERT INTO `navigator_flatcats` VALUES ('10', 'Rooms, Games, And Races', '1', '1');
43INSERT INTO `navigator_flatcats` VALUES ('11', 'Beauty Salons', '1', '1');
44INSERT INTO `navigator_flatcats` VALUES ('12', 'Help Centers and Services', '1', '1');
45INSERT INTO `navigator_flatcats` VALUES ('13', 'Classes, nursery, and adoption', '1', '1');
46INSERT INTO `navigator_flatcats` VALUES ('14', 'Other', '1', '1');
47INSERT INTO `navigator_flatcats` VALUES ('15', ' No Category', '1', '1');