-- =============================================================================
-- Twosome – database/migration_new_cheeky_games.sql
-- Schema for Cheeky Grand Prix & Companion Cheeky Games:
--   cheeky_grand_prix, flirt_bluff, blush_bingo, midnight_charades,
--   teasing_wheel, two_choices_one_bed, whisper_code
-- =============================================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ── 1. FLIRT BLUFF CARDS ──
CREATE TABLE IF NOT EXISTS flirt_bluff_cards (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    truth1     VARCHAR(255) NOT NULL,
    truth2     VARCHAR(255) NOT NULL,
    bluff      VARCHAR(255) NOT NULL,
    scenario   VARCHAR(128) NOT NULL,
    level      TINYINT UNSIGNED NOT NULL DEFAULT 1,
    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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ── 2. BLUSH BINGO PROMPTS ──
CREATE TABLE IF NOT EXISTS blush_bingo_prompts (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    title      VARCHAR(128) NOT NULL,
    category   VARCHAR(64)  NOT NULL DEFAULT 'cute',
    level      TINYINT UNSIGNED NOT NULL DEFAULT 1,
    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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ── 3. MIDNIGHT CHARADES PROMPTS ──
CREATE TABLE IF NOT EXISTS midnight_charades_prompts (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    prompt     VARCHAR(255) NOT NULL,
    category   VARCHAR(64)  NOT NULL DEFAULT 'flirty',
    level      TINYINT UNSIGNED NOT NULL DEFAULT 1,
    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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ── 4. TEASING WHEEL SEGMENTS ──
CREATE TABLE IF NOT EXISTS teasing_wheel_segments (
    id          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    title       VARCHAR(128) NOT NULL,
    description TEXT         NOT NULL,
    icon        VARCHAR(16)  NOT NULL DEFAULT '✨',
    level       TINYINT UNSIGNED NOT NULL DEFAULT 1,
    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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ── 5. TWO CHOICES ONE BED DILEMMAS ──
CREATE TABLE IF NOT EXISTS two_choices_one_bed_dilemmas (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    option_a   VARCHAR(255) NOT NULL,
    option_b   VARCHAR(255) NOT NULL,
    level      TINYINT UNSIGNED NOT NULL DEFAULT 1,
    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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ── 6. WHISPER CODE PROMPTS ──
CREATE TABLE IF NOT EXISTS whisper_code_prompts (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    phrase     VARCHAR(255) NOT NULL,
    decoy1     VARCHAR(255) NOT NULL,
    decoy2     VARCHAR(255) NOT NULL,
    decoy3     VARCHAR(255) NOT NULL,
    level      TINYINT UNSIGNED NOT NULL DEFAULT 1,
    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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;