CREATE TABLE post_likes (
    id INT PRIMARY KEY AUTO_INCREMENT,
    post_id INT,
    user_id INT,
    action ENUM('like', 'dislike'),
    FOREIGN KEY (post_id) REFERENCES post_table (id) ON DELETE CASCADE,
    FOREIGN KEY (user_id) REFERENCES singup_table (id) ON DELETE CASCADE
);


ALTER TABLE post_table ADD COLUMN likes INT DEFAULT 0;
ALTER TABLE post_table ADD COLUMN dislikes INT DEFAULT 0;