SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS marketing_ai_creatives (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    user_id INT UNSIGNED NOT NULL,
    broker_id INT UNSIGNED NULL,
    provider_key VARCHAR(40) NOT NULL,
    provider_label VARCHAR(80) NOT NULL,
    action ENUM('text','image','document') NOT NULL,
    prompt TEXT NOT NULL,
    result_text LONGTEXT NULL,
    images JSON NULL,
    meta JSON NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_marketing_ai_user (user_id),
    INDEX idx_marketing_ai_broker (broker_id),
    INDEX idx_marketing_ai_action (action),
    CONSTRAINT fk_marketing_ai_user
        FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE,
    CONSTRAINT fk_marketing_ai_broker
        FOREIGN KEY (broker_id) REFERENCES users (id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;