From b29d86d9ed34fd890eb14cb7a75f6ae4f7148865 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 01 九月 2026 13:58:03 +0800
Subject: [PATCH] feat(mes): 新增防伪防窜货功能模块

---
 sql/mysql/mes_wm_sales_outbound_traceability.sql |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)

diff --git a/sql/mysql/mes_wm_sales_outbound_traceability.sql b/sql/mysql/mes_wm_sales_outbound_traceability.sql
index 8f707d1..2ae437f 100644
--- a/sql/mysql/mes_wm_sales_outbound_traceability.sql
+++ b/sql/mysql/mes_wm_sales_outbound_traceability.sql
@@ -1,6 +1,15 @@
 -- 鍑哄簱娴侀�氱鐞嗭細閿�鍞嚭搴撲笌琚嬬爜/鎵樼洏鐮佸叧鑱旓紙鏃犵鎴峰瓧娈碉級
 -- 鎵ц鍓嶈纭鐩爣鏁版嵁搴撲负 mom-thzy锛屽苟閫愭潯鎵ц銆�
 
+ALTER TABLE mes_wm_product_sales
+  ADD COLUMN client_name varchar(255) DEFAULT NULL COMMENT '缁忛攢鍟嗗悕绉板揩鐓�' AFTER client_id;
+ALTER TABLE mes_wm_product_sales
+  ADD COLUMN outbound_time datetime DEFAULT NULL COMMENT '瀹為檯鍑哄簱鏃堕棿' AFTER sales_date;
+ALTER TABLE mes_wm_product_sales
+  ADD COLUMN outbound_user_id bigint DEFAULT NULL COMMENT '鎵ц鍑哄簱鎿嶄綔浜篒D' AFTER outbound_time;
+ALTER TABLE mes_wm_product_sales
+  ADD INDEX idx_product_sales_outbound_time (outbound_time);
+
 ALTER TABLE mes_wm_product_sales_detail
   ADD COLUMN bag_code_id bigint DEFAULT NULL COMMENT '琚嬬爜缂栧彿' AFTER area_id;
 ALTER TABLE mes_wm_product_sales_detail

--
Gitblit v1.9.3