From 1fb9069acd396eb8bdbd65252f6eb10d3e8362b7 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期二, 02 六月 2026 13:56:57 +0800 Subject: [PATCH] feat(staff): 修改员工入职服务接口增加用户添加标识参数 --- doc/20260602_device_maintenance_acceptance.sql | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/doc/20260602_device_maintenance_acceptance.sql b/doc/20260602_device_maintenance_acceptance.sql new file mode 100644 index 0000000..24ccd4e --- /dev/null +++ b/doc/20260602_device_maintenance_acceptance.sql @@ -0,0 +1,9 @@ +-- 璁惧淇濆吇琛ㄦ柊澧為獙鏀朵汉鐩稿叧瀛楁 +ALTER TABLE `device_maintenance` + ADD COLUMN `acceptance_name` VARCHAR(100) NULL COMMENT '楠屾敹浜�' AFTER `spare_parts_ids`, + ADD COLUMN `acceptance_time` DATETIME NULL COMMENT '楠屾敹鏃堕棿' AFTER `acceptance_name`, + ADD COLUMN `acceptance_remark` VARCHAR(500) NULL COMMENT '楠屾敹澶囨敞' AFTER `acceptance_time`; + +-- 璁惧淇濆吇瀹氭椂浠诲姟琛ㄦ柊澧炴槸鍚﹀惎鐢ㄥ瓧娈� +ALTER TABLE `maintenance_task` + ADD COLUMN `is_enabled` TINYINT(1) NULL DEFAULT 1 COMMENT '鏄惁鍚敤 0-绂佺敤 1-鍚敤' AFTER `is_active`; \ No newline at end of file -- Gitblit v1.9.3