-- ============================================================================
-- 定时保养任务 maintenance_task：保养人、保养项目
-- 设备保养记录 device_maintenance：计划保养人
-- ============================================================================

ALTER TABLE `maintenance_task`
    ADD COLUMN `maintenance_person_id` bigint NULL DEFAULT NULL COMMENT '保养人id' AFTER `registrant`;

ALTER TABLE `maintenance_task`
    ADD COLUMN `maintenance_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保养人' AFTER `maintenance_person_id`;

ALTER TABLE `maintenance_task`
    ADD COLUMN `maintenance_items` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '保养项目' AFTER `maintenance_person`;

ALTER TABLE `device_maintenance`
    ADD COLUMN `maintenance_person_id` bigint NULL DEFAULT NULL COMMENT '计划保养人id' AFTER `maintenance_actually_name`;

ALTER TABLE `device_maintenance`
    ADD COLUMN `maintenance_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '计划保养人' AFTER `maintenance_person_id`;