-- Phase 4: capture the batch attributes that moved, so the destination can be
-- credited as a faithful batch (preserving expiry/cost/batch) on receipt. One
-- transfer item row per source batch consumed. Additive/nullable.

ALTER TABLE `stock_transfer_items` ADD COLUMN `expiry_date` DATE NULL DEFAULT NULL;
ALTER TABLE `stock_transfer_items` ADD COLUMN `cost` DECIMAL(11,2) NULL DEFAULT NULL;
ALTER TABLE `stock_transfer_items` ADD COLUMN `batch_number` VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE `stock_transfer_items` ADD COLUMN `source_stock_id` BIGINT NULL DEFAULT NULL;