-- 删除管理端「新闻动态发布」模块全部菜单与权限按钮
-- 说明：
-- 1. 仅删除后台菜单、角色授权与翻译菜单选择中的残留 ID
-- 2. 不删除 huayang_news 表数据，也不影响官网前台 /site/news 接口

DELETE FROM `sys_role_menu`
WHERE `menu_id` IN (
  2630, 2631, 2632, 2633,
  2732, 2733, 2734, 2735,
  2880, 2881, 2882, 2883, 2884, 2885,
  2891
);

DELETE FROM `sys_menu`
WHERE `menu_id` IN (
  2732, 2733, 2734, 2735,
  2880, 2881, 2882, 2883, 2884, 2885,
  2891,
  2631, 2632, 2633, 2630
);

UPDATE `huayang_site_config`
SET `config_value` = TRIM(BOTH ',' FROM `config_value`)
WHERE `config_key` = 'translation_menu_selected_ids'
  AND `config_value` IS NOT NULL;

UPDATE `huayang_site_config`
SET `config_value` = TRIM(BOTH ',' FROM
  REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
      REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
        CONCAT(',', COALESCE(`config_value`, ''), ','),
        ',2630,', ','),
      ',2631,', ','),
    ',2632,', ','),
  ',2633,', ','),
  ',2732,', ','),
  ',2733,', ','),
  ',2734,', ','),
  ',2735,', ','),
  ',2880,', ','),
  ',2881,', ','),
  ',2882,', ','),
  ',2883,', ','),
  ',2884,', ','),
  ',2885,', ','),
  ',2891,', ',')
)
WHERE `config_key` = 'translation_menu_selected_ids';