-- Supports the shipment page's source-branch/on-shelf filter and batched
-- available-quantity lookup by product code.
ALTER TABLE items
  ADD INDEX idx_items_ship_product_search (
    current_location_id,
    shelf_status,
    product_code
  );
