-- 2026-09-13 — Freight broker "New Trip Request" (Nash): "he can choose any of
-- the dispatchers from his contact list". Saved contacts gain the
-- `dispatcher` role so a broker's book can hold carrier dispatchers next to
-- the drivers and brokers a carrier dispatcher saves (migration 0014).
alter table public.carrier_contacts drop constraint if exists carrier_contacts_role_check;
alter table public.carrier_contacts
  add constraint carrier_contacts_role_check check (role in ('driver', 'broker', 'dispatcher'));