-- Migration: Hot Potato Heart
-- Table: hot_potato_dares

CREATE TABLE IF NOT EXISTS hot_potato_dares (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    code VARCHAR(64) NOT NULL UNIQUE,
    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, 2: Spicy, 3: Wild
    is_spicy TINYINT(1) NOT NULL DEFAULT 0,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_potato_level (level, is_spicy)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;