上线时需要的脚本

-- 删除高招，中招菜单
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);