From e40a608ef9bf51db294d8eefada6a8e2e80cebca Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期四, 15 十月 2026 16:03:27 +0800
Subject: [PATCH] fix(mdm): 物料列表改按物料编码排序

---
 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