-- ============================================================================
|
-- 定时保养任务 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`;
|
