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`),          -- 新增热度索引
