-- B2: a Workspace trip has one carrier and one Synchron order number.
-- Stop if older data has multiple bindings; review it rather than deleting any.
do $$
begin
  if exists (
    select 1 from public.trip_order_numbers
    group by trip_id having count(*) > 1
  ) then
    raise exception 'trip_order_numbers has trips with multiple orders; review those rows before applying 0057';
  end if;
end $$;

create unique index if not exists trip_order_numbers_one_order_per_trip
  on public.trip_order_numbers (trip_id);
