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