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 等字典/菜单中文双重编码乱码
---
yudao-module-member/src/test/resources/sql/create_tables.sql | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/yudao-module-member/src/test/resources/sql/create_tables.sql b/yudao-module-member/src/test/resources/sql/create_tables.sql
index 782a818..9775a30 100644
--- a/yudao-module-member/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-member/src/test/resources/sql/create_tables.sql
@@ -11,6 +11,7 @@
"avatar" varchar(255) NOT NULL DEFAULT '' COMMENT '澶村儚',
"status" tinyint NOT NULL COMMENT '鐘舵��',
"mobile" varchar(11) NOT NULL COMMENT '鎵嬫満鍙�',
+ "email" varchar(50) NULL COMMENT '閭',
"password" varchar(100) NOT NULL DEFAULT '' COMMENT '瀵嗙爜',
"register_ip" varchar(32) NOT NULL COMMENT '娉ㄥ唽 IP',
"login_ip" varchar(50) NULL DEFAULT '' COMMENT '鏈�鍚庣櫥褰旾P',
--
Gitblit v1.9.3