commit 7affa47e1a8802d089912cdf9e1c9461cb29bc8b
author 夜雨声烦 <xxi13552467509@163.com> Tue May 20 19:27:16 2025 +0800
committer 夜雨声烦 <xxi13552467509@163.com> Tue May 20 22:05:43 2025 +0800
tree bf6da5a667d7bb8d071f4b7ce05572a802421763
parent 1ab4f5b18991df0055d5eee870052baed056c8c4

expandAdminFunction

Change-Id: If3b875b3017d1922b15150dd735ca2ce5a3a77f0

src/main/resources/schema.sql

diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index e5faa3f..8a2387c 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -9,6 +9,10 @@
   `signin_count` INT DEFAULT 0,
   `last_signin_date` DATE,
   `role` ENUM('USER', 'ADMIN') DEFAULT 'USER' COMMENT '用户角色',
+  `is_banned` BOOLEAN DEFAULT FALSE COMMENT '是否被封禁',
+  `banned_reason` VARCHAR(255) COMMENT '封禁原因',
+  `banned_at` DATETIME COMMENT '封禁时间',
+  `banned_by` BIGINT COMMENT '操作管理员ID',
   INDEX `idx_user_level` (`user_level`)  -- 按等级查询优化
 );
 -- 用户统计表
@@ -58,6 +62,10 @@
   `last_calculated` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后热度计算时间',
   `average_rating` DECIMAL(3,2) DEFAULT 0.00 COMMENT '帖子平均评分',
   `rating_count` INT DEFAULT 0 COMMENT '总评分人数',
+  `is_locked` BOOLEAN DEFAULT FALSE COMMENT '是否被锁定',
+  `locked_reason` VARCHAR(255) COMMENT '锁定原因',
+  `locked_at` DATETIME COMMENT '锁定时间',
+  `locked_by` BIGINT COMMENT '操作管理员ID',
   FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`),
   FOREIGN KEY (`torrent_id`) REFERENCES `torrents`(`torrent_id`),
   INDEX `idx_hot_score` (`hot_score`),          -- 新增热度索引