From 202157cf81af12aaa9cf1b8e860a02dbb55bfe2a Mon Sep 17 00:00:00 2001 From: 吴羡 <16976746+Xian-TT3@user.noreply.gitee.com> Date: 星期四, 22 十月 2026 20:28:25 +0800 Subject: [PATCH] feat: 完善直绑模板设备初始化与审批人权限校验 --- sql/lims_delta.sql | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git a/sql/lims_delta.sql b/sql/lims_delta.sql index d1929a5..bd6ee65 100644 --- a/sql/lims_delta.sql +++ b/sql/lims_delta.sql @@ -105,3 +105,32 @@ add column search_new_time datetime default null comment '鏌ユ柊鏃堕棿' after search_new_source, add column search_new_result varchar(500) default null comment '鏌ユ柊缁撴灉' after search_new_time, add column search_new_website varchar(500) default null comment '鏉ユ簮涓哄叾浠栨椂鐨勫叿浣撶綉鍧�鎴栫綉绔欏悕绉�' after search_new_result; + +-- 22銆佹楠岃鍗曡〃澧炲姞鏍囧噯搴撲簩绾ц妭鐐笽D锛堢洿缁戞ā鏉夸笅鍗曪級 +-- 浠呭湪鐩爣搴撶己灏戣鍒楁椂鎵ц涓�娆� +alter table ins_order + add column standard_tree_id int default null comment '鏂拌仛鐩寸粦妯℃澘涓嬪崟鏃堕�夋嫨鐨勬爣鍑嗗簱浜岀骇鑺傜偣ID' after quality_monitor_details_id; + +-- 23銆佽祫璐ㄨ〃琛ラ綈棰佸彂鏃堕棿鍙婂垱寤轰汉濮撳悕 +-- 浠呭湪鐩爣搴撶己灏戣繖浜涘垪鏃舵墽琛屼竴娆� +alter table certification + add column create_user_name varchar(255) default null comment '鍒涘缓浜哄鍚�' after create_user, + add column first_issuance_date datetime default null comment '棣栨棰佸彂鏃堕棿' after date_of_issuance, + add column latest_issuance_date datetime default null comment '鏈�杩戦鍙戞椂闂�' after first_issuance_date; + +-- 24銆佸鎴锋弧鎰忓害琛ㄥ鍔犵‘璁ゅ瓧娈� +-- 浠呭湪鐩爣搴撶己灏戣繖浜涘垪鏃舵墽琛屼竴娆� +alter table cnas_client_satisfaction + add column confirm_person varchar(255) default null comment '纭浜�' after reasonable_fees_suggestion, + add column confirm_person_id int default null comment '纭浜篿d' after confirm_person, + add column confirm_status int default null comment '纭鐘舵��, 0:鏈‘璁�, 1:纭' after confirm_person_id; + +-- 25銆佷汉鍛樺煿璁槑缁嗚〃澧炲姞澶栬仒/闈炵郴缁熻甯堝鍚� +-- 浠呭湪鐩爣搴撶己灏戣鍒楁椂鎵ц涓�娆� +alter table cnas_person_training_detailed + add column training_lecturer_name varchar(255) default null comment '澶栬仒/闈炵郴缁熻甯堝鍚嶏紱鍐呴儴璁插笀浠嶅瓨 training_lecturer_id' after training_lecturer_id; + +-- 26銆佹楠岃鍗曟ā鏉垮揩鐓ц〃澧炲姞璁惧榛樿鍊煎垵濮嬪寲鏍囪 +-- 浠呭湪鐩爣搴撶己灏戣鍒楁椂鎵ц涓�娆� +alter table ins_order_standard_template + add column device_defaults_initialized int default null comment '榛樿璁惧鏄惁宸插湪棣栨杩涘叆妫�楠屼换鍔℃椂鍒濆鍖栵細0鍚︼紝1鏄�' after record_values; -- Gitblit v1.9.3