-- =====================================================================
-- AI Front Desk Platform — Migration 015
--
-- Whether this DID has completed carrier SMS registration (e.g. 10DLC
-- campaign registration) — an internal provisioning detail, same
-- category as phone_numbers.provider/connection_id. Superadmin-only,
-- both to view and to change (see public/phone-numbers.php's
-- $canSeeProvider/$canManage — this column follows that same pattern),
-- for the identical reason: a tenant has no reason to see internal
-- carrier-registration state, and there's no live sync back to the
-- carrier/OpenSIP from this portal, so a tenant flipping this by hand
-- wouldn't reflect reality.
-- =====================================================================

SET NAMES utf8mb4;

ALTER TABLE phone_numbers
    ADD COLUMN sms_registered TINYINT(1) NOT NULL DEFAULT 0
        COMMENT 'Superadmin-only. Whether this DID has completed carrier SMS registration (e.g. 10DLC). Not synced live — set by hand once registration is confirmed.'
        AFTER provider;