Files
call-center/migrations/sql/0013_asterisk_bridge_idempotency_sqlite.sql

7 lines
323 B
SQL

ALTER TABLE voice_events ADD COLUMN source_event_id TEXT;
CREATE UNIQUE INDEX IF NOT EXISTS ix_voice_events_source_event_id ON voice_events(source_event_id);
DROP INDEX IF EXISTS ix_call_recordings_source_event_id;
CREATE UNIQUE INDEX IF NOT EXISTS ix_call_recordings_source_event_id ON call_recordings(source_event_id);