From f569e2257372a2f940aace9ad151fd758196eb9a Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期六, 13 六月 2026 14:34:42 +0800 Subject: [PATCH] 修改客户，销售，协同，报价，质量 --- doc/sql/20260613_quality_attachment_optimize.sql | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/doc/sql/20260613_quality_attachment_optimize.sql b/doc/sql/20260613_quality_attachment_optimize.sql new file mode 100644 index 0000000..12544ad --- /dev/null +++ b/doc/sql/20260613_quality_attachment_optimize.sql @@ -0,0 +1,16 @@ +-- ============================================================ +-- 涓嶅悎鏍肩鐞嗘ā鍧椾紭鍖� +-- 1. 搴熷純 quality_inspect_file 琛紝闄勪欢鏀圭敤 storage_attachment 浣撶郴 +-- 2. 妫�楠岃褰曢檮浠堕�氳繃 storage_attachment (record_type='quality_inspect') 鍏宠仈 +-- 3. 涓嶅悎鏍煎搧闄勪欢閫氳繃 storage_attachment (record_type='quality_unqualified') 鍏宠仈 +-- 鐢熸垚鏃ユ湡锛�2026-06-13 +-- ============================================================ + +-- 鍙�夛細濡傛灉 quality_inspect_file 琛ㄥ瓨鍦ㄤ笖鏈夋暟鎹紝闇�瑕佸厛杩佺Щ鏁版嵁鍐嶅垹闄� +-- 鏁版嵁杩佺Щ锛堝皢鏃ч檮浠舵暟鎹縼绉诲埌 storage_attachment 琛級 +-- INSERT INTO storage_attachment (name, url, file_size, application, record_type, record_id, create_time, create_user, tenant_id, dept_id, is_deleted) +-- SELECT name, url, file_size, 'FILE', 'quality_inspect', inspect_id, create_time, create_user, tenant_id, dept_id, 0 +-- FROM quality_inspect_file; + +-- 鍒犻櫎鏃х殑妫�楠岄檮浠惰〃锛堢‘璁ゆ暟鎹凡杩佺Щ鍚庢墽琛岋級 +-- DROP TABLE IF EXISTS quality_inspect_file; -- Gitblit v1.9.3