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_sales_ledger_approval.sql |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)

diff --git a/doc/sql/20260613_sales_ledger_approval.sql b/doc/sql/20260613_sales_ledger_approval.sql
new file mode 100644
index 0000000..73169e9
--- /dev/null
+++ b/doc/sql/20260613_sales_ledger_approval.sql
@@ -0,0 +1,9 @@
+-- 閿�鍞彴璐﹀鍔犲鎵圭姸鎬佸瓧娈�
+-- 0-寰呭鎵癸紝1-瀹℃壒涓紝2-宸查�氳繃锛�3-宸查┏鍥�
+
+ALTER TABLE sales_ledger
+ADD COLUMN IF NOT EXISTS approval_status INT DEFAULT 0 COMMENT '瀹℃壒鐘舵�侊細0-寰呭鎵癸紝1-瀹℃壒涓紝2-宸查�氳繃锛�3-宸查┏鍥�';
+
+-- 鐢熶骇涓昏鍒掑鍔犲鎵圭姸鎬佸瓧娈碉紙涓庨攢鍞彴璐﹀鎵圭姸鎬佸悓姝ワ級
+ALTER TABLE production_plan
+ADD COLUMN IF NOT EXISTS approval_status INT DEFAULT NULL COMMENT '瀹℃壒鐘舵�侊細0-寰呭鎵癸紝1-瀹℃壒涓紝2-宸查�氳繃锛�3-宸查┏鍥�';

--
Gitblit v1.9.3