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

    project_id INT NULL,

    trend_title VARCHAR(255) NOT NULL,

    market_area VARCHAR(255) NOT NULL,

    priority ENUM('high','medium','low') DEFAULT 'medium',

    recommendation LONGTEXT,

    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
