java-bbc/db/2025-03-11 门店公告合并.sql

USE `yami_bbc`;

-- 修改公告菜单名
UPDATE tz_shop_menu_lang
SET
    name = '门店公告'
WHERE
    lang = 0
    AND menu_id = 1299;

UPDATE tz_shop_menu_lang
SET
    name = 'Station Notices'
WHERE
    lang = 1
    AND menu_id = 1299;

-- 补充遗漏菜单语言
insert into `tz_sys_menu_lang` (`menu_id`, `lang`, `name`) values
(1193,0,'修改'),
(1193,1,'Modify');

-- 移除多余公告菜单
DELETE FROM tz_shop_menu
WHERE
    menu_id IN (1017, 1027, 1028);

DELETE FROM tz_shop_menu_lang
WHERE
    menu_id IN (1017, 1027, 1028);


# 商家转账改动

ALTER TABLE `tz_enterprise_pay`
    MODIFY COLUMN `status` tinyint(0) NULL DEFAULT NULL COMMENT '状态(1:申请中 2:已完成 3:带用户确认 -1:失败)',
    ADD COLUMN `mch_id` varchar(50) NULL COMMENT '微信支付mchId' AFTER `out_batch_no`,
    ADD COLUMN `app_id` varchar(50) NULL COMMENT '小程序/公众号id' AFTER `mch_id`,
    ADD COLUMN `app_type` int NULL COMMENT '提现场景类型：1:小程序 2: 公众号 3 :应用app' AFTER `app_id`,
    ADD COLUMN `package_Info` varchar(255) NULL COMMENT '【跳转领取页面的package信息】 跳转微信支付收款页的package信息，APP调起用户确认收款或JSAPI调起用户确认收款需要使用的参数。' AFTER `app_type`;


ALTER TABLE `tz_distribution_withdraw_cash`
    MODIFY COLUMN `state` tinyint(0) NULL DEFAULT NULL COMMENT '提现状态(0:申请中 1:提现成功 2:拒绝提现 3:带用户确认 -1:提现失败)' AFTER `update_time`,
    ADD COLUMN `app_type` int NULL COMMENT '提现场景类型：1:小程序 2: 公众号 3 :应用app';