| commit | 451d71c3a34218323aebcc2ac78491f4bb401878 | [log] [tgz] |
|---|---|---|
| author | 夜雨声烦 <xxi13552467509@163.com> | Tue May 20 00:58:36 2025 +0800 |
| committer | 夜雨声烦 <xxi13552467509@163.com> | Tue May 20 00:58:36 2025 +0800 |
| tree | 10c5bd4946725cb676a287795cd2115e8cc58208 | |
| parent | 8b83258a3a80fdffc46450261d418c7511ba6a26 [diff] [blame] |
admin_basic Change-Id: I16f1cd5785730b22e6e1e3fb4905f546ef0b555d
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`) -- 按等级查询优化 ); -- 用户统计表