bug_fix+historyview
Change-Id: I6f446c1b660a4322865cfcf5502c88cb772ca0a1
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)
+);