-- Migration 047: Add after-hours message tracking to engagement snapshots
-- Counts Teams messages sent by the employee between 5:30 PM and 7:00 AM UTC.
-- Populated during sync if the Azure AD app has the Chat.Read.All permission.

ALTER TABLE engagement_snapshots
  ADD COLUMN IF NOT EXISTS after_hours_messages INT DEFAULT 0;