update.md 101 KB
sql更新记录
注：当前为每次版本升级时涉及到的数据库变更记录
● 密码重置，重制完以后为123456
UPDATE sys_user
SET PASSWORD = 'jTk6muJjbpIDarA1fKPulLHvjwjF+Yv1IrUeJOkU0CEAbfPowtswo0akbokVTl6DMoH8OhDQtXwOAxqrsaAT8A=='
WHERE
user_name = 'admin'
---
---
### ● 日期：2023.06.09
alter table we_qr_code add rule_mode tinyint default 1 null comment '排班方式 1：轮询 2：顺序 3：随机' after rule_type; alter table we_qr_code add open_spare_user tinyint default 0 null comment '开启备用员工 0：否 1：是' after rule_mode; alter table we_qr_scope add scheduling_num int default 0 null comment '排班次数' after status; alter table we_qr_scope add is_spare_user tinyint default 0 null comment '是否备用员工 0：否 1：是' after scheduling_num; alter table we_qr_code add is_exclusive tinyint default 0 null comment '是否开启同一外部企业客户只能添加同一个员工，开启后，同一个企业的客户会优先添加到同一个跟进人 0-不开启 1-开启' after qr_code;
---
---
### ● 日期：2023.06.26
CREATE TABLE we_group_code_range (
id bigint(20) NOT NULL AUTO_INCREMENT,
code_id bigint(20) NOT NULL COMMENT '活码ID',
chat_id varchar(64) NOT NULL COMMENT '群聊ID',
del_flag tinyint(1) DEFAULT '0' COMMENT '0:正常;1:删除;',
create_by varchar(255) DEFAULT NULL COMMENT '创建人',
create_by_id bigint(20) DEFAULT NULL COMMENT '创建人id',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint(20) DEFAULT NULL COMMENT '更新人id',
update_time datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (id),
KEY cha_id_index (code_id,chat_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户群活码范围';
---
---
### ● 日期：2023.07.9
ALTER TABLE we_allocate_customer ADD COLUMN customer_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户名称' AFTER external_userid;
ALTER TABLE we_allocate_customer ADD COLUMN takeover_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接替成员名称' AFTER customer_name;
ALTER TABLE we_allocate_customer ADD COLUMN takeover_dept_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接替成员部门名称' AFTER takeover_name;
ALTER TABLE we_allocate_group ADD COLUMN chat_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客群名称' AFTER chat_id;
ALTER TABLE we_allocate_group ADD COLUMN takeover_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接替员工名称' AFTER chat_name;
ALTER TABLE we_allocate_group ADD COLUMN takeover_dept_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接替员工部门名称' AFTER takeover_name;
ALTER TABLE we_chat_contact_msg MODIFY COLUMN room_id varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '群聊id' AFTER to_list;
ALTER TABLE we_content_view_record MODIFY COLUMN is_customer tinyint(4) NULL DEFAULT 1 COMMENT '是否企业客户 0否1是(当前字段废弃，跟客户表关联查询)' AFTER resource_type;
ALTER TABLE we_content_view_record MODIFY COLUMN external_user_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '外部联系人姓名' AFTER external_user_id;
ALTER TABLE we_form_survey_answer MODIFY COLUMN answer longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '答案' AFTER ip_addr;
CREATE TABLE we_group_code_range (
id bigint(20) NOT NULL AUTO_INCREMENT,
code_id bigint(20) NOT NULL COMMENT '活码ID',
chat_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '群聊ID',
del_flag tinyint(1) NULL DEFAULT 0 COMMENT '0:正常;1:删除;',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
create_by_id bigint(20) NULL DEFAULT NULL COMMENT '创建人id',
create_time datetime NULL DEFAULT NULL COMMENT '创建时间',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
update_by_id bigint(20) NULL DEFAULT NULL COMMENT '更新人id',
update_time datetime NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (id) USING BTREE,
INDEX cha_id_index(code_id, chat_id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客户群活码范围' ROW_FORMAT = Dynamic;
ALTER TABLE we_kf_welcome MODIFY COLUMN content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '欢迎语内容' AFTER type;
ALTER TABLE we_material ADD COLUMN pixel_size bigint(20) NULL DEFAULT NULL COMMENT '像素大小' AFTER poster_qr_type;
ALTER TABLE we_material ADD COLUMN memory_size bigint(20) NULL DEFAULT NULL COMMENT '内存大小' AFTER pixel_size;
ALTER TABLE we_material MODIFY COLUMN width int(11) NULL DEFAULT NULL COMMENT '图片宽（类型为图片时为图片的宽，视频为封面的宽，图文时为封面的宽，小程序为封面的宽，文章时为封面宽，海报时为海报的宽）' AFTER type;
ALTER TABLE we_material MODIFY COLUMN height int(11) NULL DEFAULT NULL COMMENT '图片高（类型为图片时为图片的高，视频为封面的高，图文时为封面的高，小程序为封面的高，文章时为封面高，海报时为海报的高）' AFTER width;
ALTER TABLE we_material MODIFY COLUMN media_type varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源类型(0图片，1语音，2视频，3文件，4文本，5海报，9图文，10链接，11小程序，12文章)' AFTER height;
CREATE TABLE we_moments_attachments (
id bigint(20) NOT NULL COMMENT '主键id',
moments_task_id bigint(20) NOT NULL COMMENT '朋友圈任务id',
is_material tinyint(1) NOT NULL COMMENT '是否内容中心素材: 0不是 1是',
msg_type tinyint(1) NULL DEFAULT NULL COMMENT '附件类型:0图片 1视频 2链接 3位置',
media_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企微素材id,有效期3天',
media_id_expire datetime NULL DEFAULT NULL COMMENT '企微素材id失效时间',
media_id_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '获取企微临时素材后，上传到oss',
thumb_media_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频封面media_id',
thumb_media_id_expire datetime NULL DEFAULT NULL COMMENT '视频封面media_id的失效时间',
thumb_media_id_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频封面media_id的url地址',
link_title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '网页链接标题',
link_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '网页链接url',
location_latitude varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地理位置纬度',
location_longitude varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地理位置经度',
location_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地理位置名称',
material_id bigint(20) NULL DEFAULT NULL COMMENT '素材中心Id',
real_type tinyint(2) NULL DEFAULT NULL COMMENT '真实素材类型',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '朋友圈附件' ROW_FORMAT = Dynamic;
CREATE TABLE we_moments_customer (
id bigint(20) NOT NULL COMMENT '主键id',
moments_task_id bigint(20) NOT NULL COMMENT '朋友圈任务id',
moments_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '朋友圈id',
user_id bigint(20) NOT NULL COMMENT '员工id',
we_user_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企微员工id',
user_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '员工名称',
external_userid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户id',
customer_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户名称',
delivery_status int(11) NULL DEFAULT NULL COMMENT '送达状态 0已送达 1未送达',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
update_by_id bigint(20) NULL DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(20) NULL DEFAULT NULL COMMENT '创建人id',
create_time datetime NULL DEFAULT NULL COMMENT '创建时间',
update_time datetime NULL DEFAULT NULL COMMENT '修改时间',
del_flag tinyint(4) NULL DEFAULT NULL COMMENT '删除标识 0:正常 1:删除',
PRIMARY KEY (id) USING BTREE,
INDEX moments_task_id(moments_task_id, moments_id, user_id, external_userid) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '朋友圈可见客户' ROW_FORMAT = Dynamic;
CREATE TABLE we_moments_estimate_customer (
id bigint(20) NOT NULL COMMENT '主键id',
moments_task_id bigint(20) NOT NULL COMMENT '朋友圈任务id',
user_id bigint(20) NULL DEFAULT NULL COMMENT '员工id',
we_user_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企微员工id',
user_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '员工名称',
external_userid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户id',
customer_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户名称',
PRIMARY KEY (id) USING BTREE,
INDEX moments_task_id(moments_task_id, we_user_id, external_userid) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '预估朋友圈可见客户' ROW_FORMAT = Dynamic;
CREATE TABLE we_moments_estimate_user (
id bigint(20) NOT NULL COMMENT '主键Id',
moments_task_id bigint(20) NOT NULL COMMENT '朋友圈任务id',
user_id bigint(20) NULL DEFAULT NULL COMMENT '员工id',
we_user_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企微员工id',
user_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '员工名称',
dept_id bigint(20) NULL DEFAULT NULL COMMENT '部门id',
dept_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名称',
execute_count int(11) NULL DEFAULT 0 COMMENT '提醒执行次数',
execute_status tinyint(1) NOT NULL COMMENT '执行状态:0未执行，1已执行',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '预估朋友圈执行员工' ROW_FORMAT = Dynamic;
ALTER TABLE we_moments_interacte ADD COLUMN moments_task_id bigint(20) NOT NULL COMMENT '朋友圈任务id' AFTER id;
ALTER TABLE we_moments_interacte ADD COLUMN we_user_id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业发表成员userid' AFTER moment_id;
ALTER TABLE we_moments_interacte MODIFY COLUMN id bigint(11) NOT NULL COMMENT '主键' FIRST;
ALTER TABLE we_moments_interacte MODIFY COLUMN moment_id varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '朋友圈id' AFTER moments_task_id;
CREATE TABLE we_moments_task (
id bigint(20) NOT NULL DEFAULT 0 COMMENT '主键ID',
name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务名称',
type tinyint(1) NOT NULL DEFAULT 0 COMMENT '朋友圈类型:0:企业动态;1:个人动态',
send_type tinyint(1) NOT NULL COMMENT '发送方式: 0企微群发，1个人发送，2成员群发',
is_lw_push tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否是在lw平台发布的:1:是;0:否;',
scope_type tinyint(1) NOT NULL DEFAULT 1 COMMENT '发送范围: 0全部客户 1按条件筛选',
customer_num int(11) NULL DEFAULT 0 COMMENT '朋友圈可见客户数',
dept_ids varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id集合',
post_ids varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '岗位id集合',
user_ids varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '员工id集合',
customer_tag text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '客户标签，多个使用逗号隔开',
content varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '朋友圈部分内容',
execute_time datetime NULL DEFAULT NULL COMMENT '执行时间',
execute_end_time datetime NULL DEFAULT NULL COMMENT '结束时间',
like_tag_ids text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '点赞标签',
comment_tag_ids text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '评论标签',
status tinyint(4) NOT NULL DEFAULT 3 COMMENT '任务状态：1未开始，2进行中，3已结束',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
create_by_id bigint(11) NULL DEFAULT NULL COMMENT '创建人id',
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) NULL DEFAULT NULL COMMENT '更新人id',
update_time datetime NULL DEFAULT NULL COMMENT '修改时间',
del_flag tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识 0:正常 1:删除',
establish_time datetime NULL DEFAULT NULL COMMENT '企微创建时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '朋友圈' ROW_FORMAT = Dynamic;
CREATE TABLE we_moments_task_relation (
id bigint(20) NOT NULL COMMENT '主键id',
moment_task_id bigint(20) NOT NULL COMMENT '朋友圈任务id',
job_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '异步任务id，24小时有效',
job_id_expire datetime NULL DEFAULT NULL COMMENT '异步任务id失效时间',
moment_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '朋友圈id',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '朋友圈任务和企微朋友圈关联表' ROW_FORMAT = Dynamic;
CREATE TABLE we_moments_user (
id bigint(20) NOT NULL COMMENT '主键id',
moments_task_id bigint(20) NOT NULL COMMENT '朋友圈任务id',
moments_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '朋友圈id',
user_id bigint(20) NOT NULL COMMENT '员工id',
we_user_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企微员工id',
user_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '员工名称',
dept_id bigint(20) NULL DEFAULT NULL COMMENT '部门id',
dept_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名称',
execute_status tinyint(1) NOT NULL COMMENT '执行状态:0未执行，1已执行',
execute_count int(11) NOT NULL COMMENT '提醒执行次数',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
update_by_id bigint(20) NULL DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(20) NULL DEFAULT NULL COMMENT '创建人id',
create_time datetime NULL DEFAULT NULL COMMENT '创建时间',
update_time datetime NULL DEFAULT NULL COMMENT '修改时间',
del_flag tinyint(4) NULL DEFAULT NULL COMMENT '删除标识 0:正常 1:删除',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '朋友圈执行员工' ROW_FORMAT = Dynamic;
ALTER TABLE we_msg_tlp ADD COLUMN template_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '欢迎语模版id' AFTER category_id;
ALTER TABLE we_qi_rule_msg MODIFY COLUMN room_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '群聊ID' AFTER receive_id;
DROP TABLE IF EXISTS we_moments;
ALTER TABLE we_allocate_customer ADD COLUMN leave_user_id bigint(20) NULL DEFAULT NULL COMMENT '离职表主键 ' AFTER id;
ALTER TABLE we_allocate_group ADD COLUMN leave_user_id bigint(20) NULL DEFAULT NULL COMMENT '离职表主键' AFTER id;
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2451, '朋友圈管理', 2198, 1, 'list', 'friendCircle/list', 1, 'C', '0', '0', 'friendCircle:list', '#', 'admin', NULL, '2023-07-05 15:27:18', NULL, NULL, NULL, '');
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2452, '任务统计', 2198, 2, 'statistics', 'friendCircle/statistics', 1, 'C', '1', '0', 'friendCircle:statistics', '#', 'admin', NULL, '2023-07-05 15:28:40', NULL, NULL, NULL, '');
UPDATE sys_menu SET menu_name = '员工动态', parent_id = 2198, order_num = 45, path = 'circle', component = 'friendCircle/index', is_frame = 1, menu_type = 'C', visible = '1', status = '0', perms = 'friendCircle:index', icon = 'build', create_by = 'admin_prod', create_by_id = NULL, create_time = '2021-11-24 17:48:12', update_by = 'admin', update_by_id = NULL, update_time = '2023-07-05 15:26:32', remark = '' WHERE menu_id = 2190;
UPDATE sys_menu SET menu_name = '企业动态', parent_id = 2198, order_num = 44, path = 'enterprise', component = 'friendCircle/enterprise', is_frame = 1, menu_type = 'C', visible = '1', status = '0', perms = 'friendCircle:enterprise', icon = 'dict', create_by = 'admin_prod', create_by_id = NULL, create_time = '2021-11-24 17:57:13', update_by = 'admin', update_by_id = NULL, update_time = '2023-07-05 15:26:27', remark = '' WHERE menu_id = 2191;
UPDATE sys_menu SET menu_name = '微信客服', parent_id = 2052, order_num = 4, path = 'customerService', component = NULL, is_frame = 1, menu_type = 'M', visible = '1', status = '0', perms = '', icon = 'wechat', create_by = 'admin_prod', create_by_id = NULL, create_time = '2022-01-09 21:06:51', update_by = 'lw', update_by_id = NULL, update_time = '2023-07-07 16:50:25', remark = '' WHERE menu_id = 2199;
UPDATE sys_menu SET menu_name = '私域洞察', parent_id = 2279, order_num = 2, path = 'operateAnalysis', component = NULL, is_frame = 1, menu_type = 'M', visible = '0', status = '0', perms = '', icon = 'card', create_by = 'admin_prod', create_by_id = NULL, create_time = '2022-01-09 21:46:35', update_by = 'lw', update_by_id = NULL, update_time = '2023-07-09 15:38:06', remark = '' WHERE menu_id = 2204;
UPDATE sys_menu SET menu_name = '场景管理', parent_id = 2199, order_num = 2, path = 'sceneManage', component = 'customerService/sceneManage/index', is_frame = 1, menu_type = 'C', visible = '0', status = '0', perms = 'service:scene:index', icon = 'build', create_by = 'admin_prod', create_by_id = NULL, create_time = '2022-01-10 17:06:42', update_by = 'admin', update_by_id = NULL, update_time = '2023-05-30 13:43:09', remark = '' WHERE menu_id = 2208;
UPDATE sys_menu SET menu_name = '咨询记录', parent_id = 2199, order_num = 3, path = 'searchRecord', component = 'customerService/searchRecord/index', is_frame = 1, menu_type = 'C', visible = '0', status = '0', perms = 'service:search:index', icon = 'checkbox', create_by = 'admin_prod', create_by_id = NULL, create_time = '2022-01-12 14:19:24', update_by = 'admin', update_by_id = NULL, update_time = '2023-05-30 13:43:22', remark = '' WHERE menu_id = 2214;
UPDATE sys_menu SET menu_name = '表单统计', parent_id = 2293, order_num = 3, path = 'smartFormStatistics', component = 'drainageCode/smartForms/statistics/index', is_frame = 1, menu_type = 'C', visible = '1', status = '0', perms = 'drainageCode/smartForms/statistics/index', icon = '#', create_by = 'admin', create_by_id = NULL, create_time = '2022-10-21 16:17:14', update_by = 'admin', update_by_id = NULL, update_time = '2023-05-28 17:05:27', remark = '' WHERE menu_id = 2297;
UPDATE sys_menu SET menu_name = '列表', parent_id = 2002, order_num = 0, path = 'list', component = 'customerManage/customer', is_frame = 1, menu_type = 'C', visible = '1', status = '0', perms = '', icon = '#', create_by = 'admin', create_by_id = NULL, create_time = '2023-02-28 17:50:38', update_by = 'lw', update_by_id = NULL, update_time = '2023-06-12 15:47:42', remark = '' WHERE menu_id = 2372;
UPDATE sys_menu SET menu_name = '商城中心', parent_id = 0, order_num = 8, path = 'microStore/managerShop', component = NULL, is_frame = 1, menu_type = 'M', visible = '0', status = '1', perms = '', icon = '#', create_by = 'admin', create_by_id = NULL, create_time = '2023-03-13 15:43:42', update_by = 'admin', update_by_id = NULL, update_time = '2023-06-19 12:23:41', remark = '' WHERE menu_id = 2408;
UPDATE sys_menu SET menu_name = '{新增}', parent_id = 2443, order_num = 2, path = 'add', component = 'conversation/quality/add', is_frame = 1, menu_type = 'C', visible = '1', status = '0', perms = '', icon = '#', create_by = 'admin', create_by_id = NULL, create_time = '2023-05-26 10:08:42', update_by = 'admin', update_by_id = NULL, update_time = '2023-07-07 14:58:00', remark = '' WHERE menu_id = 2445;
---
### ● 日期：2023.08.22 【线索中心|获客助手】
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2455, '私域孵化', 2366, 2, 'privateIncubation', NULL, 1, 'M', '0', '0', '', '#', 'admin', NULL, '2023-08-07 11:38:36', 'admin', NULL, '2023-08-07 12:16:26', '');
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2456, '线索公海', 2455, 5, 'clueHighseas', NULL, 1, 'M', '0', '0', NULL, '#', 'admin', NULL, '2023-08-07 11:39:09', NULL, NULL, NULL, '');
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2457, '列表', 2456, 5, 'index', 'clue/clueHighseas/index', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-08-07 11:40:11', NULL, NULL, NULL, '');
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2458, '{新增}公海', 2456, 10, 'addEdit', 'clue/clueHighseas/addEdit', 1, 'C', '1', '0', '', '#', 'admin', NULL, '2023-08-07 11:41:01', 'admin', NULL, '2023-08-07 11:41:32', '');
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2459, '公海统计', 2456, 15, 'highseasStatistics', 'clue/clueHighseas/highseasStatistics', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-08-07 11:42:02', NULL, NULL, NULL, '');
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2460, '客户详情', 2456, 20, 'clueDetail', 'clue/clueHighseas/clueDetail', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-08-07 11:42:43', NULL, NULL, NULL, '');
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2461, '线索模板', 2455, 10, 'clueTemplate', 'clue/clueTemplate/index', 1, 'C', '0', '0', NULL, '#', 'admin', NULL, '2023-08-07 11:43:23', NULL, NULL, NULL, '');
UPDATE sys_menu SET menu_name = '老客迁移', parent_id = 2285, order_num = 1, path = 'index', component = 'drainageCode/highSeas/index', is_frame = 1, menu_type = 'C', visible = '0', status = '0', perms = '', icon = '#', create_by = 'admin', create_by_id = NULL, create_time = '2021-08-20 14:20:37', update_by = 'admin', update_by_id = NULL, update_time = '2023-08-18 10:22:24', remark = '' WHERE menu_id = 2187;
UPDATE sys_menu SET menu_name = '迁移分析', parent_id = 2285, order_num = 1, path = 'statistics', component = 'drainageCode/highSeas/statistics', is_frame = 1, menu_type = 'C', visible = '0', status = '0', perms = 'highSeas:statistics', icon = '#', create_by = 'admin_prod', create_by_id = NULL, create_time = '2021-11-21 15:32:40', update_by = 'admin', update_by_id = NULL, update_time = '2023-08-18 10:22:04', remark = '' WHERE menu_id = 2189;
UPDATE sys_menu SET menu_name = '老客孵化', parent_id = 2366, order_num = 3, path = 'highSeas', component = NULL, is_frame = 1, menu_type = 'M', visible = '0', status = '0', perms = '', icon = '#', create_by = 'admin', create_by_id = NULL, create_time = '2022-09-12 23:56:37', update_by = 'admin', update_by_id = NULL, update_time = '2023-08-18 10:22:51', remark = '' WHERE menu_id = 2285;
ALTER TABLE sys_user ADD COLUMN is_open_daily tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启动态日报 0开启，1关闭 默认开启0' AFTER kf_status;
DROP TABLE IF EXIST we_leads_template_settings
CREATE TABLE we_leads_template_settings (
id bigint(20) NOT NULL COMMENT '主键',
table_entry_name varchar(255) NOT NULL COMMENT '表项名称',
table_entry_id varchar(255) NOT NULL COMMENT '表项Id',
table_entry_attr tinyint(4) DEFAULT NULL COMMENT '表项属性 0 填写项 1 下拉项',
data_attr tinyint(4) DEFAULT NULL COMMENT '数据属性 0 文本 1 数字 2 日期',
datetime_type tinyint(4) DEFAULT NULL COMMENT '日期类型 0 日期 1 日期+时间',
max_input_len int(11) DEFAULT NULL COMMENT '输入长度',
can_edit tinyint(4) DEFAULT 0 COMMENT '是否可被编辑 0 可被编辑 1 不可被编辑',
is_required tinyint(1) DEFAULT NULL COMMENT '是否必填项 0选填 1必填',
create_time datetime NOT NULL COMMENT '创建时间',
rank int(255) DEFAULT NULL COMMENT '排序',
update_time datetime DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) NOT NULL COMMENT '创建人',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(11) NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='线索模版配置表';
INSERT INTO we_leads_template_settings VALUES (1678322167884226560, '姓名', 'name', 0, 0, NULL, 10, 1, 1, '2023-07-10 16:36:01', 1, '2023-07-10 16:36:01', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_leads_template_settings VALUES (1679400302667051008, '电话号码', 'phone', 0, 0, NULL, 11, 1, 1, '2023-07-13 16:00:09', 3, '2023-08-03 10:44:50', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_leads_template_settings VALUES (1691634393458208768, '性别', '1691634393122664448', 1, 0, 0, 100, 1, 0, '2023-08-16 10:14:03', 3, '2023-08-16 10:14:03', 'admin', 'admin', 1, 1, 0);
DROP TABLE IF EXIST we_leads_template_table_entry_content
CREATE TABLE we_leads_template_table_entry_content (
id bigint(20) NOT NULL COMMENT '主键Id',
leads_template_settings_id bigint(20) NOT NULL COMMENT '模版表id',
content varchar(255) NOT NULL COMMENT '内容',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='线索模版配置表项内容表';
INSERT INTO we_leads_template_table_entry_content VALUES (1691634393802141696, 1691634393458208768, '男', '2023-08-16 10:14:03', NULL, 0);
INSERT INTO we_leads_template_table_entry_content VALUES (1691634393802141697, 1691634393458208768, '女', '2023-08-16 10:14:03', NULL, 0);
INSERT INTO we_leads_template_table_entry_content VALUES (1679402002626850818, 1691634393458208768, '未知', '2023-07-13 16:06:54', NULL, 0);
DROP TABLE IF EXISTS we_leads_sea;
CREATE TABLE we_leads_sea (
id bigint NOT NULL COMMENT '主键Id',
name varchar(32) DEFAULT NULL COMMENT '公海名称',
is_auto_recovery tinyint DEFAULT NULL COMMENT '是否自动回收（1 表示是，0 表示否）',
num int DEFAULT '0' COMMENT '公海线索数',
first int DEFAULT NULL COMMENT '成员领取线索超过A天未能实现几次跟进，则回收至公海池。且必须在前几天内完成首次跟进。(A)',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) NOT NULL COMMENT '创建人',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint DEFAULT NULL COMMENT '更新人id',
create_by_id bigint NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
version bigint NOT NULL COMMENT '当前规则版本',
PRIMARY KEY (id)
) COMMENT='线索公海';
INSERT INTO we_leads_sea VALUES (1, '默认公海', 0, 0, NULL, '2023-07-14 17:18:41', '2023-07-14 17:18:44', 'admin', 'admin', 1, 1, 0, 0);
DROP TABLE IF EXISTS we_leads_sea_rule_record;
CREATE TABLE we_leads_sea_rule_record (
id bigint NOT NULL COMMENT '主键Id',
sea_id bigint NOT NULL COMMENT '公海id',
is_auto_recovery tinyint NOT NULL COMMENT '是否自动回收（1 表示是，0 表示否）',
first int DEFAULT NULL COMMENT '成员领取线索超过A天未能实现几次跟进，则回收至公海池。且必须在前几天内完成首次跟进。(A)',
version int NOT NULL COMMENT '历史规则版本',
create_time datetime NOT NULL COMMENT '创建时间',
create_by varchar(255) DEFAULT NULL COMMENT '创建人',
create_by_id bigint DEFAULT NULL COMMENT '创建人Id',
PRIMARY KEY (id)
) COMMENT='线索公海规则修改记录';
DROP TABLE IF EXISTS we_leads_sea_visible_range;
CREATE TABLE we_leads_sea_visible_range (
id bigint NOT NULL COMMENT '主键Id',
sea_id bigint NOT NULL COMMENT '公海池Id',
type tinyint NOT NULL COMMENT '类型(0部门 1岗位 2员工)',
data_id varchar(32) DEFAULT NULL COMMENT '数据Id',
data_name varchar(32) DEFAULT NULL COMMENT '数据名称',
is_admin tinyint(1) DEFAULT '0' COMMENT '是否管理员（1是，0否）',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) NOT NULL COMMENT '创建人',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint DEFAULT NULL COMMENT '更新人id',
create_by_id bigint NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
PRIMARY KEY (id)
) COMMENT='公海可见范围';
DROP TABLE IF EXIST we_leads
CREATE TABLE we_leads (
id bigint(20) NOT NULL COMMENT '主键Id',
name varchar(32) NOT NULL COMMENT '姓名',
phone char(11) NOT NULL COMMENT '电话号码',
leads_status tinyint(2) NOT NULL COMMENT '线索状态(0待分配，1跟进中，2已上门，3已退回)',
labels_ids varchar(500) DEFAULT NULL COMMENT '备注标签',
properties text COMMENT '自定义属性',
sea_id bigint(20) DEFAULT NULL COMMENT '所属公海',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) NOT NULL COMMENT '创建人',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
create_by_id bigint(20) NOT NULL COMMENT '创建人id',
update_by_id bigint(20) DEFAULT NULL COMMENT '更新人id',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
follower_id bigint(20) DEFAULT NULL COMMENT '当前跟进人Id',
we_user_id varchar(32) DEFAULT NULL COMMENT '当前跟进人企微Id',
follower_name varchar(32) DEFAULT NULL COMMENT '当前跟进人名称',
dept_id varchar(32) DEFAULT NULL COMMENT '当前跟进人部门Id',
recovery_times int(11) NOT NULL DEFAULT '0' COMMENT '回收次数',
return_reason tinyint(2) DEFAULT NULL COMMENT '末次回收原因',
source tinyint(3) DEFAULT NULL COMMENT '线索来源 0excel导入',
sex tinyint(2) DEFAULT NULL COMMENT ' 性别 0 = 未知, 1 = 男, 2 = 女',
import_record_id bigint(20) DEFAULT NULL COMMENT '导入记录id',
customer_id bigint(20) DEFAULT NULL COMMENT '客户Id',
external_userid varchar(255) DEFAULT NULL COMMENT '客户外部联系人Id',
bind_customer_time datetime NOT NULL COMMENT '绑定客户时间',
PRIMARY KEY (id),
UNIQUE INDEX phone_unique(phone) USING BTREE COMMENT '手机号码索引'
) ENGINE=InnoDB COMMENT='线索';
DROP TABLE IF EXIST we_leads_follower
CREATE TABLE we_leads_follower (
id bigint(20) NOT NULL COMMENT '主键Id',
leads_id bigint(20) NOT NULL COMMENT '线索Id',
follower_id bigint(20) NOT NULL COMMENT '跟进人id',
follower_we_user_id varchar(32) DEFAULT NULL COMMENT '跟进人企微Id',
follower_name varchar(32) NOT NULL COMMENT '跟进人名称',
dept_id bigint(20) DEFAULT NULL COMMENT '跟进人所属部门Id',
dept_name varchar(32) DEFAULT NULL COMMENT '跟进人所属部门名称',
get_type tinyint(2) NOT NULL COMMENT '领取方式（0指定分配，1主动领取，2线索转接）',
follower_status tinyint(2) NOT NULL COMMENT '跟进状态：0已领取，1跟进中，2已上门，3已退回',
return_type tinyint(2) DEFAULT NULL COMMENT '退回方式 0成员主动退回 1超时自动退回 2管理员强制回收 3离职退回',
return_reason varchar(500) DEFAULT NULL COMMENT '退回原因',
assigner_id bigint(20) NULL COMMENT '分配人id',
assigner_name varchar(32) NULL COMMENT '分配人名称',
follower_start_time datetime DEFAULT NULL COMMENT '跟进开始时间',
follower_end_time datetime DEFAULT NULL COMMENT '跟进结束时间',
is_current_follower tinyint(2) DEFAULT NULL COMMENT '是否当前跟进人（0否，1是）',
sea_id bigint(20) NOT NULL COMMENT '跟进时线索所处的公海Id',
is_latest tinyint(2) DEFAULT NULL COMMENT '是否最新跟进人（0否，1是）',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='线索跟进人';
DROP TABLE IF EXIST we_leads_sea_base_settings
CREATE TABLE we_leads_sea_base_settings (
id bigint(20) NOT NULL,
max_claim int(11) DEFAULT '1' COMMENT '员工每日领取上限',
stock_max_claim int(11) DEFAULT '1' COMMENT '成员客户存量上限',
create_time datetime NOT NULL COMMENT '创建时间',
create_by varchar(255) DEFAULT NULL COMMENT '创建人',
create_by_id bigint(20) DEFAULT NULL COMMENT '创建人id',
update_time datetime DEFAULT NULL COMMENT '修改时间',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint(20) DEFAULT NULL COMMENT '更新人id',
del_flag tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标识 0 正常 1 删除',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='公海基础配置表';
INSERT INTO we_leads_sea_base_settings VALUES (1, 10, 100, '2023-07-17 17:18:13', NULL, NULL, NULL, NULL, NULL, 0);
DROP TABLE IF EXIST we_leads_follow_record
CREATE TABLE we_leads_follow_record (
id bigint(20) NOT NULL,
we_leads_id bigint(20) DEFAULT NULL COMMENT '线索id',
sea_id bigint(20) DEFAULT NULL COMMENT '所属公海',
follow_user_id bigint(20) DEFAULT NULL COMMENT '线索跟进人表Id',
record_status tinyint(4) DEFAULT NULL COMMENT '记录状态 0已领取 1跟进中 2已转化 3已退回',
create_time datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='线索跟进记录';
DROP TABLE IF EXIST we_leads_records_content
CREATE TABLE we_leads_records_content (
id bigint(20) NOT NULL COMMENT '主键Id',
record_id bigint(20) NOT NULL COMMENT '跟进记录Id',
item_key varchar(32) NOT NULL COMMENT '记录项目名',
item_value varchar(500) NOT NULL COMMENT '记录项目值',
rank int(11) DEFAULT NULL COMMENT '排序',
is_visible tinyint(4) NOT NULL COMMENT '是否显示 0 显示 1 隐藏',
is_attachment tinyint(4) NOT NULL COMMENT '是否存在附件 0否 1是',
parent_id bigint(20) DEFAULT 0 COMMENT '父类id,无父类默认值为0',
create_time datetime NOT NULL COMMENT '创建时间',
replier_from_id bigint(20) DEFAULT NULL COMMENT '回复者id',
replier_from_we_user_Id varchar(32) DEFAULT NULL COMMENT '回复者企微Id',
replier_from varchar(32) DEFAULT NULL COMMENT '回复者',
replier_from_avatar varchar(255) DEFAULT NULL COMMENT '回复者头像',
replier_to_id bigint(20) DEFAULT NULL COMMENT '回复对象id',
replier_to varchar(32) DEFAULT NULL COMMENT '回复对象',
replier_to_we_user_Id varchar(32) DEFAULT NULL COMMENT '回复对象企微id',
replier_to_avatar varchar(255) DEFAULT NULL COMMENT '回复对象头像',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='线索跟进记录内容';
DROP TABLE IF EXIST we_leads_records_attachment
CREATE TABLE we_leads_records_attachment (
id bigint(20) NOT NULL COMMENT '主键Id',
content_id bigint(20) NOT NULL COMMENT '跟进记录内容Id',
type tinyint(2) NOT NULL COMMENT '附件类型 0 图片（image）、1 语音（voice）、2 视频（video），3 普通文件(file)',
title varchar(255) NOT NULL COMMENT '附件名称',
url varchar(255) NOT NULL COMMENT '附件地址',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='线索跟进记录附件';
DROP TABLE IF EXIST we_leads_auto_recovery
CREATE TABLE we_leads_auto_recovery (
id bigint(20) NOT NULL COMMENT '主键id',
leads_id bigint(20) NOT NULL COMMENT '线索id',
follower_id bigint(20) NOT NULL COMMENT '跟进人id',
type tinyint(2) NOT NULL COMMENT '自动回收类型',
recovery_time datetime NOT NULL COMMENT '回收时间',
recovery_reason tinyint(4) comment '回收原因',
executing_state tinyint(2) NOT NULL COMMENT '执行状态 0待执行 1已执行 2已取消',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) NOT NULL COMMENT '创建人',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(11) NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='线索自动回收';
DROP TABLE IF EXIST we_leads_record_content_cooperate_user
CREATE TABLE we_leads_record_content_cooperate_user (
id bigint(20) NOT NULL COMMENT '主键Id',
content_id bigint(20) NOT NULL COMMENT '记录内容id',
user_id bigint(20) DEFAULT NULL COMMENT '用户id',
we_user_id varchar(32) DEFAULT NULL COMMENT '用户企微Id',
user_name varchar(32) DEFAULT NULL COMMENT '用户名称',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='跟进记录内容协作成员';
DROP TABLE IF EXIST we_leads_import_record
CREATE TABLE we_leads_import_record (
id bigint(20) NOT NULL COMMENT '主键Id',
sea_id bigint(20) DEFAULT NULL COMMENT '所属公海',
import_source_file_name varchar(255) DEFAULT NULL COMMENT '导入的表单或excel的文件名',
import_source_type tinyint(4) DEFAULT NULL COMMENT '导入来源 0 excel 1 智能表单 2 手动新增',
form_id bigint(20) DEFAULT NULL COMMENT '智能表单id，当导入来源类型为智能表单时，这个值不为空',
total_num int(11) DEFAULT NULL COMMENT 'excel的线索总数',
success_num int(11) DEFAULT NULL COMMENT '线索导入的成功数',
fail_num int(11) DEFAULT NULL COMMENT '线索导入的失败数',
create_time datetime NOT NULL COMMENT '创建时间',
create_by varchar(255) DEFAULT NULL COMMENT '创建人',
create_by_id bigint(20) DEFAULT NULL COMMENT '创建人id',
update_time datetime DEFAULT NULL COMMENT '修改时间',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint(20) DEFAULT NULL COMMENT '更新人id',
del_flag tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标识 0 正常 1 删除',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='线索导入记录';
DROP TABLE IF EXIST we_leads_manual_add_record
CREATE TABLE we_leads_manual_add_record (
id bigint(20) NOT NULL COMMENT '主键Id',
we_user_id varchar(64) NOT NULL COMMENT '企微员工Id',
leads_id bigint(20) NOT NULL COMMENT '线索Id',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='线索手动入线记录';
DROP TABLE IF EXIST we_message_notification
CREATE TABLE we_message_notification (
id bigint NOT NULL COMMENT '主键Id',
title varchar(32) NOT NULL COMMENT '通知标题',
content varchar(255) NOT NULL COMMENT '通知内容',
notification_time datetime NOT NULL COMMENT '通知时间',
we_user_id varchar(32) NOT NULL COMMENT '员工Id',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) NOT NULL COMMENT '创建人',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(11) NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
is_read tinyint(1) DEFAULT NULL COMMENT '是否已读 0未读 1已读',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='消息通知';
DROP TABLE IF EXIST we_tasks
CREATE TABLE we_tasks (
id bigint(20) NOT NULL COMMENT '主键Id',
user_id bigint(20) NOT NULL COMMENT '员工id',
we_user_id varchar(32) NOT NULL COMMENT '员工企微Id',
type tinyint(4) NOT NULL COMMENT '任务类型',
title varchar(255) NOT NULL COMMENT '任务标题',
content varchar(500) NOT NULL COMMENT '自定义任务内容',
send_time datetime NOT NULL COMMENT '发送时间',
url varchar(255) DEFAULT NULL COMMENT '链接',
status tinyint(2) DEFAULT NULL COMMENT '状态，0待执行，1已完成，2已取消',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) NOT NULL COMMENT '创建人',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(11) NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
leads_id bigint(20) NOT NULL COMMENT '线索中心-线索Id',
is_visible tinyint(1) DEFAULT NULL COMMENT '是否显示（0不显示 1显示）',
record_id bigint(20) DEFAULT NULL COMMENT '线索中心-跟进记录Id',
PRIMARY KEY (id)
) ENGINE=InnoDB COMMENT='待办任务';
ALTER TABLE we_corp_account ADD COLUMN customer_link_margin bigint(20) NULL DEFAULT NULL COMMENT '获客助手剩余可用量' AFTER customer_churn_notice_switch;
ALTER TABLE we_corp_account ADD COLUMN customer_link_total bigint(20) NULL DEFAULT NULL COMMENT '获客助手总量' AFTER customer_link_margin;
DROP TABLE IF EXIST we_customer_link
CREATE TABLE we_customer_link (
id bigint(20) NOT NULL COMMENT '主键',
link_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接名称',
link_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业微信返回的获客链接id',
link_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业微信返回的获客链接',
state varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '渠道标识',
link_short_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '获客链接短链',
skip_verify tinyint(4) NULL DEFAULT 1 COMMENT '是否无需验证，默认为true 1:是 0:是',
we_user_list text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '此获客链接关联的userid列表，最多可关联100个',
department_list text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '此获客链接关联的部门id列表，部门覆盖总人数最多100个',
tag_ids text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '标签id多个使用逗号隔开',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
create_by_id bigint(20) NULL DEFAULT NULL COMMENT '创建人id',
create_time datetime NULL DEFAULT NULL COMMENT '创建时间',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人名称',
update_by_id bigint(20) NULL DEFAULT NULL COMMENT '更新人id',
update_time datetime NULL DEFAULT NULL COMMENT '更新时间',
del_flag tinyint(4) NULL DEFAULT 0 COMMENT '删除标识 0 有效 1删除',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '获客助手' ROW_FORMAT = Dynamic;
DROP TABLE IF EXIST we_customer_link_attachments
CREATE TABLE we_customer_link_attachments (
id bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键id',
customer_link_id bigint(11) NOT NULL COMMENT '识客码id',
msg_type varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息类型 文本:text 图片:image 图文:link 小程序:miniprogram 视频:video 文件:file ',
content text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '消息内容',
media_id varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '媒体id',
msg_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业微信端返回的消息id',
title varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息标题',
description varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息描述',
file_url varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件路径',
link_url varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息链接',
pic_url varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息图片地址',
app_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小程序appid',
create_by varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
create_by_id bigint(11) NULL DEFAULT NULL COMMENT '创建人id',
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_by varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) NULL DEFAULT NULL COMMENT '更新人id',
update_time datetime NULL DEFAULT NULL COMMENT '修改时间',
real_type tinyint(2) NULL DEFAULT NULL COMMENT '素材真实类型',
material_id bigint(20) NULL DEFAULT NULL COMMENT '素材id',
del_flag tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识 0 有效 1删除',
PRIMARY KEY (id) USING BTREE,
INDEX qr_id_IDX(customer_link_id, del_flag) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1692356624150212610 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '活码附件表' ROW_FORMAT = DYNAMIC;
DROP TABLE IF EXIST we_customer_link_count
CREATE TABLE we_customer_link_count (
id bigint(20) NOT NULL COMMENT '主键',
external_userid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户external_userid',
link_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '获客链接id',
we_user_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '通过获客链接添加此客户的跟进人userid',
customer_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户名称',
customer_type tinyint(4) NULL DEFAULT NULL COMMENT '客户类型 1:微信用户，2:企业用户\n',
gender tinyint(4) NULL DEFAULT NULL COMMENT '0-未知 1-男性 2-女性\n',
avatar varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户头像',
user_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '添加人名称',
chat_status tinyint(4) NULL DEFAULT 0 COMMENT '会话状态，0-客户未发消息 1-客户已发送消息',
add_time datetime NULL DEFAULT NULL COMMENT '客户相关添加时间',
state varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用于区分客户具体是通过哪个获客链接进行添加，用户可在获客链接后拼接customer_channel=自定义字符串，字符串不超过64字节，超过会被截断。通过点击带有customer_channel参数的链接获取到的客户，调用获客信息接口或获取客户详情接口时，返回的state参数即为链接后拼接自定义字符串',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
create_by_id bigint(20) NULL DEFAULT NULL COMMENT '创建人id',
create_time datetime NULL DEFAULT NULL COMMENT '创建时间',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人名称',
update_by_id bigint(20) NULL DEFAULT NULL COMMENT '更新人id',
update_time datetime NULL DEFAULT NULL COMMENT '更新时间',
del_flag tinyint(4) NULL DEFAULT 0 COMMENT '删除标识 0 有效 1删除',
UNIQUE INDEX onlykey(external_userid, we_user_id) USING BTREE COMMENT '联合唯一建'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
ALTER TABLE we_leads MODIFY COLUMN bind_customer_time datetime NULL DEFAULT NULL COMMENT '绑定客户时间' AFTER external_userid;
ALTER TABLE we_leads ADD UNIQUE INDEX phone_unique(phone) USING BTREE COMMENT '手机号码索引';
ALTER TABLE we_leads_follower MODIFY COLUMN assigner_id bigint(20) NULL DEFAULT NULL COMMENT '分配人id' AFTER return_reason;
ALTER TABLE we_leads_follower MODIFY COLUMN assigner_name varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分配人名称' AFTER assigner_id;
DROP TABLE IF EXIST we_leads_record_attachment
CREATE TABLE we_leads_record_attachment (
id bigint(20) NOT NULL COMMENT '主键Id',
content_id bigint(20) NOT NULL COMMENT '跟进记录内容Id',
type tinyint(2) NOT NULL COMMENT '附件类型 0 图片（image）、1 语音（voice）、2 视频（video），3 普通文件(file)',
title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '附件名称',
url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '附件地址',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '线索跟进记录附件' ROW_FORMAT = Dynamic;
DROP TABLE IF EXIST we_leads_record_content
CREATE TABLE we_leads_record_content (
id bigint(20) NOT NULL COMMENT '主键Id',
record_id bigint(20) NOT NULL COMMENT '跟进记录Id',
item_key varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '记录项目名',
item_value varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '记录项目值',
rank int(11) NULL DEFAULT NULL COMMENT '排序',
is_visible tinyint(4) NOT NULL COMMENT '是否显示 是否显示 0 显示 1 隐藏',
is_attachment tinyint(4) NOT NULL COMMENT '是否存在附件 0否 1是',
parent_id bigint(20) NULL DEFAULT 0 COMMENT '父类id,无父类默认值为0',
replier_from_id bigint(20) NULL DEFAULT NULL COMMENT '回复者id',
replier_from_we_user_id varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复者企微Id',
replier_from varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复者',
replier_from_avatar varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复者头像',
replier_to_id bigint(20) NULL DEFAULT NULL COMMENT '回复对象id',
replier_to varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复对象',
replier_to_we_user_id varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复对象企微id',
replier_to_avatar varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复对象头像',
create_time datetime NOT NULL COMMENT '创建时间',
sub_num int(11) NULL DEFAULT 0 COMMENT '子类数量',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '线索跟进记录内容' ROW_FORMAT = Dynamic;
ALTER TABLE we_qr_code ADD COLUMN qr_welcome_open tinyint(4) NULL DEFAULT NULL COMMENT '欢迎语开关 1-不发送欢迎语，2-发送欢迎语' AFTER qr_code;
ALTER TABLE we_qr_code ADD COLUMN qr_priority_user_welcome tinyint(4) NULL DEFAULT NULL COMMENT '是否优先员工欢迎语 0-否，1-是（仅欢迎语开关为2是生效）' AFTER qr_welcome_open;
DROP TABLE IF EXISTS we_substitute_customer_order;
CREATE TABLE we_substitute_customer_order (
id bigint(20) NOT NULL COMMENT '主键Id',
purchaser varchar(255) NOT NULL COMMENT '购买人',
phone char(11) NOT NULL COMMENT '联系方式',
source varchar(20) NOT NULL COMMENT '订单来源',
order_time datetime NOT NULL COMMENT '下单时间',
dept_id bigint(20) NOT NULL COMMENT '归属部门',
user_id bigint(20) NOT NULL COMMENT '归属员工',
order_status varchar(20) NOT NULL COMMENT '订单状态',
product_name varchar(255) NOT NULL COMMENT '商品名称',
product_url varchar(1000) DEFAULT NULL COMMENT '商品图片',
product_unit_price decimal(9,2) NOT NULL COMMENT '商品单价',
amount int(11) NOT NULL COMMENT '商品数量',
total_price decimal(10,0) NOT NULL COMMENT '付款总价',
discount varchar(255) DEFAULT NULL COMMENT '付款折扣',
discount_amount decimal(9,2) DEFAULT NULL COMMENT '折扣金额',
actual_payment decimal(9,2) NOT NULL COMMENT '实际付款',
returned_money_type varchar(20) NOT NULL COMMENT '回款方式',
returned_money decimal(9,2) NOT NULL COMMENT '回款金额',
returned_date datetime NOT NULL COMMENT '回款日期',
payer varchar(255) NOT NULL COMMENT '打款人',
returned_receipt varchar(1000) DEFAULT NULL COMMENT '回款凭证',
status tinyint(2) NOT NULL COMMENT '状态：0暂存 1完成',
properties varchar(1000) DEFAULT NULL COMMENT '自定义属性',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) NOT NULL COMMENT '创建人',
update_by varchar(255) DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(11) NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
external_userid varchar(255) NOT NULL COMMENT '外部联系人的userid',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代客下单-订单';
DROP TABLE IF EXIST we_substitute_customer_order_catalogue
CREATE TABLE we_substitute_customer_order_catalogue (
id bigint(20) NOT NULL COMMENT '主键Id',
name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称',
sort int(11) NOT NULL COMMENT '排序',
is_fixed tinyint(4) NOT NULL COMMENT '是否固定值 0否 1是',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime NULL DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) NULL DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(11) NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标识',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代客下单字段分类' ROW_FORMAT = Dynamic;
DROP TABLE IF EXIST we_substitute_customer_order_catalogue_property
CREATE TABLE we_substitute_customer_order_catalogue_property (
id bigint(20) NOT NULL COMMENT '主键id',
catalogue_id bigint(20) NOT NULL COMMENT '分类id',
name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字段名称',
code varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段编码',
type tinyint(2) NOT NULL COMMENT '字段类型',
is_require tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否必填 0否 1是',
expound varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段说明',
value varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段值',
sort int(11) NULL DEFAULT NULL COMMENT '排序',
is_fixed tinyint(4) NULL DEFAULT 0 COMMENT '是否固定字段，0否 1是',
is_money tinyint(4) NULL DEFAULT 0 COMMENT '是否金额，字段类型为数字时用，需要精确到小数点后两位 0否 1是',
is_to_time tinyint(4) NULL DEFAULT 0 COMMENT '是否精确到时间，字段类型为日期时用，0否 1是',
is_multiple_choice tinyint(4) NULL DEFAULT 0 COMMENT '是否多选，0否 1是',
is_more tinyint(4) NULL DEFAULT NULL COMMENT '是否支持多个，附件时用，0否 1时',
create_time datetime NOT NULL COMMENT '创建时间',
update_time datetime NULL DEFAULT NULL COMMENT '更新时间',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
update_by_id bigint(11) NULL DEFAULT NULL COMMENT '更新人id',
create_by_id bigint(11) NOT NULL COMMENT '创建人id',
del_flag tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标识',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代客下单分类字段' ROW_FORMAT = Dynamic;
ALTER TABLE we_tasks ADD COLUMN record_id bigint(20) NULL DEFAULT NULL COMMENT '线索中心-跟进记录Id' AFTER is_visible;
● 日期：2023.06.09
ALTER TABLE `we_substitute_customer_order` ADD COLUMN `external_userid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '外部联系人的userid' AFTER `del_flag`;
ALTER TABLE `we_substitute_customer_order` MODIFY COLUMN `discount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '付款折扣' AFTER `total_price`;
ALTER TABLE `we_substitute_customer_order` MODIFY COLUMN `discount_amount` decimal(9, 2) NULL DEFAULT NULL COMMENT '折扣金额' AFTER `discount`;
ALTER TABLE `we_tasks` MODIFY COLUMN `send_time` datetime NULL DEFAULT NULL COMMENT '发送时间' AFTER `content`;
ALTER TABLE we_leads DROP INDEX phone_unique;
ALTER TABLE `we_substitute_customer_order` ADD COLUMN `external_userid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '外部联系人的userid' AFTER `del_flag`;
DELETE FROM sys_menu WHERE menu_name = '系统管理' AND menu_id=1
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2462, '订单信息', 2367, 2, 'orderInfo', 'salesCenter/orderInfo/index', 1, 'C', '0', '0', 'salesCenter:orderInfo:index', '#', 'admin', NULL, '2023-08-10 16:08:45', 'admin', NULL, '2023-08-17 11:23:25', '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2470, '知识中心', 2230, 45, 'knowledgeBase', NULL, 1, 'M', '0', '0', NULL, '#', 'admin', NULL, '2023-08-21 15:59:46', NULL, NULL, NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2471, '客服问答库', 2470, 1, 'kfKnowledge', NULL, 1, 'M', '0', '0', NULL, '#', 'admin', NULL, '2023-08-21 16:01:27', NULL, NULL, NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2472, '列表', 2471, 1, 'index', 'customerService/knowledgeBase/index', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-08-21 16:02:34', NULL, NULL, NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2473, '{新增}', 2471, 2, 'add', 'customerService/knowledgeBase/add', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-08-21 16:07:19', NULL, NULL, NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_by_id`, `create_time`, `update_by`, `update_by_id`, `update_time`, `remark`) VALUES (2474, '详情', 2471, 3, 'detail', 'customerService/knowledgeBase/detail', 1, 'C', '1', '0', NULL, '#', 'admin', NULL, '2023-08-21 16:08:16', NULL, NULL, NULL, '');
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687007498300997632, 1686684407914029056, '商品编码', 'productName', 0, 1, '请关联商品', NULL, 0, 1, 0, 0, 0, NULL, '2023-08-03 15:48:25', '2023-08-03 15:48:25', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687010197646004224, 1686684407914029056, '商品图片', 'productUrl', 7, 0, NULL, NULL, 1, 1, 0, 0, 0, 1, '2023-08-03 15:59:09', '2023-08-03 15:59:09', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687011073676726272, 1686684407914029056, '商品单价', 'productUnitPrice', 6, 1, '请关联商品', NULL, 2, 1, 1, 0, 0, NULL, '2023-08-03 16:02:38', '2023-08-03 16:02:38', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687011624535654400, 1686684407914029056, '商品数量', 'amount', 6, 1, '请填写数量', NULL, 3, 1, 0, 0, 0, NULL, '2023-08-03 16:04:49', '2023-08-03 16:04:49', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687012068431429632, 1686684373675925504, '购买人', 'purchaser', 0, 1, '请填写购买人名称', NULL, 4, 1, 0, 0, 0, NULL, '2023-08-03 16:06:35', '2023-08-03 16:06:35', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687012156713140224, 1686684373675925504, '联系方式', 'phone', 0, 1, '请填写联系方式', NULL, 6, 1, 0, 0, 0, NULL, '2023-08-03 16:06:56', '2023-08-03 16:06:56', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687012507407286272, 1686684373675925504, '订单来源', 'source', 2, 1, NULL, '商品图册,小程序商城,其他', 5, 1, 0, 0, 0, NULL, '2023-08-03 16:08:20', '2023-08-03 16:08:20', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687012835494133760, 1686684373675925504, '下单时间', 'orderTime', 3, 1, '请选择时间', NULL, 7, 1, 0, 1, 0, NULL, '2023-08-03 16:09:38', '2023-08-03 16:09:38', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687013105615699968, 1686684373675925504, '归属部门', 'deptId', 4, 1, '请选择部门', NULL, 8, 1, 0, 0, 0, NULL, '2023-08-03 16:10:42', '2023-08-03 16:10:42', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687013218333425664, 1686684373675925504, '归属员工', 'userId', 5, 1, '请选择员工', NULL, 9, 1, 0, 0, 0, NULL, '2023-08-03 16:11:09', '2023-08-03 16:11:09', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687013574748602368, 1686684373675925504, '订单状态', 'orderStatus', 2, 1, NULL, '待支付,待发货,待回款', 10, 1, 0, 0, 0, NULL, '2023-08-03 16:12:34', '2023-08-03 16:12:34', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687014381204209664, 1686684432819806208, '付款总价', 'totalPrice', 6, 1, '请填写价格', NULL, 11, 1, 1, 0, 0, NULL, '2023-08-03 16:15:46', '2023-08-03 16:15:46', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687014666773397504, 1686684432819806208, '付款折扣', 'discount', 6, 0, '请填写折扣', NULL, 12, 1, 0, 0, 0, NULL, '2023-08-03 16:16:54', '2023-08-03 16:16:54', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687014724822564864, 1686684432819806208, '折扣金额', 'discountAmount', 6, 0, '请填写金额', NULL, 13, 1, 1, 0, 0, NULL, '2023-08-03 16:17:08', '2023-08-03 16:17:08', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687014801678991360, 1686684432819806208, '实际付款', 'actualPayment', 6, 1, '请填写价格', NULL, 14, 1, 1, 0, 0, NULL, '2023-08-03 16:17:27', '2023-08-03 16:17:27', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687015152255696896, 1686684460279914496, '回款方式', 'returnedMoneyType', 2, 1, NULL, '现金,微信,支付宝,银联,其他', 15, 1, 0, 0, 0, NULL, '2023-08-03 16:18:50', '2023-08-03 16:18:50', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687015342861647872, 1686684460279914496, '回款金额', 'returnedMoney', 6, 1, '请填写金额', NULL, 16, 1, 1, 0, 0, NULL, '2023-08-03 16:19:36', '2023-08-03 16:19:36', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687015505588060160, 1686684460279914496, '回款时间', 'returnedDate', 3, 1, '请选择时间', NULL, 17, 1, 0, 1, 0, NULL, '2023-08-03 16:20:14', '2023-08-03 16:20:14', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687015583602114560, 1686684460279914496, '打款人', 'payer', 0, 1, '请填写打款人名称', NULL, 18, 1, 0, 0, 0, NULL, '2023-08-03 16:20:33', '2023-08-03 16:20:33', 'admin', 'admin', 1, 1, 0);
INSERT INTO `we_substitute_customer_order_catalogue_property` (`id`, `catalogue_id`, `name`, `code`, `type`, `is_require`, `expound`, `value`, `sort`, `is_fixed`, `is_money`, `is_to_time`, `is_multiple_choice`, `is_more`, `create_time`, `update_time`, `create_by`, `update_by`, `update_by_id`, `create_by_id`, `del_flag`) VALUES (1687015747247079424, 1686684460279914496, '回款凭证', 'returnedReceipt', 7, 0, NULL, NULL, 19, 1, 0, 0, 0, 1, '2023-08-03 16:21:12', '2023-08-03 16:21:12', 'admin', 'admin', 1, 1, 0);
CREATE TABLE `we_common_link_stat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`short_id` bigint(20) NOT NULL COMMENT '短链ID',
`date_time` datetime NOT NULL COMMENT '日期',
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '链接渠道',
`pv_num` int(11) NULL DEFAULT 0 COMMENT 'PV数量',
`uv_num` int(11) NULL DEFAULT 0 COMMENT 'UV数量',
`open_num` int(11) NULL DEFAULT 0 COMMENT '打开小程序数量',
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备用',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
`create_by_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID',
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
`update_by_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人id',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标识 0 有效 1 删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短链通用统计表' ROW_FORMAT = DYNAMIC;
CREATE TABLE `we_kf_answer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`group_id` bigint(64) NOT NULL COMMENT '活码分组id',
`intent_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企微问答ID',
`qt_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '问题名称',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`create_by_id` bigint(11) NULL DEFAULT NULL COMMENT '创建人id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`update_by_id` bigint(11) NULL DEFAULT NULL COMMENT '更新人id',
`del_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0有效,1删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服问答信息表' ROW_FORMAT = DYNAMIC;
CREATE TABLE `we_kf_answer_attachments` (
`id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`answer_id` bigint(64) NOT NULL COMMENT '活码id',
`material_id` bigint(20) NULL DEFAULT NULL COMMENT '素材Id',
`msg_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息类型 文本:text 图片:image 图文:link 小程序:miniprogram 视频:video 文件:file ',
`content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息内容',
`media_id` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '媒体id',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息标题',
`description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息描述',
`file_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件路径',
`link_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息链接',
`pic_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息图片地址',
`app_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小程序appid',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`create_by_id` bigint(11) NULL DEFAULT NULL COMMENT '创建人id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`update_by_id` bigint(11) NULL DEFAULT NULL COMMENT '更新人id',
`update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
`del_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '删除标识 0 有效 1删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服问答回答表' ROW_FORMAT = DYNAMIC;
CREATE TABLE `we_kf_answer_group` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`group_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分组ID',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分组名称',
`is_default` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否为默认分组。0-否 1-是 默认分组为系统自动创建，不可修改/删除',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`create_by_id` bigint(11) NULL DEFAULT NULL COMMENT '创建人id',
`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`update_by_id` bigint(11) NULL DEFAULT NULL COMMENT '更新人id',
`del_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0有效,1删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服问答分组表' ROW_FORMAT = DYNAMIC;
CREATE TABLE `we_kf_answer_like_question` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`answer_id` bigint(64) NOT NULL COMMENT '问答id',
`qt_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '问题名称',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
`create_by_id` bigint(11) NULL DEFAULT NULL COMMENT '创建人id',
`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
`update_by_id` bigint(11) NULL DEFAULT NULL COMMENT '更新人id',
`del_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除:0有效,1删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客服问答相似问题表' ROW_FORMAT = DYNAMIC;
CREATE TABLE `we_material_seize_poster` (
`id` bigint(20) NOT NULL COMMENT '主键',
`material_id` bigint(20) NULL DEFAULT NULL COMMENT '素材id，为海报类型且海报上的二维码为占位符类型的素材',
`real_post_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实际海报图片地址',
`belong_we_user_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '海报上的二维码归属人id，为员工的we_user_id',
`config_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '新增联系方式的配置id',
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
`create_by_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人id',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
`update_by_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人id',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`del_flag` int(1) NULL DEFAULT 0 COMMENT '0 未删除 1 已删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '素材海报占位符海报生成的实际海报' ROW_FORMAT = DYNAMIC;
---
### ● 日期：2023.08.28
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2468, '系统监控', 2185, 9, 'system', NULL, 1, 'M', '0', '0', NULL, 'app', 'admin', NULL, '2023-08-26 16:41:35', NULL, NULL, NULL, '');
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2469, '企微异常', 2468, 1, 'system/exception', 'system/exception/index', 1, 'C', '0', '0', '', 'build', 'admin', NULL, '2023-08-26 17:01:15', 'admin', NULL, '2023-08-26 17:08:45', '');
CREATE TABLE we_error_msg (
id bigint(20) NOT NULL COMMENT '主键',
url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求url',
error_code bigint(20) NULL DEFAULT NULL COMMENT '错误码',
error_msg text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '错误信息',
we_params text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求参数',
create_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
create_by_id bigint(20) NULL DEFAULT NULL COMMENT '创建人id',
create_time datetime NULL DEFAULT NULL COMMENT '创建时间',
update_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '更新人',
update_by_id bigint(20) NULL DEFAULT NULL COMMENT '更新人id',
update_time datetime NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '企业微信响应错误参数记录表' ROW_FORMAT = Dynamic;
ALTER TABLE we_fission ADD COLUMN active_title varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动名称' AFTER fission_url;
ALTER TABLE we_fission ADD COLUMN active_descr varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动描述' AFTER active_title;
ALTER TABLE we_fission ADD COLUMN active_cover_type tinyint(4) NULL DEFAULT 1 COMMENT '1:海报缩略图 2:自定义' AFTER active_descr;
ALTER TABLE we_fission ADD COLUMN active_cover_url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面图片地址' AFTER active_cover_type;
ALTER TABLE we_group_code_range ADD COLUMN status tinyint(4) NULL DEFAULT NULL COMMENT '关联状态 0-未关联 1-关联' AFTER chat_id;
---
### ● 日期：2023.09.11
INSERT INTO we_leads_template_settings (id, table_entry_name, table_entry_id, table_entry_attr, data_attr, datetime_type, max_input_len, can_edit, is_required, create_time, rank, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1678322167884226560, '姓名', 'name', 0, 0, NULL, 10, 1, 1, '2023-07-10 16:36:01', 4, '2023-09-10 20:51:35', 'admin', 'lw', 168, 1, 0);
INSERT INTO we_leads_template_settings (id, table_entry_name, table_entry_id, table_entry_attr, data_attr, datetime_type, max_input_len, can_edit, is_required, create_time, rank, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1679400302667051008, '电话号码', 'phone', 0, 0, NULL, 11, 1, 1, '2023-07-13 16:00:09', 2, '2023-09-09 11:53:46', 'admin', 'lw', 168, 1, 0);
INSERT INTO we_leads_template_settings (id, table_entry_name, table_entry_id, table_entry_attr, data_attr, datetime_type, max_input_len, can_edit, is_required, create_time, rank, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1691634393458208768, '性别', '1691634393122664448', 1, 0, 0, 100, 1, 0, '2023-08-16 10:14:03', 5, '2023-09-10 20:51:37', 'admin', 'lw', 168, 1, 0);
INSERT INTO we_leads_template_settings (id, table_entry_name, table_entry_id, table_entry_attr, data_attr, datetime_type, max_input_len, can_edit, is_required, create_time, rank, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1691695879538970624, '年龄', '1691695879102763008', 0, 1, 0, 100, 0, 0, '2023-08-16 14:18:23', 3, '2023-09-10 20:51:37', 'admin', 'lw', 168, 1, 0);
INSERT INTO we_leads_template_settings (id, table_entry_name, table_entry_id, table_entry_attr, data_attr, datetime_type, max_input_len, can_edit, is_required, create_time, rank, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1691695967267033088, '身高', '1691695966935683072', 0, 1, 0, 100, 0, 0, '2023-08-16 14:18:43', 1, '2023-09-10 20:51:35', 'admin', 'lw', 168, 1, 0);
ALTER TABLE we_customer MODIFY COLUMN add_user_id varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER del_flag;
ALTER TABLE we_customer MODIFY COLUMN phone varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER track_time;
---
### ● 日期：2023.09.19
ALTER TABLE we_kf_info MODIFY COLUMN end_content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '自动结束提醒内容';
ALTER TABLE we_group_member ADD UNIQUE INDEX index(chat_id, user_id) USING BTREE COMMENT '客群id与群成员id构建唯一索引';
---
### ● 日期：2023.09.26
ALTER TABLE we_customer ADD COLUMN is_join_blacklist tinyint(4) NULL DEFAULT 1 COMMENT '0:加入黑名单;1:不加入黑名单;' AFTER add_user_leave;
ALTER TABLE we_customer MODIFY COLUMN add_user_id varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL AFTER del_flag;
ALTER TABLE we_material ADD COLUMN tag_ids text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '标签id' AFTER type;
INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_by_id, create_time, update_by, update_by_id, update_time, remark) VALUES (2468, '系统监控', 2185, 9, 'system', NULL, 1, 'M', '0', '0', NULL, 'app', 'admin', NULL, '2023-08-26 16:41:35', NULL, NULL, NULL, '');
---
### ● 日期：2023.10.09
INSERT INTO we_substitute_customer_order_catalogue (id, name, sort, is_fixed, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1686684373675925504, '订单信息', 0, 1, '2023-08-02 18:24:26', '2023-08-02 18:24:26', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue (id, name, sort, is_fixed, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1686684407914029056, '商品信息', 1, 1, '2023-08-02 18:24:35', '2023-08-02 18:24:35', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue (id, name, sort, is_fixed, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1686684432819806208, '付款信息', 2, 1, '2023-08-02 18:24:41', '2023-08-02 18:24:41', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue (id, name, sort, is_fixed, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1686684460279914496, '回款信息', 3, 1, '2023-08-02 18:24:47', '2023-08-02 18:24:47', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687007498300997632, 1686684407914029056, '商品编码', 'productName', 0, 1, '请关联商品', NULL, 0, 1, 0, 0, 0, NULL, '2023-08-03 15:48:25', '2023-08-03 15:48:25', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687010197646004224, 1686684407914029056, '商品图片', 'productUrl', 7, 0, NULL, NULL, 1, 1, 0, 0, 0, 1, '2023-08-03 15:59:09', '2023-08-03 15:59:09', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687011073676726272, 1686684407914029056, '商品单价', 'productUnitPrice', 6, 1, '请关联商品', NULL, 2, 1, 1, 0, 0, NULL, '2023-08-03 16:02:38', '2023-08-03 16:02:38', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687011624535654400, 1686684407914029056, '商品数量', 'amount', 6, 1, '请填写数量', NULL, 3, 1, 0, 0, 0, NULL, '2023-08-03 16:04:49', '2023-08-03 16:04:49', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687012068431429632, 1686684373675925504, '购买人', 'purchaser', 0, 1, '请填写购买人名称', NULL, 4, 1, 0, 0, 0, NULL, '2023-08-03 16:06:35', '2023-08-03 16:06:35', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687012156713140224, 1686684373675925504, '联系方式', 'phone', 0, 1, '请填写联系方式', NULL, 6, 1, 0, 0, 0, NULL, '2023-08-03 16:06:56', '2023-08-03 16:06:56', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687012507407286272, 1686684373675925504, '订单来源', 'source', 2, 1, NULL, '商品图册,小程序商城,其他', 5, 1, 0, 0, 0, NULL, '2023-08-03 16:08:20', '2023-08-03 16:08:20', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687012835494133760, 1686684373675925504, '下单时间', 'orderTime', 3, 1, '请选择时间', NULL, 7, 1, 0, 1, 0, NULL, '2023-08-03 16:09:38', '2023-08-03 16:09:38', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687013105615699968, 1686684373675925504, '归属部门', 'deptId', 4, 1, '请选择部门', NULL, 8, 1, 0, 0, 0, NULL, '2023-08-03 16:10:42', '2023-08-03 16:10:42', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687013218333425664, 1686684373675925504, '归属员工', 'userId', 5, 1, '请选择员工', NULL, 9, 1, 0, 0, 0, NULL, '2023-08-03 16:11:09', '2023-08-03 16:11:09', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687013574748602368, 1686684373675925504, '订单状态', 'orderStatus', 2, 1, NULL, '待支付,待发货,待回款', 10, 1, 0, 0, 0, NULL, '2023-08-03 16:12:34', '2023-08-03 16:12:34', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687014381204209664, 1686684432819806208, '付款总价', 'totalPrice', 6, 1, '请填写价格', NULL, 11, 1, 1, 0, 0, NULL, '2023-08-03 16:15:46', '2023-08-03 16:15:46', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687014666773397504, 1686684432819806208, '付款折扣', 'discount', 6, 0, '请填写折扣', NULL, 12, 1, 0, 0, 0, NULL, '2023-08-03 16:16:54', '2023-08-03 16:16:54', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687014724822564864, 1686684432819806208, '折扣金额', 'discountAmount', 6, 0, '请填写金额', NULL, 13, 1, 1, 0, 0, NULL, '2023-08-03 16:17:08', '2023-08-03 16:17:08', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687014801678991360, 1686684432819806208, '实际付款', 'actualPayment', 6, 1, '请填写价格', NULL, 14, 1, 1, 0, 0, NULL, '2023-08-03 16:17:27', '2023-08-03 16:17:27', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687015152255696896, 1686684460279914496, '回款方式', 'returnedMoneyType', 2, 1, NULL, '现金,微信,支付宝,银联,其他', 15, 1, 0, 0, 0, NULL, '2023-08-03 16:18:50', '2023-08-03 16:18:50', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687015342861647872, 1686684460279914496, '回款金额', 'returnedMoney', 6, 1, '请填写金额', NULL, 16, 1, 1, 0, 0, NULL, '2023-08-03 16:19:36', '2023-08-03 16:19:36', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687015505588060160, 1686684460279914496, '回款时间', 'returnedDate', 3, 1, '请选择时间', NULL, 17, 1, 0, 1, 0, NULL, '2023-08-03 16:20:14', '2023-08-03 16:20:14', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687015583602114560, 1686684460279914496, '打款人', 'payer', 0, 1, '请填写打款人名称', NULL, 18, 1, 0, 0, 0, NULL, '2023-08-03 16:20:33', '2023-08-03 16:20:33', 'admin', 'admin', 1, 1, 0);
INSERT INTO we_substitute_customer_order_catalogue_property (id, catalogue_id, name, code, type, is_require, expound, value, sort, is_fixed, is_money, is_to_time, is_multiple_choice, is_more, create_time, update_time, create_by, update_by, update_by_id, create_by_id, del_flag) VALUES (1687015747247079424, 1686684460279914496, '回款凭证', 'returnedReceipt', 7, 0, NULL, NULL, 19, 1, 0, 0, 0, 1, '2023-08-03 16:21:12', '2023-08-03 16:21:12', 'admin', 'admin', 1, 1, 0);
UPDATE sys_menu set visible=1 where menu_name = '知识中心';
INSERT INTO we_leads_sea_base_settings (id, max_claim, stock_max_claim, create_time, create_by, create_by_id, update_time, update_by, update_by_id, del_flag) VALUES (1, 1, 8, '2023-07-17 17:18:13', NULL, NULL, '2023-10-10 16:13:34', 'lw', 168, 0);
```