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

    competitor_name VARCHAR(255) NOT NULL,

    source VARCHAR(100) NOT NULL,

    scan_type VARCHAR(100) NOT NULL,

    result LONGTEXT,

    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
