insert into shipments (external_id, status, booked_at)
values
    ('shipment-100', 'in_transit', '2026-09-01T09:00:00Z'),
    ('shipment-101', 'booked', '2026-09-01T09:05:00Z');

insert into shipment_events (shipment_id, sequence, event_type, occurred_at)
select id, 1, 'booked', booked_at
from shipments;

insert into shipment_events (shipment_id, sequence, event_type, occurred_at)
select id, 2, 'departed', '2026-09-01T09:10:00Z'
from shipments
where external_id = 'shipment-100';

insert into recovery_ledger (sequence, external_id, committed_at)
values
    (100, 'shipment-100', '2026-09-01T09:00:00Z'),
    (101, 'shipment-101', '2026-09-01T09:05:00Z');
