From ea15a94b09d6d6b0c62f64aa6cfa03b4636cf557 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期三, 02 九月 2026 18:02:36 +0800
Subject: [PATCH] fix(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