From 5b9b59e0a1e006179440cb6887fc6326bf49976d Mon Sep 17 00:00:00 2001
From: cl <1442464845@qq.com>
Date: 星期一, 13 四月 2026 13:21:05 +0800
Subject: [PATCH] 重量sql

---
 version/db/man_loc_add_weight.sql        |    2 ++
 version/db/man_task_stock_add_weight.sql |    4 ++++
 2 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/version/db/man_loc_add_weight.sql b/version/db/man_loc_add_weight.sql
new file mode 100644
index 0000000..7b220c2
--- /dev/null
+++ b/version/db/man_loc_add_weight.sql
@@ -0,0 +1,2 @@
+-- 搴撲綅閲嶉噺锛屼笌浠诲姟/鎺ュ彛鍥涗綅灏忔暟涓�鑷�
+ALTER TABLE man_loc ADD COLUMN weight DECIMAL(18, 4) NULL COMMENT '閲嶉噺';
diff --git a/version/db/man_task_stock_add_weight.sql b/version/db/man_task_stock_add_weight.sql
new file mode 100644
index 0000000..8557491
--- /dev/null
+++ b/version/db/man_task_stock_add_weight.sql
@@ -0,0 +1,4 @@
+-- 鍏ュ簱閲嶉噺锛屼笌鎺ュ彛 BigDecimal 鍥涗綅灏忔暟涓�鑷达紱鎵ц鍓嶈纭搴撹〃鍚嶄笌鐜扮綉涓�鑷�
+ALTER TABLE man_task ADD COLUMN weight DECIMAL(18, 4) NULL COMMENT '閲嶉噺';
+ALTER TABLE man_stock ADD COLUMN weight DECIMAL(18, 4) NULL COMMENT '閲嶉噺';
+ALTER TABLE man_stock_item ADD COLUMN weight DECIMAL(18, 4) NULL COMMENT '閲嶉噺';

--
Gitblit v1.9.1