-- Migration: Add 'transfer' to stock_histories type enum
-- Date: 2026-02-06
-- Purpose: Track stock transfer movements in history

ALTER TABLE stock_histories
MODIFY COLUMN type ENUM('initial', 'adjustment', 'sale', 'return', 'purchase', 'transfer') DEFAULT 'adjustment';