-- Migration: Capture Zoom's reported display name
-- Description: Zoom's participant_joined/left webhook carries participant.user_name — the name
--              the attendee actually joined as, which can differ from (or be updated ahead of)
--              our own registration record's full_name. Adds zoom_display_name to the append-only
--              live event log (per-event capture) and to the attendee summary (holds the latest
--              name seen for that seeker). full_name is untouched — it stays sourced from our own
--              registration record; zoom_display_name is purely additive, for comparison/audit.
-- Idempotent — safe to re-run.

ALTER TABLE zoom_analytics_live_event
  ADD COLUMN IF NOT EXISTS zoom_display_name VARCHAR(255);

ALTER TABLE zoom_analytics_attendee_summary
  ADD COLUMN IF NOT EXISTS zoom_display_name VARCHAR(255);
