water/server/plugin/saiadmin/db/20260822_rollback_merchant_withdrawal_setting.sql

-- 手工回滚脚本。
-- 警告：删除字段会永久丢失所有商户的提现更新配置，请勿在正常升级中执行。

DELETE role_menu
FROM `sa_system_role_menu` role_menu
INNER JOIN `sa_system_menu` menu ON menu.`id` = role_menu.`menu_id`
WHERE menu.`slug` IN (
    'core:merchant:withdrawalSetting:read',
    'core:merchant:withdrawalSetting:update'
);

DELETE FROM `sa_system_menu`
WHERE `slug` IN (
    'core:merchant:withdrawalSetting:read',
    'core:merchant:withdrawalSetting:update'
);

ALTER TABLE `sa_merchant`
    DROP COLUMN `withdraw_update_day`,
    DROP COLUMN `withdraw_update_mode`;