ホーム エクスプローラ ヘルプ
登録 サインイン
fjnx
/
soc
2
0
フォーク 0
ファイル 課題 0 プルリクエスト 0 Wiki
ツリー: 00fc196572
ブランチ タグ
soc
/
project_data
/
sql
/
0.0.2
/
soc
/
soc.sql

soc.sql 132 KB
履歴 Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255 
  1. 

  2. SET NAMES utf8mb4;
    3. 

  3. SET FOREIGN_KEY_CHECKS = 0;
    4. 

  4. 

  5. -- ----------------------------
    6. 

  6. -- Table structure for core_announcement_notification
    7. 

  7. -- ----------------------------
    8. 

  8. DROP TABLE IF EXISTS `sync_fjnx_org_move`;
    9. 

  9. CREATE TABLE `sync_fjnx_org_move` (
    10. 

  10.                                       `id` bigint NOT NULL AUTO_INCREMENT,
    11. 

  11.                                       `org_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '特殊机构编码',
    12. 

  12.                                       `org_type` int DEFAULT NULL COMMENT '1: 部门（强行将机构类型指定为部门） 2： 机构  （强行将机构类型指定为机构）',
    13. 

  13.                                       PRIMARY KEY (`id`) USING BTREE
    14. 

  14. ) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='配置特殊的机构和部门机构，决定是否要移动到机关机构下';
    15. 

  15. -- ----------------------------
    16. 

  16. -- Records of core_announcement_notification
    17. 

  17. -- ----------------------------
    18. 

  18. 

  19. 

  20. SET FOREIGN_KEY_CHECKS = 1;
    21. 

  21. -- 监控调阅任务按钮菜单
    22. 

  22. delete from  sys_menu where id in(2197,2198) ;
    23. 

  23. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2197, '导出', 2073, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:task:export', '1', '#', NULL, '超级管理员', '2023-09-14 16:10:03', '', NULL, '');
    24. 

  24. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2198, '详情', 2073, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:task:query', '1', '#', NULL, '超级管理员', '2023-09-14 16:10:35', '超级管理员', '2023-09-14 19:26:20', '');
    25. 

  25. 

  26. -- 修改教育培训菜单名称
    27. 

  27. update sys_menu set menu_name ='安全教育' where id=2127;
    28. 

  28. update sys_menu set menu_name ='知识库标签管理' where id=2038;
    29. 

  29. update sys_menu set menu_name ='上传学习资料' where id=2045;
    30. 

  30. update sys_menu set menu_name ='培训计划管理' where id=2059;
    31. 

  31. update sys_menu set menu_name ='培训任务管理' where id=2079;
    32. 

  32. 

  33. -- 机构扩展添加是否业务库
    34. 

  34. ALTER TABLE sys_org_extend
    35. 

  35.     MODIFY COLUMN business_library INT COMMENT '是否业务库';
    36. 

  36. 

  37. -- 机构扩展字典添加
    38. 

  38. delete from sys_dict_type where dict_type in ('org_extend_standard','org_extend_business_library_standard','org_extend_self_service_bank_standard','org_extend_detached_standard','org_extend_is');
    39. 

  39. 

  40. INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展基础标准', 'org_extend_standard', '0', '超级管理员', '2023-09-14 16:53:49', '', NULL, '机构扩展基础标准');
    41. 

  41. INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展业务库标准', 'org_extend_business_library_standard', '0', '超级管理员', '2023-09-14 16:54:52', '', NULL, '机构扩展业务库标准');
    42. 

  42. INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展在行式自助银行标准', 'org_extend_self_service_bank_standard', '0', '超级管理员', '2023-09-14 16:55:45', '', NULL, '机构扩展在行式自助银行标准');
    43. 

  43. INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展离行式自助银行标准', 'org_extend_detached_standard', '0', '超级管理员', '2023-09-14 16:56:30', '', NULL, '机构扩展离行式自助银行标准');
    44. 

  44. INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '机构扩展是否选择框', 'org_extend_is', '0', '超级管理员', '2023-09-15 09:48:38', '', NULL, '机构扩展是否选择框');
    45. 

  45. 

  46. delete from sys_dict_data where dict_type in ('org_extend_standard','org_extend_business_library_standard','org_extend_self_service_bank_standard','org_extend_detached_standard','org_extend_is');
    47. 

  47. 

  48. INSERT INTO `sys_dict_data`( `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 ( 1, '基础标准1', '1', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:04', '', NULL, NULL);
    49. 

  49. INSERT INTO `sys_dict_data`( `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 ( 2, '基础标准2', '2', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:10', '', NULL, NULL);
    50. 

  50. INSERT INTO `sys_dict_data`( `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 ( 3, '基础标准3', '3', 'org_extend_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:28', '', NULL, NULL);
    51. 

  51. INSERT INTO `sys_dict_data`( `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 ( 1, '业务库标准1', '1', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:45', '', NULL, NULL);
    52. 

  52. INSERT INTO `sys_dict_data`( `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 ( 2, '业务库标准2', '2', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:50', '', NULL, NULL);
    53. 

  53. INSERT INTO `sys_dict_data`( `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 ( 3, '业务库标准3', '3', 'org_extend_business_library_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:57:55', '', NULL, NULL);
    54. 

  54. INSERT INTO `sys_dict_data`( `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 ( 1, '在行式自助银行标准1', '1', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:09', '', NULL, NULL);
    55. 

  55. INSERT INTO `sys_dict_data`( `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 ( 2, '在行式自助银行标准2', '2', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:13', '', NULL, NULL);
    56. 

  56. INSERT INTO `sys_dict_data`( `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 ( 3, '在行式自助银行标准3', '3', 'org_extend_self_service_bank_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:20', '', NULL, NULL);
    57. 

  57. INSERT INTO `sys_dict_data`( `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 ( 1, '离行式自助银行标准1', '1', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:33', '', NULL, NULL);
    58. 

  58. INSERT INTO `sys_dict_data`( `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 ( 2, '离行式自助银行标准2', '2', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:37', '', NULL, NULL);
    59. 

  59. INSERT INTO `sys_dict_data`( `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 ( 3, '离行式自助银行标准3', '3', 'org_extend_detached_standard', NULL, 'default', 'N', '0', '超级管理员', '2023-09-14 16:58:41', '', NULL, NULL);
    60. 

  60. INSERT INTO `sys_dict_data`( `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 ( 1, '是', '1', 'org_extend_is', NULL, 'default', 'N', '0', '超级管理员', '2023-09-15 09:48:58', '', NULL, NULL);
    61. 

  61. INSERT INTO `sys_dict_data`( `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 ( 2, '否', '0', 'org_extend_is', NULL, 'default', 'N', '0', '超级管理员', '2023-09-15 09:49:08', '', NULL, NULL);
    62. 

  62. 

  63. DROP TABLE IF EXISTS `core_question_flow`;
    64. 

  64. DROP TABLE IF EXISTS `core_question`;
    65. 

  65. CREATE TABLE `core_question_flow` (
    66. 

  66.   `id` bigint NOT NULL,
    67. 

  67.   `question_id` bigint DEFAULT NULL COMMENT '隐患问题id',
    68. 

  68.   `executor_id` bigint DEFAULT NULL COMMENT '流程执行人',
    69. 

  69.   `executor_name` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '流程执行人姓名',
    70. 

  70.   `execute_time` datetime DEFAULT NULL COMMENT '流程操作时间',
    71. 

  71.   `execute_status` int DEFAULT NULL COMMENT '流程执行结果。0：通过、1：未通过',
    72. 

  72.   `execute_step` int DEFAULT NULL COMMENT '流程执行步骤.1确认，2异议审批,11整改',
    73. 

  73.   `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行描述',
    74. 

  74.   `reform_date` datetime DEFAULT NULL COMMENT '整改时间',
    75. 

  75.   `images` varchar(1024) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '流程相关图片',
    76. 

  76.   PRIMARY KEY (`id`)
    77. 

  77. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='隐患问题审批流程';
    78. 

  78. CREATE TABLE `core_question` (
    79. 

  79.   `id` bigint NOT NULL,
    80. 

  80.   `org_id` bigint DEFAULT NULL COMMENT '隐患所属机构',
    81. 

  81.   `org_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '隐患所属机构名称',
    82. 

  82.   `org_path` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '隐患所属机构path',
    83. 

  83.   `src_type` int DEFAULT NULL COMMENT '来源，1：履职，2：安全检查',
    84. 

  84.   `src_task_id` bigint DEFAULT NULL COMMENT '来源任务id',
    85. 

  85.   `src_task_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '来源任务名称',
    86. 

  86.   `src_point_id` bigint DEFAULT NULL COMMENT '检查、履职内容id',
    87. 

  87.   `src_data_point_id` bigint DEFAULT NULL COMMENT '检查、履职登记内容id',
    88. 

  88.   `check_item` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查、履职项名称',
    89. 

  89.   `check_content` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查内容',
    90. 

  90.   `question_desc` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '隐患描述',
    91. 

  91.   `submitor_id` bigint DEFAULT NULL COMMENT '提出人id',
    92. 

  92.   `submitor_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提出人名称',
    93. 

  93.   `submit_time` datetime DEFAULT NULL COMMENT '发现时间',
    94. 

  94.   `confirm_status` int DEFAULT NULL COMMENT '确认状态。0未确认，1提出异议，2已确认，3已关闭',
    95. 

  95.   `reform_status` int DEFAULT NULL COMMENT '整改状态。10未整改，11已整改',
    96. 

  96.   `reform_deadline` datetime DEFAULT NULL COMMENT '整改期限',
    97. 

  97.   `create_time` datetime DEFAULT NULL,
    98. 

  98.   `update_time` datetime DEFAULT NULL,
    99. 

  99.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    100. 

  100.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    101. 

  101.   PRIMARY KEY (`id`)
    102. 

  102. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='隐患问题清单';
    103. 

  103. 

  104. UPDATE`sys_dict_data` SET `dict_label` = '待确认' WHERE `dict_code` = 360;
    105. 

  105. UPDATE `sys_dict_data` SET `dict_label` = '待履职' WHERE `dict_code` = 194;
    106. 

  106. UPDATE `sys_dict_data` SET `status` = '1' WHERE `dict_code` in( 203,208,209);
    107. 

  107. update sys_menu set icon=SUBSTR(icon,24) WHERE icon like 'http://10.87.10.55:8080%';
    108. 

  108. 

  109. 

  110. DELIMITER ??
    111. 

  111. DROP PROCEDURE IF EXISTS schema_change??
    112. 

  112. CREATE PROCEDURE schema_change()
    113. 

  113. BEGIN
    114. 

  114.     -- 预案演练任务增加推荐状态字段
    115. 

  115.     IF NOT EXISTS(SELECT *
    116. 

  116.                   FROM information_schema.columns
    117. 

  117.                   WHERE table_schema = DATABASE()
    118. 

  118.                     AND table_name = 'core_drill_task'
    119. 

  119.                     AND column_name = 'rec_status') THEN
    120. 

  120.         alter table core_drill_task
    121. 

  121.             add rec_status int null comment '推荐状态:0:正常案例、1:行社优秀案例、2:已推荐地区优秀案例、3:地区优秀案例、4:已推荐省级优秀案例、5:省级优秀案例' after status;
    122. 

  122.     END IF;
    123. 

  123. 

  124.     IF NOT EXISTS(SELECT *
    125. 

  125.                   FROM information_schema.columns
    126. 

  126.                   WHERE table_schema = DATABASE()
    127. 

  127.                     AND table_name = 'sync_fjnx_org_business_relation'
    128. 

  128.                     AND column_name = 'tree_show_parent_code') THEN
    129. 

  129.         ALTER TABLE `sync_fjnx_org_business_relation`
    130. 

  130.             ADD COLUMN `tree_show_parent_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构树上显示的父级编码' AFTER `business_parent_code`;
    131. 

  131.     END IF;
    132. 

  132. 

  133.     IF NOT EXISTS(SELECT *
    134. 

  134.                   FROM information_schema.columns
    135. 

  135.                   WHERE table_schema = DATABASE()
    136. 

  136.                     AND table_name = 'sync_fjnx_org_business_relation'
    137. 

  137.                     AND column_name = 'org_type') THEN
    138. 

  138.         ALTER TABLE `sync_fjnx_org_business_relation`
    139. 

  139.             ADD COLUMN `org_type` int NULL DEFAULT NULL COMMENT '同步配置表自定义机构类型 1：省联社 2：办事处 3: 地区行社' AFTER `tree_show_parent_code`;
    140. 

  140.     END IF;
    141. 

  141. 

  142.     IF NOT EXISTS(SELECT *
    143. 

  143.                   FROM information_schema.columns
    144. 

  144.                   WHERE table_schema = DATABASE()
    145. 

  145.                     AND table_name = 'sync_fjnx_org_business_relation'
    146. 

  146.                     AND column_name = 'dqhs_org_code') THEN
    147. 

  147.         ALTER TABLE `sync_fjnx_org_business_relation`
    148. 

  148.             ADD COLUMN `dqhs_org_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NULL DEFAULT NULL COMMENT '办事处对应的地区行社，机构编码是办事处时需要配置' AFTER `org_type`;
    149. 

  149.     END IF;
    150. 

  150. 

  151. END??
    152. 

  152. DELIMITER ;
    153. 

  153. CALL schema_change();
    154. 

  154. 

  155. -- 新增fjnx机构同步 机构关系配置表数据
    156. 

  156. delete from sync_fjnx_org_business_relation ;
    157. 

  157. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (1, 'M39000000', 'M31000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    158. 

  158. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (2, 'M42000000', 'M33000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    159. 

  159. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (3, 'M43000000', 'M34000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    160. 

  160. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (4, 'M39000000', 'M35000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    161. 

  161. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (5, 'M45000000', 'M36000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    162. 

  162. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (6, 'M46000000', 'M37000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    163. 

  163. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (7, 'M47000000', 'M38000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    164. 

  164. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (8, '900000000', 'C900000000', 'C900000000', 1, NULL, NULL, NULL, NULL, NULL);
    165. 

  165. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (9, 'M40000000', 'C900000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    166. 

  166. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (10, 'M44000000', 'C900000000', 'C900000000', 3, NULL, NULL, NULL, NULL, NULL);
    167. 

  167. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (11, 'M31000000', NULL, NULL, 2, 'M39000000', NULL, NULL, NULL, NULL);
    168. 

  168. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (12, 'M32000000', NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL);
    169. 

  169. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (13, 'M33000000', NULL, NULL, 2, 'M42000000', NULL, NULL, NULL, NULL);
    170. 

  170. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (14, 'M34000000', NULL, NULL, 2, 'M43000000', NULL, NULL, NULL, NULL);
    171. 

  171. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (15, 'M35000000', NULL, NULL, 2, 'M39000000', NULL, NULL, NULL, NULL);
    172. 

  172. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (16, 'M36000000', NULL, NULL, 2, 'M45000000', NULL, NULL, NULL, NULL);
    173. 

  173. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (17, 'M37000000', NULL, NULL, 2, 'M46000000', NULL, NULL, NULL, NULL);
    174. 

  174. INSERT INTO `sync_fjnx_org_business_relation` (`id`, `org_code`, `business_parent_code`, `tree_show_parent_code`, `org_type`, `dqhs_org_code`, `create_time`, `modified_name`, `update_time`, `modified_id`) VALUES (18, 'M38000000', NULL, NULL, 2, 'M47000000', NULL, NULL, NULL, NULL);
    175. 

  175. 

  176. 

  177. -- 新增演练任务推荐状态字典
    178. 

  178. delete from sys_dict_type where dict_type='drill_task_rec_status';
    179. 

  179. delete from sys_dict_data where dict_type='drill_task_rec_status';
    180. 

  180. INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ( '演练任务推荐状态', 'drill_task_rec_status', '0', '超级管理员', now(), '', null, null);
    181. 

  181. INSERT INTO sys_dict_data (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 (0, '正常案例', '0', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '超级管理员', now(), null);
    182. 

  182. INSERT INTO sys_dict_data (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 (0, '行社优秀案例', '1', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '超级管理员', now(), null);
    183. 

  183. INSERT INTO sys_dict_data (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 (0, '已推荐地区优秀案例', '2', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
    184. 

  184. INSERT INTO sys_dict_data (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 (0, '地区优秀案例', '3', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
    185. 

  185. INSERT INTO sys_dict_data (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 (0, '已推荐省级优秀案例', '4', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
    186. 

  186. INSERT INTO sys_dict_data (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 (0, '省级优秀案例', '5', 'drill_task_rec_status', null, 'default', 'N', '0', '超级管理员', now(), '', null, null);
    187. 

  187. -- 新增演练任务状态字典
    188. 

  188. delete from sys_dict_type where dict_type='drill_task_status';
    189. 

  189. delete from sys_dict_data where dict_type='drill_task_status';
    190. 

  190. INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES ('预案演练任务状态', 'drill_task_status', '0', '超级管理员', '2023-09-20 16:06:14', '', null, null);
    191. 

  191. INSERT INTO sys_dict_data (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 (0, '待演练', '0', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:06:46', '', null, null);
    192. 

  192. INSERT INTO sys_dict_data (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 (1, '待签名', '1', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:06:56', '', null, null);
    193. 

  193. INSERT INTO sys_dict_data (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 (2, '待评价', '2', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:07:05', '超级管理员', '2023-09-20 16:07:30', null);
    194. 

  194. INSERT INTO sys_dict_data (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 (3, '已完成', '3', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:07:13', '', null, null);
    195. 

  195. INSERT INTO sys_dict_data (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 (4, '已逾期', '4', 'drill_task_status', null, 'default', 'N', '0', '超级管理员', '2023-09-20 16:07:23', '', null, null);
    196. 

  196. 

  197. 

  198. -- 公告通知start
    199. 

  199. delete from sys_dict_type where dict_type in('messag_type','message_status') and dict_name in('消息类型','消息状态');
    200. 

  200. INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '消息类型', 'messag_type', '0', '超级管理员', '2023-09-13 17:03:11', '超级管理员', '2023-09-13 17:07:06', NULL);
    201. 

  201. INSERT INTO `sys_dict_type`( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '消息状态', 'message_status', '0', '超级管理员', '2023-09-13 17:08:11', '', NULL, NULL);
    202. 

  202. 

  203. delete from sys_dict_data where dict_type in('messag_type','message_status');
    204. 

  204. INSERT INTO `sys_dict_data`( `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 ( 0, '公告', '0', 'messag_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 17:06:33', '', NULL, NULL);
    205. 

  205. INSERT INTO `sys_dict_data`( `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 ( 0, '通知', '1', 'messag_type', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 17:06:43', '', NULL, NULL);
    206. 

  206. INSERT INTO `sys_dict_data`( `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 ( 0, '待发布', '0', 'message_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 17:09:11', '', NULL, NULL);
    207. 

  207. INSERT INTO `sys_dict_data`( `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 ( 0, '已发布', '1', 'message_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 17:09:19', '', NULL, NULL);
    208. 

  208. 

  209. delete from sys_menu where menu_name in('公告通知','公告通知详情','公告通知编辑','新增公告通知','删除公告通知','发布公告通知','取消发布');
    210. 

  210. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2196, '公告通知', 2207, 1, 'core/message', 'core/message/index', NULL, 1, 0, 'C', '0', '0', 'core:notification:list', '1', 'dashboard', NULL, '超级管理员', '2023-09-13 17:50:26', '超级管理员', '2023-09-15 16:47:45', '');
    211. 

  211. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2208, '公告通知详情', 2196, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:query', '1', '#', NULL, '超级管理员', '2023-09-19 15:17:27', '', NULL, '');
    212. 

  212. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2209, '公告通知编辑', 2196, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:edit', '1', '#', NULL, '超级管理员', '2023-09-19 15:17:56', '', NULL, '');
    213. 

  213. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2210, '新增公告通知', 2196, 3, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:add', '1', '#', NULL, '超级管理员', '2023-09-19 15:18:18', '', NULL, '');
    214. 

  214. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2211, '删除公告通知', 2196, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:remove', '1', '#', NULL, '超级管理员', '2023-09-19 15:18:42', '', NULL, '');
    215. 

  215. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2212, '发布公告通知', 2196, 5, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:publish', '1', '#', NULL, '超级管理员', '2023-09-19 15:19:03', '', NULL, '');
    216. 

  216. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2213, '取消发布', 2196, 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:notification:cancelPublish', '1', '#', NULL, '超级管理员', '2023-09-19 15:19:25', '', NULL, '');
    217. 

  217. 

  218. delete from sys_role_menu where menu_id in(2208,2209,2210,2211,2212,2213,2196) ;
    219. 

  219. 

  220. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2196);
    221. 

  221. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2208);
    222. 

  222. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2209);
    223. 

  223. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2210);
    224. 

  224. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2211);
    225. 

  225. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2212);
    226. 

  226. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (116, 2213);
    227. 

  227. 

  228. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2196);
    229. 

  229. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2208);
    230. 

  230. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2209);
    231. 

  231. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2210);
    232. 

  232. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2211);
    233. 

  233. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2212);
    234. 

  234. INSERT INTO `sys_role_menu`(`role_id`, `menu_id`) VALUES (120, 2213);
    235. 

  235. 

  236. DROP TABLE IF EXISTS `core_announcement_notification`;
    237. 

  237. CREATE TABLE `core_announcement_notification`  (
    238. 

  238.    `id` bigint(0) NOT NULL,
    239. 

  239.    `org_id` bigint(0) NULL DEFAULT NULL COMMENT '机构',
    240. 

  240.    `org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构',
    241. 

  241.    `org_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构',
    242. 

  242.    `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
    243. 

  243.    `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
    244. 

  244.    `messag_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息类型0公告1通知',
    245. 

  245.    `tag_org_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '机构类型',
    246. 

  246.    `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
    247. 

  247.    `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    248. 

  248.    `publish_time` datetime(0) NULL DEFAULT NULL COMMENT '发布时间',
    249. 

  249.    `messag_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
    250. 

  250.    `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    251. 

  251.    `update_time` datetime(0) NULL DEFAULT NULL,
    252. 

  252.    `file_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文件',
    253. 

  253.    PRIMARY KEY (`id`) USING BTREE,
    254. 

  254.    INDEX `org_id_indx`(`org_id`) USING BTREE,
    255. 

  255.    INDEX `org_path_index`(`org_path`) USING BTREE
    256. 

  256. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公告通知' ROW_FORMAT = Dynamic;
    257. 

  257. 

  258. DROP TABLE IF EXISTS `core_announcement_notification_to_org`;
    259. 

  259. CREATE TABLE `core_announcement_notification_to_org`  (
    260. 

  260. `announcement_notification_id` bigint(0) NOT NULL,
    261. 

  261. `org_id` bigint(0) NULL DEFAULT NULL,
    262. 

  262. INDEX `notification_id_index`(`announcement_notification_id`) USING BTREE,
    263. 

  263. INDEX `org_id_index`(`org_id`) USING BTREE
    264. 

  264. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告机构关联表' ROW_FORMAT = Dynamic;
    265. 

  265. 

  266. -- ----------------------------
    267. 

  267. -- Table structure for core_announcement_notification_to_role
    268. 

  268. -- ----------------------------
    269. 

  269. DROP TABLE IF EXISTS `core_announcement_notification_to_role`;
    270. 

  270. CREATE TABLE `core_announcement_notification_to_role`  (
    271. 

  271. `announcement_notification_id` bigint(0) NOT NULL,
    272. 

  272. `role_id` bigint(0) NULL DEFAULT NULL,
    273. 

  273. INDEX `notification_id_index`(`announcement_notification_id`) USING BTREE,
    274. 

  274. INDEX `role_id_index`(`role_id`) USING BTREE
    275. 

  275. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公告通知角色关联表' ROW_FORMAT = Dynamic;
    276. 

  276. 

  277. DROP TABLE IF EXISTS `core_announcement_notification_to_user`;
    278. 

  278. CREATE TABLE `core_announcement_notification_to_user`  (
    279. 

  279. `id` bigint(0) NOT NULL,
    280. 

  280. `announcement_notification_id` bigint(0) NULL DEFAULT NULL COMMENT '公告通知id',
    281. 

  281. `org_id` bigint(0) NULL DEFAULT NULL COMMENT '机构id',
    282. 

  282. `role_id` bigint(0) NULL DEFAULT NULL COMMENT '角色id',
    283. 

  283. `user_id` bigint(0) NULL DEFAULT NULL COMMENT '用户id',
    284. 

  284. PRIMARY KEY (`id`) USING BTREE,
    285. 

  285. INDEX `user_id_index`(`user_id`) USING BTREE,
    286. 

  286. INDEX `announcement_notification_id_index`(`announcement_notification_id`) USING BTREE
    287. 

  287. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公告通知查看记录表' ROW_FORMAT = Dynamic;
    288. 

  288. 

  289. -- 公告通知end
    290. 

  290. 

  291. 

  292. -- 天气预警start
    293. 

  293. delete from sys_menu where menu_name='天气预警数据';
    294. 

  294. INSERT INTO `sys_menu`(`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2166, '天气预警数据', 1, 100, 'core/weather', 'core/weather/index', NULL, 1, 0, 'C', '0', '0', 'core:weather:list', '1', 'color', NULL, '超级管理员', '2023-09-12 11:40:46', '超级管理员', '2023-09-12 11:43:45', '');
    295. 

  295. delete from sys_config where config_key='WEATHER_APP_CODE';
    296. 

  296. INSERT INTO `sys_config`(`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('天气接口AppCode', 'WEATHER_APP_CODE', '3ea812b74f67479e9ab0b3d1969a18d2', 'N', '超级管理员', '2023-09-13 14:08:42', '超级管理员', '2023-09-13 14:38:32', '天气接口的appcode（请根据购买的api接口填写）');
    297. 

  297. DROP TABLE IF EXISTS `core_weather_warning`;
    298. 

  298. CREATE TABLE `core_weather_warning`  (
    299. 

  299.  `id` bigint(0) NOT NULL AUTO_INCREMENT,
    300. 

  300.  `alarm_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预警标题',
    301. 

  301.  `alarm_content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预警内容',
    302. 

  302.  `alarm_level` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预警等级',
    303. 

  303.  `province` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省',
    304. 

  304.  `city` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市',
    305. 

  305.  `area` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区、县（没得区县用市）',
    306. 

  306.  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市区县的编号',
    307. 

  307.  `alarm_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预警类型',
    308. 

  308.  `alarm_time` datetime(0) NULL DEFAULT NULL COMMENT '预警发布时间',
    309. 

  309.  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    310. 

  310.  PRIMARY KEY (`id`) USING BTREE,
    311. 

  311.  INDEX `code`(`code`) USING BTREE
    312. 

  312. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '天气预警数据' ROW_FORMAT = Dynamic;
    313. 

  313. 

  314. DROP TABLE IF EXISTS `core_weather_city`;
    315. 

  315. CREATE TABLE `core_weather_city`  (
    316. 

  316.   `AREACODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    317. 

  317.   `AREAID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    318. 

  318.   `NAMEEN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    319. 

  319.   `NAMECN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    320. 

  320.   `DISTRICTEN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    321. 

  321.   `DISTRICTCN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    322. 

  322.   `PROVEN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    323. 

  323.   `PROVCN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    324. 

  324.   `NATIONEN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    325. 

  325.   `NATIONCN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    326. 

  326.   `GROUPID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
    327. 

  327. ) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '预警城市列表' ROW_FORMAT = Dynamic;
    328. 

  328. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('101231001', '101231001', 'diaoyudao', '钓鱼岛', 'diaoyudao', '钓鱼岛', 'fujian', '福建', 'china', '中国', '-1');
    329. 

  329. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350100', '101230101', 'fuzhou', '福州', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '-1');
    330. 

  330. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350102', '101230106', 'gulou', '鼓楼', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    331. 

  331. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350103', '101230109', 'taijiang', '台江', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    332. 

  332. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350104', '101230112', 'cangshan', '仓山', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    333. 

  333. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350105', '101230113', 'mawei', '马尾', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    334. 

  334. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350111', '101230114', 'jinan', '晋安', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    335. 

  335. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350112', '101230110', 'changle', '长乐', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    336. 

  336. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350121', '101230103', 'minhou', '闽侯', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    337. 

  337. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350122', '101230105', 'lianjiang', '连江', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    338. 

  338. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350123', '101230104', 'luoyuan', '罗源', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    339. 

  339. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350124', '101230102', 'minqing', '闽清', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    340. 

  340. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350125', '101230107', 'yongtai', '永泰', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    341. 

  341. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350128', '101230108', 'pingtan', '平潭', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    342. 

  342. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350181', '101230111', 'fuqing', '福清', 'fuzhou', '福州', 'fujian', '福建', 'china', '中国', '101230101');
    343. 

  343. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350200', '101230201', 'xiamen', '厦门', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '-1');
    344. 

  344. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350203', '101230203', 'siming', '思明', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
    345. 

  345. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350205', '101230204', 'haicang', '海沧', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
    346. 

  346. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350206', '101230205', 'huli', '湖里', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
    347. 

  347. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350211', '101230206', 'jimei', '集美', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
    348. 

  348. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350212', '101230202', 'tongan', '同安', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
    349. 

  349. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350213', '101230207', 'xiangan', '翔安', 'xiamen', '厦门', 'fujian', '福建', 'china', '中国', '101230201');
    350. 

  350. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350300', '101230401', 'putian', '莆田', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '-1');
    351. 

  351. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350302', '101230407', 'chengxiang', '城厢', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
    352. 

  352. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350303', '101230404', 'hanjiang', '涵江', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
    353. 

  353. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350304', '101230406', 'licheng', '荔城', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
    354. 

  354. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350305', '101230405', 'xiuyu', '秀屿', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
    355. 

  355. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350322', '101230402', 'xianyou', '仙游', 'putian', '莆田', 'fujian', '福建', 'china', '中国', '101230401');
    356. 

  356. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350400', '101230801', 'sanming', '三明', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '-1');
    357. 

  357. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350402', '101230812', 'meilie', '梅列', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    358. 

  358. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350403', '101230813', 'sanyuan', '三元', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    359. 

  359. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350421', '101230807', 'mingxi', '明溪', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    360. 

  360. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350423', '101230803', 'qingliu', '清流', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    361. 

  361. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350424', '101230802', 'ninghua', '宁化', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    362. 

  362. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350425', '101230811', 'datian', '大田', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    363. 

  363. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350426', '101230809', 'youxi', '尤溪', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    364. 

  364. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350427', '101230808', 'shaxian', '沙县', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    365. 

  365. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350428', '101230805', 'jiangle', '将乐', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    366. 

  366. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350429', '101230804', 'taining', '泰宁', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    367. 

  367. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350430', '101230806', 'jianning', '建宁', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    368. 

  368. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350481', '101230810', 'yongan', '永安', 'sanming', '三明', 'fujian', '福建', 'china', '中国', '101230801');
    369. 

  369. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350500', '101230501', 'quanzhou', '泉州', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '-1');
    370. 

  370. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350502', '101230511', 'licheng', '鲤城', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    371. 

  371. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350503', '101230512', 'fengze', '丰泽', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    372. 

  372. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350504', '101230513', 'luojiang', '洛江', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    373. 

  373. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350505', '101230514', 'quangang', '泉港', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    374. 

  374. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350521', '101230508', 'huian', '惠安', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    375. 

  375. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('3505211070', '101230507', 'chongwu', '崇武', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    376. 

  376. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350524', '101230502', 'anxi', '安溪', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    377. 

  377. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350525', '101230504', 'yongchun', '永春', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    378. 

  378. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350526', '101230505', 'dehua', '德化', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    379. 

  379. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350527', '101230503', 'jinmen', '金门', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    380. 

  380. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350581', '101230510', 'shishi', '石狮', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    381. 

  381. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350582', '101230509', 'jinjiang', '晋江', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    382. 

  382. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350583', '101230506', 'nanan', '南安', 'quanzhou', '泉州', 'fujian', '福建', 'china', '中国', '101230501');
    383. 

  383. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350600', '101230601', 'zhangzhou', '漳州', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '-1');
    384. 

  384. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350602', '101230611', 'xiangcheng', '芗城', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    385. 

  385. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350603', '101230612', 'longwen', '龙文', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    386. 

  386. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350622', '101230609', 'yunxiao', '云霄', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    387. 

  387. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350623', '101230606', 'zhangpu', '漳浦', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    388. 

  388. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350624', '101230607', 'zhaoan', '诏安', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    389. 

  389. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350625', '101230602', 'changtai', '长泰', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    390. 

  390. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350626', '101230608', 'dongshan', '东山', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    391. 

  391. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350627', '101230603', 'nanjing', '南靖', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    392. 

  392. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350628', '101230604', 'pinghe', '平和', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    393. 

  393. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350629', '101230610', 'huaan', '华安', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    394. 

  394. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350681', '101230605', 'longhai', '龙海', 'zhangzhou', '漳州', 'fujian', '福建', 'china', '中国', '101230601');
    395. 

  395. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350700', '101230901', 'nanping', '南平', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '-1');
    396. 

  396. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350702', '101230911', 'yanping', '延平', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    397. 

  397. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350703', '101230907', 'jianyang', '建阳', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    398. 

  398. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350721', '101230902', 'shunchang', '顺昌', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    399. 

  399. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350722', '101230906', 'pucheng', '浦城', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    400. 

  400. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350723', '101230903', 'guangze', '光泽', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    401. 

  401. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350724', '101230908', 'songxi', '松溪', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    402. 

  402. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350725', '101230909', 'zhenghe', '政和', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    403. 

  403. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350781', '101230904', 'shaowu', '邵武', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    404. 

  404. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350782', '101230905', 'wuyishan', '武夷山', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    405. 

  405. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350783', '101230910', 'jianou', '建瓯', 'nanping', '南平', 'fujian', '福建', 'china', '中国', '101230901');
    406. 

  406. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350800', '101230701', 'longyan', '龙岩', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '-1');
    407. 

  407. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350802', '101230708', 'xinluo', '新罗', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
    408. 

  408. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350803', '101230706', 'yongding', '永定', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
    409. 

  409. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350821', '101230702', 'changting', '长汀', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
    410. 

  410. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350823', '101230705', 'shanghang', '上杭', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
    411. 

  411. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350824', '101230704', 'wuping', '武平', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
    412. 

  412. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350825', '101230703', 'liancheng', '连城', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
    413. 

  413. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350881', '101230707', 'zhangping', '漳平', 'longyan', '龙岩', 'fujian', '福建', 'china', '中国', '101230701');
    414. 

  414. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350900', '101230301', 'ningde', '宁德', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '-1');
    415. 

  415. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350902', '101230310', 'jiaocheng', '蕉城', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    416. 

  416. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350921', '101230303', 'xiapu', '霞浦', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    417. 

  417. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350922', '101230302', 'gutian', '古田', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    418. 

  418. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350923', '101230309', 'pingnan', '屏南', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    419. 

  419. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350924', '101230304', 'shouning', '寿宁', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    420. 

  420. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350925', '101230305', 'zhouning', '周宁', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    421. 

  421. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350926', '101230307', 'zherong', '柘荣', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    422. 

  422. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350981', '101230306', 'fuan', '福安', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    423. 

  423. INSERT INTO `core_weather_city`(`AREACODE`, `AREAID`, `NAMEEN`, `NAMECN`, `DISTRICTEN`, `DISTRICTCN`, `PROVEN`, `PROVCN`, `NATIONEN`, `NATIONCN`, `GROUPID`) VALUES ('350982', '101230308', 'fuding', '福鼎', 'ningde', '宁德', 'fujian', '福建', 'china', '中国', '101230301');
    424. 

  424. 

  425. 

  426. -- 天气预警end
    427. 

  427. 

  428. -- Web演练库按钮及权限
    429. 

  429. delete from sys_menu where menu_name in ('预案演练管理','演练');
    430. 

  430. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2319, '预案演练管理', 0, 6, '/drill', null, null, 1, 0, 'M', '0', '0', null, '1', 'dashboard', null, '超级管理员', now(), '', null, '');
    431. 

  431. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2311, '演练', 0, 12, '/', null, null, 1, 0, 'M', '0', '0', null, '0', '#', null, '超级管理员', now(), '', null, '');
    432. 

  432. 

  433. delete from sys_menu where menu_name in ('演练库管理','演练库新增','演练库查询','演练库编辑','演练库详情','演练库删除');
    434. 

  434. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2320, '演练库管理', 2319, 1, '/dictionary', 'core/drill/drillDictionary/index', null, 1, 0, 'C', '0', '0', 'core:drillDictionary:list', '1', 'component', null, '超级管理员', now(), '超级管理员', now(), '');
    435. 

  435. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2220, '演练库新增', 2320, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:add', '1', '#', null, '超级管理员', now(), '', null, '');
    436. 

  436. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2221, '演练库查询', 2320, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:list', '1', '#', null, '超级管理员', now(), '', null, '');
    437. 

  437. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2222, '演练库编辑', 2320, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:edit', '1', '#', null, '超级管理员', now(), '', null, '');
    438. 

  438. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2223, '演练库详情', 2320, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:query', '1', '#', null, '超级管理员', now(), '', null, '');
    439. 

  439. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2224, '演练库删除', 2320, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:drillDictionary:remove', '1', '#', null, '超级管理员', now(), '', null, '');
    440. 

  440. 

  441. -- Web演练计划按钮及权限
    442. 

  442. delete from sys_menu where menu_name in ('演练计划管理','演练计划新增','演练计划列表','演练计划下发','演练计划编辑','演练计划删除','演练计划详情');
    443. 

  443. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2321, '演练计划管理', 2319, 2, '/drillPlan', 'core/drill/plan/index', null, 1, 0, 'C', '0', '0', 'core:drillPlan:list', '1', 'documentation', null, '超级管理员', now(), '超级管理员', now(), '');
    444. 

  444. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2225, '演练计划新增', 2321, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:add', '1', null, null, '超级管理员', now(), '超级管理员', now(), '');
    445. 

  445. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2226, '演练计划列表', 2321, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:list', '1', null, null, '超级管理员', now(), '', null, '');
    446. 

  446. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2227, '演练计划下发', 2321, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:publish', '1', null, null, '超级管理员', now(), '超级管理员', now(), '');
    447. 

  447. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2228, '演练计划编辑', 2321, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:edit', '1', null, null, '超级管理员', now(), '', null, '');
    448. 

  448. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2229, '演练计划删除', 2321, 5, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:remove', '1', null, null, '超级管理员', now(), '', null, '');
    449. 

  449. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2338, '演练计划详情', 2321, 6, '', null, null, 1, 0, 'F', '0', '0', 'core:drillPlan:query', '1', null, null, '超级管理员', now(), '', null, '');
    450. 

  450. 

  451. -- Web演练任务按钮及权限
    452. 

  452. delete from sys_menu where menu_name in ('演练任务管理','演练任务登记','演练任务详情','演练任务签名','演练任务评价');
    453. 

  453. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2322, '演练任务管理', 2319, 3, '/drillTask', 'core/drill/task/index', null, 1, 0, 'C', '0', '0', 'core:drillTask:list', '1', 'druid', null, '超级管理员', now(), '超级管理员', now(), '');
    454. 

  454. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2215, '演练任务登记', 2322, 1, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:edit', '1', '#', null, '超级管理员', now(), '', null, '');
    455. 

  455. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2216, '演练任务详情', 2322, 2, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:query', '1', '#', null, '超级管理员', now(), '', null, '');
    456. 

  456. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2217, '演练任务签名', 2322, 3, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:sign', '1', '#', null, '超级管理员', now(), '', null, '');
    457. 

  457. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2218, '演练任务评价', 2322, 4, '', null, null, 1, 0, 'F', '0', '0', 'core:drillTask:evaluate', '1', '#', null, '超级管理员', now(), '', null, '');
    458. 

  458. 

  459. -- App端预案演练登记菜单目录
    460. 

  460. delete from sys_menu where menu_name in ('演练登记','演练统计排名','优秀案例管理','优秀案例学习');
    461. 

  461. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2312, '演练登记', 2311, 1, '/rehearsalTask', null, null, 1, 0, 'C', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAM1BMVEVHcEzYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXHYvXF4gE2CAAAAEHRSTlMA0HAgQLDwgMAQYKCQUDDgVczG7QAAAAlwSFlzAAALEgAACxIB0t1+/AAAAhVJREFUWIXtmNtyhSAMRVFAUVH5/6/tGIkiBjmAnXZa9lsHXIVctvGwqqqqqoBaUyI10NSliGqMorF9Idb8AFb26dJrDCvy6lk+YwNhj2r5Hiyr2H+G5W2vVN/yV7FCYZ8qv23yscPkGoC++mA2dmiuxtJcuNlYZTzJN7DEq2N8AdvdsWs5dqR82zluJlZS2KkY21BYZ3cmlqK6oN+FXSlqU4wlU+Y0RCaWHKTKC2wg2qFzXCETS41SvbOci/UN7JKwAgfjXhheMkbvvM1LNr7tOA7ctd5SCZaxWSullJ5vC2XYoP4StqGXmJDqLnk2b2S+NZpc0pQjOB9NQ2Qa37ZetMBZA1T0sHkvvEfsVVCfpCvugqHJjhAJWB5wLxS8JcdUrGShl7lVB6FNxUKuybfuZceUhoWzPH8Lw33mNOx0HiUoqLE1CbtEEmawVnQYe8/MGkuYwcbkYaxv//YgjwnDK227JI1li9f4MMfzGHXvdz5N9++UB4Xs4NSagkNhZCi8ber7u4KIsEBB5WDCJqpZZrsWpy5n3mC6wA8RQWHFftwu8JuSI+fp0UnYSra2GM+dn2KhcTGiLY21rRIqLQoLEcOQDDQWGztaW+fT82Eh8C9o7IyX+RQL1SiP5wNYe51o6R5PaydhTcCNxWFvSwSL14Zw4QjeBsZxwT6Pwi7oHG7/2OpyIH7LO/fHK7eqqur3izH2BalxfxDJImssAAAAAElFTkSuQmCC', null, '超级管理员', now(), '超级管理员',now(), '');
    462. 

  462. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2313, '演练统计排名', 2311, 1, '/drillStatistics', null, null, 1, 0, 'C', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAM1BMVEVHcEzB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pLB0pJW8V+EAAAAEHRSTlMAYLDgEPDQwIBAMKBwIJBQkhN9vAAAAAlwSFlzAAALEgAACxIB0t1+/AAAAoZJREFUWIXtmNmSrCAMhlFZ4oLm/Z92Stkh2kJbp07N+F/1Ih8SsgF79epfS68SEeXCH50X0Ep0D1JnDFofowLG2h6iapFgRdXgCdXJPwumIs2roVdB3lJ8QJxorMqwM/FMlz2zE8eJsR4RRxqbjaBWNebPsIPYzydvcRO7DxeZEewi5Zmri8/YHQHZb9NwST3sE4vwXEWZkMsrarEdxBaQWMYXuAh2PnyywQn2g5J9FpQbNmFjMwgydtuwbHR2UHTINGIZ21alFJzEYTv2Wv8Rls+Jg/WELzZg92BJREROA9amjD2TnAZEPdb57O6vq/1cJPJqLHf5a4yK2vA11pfHGFu8bjXWpxkWB3H+urXYFBRyTpYZarG+PPbHV0y/tmK155iSElw49d1KLGSrDvVn+QYb6oLOppFfYKcQs12GtfM0YaMcc9SaOD0kVqjC8rhDEFOadBJfUIW198wvUVIlKq3kAtJUdvjCiqSkH030gTM9BlVwubztc/LbXaQP1yXlvRIiDH7ABTZ8omygypFglrERjZSV9H/1Bdb83hHYLh9BbdkkyGbFBK4g1gk2pnmCLVu7BYgDl+ntZwprtyO0nhV+a3ATiTXGHZJn72G5G0lhN/SbVok1KXulsWbO4Ou1WE0FxWbnEn5DKmwrbT+vc6qwkw7BeWpSzQTGFe3rCuf6hwOMEEd7Sw8GjmZTze2zw02serEv9sW+2F+KLbotvcCiy2crsHuGHyBo8+3H+RpuYLe8MPlzBtHa3ccWdfSitavBsi2+uTxu7cxMZ1eBN7Gl+N5Sr+cXYY3YT7L3t4vDXjhNjbSjGb58hmrPHas9P5G3dm0a1/mIIQ49PGSCV39UjLEf/p1q4sZjU5oAAAAASUVORK5CYII=', null, '超级管理员', now(), '超级管理员', now(), '');
    463. 

  463. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2314, '优秀案例管理', 2311, 2, '/rehearsaloptimal', null, null, 1, 0, 'M', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFYAAABWCAMAAABiiJHFAAAAM1BMVEVHcEymgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKWmgKV36H0vAAAAEHRSTlMA0KAg8BAwQMCAYOCQULBwyOgprQAAAAlwSFlzAAALEgAACxIB0t1+/AAAAllJREFUWIXtmFuSoCAMRQERiM/sf7VTPASCoNjdX1PcX/EYk0uCsqGhoaE/kgJQH0jzDrBMr8uURJS6G7qhk5jfqYi4dFI5Bq2Pb2ipxq6FLqzBKP5CPRgT9rU6qAtmagcySURus7RJxO1TsIhrc9ms9VVTrV+KYIVE73boFMV22+dbtBSrO9TASoIlWRPYoYYtjvxO4jDdQ0WsY8nNZAep32DZllYc9IpA5OZRHGXT6jGFR+nHV2doNO2Lu+sK672H/A5L9lA3dkE5tbFzZs2ygz1htfVWE6uIbw3N7gNWSVvgFpZSQ5NqYlOmJumWNrDzWrqQ9DyKPVdE4cEzR6naJQPPWufUIPPSEewe8qT9QHFX6tg5pMBkfVc0sJNEqW3AaJYD8WRtLGRvHnvDXMdyxN3aas0fXsde9VqyR4Q4SqyIadcmtaQqNo4xlbecbPAk7FKfn1VsHGMud5g/JGGv/MvaNqxhI8hfil5LHrPY8EqVjtHAbpQTa5ay4JJQ3dYP2Bieb5mxZqlOr6O7gk3Nnyu6jeW2dE7gCtZF5yOW+0WNmZDXw/UOYFrHuQrW9e7zSm+IdY4xGxAmWoU3knHHOh/IcrpeOz9JGgPQSvEd6yaYuGGv3YlcAHwvmTetvmMZUzsAnA0Q1V5ihXdoDRvlyiWeBrosB7rx++AJ+5NTjcOqP8fuvmmWByKyRjZARMVJexIbKw/jxZqp5yBa90roBOGF+z5iOhSwbGAHdmAHdmAHNsmfinkYh1/+ID7K/7PbPf7xc/sj9wSwnwUaoPPv4dDQ0H8jxtg/vgNYlsZOPYcAAAAASUVORK5CYII=', null, '超级管理员', now(), '超级管理员', now(), '');
    464. 

  464. INSERT INTO sys_menu (id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, platform_type, icon, image_path, create_by, create_time, update_by, update_time, remark) VALUES (2315, '优秀案例学习', 2311, 4, '/rehearsallearning', null, null, 1, 0, 'M', '0', '0', '', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAFcAAABWCAMAAACNSvr7AAAAM1BMVEVHcEx3max3max3max3max3max3max3max3max3max3max3max3max3max3max3max3mayxYUqyAAAAEHRSTlMAMNAgEPBggMBAUOCQoLBwPe7hCQAAAAlwSFlzAAALEgAACxIB0t1+/AAAAjBJREFUWIXtmOtyhCAMhVFBQLzs+z9tRyRIFFwJbKed9fza2tmvkOQksezRo0fFGlRSM6fDh9eFFjpXXnHlt3FnHcpU4/bxmBdzBSo18bV5+5160FpPdbjD6bn5QD0opcyfiW+npVy074B1uFyCR9u+IncRwZeMrsTl8+Fr65H1Fbe/QWWsjX6vkatGeKTkrnvY8YQN61bZn9vuFipU9MLG18WGJQxKFY2gn4w2BgRsF8+Mcb9ebzPlUxlbEinvPJeEZVOC6zInqb0gHl5f+ryhYd9xyfoUN+aKVbqQ2ye4BSujFRdR7FyITRVaaRgSB1bF2OgGLUqja3VKnaCa4QjGoWgrYRnrguQJWSUIQJbWeGLua1IfuXF+0nmRzFOqnZFm5a6LbYky20GJYbypoKWFxxVriNGmRredCShbpsKxNFKxqJNtHTfcAQWVO5+5KMLEYuMI0py5tE0Hr1Du0njs00otzBpMHuyTewv0QQ1CuD0EDyXSmMOD2A1gHPNX/pp+nMPwGAWH8o8nPC3b+C3MNSMmcMBWAd5bhz0728u+5fQ48y6b7gU738tQUIIdzuW4IzEQkLWRxc8L98n0ss9a597Q3IF5C5XrPmR6GVqOgosLe+LOZxP+ct6qtmdtbzUTZ42vaeUdkuVlGBTrafYaHnerKH+lrHEErpqOrTHgQqvI8LJ/124uuFAyGV6GMFj3JrmuhDPGEXfrjS2uIbbvrJfni/1IasKPHv0DMcZ+AB6xa3Jz3P3pAAAAAElFTkSuQmCC', null, '超级管理员', now(), '超级管理员', now(), '');
    465. 

  465. 

  466. -- 演练相关菜单权限
    467. 

  467. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2216);
    468. 

  468. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2217);
    469. 

  469. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2218);
    470. 

  470. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2220);
    471. 

  471. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2221);
    472. 

  472. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2222);
    473. 

  473. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2223);
    474. 

  474. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2224);
    475. 

  475. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2225);
    476. 

  476. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2226);
    477. 

  477. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2227);
    478. 

  478. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2228);
    479. 

  479. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2229);
    480. 

  480. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2311);
    481. 

  481. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2312);
    482. 

  482. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2313);
    483. 

  483. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2314);
    484. 

  484. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2315);
    485. 

  485. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2319);
    486. 

  486. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2320);
    487. 

  487. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2321);
    488. 

  488. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2322);
    489. 

  489. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2338);
    490. 

  490. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2216);
    491. 

  491. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2217);
    492. 

  492. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2218);
    493. 

  493. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2220);
    494. 

  494. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2221);
    495. 

  495. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2222);
    496. 

  496. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2223);
    497. 

  497. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2224);
    498. 

  498. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2225);
    499. 

  499. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2226);
    500. 

  500. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2227);
    501. 

  501. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2228);
    502. 

  502. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2229);
    503. 

  503. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2311);
    504. 

  504. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2312);
    505. 

  505. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2313);
    506. 

  506. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2314);
    507. 

  507. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2315);
    508. 

  508. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2319);
    509. 

  509. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2320);
    510. 

  510. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2321);
    511. 

  511. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2322);
    512. 

  512. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2338);
    513. 

  513. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2216);
    514. 

  514. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2218);
    515. 

  515. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2220);
    516. 

  516. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2221);
    517. 

  517. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2222);
    518. 

  518. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2223);
    519. 

  519. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2224);
    520. 

  520. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2225);
    521. 

  521. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2226);
    522. 

  522. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2227);
    523. 

  523. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2228);
    524. 

  524. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2229);
    525. 

  525. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2311);
    526. 

  526. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2312);
    527. 

  527. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2313);
    528. 

  528. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2314);
    529. 

  529. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2315);
    530. 

  530. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2319);
    531. 

  531. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2320);
    532. 

  532. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2321);
    533. 

  533. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2322);
    534. 

  534. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2338);
    535. 

  535. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2216);
    536. 

  536. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2218);
    537. 

  537. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2220);
    538. 

  538. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2221);
    539. 

  539. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2222);
    540. 

  540. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2223);
    541. 

  541. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2224);
    542. 

  542. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2225);
    543. 

  543. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2226);
    544. 

  544. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2227);
    545. 

  545. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2228);
    546. 

  546. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2229);
    547. 

  547. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2311);
    548. 

  548. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2312);
    549. 

  549. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2313);
    550. 

  550. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2314);
    551. 

  551. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2315);
    552. 

  552. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2319);
    553. 

  553. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2320);
    554. 

  554. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2321);
    555. 

  555. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2322);
    556. 

  556. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2338);
    557. 

  557. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2215);
    558. 

  558. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2216);
    559. 

  559. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2217);
    560. 

  560. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2218);
    561. 

  561. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2220);
    562. 

  562. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2221);
    563. 

  563. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2222);
    564. 

  564. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2223);
    565. 

  565. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2224);
    566. 

  566. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2225);
    567. 

  567. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2226);
    568. 

  568. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2227);
    569. 

  569. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2228);
    570. 

  570. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2229);
    571. 

  571. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2311);
    572. 

  572. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2312);
    573. 

  573. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2313);
    574. 

  574. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2314);
    575. 

  575. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2315);
    576. 

  576. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2319);
    577. 

  577. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2320);
    578. 

  578. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2321);
    579. 

  579. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2322);
    580. 

  580. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2338);
    581. 

  581. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2215);
    582. 

  582. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2216);
    583. 

  583. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2217);
    584. 

  584. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2218);
    585. 

  585. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2220);
    586. 

  586. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2221);
    587. 

  587. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2222);
    588. 

  588. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2223);
    589. 

  589. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2224);
    590. 

  590. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2225);
    591. 

  591. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2226);
    592. 

  592. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2227);
    593. 

  593. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2228);
    594. 

  594. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2229);
    595. 

  595. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2311);
    596. 

  596. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2312);
    597. 

  597. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2313);
    598. 

  598. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2314);
    599. 

  599. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2315);
    600. 

  600. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2319);
    601. 

  601. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2320);
    602. 

  602. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2321);
    603. 

  603. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2322);
    604. 

  604. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2338);
    605. 

  605. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2216);
    606. 

  606. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2217);
    607. 

  607. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2220);
    608. 

  608. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2221);
    609. 

  609. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2222);
    610. 

  610. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2223);
    611. 

  611. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2224);
    612. 

  612. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2225);
    613. 

  613. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2226);
    614. 

  614. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2228);
    615. 

  615. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2229);
    616. 

  616. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2311);
    617. 

  617. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2312);
    618. 

  618. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2315);
    619. 

  619. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2319);
    620. 

  620. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2320);
    621. 

  621. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2321);
    622. 

  622. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2322);
    623. 

  623. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2338);
    624. 

  624. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2215);
    625. 

  625. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2216);
    626. 

  626. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2217);
    627. 

  627. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2220);
    628. 

  628. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2221);
    629. 

  629. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2222);
    630. 

  630. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2223);
    631. 

  631. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2224);
    632. 

  632. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2225);
    633. 

  633. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2226);
    634. 

  634. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2227);
    635. 

  635. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2228);
    636. 

  636. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2229);
    637. 

  637. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2311);
    638. 

  638. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2312);
    639. 

  639. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2315);
    640. 

  640. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2319);
    641. 

  641. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2320);
    642. 

  642. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2321);
    643. 

  643. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2322);
    644. 

  644. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2338);
    645. 

  645. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2215);
    646. 

  646. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2216);
    647. 

  647. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2217);
    648. 

  648. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2220);
    649. 

  649. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2221);
    650. 

  650. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2222);
    651. 

  651. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2223);
    652. 

  652. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2224);
    653. 

  653. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2225);
    654. 

  654. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2226);
    655. 

  655. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2227);
    656. 

  656. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2228);
    657. 

  657. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2229);
    658. 

  658. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2311);
    659. 

  659. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2312);
    660. 

  660. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2315);
    661. 

  661. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2319);
    662. 

  662. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2320);
    663. 

  663. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2321);
    664. 

  664. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2322);
    665. 

  665. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2338);
    666. 

  666. 

  667. 

  668. 

  669. -- 检查任务表
    670. 

  670. DROP TABLE IF EXISTS `core_safety_task`;
    671. 

  671. CREATE TABLE `core_safety_task` (
    672. 

  672.                                     `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    673. 

  673.                                     `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
    674. 

  674.                                     `create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
    675. 

  675.                                     `modified_id` bigint DEFAULT NULL COMMENT '最后修改人id',
    676. 

  676.                                     `modified_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人名称',
    677. 

  677.                                     `update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
    678. 

  678.                                     `exception_count` int DEFAULT '0' COMMENT '异常数目',
    679. 

  679.                                     `org_id` bigint DEFAULT '0' COMMENT '受检机构',
    680. 

  680.                                     `org_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '受检机构',
    681. 

  681.                                     `org_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '受检机构',
    682. 

  682.                                     `check_org_id` bigint DEFAULT NULL COMMENT '执行检查机构',
    683. 

  683.                                     `check_org_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行检查机构',
    684. 

  684.                                     `status` int DEFAULT NULL COMMENT '0待检查,1检查完成',
    685. 

  685.                                     `done_status` int DEFAULT NULL COMMENT '0:代办,1:逾期,2:按时,3:补登',
    686. 

  686.                                     `check_type` int DEFAULT NULL COMMENT '0 常规安全检查 1 专项安全检查',
    687. 

  687.                                     `check_cycle` int DEFAULT '0' COMMENT '检查周期:0 无周期 1每日、2每周、3每月、4每季、5每半年、6每年',
    688. 

  688.                                     `ymd_date` date DEFAULT NULL COMMENT '年月日',
    689. 

  689.                                     `ymd_day` int DEFAULT NULL COMMENT '日',
    690. 

  690.                                     `ymd_month` int DEFAULT NULL COMMENT '月',
    691. 

  691.                                     `ymd_quarter` int DEFAULT NULL COMMENT '季',
    692. 

  692.                                     `ymd_week` int DEFAULT NULL COMMENT '周',
    693. 

  693.                                     `ymd_year` int DEFAULT NULL COMMENT '年',
    694. 

  694.                                     `ymd_halfyear` int DEFAULT NULL COMMENT '半年',
    695. 

  695.                                     `submit_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提交人',
    696. 

  696.                                     `submit_time` datetime DEFAULT NULL COMMENT '提交时间',
    697. 

  697.                                     `plan_id` bigint DEFAULT NULL COMMENT '计划id',
    698. 

  698.                                     `start_time` datetime DEFAULT NULL COMMENT '任务执行开始时间',
    699. 

  699.                                     `end_time` datetime DEFAULT NULL COMMENT '任务执行结束时间',
    700. 

  700.                                     `plan_start_time` datetime DEFAULT NULL COMMENT '计划开始时间',
    701. 

  701.                                     `plan_end_time` datetime DEFAULT NULL COMMENT '计划截止时间',
    702. 

  702.                                     `role_id` bigint DEFAULT NULL COMMENT '角色id',
    703. 

  703.                                     `deleted` int DEFAULT '0' COMMENT '是否删除0否1是',
    704. 

  704.                                     `is_question` int DEFAULT NULL COMMENT '0:未整改 1:已开始整改',
    705. 

  705.                                     `batch_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '批次id,同一执行机构一个批次id',
    706. 

  706.                                     `source_type` int DEFAULT '0' COMMENT '数据来源 0：检查计划 ，1：登记检查结果',
    707. 

  707.                                     `pdf_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登记簿pdf 文件地址',
    708. 

  708.                                     PRIMARY KEY (`id`) USING BTREE,
    709. 

  709.                                     KEY `idx_resumption_orgId` (`org_id`) USING BTREE,
    710. 

  710.                                     KEY `idx_orgpath` (`org_path`(191)) USING BTREE
    711. 

  711. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
    712. 

  712. 

  713. DROP TABLE IF EXISTS `core_safety_task_data`;
    714. 

  714. CREATE TABLE `core_safety_task_data` (
    715. 

  715.                                          `id` bigint NOT NULL DEFAULT '0',
    716. 

  716.                                          `plan_id` bigint DEFAULT NULL COMMENT '计划id',
    717. 

  717.                                          `item_id` bigint DEFAULT NULL COMMENT '检查项id',
    718. 

  718.                                          `point_id` bigint DEFAULT NULL COMMENT '要点id',
    719. 

  719.                                          `task_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查任务id',
    720. 

  720.                                          `area_id` bigint DEFAULT NULL COMMENT '区域id',
    721. 

  721.                                          `res_value` int DEFAULT NULL COMMENT '正常不正常，通过不通过，合格不合格',
    722. 

  722.                                          `reform_type` int DEFAULT NULL COMMENT '整改类型',
    723. 

  723.                                          `res_time` datetime DEFAULT NULL COMMENT '时分',
    724. 

  724.                                          `submit_time` datetime DEFAULT NULL COMMENT '提交时间',
    725. 

  725.                                          `res_status` int DEFAULT NULL COMMENT '0未提交 1正常提交 2延迟提交',
    726. 

  726.                                          `submit_by` bigint DEFAULT NULL COMMENT '提交人id',
    727. 

  727.                                          `submit_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提交人名',
    728. 

  728.                                          PRIMARY KEY (`id`) USING BTREE,
    729. 

  729.                                          KEY `item_id` (`point_id`) USING BTREE,
    730. 

  730.                                          KEY `check_task_id` (`task_id`) USING BTREE
    731. 

  731. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全检查项表';
    732. 

  732. 

  733. 

  734. DROP TABLE IF EXISTS `core_resumption_configuration`;
    735. 

  735. CREATE TABLE `core_resumption_configuration` (
    736. 

  736.                                                  `id` bigint NOT NULL COMMENT '主键',
    737. 

  737.                                                  `resumption_cycle` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '履职周期',
    738. 

  738.                                                  `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    739. 

  739.                                                  `create_time` datetime DEFAULT NULL,
    740. 

  740.                                                  `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    741. 

  741.                                                  `update_time` datetime DEFAULT NULL,
    742. 

  742.                                                  `del_flag` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
    743. 

  743.                                                  `all_day` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '全天',
    744. 

  744.                                                  `front` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '营业前',
    745. 

  745.                                                  `centre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '营业中',
    746. 

  746.                                                  `after` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '营业后',
    747. 

  747.                                                  `time_unit` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '时间单位',
    748. 

  748.                                                  PRIMARY KEY (`id`) USING BTREE
    749. 

  749. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='履职任务定时提醒';
    750. 

  750. DROP TABLE IF EXISTS `core_safety_task_data_nfc`;
    751. 

  751. CREATE TABLE `core_safety_task_data_nfc` (
    752. 

  752.                                              `id` bigint NOT NULL DEFAULT '0',
    753. 

  753.                                              `task_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查任务id',
    754. 

  754.                                              `task_data_id` bigint DEFAULT NULL COMMENT '安全检查项id',
    755. 

  755.                                              `check_id` bigint NOT NULL DEFAULT '0' COMMENT '采集点id',
    756. 

  756.                                              `submit_time` datetime DEFAULT NULL COMMENT '提交时间',
    757. 

  757.                                              `status` int DEFAULT '0' COMMENT '状态0未扫1以扫',
    758. 

  758.                                              `point_id` bigint DEFAULT NULL COMMENT '要点id',
    759. 

  759.                                              PRIMARY KEY (`id`) USING BTREE,
    760. 

  760.                                              KEY `task_id` (`task_id`) USING BTREE
    761. 

  761. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全检查nfc扫描表';
    762. 

  762. 

  763. -- 新增系统参数:演练任务行社推荐数量单季度最大值,演练任务地区推荐数量单季度最大值
    764. 

  764. INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('演练任务行社推荐数量单季度最大值', 'HS_REC_DRILL_TASK_MAX', '3', 'Y', '超级管理员', '2023-09-21 11:20:41', '', null, null);
    765. 

  765. INSERT INTO sys_config (config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark) VALUES ('演练任务地区推荐数量单季度最大值', 'AREA_REC_DRILL_TASK_MAX', '3', 'Y', '超级管理员', '2023-09-21 11:35:30', '', null, null);
    766. 

  766. 

  767. -- ----------------------------
    768. 

  768. -- Table structure for core_message_send
    769. 

  769. -- ----------------------------
    770. 

  770. DROP TABLE IF EXISTS `core_message_send`;
    771. 

  771. CREATE TABLE `core_message_send` (
    772. 

  772.                                      `id` bigint NOT NULL COMMENT '主键',
    773. 

  773.                                      `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
    774. 

  774.                                      `type` varchar(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
    775. 

  775.                                      `content` varchar(4000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
    776. 

  776.                                      `send_user` bigint DEFAULT NULL COMMENT '按用户选择',
    777. 

  777.                                      `send_role` bigint DEFAULT NULL COMMENT '按角色选择',
    778. 

  778.                                      `send_time_type` varchar(2) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '发送时间类型1立即2指定时间',
    779. 

  779.                                      `send_time` datetime DEFAULT NULL COMMENT '发送时间',
    780. 

  780.                                      `del_flag` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '0未2删',
    781. 

  781.                                      `send_status` varchar(2) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '1已发送2待发送',
    782. 

  782.                                      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    783. 

  783.                                      `create_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
    784. 

  784.                                      `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    785. 

  785.                                      `update_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
    786. 

  786.                                      PRIMARY KEY (`id`)
    787. 

  787. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='消息发送配置';
    788. 

  788. -- 消息发送配置end
    789. 

  789. 

  790. -- ----------------------------
    791. 

  791. -- Table structure for core_message_center
    792. 

  792. -- ----------------------------
    793. 

  793. DROP TABLE IF EXISTS `core_message_center`;
    794. 

  794. CREATE TABLE `core_message_center` (
    795. 

  795.                                        `id` bigint NOT NULL,
    796. 

  796.                                        `type` varchar(2) COLLATE utf8mb4_general_ci NOT NULL COMMENT '1公告2业务提醒3消息',
    797. 

  797.                                        `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
    798. 

  798.                                        `is_read` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '0未读1已读',
    799. 

  799.                                        `content` varchar(4000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '内容',
    800. 

  800.                                        `del_flag` varchar(2) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '0未2删',
    801. 

  801.                                        `user_id` bigint DEFAULT NULL COMMENT '用户',
    802. 

  802.                                        `create_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
    803. 

  803.                                        `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    804. 

  804.                                        `update_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
    805. 

  805.                                        `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    806. 

  806.                                        PRIMARY KEY (`id`)
    807. 

  807. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='消息中心';
    808. 

  808. 

  809. DROP TABLE IF EXISTS `core_safety_task_data_remark`;
    810. 

  810. CREATE TABLE `core_safety_task_data_remark` (
    811. 

  811.                                                 `id` bigint NOT NULL DEFAULT '0',
    812. 

  812.                                                 `task_data_id` bigint DEFAULT NULL COMMENT '检查项id',
    813. 

  813.                                                 `task_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '检查任务id',
    814. 

  814.                                                 `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '问题描述',
    815. 

  815.                                                 PRIMARY KEY (`id`) USING BTREE,
    816. 

  816.                                                 KEY `task_item_id` (`task_data_id`) USING BTREE
    817. 

  817. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全检查项表问题描述表';
    818. 

  818. 

  819. DROP TABLE IF EXISTS `core_safety_task_data_remarkimg`;
    820. 

  820. CREATE TABLE `core_safety_task_data_remarkimg` (
    821. 

  821.                                                    `id` bigint NOT NULL DEFAULT '0',
    822. 

  822.                                                    `task_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '安全检查任务id',
    823. 

  823.                                                    `task_data_id` bigint DEFAULT NULL COMMENT '安全检查项id',
    824. 

  824.                                                    `remark_id` bigint DEFAULT NULL COMMENT '安全检查项问题描述id',
    825. 

  825.                                                    `img_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片存放路径',
    826. 

  826.                                                    PRIMARY KEY (`id`) USING BTREE,
    827. 

  827.                                                    KEY `data_id` (`remark_id`) USING BTREE
    828. 

  828. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='安全检查产生图片表';
    829. 

  829. 

  830. -- 调整core_safecheck_plan字段
    831. 

  831. -- 调整安全检查字段
    832. 

  832. DELIMITER $$
    833. 

  833. CREATE PROCEDURE add_column_if_not_exists()
    834. 

  834. BEGIN
    835. 

  835.   IF NOT EXISTS (
    836. 

  836.       SELECT *
    837. 

  837.       FROM INFORMATION_SCHEMA.COLUMNS
    838. 

  838.       WHERE TABLE_NAME = 'core_safety_task'
    839. 

  839.       AND COLUMN_NAME = 'des'
    840. 

  840.   )
    841. 

  841.   THEN
    842. 

  842. ALTER TABLE core_safety_task
    843. 

  843.     ADD COLUMN des VARCHAR(4000) COMMENT '备注';
    844. 

  844. END IF;
    845. 

  845. END$$
    846. 

  846. DELIMITER ;
    847. 

  847. 

  848. CALL add_column_if_not_exists();
    849. 

  849. DROP PROCEDURE add_column_if_not_exists;
    850. 

  850. 

  851. 

  852. 

  853. DELIMITER $$
    854. 

  854. CREATE PROCEDURE add_column_if_not_exists()
    855. 

  855. BEGIN
    856. 

  856.   IF NOT EXISTS (
    857. 

  857.       SELECT *
    858. 

  858.       FROM INFORMATION_SCHEMA.COLUMNS
    859. 

  859.       WHERE TABLE_NAME = 'core_safecheck_plan_to_point'
    860. 

  860.       AND COLUMN_NAME = 'required'
    861. 

  861.   )
    862. 

  862.   THEN
    863. 

  863. ALTER TABLE core_safecheck_plan_to_point
    864. 

  864.     ADD COLUMN required tinyint(1) COMMENT '是否必检';
    865. 

  865. END IF;
    866. 

  866. END$$
    867. 

  867. DELIMITER ;
    868. 

  868. 

  869. CALL add_column_if_not_exists();
    870. 

  870. DROP PROCEDURE add_column_if_not_exists;
    871. 

  871. 

  872. DROP TABLE IF EXISTS `core_safety_task`;
    873. 

  873. CREATE TABLE `core_safety_task` (
    874. 

  874.                                     `id` bigint NOT NULL,
    875. 

  875.                                     `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
    876. 

  876.                                     `create_time` datetime(6) DEFAULT NULL COMMENT '创建时间',
    877. 

  877.                                     `modified_id` bigint DEFAULT NULL COMMENT '最后修改人id',
    878. 

  878.                                     `modified_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人名称',
    879. 

  879.                                     `update_time` datetime(6) DEFAULT NULL COMMENT '更新时间',
    880. 

  880.                                     `exception_count` int DEFAULT '0' COMMENT '异常数目',
    881. 

  881.                                     `org_id` bigint DEFAULT '0' COMMENT '受检机构',
    882. 

  882.                                     `org_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '受检机构',
    883. 

  883.                                     `org_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '受检机构',
    884. 

  884.                                     `check_org_id` bigint DEFAULT NULL COMMENT '执行检查机构',
    885. 

  885.                                     `check_org_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '执行检查机构',
    886. 

  886.                                     `status` int DEFAULT NULL COMMENT '0待检查,1检查完成',
    887. 

  887.                                     `done_status` int DEFAULT NULL COMMENT '0:代办,1:逾期,2:按时,3:补登',
    888. 

  888.                                     `check_type` int DEFAULT NULL COMMENT '0 常规安全检查 1 专项安全检查',
    889. 

  889.                                     `check_cycle` int DEFAULT '0' COMMENT '检查周期:0 无周期 1每日、2每周、3每月、4每季、5每半年、6每年',
    890. 

  890.                                     `ymd_date` date DEFAULT NULL COMMENT '年月日',
    891. 

  891.                                     `ymd_day` int DEFAULT NULL COMMENT '日',
    892. 

  892.                                     `ymd_month` int DEFAULT NULL COMMENT '月',
    893. 

  893.                                     `ymd_quarter` int DEFAULT NULL COMMENT '季',
    894. 

  894.                                     `ymd_week` int DEFAULT NULL COMMENT '周',
    895. 

  895.                                     `ymd_year` int DEFAULT NULL COMMENT '年',
    896. 

  896.                                     `ymd_halfyear` int DEFAULT NULL COMMENT '半年',
    897. 

  897.                                     `submit_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '提交人',
    898. 

  898.                                     `submit_time` datetime DEFAULT NULL COMMENT '提交时间',
    899. 

  899.                                     `plan_id` bigint DEFAULT NULL COMMENT '计划id',
    900. 

  900.                                     `start_time` datetime DEFAULT NULL COMMENT '任务执行开始时间',
    901. 

  901.                                     `end_time` datetime DEFAULT NULL COMMENT '任务执行结束时间',
    902. 

  902.                                     `plan_start_time` datetime DEFAULT NULL COMMENT '计划开始时间',
    903. 

  903.                                     `plan_end_time` datetime DEFAULT NULL COMMENT '计划截止时间',
    904. 

  904.                                     `role_id` bigint DEFAULT NULL COMMENT '角色id',
    905. 

  905.                                     `deleted` int DEFAULT '0' COMMENT '是否删除0否1是',
    906. 

  906.                                     `is_question` int DEFAULT NULL COMMENT '0:未整改 1:已开始整改',
    907. 

  907.                                     `batch_id` bigint DEFAULT NULL COMMENT '批次id,同一执行机构一个批次id',
    908. 

  908.                                     `source_type` int DEFAULT '0' COMMENT '数据来源 0：检查计划 ，1：登记检查结果',
    909. 

  909.                                     `pdf_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登记簿pdf 文件地址',
    910. 

  910.                                     `des` varchar(4000) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    911. 

  911.                                     PRIMARY KEY (`id`) USING BTREE,
    912. 

  912.                                     KEY `idx_resumption_orgId` (`org_id`) USING BTREE,
    913. 

  913.                                     KEY `idx_orgpath` (`org_path`(191)) USING BTREE
    914. 

  914. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
    915. 

  915. 

  916. 

  917. DELIMITER $$
    918. 

  918. CREATE PROCEDURE add_column_if_not_exists()
    919. 

  919. BEGIN
    920. 

  920.   IF NOT EXISTS (
    921. 

  921.       SELECT *
    922. 

  922.       FROM INFORMATION_SCHEMA.COLUMNS
    923. 

  923.       WHERE TABLE_NAME = 'core_safecheck_plan'
    924. 

  924.       AND COLUMN_NAME = 'distribute_status'
    925. 

  925.   )
    926. 

  926.   THEN
    927. 

  927. ALTER TABLE core_safecheck_plan
    928. 

  928.     ADD COLUMN distribute_status tinyint(1) COMMENT '下发状态';
    929. 

  929. END IF;
    930. 

  930. END$$
    931. 

  931. DELIMITER ;
    932. 

  932. 

  933. CALL add_column_if_not_exists();
    934. 

  934. DROP PROCEDURE add_column_if_not_exists;
    935. 

  935. 

  936. DELIMITER $$
    937. 

  937. CREATE PROCEDURE add_column_if_not_exists()
    938. 

  938. BEGIN
    939. 

  939.   IF NOT EXISTS (
    940. 

  940.       SELECT *
    941. 

  941.       FROM INFORMATION_SCHEMA.COLUMNS
    942. 

  942.       WHERE TABLE_NAME = 'core_safecheck_plan'
    943. 

  943.       AND COLUMN_NAME = 'distribute_plan_status'
    944. 

  944.   )
    945. 

  945.   THEN
    946. 

  946. ALTER TABLE core_safecheck_plan
    947. 

  947.     ADD COLUMN distribute_plan_status tinyint(1) COMMENT '计划下发默认状态';
    948. 

  948. END IF;
    949. 

  949. END$$
    950. 

  950. DELIMITER ;
    951. 

  951. 

  952. CALL add_column_if_not_exists();
    953. 

  953. DROP PROCEDURE add_column_if_not_exists;
    954. 

  954. DELIMITER $$
    955. 

  955. CREATE PROCEDURE add_column_if_not_exists()
    956. 

  956. BEGIN
    957. 

  957.   IF NOT EXISTS (
    958. 

  958.       SELECT *
    959. 

  959.       FROM INFORMATION_SCHEMA.COLUMNS
    960. 

  960.       WHERE TABLE_NAME = 'core_safecheck_plan'
    961. 

  961.       AND COLUMN_NAME = 'parent_id'
    962. 

  962.   )
    963. 

  963.   THEN
    964. 

  964. ALTER TABLE core_safecheck_plan
    965. 

  965.     ADD COLUMN parent_id tinyint(1) COMMENT '计划下发默认状态';
    966. 

  966. END IF;
    967. 

  967. END$$
    968. 

  968. DELIMITER ;
    969. 

  969. 

  970. CALL add_column_if_not_exists();
    971. 

  971. DROP PROCEDURE add_column_if_not_exists;
    972. 

  972. 

  973. /*
    974. 

  974.  Navicat Premium Data Transfer
    975. 

  975. 

  976.  Source Server         : 10.87.10.54
    977. 

  977.  Source Server Type    : MySQL
    978. 

  978.  Source Server Version : 80034
    979. 

  979.  Source Host           : 10.87.10.54:3306
    980. 

  980.  Source Schema         : soc
    981. 

  981. 

  982.  Target Server Type    : MySQL
    983. 

  983.  Target Server Version : 80034
    984. 

  984.  File Encoding         : 65001
    985. 

  985. 

  986.  Date: 25/09/2023 09:20:08
    987. 

  987. */
    988. 

  988. 

  989. SET NAMES utf8mb4;
    990. 

  990. SET FOREIGN_KEY_CHECKS = 0;
    991. 

  991. 

  992. -- ----------------------------
    993. 

  993. -- Table structure for core_safecheck_plan
    994. 

  994. -- ----------------------------
    995. 

  995. DROP TABLE IF EXISTS `core_safecheck_plan`;
    996. 

  996. CREATE TABLE `core_safecheck_plan`  (
    997. 

  997.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    998. 

  998.   `plan_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划名称',
    999. 

  999.   `plan_cycle` int NULL DEFAULT NULL COMMENT '计划周期：每日，每周，每月，每季度，每半年，每年 ,无周期',
    1000. 

  1000.   `exec_org_type` int NULL DEFAULT NULL COMMENT '检查机构类型',
    1001. 

  1001.   `check_org_type` int NULL DEFAULT NULL COMMENT '受检机构类型',
    1002. 

  1002.   `plan_status` int NULL DEFAULT NULL COMMENT '计划状态：0：启用，1禁用',
    1003. 

  1003.   `start_date` datetime NULL DEFAULT NULL COMMENT '开始日期',
    1004. 

  1004.   `end_date` datetime NULL DEFAULT NULL COMMENT '结束日期',
    1005. 

  1005.   `build_task_now` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '立即生成任务',
    1006. 

  1006.   `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    1007. 

  1007.   `is_deleted` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '\0' COMMENT '是否删除',
    1008. 

  1008.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1009. 

  1009.   `modified_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人名称',
    1010. 

  1010.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    1011. 

  1011.   `modified_by` bigint NULL DEFAULT NULL COMMENT '修改人id',
    1012. 

  1012.   `source_type` int NULL DEFAULT 0 COMMENT '数据来源 0：检查计划 ，1：登记检查结果',
    1013. 

  1013.   `plan_create_org_id` bigint NULL DEFAULT NULL COMMENT '计划创建机构id',
    1014. 

  1014.   `plan_of_org_id` bigint NULL DEFAULT NULL COMMENT '计划所属机构id',
    1015. 

  1015.   `check_type` int NULL DEFAULT NULL COMMENT '检查类型',
    1016. 

  1016.   `count` int NULL DEFAULT NULL COMMENT '检查次数',
    1017. 

  1017.   `modified_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    1018. 

  1018.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1019. 

  1019.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1020. 

  1020.   `exec_org` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查机构',
    1021. 

  1021.   `check_org` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '受检机构',
    1022. 

  1022.   `des` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    1023. 

  1023.   `distribute_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下发状态',
    1024. 

  1024.   `distribute_plan_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划下发默认状态',
    1025. 

  1025.   `parent_id` bigint NULL DEFAULT -1 COMMENT '下发父计划id',
    1026. 

  1026.   PRIMARY KEY (`id`) USING BTREE
    1027. 

  1027. ) ENGINE = InnoDB AUTO_INCREMENT = 1705420577829208067 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查计划表' ROW_FORMAT = Dynamic;
    1028. 

  1028. 

  1029. -- ----------------------------
    1030. 

  1030. -- Table structure for core_safecheck_plan_to_check_org
    1031. 

  1031. -- ----------------------------
    1032. 

  1032. DROP TABLE IF EXISTS `core_safecheck_plan_to_check_org`;
    1033. 

  1033. CREATE TABLE `core_safecheck_plan_to_check_org`  (
    1034. 

  1034.   `plan_id` bigint NOT NULL COMMENT '计划id',
    1035. 

  1035.   `org_id` bigint NOT NULL COMMENT '机构id',
    1036. 

  1036.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1037. 

  1037.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    1038. 

  1038.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1039. 

  1039.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
    1040. 

  1040. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查-受检机构关联表' ROW_FORMAT = Dynamic;
    1041. 

  1041. 

  1042. -- ----------------------------
    1043. 

  1043. -- Table structure for core_safecheck_plan_to_exec_org
    1044. 

  1044. -- ----------------------------
    1045. 

  1045. DROP TABLE IF EXISTS `core_safecheck_plan_to_exec_org`;
    1046. 

  1046. CREATE TABLE `core_safecheck_plan_to_exec_org`  (
    1047. 

  1047.   `plan_id` bigint NOT NULL COMMENT '计划id',
    1048. 

  1048.   `org_id` bigint NOT NULL COMMENT '机构id',
    1049. 

  1049.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1050. 

  1050.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    1051. 

  1051.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1052. 

  1052.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
    1053. 

  1053. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查-检查机构关系表' ROW_FORMAT = Dynamic;
    1054. 

  1054. 

  1055. -- ----------------------------
    1056. 

  1056. -- Table structure for core_safecheck_plan_to_point
    1057. 

  1057. -- ----------------------------
    1058. 

  1058. DROP TABLE IF EXISTS `core_safecheck_plan_to_point`;
    1059. 

  1059. CREATE TABLE `core_safecheck_plan_to_point`  (
    1060. 

  1060.   `plan_id` bigint NOT NULL COMMENT '计划id',
    1061. 

  1061.   `point_id` bigint NOT NULL COMMENT '检查要点id',
    1062. 

  1062.   `point_scan` tinyint(1) NULL DEFAULT NULL COMMENT '是否扫描NFC 1扫描，0不扫描',
    1063. 

  1063.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1064. 

  1064.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    1065. 

  1065.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1066. 

  1066.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1067. 

  1067.   `required` tinyint(1) NULL DEFAULT NULL
    1068. 

  1068. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查计划要点关联表' ROW_FORMAT = Dynamic;
    1069. 

  1069. 

  1070. -- ----------------------------
    1071. 

  1071. -- Table structure for core_safecheck_plan_to_role
    1072. 

  1072. -- ----------------------------
    1073. 

  1073. DROP TABLE IF EXISTS `core_safecheck_plan_to_role`;
    1074. 

  1074. CREATE TABLE `core_safecheck_plan_to_role`  (
    1075. 

  1075.   `plan_id` bigint NOT NULL COMMENT '计划id',
    1076. 

  1076.   `role_id` bigint NOT NULL COMMENT '角色id',
    1077. 

  1077.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    1078. 

  1078.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    1079. 

  1079.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1080. 

  1080.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
    1081. 

  1081. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查计划执行角色关联表' ROW_FORMAT = Dynamic;
    1082. 

  1082. 

  1083. -- ----------------------------
    1084. 

  1084. -- Table structure for core_safety_task
    1085. 

  1085. -- ----------------------------
    1086. 

  1086. DROP TABLE IF EXISTS `core_safety_task`;
    1087. 

  1087. CREATE TABLE `core_safety_task`  (
    1088. 

  1088.   `id` bigint NOT NULL,
    1089. 

  1089.   `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
    1090. 

  1090.   `exception_count` int NULL DEFAULT 0 COMMENT '异常数目',
    1091. 

  1091.   `org_id` bigint NULL DEFAULT 0 COMMENT '受检机构',
    1092. 

  1092.   `org_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '受检机构',
    1093. 

  1093.   `org_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '受检机构',
    1094. 

  1094.   `check_org_id` bigint NULL DEFAULT NULL COMMENT '执行检查机构',
    1095. 

  1095.   `check_org_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行检查机构',
    1096. 

  1096.   `status` int NULL DEFAULT NULL COMMENT '0待检查,1检查完成',
    1097. 

  1097.   `done_status` int NULL DEFAULT NULL COMMENT '0:代办,1:逾期,2:按时,3:补登',
    1098. 

  1098.   `check_type` int NULL DEFAULT NULL COMMENT '0 常规安全检查 1 专项安全检查',
    1099. 

  1099.   `check_cycle` int NULL DEFAULT 0 COMMENT '检查周期:0 无周期 1每日、2每周、3每月、4每季、5每半年、6每年',
    1100. 

  1100.   `ymd_date` date NULL DEFAULT NULL COMMENT '年月日',
    1101. 

  1101.   `ymd_day` int NULL DEFAULT NULL COMMENT '日',
    1102. 

  1102.   `ymd_month` int NULL DEFAULT NULL COMMENT '月',
    1103. 

  1103.   `ymd_quarter` int NULL DEFAULT NULL COMMENT '季',
    1104. 

  1104.   `ymd_week` int NULL DEFAULT NULL COMMENT '周',
    1105. 

  1105.   `ymd_year` int NULL DEFAULT NULL COMMENT '年',
    1106. 

  1106.   `ymd_halfyear` int NULL DEFAULT NULL COMMENT '半年',
    1107. 

  1107.   `submitor_id` bigint NULL DEFAULT NULL COMMENT '提交人id',
    1108. 

  1108.   `submit_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提交人',
    1109. 

  1109.   `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
    1110. 

  1110.   `plan_id` bigint NULL DEFAULT NULL COMMENT '计划id',
    1111. 

  1111.   `start_time` datetime NULL DEFAULT NULL COMMENT '任务执行开始时间',
    1112. 

  1112.   `end_time` datetime NULL DEFAULT NULL COMMENT '任务执行结束时间',
    1113. 

  1113.   `plan_start_time` datetime NULL DEFAULT NULL COMMENT '计划开始时间',
    1114. 

  1114.   `plan_end_time` datetime NULL DEFAULT NULL COMMENT '计划截止时间',
    1115. 

  1115.   `role_id` bigint NULL DEFAULT NULL COMMENT '角色id',
    1116. 

  1116.   `deleted` int NULL DEFAULT 0 COMMENT '是否删除0否1是',
    1117. 

  1117.   `is_question` int NULL DEFAULT NULL COMMENT '0:未整改 1:已开始整改',
    1118. 

  1118.   `batch_id` bigint NULL DEFAULT NULL COMMENT '批次id,同一执行机构一个批次id',
    1119. 

  1119.   `source_type` int NULL DEFAULT 0 COMMENT '数据来源 0：检查计划 ，1：登记检查结果',
    1120. 

  1120.   `pdf_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登记簿pdf 文件地址',
    1121. 

  1121.   `des` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    1122. 

  1122.   `check_team` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查组成员',
    1123. 

  1123.   `grant_user_id` bigint NULL DEFAULT NULL COMMENT '被授权的用户id',
    1124. 

  1124.   `create_time` datetime NULL DEFAULT NULL,
    1125. 

  1125.   `update_time` datetime NULL DEFAULT NULL,
    1126. 

  1126.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1127. 

  1127.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1128. 

  1128.   PRIMARY KEY (`id`) USING BTREE,
    1129. 

  1129.   INDEX `idx_resumption_orgId`(`org_id` ASC) USING BTREE,
    1130. 

  1130.   INDEX `idx_orgpath`(`org_path`(191) ASC) USING BTREE
    1131. 

  1131. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    1132. 

  1132. 

  1133. -- ----------------------------
    1134. 

  1134. -- Table structure for core_safety_task_data
    1135. 

  1135. -- ----------------------------
    1136. 

  1136. DROP TABLE IF EXISTS `core_safety_task_data`;
    1137. 

  1137. CREATE TABLE `core_safety_task_data`  (
    1138. 

  1138.   `id` bigint NOT NULL DEFAULT 0,
    1139. 

  1139.   `plan_id` bigint NULL DEFAULT NULL COMMENT '计划id',
    1140. 

  1140.   `item_id` bigint NULL DEFAULT NULL COMMENT '检查项id',
    1141. 

  1141.   `point_id` bigint NULL DEFAULT NULL COMMENT '要点id',
    1142. 

  1142.   `task_id` bigint NULL DEFAULT NULL COMMENT '检查任务id',
    1143. 

  1143.   `area_id` bigint NULL DEFAULT NULL COMMENT '区域id',
    1144. 

  1144.   `value` int NULL DEFAULT NULL COMMENT '正常不正常，通过不通过，合格不合格',
    1145. 

  1145.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题描述',
    1146. 

  1146.   `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
    1147. 

  1147.   `submit_by` bigint NULL DEFAULT NULL COMMENT '提交人id',
    1148. 

  1148.   `submit_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提交人名',
    1149. 

  1149.   `is_add` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为登记界面新增的。0：否，1：是',
    1150. 

  1150.   `rectification_deadline` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '整改期限字典值',
    1151. 

  1151.   PRIMARY KEY (`id`) USING BTREE,
    1152. 

  1152.   INDEX `item_id`(`point_id` ASC) USING BTREE,
    1153. 

  1153.   INDEX `check_task_id`(`task_id` ASC) USING BTREE
    1154. 

  1154. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查项表' ROW_FORMAT = Dynamic;
    1155. 

  1155. 

  1156. -- ----------------------------
    1157. 

  1157. -- Table structure for core_safety_task_data_nfc
    1158. 

  1158. -- ----------------------------
    1159. 

  1159. DROP TABLE IF EXISTS `core_safety_task_data_nfc`;
    1160. 

  1160. CREATE TABLE `core_safety_task_data_nfc`  (
    1161. 

  1161.   `id` bigint NOT NULL DEFAULT 0,
    1162. 

  1162.   `task_id` bigint NULL DEFAULT NULL COMMENT '检查任务id',
    1163. 

  1163.   `task_data_id` bigint NULL DEFAULT NULL COMMENT '安全检查项id',
    1164. 

  1164.   `nfc_id` bigint NOT NULL DEFAULT 0 COMMENT 'NFC id',
    1165. 

  1165.   `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
    1166. 

  1166.   `status` int NULL DEFAULT 0 COMMENT '状态0未扫1以扫',
    1167. 

  1167.   `point_id` bigint NULL DEFAULT NULL COMMENT '要点id',
    1168. 

  1168.   `scan_method` int NULL DEFAULT NULL COMMENT '0:扫描，1：拍照',
    1169. 

  1169.   `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拍照路径',
    1170. 

  1170.   PRIMARY KEY (`id`) USING BTREE,
    1171. 

  1171.   INDEX `task_id`(`task_id` ASC) USING BTREE
    1172. 

  1172. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查nfc扫描表' ROW_FORMAT = Dynamic;
    1173. 

  1173. 

  1174. -- ----------------------------
    1175. 

  1175. -- Table structure for core_safety_task_data_remarkimg
    1176. 

  1176. -- ----------------------------
    1177. 

  1177. DROP TABLE IF EXISTS `core_safety_task_data_remarkimg`;
    1178. 

  1178. CREATE TABLE `core_safety_task_data_remarkimg`  (
    1179. 

  1179.   `id` bigint NOT NULL DEFAULT 0,
    1180. 

  1180.   `task_id` bigint NULL DEFAULT NULL COMMENT '安全检查任务id',
    1181. 

  1181.   `task_data_id` bigint NULL DEFAULT NULL COMMENT '安全检查项id',
    1182. 

  1182.   `img_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片存放路径',
    1183. 

  1183.   PRIMARY KEY (`id`) USING BTREE
    1184. 

  1184. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查产生图片表' ROW_FORMAT = Dynamic;
    1185. 

  1185. 

  1186. -- ----------------------------
    1187. 

  1187. -- Table structure for core_safetycheck_rule
    1188. 

  1188. -- ----------------------------
    1189. 

  1189. DROP TABLE IF EXISTS `core_safetycheck_rule`;
    1190. 

  1190. CREATE TABLE `core_safetycheck_rule`  (
    1191. 

  1191.   `id` bigint NOT NULL AUTO_INCREMENT,
    1192. 

  1192.   `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '类型',
    1193. 

  1193.   `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
    1194. 

  1194.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '0:禁用 1:启用',
    1195. 

  1195.   `org_id` bigint NOT NULL COMMENT '发布机构',
    1196. 

  1196.   `org_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机构类型',
    1197. 

  1197.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注',
    1198. 

  1198.   `create_time` datetime NULL DEFAULT NULL,
    1199. 

  1199.   `update_time` datetime NULL DEFAULT NULL,
    1200. 

  1200.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1201. 

  1201.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1202. 

  1202.   `deleted` int NULL DEFAULT NULL COMMENT '0:未删除 、1：删除',
    1203. 

  1203.   PRIMARY KEY (`id`) USING BTREE
    1204. 

  1204. ) ENGINE = InnoDB AUTO_INCREMENT = 1701795990306471938 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '安全检查内容库定义\r\n' ROW_FORMAT = Dynamic;
    1205. 

  1205. 

  1206. -- ----------------------------
    1207. 

  1207. -- Table structure for core_safetycheck_rule_item
    1208. 

  1208. -- ----------------------------
    1209. 

  1209. DROP TABLE IF EXISTS `core_safetycheck_rule_item`;
    1210. 

  1210. CREATE TABLE `core_safetycheck_rule_item`  (
    1211. 

  1211.   `id` bigint NOT NULL AUTO_INCREMENT,
    1212. 

  1212.   `rule_id` bigint NOT NULL COMMENT '安全检查内容库定义id',
    1213. 

  1213.   `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查项名称',
    1214. 

  1214.   `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
    1215. 

  1215.   `create_time` datetime NULL DEFAULT NULL,
    1216. 

  1216.   `update_time` datetime NULL DEFAULT NULL,
    1217. 

  1217.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1218. 

  1218.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1219. 

  1219.   `deleted` int NULL DEFAULT NULL COMMENT '删除状态，0未删除，1已删除',
    1220. 

  1220.   PRIMARY KEY (`id`) USING BTREE
    1221. 

  1221. ) ENGINE = InnoDB AUTO_INCREMENT = 1705410983891484674 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查内容库-检查项' ROW_FORMAT = Dynamic;
    1222. 

  1222. 

  1223. -- ----------------------------
    1224. 

  1224. -- Table structure for core_safetycheck_rule_point
    1225. 

  1225. -- ----------------------------
    1226. 

  1226. DROP TABLE IF EXISTS `core_safetycheck_rule_point`;
    1227. 

  1227. CREATE TABLE `core_safetycheck_rule_point`  (
    1228. 

  1228.   `id` bigint NOT NULL AUTO_INCREMENT,
    1229. 

  1229.   `rule_id` bigint NOT NULL COMMENT '安全检查内容库定义id',
    1230. 

  1230.   `item_id` bigint NOT NULL COMMENT '检查项id',
    1231. 

  1231.   `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查内容',
    1232. 

  1232.   `area_id` bigint NOT NULL COMMENT '检查区域,区域表id',
    1233. 

  1233.   `business_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '要点关联的业务类型来源,要点业务类型,关联字典表code',
    1234. 

  1234.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    1235. 

  1235.   `deleted` int NULL DEFAULT NULL COMMENT '是否删除, 1是0否',
    1236. 

  1236.   `create_time` datetime NULL DEFAULT NULL,
    1237. 

  1237.   `update_time` datetime NULL DEFAULT NULL,
    1238. 

  1238.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1239. 

  1239.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1240. 

  1240.   PRIMARY KEY (`id`) USING BTREE
    1241. 

  1241. ) ENGINE = InnoDB AUTO_INCREMENT = 1705410983891484676 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查内容库-检查内容' ROW_FORMAT = Dynamic;
    1242. 

  1242. 

  1243. SET FOREIGN_KEY_CHECKS = 1;
    1244. 

  1244. 

  1245. DELETE from `sys_dict_type` WHERE dict_type='question_confirm_status' or dict_type='question_reform_status';
    1246. 

  1246. INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '问题确认状态', 'question_confirm_status', '0', '超级管理员', '2023-09-13 18:14:59', '', NULL, NULL);
    1247. 

  1247. INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '问题整改状态', 'question_reform_status', '0', '超级管理员', '2023-09-13 18:15:18', '', NULL, NULL);
    1248. 

  1248. 

  1249. DELETE from `sys_dict_data` WHERE dict_type in ('question_confirm_status','question_reform_status');
    1250. 

  1250. INSERT INTO `sys_dict_data` (`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 ( 0, '待确认', '0', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:15:44', '', NULL, NULL);
    1251. 

  1251. INSERT INTO `sys_dict_data` (`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 (1, '提出异议', '1', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:16:01', '', NULL, NULL);
    1252. 

  1252. INSERT INTO `sys_dict_data` (`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 ( 2, '已确认', '2', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:16:18', '', NULL, NULL);
    1253. 

  1253. INSERT INTO `sys_dict_data` (`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 ( 3, '已关闭', '3', 'question_confirm_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:16:30', '', NULL, NULL);
    1254. 

  1254. INSERT INTO `sys_dict_data` (`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 ( 0, '未整改', '10', 'question_reform_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:38', '', NULL, NULL);
    1255. 

  1255. INSERT INTO `sys_dict_data` (`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 ( 1, '已整改', '11', 'question_reform_status', NULL, 'default', 'N', '0', '超级管理员', '2023-09-13 18:17:47', '', NULL, NULL);
    1256.