BEGIN;

DELETE FROM shipments
WHERE external_id = 'shipment-100';

DELETE FROM recovery_ledger
WHERE business_id = 'shipment-100';

COMMIT;
