/*
Navicat MySQL Data Transfer

Source Server         : 192.168.1.141
Source Server Version : 50149
Source Host           : 192.168.1.141:3306
Source Database       : sign_back

Target Server Type    : MYSQL
Target Server Version : 50149
File Encoding         : 65001

Date: 2012-05-16 18:25:22
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `product_type`
-- ----------------------------
DROP TABLE IF EXISTS `product_type`;
CREATE TABLE `product_type` (
  `cat_id` smallint(5) NOT NULL AUTO_INCREMENT COMMENT '产品类型ID',
  `cat_name` varchar(200) DEFAULT NULL COMMENT '产品类型名称',
  `enabled` tinyint(1) DEFAULT '1' COMMENT '是否启用',
  `attr_group` varchar(255) DEFAULT NULL COMMENT '属性分组',
  `pid` smallint(5) DEFAULT NULL,
  `spec_id` varchar(100) NOT NULL COMMENT '规格id',
  PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of product_type
-- ----------------------------
INSERT INTO `product_type` VALUES ('18', '平板打印机分类模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('7', '大幅面打印机内容模型', '1', null, '16', '15');
INSERT INTO `product_type` VALUES ('6', '激光雕刻机内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('45', '激光切割机', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('32', 'eco inkjet media', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('33', '相纸内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('34', 'Inkjet Film', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('35', 'PP纸', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('36', 'Inkjet Canvas', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('48', '喷绘介质-灯箱布', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('49', '喷绘介质-网格布', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('50', '喷绘介质-车身贴', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('51', '喷绘介质-单透贴', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('52', '喷绘介质-帐篷布', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('68', '冷裱膜内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('72', '墨水-弱溶剂型墨水', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('53', '墨水-水性墨水', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('59', '墨水-溶剂墨水 ', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('46', '数控雕刻机', '1', null, '16', '27');
INSERT INTO `product_type` VALUES ('47', '刻字机', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('24', '冷热裱机内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('69', '液体覆膜机', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('28', '裁纸机', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('27', '卡片切割机', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('29', '打扣机内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('21', '罗兰武腾Mimaki喷绘机配件', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('19', 'HP designjet系列配件', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('22', 'novajet配件机配件', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('20', '赛博喷绘机配件', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('23', '喷绘机打印头', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('30', '超薄LED灯箱', '1', null, '16', '22');
INSERT INTO `product_type` VALUES ('44', '广告灯箱-滚动灯箱', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('66', '镜面魔术灯箱内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('67', '压克力水晶灯箱内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('38', '广告板材-pvc板', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('42', '广告板材-pvc发泡板', '1', null, '16', '17,20,23');
INSERT INTO `product_type` VALUES ('39', '广告板材-PE板', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('40', '广告板材-亚克力板', '1', null, '16', '18,17,20,21,23');
INSERT INTO `product_type` VALUES ('76', '3D光栅板', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('41', '广告材料-pp板材', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('43', '广告板材-abs板', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('56', '便携式展具-L展架', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('31', '易拉宝内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('54', '便携式展具-拉网展架', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('57', '便携式展具-背包展架', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('58', '便携式展具-旗杆', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('61', '展示器材-海报架', '1', null, '16', '22');
INSERT INTO `product_type` VALUES ('62', '展示器材-sign holder', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('63', '展示器材-sign display', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('64', '展示器材-Brochure Rack', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('60', '展示器材-MagazineRack', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('65', '展示器材-促销台', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('25', '热转印机内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('70', '数控切割机内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('71', '激光打标机内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('73', '鲜花指甲艺术打印机', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('74', '喷绘用车身贴内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('75', '热转印纸', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('77', '磁性材料', '1', null, '16', '8');
INSERT INTO `product_type` VALUES ('79', '影楼用冷裱膜内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('78', '影楼用相纸', '1', null, '16', '24,26,32');
INSERT INTO `product_type` VALUES ('80', '国产喷绘机配件', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('81', '数码相框', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('82', '雕刻刀内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('83', '热转印膜', '1', null, '16', '6,7');
INSERT INTO `product_type` VALUES ('84', '数码影楼相框', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('85', '广告钉', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('86', '扣眼内容模型', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('87', '拉网照明灯', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('88', '直喷显色机', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('89', '环保型便携带竹子展具', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('105', 'Display Booth Stand System', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('90', '压克力加工设备', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('91', '雕刻辅助设备', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('92', '热转印用品', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('93', '热转印布', '1', null, '16', '35,36');
INSERT INTO `product_type` VALUES ('97', 'perfect binding machine', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('98', 'hard cover maker', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('99', 'Electric guillotine paper cutt', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('100', 'Book pressing machine', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('101', 'Joint Pressing Machine', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('102', 'Paper Creasing Machine', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('103', 'LED Modules', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('107', 'epson喷绘机配件', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('108', 'Canon配件', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('109', 'Spare Parts Type(配件类型）', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('110', '喷绘机配件', '1', null, '16', '1,2');
INSERT INTO `product_type` VALUES ('111', 'LED Full Color Screen', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('112', 'Large LED Message Board', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('113', 'LED Scrolling Pannel ', '1', null, '16', '3');
INSERT INTO `product_type` VALUES ('114', 'LED Light Source ', '1', null, '16', '39');
INSERT INTO `product_type` VALUES ('115', 'LED Advertising Signs ', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('116', 'Decorated Light', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('118', 'Quick Show Displays', '1', null, '16', '1,5');
INSERT INTO `product_type` VALUES ('120', '热转印墨水', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('121', '热转印膜', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('122', '金属复合板', '1', null, '16', '10,11,12,28,33');
INSERT INTO `product_type` VALUES ('123', '杯转印机', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('124', 'PC板', '1', null, '16', '29,34');
INSERT INTO `product_type` VALUES ('125', 'T-shirt Heat Press Machine', '1', null, '16', '');
INSERT INTO `product_type` VALUES ('126', 'Flexible LED Strip', '1', null, '16', '39');