java-bbc/db/2024-09-10 修改消息模板.sql

USE yami_bbc;

# 修改订单确认收货消息模板
UPDATE
    tz_notify_template
SET
    message = '订单号${orderNumber}的用户${nickName}已经确认收货。'
WHERE
    template_id = 1811;



# 整合es数据同步的定时任务
USE xxl_job;
UPDATE xxl_job_info SET executor_handler = 'syncDataToEs', job_desc = '同步商品和门店的数据到es' WHERE executor_handler = 'verifySpuData' ;

delete from xxl_job_info WHERE executor_handler = 'syncOldStationSaveEs' ;

# 套餐购物车添加套餐购物车是否变成普通购物车字段
ALTER TABLE `tz_basket`
    ADD COLUMN `combo_update` int NULL COMMENT '套餐购物车是否变成普通购物车(0:未变，1已改变)' AFTER `use_member`,
DROP INDEX `uk_user_shop_station_sku_combo`,
ADD UNIQUE INDEX `uk_user_shop_station_sku_combo_update`(`sku_id`, `user_id`, `shop_id`, `station_id`, `combo_id`, `parent_basket_id`, `combo_update`) USING BTREE;