-- =====================================================================
-- AI Front Desk Platform — Migration 011 (admin-portal-specific)
--
-- Numbered 011 deliberately — sits after the IVR codebase's own
-- migration history (001-010, including 009_appointment_capacity.sql
-- and 010_tenant_stt_vocabulary.sql, already applied on the live
-- database). This migration only adds what the admin portal itself
-- needs on top of that.
-- =====================================================================

SET NAMES utf8mb4;

-- Flags a tenant as a demo/marketing tenant rather than a real paying
-- customer. Used by the anonymous "look around" demo flow (a visitor
-- clicking a demo link on the marketing site, no login) to pick which
-- tenant's seeded data to show, and to keep demo tenants visually
-- distinguishable from real ones in the superadmin tenant list.
ALTER TABLE tenants
    ADD COLUMN is_demo TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'Marketing/demo tenant with fictional seeded data — never a real paying customer'
        AFTER max_concurrent_appointments;