16 lines
1.3 KiB
SQL
16 lines
1.3 KiB
SQL
-- 已安装“企业微信获客助手”旧版数据表时执行一次。
|
|
-- 新安装环境直接执行 add_first_visit_wecom_promotion.sql，无需再执行本文件。
|
|
|
|
ALTER TABLE `zyt_qywx_promotion_link`
|
|
ADD COLUMN `remote_link_id` varchar(128) NULL DEFAULT NULL COMMENT '企业微信获客助手 link_id' AFTER `wecom_url`,
|
|
ADD COLUMN `remote_status` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '0历史手工 1远端有效 2远端已删除 3远端不可见 4同步失败' AFTER `remote_link_id`,
|
|
ADD COLUMN `remote_create_time` int unsigned NOT NULL DEFAULT 0 AFTER `remote_status`,
|
|
ADD COLUMN `range_user_json` text NULL COMMENT '获客链接可用成员 userid JSON' AFTER `remote_create_time`,
|
|
ADD COLUMN `range_department_json` text NULL COMMENT '获客链接可用企微部门 ID JSON' AFTER `range_user_json`,
|
|
ADD COLUMN `skip_verify` tinyint unsigned NOT NULL DEFAULT 0 AFTER `range_department_json`,
|
|
ADD COLUMN `priority_option_json` text NULL AFTER `skip_verify`,
|
|
ADD COLUMN `remote_snapshot` mediumtext NULL AFTER `priority_option_json`,
|
|
ADD COLUMN `last_sync_time` int unsigned NOT NULL DEFAULT 0 AFTER `remote_snapshot`,
|
|
ADD COLUMN `sync_error` varchar(500) NOT NULL DEFAULT '' AFTER `last_sync_time`,
|
|
ADD UNIQUE KEY `uk_remote_link_id` (`remote_link_id`);
|