-- Migration: Create project AI prompt settings table
-- Date: 2025-01-XX
-- Description: Creates table to store default AI document prompt settings for projects

-- ===== Project AI Prompt Settings =====
CREATE TABLE IF NOT EXISTS project_ai_prompt_settings (
    id VARCHAR(36) PRIMARY KEY,
    project_id VARCHAR(36) NOT NULL UNIQUE,
    target_audience VARCHAR(255) DEFAULT NULL,
    presentation_purpose VARCHAR(255) DEFAULT NULL,
    estimated_time VARCHAR(255) DEFAULT NULL,
    slide_count VARCHAR(255) DEFAULT NULL,
    presentation_style VARCHAR(255) DEFAULT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE,
    INDEX idx_project (project_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

