diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
index 944d880..19ff0b5 100644
--- a/src/main/resources/application.properties
+++ b/src/main/resources/application.properties
@@ -21,3 +21,5 @@
 spring.mail.properties.mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory
 
 logging.level.org.springframework.data.redis= DEBUG
+
+spring.security.user.role-prefix=
diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index 051ce5e..4a3621e 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -8,6 +8,7 @@
   `user_level` ENUM('lv1', 'lv2', 'lv3', 'vip') DEFAULT 'lv1',
   `signin_count` INT DEFAULT 0,
   `last_signin_date` DATE,
+  `role` ENUM('USER', 'ADMIN') DEFAULT 'USER' COMMENT '用户角色',
   INDEX `idx_user_level` (`user_level`)  -- 按等级查询优化
 );
 -- 用户统计表