-- SheListens — migration 013: missed-call events in the transcript
-- A missed/unanswered/declined call now leaves a visible line in the
-- session's own message thread (client-visible, not just listener
-- history) — see session/call-event.php.
-- Run via phpMyAdmin or: mysql -u USER -p DBNAME < backend/migrations/013_missed_call_events.sql

ALTER TABLE session_messages
  ADD COLUMN call_event VARCHAR(20) NULL AFTER attachment_size,
  ADD COLUMN call_video TINYINT(1) NULL AFTER call_event;