-- 为已执行 20260831 表迁移的环境补登记企微推广自动化补偿任务。

START TRANSACTION;

INSERT INTO `zyt_dev_crontab` (
  `name`, `type`, `system`, `remark`, `command`, `params`,
  `status`, `expression`, `create_time`, `update_time`
)
SELECT
  '补偿企微推广自动化', 1, 0,
  '补偿客户标签、备注、成员记账、范围与客户资料同步，并清理过期欢迎码',
  'qywx:retry-promotion-automation', '', 1, '* * * * *', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `zyt_dev_crontab`
  WHERE `command` = 'qywx:retry-promotion-automation' AND `delete_time` IS NULL
);

INSERT INTO `zyt_dev_crontab` (
  `name`, `type`, `system`, `remark`, `command`, `params`,
  `status`, `expression`, `create_time`, `update_time`
)
SELECT
  '刷新企微推广欢迎语素材', 1, 0,
  '预热并刷新渠道欢迎语使用的企业微信临时素材',
  'qywx:refresh-promotion-media', '', 1, '*/5 * * * *', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `zyt_dev_crontab`
  WHERE `command` = 'qywx:refresh-promotion-media' AND `delete_time` IS NULL
);

COMMIT;