-- =====================================================================
-- AI Front Desk Platform — Migration 012 (admin-portal-specific)
--
-- Numbered 012 deliberately — sits after the IVR codebase's own
-- migration history (001-011, including 009_appointment_capacity.sql,
-- 010_tenant_stt_vocabulary.sql, and 011_agent_talk_duration.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;
