1 /*
2 Navic at MySQL Data Transfer
3 Order by : happig
4 Source Server : localhost
5 Source Server Version : 50516
6 Source Host : localhost:3306
7 Source Database : test
8
9 Target Server Type : MYSQL
10 Target Server Version : 50516
11 File Encoding : 65001
12
13 Date: 2012-08-25 02:21:44
14 */
15 USE `pagelist`;
16
17 SET FOREIGN_KEY_CHECKS=0;
18 -- ----------------------------
19 -- Table structure for `v_char`
20 -- ----------------------------
21 DROP TABLE IF EXISTS `v_char`;
22 CREATE TABLE `v_char` (
23 `type_id` int(11) NOT NULL DEFAULT '0',
24 `type_name` varchar(255) DEFAULT NULL,
25 `type_parent_id` int(11) DEFAULT NULL,
26 `project` varchar(255) DEFAULT NULL,
27 PRIMARY KEY (`type_id`)
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29
30 -- ----------------------------
31 -- Records of v_char
32 -- ----------------------------
33 INSERT INTO `v_char` VALUES ('1', '工装功能', null, 'gong');
34 INSERT INTO `v_char` VALUES ('2', '工装类型', null, 'gong');
35 INSERT INTO `v_char` VALUES ('3', '家装功能', null, 'jia');
36 INSERT INTO `v_char` VALUES ('4', '家装风格', null, 'jia');
37 INSERT INTO `v_char` VALUES ('5', '家装构件', null, 'jia');
38 INSERT INTO `v_char` VALUES ('6', '家装户型', null, 'jia');
39 INSERT INTO `v_char` VALUES ('10', '办公空间', '2', 'gong');
40 INSERT INTO `v_char` VALUES ('13', '中式', '4', 'jia');
41 INSERT INTO `v_char` VALUES ('14', '欧式', '4', 'jia');
42 INSERT INTO `v_char` VALUES ('16', '医院', '1', 'gong');
43 INSERT INTO `v_char` VALUES ('17', '办公室', '1', 'gong');
44 INSERT INTO `v_char` VALUES ('18', '网吧', '1', 'gong');
45 INSERT INTO `v_char` VALUES ('19', '超市', '1', 'gong');
46 INSERT INTO `v_char` VALUES ('20', '售楼部', '1', 'gong');
47 INSERT INTO `v_char` VALUES ('21', '餐厅', '1', 'gong');
48 INSERT INTO `v_char` VALUES ('22', '酒店', '1', 'gong');