首頁 探索 說明
登入
liaoyitao
/
CMYH-SERVER
關註 1
讚好 0
複刻 0
Files 問題管理 0 合併請求 0 Wiki
目錄樹: 1e24caffa1
分支列表 標籤列表
CMYH-SERVER
/
src
/
main
/
resources
/
db
/
migration
/
V1_5__20241111_menu.sql

V1_5__20241111_menu.sql 53 KB
文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410 
  1. -- 菜单 SQL
    2. 

  2. 

  3. 

  4. INSERT INTO "public"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (2050, '属性类别管理', 0, 0, 'type', NULL, NULL, 'f', 't', 'M', 't', 't', NULL, 'management', '超级管理员', '2024-11-11 10:24:59.159073', NULL, NULL, NULL);
    5. 

  5. 

  6. SELECT setval('sys_menu_menu_id_seq', (SELECT MAX(menu_id) FROM sys_menu));
    7. 

  7. 

  8. 

  9. 

  10. with temp_menu as (
    11. 

  11. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    12. 

  12. values('区域类型', '2050', '1', 'areaType', 'type/areaType/index', false, true, 'C', true, true, 'type:areaType:list', 'operation', 'admin', now(), '', null, '区域类型：area_type菜单') returning menu_id
    13. 

  13.     )
    14. 

  14. 

  15. 

  16. -- 按钮 SQL
    17. 

  17. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    18. 

  18. values('区域类型', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'type:areaType:query',        '#', 'admin', now(), '', null, ''),
    19. 

  19.     ('区域类型', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'type:areaType:add',          '#', 'admin', now(), '', null, ''),
    20. 

  20.     ('区域类型', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'type:areaType:edit',         '#', 'admin', now(), '', null, ''),
    21. 

  21.     ('区域类型', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'type:areaType:remove',       '#', 'admin', now(), '', null, ''),
    22. 

  22.     ('区域类型', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'type:areaType:export',       '#', 'admin', now(), '', null, '');
    23. 

  23. 

  24. 

  25. 

  26. 

  27. 

  28. 

  29. -- 菜单 SQL
    30. 

  30. with temp_menu as (
    31. 

  31. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    32. 

  32. values('大楼类别', '2050', '1', 'buildingType', 'type/buildingType/index', false, true, 'C', true, true, 'type:buildingType:list', 'operation', 'admin', now(), '', null, '大楼类别：building_type菜单') returning menu_id
    33. 

  33.     )
    34. 

  34. -- 按钮 SQL
    35. 

  35. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    36. 

  36. values('大楼类别', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'type:buildingType:query',        '#', 'admin', now(), '', null, ''),
    37. 

  37.     ('大楼类别', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'type:buildingType:add',          '#', 'admin', now(), '', null, ''),
    38. 

  38.     ('大楼类别', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'type:buildingType:edit',         '#', 'admin', now(), '', null, ''),
    39. 

  39.     ('大楼类别', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'type:buildingType:remove',       '#', 'admin', now(), '', null, ''),
    40. 

  40.     ('大楼类别', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'type:buildingType:export',       '#', 'admin', now(), '', null, '');
    41. 

  41. 

  42. 

  43. 

  44. -- 菜单 SQL
    45. 

  45. with temp_menu as (
    46. 

  46. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    47. 

  47. values('设备类型', '2050', '1', 'equipmentType', 'type/equipmentType/index', false, true, 'C', true, true, 'type:equipmentType:list', 'operation', 'admin', now(), '', null, '设备类型：equipment_type菜单') returning menu_id
    48. 

  48.     )
    49. 

  49. -- 按钮 SQL
    50. 

  50. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    51. 

  51. values('设备类型', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'type:equipmentType:query',        '#', 'admin', now(), '', null, ''),
    52. 

  52.     ('设备类型', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'type:equipmentType:add',          '#', 'admin', now(), '', null, ''),
    53. 

  53.     ('设备类型', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'type:equipmentType:edit',         '#', 'admin', now(), '', null, ''),
    54. 

  54.     ('设备类型', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'type:equipmentType:remove',       '#', 'admin', now(), '', null, ''),
    55. 

  55.     ('设备类型', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'type:equipmentType:export',       '#', 'admin', now(), '', null, '');
    56. 

  56. 

  57. 

  58. 

  59. -- 菜单 SQL
    60. 

  60. with temp_menu as (
    61. 

  61. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    62. 

  62. values('户型信息', '2050', '1', 'houseType', 'type/houseType/index', false, true, 'C', true, true, 'type:houseType:list', 'operation', 'admin', now(), '', null, '户型信息：house_type菜单') returning menu_id
    63. 

  63.     )
    64. 

  64. -- 按钮 SQL
    65. 

  65. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    66. 

  66. values('户型信息', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'type:houseType:query',        '#', 'admin', now(), '', null, ''),
    67. 

  67.     ('户型信息', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'type:houseType:add',          '#', 'admin', now(), '', null, ''),
    68. 

  68.     ('户型信息', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'type:houseType:edit',         '#', 'admin', now(), '', null, ''),
    69. 

  69.     ('户型信息', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'type:houseType:remove',       '#', 'admin', now(), '', null, ''),
    70. 

  70.     ('户型信息', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'type:houseType:export',       '#', 'admin', now(), '', null, '');
    71. 

  71. 

  72. 

  73. 

  74. -- 菜单 SQL
    75. 

  75. with temp_menu as (
    76. 

  76. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    77. 

  77. values('主体类型', '2050', '1', 'organizationType', 'type/organizationType/index', false, true, 'C', true, true, 'type:organizationType:list', 'operation', 'admin', now(), '', null, '主体类型菜单') returning menu_id
    78. 

  78.     )
    79. 

  79. -- 按钮 SQL
    80. 

  80. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    81. 

  81. values('主体类型查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'type:organizationType:query',        '#', 'admin', now(), '', null, ''),
    82. 

  82.     ('主体类型新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'type:organizationType:add',          '#', 'admin', now(), '', null, ''),
    83. 

  83.     ('主体类型修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'type:organizationType:edit',         '#', 'admin', now(), '', null, ''),
    84. 

  84.     ('主体类型删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'type:organizationType:remove',       '#', 'admin', now(), '', null, ''),
    85. 

  85.     ('主体类型导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'type:organizationType:export',       '#', 'admin', now(), '', null, '');
    86. 

  86. 

  87. 

  88. 

  89. -- 菜单 SQL
    90. 

  90. with temp_menu as (
    91. 

  91. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    92. 

  92. values('规划类型', '2050', '1', 'planType', 'type/planType/index', false, true, 'C', true, true, 'type:planType:list', 'operation', 'admin', now(), '', null, '规划类型菜单') returning menu_id
    93. 

  93.     )
    94. 

  94. -- 按钮 SQL
    95. 

  95. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    96. 

  96. values('规划类型查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'type:planType:query',        '#', 'admin', now(), '', null, ''),
    97. 

  97.     ('规划类型新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'type:planType:add',          '#', 'admin', now(), '', null, ''),
    98. 

  98.     ('规划类型修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'type:planType:edit',         '#', 'admin', now(), '', null, ''),
    99. 

  99.     ('规划类型删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'type:planType:remove',       '#', 'admin', now(), '', null, ''),
    100. 

  100.     ('规划类型导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'type:planType:export',       '#', 'admin', now(), '', null, '');
    101. 

  101. 

  102. 

  103. 

  104. -- 菜单 SQL
    105. 

  105. with temp_menu as (
    106. 

  106. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    107. 

  107. values('房间类别', '2050', '1', 'roomType', 'type/roomType/index', false, true, 'C', true, true, 'type:roomType:list', 'operation', 'admin', now(), '', null, '房间类别菜单') returning menu_id
    108. 

  108.     )
    109. 

  109. -- 按钮 SQL
    110. 

  110. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    111. 

  111. values('房间类别查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'type:roomType:query',        '#', 'admin', now(), '', null, ''),
    112. 

  112.     ('房间类别新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'type:roomType:add',          '#', 'admin', now(), '', null, ''),
    113. 

  113.     ('房间类别修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'type:roomType:edit',         '#', 'admin', now(), '', null, ''),
    114. 

  114.     ('房间类别删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'type:roomType:remove',       '#', 'admin', now(), '', null, ''),
    115. 

  115.     ('房间类别导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'type:roomType:export',       '#', 'admin', now(), '', null, '');
    116. 

  116. 

  117. 

  118. 

  119. -- 菜单 SQL
    120. 

  120. with temp_menu as (
    121. 

  121. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    122. 

  122. values('交通类型', '2050', '1', 'trafficType', 'type/trafficType/index', false, true, 'C', true, true, 'type:trafficType:list', 'operation', 'admin', now(), '', null, '交通类型菜单') returning menu_id
    123. 

  123.     )
    124. 

  124. -- 按钮 SQL
    125. 

  125. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    126. 

  126. values('交通类型查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'type:trafficType:query',        '#', 'admin', now(), '', null, ''),
    127. 

  127.     ('交通类型新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'type:trafficType:add',          '#', 'admin', now(), '', null, ''),
    128. 

  128.     ('交通类型修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'type:trafficType:edit',         '#', 'admin', now(), '', null, ''),
    129. 

  129.     ('交通类型删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'type:trafficType:remove',       '#', 'admin', now(), '', null, ''),
    130. 

  130.     ('交通类型导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'type:trafficType:export',       '#', 'admin', now(), '', null, '');
    131. 

  131. 

  132. INSERT INTO "public"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (2200, '属性信息管理', 0, 0, 'info', NULL, NULL, 'f', 't', 'M', 't', 't', NULL, 'management', '超级管理员', '2024-11-11 17:14:06.847279', NULL, NULL, NULL);
    133. 

  133. 

  134. SELECT setval('sys_menu_menu_id_seq', (SELECT MAX(menu_id) FROM sys_menu));
    135. 

  135. 

  136. -- 菜单 SQL
    137. 

  137. with temp_menu as (
    138. 

  138. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    139. 

  139. values('区域对象', '2200', '1', 'areaInfo', 'info/areaInfo/index', false, true, 'C', true, true, 'info:areaInfo:list', 'operation', 'admin', now(), '', null, '区域对象菜单') returning menu_id
    140. 

  140.     )
    141. 

  141. -- 按钮 SQL
    142. 

  142. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    143. 

  143. values('区域对象查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:areaInfo:query',        '#', 'admin', now(), '', null, ''),
    144. 

  144.     ('区域对象新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:areaInfo:add',          '#', 'admin', now(), '', null, ''),
    145. 

  145.     ('区域对象修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:areaInfo:edit',         '#', 'admin', now(), '', null, ''),
    146. 

  146.     ('区域对象删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:areaInfo:remove',       '#', 'admin', now(), '', null, ''),
    147. 

  147.     ('区域对象导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:areaInfo:export',       '#', 'admin', now(), '', null, '');
    148. 

  148. 

  149. 

  150. -- 菜单 SQL
    151. 

  151. with temp_menu as (
    152. 

  152. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    153. 

  153. values('大楼信息', '2200', '1', 'buildingInfo', 'info/buildingInfo/index', false, true, 'C', true, true, 'info:buildingInfo:list', 'operation', 'admin', now(), '', null, '大楼信息菜单') returning menu_id
    154. 

  154.     )
    155. 

  155. -- 按钮 SQL
    156. 

  156. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    157. 

  157. values('大楼信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:buildingInfo:query',        '#', 'admin', now(), '', null, ''),
    158. 

  158.     ('大楼信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:buildingInfo:add',          '#', 'admin', now(), '', null, ''),
    159. 

  159.     ('大楼信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:buildingInfo:edit',         '#', 'admin', now(), '', null, ''),
    160. 

  160.     ('大楼信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:buildingInfo:remove',       '#', 'admin', now(), '', null, ''),
    161. 

  161.     ('大楼信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:buildingInfo:export',       '#', 'admin', now(), '', null, '');
    162. 

  162. 

  163. 

  164. 

  165. -- 菜单 SQL
    166. 

  166. with temp_menu as (
    167. 

  167. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    168. 

  168. values('电梯信息', '2200', '1', 'elevatorInfo', 'info/elevatorInfo/index', false, true, 'C', true, true, 'info:elevatorInfo:list', 'operation', 'admin', now(), '', null, '电梯信息菜单') returning menu_id
    169. 

  169.     )
    170. 

  170. -- 按钮 SQL
    171. 

  171. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    172. 

  172. values('电梯信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:elevatorInfo:query',        '#', 'admin', now(), '', null, ''),
    173. 

  173.     ('电梯信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:elevatorInfo:add',          '#', 'admin', now(), '', null, ''),
    174. 

  174.     ('电梯信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:elevatorInfo:edit',         '#', 'admin', now(), '', null, ''),
    175. 

  175.     ('电梯信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:elevatorInfo:remove',       '#', 'admin', now(), '', null, ''),
    176. 

  176.     ('电梯信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:elevatorInfo:export',       '#', 'admin', now(), '', null, '');
    177. 

  177. 

  178. 

  179. 

  180. 

  181. -- 菜单 SQL
    182. 

  182. with temp_menu as (
    183. 

  183. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    184. 

  184. values('设备信息', '2200', '1', 'equipmentInfo', 'info/equipmentInfo/index', false, true, 'C', true, true, 'info:equipmentInfo:list', 'operation', 'admin', now(), '', null, '设备信息菜单') returning menu_id
    185. 

  185.     )
    186. 

  186. -- 按钮 SQL
    187. 

  187. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    188. 

  188. values('设备信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:equipmentInfo:query',        '#', 'admin', now(), '', null, ''),
    189. 

  189.     ('设备信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:equipmentInfo:add',          '#', 'admin', now(), '', null, ''),
    190. 

  190.     ('设备信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:equipmentInfo:edit',         '#', 'admin', now(), '', null, ''),
    191. 

  191.     ('设备信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:equipmentInfo:remove',       '#', 'admin', now(), '', null, ''),
    192. 

  192.     ('设备信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:equipmentInfo:export',       '#', 'admin', now(), '', null, '');
    193. 

  193. 

  194. 

  195. 

  196. -- 菜单 SQL
    197. 

  197. with temp_menu as (
    198. 

  198. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    199. 

  199. values('预警信息', '2200', '1', 'forewarningInfo', 'info/forewarningInfo/index', false, true, 'C', true, true, 'info:forewarningInfo:list', 'operation', 'admin', now(), '', null, '预警信息菜单') returning menu_id
    200. 

  200.     )
    201. 

  201. -- 按钮 SQL
    202. 

  202. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    203. 

  203. values('预警信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:forewarningInfo:query',        '#', 'admin', now(), '', null, ''),
    204. 

  204.     ('预警信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:forewarningInfo:add',          '#', 'admin', now(), '', null, ''),
    205. 

  205.     ('预警信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:forewarningInfo:edit',         '#', 'admin', now(), '', null, ''),
    206. 

  206.     ('预警信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:forewarningInfo:remove',       '#', 'admin', now(), '', null, ''),
    207. 

  207.     ('预警信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:forewarningInfo:export',       '#', 'admin', now(), '', null, '');
    208. 

  208. 

  209. 

  210. 

  211. -- 菜单 SQL
    212. 

  212. with temp_menu as (
    213. 

  213. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    214. 

  214. values('主体信息', '2200', '1', 'organizationInfo', 'info/organizationInfo/index', false, true, 'C', true, true, 'info:organizationInfo:list', 'operation', 'admin', now(), '', null, '主体信息菜单') returning menu_id
    215. 

  215.     )
    216. 

  216. -- 按钮 SQL
    217. 

  217. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    218. 

  218. values('主体信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:organizationInfo:query',        '#', 'admin', now(), '', null, ''),
    219. 

  219.     ('主体信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:organizationInfo:add',          '#', 'admin', now(), '', null, ''),
    220. 

  220.     ('主体信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:organizationInfo:edit',         '#', 'admin', now(), '', null, ''),
    221. 

  221.     ('主体信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:organizationInfo:remove',       '#', 'admin', now(), '', null, ''),
    222. 

  222.     ('主体信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:organizationInfo:export',       '#', 'admin', now(), '', null, '');
    223. 

  223. 

  224. 

  225. 

  226. 

  227. -- 菜单 SQL
    228. 

  228. with temp_menu as (
    229. 

  229. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    230. 

  230. values('规划对象', '2200', '1', 'planInfo', 'info/planInfo/index', false, true, 'C', true, true, 'info:planInfo:list', 'operation', 'admin', now(), '', null, '规划对象菜单') returning menu_id
    231. 

  231. )
    232. 

  232. -- 按钮 SQL
    233. 

  233. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    234. 

  234. values('规划对象查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:planInfo:query',        '#', 'admin', now(), '', null, ''),
    235. 

  235. ('规划对象新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:planInfo:add',          '#', 'admin', now(), '', null, ''),
    236. 

  236. ('规划对象修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:planInfo:edit',         '#', 'admin', now(), '', null, ''),
    237. 

  237. ('规划对象删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:planInfo:remove',       '#', 'admin', now(), '', null, ''),
    238. 

  238. ('规划对象导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:planInfo:export',       '#', 'admin', now(), '', null, '');
    239. 

  239. 

  240. 

  241. 

  242. -- 菜单 SQL
    243. 

  243. with temp_menu as (
    244. 

  244. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    245. 

  245. values('政策信息', '2200', '1', 'policyInfo', 'info/policyInfo/index', false, true, 'C', true, true, 'info:policyInfo:list', 'operation', 'admin', now(), '', null, '政策信息菜单') returning menu_id
    246. 

  246. )
    247. 

  247. -- 按钮 SQL
    248. 

  248. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    249. 

  249. values('政策信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:policyInfo:query',        '#', 'admin', now(), '', null, ''),
    250. 

  250. ('政策信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:policyInfo:add',          '#', 'admin', now(), '', null, ''),
    251. 

  251. ('政策信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:policyInfo:edit',         '#', 'admin', now(), '', null, ''),
    252. 

  252. ('政策信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:policyInfo:remove',       '#', 'admin', now(), '', null, ''),
    253. 

  253. ('政策信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:policyInfo:export',       '#', 'admin', now(), '', null, '');
    254. 

  254. 

  255. 

  256. 

  257. 

  258. -- 菜单 SQL
    259. 

  259. with temp_menu as (
    260. 

  260. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    261. 

  261. values('房间信息', '2200', '1', 'roomInfo', 'info/roomInfo/index', false, true, 'C', true, true, 'info:roomInfo:list', 'operation', 'admin', now(), '', null, '房间信息菜单') returning menu_id
    262. 

  262. )
    263. 

  263. -- 按钮 SQL
    264. 

  264. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    265. 

  265. values('房间信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:roomInfo:query',        '#', 'admin', now(), '', null, ''),
    266. 

  266. ('房间信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:roomInfo:add',          '#', 'admin', now(), '', null, ''),
    267. 

  267. ('房间信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:roomInfo:edit',         '#', 'admin', now(), '', null, ''),
    268. 

  268. ('房间信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:roomInfo:remove',       '#', 'admin', now(), '', null, ''),
    269. 

  269. ('房间信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:roomInfo:export',       '#', 'admin', now(), '', null, '');
    270. 

  270. 

  271. 

  272. 

  273. 

  274. -- 菜单 SQL
    275. 

  275. with temp_menu as (
    276. 

  276. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    277. 

  277. values('站点信息', '2200', '1', 'stationInfo', 'info/stationInfo/index', false, true, 'C', true, true, 'info:stationInfo:list', 'operation', 'admin', now(), '', null, '站点信息菜单') returning menu_id
    278. 

  278. )
    279. 

  279. -- 按钮 SQL
    280. 

  280. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    281. 

  281. values('站点信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:stationInfo:query',        '#', 'admin', now(), '', null, ''),
    282. 

  282. ('站点信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:stationInfo:add',          '#', 'admin', now(), '', null, ''),
    283. 

  283. ('站点信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:stationInfo:edit',         '#', 'admin', now(), '', null, ''),
    284. 

  284. ('站点信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:stationInfo:remove',       '#', 'admin', now(), '', null, ''),
    285. 

  285. ('站点信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:stationInfo:export',       '#', 'admin', now(), '', null, '');
    286. 

  286. 

  287. 

  288. 

  289. 

  290. -- 菜单 SQL
    291. 

  291. with temp_menu as (
    292. 

  292. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    293. 

  293. values('交通对象', '2200', '1', 'trafficInfo', 'info/trafficInfo/index', false, true, 'C', true, true, 'info:trafficInfo:list', 'operation', 'admin', now(), '', null, '交通对象菜单') returning menu_id
    294. 

  294. )
    295. 

  295. -- 按钮 SQL
    296. 

  296. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    297. 

  297. values('交通对象查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:trafficInfo:query',        '#', 'admin', now(), '', null, ''),
    298. 

  298. ('交通对象新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:trafficInfo:add',          '#', 'admin', now(), '', null, ''),
    299. 

  299. ('交通对象修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:trafficInfo:edit',         '#', 'admin', now(), '', null, ''),
    300. 

  300. ('交通对象删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:trafficInfo:remove',       '#', 'admin', now(), '', null, ''),
    301. 

  301. ('交通对象导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:trafficInfo:export',       '#', 'admin', now(), '', null, '');
    302. 

  302. 

  303. 

  304. 

  305. 

  306. INSERT INTO "public"."sys_menu" ("menu_id", "menu_name", "parent_id", "order_num", "path", "component", "query", "is_frame", "is_cache", "menu_type", "visible", "status", "perms", "icon", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (2279, '城市推荐', 0, 0, 'recommend', NULL, NULL, 'f', 't', 'M', 't', 't', NULL, 'validCode', '超级管理员', '2024-11-18 11:10:53.179662', NULL, NULL, NULL);
    307. 

  307. 

  308. 

  309. 

  310. 

  311. 

  312. -- 菜单 SQL
    313. 

  313. with temp_menu as (
    314. 

  314. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    315. 

  315. values('综合分析', '2279', '1', 'synthesisAnalyze', 'view/synthesisAnalyze/index', false, true, 'C', true, true, 'view:synthesisAnalyze:list', 'operation', 'admin', now(), '', null, '综合分析菜单') returning menu_id
    316. 

  316. )
    317. 

  317. -- 按钮 SQL
    318. 

  318. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    319. 

  319. values('综合分析查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'view:synthesisAnalyze:query',        '#', 'admin', now(), '', null, ''),
    320. 

  320. ('综合分析新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'view:synthesisAnalyze:add',          '#', 'admin', now(), '', null, ''),
    321. 

  321. ('综合分析修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'view:synthesisAnalyze:edit',         '#', 'admin', now(), '', null, ''),
    322. 

  322. ('综合分析删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'view:synthesisAnalyze:remove',       '#', 'admin', now(), '', null, ''),
    323. 

  323. ('综合分析导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'view:synthesisAnalyze:export',       '#', 'admin', now(), '', null, '');
    324. 

  324. 

  325. 

  326. 

  327. 

  328. 

  329. -- 菜单 SQL
    330. 

  330. with temp_menu as (
    331. 

  331. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    332. 

  332. values('模型信息', '2200', '1', 'modelInfo', 'info/modelInfo/index', false, true, 'C', true, true, 'info:modelInfo:list', 'operation', 'admin', now(), '', null, '模型信息菜单') returning menu_id
    333. 

  333. )
    334. 

  334. -- 按钮 SQL
    335. 

  335. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
    336. 

  336. values('模型信息查询', (select * from temp_menu), '1',  '#', '', false, true, 'F', true, true, 'info:modelInfo:query',        '#', 'admin', now(), '', null, ''),
    337. 

  337. ('模型信息新增', (select * from temp_menu), '2',  '#', '', false, true, 'F', true, true, 'info:modelInfo:add',          '#', 'admin', now(), '', null, ''),
    338. 

  338. ('模型信息修改', (select * from temp_menu), '3',  '#', '', false, true, 'F', true, true, 'info:modelInfo:edit',         '#', 'admin', now(), '', null, ''),
    339. 

  339. ('模型信息删除', (select * from temp_menu), '4',  '#', '', false, true, 'F', true, true, 'info:modelInfo:remove',       '#', 'admin', now(), '', null, ''),
    340. 

  340. ('模型信息导出', (select * from temp_menu), '5',  '#', '', false, true, 'F', true, true, 'info:modelInfo:export',       '#', 'admin', now(), '', null, '');
    341. 

  341. 

  342. SELECT setval('sys_menu_menu_id_seq', (SELECT MAX(menu_id) FROM sys_menu));
    343. 

  343. 

  344. ALTER TABLE organization_info ADD COLUMN audio varchar(255);
    345. 

  345. comment on column organization_info.audio is '视频';
    346. 

  346. 

  347. 

  348. 

  349. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (102, '运营体系', 'operation_system', 't', '超级管理员', '2024-11-26 13:50:37.402144', NULL, NULL, NULL);
    350. 

  350. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (103, '服务体系', 'service_system', 't', '超级管理员', '2024-11-26 13:55:20.453367', NULL, NULL, NULL);
    351. 

  351. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (104, '增长趋势', 'growth_trend', 't', '超级管理员', '2024-11-26 14:01:21.516976', NULL, NULL, NULL);
    352. 

  352. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (105, '企业服务', 'enterprise_service', 't', '超级管理员', '2024-11-26 14:04:23.223561', NULL, NULL, NULL);
    353. 

  353. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (106, '轨道路实时监测', 'railway_realTime_monitoring', 't', '超级管理员', '2024-11-26 14:08:52.391697', NULL, NULL, NULL);
    354. 

  354. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (107, '重点区域配套设施', 'key_area_support_facilities', 't', '超级管理员', '2024-11-26 14:12:19.205583', NULL, NULL, NULL);
    355. 

  355. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (108, '重点区域植被', 'key_area_vegetation', 't', '超级管理员', '2024-11-26 14:16:10.188997', NULL, NULL, NULL);
    356. 

  356. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (109, '主要区域拥堵', 'main_area_congestion', 't', '超级管理员', '2024-11-26 14:18:26.133476', NULL, NULL, NULL);
    357. 

  357. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (110, '建筑土地概况', 'building_land_overview', 't', '超级管理员', '2024-11-26 17:13:04.015269', NULL, NULL, NULL);
    358. 

  358. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (111, '建筑土地统计', 'building_land_statistics', 't', '超级管理员', '2024-11-26 17:18:07.640768', NULL, NULL, NULL);
    359. 

  359. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (112, '成本效益统计', 'cost_benefit_stat', 't', '超级管理员', '2024-11-27 14:09:53.336277', NULL, NULL, NULL);
    360. 

  360. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (113, '成本效益分析', 'cost_benefit_analysis', 't', '超级管理员', '2024-11-27 18:41:59.075476', NULL, NULL, NULL);
    361. 

  361. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (114, '主要区域车流量情况', 'main_area_traffic_flow', 't', '超级管理员', '2024-11-27 18:50:00.433443', NULL, NULL, NULL);
    362. 

  362. INSERT INTO "public"."sys_dict_type" ("dict_id", "dict_name", "dict_type", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (101, '道路实时路况监测', 'road-realtime-traffic', 't', '超级管理员', '2024-11-26 10:19:45.947831', '超级管理员', '2024-11-27 19:36:39.630993', NULL);
    363. 

  363. 

  364. SELECT setval('sys_dict_type_dict_id_seq', (SELECT MAX(dict_id) FROM sys_dict_type));
    365. 

  365. 

  366. 

  367. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (119, 1, '政策咨询', '385/个', 'enterprise_service', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:04:53.442761', NULL, NULL, NULL);
    368. 

  368. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (120, 2, '工商服务', '25/个', 'enterprise_service', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:05:20.327122', NULL, NULL, NULL);
    369. 

  369. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (121, 3, '法律服务', '128/个', 'enterprise_service', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:05:40.933106', NULL, NULL, NULL);
    370. 

  370. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (122, 4, '财税服务', '235/个', 'enterprise_service', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:06:03.814214', NULL, NULL, NULL);
    371. 

  371. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (123, 5, '行政服务', '25/个', 'enterprise_service', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:06:24.501192', NULL, NULL, NULL);
    372. 

  372. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (124, 6, '人才服务', '125/个', 'enterprise_service', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:06:42.086761', NULL, NULL, NULL);
    373. 

  373. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (125, 1, '客流量超限：', '30%', 'railway_realTime_monitoring', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:09:28.257169', NULL, NULL, NULL);
    374. 

  374. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (126, 2, '范围故障', '1', 'railway_realTime_monitoring', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:09:44.849027', NULL, NULL, NULL);
    375. 

  375. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (127, 4, '进出站超限：', '50%', 'railway_realTime_monitoring', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:10:03.912008', '超级管理员', '2024-11-27 19:41:07.646659', NULL);
    376. 

  376. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (128, 1, '路灯', '65/盏', 'key_area_support_facilities', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:12:54.220285', NULL, NULL, NULL);
    377. 

  377. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (129, 2, '信号灯', '65/盏', 'key_area_support_facilities', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:13:09.607786', NULL, NULL, NULL);
    378. 

  378. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (130, 3, '摄像头', '44/个', 'key_area_support_facilities', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:13:26.696732', NULL, NULL, NULL);
    379. 

  379. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (131, 4, '路灯状态正常率', '75%', 'key_area_support_facilities', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:13:54.044901', NULL, NULL, NULL);
    380. 

  380. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (132, 5, '信号灯状态正常率', '80%', 'key_area_support_facilities', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:14:20.425779', NULL, NULL, NULL);
    381. 

  381. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (133, 6, '摄像头状态正常率', '75%', 'key_area_support_facilities', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:14:45.635276', NULL, NULL, NULL);
    382. 

  382. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (138, 1, '景区周边', '60', 'main_area_congestion', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:18:47.877352', NULL, NULL, NULL);
    383. 

  383. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (139, 2, '高架桥', '30', 'main_area_congestion', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:18:58.578353', NULL, NULL, NULL);
    384. 

  384. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (140, 3, '地铁周边', '20', 'main_area_congestion', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:19:15.167956', NULL, NULL, NULL);
    385. 

  385. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (141, 4, '高铁站周边', '15', 'main_area_congestion', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:19:29.632493', NULL, NULL, NULL);
    386. 

  386. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (142, 1, '土地总面积', '63165654㎡', 'building_land_overview', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 17:14:22.918916', '超级管理员', '2024-11-27 21:23:21.779921', NULL);
    387. 

  387. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (143, 2, '实施规划总面积', '631654335㎡', 'building_land_overview', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 17:15:25.94592', '超级管理员', '2024-11-27 21:23:27.476002', NULL);
    388. 

  388. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (144, 3, '总计人口', '165654人', 'building_land_overview', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 17:15:46.687935', '超级管理员', '2024-11-27 21:24:06.422606', NULL);
    389. 

  389. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (145, 4, '实施面积', '23245614㎡', 'building_land_overview', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 17:16:11.405326', '超级管理员', '2024-11-27 21:23:31.425318', NULL);
    390. 

  390. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (136, 3, '科创园', '750', 'key_area_vegetation', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:17:15.521613', '超级管理员', '2024-11-28 05:17:16.049961', NULL);
    391. 

  391. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (137, 4, '金茂悦', '650', 'key_area_vegetation', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:17:27.688341', '超级管理员', '2024-11-28 05:17:34.241364', NULL);
    392. 

  392. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (146, 5, '竣工面积', '1165654㎡', 'building_land_overview', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 17:16:29.858606', '超级管理员', '2024-11-27 21:23:34.872682', NULL);
    393. 

  393. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (147, 6, '开发面积', '63165654㎡', 'building_land_overview', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 17:16:47.177077', '超级管理员', '2024-11-27 21:23:37.64406', NULL);
    394. 

  394. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (154, 1, '成本', '820, 932, 901, 934', 'cost_benefit_stat', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 14:28:32.823209', '超级管理员', '2024-11-27 23:09:18.464354', '');
    395. 

  395. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (155, 2, '收益', '789, 889, 976, 994', 'cost_benefit_stat', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 16:35:41.823213', '超级管理员', '2024-11-27 23:22:21.2707', NULL);
    396. 

  396. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (156, 3, '总占比', '60%', 'cost_benefit_stat', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 16:44:46.94886', '超级管理员', '2024-11-27 19:02:19.729605', NULL);
    397. 

  397. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (157, 6, '建筑土地统计', '280,430,310,400,210,370', 'building_land_statistics', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 17:33:03.51135', '超级管理员', '2024-11-27 17:34:02.226899', NULL);
    398. 

  398. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (158, 1, '市场风险', '35.17%', 'cost_benefit_analysis', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 18:43:03.282318', '超级管理员', '2024-11-27 18:43:07.420497', NULL);
    399. 

  399. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (159, 2, '财务风险', '28.57%', 'cost_benefit_analysis', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 18:43:37.766606', '超级管理员', '2024-11-27 18:44:59.836162', NULL);
    400. 

  400. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (160, 3, '操作风险', '21.43%', 'cost_benefit_analysis', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 18:44:18.368932', '超级管理员', '2024-11-27 18:45:05.257761', NULL);
    401. 

  401. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (161, 4, '法律风险', '14.29%', 'cost_benefit_analysis', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 18:44:50.36676', '超级管理员', '2024-11-27 18:45:09.223132', NULL);
    402. 

  402. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (162, 1, '今日', '20，33，42，33，53，61，45', 'main_area_traffic_flow', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 18:53:13.313762', '超级管理员', '2024-11-27 18:57:26.366458', NULL);
    403. 

  403. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (163, 2, '昨日环比', '25，38，46，39，57，66，49', 'main_area_traffic_flow', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 18:57:21.112725', '超级管理员', '2024-11-27 18:57:30.133556', NULL);
    404. 

  404. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (164, 0, '上周环比', '28，39，48，42，59，69，55', 'main_area_traffic_flow', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 18:58:00.279392', NULL, NULL, NULL);
    405. 

  405. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (165, 3, '市内三环内拥堵量：', '18km/h', 'road-realtime-traffic', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 19:38:28.100126', '超级管理员', '2024-11-27 19:39:57.127274', NULL);
    406. 

  406. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (166, 4, '安全态势：', '0.8安全', 'road-realtime-traffic', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 19:39:07.919651', '超级管理员', '2024-11-27 19:40:01.828812', NULL);
    407. 

  407. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (167, 3, '客流量超限：', '15%', 'railway_realTime_monitoring', NULL, 'default', 'f', 't', '超级管理员', '2024-11-27 19:41:03.178779', '超级管理员', '2024-11-27 19:41:11.238614', NULL);
    408. 

  408. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (134, 1, '第八再升水公园', '2350', 'key_area_vegetation', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:16:42.06559', '超级管理员', '2024-11-28 05:16:42.70318', NULL);
    409. 

  409. INSERT INTO "public"."sys_dict_data" ("dict_code", "dict_sort", "dict_label", "dict_value", "dict_type", "css_class", "list_class", "is_default", "status", "create_by", "create_time", "update_by", "update_time", "remark") VALUES (135, 2, '川西营小学', '1500', 'key_area_vegetation', NULL, 'default', 'f', 't', '超级管理员', '2024-11-26 14:16:56.963256', '超级管理员', '2024-11-28 05:16:58.467162', NULL);
    410. 

  410. SELECT setval('sys_dict_data_dict_code_seq', (SELECT MAX(dict_code) FROM sys_dict_data));
    411.