CREATE TABLE IF NOT EXISTS `safe_line_inspection_task` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `inspection_name` varchar(100) DEFAULT NULL COMMENT '巡检任务名称',
  `line_name` varchar(100) DEFAULT NULL COMMENT '线路名称',
  `inspection_project` varchar(1000) DEFAULT NULL COMMENT '巡检项目',
  `inspector_id` varchar(255) DEFAULT NULL COMMENT '巡检人ID，多个用逗号分隔',
  `frequency_type` varchar(20) DEFAULT NULL COMMENT '频率类型 DAILY/WEEKLY/MONTHLY',
  `frequency_detail` varchar(50) DEFAULT NULL COMMENT '频率详情：每日HH:mm；每周MON,HH:mm；每月DD,HH:mm',
  `next_execution_time` datetime DEFAULT NULL COMMENT '下次执行时间',
  `last_execution_time` datetime DEFAULT NULL COMMENT '最后执行时间',
  `is_enabled` tinyint DEFAULT '1' COMMENT '是否启用 0否 1是',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_user` int DEFAULT NULL COMMENT '创建人ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_user` int DEFAULT NULL COMMENT '更新人ID',
  `tenant_id` bigint DEFAULT NULL COMMENT '租户ID',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_safe_line_inspection_task_enabled` (`is_enabled`, `next_execution_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='安全生产-线路定时巡检任务';

ALTER TABLE `safe_line_inspection`
  ADD COLUMN `schedule_task_id` bigint DEFAULT NULL COMMENT '定时巡检任务ID' AFTER `id`,
  ADD COLUMN `inspection_project` varchar(1000) DEFAULT NULL COMMENT '巡检项目' AFTER `inspection_type`,
  ADD KEY `idx_safe_line_inspection_schedule_task` (`schedule_task_id`) USING BTREE;

ALTER TABLE `safe_line_inspection`
  ADD COLUMN `inspection_result` varchar(20) DEFAULT NULL COMMENT '巡检结果：正常/异常' AFTER `status`,
  ADD COLUMN `actual_inspection_time` datetime DEFAULT NULL COMMENT '实际巡检时间' AFTER `inspection_result`,
  ADD COLUMN `hidden_id` int DEFAULT NULL COMMENT '关联隐患排查上报ID' AFTER `actual_inspection_time`,
  ADD KEY `idx_safe_line_inspection_hidden` (`hidden_id`) USING BTREE;

ALTER TABLE `safe_line_inspection_hazard`
  ADD COLUMN `safe_hidden_id` int DEFAULT NULL COMMENT '关联隐患排查上报ID' AFTER `record_id`,
  ADD COLUMN `rectify_deadline` date DEFAULT NULL COMMENT '整改期限' AFTER `rectify_user_id`,
  ADD KEY `idx_safe_line_inspection_hazard_hidden` (`safe_hidden_id`) USING BTREE;