water/server/plugin/saiadmin/db/20260822_rollback_merchant_daily_statistics.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.`code` IN (
    'MerchantStatistics',
    'MerchantStatisticsRead',
    'MerchantStatisticsExport'
);

DELETE FROM `sa_system_menu`
WHERE `code` IN (
    'MerchantStatistics',
    'MerchantStatisticsRead',
    'MerchantStatisticsExport'
);

DROP TABLE IF EXISTS `sa_merchant_daily_statistics`;