BEGIN;

INSERT INTO shipments (
    external_id,
    status,
    price_cents,
    destination_postal,
    booked_at
) VALUES (
    'shipment-102',
    'booked',
    2399,
    '90100',
    '2026-08-01T10:05:00Z'
);

INSERT INTO shipment_events (
    shipment_id,
    event_sequence,
    kind,
    occurred_at
)
SELECT id, 1, 'booked', '2026-08-01T10:05:00Z'
FROM shipments
WHERE external_id = 'shipment-102';

INSERT INTO recovery_ledger (sequence, business_id, kind, committed_at)
VALUES (102, 'shipment-102', 'shipment_booked', '2026-08-01T10:05:00Z');

COMMIT;
