From a71dacada24ef2c4e2e2718471c4b5efef403221 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期五, 16 十月 2026 09:19:28 +0800
Subject: [PATCH] fix(sql): 售后/问题库 SQL 追加 SET NAMES utf8mb4，修复 aftersale_reason_type 等字典/菜单中文双重编码乱码
---
sql/mysql/aftersales_problem_visit_init.sql | 3 +++
sql/mysql/aftersales_ticket_text_fields.sql | 2 ++
sql/mysql/aftersales_ticket_item_enhance.sql | 3 +++
3 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/aftersales_problem_visit_init.sql b/sql/mysql/aftersales_problem_visit_init.sql
index 4a25966..ed75ab3 100644
--- a/sql/mysql/aftersales_problem_visit_init.sql
+++ b/sql/mysql/aftersales_problem_visit_init.sql
@@ -3,6 +3,9 @@
-- 鍚細after_sale_ticket 鍔� 6 鍒椼�乤fter_sale_problem / after_sale_visit 寤鸿〃銆侀棶棰樺簱鑿滃崟锛堢┖闂� id 602710-602716锛屽凡瀛樺湪鍒欒烦杩囷級
-- =============================================
+-- 寮哄埗杩炴帴瀛楃闆嗭紝閬垮厤涓枃琚弻閲嶇紪鐮侊紙涔辩爜锛�
+SET NAMES utf8mb4;
+
-- 1. after_sale_ticket 鍔犲洖璁�/娌夋穩鐩稿叧鍒�
SET @c := (SELECT COUNT(*) FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'after_sale_ticket' AND COLUMN_NAME = 'visit_status');
diff --git a/sql/mysql/aftersales_ticket_item_enhance.sql b/sql/mysql/aftersales_ticket_item_enhance.sql
index 818614d..a7eec1f 100644
--- a/sql/mysql/aftersales_ticket_item_enhance.sql
+++ b/sql/mysql/aftersales_ticket_item_enhance.sql
@@ -4,6 +4,9 @@
-- 鍖呭惈锛歛fter_sale_ticket_item 鍔犲瓧娈� + aftersale_reason_type 瀛楀吀
-- =============================================
+-- 寮哄埗杩炴帴瀛楃闆嗭紝閬垮厤涓枃琚弻閲嶇紪鐮侊紙涔辩爜锛�
+SET NAMES utf8mb4;
+
-- =============================================
-- 1. 宸ュ崟鏄庣粏琛ㄦ柊澧炲瓧娈碉紙瀛樺湪鎬у垽鏂紝淇濊瘉鍙噸澶嶆墽琛岋級
-- =============================================
diff --git a/sql/mysql/aftersales_ticket_text_fields.sql b/sql/mysql/aftersales_ticket_text_fields.sql
index 091456b..07f38e8 100644
--- a/sql/mysql/aftersales_ticket_text_fields.sql
+++ b/sql/mysql/aftersales_ticket_text_fields.sql
@@ -1,6 +1,8 @@
-- =============================================
-- 鍞悗宸ュ崟锛氬鎴�/鑱旂郴浜�/鐗╂枡/鎵规 鏀逛负鏂囨湰瀛樺偍 + 鍏滃簳琛ラ綈宸ュ崟鎸夐挳鏉冮檺锛堝彲閲嶅鎵ц锛�
-- =============================================
+-- 寮哄埗杩炴帴瀛楃闆嗭紝閬垮厤涓枃琚弻閲嶇紪鐮侊紙涔辩爜锛�
+SET NAMES utf8mb4;
SET @c1 := (SELECT COUNT(*) FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'after_sale_ticket' AND COLUMN_NAME = 'customer_name');
SET @ddl1 := IF(@c1 = 0,
--
Gitblit v1.9.3