java-bbc/db/2024-12-03 添加通联退款字段-删除推送直播数据定时任务.sql

# 添加通联的退款id字段

USE `yami_bbc`;
ALTER TABLE `tz_refund_info`
    ADD COLUMN `allinpay_refund_id` VARCHAR(200) DEFAULT NULL COMMENT '传给通联的退款id(通联环境)';

UPDATE `tz_refund_info` SET allinpay_refund_id = refund_id;

# 删除推送直播间数据的定时任务
USE `xxl_job`;
delete from xxl_job_info where executor_handler = 'pushLiveRoomData';