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已处理 */