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

-- 商户设备绑定迁移回滚脚本（仅在需要撤销该功能时手工执行）。
-- 警告：DROP TABLE 会永久删除设备台账、当前绑定关系和绑定/解绑流水。

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:device:index',
    'core:merchant:device:bind',
    'core:merchant:device:unbind'
);

DELETE FROM `sa_system_menu`
WHERE `slug` IN (
    'core:merchant:device:index',
    'core:merchant:device:bind',
    'core:merchant:device:unbind'
);

DROP TABLE IF EXISTS `sa_merchant_device_binding_record`;
DROP TABLE IF EXISTS `sa_merchant_device_binding`;
DROP TABLE IF EXISTS `sa_device`;