mxys_backend/db/update_241107.sql

-- 新增公共配置
INSERT INTO `tcwm2.5`.`common_info` (`id`, `create_at`, `max`, `min`, `type`, `value`, `condition_from`) VALUES (433, '2024-10-17 10:48:43', NULL, '是否开启新支付', 433, '1', 'weixin');
INSERT INTO `tcwm2.5`.`common_info` (`id`, `create_at`, `max`, `min`, `type`, `value`, `condition_from`) VALUES (434, '2024-10-17 10:48:43', NULL, '微信支付RHT商户号', 434, '866360132440001', 'weixin');
INSERT INTO `tcwm2.5`.`common_info` (`id`, `create_at`, `max`, `min`, `type`, `value`, `condition_from`) VALUES (435, '2024-10-17 10:48:43', NULL, '微信支付RHT商户密钥', 435, 'B9591F61B1944A93938DD3DFA9070763', 'weixin');


/* --------------- 修改表 --------------- */
-- 修改表：goods_shop[店铺信息]
-- 添加字段：
ALTER TABLE goods_shop
    ADD COLUMN `mch_id` VARCHAR(32) COMMENT '商户id;' AFTER reservation_open_flag;

/* --------------- 修改表 --------------- */
-- 修改表：user_money_details[]
-- 添加字段：
ALTER TABLE user_money_details
    ADD COLUMN `remark` VARCHAR(32) COMMENT '备注信息;' AFTER children_id;


ALTER TABLE rider_bank_card_info
    ADD COLUMN `mch_id` VARCHAR(32) COMMENT '商户id;' AFTER del_flag;