· 8 years ago · Feb 18, 2018, 05:14 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : localhost_3306
5Source Server Version : 50510
6Source Host : localhost:3306
7Source Database : phoenix3
8
9Target Server Type : MYSQL
10Target Server Version : 50510
11File Encoding : 65001
12
13Date: 2011-10-24 00:59:30
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=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
29
30-- ----------------------------
31-- Records of navigator_flatcats
32-- ----------------------------
33INSERT INTO `navigator_flatcats` VALUES ('1', 'Groups', '1', '1');
34INSERT INTO `navigator_flatcats` VALUES ('2', 'Friends', '1', '1');
35INSERT INTO `navigator_flatcats` VALUES ('3', 'Date', '1', '1');
36INSERT INTO `navigator_flatcats` VALUES ('4', 'Party', '1', '1');
37INSERT INTO `navigator_flatcats` VALUES ('5', 'Food & Drinks', '1', '1');
38INSERT INTO `navigator_flatcats` VALUES ('6', 'Trade', '1', '1');
39INSERT INTO `navigator_flatcats` VALUES ('7', 'Games & Mazes', '1', '1');
40INSERT INTO `navigator_flatcats` VALUES ('8', 'RPG', '1', '1');
41INSERT INTO `navigator_flatcats` VALUES ('9', 'Help', '1', '1');
42INSERT INTO `navigator_flatcats` VALUES ('10', 'Shops & Services', '1', '1');
43INSERT INTO `navigator_flatcats` VALUES ('11', 'Staff Catagory', '1', '5');