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

7 lines
344 B
SQL

ALTER TABLE voice_events ADD COLUMN IF NOT EXISTS source_event_id VARCHAR(64);
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);