mysql 评论回复表

CREATE TABLE comment_replies (
    id INT AUTO_INCREMENT PRIMARY KEY,
    comment_id INT NOT NULL,
    user_id INT NOT NULL,
    content TEXT NOT NULL,
    parent_id INT DEFAULT NULL, -- 表示回复的父级回复ID
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (comment_id) REFERENCES comments(id),
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (parent_id) REFERENCES comment_replies(id)
);

SELECT * FROM comment_replies WHERE comment_id = ?;

SELECT COUNT(*) AS reply_count FROM comment_replies WHERE comment_id = ?;

SELECT COUNT(*) AS reply_count FROM comment_replies WHERE user_id = ?;