-- =============================================================================
-- Twosome – database/migration_snakes_ladders.sql
-- Schema for Snakes & Ladders: After Dark
-- =============================================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

CREATE TABLE IF NOT EXISTS snakes_ladders_cards (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    type       ENUM('dare', 'tease', 'snake_forfeit', 'checkpoint', 'mystery', 'cheeky') NOT NULL,
    heat       ENUM('mild', 'spicy', 'wild') NOT NULL DEFAULT 'spicy',
    mode       ENUM('apart', 'together', 'both') NOT NULL DEFAULT 'both',
    title      VARCHAR(128) NOT NULL,
    text       TEXT NOT NULL,
    effect_val INT NOT NULL DEFAULT 0,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_type_heat_mode (type, heat, mode)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;