/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : vison

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 06/08/2018 15:32:47
*/


-- ----------------------------
-- Table structure for contactus
-- ----------------------------
CREATE TABLE `contactus`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `message` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '留言',
  `createTime` int(11) NULL DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '联系我们' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of contactus
-- ----------------------------
INSERT INTO `contactus` VALUES (1, '张三', 'zhangsan.@qq0com', '建议测试而已', '测试而已，张三测试而而已。李四一个建议，王二说的不错，我就想测试测试而已，测试而已，张三测试而而已。李四一个建议，王二说的不错，我就想测试测试而已，测试而已，张三测试而而已。李四一个建议，王二说的不错，我就想测试测试而已，测试而已，张三测试而而已。李四一个建议，王二说的不错，我就想测试测试而已，测试而已，张三测试而而已。李四一个建议，王二说的不错，我就想测试测试而已，测试而已，张三测试而而已。李四一个建议，王二说的不错，我就想测试测试而已', 1533452581);
INSERT INTO `contactus` VALUES (2, '测试', 'ceshi@163.com', '测试主题', '测试留言', 1533526506);
INSERT INTO `contactus` VALUES (3, '测试', 'ceshi@163.com', '测试主题', '测试留言', 1533527051);

-- ----------------------------
-- Table structure for product
-- ----------------------------
CREATE TABLE `product`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品名称',
  `homeImg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品首页图片',
  `listImg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品图',
  `details` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详情',
  `createTime` int(11) NOT NULL COMMENT '创建时间',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态0正常1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES (9, '微波热疗系统', '20180806\\9ee322fb4038db6fc146d1b6cf622102.png', '20180806\\a2a3020756219df464691efab1ca7dea.png', '&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533522982545593.png&quot; title=&quot;201808061533522982545593.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533522982296997.png&quot; title=&quot;201808061533522982296997.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;', 1533522991, 0);
INSERT INTO `product` VALUES (10, '微波消融治疗仪', '20180806\\b9b3711e84e01514c435c537436df9dd.png', '20180806\\8fc6508cb94d9e5c59a86ae2ec2f12f7.png', '&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523052931762.png&quot; title=&quot;201808061533523052931762.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523052960418.png&quot; title=&quot;201808061533523052960418.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523052566558.png&quot; title=&quot;201808061533523052566558.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523052403839.png&quot; title=&quot;201808061533523052403839.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523052680023.png&quot; title=&quot;201808061533523052680023.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523052531951.png&quot; title=&quot;201808061533523052531951.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;', 1533523056, 0);
INSERT INTO `product` VALUES (11, '微波治疗仪', '20180806\\aef4f2c0af22f2b6dacda90881c26baf.png', '20180806\\cbd2922790df7da9e64e209f75456374.png', '&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523117522979.png&quot; title=&quot;201808061533523117522979.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523117379364.png&quot; title=&quot;201808061533523117379364.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;img src=&quot;http://localhost/data/images/20180806/201808061533523117417175.png&quot; title=&quot;201808061533523117417175.png&quot;/&gt;&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;', 1533523126, 0);

