Halaman utama Jelajahi Bantuan
Daftar Masuk
3254194295
/
abb-manage
1
0
Fork 0
Berkas Masalah 0 Permintaan Tarik 0 Wiki
Cabang: master
Ranting Tag
abb-manage
/
db
/
设备运行与巡检功能SQL.sql

设备运行与巡检功能SQL.sql 25 KB
Permalink Riwayat Mentahan

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361 
  1. INSERT INTO `t_sys_menu`(`menu_id`, `name`, `parent_id`, `parent_name`, `type`, `url`, `method`, `value`, `sort`,
    2. 

  2.                          `visible`, `content`, `permission`, `icon`, `del_flag`, `created_user_id`, `update_user_id`,
    3. 

  3.                          `created_time`, `update_time`, `created_user_name`, `update_user_name`, `component`,
    4. 

  4.                          `redirect`, `title`, `hidden_header_content`, `target`, `client_id`)
    5. 

  5. VALUES ('5f8d274166d8a74cb03a3801', 'DailyManage', NULL, NULL, 1, '/daily-manage', NULL, NULL, 9, 1, NULL,
    6. 

  6.         'daily-manage', 'profile', 0, '1', '1', '2020-10-19 13:42:26', '2020-10-19 13:43:19', '超级管理员', '超级管理员',
    7. 

  7.         'RouteView', '/xxx', '日常管理', 0, NULL, 'end');
    8. 

  8. 

  9. INSERT INTO `t_sys_menu`(`menu_id`, `name`, `parent_id`, `parent_name`, `type`, `url`, `method`, `value`, `sort`,
    10. 

  10.                          `visible`, `content`, `permission`, `icon`, `del_flag`, `created_user_id`, `update_user_id`,
    11. 

  11.                          `created_time`, `update_time`, `created_user_name`, `update_user_name`, `component`,
    12. 

  12.                          `redirect`, `title`, `hidden_header_content`, `target`, `client_id`)
    13. 

  13. VALUES ('5f8d290666d8a74cb03a380b', 'DailyManageConfig', '5f8d274166d8a74cb03a3801', '日常管理', 1, '/daily-manage-config',
    14. 

  14.         NULL, NULL, 1, 1, NULL, 'daily-manage-config', 'profile', 0, '1', '1', '2020-10-19 13:49:58',
    15. 

  15.         '2020-10-19 13:51:24', '超级管理员', '超级管理员', 'RouteView', '/xxx', '管理配置', 0, NULL, 'end');
    16. 

  16. 

  17. 

  18. -- 配置信息
    19. 

  19. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    20. 

  20.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    21. 

  21.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    22. 

  22.                        `update_time`, `created_user_name`, `update_user_name`,
    23. 

  23.                        `hidden_header_content`, `target`)
    24. 

  24. VALUES ('95497337961500', '5f8d290666d8a74cb03a380b', '管理配置', '配置信息', 'FillInfo', '/fill/info',
    25. 

  25.         'FillInfo', 1, NULL, '', 1, NULL, NULL, 1, NULL, '配置信息',
    26. 

  26.         0, NULL, NULL, '2020-10-17 23:25:15',
    27. 

  27.         '2020-10-17 23:25:15', NULL, NULL, 0, NULL);
    28. 

  28. 

  29. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    30. 

  30.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    31. 

  31.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    32. 

  32.                        `update_time`, `created_user_name`, `update_user_name`,
    33. 

  33.                        `hidden_header_content`, `target`)
    34. 

  34. VALUES ('95497337961500001', '95497337961500', '配置信息', '添加', 'Add', '', '', 1, NULL, '', 2, NULL, NULL, 1, NULL,
    35. 

  35.         'fill-infos-add',
    36. 

  36.         0, NULL, NULL, '2020-10-17 23:25:15',
    37. 

  37.         '2020-10-17 23:25:15', NULL, NULL, 0, NULL);
    38. 

  38. 

  39. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    40. 

  40.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    41. 

  41.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    42. 

  42.                        `update_time`, `created_user_name`, `update_user_name`,
    43. 

  43.                        `hidden_header_content`, `target`)
    44. 

  44. VALUES ('95497337961500002', '95497337961500', '配置信息', '修改', 'Edit', '', '', 2, NULL, '', 2, NULL, NULL, 1, NULL,
    45. 

  45.         'fill-infos-edit',
    46. 

  46.         0, NULL, NULL, '2020-10-17 23:25:15',
    47. 

  47.         '2020-10-17 23:25:15', NULL, NULL, 0, NULL);
    48. 

  48. 

  49. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    50. 

  50.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    51. 

  51.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    52. 

  52.                        `update_time`, `created_user_name`, `update_user_name`,
    53. 

  53.                        `hidden_header_content`, `target`)
    54. 

  54. VALUES ('95497337961500003', '95497337961500', '配置信息', '删除', 'Del', '', '', 3, NULL, '', 2, NULL, NULL, 1, NULL,
    55. 

  55.         'fill-infos-del',
    56. 

  56.         0, NULL, NULL, '2020-10-17 23:25:15',
    57. 

  57.         '2020-10-17 23:25:15', NULL, NULL, 0, NULL);
    58. 

  58. 

  59. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    60. 

  60.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    61. 

  61.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    62. 

  62.                        `update_time`, `created_user_name`, `update_user_name`,
    63. 

  63.                        `hidden_header_content`, `target`)
    64. 

  64. VALUES ('95497337961500004', '95497337961500', '配置信息', '导出', 'Export', '', '', 4, NULL, '', 2, NULL, NULL, 1, NULL,
    65. 

  65.         'fill-infos-export',
    66. 

  66.         0, NULL, NULL, '2020-10-17 23:25:15',
    67. 

  67.         '2020-10-17 23:25:15', NULL, NULL, 0, NULL);
    68. 

  68. 

  69. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    70. 

  70.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    71. 

  71.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    72. 

  72.                        `update_time`, `created_user_name`, `update_user_name`,
    73. 

  73.                        `hidden_header_content`, `target`)
    74. 

  74. VALUES ('95431276055000', '5f8d290666d8a74cb03a380b', '管理配置', '填报项目', 'FillGather', '/fill/gather',
    75. 

  75.         'FillGather', 2, NULL, '', 1, NULL, NULL, 1, NULL, '填报项目',
    76. 

  76.         0, NULL, NULL, '2020-10-17 23:24:09',
    77. 

  77.         '2020-10-17 23:24:09', NULL, NULL, 0, NULL);
    78. 

  78. 

  79. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    80. 

  80.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    81. 

  81.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    82. 

  82.                        `update_time`, `created_user_name`, `update_user_name`,
    83. 

  83.                        `hidden_header_content`, `target`)
    84. 

  84. VALUES ('95431276055000001', '95431276055000', '填报项目', '添加', 'Add', '', '', 1, NULL, '', 2, NULL, NULL, 1, NULL,
    85. 

  85.         'fill-gathers-add',
    86. 

  86.         0, NULL, NULL, '2020-10-17 23:24:09',
    87. 

  87.         '2020-10-17 23:24:09', NULL, NULL, 0, NULL);
    88. 

  88. 

  89. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    90. 

  90.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    91. 

  91.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    92. 

  92.                        `update_time`, `created_user_name`, `update_user_name`,
    93. 

  93.                        `hidden_header_content`, `target`)
    94. 

  94. VALUES ('95431276055000002', '95431276055000', '填报项目', '修改', 'Edit', '', '', 2, NULL, '', 2, NULL, NULL, 1, NULL,
    95. 

  95.         'fill-gathers-edit',
    96. 

  96.         0, NULL, NULL, '2020-10-17 23:24:09',
    97. 

  97.         '2020-10-17 23:24:09', NULL, NULL, 0, NULL);
    98. 

  98. 

  99. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    100. 

  100.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    101. 

  101.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    102. 

  102.                        `update_time`, `created_user_name`, `update_user_name`,
    103. 

  103.                        `hidden_header_content`, `target`)
    104. 

  104. VALUES ('95431276055000003', '95431276055000', '填报项目', '删除', 'Del', '', '', 3, NULL, '', 2, NULL, NULL, 1, NULL,
    105. 

  105.         'fill-gathers-del',
    106. 

  106.         0, NULL, NULL, '2020-10-17 23:24:09',
    107. 

  107.         '2020-10-17 23:24:09', NULL, NULL, 0, NULL);
    108. 

  108. 

  109. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    110. 

  110.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    111. 

  111.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    112. 

  112.                        `update_time`, `created_user_name`, `update_user_name`,
    113. 

  113.                        `hidden_header_content`, `target`)
    114. 

  114. VALUES ('95431276055000004', '95431276055000', '填报项目', '导出', 'Export', '', '', 4, NULL, '', 2, NULL, NULL, 1, NULL,
    115. 

  115.         'fill-gathers-export',
    116. 

  116.         0, NULL, NULL, '2020-10-17 23:24:09',
    117. 

  117.         '2020-10-17 23:24:09', NULL, NULL, 0, NULL);
    118. 

  118. 

  119. INSERT INTO `t_sys_menu`(`menu_id`, `name`, `parent_id`, `parent_name`, `type`, `url`, `method`,
    120. 

  120.                          `value`, `sort`, `visible`, `content`, `permission`, `icon`, `del_flag`,
    121. 

  121.                          `created_user_id`, `update_user_id`, `created_time`, `update_time`,
    122. 

  122.                          `created_user_name`, `update_user_name`, `component`, `redirect`, `title`,
    123. 

  123.                          `hidden_header_content`, `target`, `client_id`)
    124. 

  124. VALUES ('5f8d623966d8a7519443a747', 'DailyManageLog', '5f8d274166d8a74cb03a3801', '日常管理', 1, '/daily-manage-log', NULL,
    125. 

  125.         NULL, 2, 1, NULL, 'daily-manage-log', 'profile', 0, '1', '1', '2020-10-19 17:54:02', '2020-10-19 17:54:34',
    126. 

  126.         '超级管理员', '超级管理员', 'RouteView', '/xxx', '日常记录', 0, NULL, 'end');
    127. 

  127. 

  128. 

  129. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    130. 

  130.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    131. 

  131.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    132. 

  132.                        `update_time`, `created_user_name`, `update_user_name`,
    133. 

  133.                        `hidden_header_content`, `target`)
    134. 

  134. VALUES ('95549876888100', '5f8d623966d8a7519443a747', '日常记录', '设备运行填报记录', 'SbRunFill', '/sb/run/fill',
    135. 

  135.         'SbRunFill', 1, NULL, '', 1, NULL, NULL, 1, NULL, '设备运行填报记录',
    136. 

  136.         0, NULL, NULL, '2020-10-17 23:26:08',
    137. 

  137.         '2020-10-17 23:26:08', NULL, NULL, 0, NULL);
    138. 

  138. 

  139. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    140. 

  140.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    141. 

  141.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    142. 

  142.                        `update_time`, `created_user_name`, `update_user_name`,
    143. 

  143.                        `hidden_header_content`, `target`)
    144. 

  144. VALUES ('95549876888100001', '95549876888100', '设备运行填报记录', '添加', 'Add', '', '', 1, NULL, '', 2, NULL, NULL, 1, NULL,
    145. 

  145.         'sb-run-fills-add',
    146. 

  146.         0, NULL, NULL, '2020-10-17 23:26:08',
    147. 

  147.         '2020-10-17 23:26:08', NULL, NULL, 0, NULL);
    148. 

  148. 

  149. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    150. 

  150.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    151. 

  151.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    152. 

  152.                        `update_time`, `created_user_name`, `update_user_name`,
    153. 

  153.                        `hidden_header_content`, `target`)
    154. 

  154. VALUES ('95549876888100002', '95549876888100', '设备运行填报记录', '修改', 'Edit', '', '', 2, NULL, '', 2, NULL, NULL, 1, NULL,
    155. 

  155.         'sb-run-fills-edit',
    156. 

  156.         0, NULL, NULL, '2020-10-17 23:26:08',
    157. 

  157.         '2020-10-17 23:26:08', NULL, NULL, 0, NULL);
    158. 

  158. 

  159. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    160. 

  160.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    161. 

  161.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    162. 

  162.                        `update_time`, `created_user_name`, `update_user_name`,
    163. 

  163.                        `hidden_header_content`, `target`)
    164. 

  164. VALUES ('95549876888100003', '95549876888100', '设备运行填报记录', '删除', 'Del', '', '', 3, NULL, '', 2, NULL, NULL, 1, NULL,
    165. 

  165.         'sb-run-fills-del',
    166. 

  166.         0, NULL, NULL, '2020-10-17 23:26:08',
    167. 

  167.         '2020-10-17 23:26:08', NULL, NULL, 0, NULL);
    168. 

  168. 

  169. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    170. 

  170.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    171. 

  171.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    172. 

  172.                        `update_time`, `created_user_name`, `update_user_name`,
    173. 

  173.                        `hidden_header_content`, `target`)
    174. 

  174. VALUES ('95549876888100004', '95549876888100', '设备运行填报记录', '导出', 'Export', '', '', 4, NULL, '', 2, NULL, NULL, 1, NULL,
    175. 

  175.         'sb-run-fills-export',
    176. 

  176.         0, NULL, NULL, '2020-10-17 23:26:08',
    177. 

  177.         '2020-10-17 23:26:08', NULL, NULL, 0, NULL);
    178. 

  178. 

  179. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    180. 

  180.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    181. 

  181.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    182. 

  182.                        `update_time`, `created_user_name`, `update_user_name`,
    183. 

  183.                        `hidden_header_content`, `target`)
    184. 

  184. VALUES ('95528250819400', '5f8d623966d8a7519443a747', '日常记录', '设备巡检填报记录', 'SbInspectionFill', '/sb/inspection/fill',
    185. 

  185.         'SbInspectionFill', 2, NULL, '', 1, NULL, NULL, 1, NULL, '设备巡检填报记录',
    186. 

  186.         0, NULL, NULL, '2020-10-17 23:25:46',
    187. 

  187.         '2020-10-17 23:25:46', NULL, NULL, 0, NULL);
    188. 

  188. 

  189. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    190. 

  190.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    191. 

  191.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    192. 

  192.                        `update_time`, `created_user_name`, `update_user_name`,
    193. 

  193.                        `hidden_header_content`, `target`)
    194. 

  194. VALUES ('95528250819400001', '95528250819400', '设备巡检填报记录', '添加', 'Add', '', '', 1, NULL, '', 2, NULL, NULL, 1, NULL, 'sb-inspection-fills-add',
    195. 

  195.         0, NULL, NULL, '2020-10-17 23:25:46',
    196. 

  196.         '2020-10-17 23:25:46', NULL, NULL, 0, NULL);
    197. 

  197. 

  198. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    199. 

  199.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    200. 

  200.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    201. 

  201.                        `update_time`, `created_user_name`, `update_user_name`,
    202. 

  202.                        `hidden_header_content`, `target`)
    203. 

  203. VALUES ('95528250819400002', '95528250819400', '设备巡检填报记录', '修改', 'Edit', '', '', 2, NULL, '', 2, NULL, NULL, 1, NULL, 'sb-inspection-fills-edit',
    204. 

  204.         0, NULL, NULL, '2020-10-17 23:25:46',
    205. 

  205.         '2020-10-17 23:25:46', NULL, NULL, 0, NULL);
    206. 

  206. 

  207. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    208. 

  208.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    209. 

  209.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    210. 

  210.                        `update_time`, `created_user_name`, `update_user_name`,
    211. 

  211.                        `hidden_header_content`, `target`)
    212. 

  212. VALUES ('95528250819400003', '95528250819400', '设备巡检填报记录', '删除', 'Del', '', '', 3, NULL, '', 2, NULL, NULL, 1, NULL, 'sb-inspection-fills-del',
    213. 

  213.         0, NULL, NULL, '2020-10-17 23:25:46',
    214. 

  214.         '2020-10-17 23:25:46', NULL, NULL, 0, NULL);
    215. 

  215. 

  216. INSERT INTO t_sys_menu(`menu_id`, `parent_id`, `parent_name`, `title`, `name`, `url`, `component`, `sort`, `redirect`,
    217. 

  217.                        `icon`, `type`, `method`, `value`, `visible`, `content`,
    218. 

  218.                        `permission`, `del_flag`, `created_user_id`, `update_user_id`, `created_time`,
    219. 

  219.                        `update_time`, `created_user_name`, `update_user_name`,
    220. 

  220.                        `hidden_header_content`, `target`)
    221. 

  221. VALUES ('95528250819400004', '95528250819400', '设备巡检填报记录', '导出', 'Export', '', '', 4, NULL, '', 2, NULL, NULL, 1, NULL, 'sb-inspection-fills-export',
    222. 

  222.         0, NULL, NULL, '2020-10-17 23:25:46',
    223. 

  223.         '2020-10-17 23:25:46', NULL, NULL, 0, NULL);
    224. 

  224. 

  225. update t_sys_menu
    226. 

  226. set client_id = 'end'
    227. 

  227. WHERE client_id = ''
    228. 

  228.    or client_id is null;
    229. 

  229. 

  230. 

  231. -- 数据词典
    232. 

  232. INSERT INTO `t_sys_dict`(`id`, `type`,
    233. 

  233.                          `type_name`, `code`, `value`, `value_type`, `label`, `description`, `sort`, `created_time`,
    234. 

  234.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    235. 

  235.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    236. 

  236. VALUES ('5e9ee013b2131001', 'FILL_INFO_USE_TYPE',
    237. 

  237.         '使用类型', 'FILL_INFO_USE_TYPE_YUN_XING', '1', 2, '运行记录', '运行记录', 1, '2020-10-11 19:59:16',
    238. 

  238.         '2020-10-11 11:32:50',
    239. 

  239.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    240. 

  240. 

  241. INSERT INTO `t_sys_dict`(`id`, `type`,
    242. 

  242.                          `type_name`, `code`, `value`, `value_type`, `label`, `description`, `sort`, `created_time`,
    243. 

  243.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    244. 

  244.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    245. 

  245. VALUES ('5e9ee013b2131002', 'FILL_INFO_USE_TYPE',
    246. 

  246.         '使用类型', 'FILL_INFO_USE_TYPE_XUN_JIAN', '2', 2, '巡检记录', '巡检记录', 2, '2020-10-11 19:59:16',
    247. 

  247.         '2020-10-11 11:32:50',
    248. 

  248.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    249. 

  249. 

  250. INSERT INTO `t_sys_dict`(`id`, `type`,
    251. 

  251.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    252. 

  252.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    253. 

  253.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    254. 

  254. VALUES ('5e9ee013b2131003', 'FILL_INFO_TYPE',
    255. 

  255.         '数值类型', 'FILL_INFO_TYPE_INT', '1', '整数', '整数', 1, 2, '2020-10-11 19:59:16',
    256. 

  256.         '2020-10-11 11:32:50',
    257. 

  257.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    258. 

  258. 

  259. INSERT INTO `t_sys_dict`(`id`, `type`,
    260. 

  260.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    261. 

  261.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    262. 

  262.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    263. 

  263. VALUES ('5e9ee013b2131004', 'FILL_INFO_TYPE',
    264. 

  264.         '数值类型', 'FILL_INFO_TYPE_DECIMAL', '2', '小数', '小数', 2, 2, '2020-10-11 19:59:16',
    265. 

  265.         '2020-10-11 11:32:50',
    266. 

  266.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    267. 

  267. 

  268. INSERT INTO `t_sys_dict`(`id`, `type`,
    269. 

  269.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    270. 

  270.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    271. 

  271.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    272. 

  272. VALUES ('5e9ee013b2131005', 'FILL_INFO_TYPE',
    273. 

  273.         '数值类型', 'FILL_INFO_TYPE_FAN_WEI', '3', '范围值', '范围值', 3, 2, '2020-10-11 19:59:16',
    274. 

  274.         '2020-10-11 11:32:50',
    275. 

  275.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    276. 

  276. 

  277. 

  278. INSERT INTO `t_sys_dict`(`id`, `type`,
    279. 

  279.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    280. 

  280.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    281. 

  281.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    282. 

  282. VALUES ('5e9ee013b2131006', 'FILL_INFO_TYPE',
    283. 

  283.         '数值类型', 'FILL_INFO_TYPE_STRING', '4', '文字说明', '文字说明', 4, 2, '2020-10-11 19:59:16',
    284. 

  284.         '2020-10-11 11:32:50',
    285. 

  285.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    286. 

  286. 

  287. INSERT INTO `t_sys_dict`(`id`, `type`,
    288. 

  288.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    289. 

  289.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    290. 

  290.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    291. 

  291. VALUES ('5e9ee013b2131007', 'FILL_INFO_NATURE',
    292. 

  292.         '标题说明', 'FILL_INFO_NATURE_SHI_GONG', '1', '施工信息', '施工信息', 1, 2, '2020-10-11 19:59:16',
    293. 

  293.         '2020-10-11 11:32:50',
    294. 

  294.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    295. 

  295. 

  296. INSERT INTO `t_sys_dict`(`id`, `type`,
    297. 

  297.                          `type_name`, `code`, `value`, `sort`, `label`, `description`, `value_type`, `created_time`,
    298. 

  298.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    299. 

  299.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    300. 

  300. VALUES ('5e9ee013b2131008', 'FILL_INFO_NATURE',
    301. 

  301.         '标题说明', 'FILL_INFO_NATURE_CHE_LIANG', '2', 2, '车辆运行检查', '车辆运行检查', 2, '2020-10-11 19:59:16',
    302. 

  302.         '2020-10-11 11:32:50',
    303. 

  303.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    304. 

  304. 

  305. INSERT INTO `t_sys_dict`(`id`, `type`,
    306. 

  306.                          `type_name`, `code`, `value`, `sort`, `label`, `description`, `value_type`, `created_time`,
    307. 

  307.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    308. 

  308.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    309. 

  309. VALUES ('5e9ee013b2131009', 'FILL_INFO_NATURE',
    310. 

  310.         '标题说明', 'FILL_INFO_NATURE_YUN_XING', '3', 3, '运行项目', '运行项目', 2, '2020-10-11 19:59:16',
    311. 

  311.         '2020-10-11 11:32:50',
    312. 

  312.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    313. 

  313. 

  314. 

  315. INSERT INTO `t_sys_dict`(`id`, `type`,
    316. 

  316.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    317. 

  317.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    318. 

  318.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    319. 

  319. VALUES ('5e9ee013b2131010', 'FILL_INFO_TYPE',
    320. 

  320.         '数值类型', 'FILL_INFO_TYPE_XIA_LA', '5', '下拉选项', '下拉选项', 5, 2, '2020-10-11 19:59:16',
    321. 

  321.         '2020-10-11 11:32:50',
    322. 

  322.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    323. 

  323. 

  324. 

  325. INSERT INTO `t_sys_dict`(`id`, `type`,
    326. 

  326.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    327. 

  327.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    328. 

  328.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    329. 

  329. VALUES ('5e9ee013b2131011', 'FILL_INFO_TYPE',
    330. 

  330.         '数值类型', 'FILL_INFO_TYPE_DAN_XUAN', '6', '单选', '单选', 6, 2, '2020-10-11 19:59:16',
    331. 

  331.         '2020-10-11 11:32:50',
    332. 

  332.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    333. 

  333. 

  334. 

  335. 

  336. INSERT INTO `t_sys_dict`(`id`, `type`,
    337. 

  337.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    338. 

  338.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    339. 

  339.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    340. 

  340. VALUES ('5e9ee013b2131012', 'FILE_GATHER_CODE_ID',
    341. 

  341.         '填报项目类型', 'FILE_GATHER_CODE_ID_GGSB', '1', '工程设备', '工程设备', 1, 2, '2020-10-11 19:59:16',
    342. 

  342.         '2020-10-11 11:32:50',
    343. 

  343.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    344. 

  344. 

  345. INSERT INTO `t_sys_dict`(`id`, `type`,
    346. 

  346.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    347. 

  347.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    348. 

  348.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    349. 

  349. VALUES ('5e9ee013b2131013', 'FILE_GATHER_CODE_ID',
    350. 

  350.         '填报项目类型', 'FILE_GATHER_CODE_ID_PTCL', '2', '普通车辆', '普通车辆', 2, 2, '2020-10-11 19:59:16',
    351. 

  351.         '2020-10-11 11:32:50',
    352. 

  352.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    353. 

  353. 

  354. INSERT INTO `t_sys_dict`(`id`, `type`,
    355. 

  355.                          `type_name`, `code`, `value`, `label`, `description`, `sort`, `value_type`, `created_time`,
    356. 

  356.                          `update_time`, `del_flag`, `created_user_id`, `update_user_id`,
    357. 

  357.                          `created_user_name`, `update_user_name`, `child_flag`, `parent_id`)
    358. 

  358. VALUES ('5e9ee013b2131014', 'FILE_GATHER_CODE_ID',
    359. 

  359.         '填报项目类型', 'FILE_GATHER_CODE_ID_TYSB', '3', '通用设备', '通用设备', 3, 2, '2020-10-11 19:59:16',
    360. 

  360.         '2020-10-11 11:32:50',
    361. 

  361.         '0', '5e9e76b9c04d181784c646d2', '5e9e76b9c04d181784c646d2', '刘宇', '刘宇', NULL, NULL);
    362.