-- =============================================================================
-- Twosome – database/migration_dare_minesweeper.sql
-- Schema for Dare Minesweeper:
--   dare_minesweeper_dares (150+ funny, flirty, consensual bomb dares)
--   dare_minesweeper_compliments (100+ sweet compliments and teases)
-- =============================================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

CREATE TABLE IF NOT EXISTS dare_minesweeper_dares (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    text       TEXT NOT NULL,
    level      TINYINT UNSIGNED NOT NULL DEFAULT 1,
    mode       ENUM('apart', 'together', 'both') NOT NULL DEFAULT 'both',
    is_spicy   TINYINT(1) NOT NULL DEFAULT 0,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_mode_level (mode, level)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS dare_minesweeper_compliments (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    text       TEXT NOT NULL,
    type       ENUM('sweet', 'tease') NOT NULL DEFAULT 'sweet',
    level      TINYINT UNSIGNED NOT NULL DEFAULT 1,
    mode       ENUM('apart', 'together', 'both') NOT NULL DEFAULT 'both',
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_mode_level_type (mode, level, type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;