ddl.sql 6.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. -- config_station 增加逆变器数量(幂等)
  2. ALTER TABLE config_station ADD COLUMN IF NOT EXISTS inverter_quantity integer;
  3. COMMENT ON COLUMN config_station.inverter_quantity IS '逆变器数量(测光法理论功率用)';
  4. -- 增加 理论功率 一级菜单
  5. INSERT INTO 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)
  6. SELECT
  7. nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
  8. '理论功率', 0, 20, 'theoretical', '', '', '', 1, 0, 'M', '0', '0', '', 'ThunderboltOutlined', 'admin', now(), '', NULL, '理论功率一级菜单'
  9. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '理论功率');
  10. -- 增加 光伏理论功率 二级菜单
  11. INSERT INTO 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)
  12. SELECT
  13. nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
  14. '光伏理论功率',
  15. (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
  16. 10, 'pv-theoretical-power', 'ufo/theoretical/PvTheoreticalPower', '', 'PvTheoreticalPower', 1, 0, 'C', '0', '0', 'theoretical:power:list', 'LineChartOutlined', 'admin', now(), '', NULL, '光伏理论功率页面'
  17. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏理论功率');
  18. -- 增加 光伏受阻电量 二级菜单
  19. INSERT INTO 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)
  20. SELECT
  21. nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
  22. '光伏受阻电量',
  23. (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
  24. 20, 'pv-curtailment-energy', 'ufo/theoretical/PvCurtailmentEnergy', '', 'PvCurtailmentEnergy', 1, 0, 'C', '0', '0', 'theoretical:curtailedEnergy:list', 'AreaChartOutlined', 'admin', now(), '', NULL, '光伏受阻电量页面'
  25. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏受阻电量');
  26. -- 增加 光伏场站逻辑校核 二级菜单
  27. INSERT INTO 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)
  28. SELECT
  29. nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
  30. '光伏场站逻辑校核',
  31. (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
  32. 30, 'pv-station-logic-check', 'ufo/theoretical/PvStationLogicCheck', '', 'PvStationLogicCheck', 1, 0, 'C', '0', '0', 'theoretical:logicCheck:list', 'AuditOutlined', 'admin', now(), '', NULL, '光伏场站逻辑校核页面'
  33. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏场站逻辑校核');
  34. -- 增加 光伏场外受阻电力校核 二级菜单
  35. INSERT INTO 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)
  36. SELECT
  37. nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
  38. '光伏场外受阻电力校核',
  39. (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
  40. 40, 'pv-off-site-power-check', 'ufo/theoretical/PvOffSitePowerCheck', '', 'PvOffSitePowerCheck', 1, 0, 'C', '0', '0', 'theoretical:offSiteCheck:list', 'SafetyOutlined', 'admin', now(), '', NULL, '光伏场外受阻电力校核页面'
  41. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏场外受阻电力校核');
  42. -- 增加 光伏场内受阻电力校核 二级菜单
  43. INSERT INTO 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)
  44. SELECT
  45. nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
  46. '光伏场内受阻电力校核',
  47. (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
  48. 50, 'pv-intra-plant-power-check', 'ufo/theoretical/PvIntraPlantPowerCheck', '', 'PvIntraPlantPowerCheck', 1, 0, 'C', '0', '0', 'theoretical:intraPlantCheck:list', 'SafetyCertificateOutlined', 'admin', now(), '', NULL, '光伏场内受阻电力校核页面'
  49. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏场内受阻电力校核');
  50. -- 增加 光伏受阻电量日报 二级菜单
  51. INSERT INTO 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)
  52. SELECT
  53. nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
  54. '光伏受阻电量日报',
  55. (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
  56. 60, 'pv-curtailment-energy-daily', 'ufo/theoretical/PvCurtailmentEnergyDaily', '', 'PvCurtailmentEnergyDaily', 1, 0, 'C', '0', '0', 'theoretical:dailyReport:list', 'FileTextOutlined', 'admin', now(), '', NULL, '光伏受阻电量日报页面'
  57. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏受阻电量日报');
  58. -- 增加 光伏受阻电量月报 二级菜单
  59. INSERT INTO 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)
  60. SELECT
  61. nextval(pg_get_serial_sequence('sys_menu', 'menu_id')),
  62. '光伏受阻电量月报',
  63. (select menu_id from sys_menu t where t.menu_name = '理论功率' and t.parent_id = 0),
  64. 70, 'pv-curtailment-energy-monthly', 'ufo/theoretical/PvCurtailmentEnergyMonthly', '', 'PvCurtailmentEnergyMonthly', 1, 0, 'C', '0', '0', 'theoretical:monthlyReport:list', 'CalendarOutlined', 'admin', now(), '', NULL, '光伏受阻电量月报页面'
  65. WHERE NOT EXISTS (SELECT 1 FROM sys_menu t WHERE t.menu_name = '光伏受阻电量月报');