/*
 Navicat Premium Data Transfer

 Source Server         : mo_115.29.177.44
 Source Server Type    : MySQL
 Source Server Version : 100302
 Source Host           : 115.29.177.44:6330
 Source Schema         : test1

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

 Date: 03/01/2021 16:47:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_category
-- ----------------------------
DROP TABLE IF EXISTS `app_category`;
CREATE TABLE `app_category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父部门id',
  `parent_ids` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '父级ids',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `tips` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提示',
  `version` int(11) NULL DEFAULT NULL COMMENT '版本（乐观锁保留字段）',
  `order_num` int(11) NULL DEFAULT NULL COMMENT '排序',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '蔬菜分类表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_category
-- ----------------------------
INSERT INTO `app_category` VALUES (47, 0, '[0],', '种类', '', NULL, NULL, NULL, NULL, NULL, NULL, '种类', 0);
INSERT INTO `app_category` VALUES (48, 47, '[0],[47],', '十字花科', '', NULL, NULL, NULL, NULL, NULL, NULL, '十字花科', 0);
INSERT INTO `app_category` VALUES (49, 48, '[0],[47],[48],', '白菜', '', NULL, NULL, NULL, NULL, NULL, NULL, '白菜', 0);
INSERT INTO `app_category` VALUES (50, 49, '[0],[47],[48],[49],', '结球白菜', '', NULL, NULL, NULL, NULL, NULL, NULL, '结球白菜', 0);
INSERT INTO `app_category` VALUES (51, 49, '[0],[47],[48],[49],', '黄白菜', '', NULL, NULL, NULL, NULL, NULL, NULL, '黄白菜', 0);
INSERT INTO `app_category` VALUES (52, 49, '[0],[47],[48],[49],', '高山娃娃菜', '', NULL, NULL, NULL, NULL, NULL, NULL, '高山娃娃菜', 0);
INSERT INTO `app_category` VALUES (53, 49, '[0],[47],[48],[49],', '小白菜', '', NULL, NULL, NULL, NULL, NULL, NULL, '小白菜', 0);

-- ----------------------------
-- Table structure for app_env_report
-- ----------------------------
DROP TABLE IF EXISTS `app_env_report`;
CREATE TABLE `app_env_report`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `type` int(10) NULL DEFAULT NULL COMMENT '报告文件类型',
  `version` int(11) NULL DEFAULT NULL COMMENT '版本（乐观锁保留字段）',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '上传者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '上传日期',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 62 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '环境报表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_env_report
-- ----------------------------
INSERT INTO `app_env_report` VALUES (60, '测试.xls', 1, NULL, NULL, NULL, NULL, NULL, '', 0);
INSERT INTO `app_env_report` VALUES (61, 'JAVA解惑.pdf', 3, NULL, NULL, NULL, NULL, NULL, 'pdf 测试', 0);

-- ----------------------------
-- Table structure for app_production_qr
-- ----------------------------
DROP TABLE IF EXISTS `app_production_qr`;
CREATE TABLE `app_production_qr`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `version` int(11) NULL DEFAULT NULL COMMENT '版本',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 65 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品二维码数据表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_production_qr
-- ----------------------------
INSERT INTO `app_production_qr` VALUES (54, '西瓜', NULL, NULL, NULL, NULL, NULL, '德宏大西瓜', 0);
INSERT INTO `app_production_qr` VALUES (55, '辣椒', NULL, NULL, NULL, NULL, NULL, '辣椒', 0);
INSERT INTO `app_production_qr` VALUES (56, '玉米', NULL, NULL, NULL, NULL, NULL, '玉米', 0);
INSERT INTO `app_production_qr` VALUES (57, '土豆', NULL, NULL, NULL, NULL, NULL, '土豆', 0);
INSERT INTO `app_production_qr` VALUES (64, '黄瓜', 1, 57, '2019-01-05 07:07:04', NULL, NULL, '黄瓜', 0);

-- ----------------------------
-- Table structure for app_time_line
-- ----------------------------
DROP TABLE IF EXISTS `app_time_line`;
CREATE TABLE `app_time_line`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `order_num` int(11) NULL DEFAULT NULL COMMENT '排序',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  `year` int(4) NULL DEFAULT NULL COMMENT '年份',
  `month_day` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '月日',
  `is_show` int(1) NULL DEFAULT 0 COMMENT '显示（1 显示，2 影藏）',
  `content_txt` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
  `happen_time` date NULL DEFAULT NULL COMMENT '发生时间',
  `cover_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '所属人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 68 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '时间线表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_time_line
-- ----------------------------
INSERT INTO `app_time_line` VALUES (56, '123', 123, 1, '2019-03-08 18:23:26', 1, '2019-03-09 00:35:25', '123', 0, NULL, '132', 1, '231玩儿翁无若', '2019-03-09', '/static/img/送别.jpg', 1);
INSERT INTO `app_time_line` VALUES (57, 'tt', 12, 1, '2019-03-08 18:27:51', 1, '2019-03-09 00:35:37', '121', 0, NULL, '121', 1, 'wererer', '2019-03-21', '/static/img/送别.jpg', 1);
INSERT INTO `app_time_line` VALUES (58, '12', 1, 1, '2019-03-08 23:28:29', 1, '2019-03-08 23:47:03', '12', 0, NULL, '12', 1, 'ewwewe', '2018-01-01', '/static/img/送别.jpg', 1);
INSERT INTO `app_time_line` VALUES (60, '吉他学习', 1, 1, '2019-03-10 23:02:07', 1, '2019-03-10 23:24:14', '吉他学习-《程序员之歌》', 0, 2019, '03/10', 1, '送别<img src=\"/file/ueditor/jsp/upload/image/20190310/1552231444996004411.jpg\" alt=\"送别.jpg\" />', '2019-03-10', '/static/img/FLAMING MOUNTAIN.JPG', 1);
INSERT INTO `app_time_line` VALUES (61, '吉他学习', 1, 1, '2019-03-10 23:02:07', 1, '2019-03-10 23:24:14', '吉他学习-《程序员之歌》', 0, 2019, '03/10', 1, '送别<img src=\"/file/ueditor/jsp/upload/image/20190310/1552231444996004411.jpg\" alt=\"送别.jpg\" />', '2019-03-10', '/static/img/FLAMING MOUNTAIN.JPG', 1);
INSERT INTO `app_time_line` VALUES (62, '吉他学习', 1, 1, '2019-03-10 23:02:07', 1, '2019-03-10 23:24:14', '吉他学习-《程序员之歌》', 0, 2019, '03/10', 1, '送别<img src=\"/file/ueditor/jsp/upload/image/20190310/1552231444996004411.jpg\" alt=\"送别.jpg\" />', '2019-03-10', '/static/img/FLAMING MOUNTAIN.JPG', 1);
INSERT INTO `app_time_line` VALUES (63, '吉他学习', 1, 1, '2019-03-10 23:02:07', 1, '2019-03-10 23:24:14', '吉他学习-《程序员之歌》', 0, 2019, '03/10', 1, '送别<img src=\"/file/ueditor/jsp/upload/image/20190310/1552231444996004411.jpg\" alt=\"送别.jpg\" />', '2019-03-10', '/static/img/FLAMING MOUNTAIN.JPG', 1);
INSERT INTO `app_time_line` VALUES (64, '吉他学习', 1, 1, '2019-03-10 23:02:07', 1, '2019-03-10 23:24:14', '吉他学习-《程序员之歌》', 0, 2019, '03/10', 1, '送别<img src=\"/file/ueditor/jsp/upload/image/20190310/1552231444996004411.jpg\" alt=\"送别.jpg\" />', '2019-03-10', '/static/img/FLAMING MOUNTAIN.JPG', 1);
INSERT INTO `app_time_line` VALUES (65, '吉他学习', 1, 1, '2019-03-10 23:02:07', 1, '2019-03-10 23:24:14', '吉他学习-《程序员之歌》', 0, 2019, '03/10', 1, '送别<img src=\"/file/ueditor/jsp/upload/image/20190310/1552231444996004411.jpg\" alt=\"送别.jpg\" />', '2019-03-10', '/static/img/FLAMING MOUNTAIN.JPG', 1);
INSERT INTO `app_time_line` VALUES (66, '吉他学习', 1, 1, '2019-03-10 23:02:07', 1, '2019-03-10 23:24:14', '吉他学习-《程序员之歌》', 0, 2019, '03/10', 1, '送别<img src=\"/file/ueditor/jsp/upload/image/20190310/1552231444996004411.jpg\" alt=\"送别.jpg\" />', '2019-03-10', '/static/img/FLAMING MOUNTAIN.JPG', 1);
INSERT INTO `app_time_line` VALUES (67, '吉他学习', 1, 1, '2019-03-10 23:02:07', 1, '2019-03-10 23:24:14', '吉他学习-《程序员之歌》', 0, 2019, '03/10', 1, '送别<img src=\"/file/ueditor/jsp/upload/image/20190310/1552231444996004411.jpg\" alt=\"送别.jpg\" />', '2019-03-10', '/static/img/FLAMING MOUNTAIN.JPG', 1);

-- ----------------------------
-- Table structure for app_wx_house
-- ----------------------------
DROP TABLE IF EXISTS `app_wx_house`;
CREATE TABLE `app_wx_house`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房屋名称',
  `type` int(2) NULL DEFAULT NULL COMMENT '房屋类型（house_type）',
  `type_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房屋类型',
  `orientation_type` int(2) NULL DEFAULT NULL COMMENT '朝向（house_orientation_type）',
  `orientation_type_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '朝向',
  `decoration_type` int(2) NULL DEFAULT NULL COMMENT '装修程度（house_decoration_type）',
  `decoration_type_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '装修程度',
  `status` int(2) NULL DEFAULT NULL COMMENT '状态（house_status）',
  `status_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `hall` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '厅室',
  `shi` int(2) NULL DEFAULT NULL COMMENT '室',
  `ting` int(2) NULL DEFAULT NULL COMMENT '厨',
  `chu` int(2) NULL DEFAULT NULL COMMENT '厅',
  `wei` int(2) NULL DEFAULT NULL COMMENT '卫',
  `area` decimal(10, 2) NULL DEFAULT NULL COMMENT '面积',
  `total_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '总价',
  `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '单价',
  `house_building` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '建房',
  `years` int(2) NULL DEFAULT NULL COMMENT '年限',
  `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `owner` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房主',
  `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `lat_lng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址经纬度',
  `information` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '基本信息',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  `dept_id` bigint(20) NULL DEFAULT 3 COMMENT '机构ID',
  `dept_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '房屋记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_wx_house
-- ----------------------------
INSERT INTO `app_wx_house` VALUES (60, '杏花小区四室', 1, '住宅(90m²以下)', 1, '东南', 1, '中等装修', 1, '未售', '3室1厅1厨2卫', NULL, NULL, NULL, NULL, 130.00, 68.60, 6000.00, '无', 5, '15187596692', '无', '云南省保山市隆阳区辛街乡', NULL, '云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡', 1, '2020-03-02 23:45:54', 1, '2020-03-02 23:45:54', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (61, '杏花小区四室', 1, '住宅(90m²以下)', 1, '东南', 1, '中等装修', 1, '未售', '3室1厅1厨2卫', NULL, NULL, NULL, NULL, 130.00, 68.60, 6000.00, '无', 5, '15187596692', '无', '云南省保山市隆阳区辛街乡', NULL, '云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡', 1, '2020-03-02 23:45:56', 1, '2020-03-02 23:45:56', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (62, '杏花小区四室', 1, '住宅(90m²以下)', 1, '东南', 1, '中等装修', 1, '未售', '3室1厅1厨2卫', NULL, NULL, NULL, NULL, 130.00, 68.60, 6000.00, '无', 5, '15187596692', '无', '云南省保山市隆阳区辛街乡', NULL, '云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡', 1, '2020-03-02 23:52:39', 1, '2020-03-02 23:52:39', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (63, '杏花小区四室', 1, '住宅(90m²以下)', 1, '东南', 1, '中等装修', 1, '未售', '3室1厅1厨2卫', NULL, NULL, NULL, NULL, 130.00, 68.60, 6000.00, '无', 5, '15187596692', '无', '云南省保山市隆阳区辛街乡', NULL, '云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡', 1, '2020-03-02 23:54:08', 1, '2020-03-02 23:54:08', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (64, '杏花小区四室', 1, '住宅(90m²以下)', 1, '东南', 1, '中等装修', 1, '未售', '3室1厅1厨2卫', NULL, NULL, NULL, NULL, 130.00, 68.60, 6000.00, '无', 5, '15187596692', '无', '云南省保山市隆阳区辛街乡', NULL, '云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡', 1, '2020-03-02 23:56:06', 1, '2020-03-02 23:56:06', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (65, '杏花小区四室', 1, '住宅(90m²以下)', 1, '东南', 1, '中等装修', 1, '未售', '3室1厅1厨2卫', NULL, NULL, NULL, NULL, 130.00, 68.60, 6000.00, '无', 5, '15187596692', '无', '云南省保山市隆阳区辛街乡', NULL, '云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡', 1, '2020-03-02 23:56:31', 1, '2020-03-02 23:56:31', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (66, '杏花小区四室', 1, '住宅(90m²以下)', 1, '东南', 1, '中等装修', 1, '未售', '3室1厅1厨2卫', NULL, NULL, NULL, NULL, 130.00, 68.60, 6000.00, '无', 5, '15187596692', '无', '云南省保山市隆阳区辛街乡', NULL, '云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡', 1, '2020-03-02 23:56:49', 1, '2020-03-02 23:56:49', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (67, '杏花小区四室', 1, '住宅(90m²以下)', 1, '东南', 1, '中等装修', 1, '未售', '3室1厅1厨2卫', NULL, NULL, NULL, NULL, 130.00, 68.60, 6000.00, '无', 5, '15187596692', '无', '云南省保山市隆阳区辛街乡', NULL, '云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡云南省保山市隆阳区辛街乡', 1, '2020-03-02 23:59:31', 1, '2020-03-02 23:59:31', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (68, '新增一个', 9, '其他', 9, '西北', 3, '中等装修', 2, '未售', '6室6厅6厨6卫', 6, 6, 6, 6, 123.55, 121.12, 6500.00, '5', 5, '18270914314', '小伟', '云南保山腾冲湿地', NULL, '床大房大', 324, '2020-03-03 21:09:14', 324, '2020-03-03 21:09:14', NULL, 0, 3, NULL);
INSERT INTO `app_wx_house` VALUES (69, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, 0, 0, 0, 0.00, 0.00, 0.00, NULL, 0, NULL, NULL, '官渡', NULL, NULL, 58, '2020-03-03 22:42:28', 58, '2020-03-03 22:42:28', NULL, 0, 530111, NULL);
INSERT INTO `app_wx_house` VALUES (70, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, 0, 0, 0, 0.00, 0.00, 0.00, NULL, 0, NULL, NULL, '官渡1', NULL, NULL, 58, '2020-03-03 22:42:58', 58, '2020-03-03 22:42:58', NULL, 0, 530111, NULL);
INSERT INTO `app_wx_house` VALUES (71, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, 0, 0, 0, 0.00, 0.00, 0.00, NULL, 0, NULL, NULL, '官渡2', NULL, NULL, 58, '2020-03-03 22:43:02', 58, '2020-03-03 22:43:02', NULL, 0, 530111, NULL);
INSERT INTO `app_wx_house` VALUES (72, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, 0, 0, 0, 0.00, 0.00, 0.00, NULL, 0, NULL, NULL, '五华', NULL, NULL, 59, '2020-03-03 22:44:41', 59, '2020-03-03 22:44:41', NULL, 0, 530102, NULL);
INSERT INTO `app_wx_house` VALUES (73, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, 0, 0, 0, 0.00, 0.00, 0.00, NULL, 0, NULL, NULL, '五华1', NULL, NULL, 59, '2020-03-03 22:44:47', 59, '2020-03-03 22:44:47', NULL, 0, 530102, NULL);
INSERT INTO `app_wx_house` VALUES (74, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, 0, 0, 0, 0.00, 0.00, 0.00, NULL, 0, NULL, NULL, '五华2', NULL, NULL, 59, '2020-03-03 22:44:51', 59, '2020-03-03 22:44:51', NULL, 0, 530102, NULL);
INSERT INTO `app_wx_house` VALUES (75, '1', 1, '1', 1, '1', 1, '1', 1, '1', '1', 1, 1, 1, 1, 1.00, 1.00, 1.00, '1', 1, '1', '1', '1', '1', '1', 1, '2020-03-03 23:02:52', 1, '2020-03-03 23:02:52', '1', 0, 530000, NULL);
INSERT INTO `app_wx_house` VALUES (76, '2', 2, '2', 2, '2', 2, '2', 2, '2', '2', 2, 2, 2, 2, 2.00, 2.00, 2.00, '2', 2, '2', '2', '2', '2', '2', 1, '2020-03-03 23:04:07', 1, '2020-03-03 23:04:07', '2', 0, 530000, NULL);
INSERT INTO `app_wx_house` VALUES (77, '3', 3, '3', 3, '3', 3, '3', 3, '3', '3', 3, 3, 3, 3, 3.00, 3.00, 3.00, '3', 3, '3', '3', '3', '3', '3', 1, '2020-03-03 23:05:57', 1, '2020-03-03 23:05:57', '3', 0, 530000, '云南省农业厅');

-- ----------------------------
-- Table structure for diy_attribute
-- ----------------------------
DROP TABLE IF EXISTS `diy_attribute`;
CREATE TABLE `diy_attribute`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '属性编码',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `category_id` bigint(20) NOT NULL COMMENT '分类id',
  `type` int(1) NOT NULL DEFAULT 0 COMMENT '字段类型：0字符串，1数字。用来前台校验 ，查询条件，',
  `default_value` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '属性默认值',
  `order_num` decimal(10, 0) NULL DEFAULT NULL COMMENT '排序',
  `is_show` int(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 1 COMMENT '控制该属性是否列表显示：1. 显示，0 影藏',
  `is_must` int(1) NOT NULL DEFAULT 1 COMMENT '是否必须：1 是，0 否',
  `help` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帮助信息',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `所属分类`(`category_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 108 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字段表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of diy_attribute
-- ----------------------------
INSERT INTO `diy_attribute` VALUES (13, 'remarks', '备注', 0, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '保留字段，分类为0', 0);
INSERT INTO `diy_attribute` VALUES (14, 'delFlag', '逻辑删除', 0, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '保留字段，分类为0', 0);
INSERT INTO `diy_attribute` VALUES (15, 'categoryId', '分类id', 0, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '保留字段，分类为0', 0);
INSERT INTO `diy_attribute` VALUES (16, 'jstime', 'js时间参数', 0, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '	保留字段，分类为0', 0);
INSERT INTO `diy_attribute` VALUES (17, 'id', '主键', 0, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '	保留字段，分类为0', 0);
INSERT INTO `diy_attribute` VALUES (18, 'diyCategoryId', NULL, 0, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '	保留字段，分类为0', 0);
INSERT INTO `diy_attribute` VALUES (19, 'name', '名字', 0, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '	保留字段，分类为0', 0);
INSERT INTO `diy_attribute` VALUES (20, 'sort', '排序', 0, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '	保留字段，分类为0', 0);
INSERT INTO `diy_attribute` VALUES (23, 'plantingDate', '种植时间', 3, 0, '1', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '二维码数据字段', 0);
INSERT INTO `diy_attribute` VALUES (24, 'belongSite', '所属地块', 3, 0, '1', 2, 1, 1, NULL, NULL, NULL, NULL, NULL, '二维码数据字段', 0);
INSERT INTO `diy_attribute` VALUES (25, 'seed', '种子名称', 3, 0, '1', 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '二维码数据字段', 0);
INSERT INTO `diy_attribute` VALUES (30, 'company', '公司名/姓名', 5, 0, '1', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '竞拍者', 0);
INSERT INTO `diy_attribute` VALUES (31, 'email', '邮箱', 5, 0, '1', 2, 1, 1, NULL, NULL, NULL, NULL, NULL, '邮箱练习方式', 0);
INSERT INTO `diy_attribute` VALUES (32, 'phone', '手机号码', 5, 0, '1', 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '联系方式-手机号码', 0);
INSERT INTO `diy_attribute` VALUES (33, 'address', '单位地址', 5, 0, '1', 4, 1, 1, NULL, NULL, NULL, NULL, NULL, '地址信息', 0);
INSERT INTO `diy_attribute` VALUES (34, 'receivedDate', '发货日期', 5, 0, '1', 5, 1, 1, NULL, NULL, NULL, NULL, NULL, '竞拍成功后发货日期', 0);
INSERT INTO `diy_attribute` VALUES (35, 'adivices', '意见或建议', 5, 0, '1', 6, 1, 1, NULL, NULL, NULL, NULL, NULL, '意见或建议', 0);
INSERT INTO `diy_attribute` VALUES (36, 'production', '商品种类', 6, 0, '1', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '商品信息', 0);
INSERT INTO `diy_attribute` VALUES (37, 'price', '最低价格', 6, 0, '1', 2, 1, 1, NULL, NULL, NULL, NULL, NULL, '价格字段信息', 0);
INSERT INTO `diy_attribute` VALUES (38, 'biddingStartDate', '竞拍开始时间', 6, 0, '1', 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '竞拍开始时间设定', 0);
INSERT INTO `diy_attribute` VALUES (39, 'switch', '开关', 6, 0, 'off', 4, 1, 1, NULL, NULL, NULL, NULL, NULL, '开启竞价模式', 0);
INSERT INTO `diy_attribute` VALUES (40, 'num', '种子数量', 3, 0, '1', 4, 1, 1, NULL, NULL, NULL, NULL, NULL, '种子数量', 0);
INSERT INTO `diy_attribute` VALUES (41, 'nongyaocanliu', '检测日期', 7, 0, '1', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '检测日期', 0);
INSERT INTO `diy_attribute` VALUES (52, 'fertilizationDate', '施肥日期', 1, 0, '1', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '施肥日期', 0);
INSERT INTO `diy_attribute` VALUES (53, 'plot', '所属地块', 1, 0, '1', 2, 1, 1, NULL, NULL, NULL, NULL, NULL, '2', 0);
INSERT INTO `diy_attribute` VALUES (54, 'farmOperatingTime', '农事操作时间', 4, 2, '1', 3, 1, 1, '农事操作时间,必填且为日期！', NULL, NULL, 1, '2018-12-27 00:26:37', '农事操作时间', 0);
INSERT INTO `diy_attribute` VALUES (55, 'doer', '经办人', 3, 0, '1', 5, 1, 1, NULL, NULL, NULL, NULL, NULL, '经办人', 0);
INSERT INTO `diy_attribute` VALUES (62, 'fertilizer', '肥料名称', 1, 0, '1', 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '肥料名称', 0);
INSERT INTO `diy_attribute` VALUES (63, 'fertilizationAmount', '施肥数量', 1, 0, '1', 4, 1, 1, NULL, NULL, NULL, NULL, NULL, '施肥数量', 0);
INSERT INTO `diy_attribute` VALUES (64, 'fertilizationMode', '施肥方式', 1, 0, '1', 5, 1, 1, NULL, NULL, NULL, NULL, NULL, '施肥方式', 0);
INSERT INTO `diy_attribute` VALUES (65, 'coManager', '经办方', 1, 0, '1', 6, 1, 1, NULL, NULL, NULL, NULL, NULL, '经办方', 0);
INSERT INTO `diy_attribute` VALUES (66, 'fRemarks', '备注', 1, 0, '1', 7, 1, 1, NULL, NULL, NULL, NULL, NULL, '备注', 0);
INSERT INTO `diy_attribute` VALUES (67, 'theirPlot', '所属地块', 4, 0, '1', 2, 1, 1, NULL, NULL, NULL, NULL, NULL, '所属地块', 0);
INSERT INTO `diy_attribute` VALUES (68, 'farmingContent', '农事内容', 4, 0, '1', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '农事内容', 0);
INSERT INTO `diy_attribute` VALUES (69, 'arranger', '经办者1', 4, 0, '1', 4, 1, 1, NULL, NULL, NULL, 1, '2018-12-25 20:43:07', '经办者', 0);
INSERT INTO `diy_attribute` VALUES (70, 'testingVarieties', '检测品种', 7, 0, '1', 2, 1, 1, NULL, NULL, NULL, NULL, NULL, '检测品种', 0);
INSERT INTO `diy_attribute` VALUES (71, 'measuredValue', '实测值', 7, 0, '1', 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '实测值', 0);
INSERT INTO `diy_attribute` VALUES (72, 'standardValue', '标准值', 7, 0, '1', 4, 1, 1, NULL, NULL, NULL, NULL, NULL, '标准值', 0);
INSERT INTO `diy_attribute` VALUES (73, 'testConclusion', '检测结论', 7, 0, '1', 5, 1, 1, NULL, NULL, NULL, NULL, NULL, '检测结论', 0);
INSERT INTO `diy_attribute` VALUES (74, 'testingUnit', '检测单位', 7, 0, '1', 6, 1, 1, NULL, NULL, NULL, NULL, NULL, '检测单位', 0);
INSERT INTO `diy_attribute` VALUES (75, 'monitorPeople', '监测人', 7, 0, '1', 7, 1, 1, NULL, NULL, NULL, NULL, NULL, '监测人', 0);
INSERT INTO `diy_attribute` VALUES (76, 'harvestDate', '采收日期', 9, 0, '1', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '采收日期', 0);
INSERT INTO `diy_attribute` VALUES (77, 'TheirPlot1', '所属地块', 9, 0, '1', 2, 1, 1, NULL, NULL, NULL, NULL, NULL, '所属地块', 0);
INSERT INTO `diy_attribute` VALUES (78, 'harvestProducts', '采收产品', 9, 0, '1', 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '采收产品', 0);
INSERT INTO `diy_attribute` VALUES (79, 'harvestNum', '采收数量', 9, 0, '1', 4, 1, 1, NULL, NULL, NULL, NULL, NULL, '采收数量', 0);
INSERT INTO `diy_attribute` VALUES (80, 'productLevel', '产品级别', 9, 0, '1', 5, 1, 1, NULL, NULL, NULL, NULL, NULL, '产品级别', 0);
INSERT INTO `diy_attribute` VALUES (81, 'operator1', '经办者', 9, 0, '1', 6, 1, 1, NULL, NULL, NULL, NULL, NULL, '', 0);
INSERT INTO `diy_attribute` VALUES (82, 'originName', '生产地名', 9, 0, '1', 7, 1, 1, NULL, NULL, NULL, NULL, NULL, '生产地名', 0);
INSERT INTO `diy_attribute` VALUES (83, 'address', '生产地地址', 9, 0, '1', 8, 1, 1, NULL, NULL, NULL, NULL, NULL, '生产地地址', 0);
INSERT INTO `diy_attribute` VALUES (84, 'aa', 'aa', 8, 0, '', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '', 0);
INSERT INTO `diy_attribute` VALUES (85, 'dateOfmedication', '用药日期', 11, 0, '', 1, 1, 1, NULL, NULL, NULL, NULL, NULL, '用药日期', 0);
INSERT INTO `diy_attribute` VALUES (86, 'landBelongingto', '所属地块', 11, 0, '', 2, 1, 1, NULL, NULL, NULL, 57, '2019-01-06 05:50:09', '所属地块', 0);
INSERT INTO `diy_attribute` VALUES (87, 'pesticideName', '农药名称', 11, 0, '', 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '农药名称', 0);
INSERT INTO `diy_attribute` VALUES (88, 'numberOfdrugs', '用药数量', 11, 0, '', 4, 1, 1, NULL, NULL, NULL, NULL, NULL, '用药数量', 0);
INSERT INTO `diy_attribute` VALUES (89, 'drugUse', '用药方式', 11, 0, '', 5, 1, 1, NULL, NULL, NULL, NULL, NULL, '用药方式', 0);
INSERT INTO `diy_attribute` VALUES (90, 'dilutionMultiples', '稀释倍数', 11, 0, '', 6, 1, 1, NULL, NULL, NULL, NULL, NULL, '稀释倍数', 0);
INSERT INTO `diy_attribute` VALUES (91, 'purposeOfmedication', '用药目的', 11, 0, '', 7, 1, 1, NULL, NULL, NULL, NULL, NULL, '用药目的', 0);
INSERT INTO `diy_attribute` VALUES (92, 'drugUser', '用药人', 11, 0, '', 8, 1, 1, NULL, NULL, NULL, NULL, NULL, '用药人', 0);
INSERT INTO `diy_attribute` VALUES (93, 'productName', '产品名称', 10, 0, '啊啊', 1, 1, 1, '产品名称，不能为空，且为数字', NULL, NULL, 1, '2019-01-05 07:09:43', '产品名称', 0);
INSERT INTO `diy_attribute` VALUES (94, 'originName', '产地名称', 10, 0, NULL, 2, 1, 1, '产地名称为日期yyyy-MM-dd。', NULL, NULL, 1, '2019-01-05 07:08:23', '产地名称', 0);
INSERT INTO `diy_attribute` VALUES (95, 'address', '地址', 10, 0, NULL, 3, 1, 1, NULL, NULL, NULL, NULL, NULL, '地址', 0);
INSERT INTO `diy_attribute` VALUES (98, 'a', 'a', 15, 1, '', 3, 1, 1, '请输入a!', 1, '2018-12-23 06:48:58', 1, '2020-02-27 19:35:58', 'a', 0);
INSERT INTO `diy_attribute` VALUES (99, 'b', 'b', 15, 0, '', 2, 1, 1, '请输入b！', 1, '2018-12-23 06:49:25', 1, '2020-02-27 19:36:37', 'b', 0);
INSERT INTO `diy_attribute` VALUES (104, 'responsiblePerson', '负责人', 10, 0, NULL, 4, 1, 1, '负责人必填，并且是文本', 57, '2019-01-05 09:47:12', NULL, NULL, NULL, 0);
INSERT INTO `diy_attribute` VALUES (105, 'd', 'd', 15, 0, '', 3, 1, 1, '请输入d！', 1, '2019-01-06 12:42:39', 1, '2020-02-27 19:36:16', 'd', 0);
INSERT INTO `diy_attribute` VALUES (106, 'a1', 'a1', 26, 1, NULL, 100, 1, 1, 'a1', 1, '2020-02-27 19:45:36', 1, '2020-02-27 19:45:36', 'a1', 0);
INSERT INTO `diy_attribute` VALUES (107, 'b1', 'b1', 26, 0, NULL, 22, 1, 1, 'b1', 1, '2020-02-27 19:45:48', 1, '2020-02-27 19:45:48', 'b1', 0);

-- ----------------------------
-- Table structure for diy_base_info
-- ----------------------------
DROP TABLE IF EXISTS `diy_base_info`;
CREATE TABLE `diy_base_info`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `category_id` bigint(20) NULL DEFAULT NULL COMMENT '分类id',
  `order_num` bigint(30) NULL DEFAULT NULL COMMENT '排序',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `关联分类`(`category_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '基础表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of diy_base_info
-- ----------------------------
INSERT INTO `diy_base_info` VALUES ('0574f946deca486d909008330237a51e', '茭白', 10, 1, 57, '2019-01-29 03:04:55', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('05e8fbc4465843f48f5e1e6ac204b049', '土豆', 4, 1, NULL, NULL, NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('07c7a782e78147ee92d5ea75f92e146c', '1231', 15, 1231, 1, '2020-02-27 19:31:27', 1, '2020-02-27 19:31:27', '1231', 0);
INSERT INTO `diy_base_info` VALUES ('09a248e161694ed1908dad8db7fb0ca8', '12', 1, 1, 1, '2018-12-23 03:28:18', 1, '2018-12-23 04:45:56', '位', 0);
INSERT INTO `diy_base_info` VALUES ('0bf8758205f4404cbe1ce3af9e66e883', '22', 26, 22, 1, '2020-02-27 19:46:34', 1, '2020-02-27 19:47:12', '222222', 0);
INSERT INTO `diy_base_info` VALUES ('0ec012045f3d429a88b575fba754a50a', '土豆', 4, 2, NULL, NULL, NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('11', '土豆', 1, 2, NULL, NULL, NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('128079092b164e4f81a3e4829b0c4a2d', NULL, 1, NULL, 57, '2018-12-25 15:47:48', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('1427d5fa8a234ae0926a0912ab9a1c45', '土豆', 10, 1, 57, '2019-01-05 09:15:02', 57, '2019-01-05 09:49:52', NULL, 0);
INSERT INTO `diy_base_info` VALUES ('1877cb635d944ae8bb98536c9fd2c86f', '土豆', 4, 3, NULL, NULL, NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('1bd1ff31e62f4ae682fff1e4ab17a6c6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('23d3b53d7ff74da39bed9e051e3d1c36', ' 1', 7, NULL, NULL, NULL, NULL, NULL, ' 1', 0);
INSERT INTO `diy_base_info` VALUES ('2fe963f3cf7f44729acb084aca778d53', '土豆', 11, 1, NULL, NULL, NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('33bc2820f48b41a69060fbd9663e83c8', '西瓜', 11, NULL, NULL, NULL, NULL, NULL, '西瓜', 0);
INSERT INTO `diy_base_info` VALUES ('35cd1e81504c4cba8101b3470dd19e89', '土豆', 9, 1, NULL, NULL, NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('3aa437053eca47b9970dd5c09912bc42', '茭白', 3, 2, 57, '2019-01-29 03:09:49', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('3aadfa15247e46529f0de6d7db0d3f0d', '西瓜', 11, NULL, NULL, NULL, NULL, NULL, '西瓜', 0);
INSERT INTO `diy_base_info` VALUES ('404f87ba9e284dc187c7899ee450b3f1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('4b240073140040e6a9259f02b097ca58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('4ddf846fa58d48c087f007dd54a15e85', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('59d6ccd249af4396b9e1525a803ac8fd', NULL, NULL, NULL, 1, '2018-12-23 16:16:49', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('5a960fba7a524c8bbbcc13453f70b270', '西瓜', 4, NULL, NULL, NULL, NULL, NULL, '西瓜', 0);
INSERT INTO `diy_base_info` VALUES ('60fdda5f83004495bcb9d56bc36464ab', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('63892c12a86d42c98b2cc9a08d216757', '土豆', NULL, NULL, 1, '2018-12-23 19:17:33', NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('6d021753331f4880b1edb0b763712c50', NULL, NULL, NULL, 1, '2018-12-23 16:16:49', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('6d4bc1a2efbf4db2b033514ab8348992', NULL, NULL, NULL, 1, '2018-12-23 16:34:28', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('6ff21c92d40e44c7b27174a47ccc8cf7', NULL, NULL, NULL, 1, '2018-12-23 16:49:28', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('75c015119605435cab09be7c66e334c4', '土豆', 11, 2, NULL, NULL, 57, '2019-01-06 05:48:54', '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('76380aafb28d4587a92a3442c066c3b7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('7af845ee226145f38e4a0f928e047305', NULL, NULL, NULL, 1, '2018-12-23 16:21:16', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('7b116b7f06d74745b2c2a997877b9461', '土豆', 3, 2, 57, '2019-01-05 09:54:17', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('836d649856ea4c7b84b5790731d96be9', 'aaaa', NULL, 1212, 1, '2018-12-23 06:58:19', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('8886b99b1be7400c984a9b03df49b5ef', '土豆', 7, 1, NULL, NULL, NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('8c0d5869177646f7825466693706e2a6', NULL, NULL, NULL, 1, '2018-12-23 16:19:27', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('91aeb1b725074064a25d3f71f81c93ce', '西瓜', 1, NULL, NULL, NULL, NULL, NULL, '西瓜', 0);
INSERT INTO `diy_base_info` VALUES ('91fd832434164dba869a0194465752c1', NULL, 1, NULL, 57, '2018-12-25 15:25:24', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('93d60298b98c4f3680b42736d37be4da', '西瓜', NULL, NULL, 1, '2018-12-23 19:17:33', NULL, NULL, '西瓜', 0);
INSERT INTO `diy_base_info` VALUES ('a7272258936644afabf478288c040c8d', '西瓜', NULL, NULL, 1, '2018-12-23 19:21:35', NULL, NULL, '西瓜', 0);
INSERT INTO `diy_base_info` VALUES ('afd9550764a34671b22931527b566f23', '11', 15, 11, 1, '2020-02-27 19:37:22', 1, '2020-02-27 19:44:01', '11', 0);
INSERT INTO `diy_base_info` VALUES ('b29b7754488a49f4a89fc9ad47679784', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('b3008cd556b845f99897e8cb35376e4e', 'qwe', NULL, NULL, 1, '2018-12-23 03:31:22', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('b34202ce65064984ab1846ca85e1d39c', '土豆', NULL, NULL, 1, '2018-12-23 19:21:35', NULL, NULL, '土豆', 0);
INSERT INTO `diy_base_info` VALUES ('b3e3d9a085874a708cdc64751717316e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('b9e23ba3eef64593b42ac380b7200cb6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('ba2b3ed1e10e4a069141ae55ec3f576e', NULL, NULL, NULL, 1, '2018-12-23 16:19:27', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('bcf3209af30c4378a7c52cb823a9aeee', '111', 10, 111, 1, '2018-12-26 19:57:24', 1, '2018-12-26 23:04:48', '111', 0);
INSERT INTO `diy_base_info` VALUES ('bfea4daac6f3405ba0cb41c75064a9a9', NULL, NULL, NULL, 1, '2018-12-23 16:34:28', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('c3cac660407043cbb9eec9630012cfa4', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('c4fc0514d0b0441fa7c59a5b130148b6', '黄瓜', 10, 1, 57, '2019-01-05 07:09:52', 57, '2019-01-05 07:10:11', '黄瓜二维码', 0);
INSERT INTO `diy_base_info` VALUES ('cae2d418eed34d7ba8f9652a435d4521', 'qwe', NULL, NULL, 1, '2018-12-23 03:29:23', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('cb090240f6d847cb8677799e6bc6dba1', NULL, NULL, NULL, 1, '2018-12-23 16:14:05', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('cc09ddf25d184d32b16c428ad0473ced', NULL, NULL, NULL, 1, '2018-12-23 16:21:16', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('d2d2a811c9f741fda0d320083eae486b', NULL, NULL, NULL, 1, '2018-12-23 16:49:28', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('d586c357a9fa4aa6b18ebcd64ab9ec37', NULL, NULL, NULL, 1, '2018-12-23 16:14:05', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('dbb6492a41e549fdb1a05b79ff94f6dd', NULL, 1, NULL, 57, '2018-12-25 15:20:58', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('df51b1cdfd074bb78fe0a484b97e0bf9', '西瓜', 9, NULL, NULL, NULL, NULL, NULL, '西瓜', 0);
INSERT INTO `diy_base_info` VALUES ('ebe67e71140d4a99ad6f20010aec24f6', '茭白', 1, 3, 57, '2019-01-29 03:13:20', NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('f3687174486445a2ae4ee17dab92024a', '2', 10, 2, 1, '2018-12-26 20:01:41', 1, '2018-12-27 00:10:19', '2', 0);
INSERT INTO `diy_base_info` VALUES ('f6c102a4295947af9502b767f99f5dec', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `diy_base_info` VALUES ('f6f4b9caf9ce45689fd9efe2d2e8ed3b', '土豆', 11, 3, NULL, NULL, 57, '2019-01-06 05:48:59', '土豆', 0);

-- ----------------------------
-- Table structure for diy_category
-- ----------------------------
DROP TABLE IF EXISTS `diy_category`;
CREATE TABLE `diy_category`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类编码',
  `order_num` bigint(30) NULL DEFAULT NULL COMMENT '排序',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  `type` int(1) NOT NULL DEFAULT 3 COMMENT '类型（0：停用；1：单数据，2：多数据，3：不限）',
  `is_show` tinyint(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 1 COMMENT '控制该分类是否显示：1. 显示，0 影藏',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
  `is_open` tinyint(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 1 COMMENT '是否对外：1. 是，0 否',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分类表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of diy_category
-- ----------------------------
INSERT INTO `diy_category` VALUES (1, '施肥记录', 'category1', 3, NULL, NULL, NULL, NULL, '属于数据产品二维码数据', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (3, '种植播种', 'diyCategory3', 2, NULL, NULL, NULL, NULL, '属于数据产品二维码数据', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (4, '其他农事', 'jsonCategory', 5, NULL, NULL, NULL, NULL, '属于数据产品二维码数据', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (5, '竞拍信息管理', 'bidding', 555, NULL, NULL, NULL, NULL, '用于记录竞拍者信息', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (6, '控制竞拍', 'biddingCtrl', 666, NULL, NULL, NULL, NULL, '用于控制竞拍流程', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (7, '检测记录', 'checkInfo', 6, NULL, NULL, NULL, NULL, '属于数据产品二维码数据', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (9, '采收记录', 'getInfo', 7, NULL, NULL, NULL, NULL, '属于数据产品二维码数据', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (10, '产品信息', 'productInformation', 1, NULL, NULL, NULL, NULL, '属于数据产品二维码数据', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (11, '农药使用', 'pesticideUse', 4, NULL, NULL, NULL, NULL, '属于数据产品二维码数据', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (15, '测试分类100', 'category100', 100, 1, '2018-12-23 06:48:26', NULL, NULL, 'category100', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (16, '施肥记录', 'test1', 3, 1, '2018-12-31 18:01:56', NULL, NULL, '测试', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (17, '种植播种', 'test3', 2, 1, '2018-12-31 18:01:56', NULL, NULL, '测试', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (18, '施肥记录', 'test1', 3, 1, '2018-12-31 18:03:20', NULL, NULL, '测试', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (19, '种植播种', 'test3', 2, 1, '2018-12-31 18:03:21', NULL, NULL, '测试', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (20, '施肥记录', 'test1', 3, 1, '2018-12-31 18:12:25', NULL, NULL, '测试', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (21, '种植播种', 'test3', 2, 1, '2018-12-31 18:12:25', NULL, NULL, '测试', 0, 3, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (24, '11', '11', 11, 1, '2019-04-29 14:17:28', 1, '2019-04-29 14:22:58', '11', 0, 1, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (25, 'aa', 'aa', 11, 1, '2019-04-29 14:22:44', NULL, NULL, 'ad', 0, 2, 1, NULL, 1);
INSERT INTO `diy_category` VALUES (26, '测试1', 'test1', 100, 1, '2020-02-27 19:44:38', 1, '2020-02-27 19:44:38', '测试1', 0, 3, 1, NULL, 0);

-- ----------------------------
-- Table structure for diy_json
-- ----------------------------
DROP TABLE IF EXISTS `diy_json`;
CREATE TABLE `diy_json`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据id',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `json_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '扩展的json值',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  `category_id` bigint(20) NULL DEFAULT NULL COMMENT '分类id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字段值表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of diy_json
-- ----------------------------
INSERT INTO `diy_json` VALUES ('000b1cb7547e4eb7b126d0ec0edeb455', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\", \"38\": \"2018-07-27 00:00:00\"}', '2018-07-26 20:26:31', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('047a6d7f1ab646c7a9796667765ff564', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914399\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"1\"}', '2018-07-26 23:34:13', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('05535537ab154be7962a4ef82cc2174b', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\"}', '2018-07-24 21:46:03', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('0574f946deca486d909008330237a51e', NULL, '{\"93\": \"茭白\", \"94\": \"上海市市外蔬菜主供应基地\", \"95\": \"云南德宏芒市\", \"104\": \"陶春良\"}', NULL, 57, '2019-01-29 03:04:55', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('05e8fbc4465843f48f5e1e6ac204b049', NULL, '{\"54\": \"2018-09-02\", \"67\": \"1\", \"68\": \"1\", \"69\": \"1\"}', '2018-09-02 09:11:41', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('05f66cdbb97e4139b1405c0fa0506135', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:54', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('07c7a782e78147ee92d5ea75f92e146c', NULL, '{\"99\":\"1231\",\"105\":\"1231\",\"98\":\"1231\"}', NULL, 1, '2020-02-27 19:31:27', 1, '2020-02-27 19:31:27', NULL, 0, 15);
INSERT INTO `diy_json` VALUES ('07db1df2660d42259bd4b8dd87b43803', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-26 20:40:57', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('09a248e161694ed1908dad8db7fb0ca8', NULL, '{\"52\": \"1\", \"53\": \"1\", \"62\": \"1\", \"63\": \"1\", \"64\": \"1111\", \"65\": \"1111\", \"66\": \"1\"}', NULL, 1, '2018-12-23 04:45:41', 1, '2018-12-23 04:45:56', NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('0a78e3a921cf46cbabfb957b9711a2ff', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:51', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('0bf8758205f4404cbe1ce3af9e66e883', NULL, '{\"106\":\"22\",\"107\":\"22\"}', NULL, 1, '2020-02-27 19:46:34', 1, '2020-02-27 19:47:12', NULL, 0, 26);
INSERT INTO `diy_json` VALUES ('0ec012045f3d429a88b575fba754a50a', NULL, '{\"54\": \"2018-09-02\", \"67\": \"2\", \"68\": \"2\", \"69\": \"2\"}', '2018-09-02 09:11:30', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('10', NULL, '{\"52\": \"2018-09-02\", \"53\": \"1\", \"62\": \"1\", \"63\": \"1\", \"64\": \"1\", \"65\": \"1\", \"66\": \"1\"}', '2018-09-02 09:08:48', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('11', NULL, '{\"52\": \"2018-09-08\", \"53\": \"1\", \"62\": \"1\", \"63\": \"1\", \"64\": \"1\", \"65\": \"1\", \"66\": \"1\"}', '2018-09-02 09:09:13', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('12', NULL, '{\"52\": \"2018-09-20\", \"53\": \"1\", \"62\": \"1\", \"63\": \"1\", \"64\": \"1\", \"65\": \"1\", \"66\": \"1\"}', '2018-09-02 09:09:30', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('128079092b164e4f81a3e4829b0c4a2d', NULL, '{\"23\": \"1\", \"24\": \"1\", \"25\": \"太阳花三号\"}', NULL, 57, '2018-12-25 15:47:49', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('1427d5fa8a234ae0926a0912ab9a1c45', NULL, '{\"93\": \"土豆\", \"94\": \"上海市市外蔬菜主供应基地\", \"95\": \"云南省德宏州芒市\", \"104\": \"1\"}', NULL, 57, '2019-01-05 09:15:02', 57, '2019-01-05 09:49:52', NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('152f9469794b43cbb34c0c5351838638', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:09', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('1877cb635d944ae8bb98536c9fd2c86f', NULL, '{\"54\": \"2018-09-03\", \"67\": \"3\", \"68\": \"3\", \"69\": \"3\"}', '2018-09-02 09:11:59', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('18e796d595154113a0c842683264fb01', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:49', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('1b03c244d8bb496dbd4e06021904be5a', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\"}', '2018-07-24 21:48:44', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('1bd1ff31e62f4ae682fff1e4ab17a6c6', NULL, '{\"25\": \"c\"}', '2018-07-15 03:06:03', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('1cc6e0c8dde443fb977d6c62bf66c7e5', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914370\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:13:53', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('23d3b53d7ff74da39bed9e051e3d1c36', NULL, '{\"41\": \"1\", \"70\": \"1\", \"71\": \"1\", \"72\": \"1\", \"73\": \"1\", \"74\": \"1\", \"75\": \"1\"}', '2018-08-21 13:44:20', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('24b25f451a1840fb85f0e4bf822f18e7', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:09', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('2535d21db634490db4f1bf78f86d340b', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914370\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:13:53', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('2543b94e0246478998806dc1703ba08b', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:13:09', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('2fe963f3cf7f44729acb084aca778d53', NULL, '{\"85\": \"2018-09-02\", \"86\": \"1\", \"87\": \"1\", \"88\": \"1\", \"89\": \"1\", \"90\": \"1\", \"91\": \"1\", \"92\": \"1\"}', '2018-09-02 09:10:28', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('33bc2820f48b41a69060fbd9663e83c8', NULL, '{\"85\": \"2018-09-01\", \"86\": \"2\", \"87\": \"2\", \"88\": \"2\", \"89\": \"2\", \"90\": \"2\", \"91\": \"2\", \"92\": \"2\"}', '2018-09-01 18:50:43', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('35cd1e81504c4cba8101b3470dd19e89', NULL, '{\"76\": \"2018-09-25\", \"77\": \"1\", \"78\": \"1\", \"79\": \"1\", \"80\": \"1\", \"81\": \"1\", \"82\": \"1\", \"83\": \"1\"}', '2018-09-02 09:12:37', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('3aa437053eca47b9970dd5c09912bc42', NULL, '{\"23\": \"2018年12月31日\", \"24\": \"上海市市外蔬菜主供应基地介桃基地\", \"25\": \"双季茭白\", \"40\": \"700株/亩\", \"55\": \"陶春良\"}', NULL, 57, '2019-01-29 03:09:49', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('3aadfa15247e46529f0de6d7db0d3f0d', NULL, '{\"85\": \"2018-09-01\", \"86\": \"1\", \"87\": \"1\", \"88\": \"1\", \"89\": \"1\", \"90\": \"1\", \"91\": \"1\", \"92\": \"1\"}', '2018-09-01 15:21:53', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('404f87ba9e284dc187c7899ee450b3f1', NULL, '{\"email\": \"[email protected]\", \"phone\": \"12312312311\", \"address\": \"adsda\", \"company\": \"231\", \"adivices\": \"asdas\", \"receivedDate\": \"2018-07-12\"}', '2018-07-20 00:07:27', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('47c927eb876a4d4fa55e423f62a90b3b', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914399\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"1\", \"nsukey\": \"ntYeQqEe5Ki+KsbJqkhmr/62WOu9Bll1Jk7K+C67tot4NxPDgYEbsR0Fqvc1pYTSHzQCdjJ2w7zVoqsMDbcCp/TGKiRtIXhjbDFOVm9tDXSRF6H+vHPgCtbzFytO9Iv7TAX5136UJMc/9tY9A/lwtv7CAOFIovQdIm7b/8PdUd125B2mXCjTXLbnFpIyMtxH5NfAPl9TrVDo/LXNwK5c1Q==\"}', '2018-07-26 23:34:18', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('4b240073140040e6a9259f02b097ca58', NULL, '{}', '2018-07-24 22:54:00', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('4ddf846fa58d48c087f007dd54a15e85', NULL, '{\"25\": \"cc\"}', '2018-07-15 03:06:03', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('4f2ca5895ce94d54a1571b84e0248151', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 13:46:13', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('526aecf0b2e24aafa00338d7d964d6b7', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:50', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('5415f339e4d445dd98e22fcc036b33b0', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:54', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('556b03fa17a944ba8d83d9f697dbcda0', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:51', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('55d996b2ab914a47a4a33f257a4ed866', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\"}', '2018-07-24 22:58:54', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('55dbc8ec6ffe43ddb132bac7682f6801', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:54', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('5656578d82c8460eb60e7286bcace4c4', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:51', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('59d6ccd249af4396b9e1525a803ac8fd', NULL, '{\"主键\": \"70ac779b6d6945368784ebe4b9d0f3bb\", \"名称\": \"西瓜\", \"备注\": \"西瓜\", \"排序\": \"1\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:16:49', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('5a960fba7a524c8bbbcc13453f70b270', NULL, '{\"54\": \"1\", \"67\": \"1\", \"68\": \"1\", \"69\": \"1\"}', '2018-08-21 13:41:23', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('5bd1565d57a441d6a1bca3f4ca501f10', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\", \"nsukey\": \"gZl1VMBxgmhlpnOxOBg9XWU26Q03+JhWhg/sThvkfn/xS7okSTIIQjfznI5m1SGoenPeGcdE81d58LPtKNLbni7NBy1p2cBK5KIaNDSwlbiA9UAcpLoDtlctsABrl1uR4vVd0R7dCN8cavEVzDy+X30AJeB8ziXe5+DAqj+juPnTMF6j3P49bE0wFxt2Abc1xIAkxxAnBzlDt5k4QdB6+Q==\"}', '2018-07-26 23:07:51', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('5c1e3bc61af54f3b809c3c8ce5721dd1', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914399\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"1\"}', '2018-07-26 23:54:29', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('5da43a107294439fb653c6ae748ccb5e', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-26 23:07:44', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('600b6f13e87c48e482144ade404ff338', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:09', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('60fdda5f83004495bcb9d56bc36464ab', NULL, '{\"25\": \"cc\"}', '2018-07-15 02:57:41', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('63892c12a86d42c98b2cc9a08d216757', NULL, '{\"93\": \"b\", \"94\": null, \"95\": \"呃呃\"}', NULL, 1, '2018-12-23 19:17:33', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('643262c42f7846b5b80a8409635b5bf3', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914380\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-26 20:27:19', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('6d021753331f4880b1edb0b763712c50', NULL, '{\"主键\": \"8e02ad8a648940f3a5232c52a364165d\", \"名称\": \"土豆\", \"备注\": \"土豆\", \"排序\": \"2\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:16:49', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('6d037143ac4b42d6a4c3770796b556bb', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914399\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"1\", \"nsukey\": \"ntYeQqEe5Ki+KsbJqkhmr/62WOu9Bll1Jk7K+C67tot4NxPDgYEbsR0Fqvc1pYTSHzQCdjJ2w7zVoqsMDbcCp/TGKiRtIXhjbDFOVm9tDXSRF6H+vHPgCtbzFytO9Iv7TAX5136UJMc/9tY9A/lwtv7CAOFIovQdIm7b/8PdUd125B2mXCjTXLbnFpIyMtxH5NfAPl9TrVDo/LXNwK5c1Q==\"}', '2018-07-26 23:34:18', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('6d4bc1a2efbf4db2b033514ab8348992', NULL, '{\"主键\": \"70ac779b6d6945368784ebe4b9d0f3bb\", \"名称\": \"西瓜\", \"备注\": \"西瓜\", \"排序\": \"1\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:34:52', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('6ff21c92d40e44c7b27174a47ccc8cf7', NULL, '{\"主键\": \"70ac779b6d6945368784ebe4b9d0f3bb\", \"名称\": \"西瓜\", \"备注\": \"西瓜\", \"排序\": \"1\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:49:28', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('70ab09e457d44e9d997f1d2dd1da3feb', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\"}', '2018-07-24 22:46:30', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('7159f7ae69234259b6d85288498b872d', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 13:52:19', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('747c7e21acef4e4192fd3e60868e342b', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914380\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-26 20:27:17', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('75c015119605435cab09be7c66e334c4', NULL, '{\"85\": \"2018-09-20\", \"86\": \"2\", \"87\": \"2\", \"88\": \"2\", \"89\": \"2\", \"90\": \"2\", \"91\": \"2\", \"92\": \"2\"}', '2018-09-02 09:10:59', NULL, NULL, 57, '2019-01-06 05:48:54', NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('76380aafb28d4587a92a3442c066c3b7', NULL, '{\"25\": \"c\"}', '2018-07-15 02:57:41', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('7af845ee226145f38e4a0f928e047305', NULL, '{\"主键\": \"70ac779b6d6945368784ebe4b9d0f3bb\", \"名称\": \"西瓜\", \"备注\": \"西瓜\", \"排序\": \"1\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:21:16', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('7b116b7f06d74745b2c2a997877b9461', NULL, '{\"23\": \"1\", \"24\": \"1\", \"25\": \"1\", \"40\": \"1\", \"55\": \"1\"}', NULL, 57, '2019-01-05 09:54:17', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('8193615212f943e79021ba7185f792f0', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:51', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('824de4cab7314811b7f3534192cae491', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:50', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('8353db82764a4936b14f34b374fc81d0', NULL, '{\"23\": \"2018-08-21\", \"24\": \"1\", \"25\": \"1\", \"40\": \"1\", \"55\": \"1\"}', '2018-09-02 09:09:58', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('836d649856ea4c7b84b5790731d96be9', NULL, '{\"98\": \"aaa\", \"99\": \"\"}', NULL, 1, '2018-12-23 06:58:19', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('83f3708dbd734375a423938010921ab6', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:13:09', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('844947d726b74382ac8abfaa804a84b7', NULL, '{\"23\": \"a\", \"24\": \"b\", \"25\": \"c\"}', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('884d47a53867496f930a0abea92035f5', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"1\"}', '2018-07-27 22:21:38', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('8886b99b1be7400c984a9b03df49b5ef', NULL, '{\"41\": \"2018-09-02\", \"70\": \"1\", \"71\": \"1\", \"72\": \"1\", \"73\": \"1\", \"74\": \"1\", \"75\": \"1\"}', '2018-09-02 09:12:17', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('8c0d5869177646f7825466693706e2a6', NULL, '{\"主键\": \"70ac779b6d6945368784ebe4b9d0f3bb\", \"名称\": \"西瓜\", \"备注\": \"西瓜\", \"排序\": \"1\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:19:27', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('8e37ab8ec1dc4edbb6c7fc00b6dd856b', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"1\"}', '2018-07-27 22:21:38', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('919f3981512d43ce96fcf88086a623d5', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914399\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"1\"}', '2018-07-26 23:54:29', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('91aeb1b725074064a25d3f71f81c93ce', NULL, '{\"52\": \"1\", \"53\": \"1\", \"62\": \"1\", \"63\": \"1\", \"64\": \"1\", \"65\": \"1\", \"66\": \"1\"}', '2018-08-21 13:40:35', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('91fd832434164dba869a0194465752c1', NULL, '{\"23\": \"1\", \"24\": \"1\", \"25\": \"太阳花三号\"}', NULL, 57, '2018-12-25 15:25:25', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('93d60298b98c4f3680b42736d37be4da', NULL, '{\"93\": null, \"94\": \"c\", \"95\": null}', NULL, 1, '2018-12-23 19:17:33', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('954dc7e835e04c97bd067d7efc87528d', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 13:52:56', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('a08327b7322148fab82336e95cefb0b2', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:54', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('a7272258936644afabf478288c040c8d', NULL, '{\"93\": null, \"94\": \"c\", \"95\": null}', NULL, 1, '2018-12-23 19:21:35', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('ad4d9ff182714c1880692ccf0dd8e772', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:49', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('afd9550764a34671b22931527b566f23', NULL, '{\"99\":\"a\",\"105\":\"11\",\"98\":\"11\"}', NULL, 1, '2020-02-27 19:37:22', 1, '2020-02-27 19:44:01', NULL, 0, 15);
INSERT INTO `diy_json` VALUES ('b29b7754488a49f4a89fc9ad47679784', NULL, '{\"email\": \"[email protected]\", \"phone\": \"12312312311\", \"address\": \"sxs\", \"company\": \"123\", \"adivices\": \"\", \"receivedDate\": \"\"}', '2018-07-20 00:14:52', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('b3008cd556b845f99897e8cb35376e4e', NULL, '{\"52\": \"123123\", \"53\": \"11231\", \"62\": \"1121\", \"63\": \"1\", \"64\": \"1\", \"65\": \"1\", \"66\": \"1\"}', NULL, 1, '2018-12-23 03:31:30', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('b34202ce65064984ab1846ca85e1d39c', NULL, '{\"93\": \"b\", \"94\": null, \"95\": \"呃呃\"}', NULL, 1, '2018-12-23 19:21:35', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('b3e3d9a085874a708cdc64751717316e', NULL, '{}', '2018-07-14 00:37:36', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('b9e23ba3eef64593b42ac380b7200cb6', NULL, '{}', '2018-07-24 14:23:30', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('ba2b3ed1e10e4a069141ae55ec3f576e', NULL, '{\"主键\": \"8e02ad8a648940f3a5232c52a364165d\", \"名称\": \"土豆\", \"备注\": \"土豆\", \"排序\": \"2\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:19:27', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('bcd869dc4c34466e82b1dba90397847c', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:51', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('bcf3209af30c4378a7c52cb823a9aeee', NULL, '{\"93\": \"啊啊\", \"94\": \"啊啊啊\", \"95\": \"踩踩踩\"}', NULL, 1, '2018-12-26 20:05:00', 1, '2018-12-26 23:04:49', NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('be51aec81ed14b529ba3aee276968c36', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 13:49:00', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('bfea4daac6f3405ba0cb41c75064a9a9', NULL, '{\"主键\": \"8e02ad8a648940f3a5232c52a364165d\", \"名称\": \"土豆\", \"备注\": \"土豆\", \"排序\": \"2\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:34:52', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('c3cac660407043cbb9eec9630012cfa4', NULL, '{\"email\": \"[email protected]\", \"phone\": \"12312312311\", \"address\": \"dede\", \"company\": \"123\", \"adivices\": \"\", \"receivedDate\": \"\"}', '2018-07-20 00:00:51', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('c4c94c18bc114303a4c1540e2d97ce0f', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 13:52:14', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('c4fc0514d0b0441fa7c59a5b130148b6', NULL, '{\"93\": \"黄瓜\", \"94\": \"云南德宏芒市\", \"95\": \"云南德宏芒市\"}', NULL, 57, '2019-01-05 07:09:52', 57, '2019-01-05 07:10:11', NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('c5b8ade5c799422badc6a43db3a527c2', NULL, '{\"30\": \"ygz\", \"31\": \"[email protected]\", \"32\": \"13954656021\", \"33\": \"云南省昆明市盘龙区\", \"34\": \"2018-07-23\", \"35\": \"测试~\"}', '2018-07-23 22:26:51', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('c93aec66ea624570ac92a0e21353ed5a', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914300\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-24\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 00:17:34', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('ca901bde262d4a9d9fcdfc0aaeabe307', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-26 20:26:29', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('cb090240f6d847cb8677799e6bc6dba1', NULL, '{\"主键\": \"8e02ad8a648940f3a5232c52a364165d\", \"名称\": \"土豆\", \"备注\": \"土豆\", \"排序\": \"2\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:14:05', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('cc09ddf25d184d32b16c428ad0473ced', NULL, '{\"主键\": \"8e02ad8a648940f3a5232c52a364165d\", \"名称\": \"土豆\", \"备注\": \"土豆\", \"排序\": \"2\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:21:16', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('cc16e0d6934c48c783e1362e23e3810e', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 00:24:19', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('d1f21b0a978d466daec38dbe19ab12a7', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:54', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('d2d2a811c9f741fda0d320083eae486b', NULL, '{\"主键\": \"8e02ad8a648940f3a5232c52a364165d\", \"名称\": \"土豆\", \"备注\": \"土豆\", \"排序\": \"2\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:49:28', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('d586c357a9fa4aa6b18ebcd64ab9ec37', NULL, '{\"主键\": \"70ac779b6d6945368784ebe4b9d0f3bb\", \"名称\": \"西瓜\", \"备注\": \"西瓜\", \"排序\": \"1\", \"分类id\": \"10\"}', NULL, 1, '2018-12-23 16:14:05', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('dbb6492a41e549fdb1a05b79ff94f6dd', NULL, '{\"23\": \"1\", \"24\": \"1\", \"25\": \"太阳花三号\"}', NULL, 57, '2018-12-25 15:20:58', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('df51b1cdfd074bb78fe0a484b97e0bf9', NULL, '{\"76\": \"1\", \"77\": \"1\", \"78\": \"1\", \"79\": \"1\", \"80\": \"1\", \"81\": \"1\", \"82\": \"1\", \"83\": \"1\"}', '2018-08-21 13:41:33', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('e395b32aa59249b6a20de76c79028ed4', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 13:51:12', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('e4f7fa9fa79741c48ef160e1202a8033', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-25 13:50:24', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('e610b4392526491494643ba151b242ba', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-26 23:08:44', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('e8f74a01e3a44203ab07df2f36549ab6', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:49', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('ebe67e71140d4a99ad6f20010aec24f6', NULL, '{\"52\": \"2019年1月18日\", \"53\": \"上海市市外蔬菜主供应基地介桃基地\", \"62\": \"尿素+氯化钾复合肥（15-15-15）\", \"63\": \"20斤尿素+50斤氯化钾复合肥（15-15-15）/亩\", \"64\": \"撒施\", \"65\": \"陶春良\", \"66\": \"1\"}', NULL, 57, '2019-01-29 03:13:20', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('ec3dc596d36d486bad3e4597698b320f', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914377\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-26 20:28:54', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('eec568e8e9864ca386885e99b861debc', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914370\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:13:53', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('f3687174486445a2ae4ee17dab92024a', NULL, '{\"93\": \"11\", \"94\": \"2018-12-13\", \"95\": \"1\"}', NULL, 1, '2018-12-26 20:01:41', 1, '2018-12-27 00:10:19', NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('f682e1ea85af4dd891cc902f6ab3e001', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:13:09', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('f6c102a4295947af9502b767f99f5dec', NULL, '{}', '2018-07-24 00:22:05', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('f6dbe77284484474803ac5c0a801ae99', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-27 22:12:54', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('f6f4b9caf9ce45689fd9efe2d2e8ed3b', NULL, '{\"85\": \"2018-09-05\", \"86\": \"3\", \"87\": \"3\", \"88\": \"3\", \"89\": \"3\", \"90\": \"3\", \"91\": \"3\", \"92\": \"3\"}', '2018-09-02 09:10:44', NULL, NULL, 57, '2019-01-06 05:48:59', NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('f79b6d5afff24d30816b2eaf50209250', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914377\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\", \"36\": \"0\"}', '2018-07-26 20:28:56', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('f91f4318759f44efa58e8d7b1f7207f3', NULL, '{\"52\": \"123123\", \"53\": \"11231\", \"62\": \"1121\", \"63\": \"1\", \"64\": \"1\", \"65\": \"1\", \"66\": \"1\"}', NULL, 1, '2018-12-23 03:32:32', NULL, NULL, NULL, 0, NULL);
INSERT INTO `diy_json` VALUES ('f9f92268edd2487db775c050c17e50d4', NULL, '{\"30\": \"贤心\", \"31\": \"[email protected]\", \"32\": \"18270914379\", \"33\": \"云南省昆明市\", \"34\": \"2018-07-23\", \"35\": \"备注测试~\"}', '2018-07-24 21:45:42', NULL, NULL, NULL, NULL, NULL, 0, NULL);

-- ----------------------------
-- Table structure for diy_reserved_attribute
-- ----------------------------
DROP TABLE IF EXISTS `diy_reserved_attribute`;
CREATE TABLE `diy_reserved_attribute`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `create_by` bigint(32) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(32) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字段保留表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for im_msg_info
-- ----------------------------
DROP TABLE IF EXISTS `im_msg_info`;
CREATE TABLE `im_msg_info`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` bigint(20) NULL DEFAULT 0 COMMENT '上级ID',
  `pids` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '所有上级',
  `name` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '标题',
  `sort` int(2) NULL DEFAULT 1 COMMENT '消息排序',
  `msg_type` int(2) NULL DEFAULT NULL COMMENT '消息类型（1 系统，2 聊天，3 评论，等）',
  `msg_data_type` int(2) NULL DEFAULT NULL COMMENT '消息数据类型（1 普通文本，2 图片url，3 视频url，4 语音url， 等）',
  `data_id` bigint(20) NULL DEFAULT NULL COMMENT '数据id（如报道的评论 ,纯用户交互，默认空）',
  `creator` bigint(20) NULL DEFAULT NULL COMMENT '创建者(消息发送者)',
  `del_flag` tinyint(1) NULL DEFAULT 0 COMMENT '删除标识  0：未删除    1：删除',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `tenant_code` bigint(20) NULL DEFAULT NULL COMMENT '租户编码',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of im_msg_info
-- ----------------------------
INSERT INTO `im_msg_info` VALUES (1, 0, NULL, '系统消息1', 1, 1, 1, NULL, 1, 0, '2019-07-26 11:32:37', NULL, NULL, 1001, NULL);
INSERT INTO `im_msg_info` VALUES (2, 0, NULL, '系统消息2', 1, 1, 1, NULL, 1, 0, '2019-07-25 11:32:37', NULL, NULL, 1001, NULL);
INSERT INTO `im_msg_info` VALUES (3, 0, NULL, '系统消息3', 1, 1, 1, NULL, 1, 0, '2019-07-24 11:32:37', NULL, NULL, 1001, NULL);
INSERT INTO `im_msg_info` VALUES (4, 0, '', '内容', 1, NULL, NULL, NULL, 1067246875800000001, 0, '2019-07-26 17:08:18', NULL, NULL, 1001, NULL);
INSERT INTO `im_msg_info` VALUES (6, 0, '', '公告内容新增', 1, 1, NULL, NULL, 1067246875800000001, 0, '2019-07-26 17:14:01', NULL, NULL, 1001, NULL);
INSERT INTO `im_msg_info` VALUES (8, 0, '', '公告标题', 1, 1, NULL, NULL, 1067246875800000001, 0, '2019-07-26 19:36:20', NULL, NULL, 1001, NULL);
INSERT INTO `im_msg_info` VALUES (9, 0, '', '标题', 1, 1, NULL, NULL, 1067246875800000001, 0, '2019-07-26 19:41:44', NULL, NULL, 1001, NULL);
INSERT INTO `im_msg_info` VALUES (10, 0, '', '公告标题', 1, 1, NULL, NULL, 1067246875800000001, 0, '2019-07-26 19:44:37', NULL, NULL, 1001, NULL);

-- ----------------------------
-- Table structure for im_msg_user_ref
-- ----------------------------
DROP TABLE IF EXISTS `im_msg_user_ref`;
CREATE TABLE `im_msg_user_ref`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `msg_id` bigint(20) NULL DEFAULT NULL COMMENT '消息id',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `msg_status` int(1) NULL DEFAULT 1 COMMENT '消息状态（1 默认<未推送>，2 未阅<已推送>，3  已阅读 ，4 用户删除）',
  `creator` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `tenant_code` bigint(20) NULL DEFAULT NULL COMMENT '租户编码',
  `del_flag` tinyint(1) NULL DEFAULT 0 COMMENT '删除标识  0：未删除    1：删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `activity_user_id`(`msg_id`, `user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息用户关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of im_msg_user_ref
-- ----------------------------
INSERT INTO `im_msg_user_ref` VALUES (1, 1, 1152466661293592577, 1, NULL, NULL, NULL, NULL, NULL, 0);

-- ----------------------------
-- Table structure for im_user_msg_view.bak
-- ----------------------------
DROP TABLE IF EXISTS `im_user_msg_view.bak`;
CREATE TABLE `im_user_msg_view.bak`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` bigint(20) NULL DEFAULT 0 COMMENT '上级ID',
  `pids` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '所有上级',
  `name` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '标题',
  `sort` int(2) NULL DEFAULT 1 COMMENT '消息状态（1 待处理，2 已处理）',
  `msg_type` int(2) NULL DEFAULT NULL COMMENT '消息类型（1 系统，2 聊天，3 评论，等）',
  `msg_data_type` int(2) NULL DEFAULT NULL COMMENT '消息数据类型（1 普通文本，2 图片url，3 视频url，4 语音url， 等）',
  `data_id` bigint(20) NULL DEFAULT NULL COMMENT '数据id（如报道的评论 ,纯用户交互，默认空）',
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `real_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓　名',
  `gender` tinyint(4) UNSIGNED NULL DEFAULT NULL COMMENT '性别   0：男   1：女    2：保密',
  `head_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `msg_status` int(1) NULL DEFAULT 1 COMMENT '消息状态（1 默认<未推送>，2 未阅<已推送>，3  已阅读 ，4 用户删除）',
  `creator` bigint(20) NULL DEFAULT NULL COMMENT '创建者(消息发送者)',
  `del_flag` tinyint(4) UNSIGNED NULL DEFAULT NULL COMMENT '删除标识  0：未删除    1：删除',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `tenant_code` bigint(20) NULL DEFAULT NULL COMMENT '租户编码',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户消息视图表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sq_sampling_category
-- ----------------------------
DROP TABLE IF EXISTS `sq_sampling_category`;
CREATE TABLE `sq_sampling_category`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '上级分类ID，一级分类为0',
  `parent_ids` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所有分类父类名称',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称',
  `order_num` bigint(11) NULL DEFAULT NULL COMMENT '排序',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `remark` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
  `category_id` bigint(20) NULL DEFAULT NULL COMMENT '分类id',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 81 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分类管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sq_sampling_category
-- ----------------------------
INSERT INTO `sq_sampling_category` VALUES (1, 0, ',0,', '土壤', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (2, 0, ',0,', '农作物', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (3, 1, ',0,1,', '土壤亚类', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (4, 3, ',0,1,3,', '成土母质', 4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (5, 1, ',0,1,', '黑土', 3, 1, 1, '2018-09-28 17:40:07', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (6, 2, ',0,2,', '类别1', 4, 1, 1, '2018-09-28 17:40:45', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (7, 2, ',0,2,', '类别2', 0, 1, 116, '2018-11-16 15:43:42', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (14, 0, ',0,', '测试', 3, 1, 1, '2018-11-01 18:31:16', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (15, 14, ',0,14,', '测试a', 3, 1, 1, '2018-11-01 18:31:48', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (16, 19, ',0,14,19,', '测试aa', 3, 1, 1, '2018-11-01 18:31:48', 1, '2018-12-21 22:55:39', NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (17, 16, ',0,14,19,16,', '测试aaa', 3, 1, 1, '2018-11-01 18:31:48', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (18, 16, ',0,14,19,16,', '测试aab', 3, 1, 1, '2018-11-01 18:31:48', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (19, 14, ',0,14,', '测试b', 3, 1, 1, '2018-11-01 18:31:48', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (20, 19, ',0,14,19,', '测试bb', 3, 1, 1, '2018-11-01 18:31:48', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (25, 0, ',0,', 'test1', 0, 1, 1, '2018-11-02 11:38:25', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (26, 25, ',0,25,', 'test2', 0, 1, 1, '2018-11-02 11:38:33', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (27, 26, ',0,25,26,', 'test3', 0, 1, 1, '2018-11-02 11:38:43', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (29, 1, ',0,1,', 'test31', 0, 1, 1, '2018-11-02 11:39:25', 1, '2018-12-12 16:30:07', NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (30, 2, ',0,2,', 'test41', 0, 1, 1, '2018-11-02 11:39:47', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (31, 25, ',0,25,', '111', 0, 1, NULL, '2018-11-14 17:30:11', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (32, 0, ',0,', '交通工具', 0, 1, 1, '2018-11-16 11:43:04', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (33, 0, ',0,', '455', 0, 1, 1, '2018-11-16 11:44:46', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (34, 0, ',0,', '土壤', 1, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (35, 0, ',0,', '农作物', 2, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (36, 1, ',0,1,', '土壤亚类', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (37, 3, ',0,1,3,', '成土母质', 4, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (38, 1, ',0,1,', '黑土', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (39, 2, ',0,2,', '类别1', 4, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (40, 2, ',0,2,', '类别2', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (41, 0, ',0,', '测试', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (42, 14, ',0,14,', '测试a', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (43, 19, ',0,14,19,', '测试aa', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (44, 16, ',0,14,19,16,', '测试aaa', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (45, 16, ',0,14,19,16,', '测试aab', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (46, 14, ',0,14,', '测试b', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (47, 19, ',0,14,19,', '测试bb', 3, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (48, 0, ',0,', 'test1', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (49, 25, ',0,25,', 'test2', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (50, 26, ',0,25,26,', 'test3', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (51, 1, ',0,1,', 'test31', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (52, 2, ',0,2,', 'test41', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (53, 25, ',0,25,', '111', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (54, 0, ',0,', '交通工具', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (55, 0, ',0,', '455', 0, 1, 1, '2018-12-31 20:35:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (56, 0, ',0,', '土壤', 1, 0, 1, '2018-12-31 20:36:10', 1, '2018-12-31 20:37:27', '111', NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (57, 0, ',0,', '农作物', 2, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (58, 1, ',0,1,', '土壤亚类', 3, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (59, 3, ',0,1,3,', '成土母质', 4, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (60, 1, ',0,1,', '黑土', 3, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (61, 2, ',0,2,', '类别1', 4, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (62, 2, ',0,2,', '类别2', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (63, 0, ',0,', '测试', 3, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (64, 14, ',0,14,', '测试a', 3, 1, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (65, 19, ',0,14,19,', '测试aa', 3, 1, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (66, 16, ',0,14,19,16,', '测试aaa', 3, 1, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (67, 16, ',0,14,19,16,', '测试aab', 3, 1, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (68, 14, ',0,14,', '测试b', 3, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (69, 19, ',0,14,19,', '测试bb', 3, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (70, 0, ',0,', 'test1', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (71, 25, ',0,25,', 'test2', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (72, 26, ',0,25,26,', 'test3', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (73, 1, ',0,1,', 'test31', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (74, 2, ',0,2,', 'test41', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (75, 25, ',0,25,', '111', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (76, 0, ',0,', '交通工具', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (77, 0, ',0,', '455', 0, 0, 1, '2018-12-31 20:36:10', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sq_sampling_category` VALUES (78, 59, ',0,1,', '12', 12, 0, 1, '2018-12-31 20:37:42', 1, '2019-01-01 08:27:57', '12', 12, '12');
INSERT INTO `sq_sampling_category` VALUES (79, 1, ',0,1,', '1', 1, 1, 1, '2019-01-01 08:26:46', NULL, NULL, '1', 1, '1');
INSERT INTO `sq_sampling_category` VALUES (80, 1, ',0,1,', '1', 1, 0, 1, '2019-01-06 04:12:58', NULL, NULL, '1', 1, '1');

-- ----------------------------
-- Table structure for sys_area
-- ----------------------------
DROP TABLE IF EXISTS `sys_area`;
CREATE TABLE `sys_area`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `parent_id` bigint(20) NOT NULL COMMENT '父级编号',
  `parent_ids` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所有父级编号',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
  `short_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '缩略名称',
  `order_num` decimal(10, 0) NOT NULL COMMENT '排序',
  `code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域编码',
  `type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域类型',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sys_area_parent_id`(`parent_id`) USING BTREE,
  INDEX `sys_area_del_flag`(`del_flag`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 533433 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '区域表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_area
-- ----------------------------
INSERT INTO `sys_area` VALUES (530000, 0, ',0,', '云南省', '', 10, '600', '1', 1, '2013-05-27 08:00:00', 1, '2018-12-22 10:53:09', NULL, 0);
INSERT INTO `sys_area` VALUES (530100, 530000, ',0,530000,', '昆明市', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530101, 530100, ',0,530000,530100,', '市辖区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530102, 530100, ',0,530000,530100,', '五华区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530103, 530100, ',0,530000,530100,', '盘龙区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530111, 530100, ',0,530000,530100,', '官渡区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530112, 530100, ',0,530000,530100,', '西山区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530113, 530100, ',0,530000,530100,', '东川区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530121, 530100, ',0,530000,530100,', '呈贡区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530122, 530100, ',0,530000,530100,', '晋宁区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530124, 530100, ',0,530000,530100,', '富民县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530125, 530100, ',0,530000,530100,', '宜良县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530126, 530100, ',0,530000,530100,', '石林彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530127, 530100, ',0,530000,530100,', '嵩明县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530128, 530100, ',0,530000,530100,', '禄劝彝族苗族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530129, 530100, ',0,530000,530100,', '寻甸回族彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530181, 530100, ',0,530000,530100,', '安宁市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530300, 530000, ',0,530000,', '曲靖市', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530301, 530300, ',0,530000,530300,', '市辖区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530302, 530300, ',0,530000,530300,', '麒麟区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530321, 530300, ',0,530000,530300,', '马龙县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530322, 530300, ',0,530000,530300,', '陆良县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530323, 530300, ',0,530000,530300,', '师宗县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:09', '', 0);
INSERT INTO `sys_area` VALUES (530324, 530300, ',0,530000,530300,', '罗平县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530325, 530300, ',0,530000,530300,', '富源县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530326, 530300, ',0,530000,530300,', '会泽县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530328, 530300, ',0,530000,530300,', '沾益县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530381, 530300, ',0,530000,530300,', '宣威市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530400, 530000, ',0,530000,', '玉溪市', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530401, 530400, ',0,530000,530400,', '市辖区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530402, 530400, ',0,530000,530400,', '红塔区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530421, 530400, ',0,530000,530400,', '江川县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530422, 530400, ',0,530000,530400,', '澄江县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530423, 530400, ',0,530000,530400,', '通海县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530424, 530400, ',0,530000,530400,', '华宁县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530425, 530400, ',0,530000,530400,', '易门县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530426, 530400, ',0,530000,530400,', '峨山彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530427, 530400, ',0,530000,530400,', '新平彝族傣族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530428, 530400, ',0,530000,530400,', '元江哈尼族彝族傣族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530500, 530000, ',0,530000,', '保山市', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530501, 530500, ',0,530000,530500,', '市辖区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530502, 530500, ',0,530000,530500,', '隆阳区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530521, 530500, ',0,530000,530500,', '施甸县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530523, 530500, ',0,530000,530500,', '龙陵县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530524, 530500, ',0,530000,530500,', '昌宁县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530581, 530500, ',0,530000,530500,', '腾冲市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530600, 530000, ',0,530000,', '昭通市', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530601, 530600, ',0,530000,530600,', '市辖区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530602, 530600, ',0,530000,530600,', '昭阳区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530621, 530600, ',0,530000,530600,', '鲁甸县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530622, 530600, ',0,530000,530600,', '巧家县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530623, 530600, ',0,530000,530600,', '盐津县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530624, 530600, ',0,530000,530600,', '大关县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:11', '', 0);
INSERT INTO `sys_area` VALUES (530625, 530600, ',0,530000,530600,', '永善县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530626, 530600, ',0,530000,530600,', '绥江县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530627, 530600, ',0,530000,530600,', '镇雄县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530628, 530600, ',0,530000,530600,', '彝良县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530629, 530600, ',0,530000,530600,', '威信县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530630, 530600, ',0,530000,530600,', '水富县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530700, 530000, ',0,530000,', '丽江市', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530701, 530700, ',0,530000,530700,', '市辖区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530702, 530700, ',0,530000,530700,', '古城区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530721, 530700, ',0,530000,530700,', '玉龙纳西族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530722, 530700, ',0,530000,530700,', '永胜县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530723, 530700, ',0,530000,530700,', '华坪县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530724, 530700, ',0,530000,530700,', '宁蒗彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530800, 530000, ',0,530000,', '普洱市', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530801, 530800, ',0,530000,530800,', '市辖区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530802, 530800, ',0,530000,530800,', '思茅区', '', 30, '6000', '4', 1, '2018-04-11 13:55:29', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530821, 530800, ',0,530000,530800,', '宁洱哈尼族彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530822, 530800, ',0,530000,530800,', '墨江哈尼族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530823, 530800, ',0,530000,530800,', '景东彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530824, 530800, ',0,530000,530800,', '景谷傣族彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530825, 530800, ',0,530000,530800,', '镇沅彝族哈尼族拉祜族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530826, 530800, ',0,530000,530800,', '江城哈尼族彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530827, 530800, ',0,530000,530800,', '孟连傣族拉祜族佤族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530828, 530800, ',0,530000,530800,', '澜沧拉祜族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530829, 530800, ',0,530000,530800,', '西盟佤族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530900, 530000, ',0,530000,', '临沧市', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530901, 530900, ',0,530000,530900,', '市辖区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530902, 530900, ',0,530000,530900,', '临翔区', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530921, 530900, ',0,530000,530900,', '凤庆县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530922, 530900, ',0,530000,530900,', '云县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:13', '', 0);
INSERT INTO `sys_area` VALUES (530923, 530900, ',0,530000,530900,', '永德县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (530924, 530900, ',0,530000,530900,', '镇康县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (530925, 530900, ',0,530000,530900,', '双江拉祜族佤族布朗族傣族自治县', '', 30, '6000', '4', 1, '2018-06-27 15:39:36', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (530926, 530900, ',0,530000,530900,', '耿马傣族佤族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (530927, 530900, ',0,530000,530900,', '沧源佤族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532300, 530000, ',0,530000,', '楚雄彝族自治州', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532301, 532300, ',0,530000,532300,', '楚雄市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532322, 532300, ',0,530000,532300,', '双柏县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532323, 532300, ',0,530000,532300,', '牟定县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532324, 532300, ',0,530000,532300,', '南华县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532325, 532300, ',0,530000,532300,', '姚安县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532326, 532300, ',0,530000,532300,', '大姚县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532327, 532300, ',0,530000,532300,', '永仁县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532328, 532300, ',0,530000,532300,', '元谋县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532329, 532300, ',0,530000,532300,', '武定县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532331, 532300, ',0,530000,532300,', '禄丰县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532500, 530000, ',0,530000,', '红河哈尼族彝族自治州', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532501, 532500, ',0,530000,532500,', '个旧市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532502, 532500, ',0,530000,532500,', '开远市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532503, 532500, ',0,530000,532500,', '蒙自市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532504, 532500, ',0,530000,532500,', '弥勒市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532523, 532500, ',0,530000,532500,', '屏边苗族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532524, 532500, ',0,530000,532500,', '建水县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532525, 532500, ',0,530000,532500,', '石屏县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532527, 532500, ',0,530000,532500,', '泸西县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532528, 532500, ',0,530000,532500,', '元阳县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532529, 532500, ',0,530000,532500,', '红河县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532530, 532500, ',0,530000,532500,', '金平苗族瑶族傣族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532531, 532500, ',0,530000,532500,', '绿春县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532532, 532500, ',0,530000,532500,', '河口瑶族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:15', '', 0);
INSERT INTO `sys_area` VALUES (532600, 530000, ',0,530000,', '文山壮族苗族自治州', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532621, 532600, ',0,530000,532600,', '文山市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532622, 532600, ',0,530000,532600,', '砚山县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532623, 532600, ',0,530000,532600,', '西畴县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532624, 532600, ',0,530000,532600,', '麻栗坡县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532625, 532600, ',0,530000,532600,', '马关县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532626, 532600, ',0,530000,532600,', '丘北县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532627, 532600, ',0,530000,532600,', '广南县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532628, 532600, ',0,530000,532600,', '富宁县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532800, 530000, ',0,530000,', '西双版纳傣族自治州', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532801, 532800, ',0,530000,532800,', '景洪市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532822, 532800, ',0,530000,532800,', '勐海县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532823, 532800, ',0,530000,532800,', '勐腊县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532900, 530000, ',0,530000,', '大理白族自治州', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532901, 532900, ',0,530000,532900,', '大理市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532922, 532900, ',0,530000,532900,', '漾濞彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532923, 532900, ',0,530000,532900,', '祥云县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532924, 532900, ',0,530000,532900,', '宾川县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532925, 532900, ',0,530000,532900,', '弥渡县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532926, 532900, ',0,530000,532900,', '南涧彝族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532927, 532900, ',0,530000,532900,', '巍山彝族回族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532928, 532900, ',0,530000,532900,', '永平县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532929, 532900, ',0,530000,532900,', '云龙县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532930, 532900, ',0,530000,532900,', '洱源县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532931, 532900, ',0,530000,532900,', '剑川县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (532932, 532900, ',0,530000,532900,', '鹤庆县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (533100, 530000, ',0,530000,', '德宏傣族景颇族自治州', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (533102, 533100, ',0,530000,533100,', '瑞丽市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (533103, 533100, ',0,530000,533100,', '芒市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (533122, 533100, ',0,530000,533100,', '梁河县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:17', '', 0);
INSERT INTO `sys_area` VALUES (533123, 533100, ',0,530000,533100,', '盈江县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533124, 533100, ',0,530000,533100,', '陇川县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533300, 530000, ',0,530000,', '怒江傈僳族自治州', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533301, 533300, ',0,530000,533300,', '泸水县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533323, 533300, ',0,530000,533300,', '福贡县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533324, 533300, ',0,530000,533300,', '贡山独龙族怒族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533325, 533300, ',0,530000,533300,', '兰坪白族普米族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533400, 530000, ',0,530000,', '迪庆藏族自治州', '', 30, '6000', '3', 1, '2016-08-15 11:09:03', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533401, 533400, ',0,530000,533400,', '香格里拉市', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533422, 533400, ',0,530000,533400,', '德钦县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533423, 533400, ',0,530000,533400,', '维西傈僳族自治县', '', 30, '6000', '4', 1, '2016-08-15 13:46:21', 1, '2018-12-22 10:53:19', '', 0);
INSERT INTO `sys_area` VALUES (533424, 530000, ',0,530000,', '测试1', '测试1', 1, '1008', NULL, 1, '2018-12-21 17:47:17', 1, '2018-12-22 10:53:09', NULL, 0);
INSERT INTO `sys_area` VALUES (533425, 533424, ',0,530000,533424,', '测试21', '测试2', 11, '1002', NULL, 1, '2018-12-21 17:47:55', 1, '2018-12-22 10:53:09', NULL, 0);
INSERT INTO `sys_area` VALUES (533427, 533424, ',0,530000,533424,', '测试22', '测试22', 212, '22342', NULL, 1, '2018-12-22 09:45:55', 1, '2018-12-22 10:54:29', NULL, 0);
INSERT INTO `sys_area` VALUES (533432, 533425, ',0,530000,533424,533425,', '123', '123', 12, '123', NULL, 1, '2018-12-23 03:15:47', NULL, NULL, NULL, 0);

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `param_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'key',
  `param_value` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态   0：隐藏   1：显示',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `param_key`(`param_key`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES (1, NULL, 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":1,\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"qiniuBucketName\":\"ios-app\",\"aliyunDomain\":\"\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"\",\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\"}', 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_config` VALUES (2, NULL, '12', '12', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_config` VALUES (4, NULL, 'test2', '12', 1, 1, '2018-09-29 12:00:10', NULL, NULL, '12', 0);
INSERT INTO `sys_config` VALUES (6, NULL, 'sys', '{\"systemTitle\":\"溯源系统\",\"copyright\":\"Copyright @ 2018 德宏农业科技有限公司.\"}', 1, 1, '2019-04-17 10:53:39', 1, '2019-04-17 11:21:44', NULL, 0);
INSERT INTO `sys_config` VALUES (7, NULL, 'host', 'http://21u697519k.iok.la', 1, 1, '2019-04-17 11:49:21', NULL, NULL, NULL, 0);
INSERT INTO `sys_config` VALUES (8, NULL, 'SYS_USER_INIT', '{\"userPwd\":\"123456\",\"userRoles\":\"10\"}', 1, 1, '2020-03-03 22:52:24', 1, '2020-03-13 15:07:25', NULL, 0);

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint(20) NOT NULL COMMENT '上级部门ID，一级部门为0',
  `parent_ids` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所有父级编号',
  `area_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '区域id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `order_num` bigint(11) NULL DEFAULT NULL COMMENT '排序',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `type_value` bigint(11) NULL DEFAULT NULL COMMENT '类型值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 533424 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES (530000, 0, ',0,', '530000', '测试', 10, 0, NULL, NULL, 1, '2018-12-22 09:41:53', NULL, 1);

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典标签',
  `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典键值',
  `css_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表格回显样式',
  `is_default` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `order_num` bigint(20) NULL DEFAULT 0 COMMENT '字典排序',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES (1, 'sys_user_sex', '男', '0', '', '', 'Y', '0', 1, NULL, NULL, 1, '2019-04-29 15:34:30', NULL, 0);
INSERT INTO `sys_dict_data` VALUES (2, 'sys_user_sex', '女', '1', '', '', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (3, 'sys_user_sex', '未知', '2', '', '', 'N', '0', 3, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (4, 'sys_show_hide', '显示', '0', '', 'primary', 'Y', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (5, 'sys_show_hide', '隐藏', '1', '', 'danger', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (6, 'sys_normal_disable', '正常', '0', '', 'primary', 'Y', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (7, 'sys_normal_disable', '停用', '1', '', 'danger', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (8, 'sys_job_status', '正常', '0', '', 'primary', 'Y', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (9, 'sys_job_status', '暂停', '1', '', 'danger', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (10, 'sys_yes_no', '是', '1', '', 'primary', 'Y', '0', 1, NULL, NULL, 1, '2019-04-29 17:51:51', NULL, 0);
INSERT INTO `sys_dict_data` VALUES (11, 'sys_yes_no', '否', '0', '', 'default', 'N', '0', 2, NULL, NULL, 1, '2019-04-29 17:51:58', NULL, 0);
INSERT INTO `sys_dict_data` VALUES (12, 'sys_notice_type', '通知', '1', '', 'warning', 'Y', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (13, 'sys_notice_type', '公告', '2', '', 'success', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (14, 'sys_notice_status', '正常', '0', '', 'primary', 'Y', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (15, 'sys_notice_status', '关闭', '1', '', 'danger', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (16, 'sys_oper_type', '新增', '1', '', 'info', 'N', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (17, 'sys_oper_type', '修改', '2', '', 'info', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (18, 'sys_oper_type', '删除', '3', '', 'danger', 'N', '0', 3, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (19, 'sys_oper_type', '授权', '4', '', 'primary', 'N', '0', 4, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (20, 'sys_oper_type', '导出', '5', '', 'warning', 'N', '0', 5, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (21, 'sys_oper_type', '导入', '6', '', 'warning', 'N', '0', 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (22, 'sys_oper_type', '强退', '7', '', 'danger', 'N', '0', 7, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (23, 'sys_oper_type', '生成代码', '8', '', 'warning', 'N', '0', 8, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (24, 'sys_oper_type', '清空数据', '9', '', 'danger', 'N', '0', 8, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (25, 'sys_common_status', '成功', '0', '', 'primary', 'N', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (26, 'sys_common_status', '失败', '1', '', 'danger', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (27, 'wit_org_fund_source', '有国外资金背景', '1', '', 'primary', 'N', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (28, 'wit_org_fund_source', '无国外资金背景', '0', '', 'primary', 'N', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (31, 'diy_category_type', '单数据', '1', '', 'danger', 'N', '0', 1, NULL, NULL, 1, '2019-04-29 13:42:21', NULL, 0);
INSERT INTO `sys_dict_data` VALUES (32, 'diy_category_type', '多数据', '2', '', 'success', 'N', '0', 2, NULL, NULL, 1, '2019-04-29 13:42:28', NULL, 0);
INSERT INTO `sys_dict_data` VALUES (33, 'diy_category_type', '不限', '3', '', 'primary', 'N', '0', 3, NULL, NULL, 1, '2019-04-29 13:42:34', NULL, 0);
INSERT INTO `sys_dict_data` VALUES (36, 'diy_attribute_type', '数字', '1', NULL, 'primary', '0', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (37, 'diy_attribute_type', '日期', '2', NULL, 'info', '0', '0', 3, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (38, 'diy_attribute_type', '长文本', '3', NULL, 'warning', '0', '0', 4, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (39, 'diy_attribute_type', '短文本', '4', NULL, 'danger', '0', '0', 5, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (40, 'diy_attribute_type', '图片', '5', NULL, 'default', '0', '0', 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (41, 'diy_attribute_type', '视频', '6', NULL, 'primary', '0', '0', 7, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (42, 'diy_attribute_type', '语音', '7', NULL, 'success', '0', '0', 8, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (43, 'diy_attribute_type', '单列下拉', '8', NULL, 'info', '0', '0', 9, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (48, 'sys_dict_style', '默认', 'default', '', '', '1', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (49, 'sys_dict_style', '主要', 'primary', '', '', '0', '0', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (50, 'sys_dict_style', '成功', 'success', '', '', '0', '0', 3, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (51, 'sys_dict_style', '信息', 'info', '', '', '0', '0', 4, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (52, 'sys_dict_style', '警告', 'warning', '', '', '0', '0', 5, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (53, 'sys_dict_style', '危险', 'danger', '', '', '0', '0', 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (58, 'sys_user_sex', '非男', '4', '', 'warning', 'N', '0', 10, 1, '2019-04-29 16:49:27', NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (59, 'diy_attribute_type', '文本', '0', NULL, 'success', '0', '0', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (60, 'diy_attribute_type', '多列下拉-区域', '9', NULL, 'warning', '0', '0', 10, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (61, 'diy_attribute_type', '多列下拉-日期', '10', NULL, 'success', '0', '0', 11, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (62, 'app_resume_type', '互联网工程师', '1', '', 'default', '1', '0', 10, 1, '2019-04-29 19:27:07', NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (63, 'app_resume_type', '2', '服务行业', '', 'default', '0', '0', 20, 1, '2019-04-29 19:27:26', NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (64, 'sys_user_sex', '11', '11', '11', 'primary', '0', '1', 11, 1, '2019-04-29 19:40:38', NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (65, 'sys_file_type', '系统文件', '0', '', 'default', '1', '0', 1, 1, '2019-05-02 11:34:51', NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_data` VALUES (66, 'sys_file_type', '微信文件', '1', '', 'primary', '1', '0', 1, 1, '2019-05-02 11:35:11', NULL, NULL, NULL, 0);

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典名称',
  `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型',
  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `dict_type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES (1, NULL, 'sys_user_sex', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (2, NULL, 'sys_show_hide', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (3, NULL, 'sys_normal_disable', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (4, NULL, 'sys_job_status', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (5, NULL, 'sys_yes_no', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (6, NULL, 'sys_notice_type', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (7, NULL, 'sys_notice_status', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (8, NULL, 'sys_oper_type', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (9, NULL, 'sys_common_status', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (10, NULL, 'wit_org_fund_source', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (11, NULL, 'wit_yes_no', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (12, NULL, 'wit_status', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (13, NULL, 'wit_del_flag', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (14, NULL, 'diy_attribute_type', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (15, NULL, 'wit_clue_status', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (16, NULL, 'wit_procuratorate', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (17, NULL, 'wit_person_type', '0', NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_dict_type` VALUES (18, '简历类型', 'app_resume_type', '0', 1, '2019-04-29 19:25:16', NULL, NULL, '简历类型', 0);
INSERT INTO `sys_dict_type` VALUES (19, '字典样式', 'sys_dict_style', '0', 1, '2019-04-29 19:34:42', NULL, NULL, '字典样式', 0);
INSERT INTO `sys_dict_type` VALUES (20, '系统在线文件类型', 'sys_file_type', '0', 1, '2019-05-02 11:34:00', NULL, NULL, '系统在线文件类型', 0);

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求方法',
  `params_str` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
  `create_by` bigint(11) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(11) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 838 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `parent_ids` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所有父级编号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(1) NULL DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `is_hide` int(1) NOT NULL DEFAULT 0 COMMENT '菜单显示控制     0：显示   其他：影藏',
  `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `order_num` bigint(11) NULL DEFAULT NULL COMMENT '排序',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 382 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, 0, '', '系统管理', NULL, NULL, 0, 0, 'fa fa-cog', 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (2, 1, '', '用户管理', 'modules/sys/user.html', 'sys:dict:listByType,tp:teacher:select,tp:student:select', 1, 0, 'fa fa-user', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (3, 1, '', '角色管理', 'modules/sys/role.html', NULL, 1, 0, 'fa fa-user-secret', 2, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (4, 1, '', '菜单管理', 'modules/sys/menu.html', NULL, 1, 0, 'fa fa-th-list', 3, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (5, 1, '', 'SQL监控', '/druid/sql.html', NULL, 1, 0, 'fa fa-bug', 4, NULL, NULL, 1, '2019-01-03 22:39:39', NULL, 0);
INSERT INTO `sys_menu` VALUES (15, 2, '', '查看', NULL, 'sys:user:list,sys:user:info', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '', '新增', NULL, 'sys:user:save,sys:role:select', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '', '修改', NULL, 'sys:user:update,sys:role:select', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '', '删除', NULL, 'sys:user:delete', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (19, 3, '', '查看', NULL, 'sys:role:list,sys:role:info', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (20, 3, '', '新增', NULL, 'sys:role:save,sys:menu:perms', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (21, 3, '', '修改', NULL, 'sys:role:update,sys:menu:perms', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (22, 3, '', '删除', NULL, 'sys:role:delete', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '', '查看', NULL, 'sys:menu:list,sys:menu:info', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '', '新增', NULL, 'sys:menu:save,sys:menu:select', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '', '修改', NULL, 'sys:menu:update,sys:menu:select', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '', '删除', NULL, 'sys:menu:delete', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (27, 1, '', '参数管理', 'modules/sys/config.html', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 0, 'fa fa-sun-o', 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (29, 1, '', '系统日志', 'modules/sys/log.html', 'sys:log:list', 1, 0, 'fa fa-file-text-o', 7, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (30, 1, '', '文件管理', '/webjars/static/ckfinder/ckfinder.html', NULL, 1, 0, 'fa fa-file-image-o', 6, NULL, NULL, 1, '2019-01-04 08:59:14', NULL, 0);
INSERT INTO `sys_menu` VALUES (31, 1, '', '组织机构', 'modules/sys/dept.html', NULL, 1, 0, 'fa fa-file-code-o', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (32, 31, '', '查看', NULL, 'sys:dept:list,sys:dept:info', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (33, 31, '', '新增', NULL, 'sys:dept:save,sys:dept:select', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (34, 31, '', '修改', NULL, 'sys:dept:update,sys:dept:select', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (35, 31, '', '删除', NULL, 'sys:dept:delete', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (61, 1, '', '行政区划', 'modules/sys/sysarea.html', NULL, 1, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (62, 61, '', '新增', NULL, 'SysAreaController:save', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (65, 61, '', '列表', NULL, 'SysAreaController:list', 2, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (142, 61, '', '修改', NULL, 'SysAreaController:update', 2, 0, NULL, 0, 1, '2018-09-11 11:51:42', NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (143, 61, '', '删除', NULL, 'SysAreaController:del', 2, 0, NULL, 0, 1, '2018-09-11 11:52:15', NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (215, 256, NULL, '分类表', 'modules/diy/category.html', NULL, 1, 0, 'fa fa-file-code-o', 6, NULL, NULL, 1, '2018-12-22 20:30:15', NULL, 0);
INSERT INTO `sys_menu` VALUES (216, 215, NULL, '查看', NULL, 'CategoryController:list,CategoryController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (217, 215, NULL, '新增', NULL, 'CategoryController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (218, 215, NULL, '修改', NULL, 'CategoryController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (219, 215, NULL, '删除', NULL, 'CategoryController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (220, 215, NULL, '导入', NULL, 'CategoryController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (221, 215, NULL, '导出', NULL, 'CategoryController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (222, 215, NULL, '模板', NULL, 'CategoryController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (223, 256, NULL, '字表段', 'modules/diy/attribute.html', NULL, 1, 1, 'fa fa-file-code-o', 6, NULL, NULL, 1, '2019-01-05 16:01:21', NULL, 0);
INSERT INTO `sys_menu` VALUES (224, 223, NULL, '查看', NULL, 'AttributeController:list,AttributeController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (225, 223, NULL, '新增', NULL, 'AttributeController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (226, 223, NULL, '修改', NULL, 'AttributeController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (227, 223, NULL, '删除', NULL, 'AttributeController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (228, 223, NULL, '导入', NULL, 'AttributeController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (229, 223, NULL, '导出', NULL, 'AttributeController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (230, 223, NULL, '模板', NULL, 'AttributeController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (231, 256, NULL, '基础表', 'modules/diy/baseinfo.html', NULL, 1, 1, 'fa fa-file-code-o', 6, NULL, NULL, 1, '2019-01-05 16:01:32', NULL, 0);
INSERT INTO `sys_menu` VALUES (232, 231, NULL, '查看', NULL, 'BaseInfoController:list,BaseInfoController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (233, 231, NULL, '新增', NULL, 'BaseInfoController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (234, 231, NULL, '修改', NULL, 'BaseInfoController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (235, 231, NULL, '删除', NULL, 'BaseInfoController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (236, 231, NULL, '导入', NULL, 'BaseInfoController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (237, 231, NULL, '导出', NULL, 'BaseInfoController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (238, 231, NULL, '模板', NULL, 'BaseInfoController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (247, 256, NULL, '字段值表', 'modules/diy/json.html', NULL, 1, 1, 'fa fa-file-code-o', 6, NULL, NULL, 1, '2019-01-05 16:01:40', NULL, 0);
INSERT INTO `sys_menu` VALUES (248, 247, NULL, '查看', NULL, 'JsonController:list,JsonController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (249, 247, NULL, '新增', NULL, 'JsonController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (250, 247, NULL, '修改', NULL, 'JsonController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (251, 247, NULL, '删除', NULL, 'JsonController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (252, 247, NULL, '导入', NULL, 'JsonController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (253, 247, NULL, '导出', NULL, 'JsonController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (254, 247, NULL, '模板', NULL, 'JsonController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (255, 0, ',0,', '应用模块', NULL, NULL, 0, 0, 'fa fa-database', 1, 1, '2018-12-22 20:27:32', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (256, 0, ',0,', '工具模块', NULL, NULL, 0, 0, 'fa fa-diamond', 2, 1, '2018-12-22 20:28:20', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (257, 255, ',0,255,', '自定义模块', NULL, NULL, 0, 0, 'fa fa-circle-o', 0, 1, '2018-12-22 20:32:29', NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (262, 255, NULL, '产品二维码数据表', 'modules/qr/productionqr.html', NULL, 1, 0, 'fa fa-file-code-o', 6, NULL, NULL, 1, '2018-12-28 22:04:25', NULL, 1);
INSERT INTO `sys_menu` VALUES (263, 262, NULL, '查看', NULL, 'ProductionQrController:list,ProductionQrController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (264, 262, NULL, '新增', NULL, 'ProductionQrController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (265, 262, NULL, '修改', NULL, 'ProductionQrController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (266, 262, NULL, '删除', NULL, 'ProductionQrController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (267, 262, NULL, '导入', NULL, 'ProductionQrController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (268, 262, NULL, '导出', NULL, 'ProductionQrController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (269, 262, NULL, '模板', NULL, 'ProductionQrController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (273, 262, ',0,', '生成二维码', NULL, 'ProductionQrController:generate', 2, 0, 'fa fa-circle-o', 0, 1, '2018-12-29 20:00:36', NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (281, 257, ',0,255,257,', '测试分类100', 'modules/diy/baseinfo.html?categoryId=15', 'CategoryController:save', 1, 0, 'fa fa-adjust', 100, 1, '2018-12-31 16:00:39', 1, '2019-01-04 15:45:21', NULL, 0);
INSERT INTO `sys_menu` VALUES (282, 255, ',0,255,', '二维码链接', NULL, NULL, 0, 0, 'fa fa-qrcode', 1, 1, '2018-12-31 19:31:46', NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (283, 282, ',0,255,282,', '西瓜链接', '/webjars/static/qr/productionQr_detail.html?detail=54', 'ProductionQrController:save', 1, 0, NULL, 0, 1, '2018-12-31 20:05:23', 1, '2019-01-03 22:42:20', NULL, 1);
INSERT INTO `sys_menu` VALUES (284, 282, ',0,255,282,', '辣椒链接', '/webjars/static/qr/productionQr_detail.html?detail=55', 'ProductionQrController:save', 1, 0, NULL, 2, 1, '2018-12-31 20:06:05', 1, '2019-01-03 22:42:36', NULL, 1);
INSERT INTO `sys_menu` VALUES (285, 282, ',0,255,282,', '土豆链接', '/webjars/static/qr/productionQr_detail.html?detail=57', 'ProductionQrController:save', 1, 0, NULL, 2, 1, '2018-12-31 20:06:38', 1, '2019-01-03 22:42:47', NULL, 1);
INSERT INTO `sys_menu` VALUES (310, 0, ',0,', '测试模块', NULL, NULL, 0, 1, 'glyphicon glyphicon-move', 4, 1, '2018-12-31 20:39:18', 1, '2019-01-05 16:06:56', NULL, 0);
INSERT INTO `sys_menu` VALUES (314, 1, NULL, '分类管理', 'modules/app/samplingcategory.html', NULL, 1, 1, 'fa fa-file-code-o', 6, NULL, NULL, 1, '2019-04-29 19:12:26', NULL, 1);
INSERT INTO `sys_menu` VALUES (315, 314, NULL, '查看', NULL, 'SamplingCategoryController:list,SamplingCategoryController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (316, 314, NULL, '新增', NULL, 'SamplingCategoryController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (317, 314, NULL, '修改', NULL, 'SamplingCategoryController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (318, 314, NULL, '删除', NULL, 'SamplingCategoryController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (319, 314, NULL, '导入', NULL, 'SamplingCategoryController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (320, 314, NULL, '导出', NULL, 'SamplingCategoryController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (321, 314, NULL, '模板', NULL, 'SamplingCategoryController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (336, 335, NULL, '查看', NULL, 'TimeLineController:list,TimeLineController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (337, 335, NULL, '新增', NULL, 'TimeLineController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (338, 335, NULL, '修改', NULL, 'TimeLineController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (339, 335, NULL, '删除', NULL, 'TimeLineController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (340, 335, NULL, '导入', NULL, 'TimeLineController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (341, 335, NULL, '导出', NULL, 'TimeLineController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (342, 335, NULL, '模板', NULL, 'TimeLineController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (343, 255, ',0,255,', '时间轴详情', '/webjars/static/timeline/index_my.html?userId=1', NULL, 1, 0, 'fa fa-circle-o', 1, 1, '2019-03-05 23:34:47', 1, '2019-03-10 22:05:54', NULL, 1);
INSERT INTO `sys_menu` VALUES (344, 255, ',0,255,', '时间轴富文本', 'modules/app/ueditor_timeline.html', NULL, 1, 0, 'fa fa-circle-o', 0, 1, '2019-03-10 22:34:47', 1, '2019-03-10 22:40:41', NULL, 1);
INSERT INTO `sys_menu` VALUES (345, 1, NULL, '字典数据表', 'modules/sys/dictdata.html', NULL, 1, 1, 'fa fa-file-code-o', 6, NULL, NULL, 1, '2019-04-29 17:07:46', NULL, 0);
INSERT INTO `sys_menu` VALUES (346, 345, NULL, '查看', NULL, 'SysDictDataController:list,SysDictDataController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (347, 345, NULL, '新增', NULL, 'SysDictDataController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (348, 345, NULL, '修改', NULL, 'SysDictDataController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (349, 345, NULL, '删除', NULL, 'SysDictDataController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (350, 345, NULL, '导入', NULL, 'SysDictDataController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (351, 345, NULL, '导出', NULL, 'SysDictDataController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (352, 345, NULL, '模板', NULL, 'SysDictDataController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (353, 1, NULL, '字典管理', 'modules/sys/dicttype.html', NULL, 1, 0, 'fa fa-file-code-o', 6, NULL, NULL, 1, '2019-04-29 17:08:06', NULL, 0);
INSERT INTO `sys_menu` VALUES (354, 353, NULL, '查看', NULL, 'SysDictTypeController:list,SysDictTypeController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (355, 353, NULL, '新增', NULL, 'SysDictTypeController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (356, 353, NULL, '修改', NULL, 'SysDictTypeController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (357, 353, NULL, '删除', NULL, 'SysDictTypeController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (358, 353, NULL, '导入', NULL, 'SysDictTypeController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (359, 353, NULL, '导出', NULL, 'SysDictTypeController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (360, 353, NULL, '模板', NULL, 'SysDictTypeController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (361, 1, NULL, '系统在线文件', 'modules/sys/onlinefile.html', NULL, 1, 0, 'fa fa-file-code-o', 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (362, 361, NULL, '查看', NULL, 'SysOnlineFileController:list,SysOnlineFileController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (363, 361, NULL, '新增', NULL, 'SysOnlineFileController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (364, 361, NULL, '修改', NULL, 'SysOnlineFileController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (365, 361, NULL, '删除', NULL, 'SysOnlineFileController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (366, 361, NULL, '导入', NULL, 'SysOnlineFileController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (367, 361, NULL, '导出', NULL, 'SysOnlineFileController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (368, 361, NULL, '模板', NULL, 'SysOnlineFileController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_menu` VALUES (369, 257, ',0,255,257,', '测试1', 'modules/diy/baseinfo.html?categoryId=26', 'CategoryController:save', 1, 0, NULL, 100, 1, '2020-02-27 19:45:56', 1, '2020-02-27 19:45:56', NULL, 0);
INSERT INTO `sys_menu` VALUES (370, 1, NULL, '房屋记录', 'modules/app/wxhouse.html', NULL, 1, 0, 'fa fa-file-code-o', 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (371, 370, NULL, '查看', NULL, 'WxHouseController:list,WxHouseController:info', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (372, 370, NULL, '新增', NULL, 'WxHouseController:save', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (373, 370, NULL, '修改', NULL, 'WxHouseController:update', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (374, 370, NULL, '删除', NULL, 'WxHouseController:delete', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (375, 370, NULL, '导入', NULL, 'WxHouseController:importExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (376, 370, NULL, '导出', NULL, 'WxHouseController:exportExcel', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (377, 370, NULL, '模板', NULL, 'WxHouseController:template', 2, 0, NULL, 6, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (378, 2, ',0,', '导入', NULL, 'SysUserController:importExcel', 2, 0, 'fa fa-circle-o', 50, 1, '2020-03-13 11:42:19', 1, '2020-03-13 11:42:19', NULL, 0);
INSERT INTO `sys_menu` VALUES (379, 2, ',0,', '导出', NULL, 'SysUserController:exportExcel', 2, 0, 'fa fa-circle-o', 0, 1, '2020-03-13 11:42:46', 1, '2020-03-13 11:42:46', NULL, 0);

-- ----------------------------
-- Table structure for sys_online_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_online_file`;
CREATE TABLE `sys_online_file`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `url` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '图标uri',
  `order_num` bigint(30) NULL DEFAULT NULL COMMENT '排序',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记（0：显示；1：隐藏）',
  `type` int(1) NOT NULL DEFAULT 0 COMMENT '类型<app_file_type>',
  `status` int(1) NOT NULL DEFAULT 0 COMMENT '状态<sys_normal_disable> 0 正常，1 停用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '在线文件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_online_file
-- ----------------------------
INSERT INTO `sys_online_file` VALUES (29, NULL, 'http://47.105.60.135/wisdom/content/aed08cf817d9b0a5f13e75b6f7125f7a.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (30, NULL, 'http://47.105.60.135/wisdom/content/4ccd4d9dc598d9e8ce6c822760d7c48b.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (31, NULL, 'http://47.105.60.135/wisdom/content/32f2e9dba07cc1437f077d8f4013a621.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (32, NULL, 'http://47.105.60.135/wisdom/content/16feb6f8bd671066f7f4420a55634ccd.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (33, NULL, 'http://47.105.60.135/wisdom/content/fe299c9cc423f51620bd799c778be8fc.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (34, NULL, 'http://47.105.60.135/wisdom/content/ef1d1126b58b62c9d844188eacf4e6dd.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (35, NULL, 'http://47.105.60.135/wisdom/content/c155ddae03d4361adaa10c82c4605df4.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (36, NULL, 'http://47.105.60.135/wisdom/content/2d6ba85b2ee336f5aba1f7f13bf22b0c.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (37, NULL, 'http://47.105.60.135/wisdom/content/e6f768ad1ebe5897568059e600710c77.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (38, NULL, 'http://47.105.60.135/wisdom/content/a91081e8be1ebf938da32348fcfd0d81.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (39, NULL, 'http://47.105.60.135/wisdom/content/0bf87d7e0f3fa07ad11ab1c0e93bbeb0.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (42, NULL, 'http://47.105.60.135/wisdom/content/9836fd315cace3ef2283b90c0e21006d.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (43, NULL, 'http://47.105.60.135/wisdom/content/8189e17ab9471649f6600c17e897835e.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (44, NULL, 'http://47.105.60.135/wisdom/content/f8efc39ca5d2171add117475df4be7fb.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (45, NULL, 'http://47.105.60.135/wisdom/content/859a2454d0fce26ab0c5e7f808ce8b40.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (46, NULL, 'http://47.105.60.135/wisdom/content/6d6b6d2ee61553d1a2d6bd16c1a9800e.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (47, '11', 'http://127.0.0.1:8446/static/files/sys/jpg/20190502/94016487735894/e2.jpg', 11, 1, '2019-05-02 11:41:27', NULL, NULL, '11', 1, 0, 0);
INSERT INTO `sys_online_file` VALUES (48, 'aaa11', 'http://127.0.0.1:8446/static/files/sys/jpg/20190502/97403181046115/e.jpg', 21, 1, '2019-05-02 12:25:19', 1, '2019-05-02 12:37:54', '1211', 1, 1, 1);

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  `role_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (10, 1, '2018-09-20 17:11:07', 1, '2020-03-03 22:13:12', '备注', 1, 6, '基础权限', NULL);
INSERT INTO `sys_role` VALUES (19, 1, '2018-12-31 01:06:44', 1, '2019-01-05 09:48:40', NULL, 1, 533100, '用户', NULL);
INSERT INTO `sys_role` VALUES (20, 1, '2020-03-03 22:14:27', 1, '2020-03-03 22:14:27', NULL, 1, NULL, '五华盘龙数据权限', NULL);
INSERT INTO `sys_role` VALUES (21, 1, '2020-03-03 22:15:13', 1, '2020-03-03 22:40:54', NULL, 1, NULL, '官渡西山数据权限', NULL);
INSERT INTO `sys_role` VALUES (22, 1, '2020-03-03 22:47:56', 1, '2020-03-03 22:47:56', NULL, 1, NULL, '昆明数据权限', NULL);

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与部门对应关系' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1612 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与菜单对应关系' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '盐',
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  `user_type` bigint(20) NULL DEFAULT NULL COMMENT '用户类型:0:系统用户、1:教师、2:学生(同数据字典)',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  `full_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全名',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `user_info_id` bigint(20) NULL DEFAULT NULL COMMENT '用户信息id,当用户类型为教师、学生时，对应teacher_id/student_id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 62 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', '1fdca6a7bed734f676cb375142c0e498835741cc00a185340cc8eea8cccb9788', 'bR2KP6ggHUV3YnTa07BY', '[email protected]', '13612345678', 1, 530000, 0, 0, NULL, 1, '2021-01-03 15:19:13', NULL, 0, '管理员', NULL, 0);
INSERT INTO `sys_user` VALUES (56, 'test', '59e88b3fe2ca1013e73d1906f1668bdc32c12fe16827f31e0332e85ddefb81ce', '2Cq1DmU79kdPhICqCtdD', '[email protected]', '11111111111', 1, 530000, NULL, 1, '2018-11-30 22:54:27', NULL, NULL, NULL, 1, 'test', NULL, NULL);
INSERT INTO `sys_user` VALUES (57, 'tcl', '708804fbf799d269267582df2485b78a9873383f416f8067866c3eafedd67be2', '5U0rtkv3dPG7WrJAo31h', '[email protected]', '12345678901', 1, 530000, NULL, 1, '2018-12-01 21:41:55', 1, '2018-12-31 01:07:42', NULL, 1, '陶春良', NULL, NULL);
INSERT INTO `sys_user` VALUES (58, 'guandu', '1192e5fafd1e4e1ca9e5728cc44f96f7827ce8a58183130cc9679eeaa41bb8be', 'YR1BQ8u2CayDoaBSqDH6', '[email protected]', '18270914333', 1, 530111, 0, 1, '2019-04-19 21:03:43', 1, '2020-03-03 22:17:18', NULL, 1, '官渡测试数据权限', NULL, NULL);
INSERT INTO `sys_user` VALUES (59, 'wuhua', '682845782add1d71f9f6f46f513747809615863589dd973bec44d6581deb183d', 'khmtZ1ufNqlrwVh6mMo9', '[email protected]', '18270914311', 1, 530102, 0, 1, '2020-03-03 22:00:04', 1, '2020-03-03 22:16:27', NULL, 1, '五华区测试', NULL, NULL);
INSERT INTO `sys_user` VALUES (60, 'km', '62a52aa51c67eadbc6625619867cc0eb1e529e01f428a1a9cf543d8474c85e81', 'AUJdI7g1f037fR4gYGOl', '[email protected]', '18270914379', 1, 530000, 0, 1, '2020-03-03 22:49:12', 1, '2020-03-03 22:49:12', NULL, 1, '昆明数据权限测试', NULL, NULL);
INSERT INTO `sys_user` VALUES (61, 'km1', '43d9fbaadd5a76c8a52a52b99672b8f75adf3a9d15a02bff944fbc91d2eb1d82', 'dVLhgQU0A7YjO2zt0fvM', '[email protected]', '18270914379', 1, 530000, 0, 1, '2020-03-13 15:34:54', 1, '2020-03-13 15:34:54', NULL, 1, '昆明数据权限测试', NULL, NULL);

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间 yyyyMMdd HH:mm:ss',
  `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间 yyyyMMdd HH:mm:ss',
  `del_flag` int(1) NULL DEFAULT 0 COMMENT '逻辑删除：0 未删除，1已删除',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 87 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与角色对应关系' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Procedure structure for delTreeNode
-- ----------------------------
DROP PROCEDURE IF EXISTS `delTreeNode`;
delimiter ;;
CREATE DEFINER=`root`@`%` PROCEDURE `delTreeNode`(IN treeTable VARCHAR(200),IN treeId bigint,OUT treeCount BIGINT)
BEGIN
	SET @sqlStmt = CONCAT('update ',treeTable,' set del_flag=1 where  FIND_IN_SET(',treeId,',parent_ids) or id = ',treeId);
			PREPARE stmt FROM @sqlStmt;
			EXECUTE stmt;
			  -- 获取查询影响的行数
    SET @cnt = ROW_COUNT();
    -- 输出影响函数
    SELECT @cnt INTO treeCount ;
		SELECT  treeCount ;
end
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;