ALTER TABLE `inspection_task`
|
ADD COLUMN `inspection_project` VARCHAR(100) NULL COMMENT '巡检项目' AFTER `task_name`;
|
|
ALTER TABLE `inspection_task`
|
ADD COLUMN `inspection_result` VARCHAR(1) NULL COMMENT '巡检结果 0异常 1正常' AFTER `remarks`,
|
ADD COLUMN `abnormal_description` VARCHAR(500) NULL COMMENT '异常描述' AFTER `inspection_result`,
|
ADD COLUMN `device_repair_id` BIGINT NULL COMMENT '关联维修单ID' AFTER `abnormal_description`,
|
ADD COLUMN `acceptance_user_id` BIGINT NULL COMMENT '验收人ID' AFTER `device_repair_id`,
|
ADD COLUMN `acceptance_name` VARCHAR(100) NULL COMMENT '验收人' AFTER `acceptance_user_id`;
|
|
ALTER TABLE `timing_task`
|
ADD COLUMN `inspection_project` VARCHAR(100) NULL COMMENT '巡检项目' AFTER `task_name`,
|
ADD COLUMN `is_enabled` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否启用 0否 1是' AFTER `is_active`;
|
|
CREATE INDEX `idx_inspection_task_device_repair_id`
|
ON `inspection_task` (`device_repair_id`);
|
|
CREATE INDEX `idx_inspection_task_inspection_result`
|
ON `inspection_task` (`inspection_result`);
|
|
CREATE INDEX `idx_timing_task_is_enabled`
|
ON `timing_task` (`is_enabled`);
|
