UPDATE public.sys_menu
SET order_num = CASE menu_name
    WHEN '辐照度曲线' THEN 10
    WHEN '光伏温度'   THEN 20
    WHEN '光伏风速'   THEN 30
    WHEN '光伏风向'   THEN 40
    WHEN '光伏湿度'   THEN 50
    WHEN '光伏气压'   THEN 60
    ELSE order_num
END
WHERE menu_name IN (
    '辐照度曲线',
    '光伏温度',
    '光伏风速',
    '光伏风向',
    '光伏湿度',
    '光伏气压'
);

update "public"."sys_menu" set menu_name = '辐照度' where menu_name = '辐照度曲线';
update "public"."sys_menu" set menu_name = '风向' where menu_name = '光伏风向';
update "public"."sys_menu" set menu_name = '风速' where menu_name = '光伏风速';
update "public"."sys_menu" set menu_name = '温度' where menu_name = '光伏温度';
update "public"."sys_menu" set menu_name = '湿度' where menu_name = '光伏湿度';
update "public"."sys_menu" set menu_name = '气压' where menu_name = '光伏气压';
update "public"."sys_menu" set order_num = 10 where menu_name = '超短期功率预测';
update "public"."sys_menu" set order_num = 20 where menu_name = '短期功率预测';
update "public"."sys_menu" set order_num = 30 where menu_name = '中期功率预测';
update "public"."sys_menu" set order_num = 40 where menu_name = '辐照度功率对比';
update "public"."sys_menu" set order_num = 50 where menu_name = '超短期功率预测修正';
update "public"."sys_menu" set order_num = 60 where menu_name = '短期功率预测修正';