diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index 355602c..d97701c 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -34,6 +34,8 @@
 CREATE TABLE IF NOT EXISTS `posts` (
     post_id INT AUTO_INCREMENT PRIMARY KEY,
     user_id INT NOT NULL,
+    hot_score DOUBLE DEFAULT 0.0,
+    view_count INT DEFAULT 0,
     post_title VARCHAR(255) NOT NULL,
     post_content TEXT NOT NULL,
     post_type ENUM('resource', 'discussion') NOT NULL,
@@ -56,14 +58,6 @@
     PRIMARY KEY (post_id, tag_id)
 );
 
-CREATE TABLE IF NOT EXISTS `post_likes` (
-    user_id INT NOT NULL,
-    post_id INT NOT NULL,
-    FOREIGN KEY (user_id) REFERENCES users(user_id),
-    FOREIGN KEY (post_id) REFERENCES posts(post_id),
-    PRIMARY KEY (user_id, post_id)
-);
-
 -- 关注关系表
 CREATE TABLE IF NOT EXISTS `user_follows` (
     follower_id INT NOT NULL,
@@ -98,11 +92,20 @@
     FOREIGN KEY (parent_comment_id) REFERENCES comments(comment_id) -- 关联父评论
 );
 
-CREATE TABLE post_likes (
-    user_id BIGINT NOT NULL,
-    post_id BIGINT NOT NULL,
+CREATE TABLE IF NOT EXISTS post_likes (
+    user_id INT NOT NULL,
+    post_id INT NOT NULL,
     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     PRIMARY KEY (user_id, post_id),
     CONSTRAINT fk_post FOREIGN KEY (post_id) REFERENCES posts(post_id),
     CONSTRAINT fk_user FOREIGN KEY (user_id) REFERENCES users(user_id)
 );
+
+CREATE TABLE IF NOT EXISTS post_views (
+    view_id INT AUTO_INCREMENT PRIMARY KEY,
+    user_id INT NOT NULL,
+    post_id INT NOT NULL,
+    view_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    FOREIGN KEY (user_id) REFERENCES users(user_id),
+    FOREIGN KEY (post_id) REFERENCES posts(post_id)
+);
