上线时需要的脚本
-- 删除高招,中招菜单
delete from t_base_menu where menu_id in (200,205) or parent_id in (200,205);
-- 删除高招,中招与身份的关系
delete FROM t_base_menu_privilage where menu_id in (select menu_id from t_base_menu where menu_id in (200,205) or parent_id in (200,205));
-- 删除高招,中招与职务+分管工作的关系
delete from t_base_principalship_menu where menu_id in (200,205) or parent_id in (200,205);