From ef379e5c13ba7821da4ebf4882a59b07b99324a7 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@local>
Date: 星期二, 03 十一月 2026 17:26:20 +0800
Subject: [PATCH] fix(crm): 北方科技补 crm_customer.auto_pool_enabled 列,修复新增客户系统异常

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

diff --git a/sql/mysql/bfkj_crm_customer_add_auto_pool_enabled.sql b/sql/mysql/bfkj_crm_customer_add_auto_pool_enabled.sql
new file mode 100644
index 0000000..a1a4bc3
--- /dev/null
+++ b/sql/mysql/bfkj_crm_customer_add_auto_pool_enabled.sql
@@ -0,0 +1,39 @@
+-- =====================================================================
+-- 鍖楁柟绉戞妧锛氫慨澶嶃�岄攢鍞鎴锋柊澧炴姤绯荤粺寮傚父銆�
+--
+-- 鐜拌薄锛�
+--   CRM 鈫� 瀹㈡埛绠$悊 鈫� 鏂板瀹㈡埛锛岀偣鍑讳繚瀛樺悗鎻愮ず銆岀郴缁熷紓甯搞�嶃��
+--
+-- 鏍瑰洜锛�
+--   crm_customer 琛ㄧ己灏� auto_pool_enabled 鍒楋紝鑰屼唬鐮侊紙CrmCustomerDO锛夐噷
+--   宸叉湁 autoPoolEnabled 瀛楁銆侻ySQL 鎻掑叆鏃舵姤锛�
+--     java.sql.SQLSyntaxErrorException: Unknown column 'auto_pool_enabled'
+--   鏈川鏄唬鐮佹瘮鏁版嵁搴撴柊锛屽缓琛ㄨ剼鏈病鏈夊悓姝ヨ繖涓�鍒椼��
+--
+-- 褰卞搷鑼冨洿锛�
+--   鍙奖鍝嶆柊澧炲鎴凤紱宸叉湁瀹㈡埛鏁版嵁鐨勬煡璇€�佺紪杈戜笉鍙楀奖鍝嶃��
+--
+-- 淇锛�
+--   琛ヤ笂璇ュ垪锛屽甫榛樿鍊� 0锛堜笉鑷姩鏀惧叆鍏捣锛夛紝宸叉湁鏁版嵁鑷姩鑾峰緱榛樿鍊笺��
+--
+-- 鐗规�э細鍙噸澶嶆墽琛岋紙鍏堝垽鏂垪鏄惁瀛樺湪锛�
+-- =====================================================================
+
+SET @col_exists := (
+    SELECT COUNT(*)
+    FROM information_schema.COLUMNS
+    WHERE TABLE_SCHEMA = DATABASE()
+      AND TABLE_NAME = 'crm_customer'
+      AND COLUMN_NAME = 'auto_pool_enabled'
+);
+
+SET @sql := IF(@col_exists = 0,
+    'ALTER TABLE crm_customer ADD COLUMN auto_pool_enabled tinyint(1) NOT NULL DEFAULT 0 COMMENT ''鏄惁寮�鍚嚜鍔ㄦ斁鍏ュ叕娴�'' AFTER deal_status',
+    'SELECT ''column auto_pool_enabled already exists'' AS msg');
+
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- 楠岃瘉
+SHOW COLUMNS FROM crm_customer LIKE 'auto_pool_enabled';

--
Gitblit v1.9.3