-- Phase 4: two-step transfers (pending → received). Existing rows represent
-- completed instant transfers, so the column DEFAULTs to 'received'; the send
-- path explicitly sets 'pending'. Additive/non-breaking.

ALTER TABLE `stock_transfers` ADD COLUMN `status` ENUM('pending','received','cancelled') NOT NULL DEFAULT 'received';
ALTER TABLE `stock_transfers` ADD COLUMN `received_by` BIGINT NULL DEFAULT NULL;
ALTER TABLE `stock_transfers` ADD COLUMN `received_at` DATETIME NULL DEFAULT NULL;