20261021_dp.sql 729 B

12345678910111213
  1. -- 中期功率预测修正菜单
  2. INSERT INTO "public"."sys_menu" (
  3. "menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query",
  4. "route_name", "is_frame", "is_cache", "menu_type", "visible", "status", "perms",
  5. "icon", "create_by", "create_time", "update_by", "update_time", "remark"
  6. )
  7. SELECT
  8. 2087, '中期功率预测修正', 2007, 70, 'mediumTermPowerForecastCorrect', 'ufo/electricity/forecast/DataMediumTermPowerForecastCorrect', NULL,
  9. 'DataMediumTermPowerForecastCorrect', 1, 0, 'C', '0', '0', 'mediumterm:powerForecastCorrect:list',
  10. 'chart', 'admin', '2026-10-21 00:00:00', '', NULL, ''
  11. WHERE NOT EXISTS (
  12. SELECT 1 FROM sys_menu WHERE menu_name = '中期功率预测修正'
  13. );