-- VILLAFLOW CMS — Migration 006
-- Phase 3 — Rooms (Room Specs sub-scope)
-- Owns: the reusable icon+label spec list (e.g. "Bed Type", "Size",
-- "Capacity", "View"), self-contained within Rooms — structurally
-- similar to a Facilities master list but room-presentation-specific
-- and NOT the Facilities module (which does not exist until Phase 4).

CREATE TABLE IF NOT EXISTS room_specs (
    id            INT UNSIGNED    AUTO_INCREMENT PRIMARY KEY,
    label         VARCHAR(100)    NOT NULL,
    icon          VARCHAR(100)    NULL,
    sort_order    INT             NOT NULL DEFAULT 0,
    created_at    TIMESTAMP       NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at    TIMESTAMP       NOT NULL DEFAULT CURRENT_TIMESTAMP
                                  ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;