-- ============================================================================
-- 设备报修 device_repair
-- ============================================================================

ALTER TABLE `device_repair`
    ADD COLUMN `acceptance_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '验收人' AFTER `repair_name`;

ALTER TABLE `device_repair`
    ADD COLUMN `acceptance_time` datetime NULL DEFAULT NULL COMMENT '验收时间' AFTER `acceptance_name`;

ALTER TABLE `device_repair`
    ADD COLUMN `acceptance_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '验收备注' AFTER `acceptance_time`;

-- 状态说明：0-待维修 1-完成 2-维修失败 3-待验收
