-- Migration: Zoom generated link — source mobile
-- Description: Adds source_mobile to zoom_generated_registrant_link so a ROLE-sourced generated
--              link stores the user's mobile number alongside their source email. Nullable
--              (placeholder rows and users without a phone number have none). Idempotent.

ALTER TABLE zoom_generated_registrant_link
    ADD COLUMN IF NOT EXISTS source_mobile VARCHAR(255) NULL;

COMMENT ON COLUMN zoom_generated_registrant_link.source_mobile IS
    'Mobile number of the source user (ROLE-sourced links); NULL for placeholder rows or users without a phone number.';
