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 +++
1 files changed, 3 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');
--
Gitblit v1.9.3