Inicio Explorar Ayuda
Registro Iniciar sesión
yeguanglin
/
forecast
1
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Árbol: 7c7380f6cd
Ramas Etiquetas
forecast
/
release_note
/
2026.09.17
/
20260917_dp.sql

20260917_dp.sql 2.1 KB
Histórico Raw

1234567891011 
  1. -- 隐藏菜单
    2. 

  2. UPDATE "public"."sys_menu" set status = 1 where menu_name in ('多源多模型预测', '理论功率预测');
    3. 

  3. 

  4. -- data_weather_local 斜面辐照度字段 -> 总辐照度
    5. 

  5. ALTER TABLE "public"."data_weather_local" RENAME COLUMN "inclined_irradiance" TO "irradiance";
    6. 

  6. COMMENT ON COLUMN "public"."data_weather_local"."irradiance" IS '总辐照度，单位 W/m²';
    7. 

  7. 

  8. -- 短期预测报表菜单
    9. 

  9. INSERT INTO "public"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query", "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (2071, '短期预测日报', 2016, 3, 'shor-term-forecast-daily', 'ufo/datareport/shorTermForecastDailyReport', '', 'ShorTermForecastDailyReport', 1, 0, 'C', '0', '0', 'data:shortTermForecastReport:daily', 'file-text', 'admin', '2026-09-14 00:00:00', '', NULL, '短期预测日报页面');
    10. 

  10. INSERT INTO "public"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query", "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (2072, '短期预测月报', 2016, 4, 'shor-term-forecast-monthly', 'ufo/datareport/shorTermForecastMonthlyReport', '', 'ShorTermForecastMonthlyReport', 1, 0, 'C', '0', '0', 'data:shortTermForecastReport:monthly', 'file-text', 'admin', '2026-09-14 00:00:00', '', NULL, '短期预测月报页面');
    11. 

  11. INSERT INTO "public"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query", "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (2073, '短期预测年报', 2016, 5, 'shor-term-forecast-yearly', 'ufo/datareport/shorTermForecastYearlyReport', '', 'ShorTermForecastYearlyReport', 1, 0, 'C', '0', '0', 'data:shortTermForecastReport:yearly', 'file-text', 'admin', '2026-09-14 00:00:00', '', NULL, '短期预测年报页面');
    12.