-- Session external ids are only unique within a user's service namespace. DROP INDEX IF EXISTS mission_service_sessions_external_idx; CREATE UNIQUE INDEX IF NOT EXISTS mission_service_sessions_external_idx ON mission_service_sessions(user_id, service_id, external_id);