-- =====================================================================
-- AI Front Desk Platform — Migration 012
--
-- Freeform internal notes on a tenant — e.g. "internal test line, do
-- not hand out", "trial for Acme Heating, follow up Fri", "reset for
-- new prospect 7/22". Superadmin-only, everywhere: never selected by
-- any tenant-scoped repository method a tenant's own staff can reach,
-- and only rendered on the Platform Tenants page.
-- =====================================================================

SET NAMES utf8mb4;

ALTER TABLE tenants
    ADD COLUMN internal_notes TEXT NULL
        COMMENT 'Superadmin-only internal notes — never shown to tenant staff.'
        AFTER is_demo;