From 8ad863082097ffdcab4a8e7f426d344a1fe6f892 Mon Sep 17 00:00:00 2001 From: 吴羡 <16976746+Xian-TT3@user.noreply.gitee.com> Date: 星期六, 07 十一月 2026 00:27:02 +0800 Subject: [PATCH] 修复人员管理接口校验与导出，完善设备保养计划与文件受控功能 --- sql/lims_delta.sql | 19 +++++++++++++++++++ 1 files changed, 19 insertions(+), 0 deletions(-) diff --git a/sql/lims_delta.sql b/sql/lims_delta.sql index b89c9e7..7429e74 100644 --- a/sql/lims_delta.sql +++ b/sql/lims_delta.sql @@ -1,3 +1,22 @@ -- 鎵归噺涓嬪崟鎵规鍙凤細鍚屼竴娆℃壒閲忎笅鍗曠殑鏍峰搧鍏变韩涓�涓壒娆″彿 ALTER TABLE ins_order ADD COLUMN batch_no VARCHAR(64) NULL COMMENT '鎵归噺涓嬪崟鎵规鍙�' AFTER entrust_code; ALTER TABLE cnas_inspection_order ADD COLUMN batch_no VARCHAR(64) NULL COMMENT '鎵归噺涓嬪崟鎵规鍙�' AFTER entrust_code; + +-- 璁惧淇濆吇璁″垝鏄庣粏闄勪欢琛細闄勪欢鎸夎鍒掓槑缁嗭紙璁惧琛岋級鎸傝浇 +CREATE TABLE IF NOT EXISTS `device_maintenance_attachment` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '闄勪欢id', + `maintenance_plan_detail_id` int NOT NULL COMMENT '璁惧淇濆吇璁″垝鏄庣粏id', + `file_name` varchar(255) NOT NULL COMMENT '鏂囦欢鍚�', + `file_url` varchar(500) NOT NULL COMMENT '鏂囦欢鍦板潃', + `sort` int DEFAULT '0' COMMENT '鎺掑簭', + `create_user` int DEFAULT NULL COMMENT '鍒涘缓浜�', + `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `update_user` int DEFAULT NULL COMMENT '淇敼浜�', + `update_time` datetime DEFAULT NULL COMMENT '淇敼鏃堕棿', + PRIMARY KEY (`id`), + KEY `idx_dmpa_detail_id` (`maintenance_plan_detail_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='璁惧淇濆吇璁″垝鏄庣粏闄勪欢琛�'; + +-- 鏂囦欢鍙楁帶鐢宠锛氬鍔犲彂甯冩棩鏈熴�佸疄鏂芥棩鏈燂紙鎻愪氦鏃ユ湡鍒椾繚鐣欙紝浣嗙晫闈笉鍐嶆樉绀猴級 +ALTER TABLE cnas_manage_document_controlled ADD COLUMN publish_date DATE NULL COMMENT '鍙戝竷鏃ユ湡' AFTER submit_date; +ALTER TABLE cnas_manage_document_controlled ADD COLUMN implement_date DATE NULL COMMENT '瀹炴柦鏃ユ湡' AFTER publish_date; -- Gitblit v1.9.3