-- Migration: Lip Sync Showdown
-- Table: lip_sync_prompts (100+ original dramatic monologues, cheesy movie scenes, silly love songs, and freestyle moods)

CREATE TABLE IF NOT EXISTS lip_sync_prompts (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    code VARCHAR(64) NOT NULL UNIQUE,
    category ENUM('movie_scene', 'dramatic_monologue', 'silly_love_song', 'freestyle') NOT NULL,
    title VARCHAR(128) NOT NULL,
    line_text TEXT NOT NULL,
    context_cue VARCHAR(255) NOT NULL,
    mood_tag VARCHAR(64) NOT NULL,
    audio_loop VARCHAR(64) DEFAULT 'dramatic_piano',
    duration_sec INT NOT NULL DEFAULT 15,
    mode ENUM('both', 'apart', 'together') NOT NULL DEFAULT 'both',
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_lip_sync_cat (category, mode)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;