-- shipping_info 新增"本次发货数量"字段，支持部分发货
ALTER TABLE shipping_info
    ADD COLUMN quantity DECIMAL(18, 2) NULL COMMENT '本次发货数量' AFTER sales_ledger_product_id;

-- 历史数据回填：存量发货单按对应产品行数量回填
UPDATE shipping_info si
    LEFT JOIN sales_ledger_product slp ON si.sales_ledger_product_id = slp.id
SET si.quantity = slp.quantity
WHERE si.quantity IS NULL;
