-- Migration 042: Add meeting time and external meeting columns to engagement_snapshots

ALTER TABLE engagement_snapshots
  ADD COLUMN IF NOT EXISTS audio_duration_seconds INT DEFAULT 0,
  ADD COLUMN IF NOT EXISTS meeting_duration_seconds INT DEFAULT 0,
  ADD COLUMN IF NOT EXISTS meetings_with_external INT DEFAULT 0;