-- Migration: Drop RM/Coordinator mark columns from zoom_analytics_attendee_summary
-- Description: RM/Coordinator attendance marks now live in program_user_attendance's append-only
--              attendance_events log (AttendanceSourceEnum.MANUAL_RM/MANUAL_COORDINATOR), resolved by
--              the existing SESSION_ATTENDANCE precedence engine — one canonical attendance table
--              instead of a duplicate set of columns here. ZoomAnalyticsFacadeService.markAttendance
--              now delegates to OnlineAttendanceService.markAttendance() instead of writing these
--              columns directly. Device count/duration/dropoff/rejoin/joinedAt/isSystemAttended stay
--              on this table — only the manual-mark columns move.
-- Idempotent — safe to re-run.

ALTER TABLE zoom_analytics_attendee_summary
  DROP COLUMN IF EXISTS rm_attendance,
  DROP COLUMN IF EXISTS rm_marked_at,
  DROP COLUMN IF EXISTS rm_marked_by,
  DROP COLUMN IF EXISTS coordinator_attendance,
  DROP COLUMN IF EXISTS coordinator_marked_at,
  DROP COLUMN IF EXISTS coordinator_marked_by;
