complete_postlike
Change-Id: If5a628b11d1bf19d531703ec1a8b62f1690ed7fb
diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index 3c9ff93..355602c 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -97,3 +97,12 @@
FOREIGN KEY (user_id) REFERENCES users(user_id), -- 关联用户
FOREIGN KEY (parent_comment_id) REFERENCES comments(comment_id) -- 关联父评论
);
+
+CREATE TABLE post_likes (
+ user_id BIGINT NOT NULL,
+ post_id BIGINT 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)
+);