-- Migration: Spin the Mirchi
-- Tables: spin_the_mirchi_cards

CREATE TABLE IF NOT EXISTS spin_the_mirchi_cards (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    code VARCHAR(64) NOT NULL UNIQUE,
    category VARCHAR(32) NOT NULL, -- accessories, confessions, scenarios, desires, dilemmas, teases
    title VARCHAR(128) NOT NULL,
    prompt_text TEXT NOT NULL,
    apart_prompt TEXT NOT NULL,
    together_prompt TEXT NOT NULL,
    level INT NOT NULL DEFAULT 1, -- 1: Mild/Flirty, 2: Spicy/Sensual, 3: Steamy/Intimate
    mode ENUM('together','apart','both') NOT NULL DEFAULT 'both',
    is_spicy TINYINT(1) NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_stm_category_level (category, level, is_spicy),
    INDEX idx_stm_mode (mode)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;