-- v7.4 orders flow fields
ALTER TABLE orders 
  ADD COLUMN IF NOT EXISTS receipt_file_id VARCHAR(255) NULL,
  ADD COLUMN IF NOT EXISTS buyer_location_lat DOUBLE NULL,
  ADD COLUMN IF NOT EXISTS buyer_location_lon DOUBLE NULL,
  ADD COLUMN IF NOT EXISTS buyer_address TEXT NULL,
  ADD COLUMN IF NOT EXISTS shipped_at DATETIME NULL,
  ADD COLUMN IF NOT EXISTS delivered_at DATETIME NULL,
  ADD COLUMN IF NOT EXISTS completed_at DATETIME NULL;

-- status values used:
-- pending_payment, pending_seller_approval, accepted, ready_to_ship, shipped, delivered, completed, rejected, cancelled
