begin;
insert into shipments (external_id, status, booked_at)
values ('shipment-102', 'booked', '2026-09-01T09:20:00Z');
insert into shipment_events (shipment_id, sequence, event_type, occurred_at)
select id, 1, 'booked', booked_at
from shipments
where external_id = 'shipment-102';
insert into recovery_ledger (sequence, external_id, committed_at)
values (102, 'shipment-102', '2026-09-01T09:20:00Z');
commit;
