-- Migration: Add 'partial_return' to status ENUM on product_orders table
-- Required for partial return support (returning some items while keeping others)

ALTER TABLE product_orders
  MODIFY COLUMN status ENUM('completed', 'pending', 'returned', 'partial_return', 'cancelled', 'draft')
  DEFAULT 'completed';