-- Migration: Add startup_updates table for founder progress reports
CREATE TABLE IF NOT EXISTS startup_updates (
    id INT AUTO_INCREMENT PRIMARY KEY,
    startup_id INT NOT NULL,
    founder_id INT NOT NULL,
    title VARCHAR(255) NOT NULL,
    content TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (startup_id) REFERENCES startups(id) ON DELETE CASCADE,
    FOREIGN KEY (founder_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;