dev/2021/2021-002(已归档误提交)/2021-002-ljh-001.sql

use dcp;
/*
 Navicat Premium Data Transfer

 Source Server         : 10.0.1.159_3306
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 10.0.1.159:3306
 Source Schema         : dcp

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

 Date: 11/01/2021 13:49:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for customer_file
-- ----------------------------
DROP TABLE IF EXISTS `customer_file`;
CREATE TABLE `customer_file`  (
                                  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
                                  `file_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
                                  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件地址',
                                  `file_type` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件类型',
                                  `file_name_old` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原始文件名称',
                                  `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
                                  `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
                                  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                                  `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
                                  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
                                  `reserve_one` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
                                  `reserve_two` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
                                  `reserve_three` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
                                  `reserve_four` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
                                  `reserve_five` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
                                  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服模块-文件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for customer_log
-- ----------------------------
DROP TABLE IF EXISTS `customer_log`;
CREATE TABLE `customer_log`  (
                                 `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
                                 `user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',
                                 `login_type` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登陆状态',
                                 `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
                                 `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
                                 `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                                 `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
                                 `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
                                 `reserve_one` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
                                 `reserve_two` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
                                 `reserve_three` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
                                 `reserve_four` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
                                 `reserve_five` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
                                 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服模块-登陆记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for customer_message
-- ----------------------------
DROP TABLE IF EXISTS `customer_message`;
CREATE TABLE `customer_message`  (
                                     `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
                                     `sender_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送人Id',
                                     `sender_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送人名称',
                                     `send_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '发送的数据',
                                     `receiver_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人id',
                                     `receiver_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人名称',
                                     `sending_status` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送状态',
                                     `receiving_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收状态',
                                     `message_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息类型',
                                     `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
                                     `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
                                     `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                                     `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
                                     `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
                                     `reserve_one` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
                                     `reserve_two` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
                                     `reserve_three` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
                                     `reserve_four` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
                                     `reserve_five` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
                                     PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服模块-聊天记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for customer_operation
-- ----------------------------
DROP TABLE IF EXISTS `customer_operation`;
CREATE TABLE `customer_operation`  (
                                       `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键id',
                                       `user_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',
                                       `language` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语言类型',
                                       `model_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块类型',
                                       `model_content` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块内容',
                                       `order_num` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
                                       `operation_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设置类型',
                                       `model_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块名称',
                                       `link_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接地址',
                                       `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片地址',
                                       `status` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
                                       `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
                                       `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                                       `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
                                       `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
                                       `reserve_one` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
                                       `reserve_two` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
                                       `reserve_three` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
                                       `reserve_four` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
                                       `reserve_five` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
                                       PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服模块-聊天记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for customer_quick_reply
-- ----------------------------
DROP TABLE IF EXISTS `customer_quick_reply`;
CREATE TABLE `customer_quick_reply`  (
                                         `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
                                         `sender_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送人Id',
                                         `sender_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送人名称',
                                         `send_content` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送的数据',
                                         `receiver_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人id',
                                         `receiver_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人名称',
                                         `sending_status` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送状态',
                                         `receiving_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收状态',
                                         `message_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息类型',
                                         `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
                                         `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
                                         `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                                         `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
                                         `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
                                         `reserve_one` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
                                         `reserve_two` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
                                         `reserve_three` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
                                         `reserve_four` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
                                         `reserve_five` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
                                         PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服模块-聊天记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for customer_robert_keyword
-- ----------------------------
DROP TABLE IF EXISTS `customer_robert_keyword`;
CREATE TABLE `customer_robert_keyword`  (
                                            `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
                                            `sender_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送人Id',
                                            `sender_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送人名称',
                                            `send_content` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送的数据',
                                            `receiver_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人id',
                                            `receiver_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人名称',
                                            `sending_status` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送状态',
                                            `receiving_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收状态',
                                            `message_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息类型',
                                            `status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
                                            `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
                                            `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                                            `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
                                            `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
                                            `reserve_one` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
                                            `reserve_two` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
                                            `reserve_three` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
                                            `reserve_four` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
                                            `reserve_five` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
                                            PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服模块-聊天记录表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd1c', 'DEFAULT', 'ZH', 'COL', '账号管理', '2', 'FIRSTTISHI', '账号管理', NULL, 'helpCenter/yonghu.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd1d', 'DEFAULT', 'ZH', 'COL', '项目管理', '3', 'FIRSTTISHI', '项目管理', NULL, 'helpCenter/shuji.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd1e', 'DEFAULT', 'ZH', 'COL', '平台问题', '4', 'FIRSTTISHI', '平台问题', NULL, 'helpCenter/diannao.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd1f', 'DEFAULT', 'ZH', 'ML', 'Hi，我是能联全球的智能客服助手“小E”，很高兴为您服务。如您想咨询平台的相关问题，可点击下方快捷问题列表，或者直接问我哦~', '1', 'FIRSTTISHI', '', NULL, 'helpCenter/A.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd2c', 'DEFAULT', 'EN', 'COL', 'Account Management', '2', 'FIRSTTISHI', 'Account Management', NULL, 'helpCenter/yonghu.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd2d', 'DEFAULT', 'EN', 'COL', 'Project Management', '3', 'FIRSTTISHI', 'Project Management', NULL, 'helpCenter/shuji.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd2e', 'DEFAULT', 'EN', 'COL', 'Platform Issues', '4', 'FIRSTTISHI', 'Platform Issues', NULL, 'helpCenter/diannao.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd2f', 'DEFAULT', 'EN', 'ML', 'Hello, you may need the following services (if you need labor, please click the button above to switch to manual):', '1', 'FIRSTTISHI', '', NULL, 'helpCenter/A.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd3f', 'DEFAULT', 'ZH', 'COL', '入会申请', '1', 'QUICKLIST', '入会申请', NULL, '', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd3g', 'DEFAULT', 'ZH', 'COL', '活动报名', '2', 'QUICKLIST', '活动报名', NULL, '', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd3h', 'DEFAULT', 'ZH', 'COL', '忘记密码', '3', 'QUICKLIST', '忘记密码', NULL, '', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec4b79dd3i', 'DEFAULT', 'ZH', 'COL', '入盟申请', '4', 'QUICKLIST', '入盟申请', NULL, '', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec5b79dd31', 'DEFAULT', 'ZH', 'CJ', '会议服务', '1', 'PLATFORMSERVICES', '会议服务', 'conferenceServices', 'helpCenter/discussion3.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec5b79dd3f', 'DEFAULT', 'EN', 'COL', 'Membership Application', '1', 'QUICKLIST', 'Membership Application', NULL, '', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec5b79dd3g', 'DEFAULT', 'EN', 'COL', 'Activity Registration', '2', 'QUICKLIST', 'Activity Registration', NULL, '', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec5b79dd3h', 'DEFAULT', 'EN', 'COL', 'Forget the Password', '3', 'QUICKLIST', 'Forget the Password', NULL, '', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('316b86a640d311eb83f98cec5b79dd3i', 'DEFAULT', 'EN', 'COL', 'Application for Membership', '4', 'QUICKLIST', 'Application for Membership', NULL, '', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('416b86a640d311eb83f98cec5b79dd31', 'DEFAULT', 'ZH', 'CJ', '定制服务', '2', 'PLATFORMSERVICES', '定制服务', 'IntroductionMemberProfile', 'helpCenter/zuanshi.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('416b86a640d311eb83f98cec5b79dd32', 'DEFAULT', 'ZH', 'CJ', '金融服务', '3', 'PLATFORMSERVICES', '金融服务', 'financialServices', 'helpCenter/finance3.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('416b86a640d311eb83f98cec5b79dd33', 'DEFAULT', 'ZH', 'CJ', '资源共享', '4', 'PLATFORMSERVICES', '资源共享', 'resourceSharing', 'helpCenter/share3.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('416b86a640d311eb83f98cec5b79dd34', 'DEFAULT', 'ZH', 'CJ', '会展服务', '5', 'PLATFORMSERVICES', '会展服务', 'http://tour.quanjingke.com/xiangmu/quanqiunengyuan_vtour_v7/index.html', 'helpCenter/Exhibition3.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('516b86a640d311eb83f98cec5b79dd31', 'DEFAULT', 'EN', 'CJ', 'Customized Services', '2', 'PLATFORMSERVICES', 'Customized Services', 'IntroductionMemberProfile', 'helpCenter/zuanshi.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('516b86a640d311eb83f98cec5b79dd32', 'DEFAULT', 'EN', 'CJ', 'Financial Service', '3', 'PLATFORMSERVICES', 'Financial Service', 'financialServices', 'helpCenter/finance3.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('516b86a640d311eb83f98cec5b79dd33', 'DEFAULT', 'EN', 'CJ', 'Resource Sharing', '4', 'PLATFORMSERVICES', 'Resource sharing service', 'resourceSharing', 'helpCenter/share3.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('516b86a640d311eb83f98cec5b79dd34', 'DEFAULT', 'EN', 'CJ', 'Exhibition Service', '5', 'PLATFORMSERVICES', 'Exhibition Service', 'http://tour.quanjingke.com/xiangmu/quanqiunengyuan_vtour_v7/index.html', 'helpCenter/Exhibition3.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('516b86a640d311eb83f98cec5b79dd35', 'DEFAULT', 'EN', 'CJ', 'Conference Services', '1', 'PLATFORMSERVICES', 'Conference Services', 'conferenceServices', 'helpCenter/discussion3.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('616b86a640d311eb83f98cec5b79dd31', 'DEFAULT', 'ZH', 'CJ', '申请入盟', '2', 'QUICKACCESS', '申请入盟', 'IntroductionApplicationMembership', 'helpCenter/quickBackImg2.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('616b86a640d311eb83f98cec5b79dd32', 'DEFAULT', 'ZH', 'CJ', '资助洽商', '3', 'QUICKACCESS', '资助洽商', 'IntroductionMemberProfile?key=custom&dialogVisible2=true', 'helpCenter/quickBackImg3.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('616b86a640d311eb83f98cec5b79dd33', 'DEFAULT', 'ZH', 'CJ', '申请定制服务', '4', 'QUICKACCESS', '申请定制服务', 'IntroductionMemberProfile?key=custom&dialogVisible=true', 'helpCenter/quickBackImg4.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('616b86a640d311eb83f98cec5b79dd34', 'DEFAULT', 'ZH', 'CJ', '申请调研', '5', 'QUICKACCESS', '申请调研', 'resourceSharing', 'helpCenter/quickBackImg5.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('616b86a640d311eb83f98cec5b79dd35', 'DEFAULT', 'ZH', 'CJ', '申请入会', '1', 'QUICKACCESS', '申请入会', 'IntroductionFundingApplication', 'helpCenter/quickBackImg1.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('716b86a640d311eb83f98cec5b79dd31', 'DEFAULT', 'EN', 'CJ', 'Apply for membership', '2', 'QUICKACCESS', 'Apply for membership', 'IntroductionApplicationMembership', 'helpCenter/quickBackImg2.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('716b86a640d311eb83f98cec5b79dd32', 'DEFAULT', 'EN', 'CJ', 'Funding negotiation', '3', 'QUICKACCESS', 'Funding negotiation', 'IntroductionMemberProfile?key=custom&dialogVisible2=true', 'helpCenter/quickBackImg3.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('716b86a640d311eb83f98cec5b79dd33', 'DEFAULT', 'EN', 'CJ', 'Apply for custom service', '4', 'QUICKACCESS', 'Apply for custom service', 'IntroductionMemberProfile?key=custom&dialogVisible=true', 'helpCenter/quickBackImg4.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('716b86a640d311eb83f98cec5b79dd34', 'DEFAULT', 'EN', 'CJ', 'Apply for research', '5', 'QUICKACCESS', 'Apply for research', 'resourceSharing', 'helpCenter/quickBackImg5.png', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `dcp`.`customer_operation`(`id`, `user_id`, `language`, `model_type`, `model_content`, `order_num`, `operation_type`, `model_name`, `link_path`, `image_path`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `reserve_one`, `reserve_two`, `reserve_three`, `reserve_four`, `reserve_five`) VALUES ('716b86a640d311eb83f98cec5b79dd35', 'DEFAULT', 'EN', 'CJ', 'Apply for membership', '1', 'QUICKACCESS', 'Apply for membership', 'IntroductionFundingApplication', 'helpCenter/quickBackImg1.jpg', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

/* 161,159已处理 */