Startsida Utforska Hjälp
Registrera dig Logga in
fjnx
/
soc
2
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: 845aa0075b
Grenar Taggar
soc
/
project_data
/
sql
/
0.0.2
/
soc
/
soc.sql

soc.sql 124 KB
Historik Rå

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187 
  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. END??
    125. 

  125. DELIMITER ;
    126. 

  126. CALL schema_change();
    127. 

  127. -- 新增演练任务推荐状态字典
    128. 

  128. delete from sys_dict_type where dict_type='drill_task_rec_status';
    129. 

  129. delete from sys_dict_data where dict_type='drill_task_rec_status';
    130. 

  130. 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);
    131. 

  131. 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);
    132. 

  132. 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);
    133. 

  133. 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);
    134. 

  134. 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);
    135. 

  135. 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);
    136. 

  136. 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);
    137. 

  137. -- 新增演练任务状态字典
    138. 

  138. delete from sys_dict_type where dict_type='drill_task_status';
    139. 

  139. delete from sys_dict_data where dict_type='drill_task_status';
    140. 

  140. 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);
    141. 

  141. 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);
    142. 

  142. 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);
    143. 

  143. 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);
    144. 

  144. 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);
    145. 

  145. 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);
    146. 

  146. 

  147. 

  148. -- 公告通知start
    149. 

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

  150. 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);
    151. 

  151. 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);
    152. 

  152. 

  153. delete from sys_dict_data where dict_type in('messag_type','message_status');
    154. 

  154. 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);
    155. 

  155. 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);
    156. 

  156. 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);
    157. 

  157. 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);
    158. 

  158. 

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

  160. INSERT INTO `sys_menu`( `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, '公告通知', 2168, 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', '');
    161. 

  161. INSERT INTO `sys_menu`( `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, '');
    162. 

  162. INSERT INTO `sys_menu`( `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, '');
    163. 

  163. INSERT INTO `sys_menu`( `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, '');
    164. 

  164. INSERT INTO `sys_menu`( `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, '');
    165. 

  165. INSERT INTO `sys_menu`( `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, '');
    166. 

  166. INSERT INTO `sys_menu`( `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, '');
    167. 

  167. 

  168. DROP TABLE IF EXISTS `core_announcement_notification`;
    169. 

  169. CREATE TABLE `core_announcement_notification`  (
    170. 

  170.    `id` bigint(0) NOT NULL,
    171. 

  171.    `org_id` bigint(0) NULL DEFAULT NULL COMMENT '机构',
    172. 

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

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

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

  175.    `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
    176. 

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

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

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

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

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

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

  182.    `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    183. 

  183.    `update_time` datetime(0) NULL DEFAULT NULL,
    184. 

  184.    `file_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文件',
    185. 

  185.    PRIMARY KEY (`id`) USING BTREE,
    186. 

  186.    INDEX `org_id_indx`(`org_id`) USING BTREE,
    187. 

  187.    INDEX `org_path_index`(`org_path`) USING BTREE
    188. 

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

  189. 

  190. DROP TABLE IF EXISTS `core_announcement_notification_to_org`;
    191. 

  191. CREATE TABLE `core_announcement_notification_to_org`  (
    192. 

  192. `announcement_notification_id` bigint(0) NOT NULL,
    193. 

  193. `org_id` bigint(0) NULL DEFAULT NULL,
    194. 

  194. INDEX `notification_id_index`(`announcement_notification_id`) USING BTREE,
    195. 

  195. INDEX `org_id_index`(`org_id`) USING BTREE
    196. 

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

  197. 

  198. -- ----------------------------
    199. 

  199. -- Table structure for core_announcement_notification_to_role
    200. 

  200. -- ----------------------------
    201. 

  201. DROP TABLE IF EXISTS `core_announcement_notification_to_role`;
    202. 

  202. CREATE TABLE `core_announcement_notification_to_role`  (
    203. 

  203. `announcement_notification_id` bigint(0) NOT NULL,
    204. 

  204. `role_id` bigint(0) NULL DEFAULT NULL,
    205. 

  205. INDEX `notification_id_index`(`announcement_notification_id`) USING BTREE,
    206. 

  206. INDEX `role_id_index`(`role_id`) USING BTREE
    207. 

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

  208. 

  209. DROP TABLE IF EXISTS `core_announcement_notification_to_user`;
    210. 

  210. CREATE TABLE `core_announcement_notification_to_user`  (
    211. 

  211. `id` bigint(0) NOT NULL,
    212. 

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

  213. `org_id` bigint(0) NULL DEFAULT NULL COMMENT '机构id',
    214. 

  214. `role_id` bigint(0) NULL DEFAULT NULL COMMENT '角色id',
    215. 

  215. `user_id` bigint(0) NULL DEFAULT NULL COMMENT '用户id',
    216. 

  216. PRIMARY KEY (`id`) USING BTREE,
    217. 

  217. INDEX `user_id_index`(`user_id`) USING BTREE,
    218. 

  218. INDEX `announcement_notification_id_index`(`announcement_notification_id`) USING BTREE
    219. 

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

  220. 

  221. -- 公告通知end
    222. 

  222. 

  223. 

  224. -- 天气预警start
    225. 

  225. delete from sys_menu where id=2166;
    226. 

  226. 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', '');
    227. 

  227. delete from sys_config where config_key='WEATHER_APP_CODE';
    228. 

  228. 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...0', 'N', '超级管理员', '2023-09-13 14:08:42', '超级管理员', '2023-09-13 14:38:32', '天气接口的appcode（请根据购买的api接口填写）');
    229. 

  229. DROP TABLE IF EXISTS `core_weather_warning`;
    230. 

  230. CREATE TABLE `core_weather_warning`  (
    231. 

  231.  `id` bigint(0) NOT NULL AUTO_INCREMENT,
    232. 

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

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

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

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

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

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

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

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

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

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

  242.  PRIMARY KEY (`id`) USING BTREE,
    243. 

  243.  INDEX `code`(`code`) USING BTREE
    244. 

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

  245. 

  246. DROP TABLE IF EXISTS `core_weather_city`;
    247. 

  247. CREATE TABLE `core_weather_city`  (
    248. 

  248.   `AREACODE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    249. 

  249.   `AREAID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    250. 

  250.   `NAMEEN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    251. 

  251.   `NAMECN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    252. 

  252.   `DISTRICTEN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    253. 

  253.   `DISTRICTCN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    254. 

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

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

  256.   `NATIONEN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    257. 

  257.   `NATIONCN` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    258. 

  258.   `GROUPID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
    259. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  356. 

  357. 

  358. -- 天气预警end
    359. 

  359. 

  360. -- Web演练库按钮及权限
    361. 

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

  362. 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, '');
    363. 

  363. 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, '');
    364. 

  364. 

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

  366. 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(), '');
    367. 

  367. 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, '');
    368. 

  368. 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, '');
    369. 

  369. 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, '');
    370. 

  370. 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, '');
    371. 

  371. 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, '');
    372. 

  372. 

  373. -- Web演练计划按钮及权限
    374. 

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

  375. 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(), '');
    376. 

  376. 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(), '');
    377. 

  377. 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, '');
    378. 

  378. 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(), '');
    379. 

  379. 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, '');
    380. 

  380. 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, '');
    381. 

  381. 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, '');
    382. 

  382. 

  383. -- Web演练任务按钮及权限
    384. 

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

  385. 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(), '');
    386. 

  386. 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, '');
    387. 

  387. 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, '');
    388. 

  388. 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, '');
    389. 

  389. 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, '');
    390. 

  390. 

  391. -- App端预案演练登记菜单目录
    392. 

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

  393. 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(), '');
    394. 

  394. 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(), '');
    395. 

  395. 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(), '');
    396. 

  396. 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(), '');
    397. 

  397. 

  398. -- 演练相关菜单权限
    399. 

  399. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2216);
    400. 

  400. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2217);
    401. 

  401. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2218);
    402. 

  402. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2220);
    403. 

  403. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2221);
    404. 

  404. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2222);
    405. 

  405. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2223);
    406. 

  406. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2224);
    407. 

  407. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2225);
    408. 

  408. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2226);
    409. 

  409. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2227);
    410. 

  410. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2228);
    411. 

  411. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2229);
    412. 

  412. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2311);
    413. 

  413. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2312);
    414. 

  414. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2313);
    415. 

  415. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2314);
    416. 

  416. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2315);
    417. 

  417. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2319);
    418. 

  418. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2320);
    419. 

  419. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2321);
    420. 

  420. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2322);
    421. 

  421. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (115, 2338);
    422. 

  422. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2216);
    423. 

  423. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2217);
    424. 

  424. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2218);
    425. 

  425. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2220);
    426. 

  426. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2221);
    427. 

  427. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2222);
    428. 

  428. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2223);
    429. 

  429. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2224);
    430. 

  430. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2225);
    431. 

  431. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2226);
    432. 

  432. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2227);
    433. 

  433. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2228);
    434. 

  434. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2229);
    435. 

  435. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2311);
    436. 

  436. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2312);
    437. 

  437. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2313);
    438. 

  438. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2314);
    439. 

  439. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2315);
    440. 

  440. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2319);
    441. 

  441. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2320);
    442. 

  442. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2321);
    443. 

  443. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2322);
    444. 

  444. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (116, 2338);
    445. 

  445. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2216);
    446. 

  446. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2218);
    447. 

  447. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2220);
    448. 

  448. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2221);
    449. 

  449. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2222);
    450. 

  450. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2223);
    451. 

  451. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2224);
    452. 

  452. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2225);
    453. 

  453. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2226);
    454. 

  454. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2227);
    455. 

  455. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2228);
    456. 

  456. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2229);
    457. 

  457. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2311);
    458. 

  458. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2312);
    459. 

  459. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2313);
    460. 

  460. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2314);
    461. 

  461. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2315);
    462. 

  462. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2319);
    463. 

  463. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2320);
    464. 

  464. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2321);
    465. 

  465. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2322);
    466. 

  466. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (117, 2338);
    467. 

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

  468. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2218);
    469. 

  469. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2220);
    470. 

  470. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2221);
    471. 

  471. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2222);
    472. 

  472. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2223);
    473. 

  473. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2224);
    474. 

  474. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2225);
    475. 

  475. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2226);
    476. 

  476. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2227);
    477. 

  477. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2228);
    478. 

  478. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2229);
    479. 

  479. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2311);
    480. 

  480. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2312);
    481. 

  481. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2313);
    482. 

  482. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2314);
    483. 

  483. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2315);
    484. 

  484. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2319);
    485. 

  485. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2320);
    486. 

  486. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2321);
    487. 

  487. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2322);
    488. 

  488. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (118, 2338);
    489. 

  489. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (119, 2215);
    490. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  513. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2215);
    514. 

  514. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2216);
    515. 

  515. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2217);
    516. 

  516. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2218);
    517. 

  517. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2220);
    518. 

  518. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2221);
    519. 

  519. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2222);
    520. 

  520. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2223);
    521. 

  521. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2224);
    522. 

  522. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2225);
    523. 

  523. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2226);
    524. 

  524. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2227);
    525. 

  525. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2228);
    526. 

  526. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2229);
    527. 

  527. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2311);
    528. 

  528. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2312);
    529. 

  529. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2313);
    530. 

  530. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2314);
    531. 

  531. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2315);
    532. 

  532. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2319);
    533. 

  533. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2320);
    534. 

  534. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2321);
    535. 

  535. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2322);
    536. 

  536. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (120, 2338);
    537. 

  537. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2216);
    538. 

  538. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2217);
    539. 

  539. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2220);
    540. 

  540. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2221);
    541. 

  541. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2222);
    542. 

  542. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2223);
    543. 

  543. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2224);
    544. 

  544. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2225);
    545. 

  545. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2226);
    546. 

  546. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2228);
    547. 

  547. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2229);
    548. 

  548. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2311);
    549. 

  549. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2312);
    550. 

  550. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2315);
    551. 

  551. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2319);
    552. 

  552. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2320);
    553. 

  553. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2321);
    554. 

  554. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2322);
    555. 

  555. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (121, 2338);
    556. 

  556. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2215);
    557. 

  557. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2216);
    558. 

  558. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2217);
    559. 

  559. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2220);
    560. 

  560. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2221);
    561. 

  561. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2222);
    562. 

  562. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2223);
    563. 

  563. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2224);
    564. 

  564. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2225);
    565. 

  565. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2226);
    566. 

  566. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2227);
    567. 

  567. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2228);
    568. 

  568. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2229);
    569. 

  569. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2311);
    570. 

  570. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2312);
    571. 

  571. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2315);
    572. 

  572. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2319);
    573. 

  573. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2320);
    574. 

  574. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2321);
    575. 

  575. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2322);
    576. 

  576. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (122, 2338);
    577. 

  577. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2215);
    578. 

  578. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2216);
    579. 

  579. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2217);
    580. 

  580. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2220);
    581. 

  581. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2221);
    582. 

  582. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2222);
    583. 

  583. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2223);
    584. 

  584. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2224);
    585. 

  585. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2225);
    586. 

  586. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2226);
    587. 

  587. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2227);
    588. 

  588. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2228);
    589. 

  589. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2229);
    590. 

  590. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2311);
    591. 

  591. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2312);
    592. 

  592. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2315);
    593. 

  593. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2319);
    594. 

  594. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2320);
    595. 

  595. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2321);
    596. 

  596. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2322);
    597. 

  597. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (128, 2338);
    598. 

  598. 

  599. 

  600. 

  601. -- 检查任务表
    602. 

  602. DROP TABLE IF EXISTS `core_safety_task`;
    603. 

  603. CREATE TABLE `core_safety_task` (
    604. 

  604.                                     `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    605. 

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

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

  607.                                     `modified_id` bigint DEFAULT NULL COMMENT '最后修改人id',
    608. 

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

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

  610.                                     `exception_count` int DEFAULT '0' COMMENT '异常数目',
    611. 

  611.                                     `org_id` bigint DEFAULT '0' COMMENT '受检机构',
    612. 

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

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

  614.                                     `check_org_id` bigint DEFAULT NULL COMMENT '执行检查机构',
    615. 

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

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

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

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

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

  620.                                     `ymd_date` date DEFAULT NULL COMMENT '年月日',
    621. 

  621.                                     `ymd_day` int DEFAULT NULL COMMENT '日',
    622. 

  622.                                     `ymd_month` int DEFAULT NULL COMMENT '月',
    623. 

  623.                                     `ymd_quarter` int DEFAULT NULL COMMENT '季',
    624. 

  624.                                     `ymd_week` int DEFAULT NULL COMMENT '周',
    625. 

  625.                                     `ymd_year` int DEFAULT NULL COMMENT '年',
    626. 

  626.                                     `ymd_halfyear` int DEFAULT NULL COMMENT '半年',
    627. 

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

  628.                                     `submit_time` datetime DEFAULT NULL COMMENT '提交时间',
    629. 

  629.                                     `plan_id` bigint DEFAULT NULL COMMENT '计划id',
    630. 

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

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

  632.                                     `plan_start_time` datetime DEFAULT NULL COMMENT '计划开始时间',
    633. 

  633.                                     `plan_end_time` datetime DEFAULT NULL COMMENT '计划截止时间',
    634. 

  634.                                     `role_id` bigint DEFAULT NULL COMMENT '角色id',
    635. 

  635.                                     `deleted` int DEFAULT '0' COMMENT '是否删除0否1是',
    636. 

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

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

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

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

  640.                                     PRIMARY KEY (`id`) USING BTREE,
    641. 

  641.                                     KEY `idx_resumption_orgId` (`org_id`) USING BTREE,
    642. 

  642.                                     KEY `idx_orgpath` (`org_path`(191)) USING BTREE
    643. 

  643. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
    644. 

  644. 

  645. DROP TABLE IF EXISTS `core_safety_task_data`;
    646. 

  646. CREATE TABLE `core_safety_task_data` (
    647. 

  647.                                          `id` bigint NOT NULL DEFAULT '0',
    648. 

  648.                                          `plan_id` bigint DEFAULT NULL COMMENT '计划id',
    649. 

  649.                                          `item_id` bigint DEFAULT NULL COMMENT '检查项id',
    650. 

  650.                                          `point_id` bigint DEFAULT NULL COMMENT '要点id',
    651. 

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

  652.                                          `area_id` bigint DEFAULT NULL COMMENT '区域id',
    653. 

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

  654.                                          `reform_type` int DEFAULT NULL COMMENT '整改类型',
    655. 

  655.                                          `res_time` datetime DEFAULT NULL COMMENT '时分',
    656. 

  656.                                          `submit_time` datetime DEFAULT NULL COMMENT '提交时间',
    657. 

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

  658.                                          `submit_by` bigint DEFAULT NULL COMMENT '提交人id',
    659. 

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

  660.                                          PRIMARY KEY (`id`) USING BTREE,
    661. 

  661.                                          KEY `item_id` (`point_id`) USING BTREE,
    662. 

  662.                                          KEY `check_task_id` (`task_id`) USING BTREE
    663. 

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

  664. 

  665. 

  666. DROP TABLE IF EXISTS `core_resumption_configuration`;
    667. 

  667. CREATE TABLE `core_resumption_configuration` (
    668. 

  668.                                                  `id` bigint NOT NULL COMMENT '主键',
    669. 

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

  670.                                                  `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    671. 

  671.                                                  `create_time` datetime DEFAULT NULL,
    672. 

  672.                                                  `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    673. 

  673.                                                  `update_time` datetime DEFAULT NULL,
    674. 

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

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

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

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

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

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

  680.                                                  PRIMARY KEY (`id`) USING BTREE
    681. 

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

  682. DROP TABLE IF EXISTS `core_safety_task_data_nfc`;
    683. 

  683. CREATE TABLE `core_safety_task_data_nfc` (
    684. 

  684.                                              `id` bigint NOT NULL DEFAULT '0',
    685. 

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

  686.                                              `task_data_id` bigint DEFAULT NULL COMMENT '安全检查项id',
    687. 

  687.                                              `check_id` bigint NOT NULL DEFAULT '0' COMMENT '采集点id',
    688. 

  688.                                              `submit_time` datetime DEFAULT NULL COMMENT '提交时间',
    689. 

  689.                                              `status` int DEFAULT '0' COMMENT '状态0未扫1以扫',
    690. 

  690.                                              `point_id` bigint DEFAULT NULL COMMENT '要点id',
    691. 

  691.                                              PRIMARY KEY (`id`) USING BTREE,
    692. 

  692.                                              KEY `task_id` (`task_id`) USING BTREE
    693. 

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

  694. 

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

  696. 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);
    697. 

  697. 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);
    698. 

  698. 

  699. -- ----------------------------
    700. 

  700. -- Table structure for core_message_send
    701. 

  701. -- ----------------------------
    702. 

  702. DROP TABLE IF EXISTS `core_message_send`;
    703. 

  703. CREATE TABLE `core_message_send` (
    704. 

  704.                                      `id` bigint NOT NULL COMMENT '主键',
    705. 

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

  706.                                      `type` varchar(2) COLLATE utf8mb4_general_ci DEFAULT NULL,
    707. 

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

  708.                                      `send_user` bigint DEFAULT NULL COMMENT '按用户选择',
    709. 

  709.                                      `send_role` bigint DEFAULT NULL COMMENT '按角色选择',
    710. 

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

  711.                                      `send_time` datetime DEFAULT NULL COMMENT '发送时间',
    712. 

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

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

  714.                                      `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    715. 

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

  716.                                      `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    717. 

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

  718.                                      PRIMARY KEY (`id`)
    719. 

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

  720. -- 消息发送配置end
    721. 

  721. 

  722. -- ----------------------------
    723. 

  723. -- Table structure for core_message_center
    724. 

  724. -- ----------------------------
    725. 

  725. DROP TABLE IF EXISTS `core_message_center`;
    726. 

  726. CREATE TABLE `core_message_center` (
    727. 

  727.                                        `id` bigint NOT NULL,
    728. 

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

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

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

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

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

  733.                                        `user_id` bigint DEFAULT NULL COMMENT '用户',
    734. 

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

  735.                                        `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    736. 

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

  737.                                        `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    738. 

  738.                                        PRIMARY KEY (`id`)
    739. 

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

  740. 

  741. DROP TABLE IF EXISTS `core_safety_task_data_remark`;
    742. 

  742. CREATE TABLE `core_safety_task_data_remark` (
    743. 

  743.                                                 `id` bigint NOT NULL DEFAULT '0',
    744. 

  744.                                                 `task_data_id` bigint DEFAULT NULL COMMENT '检查项id',
    745. 

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

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

  747.                                                 PRIMARY KEY (`id`) USING BTREE,
    748. 

  748.                                                 KEY `task_item_id` (`task_data_id`) USING BTREE
    749. 

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

  750. 

  751. DROP TABLE IF EXISTS `core_safety_task_data_remarkimg`;
    752. 

  752. CREATE TABLE `core_safety_task_data_remarkimg` (
    753. 

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

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

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

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

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

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

  759.                                                    KEY `data_id` (`remark_id`) USING BTREE
    760. 

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

  761. 

  762. -- 调整core_safecheck_plan字段
    763. 

  763. -- 调整安全检查字段
    764. 

  764. DELIMITER $$
    765. 

  765. CREATE PROCEDURE add_column_if_not_exists()
    766. 

  766. BEGIN
    767. 

  767.   IF NOT EXISTS (
    768. 

  768.       SELECT *
    769. 

  769.       FROM INFORMATION_SCHEMA.COLUMNS
    770. 

  770.       WHERE TABLE_NAME = 'core_safety_task'
    771. 

  771.       AND COLUMN_NAME = 'des'
    772. 

  772.   )
    773. 

  773.   THEN
    774. 

  774. ALTER TABLE core_safety_task
    775. 

  775.     ADD COLUMN des VARCHAR(4000) COMMENT '备注';
    776. 

  776. END IF;
    777. 

  777. END$$
    778. 

  778. DELIMITER ;
    779. 

  779. 

  780. CALL add_column_if_not_exists();
    781. 

  781. DROP PROCEDURE add_column_if_not_exists;
    782. 

  782. 

  783. 

  784. 

  785. DELIMITER $$
    786. 

  786. CREATE PROCEDURE add_column_if_not_exists()
    787. 

  787. BEGIN
    788. 

  788.   IF NOT EXISTS (
    789. 

  789.       SELECT *
    790. 

  790.       FROM INFORMATION_SCHEMA.COLUMNS
    791. 

  791.       WHERE TABLE_NAME = 'core_safecheck_plan_to_point'
    792. 

  792.       AND COLUMN_NAME = 'required'
    793. 

  793.   )
    794. 

  794.   THEN
    795. 

  795. ALTER TABLE core_safecheck_plan_to_point
    796. 

  796.     ADD COLUMN required tinyint(1) COMMENT '是否必检';
    797. 

  797. END IF;
    798. 

  798. END$$
    799. 

  799. DELIMITER ;
    800. 

  800. 

  801. CALL add_column_if_not_exists();
    802. 

  802. DROP PROCEDURE add_column_if_not_exists;
    803. 

  803. 

  804. DROP TABLE IF EXISTS `core_safety_task`;
    805. 

  805. CREATE TABLE `core_safety_task` (
    806. 

  806.                                     `id` bigint NOT NULL,
    807. 

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

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

  809.                                     `modified_id` bigint DEFAULT NULL COMMENT '最后修改人id',
    810. 

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

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

  812.                                     `exception_count` int DEFAULT '0' COMMENT '异常数目',
    813. 

  813.                                     `org_id` bigint DEFAULT '0' COMMENT '受检机构',
    814. 

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

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

  816.                                     `check_org_id` bigint DEFAULT NULL COMMENT '执行检查机构',
    817. 

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

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

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

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

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

  822.                                     `ymd_date` date DEFAULT NULL COMMENT '年月日',
    823. 

  823.                                     `ymd_day` int DEFAULT NULL COMMENT '日',
    824. 

  824.                                     `ymd_month` int DEFAULT NULL COMMENT '月',
    825. 

  825.                                     `ymd_quarter` int DEFAULT NULL COMMENT '季',
    826. 

  826.                                     `ymd_week` int DEFAULT NULL COMMENT '周',
    827. 

  827.                                     `ymd_year` int DEFAULT NULL COMMENT '年',
    828. 

  828.                                     `ymd_halfyear` int DEFAULT NULL COMMENT '半年',
    829. 

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

  830.                                     `submit_time` datetime DEFAULT NULL COMMENT '提交时间',
    831. 

  831.                                     `plan_id` bigint DEFAULT NULL COMMENT '计划id',
    832. 

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

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

  834.                                     `plan_start_time` datetime DEFAULT NULL COMMENT '计划开始时间',
    835. 

  835.                                     `plan_end_time` datetime DEFAULT NULL COMMENT '计划截止时间',
    836. 

  836.                                     `role_id` bigint DEFAULT NULL COMMENT '角色id',
    837. 

  837.                                     `deleted` int DEFAULT '0' COMMENT '是否删除0否1是',
    838. 

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

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

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

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

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

  843.                                     PRIMARY KEY (`id`) USING BTREE,
    844. 

  844.                                     KEY `idx_resumption_orgId` (`org_id`) USING BTREE,
    845. 

  845.                                     KEY `idx_orgpath` (`org_path`(191)) USING BTREE
    846. 

  846. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
    847. 

  847. 

  848. 

  849. DELIMITER $$
    850. 

  850. CREATE PROCEDURE add_column_if_not_exists()
    851. 

  851. BEGIN
    852. 

  852.   IF NOT EXISTS (
    853. 

  853.       SELECT *
    854. 

  854.       FROM INFORMATION_SCHEMA.COLUMNS
    855. 

  855.       WHERE TABLE_NAME = 'core_safecheck_plan'
    856. 

  856.       AND COLUMN_NAME = 'distribute_status'
    857. 

  857.   )
    858. 

  858.   THEN
    859. 

  859. ALTER TABLE core_safecheck_plan
    860. 

  860.     ADD COLUMN distribute_status tinyint(1) COMMENT '下发状态';
    861. 

  861. END IF;
    862. 

  862. END$$
    863. 

  863. DELIMITER ;
    864. 

  864. 

  865. CALL add_column_if_not_exists();
    866. 

  866. DROP PROCEDURE add_column_if_not_exists;
    867. 

  867. 

  868. DELIMITER $$
    869. 

  869. CREATE PROCEDURE add_column_if_not_exists()
    870. 

  870. BEGIN
    871. 

  871.   IF NOT EXISTS (
    872. 

  872.       SELECT *
    873. 

  873.       FROM INFORMATION_SCHEMA.COLUMNS
    874. 

  874.       WHERE TABLE_NAME = 'core_safecheck_plan'
    875. 

  875.       AND COLUMN_NAME = 'distribute_plan_status'
    876. 

  876.   )
    877. 

  877.   THEN
    878. 

  878. ALTER TABLE core_safecheck_plan
    879. 

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

  880. END IF;
    881. 

  881. END$$
    882. 

  882. DELIMITER ;
    883. 

  883. 

  884. CALL add_column_if_not_exists();
    885. 

  885. DROP PROCEDURE add_column_if_not_exists;
    886. 

  886. DELIMITER $$
    887. 

  887. CREATE PROCEDURE add_column_if_not_exists()
    888. 

  888. BEGIN
    889. 

  889.   IF NOT EXISTS (
    890. 

  890.       SELECT *
    891. 

  891.       FROM INFORMATION_SCHEMA.COLUMNS
    892. 

  892.       WHERE TABLE_NAME = 'core_safecheck_plan'
    893. 

  893.       AND COLUMN_NAME = 'parent_id'
    894. 

  894.   )
    895. 

  895.   THEN
    896. 

  896. ALTER TABLE core_safecheck_plan
    897. 

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

  898. END IF;
    899. 

  899. END$$
    900. 

  900. DELIMITER ;
    901. 

  901. 

  902. CALL add_column_if_not_exists();
    903. 

  903. DROP PROCEDURE add_column_if_not_exists;
    904. 

  904. 

  905. /*
    906. 

  906.  Navicat Premium Data Transfer
    907. 

  907. 

  908.  Source Server         : 10.87.10.54
    909. 

  909.  Source Server Type    : MySQL
    910. 

  910.  Source Server Version : 80034
    911. 

  911.  Source Host           : 10.87.10.54:3306
    912. 

  912.  Source Schema         : soc
    913. 

  913. 

  914.  Target Server Type    : MySQL
    915. 

  915.  Target Server Version : 80034
    916. 

  916.  File Encoding         : 65001
    917. 

  917. 

  918.  Date: 25/09/2023 09:20:08
    919. 

  919. */
    920. 

  920. 

  921. SET NAMES utf8mb4;
    922. 

  922. SET FOREIGN_KEY_CHECKS = 0;
    923. 

  923. 

  924. -- ----------------------------
    925. 

  925. -- Table structure for core_safecheck_plan
    926. 

  926. -- ----------------------------
    927. 

  927. DROP TABLE IF EXISTS `core_safecheck_plan`;
    928. 

  928. CREATE TABLE `core_safecheck_plan`  (
    929. 

  929.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    930. 

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

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

  932.   `exec_org_type` int NULL DEFAULT NULL COMMENT '检查机构类型',
    933. 

  933.   `check_org_type` int NULL DEFAULT NULL COMMENT '受检机构类型',
    934. 

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

  935.   `start_date` datetime NULL DEFAULT NULL COMMENT '开始日期',
    936. 

  936.   `end_date` datetime NULL DEFAULT NULL COMMENT '结束日期',
    937. 

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

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

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

  940.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    941. 

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

  942.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    943. 

  943.   `modified_by` bigint NULL DEFAULT NULL COMMENT '修改人id',
    944. 

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

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

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

  947.   `check_type` int NULL DEFAULT NULL COMMENT '检查类型',
    948. 

  948.   `count` int NULL DEFAULT NULL COMMENT '检查次数',
    949. 

  949.   `modified_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    950. 

  950.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    951. 

  951.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    952. 

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

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

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

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

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

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

  958.   PRIMARY KEY (`id`) USING BTREE
    959. 

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

  960. 

  961. -- ----------------------------
    962. 

  962. -- Table structure for core_safecheck_plan_to_check_org
    963. 

  963. -- ----------------------------
    964. 

  964. DROP TABLE IF EXISTS `core_safecheck_plan_to_check_org`;
    965. 

  965. CREATE TABLE `core_safecheck_plan_to_check_org`  (
    966. 

  966.   `plan_id` bigint NOT NULL COMMENT '计划id',
    967. 

  967.   `org_id` bigint NOT NULL COMMENT '机构id',
    968. 

  968.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    969. 

  969.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    970. 

  970.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    971. 

  971.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
    972. 

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

  973. 

  974. -- ----------------------------
    975. 

  975. -- Table structure for core_safecheck_plan_to_exec_org
    976. 

  976. -- ----------------------------
    977. 

  977. DROP TABLE IF EXISTS `core_safecheck_plan_to_exec_org`;
    978. 

  978. CREATE TABLE `core_safecheck_plan_to_exec_org`  (
    979. 

  979.   `plan_id` bigint NOT NULL COMMENT '计划id',
    980. 

  980.   `org_id` bigint NOT NULL COMMENT '机构id',
    981. 

  981.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    982. 

  982.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    983. 

  983.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    984. 

  984.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
    985. 

  985. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查-检查机构关系表' ROW_FORMAT = Dynamic;
    986. 

  986. 

  987. -- ----------------------------
    988. 

  988. -- Table structure for core_safecheck_plan_to_point
    989. 

  989. -- ----------------------------
    990. 

  990. DROP TABLE IF EXISTS `core_safecheck_plan_to_point`;
    991. 

  991. CREATE TABLE `core_safecheck_plan_to_point`  (
    992. 

  992.   `plan_id` bigint NOT NULL COMMENT '计划id',
    993. 

  993.   `point_id` bigint NOT NULL COMMENT '检查要点id',
    994. 

  994.   `point_scan` tinyint(1) NULL DEFAULT NULL COMMENT '是否扫描NFC 1扫描，0不扫描',
    995. 

  995.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    996. 

  996.   `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    997. 

  997.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    998. 

  998.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    999. 

  999.   `required` tinyint(1) NULL DEFAULT NULL
    1000. 

  1000. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查计划要点关联表' ROW_FORMAT = Dynamic;
    1001. 

  1001. 

  1002. -- ----------------------------
    1003. 

  1003. -- Table structure for core_safecheck_plan_to_role
    1004. 

  1004. -- ----------------------------
    1005. 

  1005. DROP TABLE IF EXISTS `core_safecheck_plan_to_role`;
    1006. 

  1006. CREATE TABLE `core_safecheck_plan_to_role`  (
    1007. 

  1007.   `plan_id` bigint NOT NULL COMMENT '计划id',
    1008. 

  1008.   `role_id` bigint NOT NULL COMMENT '角色id',
    1009. 

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

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

  1011.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1012. 

  1012.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
    1013. 

  1013. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规安全检查计划执行角色关联表' ROW_FORMAT = Dynamic;
    1014. 

  1014. 

  1015. -- ----------------------------
    1016. 

  1016. -- Table structure for core_safety_task
    1017. 

  1017. -- ----------------------------
    1018. 

  1018. DROP TABLE IF EXISTS `core_safety_task`;
    1019. 

  1019. CREATE TABLE `core_safety_task`  (
    1020. 

  1020.   `id` bigint NOT NULL,
    1021. 

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

  1022.   `exception_count` int NULL DEFAULT 0 COMMENT '异常数目',
    1023. 

  1023.   `org_id` bigint NULL DEFAULT 0 COMMENT '受检机构',
    1024. 

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

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

  1026.   `check_org_id` bigint NULL DEFAULT NULL COMMENT '执行检查机构',
    1027. 

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

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

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

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

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

  1032.   `ymd_date` date NULL DEFAULT NULL COMMENT '年月日',
    1033. 

  1033.   `ymd_day` int NULL DEFAULT NULL COMMENT '日',
    1034. 

  1034.   `ymd_month` int NULL DEFAULT NULL COMMENT '月',
    1035. 

  1035.   `ymd_quarter` int NULL DEFAULT NULL COMMENT '季',
    1036. 

  1036.   `ymd_week` int NULL DEFAULT NULL COMMENT '周',
    1037. 

  1037.   `ymd_year` int NULL DEFAULT NULL COMMENT '年',
    1038. 

  1038.   `ymd_halfyear` int NULL DEFAULT NULL COMMENT '半年',
    1039. 

  1039.   `submitor_id` bigint NULL DEFAULT NULL COMMENT '提交人id',
    1040. 

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

  1041.   `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
    1042. 

  1042.   `plan_id` bigint NULL DEFAULT NULL COMMENT '计划id',
    1043. 

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

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

  1045.   `plan_start_time` datetime NULL DEFAULT NULL COMMENT '计划开始时间',
    1046. 

  1046.   `plan_end_time` datetime NULL DEFAULT NULL COMMENT '计划截止时间',
    1047. 

  1047.   `role_id` bigint NULL DEFAULT NULL COMMENT '角色id',
    1048. 

  1048.   `deleted` int NULL DEFAULT 0 COMMENT '是否删除0否1是',
    1049. 

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

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

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

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

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

  1054.   `check_team` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查组成员',
    1055. 

  1055.   `grant_user_id` bigint NULL DEFAULT NULL COMMENT '被授权的用户id',
    1056. 

  1056.   `create_time` datetime NULL DEFAULT NULL,
    1057. 

  1057.   `update_time` datetime NULL DEFAULT NULL,
    1058. 

  1058.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1059. 

  1059.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1060. 

  1060.   PRIMARY KEY (`id`) USING BTREE,
    1061. 

  1061.   INDEX `idx_resumption_orgId`(`org_id` ASC) USING BTREE,
    1062. 

  1062.   INDEX `idx_orgpath`(`org_path`(191) ASC) USING BTREE
    1063. 

  1063. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    1064. 

  1064. 

  1065. -- ----------------------------
    1066. 

  1066. -- Table structure for core_safety_task_data
    1067. 

  1067. -- ----------------------------
    1068. 

  1068. DROP TABLE IF EXISTS `core_safety_task_data`;
    1069. 

  1069. CREATE TABLE `core_safety_task_data`  (
    1070. 

  1070.   `id` bigint NOT NULL DEFAULT 0,
    1071. 

  1071.   `plan_id` bigint NULL DEFAULT NULL COMMENT '计划id',
    1072. 

  1072.   `item_id` bigint NULL DEFAULT NULL COMMENT '检查项id',
    1073. 

  1073.   `point_id` bigint NULL DEFAULT NULL COMMENT '要点id',
    1074. 

  1074.   `task_id` bigint NULL DEFAULT NULL COMMENT '检查任务id',
    1075. 

  1075.   `area_id` bigint NULL DEFAULT NULL COMMENT '区域id',
    1076. 

  1076.   `value` int NULL DEFAULT NULL COMMENT '正常不正常，通过不通过，合格不合格',
    1077. 

  1077.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '问题描述',
    1078. 

  1078.   `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
    1079. 

  1079.   `submit_by` bigint NULL DEFAULT NULL COMMENT '提交人id',
    1080. 

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

  1081.   `is_add` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为登记界面新增的。0：否，1：是',
    1082. 

  1082.   `rectification_deadline` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '整改期限字典值',
    1083. 

  1083.   PRIMARY KEY (`id`) USING BTREE,
    1084. 

  1084.   INDEX `item_id`(`point_id` ASC) USING BTREE,
    1085. 

  1085.   INDEX `check_task_id`(`task_id` ASC) USING BTREE
    1086. 

  1086. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查项表' ROW_FORMAT = Dynamic;
    1087. 

  1087. 

  1088. -- ----------------------------
    1089. 

  1089. -- Table structure for core_safety_task_data_nfc
    1090. 

  1090. -- ----------------------------
    1091. 

  1091. DROP TABLE IF EXISTS `core_safety_task_data_nfc`;
    1092. 

  1092. CREATE TABLE `core_safety_task_data_nfc`  (
    1093. 

  1093.   `id` bigint NOT NULL DEFAULT 0,
    1094. 

  1094.   `task_id` bigint NULL DEFAULT NULL COMMENT '检查任务id',
    1095. 

  1095.   `task_data_id` bigint NULL DEFAULT NULL COMMENT '安全检查项id',
    1096. 

  1096.   `nfc_id` bigint NOT NULL DEFAULT 0 COMMENT 'NFC id',
    1097. 

  1097.   `submit_time` datetime NULL DEFAULT NULL COMMENT '提交时间',
    1098. 

  1098.   `status` int NULL DEFAULT 0 COMMENT '状态0未扫1以扫',
    1099. 

  1099.   `point_id` bigint NULL DEFAULT NULL COMMENT '要点id',
    1100. 

  1100.   `scan_method` int NULL DEFAULT NULL COMMENT '0:扫描，1：拍照',
    1101. 

  1101.   `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拍照路径',
    1102. 

  1102.   PRIMARY KEY (`id`) USING BTREE,
    1103. 

  1103.   INDEX `task_id`(`task_id` ASC) USING BTREE
    1104. 

  1104. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查nfc扫描表' ROW_FORMAT = Dynamic;
    1105. 

  1105. 

  1106. -- ----------------------------
    1107. 

  1107. -- Table structure for core_safety_task_data_remarkimg
    1108. 

  1108. -- ----------------------------
    1109. 

  1109. DROP TABLE IF EXISTS `core_safety_task_data_remarkimg`;
    1110. 

  1110. CREATE TABLE `core_safety_task_data_remarkimg`  (
    1111. 

  1111.   `id` bigint NOT NULL DEFAULT 0,
    1112. 

  1112.   `task_id` bigint NULL DEFAULT NULL COMMENT '安全检查任务id',
    1113. 

  1113.   `task_data_id` bigint NULL DEFAULT NULL COMMENT '安全检查项id',
    1114. 

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

  1115.   PRIMARY KEY (`id`) USING BTREE
    1116. 

  1116. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查产生图片表' ROW_FORMAT = Dynamic;
    1117. 

  1117. 

  1118. -- ----------------------------
    1119. 

  1119. -- Table structure for core_safetycheck_rule
    1120. 

  1120. -- ----------------------------
    1121. 

  1121. DROP TABLE IF EXISTS `core_safetycheck_rule`;
    1122. 

  1122. CREATE TABLE `core_safetycheck_rule`  (
    1123. 

  1123.   `id` bigint NOT NULL AUTO_INCREMENT,
    1124. 

  1124.   `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '类型',
    1125. 

  1125.   `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
    1126. 

  1126.   `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '0:禁用 1:启用',
    1127. 

  1127.   `org_id` bigint NOT NULL COMMENT '发布机构',
    1128. 

  1128.   `org_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '机构类型',
    1129. 

  1129.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注',
    1130. 

  1130.   `create_time` datetime NULL DEFAULT NULL,
    1131. 

  1131.   `update_time` datetime NULL DEFAULT NULL,
    1132. 

  1132.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1133. 

  1133.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1134. 

  1134.   `deleted` int NULL DEFAULT NULL COMMENT '0:未删除 、1：删除',
    1135. 

  1135.   PRIMARY KEY (`id`) USING BTREE
    1136. 

  1136. ) ENGINE = InnoDB AUTO_INCREMENT = 1701795990306471938 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '安全检查内容库定义\r\n' ROW_FORMAT = Dynamic;
    1137. 

  1137. 

  1138. -- ----------------------------
    1139. 

  1139. -- Table structure for core_safetycheck_rule_item
    1140. 

  1140. -- ----------------------------
    1141. 

  1141. DROP TABLE IF EXISTS `core_safetycheck_rule_item`;
    1142. 

  1142. CREATE TABLE `core_safetycheck_rule_item`  (
    1143. 

  1143.   `id` bigint NOT NULL AUTO_INCREMENT,
    1144. 

  1144.   `rule_id` bigint NOT NULL COMMENT '安全检查内容库定义id',
    1145. 

  1145.   `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查项名称',
    1146. 

  1146.   `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
    1147. 

  1147.   `create_time` datetime NULL DEFAULT NULL,
    1148. 

  1148.   `update_time` datetime NULL DEFAULT NULL,
    1149. 

  1149.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1150. 

  1150.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1151. 

  1151.   `deleted` int NULL DEFAULT NULL COMMENT '删除状态，0未删除，1已删除',
    1152. 

  1152.   PRIMARY KEY (`id`) USING BTREE
    1153. 

  1153. ) ENGINE = InnoDB AUTO_INCREMENT = 1705410983891484674 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查内容库-检查项' ROW_FORMAT = Dynamic;
    1154. 

  1154. 

  1155. -- ----------------------------
    1156. 

  1156. -- Table structure for core_safetycheck_rule_point
    1157. 

  1157. -- ----------------------------
    1158. 

  1158. DROP TABLE IF EXISTS `core_safetycheck_rule_point`;
    1159. 

  1159. CREATE TABLE `core_safetycheck_rule_point`  (
    1160. 

  1160.   `id` bigint NOT NULL AUTO_INCREMENT,
    1161. 

  1161.   `rule_id` bigint NOT NULL COMMENT '安全检查内容库定义id',
    1162. 

  1162.   `item_id` bigint NOT NULL COMMENT '检查项id',
    1163. 

  1163.   `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检查内容',
    1164. 

  1164.   `area_id` bigint NOT NULL COMMENT '检查区域,区域表id',
    1165. 

  1165.   `business_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '要点关联的业务类型来源,要点业务类型,关联字典表code',
    1166. 

  1166.   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    1167. 

  1167.   `deleted` int NULL DEFAULT NULL COMMENT '是否删除, 1是0否',
    1168. 

  1168.   `create_time` datetime NULL DEFAULT NULL,
    1169. 

  1169.   `update_time` datetime NULL DEFAULT NULL,
    1170. 

  1170.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1171. 

  1171.   `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    1172. 

  1172.   PRIMARY KEY (`id`) USING BTREE
    1173. 

  1173. ) ENGINE = InnoDB AUTO_INCREMENT = 1705410983891484676 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '安全检查内容库-检查内容' ROW_FORMAT = Dynamic;
    1174. 

  1174. 

  1175. SET FOREIGN_KEY_CHECKS = 1;
    1176. 

  1176. 

  1177. DELETE from `sys_dict_type` WHERE id='question_confirm_status' or id='question_reform_status';
    1178. 

  1178. 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);
    1179. 

  1179. 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);
    1180. 

  1180. 

  1181. DELETE from `sys_dict_data` WHERE dict_type in ('question_confirm_status','question_reform_status');
    1182. 

  1182. 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);
    1183. 

  1183. 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);
    1184. 

  1184. 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);
    1185. 

  1185. 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);
    1186. 

  1186. 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);
    1187. 

  1187. 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);
    1188.