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

diff --git a/sql/mysql/hrm_overtime_wage_config_init.sql b/sql/mysql/hrm_overtime_wage_config_init.sql
index b3589a9..986010e 100644
--- a/sql/mysql/hrm_overtime_wage_config_init.sql
+++ b/sql/mysql/hrm_overtime_wage_config_init.sql
@@ -6,6 +6,9 @@
 --   - 鎸夊伐绉嶈缃渶澶у姞鐝椂闀夸笂闄�
 -- =============================================
 
+-- 寮哄埗杩炴帴瀛楃闆嗭紝閬垮厤涓枃鑿滃崟鍚嶈鍙岄噸缂栫爜锛堜贡鐮侊級
+SET NAMES utf8mb4;
+
 -- =============================================
 -- 1. 宀椾綅鍔犵彮宸ヨ祫閰嶇疆琛�
 -- =============================================
@@ -73,6 +76,9 @@
 `path` = VALUES(`path`), `icon` = VALUES(`icon`), `component` = VALUES(`component`),
 `component_name` = VALUES(`component_name`), `status` = VALUES(`status`), `deleted` = b'0';
 
+-- 纭繚涓婄骇銆岃柂閰鐞嗐�嶇洰褰曞彲瑙侊紙閮ㄥ垎瀹㈡埛搴撲腑璇ョ洰褰曡璁句负闅愯棌 visible=0锛屼細瀵艰嚧銆屽姞鐝伐璧勭鐞嗐�嶄笉鏄剧ず锛�
+UPDATE `system_menu` SET `visible` = b'1' WHERE `id` = 6020 AND `deleted` = b'0';
+
 -- 鎺堜簣瓒呯骇绠＄悊鍛橈紙role_id = 1锛�
 INSERT INTO `system_role_menu`
 (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)

--
Gitblit v1.9.3