7 lines
330 B
MySQL
7 lines
330 B
MySQL
|
-- 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;
|