CREATE TABLE IF NOT EXISTS intelligence_competitor_reports
(
    id INT AUTO_INCREMENT PRIMARY KEY,

    competitor_id INT NOT NULL,

    title VARCHAR(255) NOT NULL,

    report_text LONGTEXT NOT NULL,

    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
