-- ============================================================================
-- Egg store transfers can now optionally name a grade (Grade A, Cracked, ...)
-- instead of always moving pooled/ungraded stock — mirrors egg_usage.grade.
-- 'mixed' (the default) behaves exactly as before: moves pooled stock without
-- attributing it to any one grade bucket.
-- ============================================================================

ALTER TABLE egg_store_transfers
  ADD COLUMN grade ENUM('gradeTwin','gradeA','gradeB','cracked','dirty','rejected','mixed') NOT NULL DEFAULT 'mixed' AFTER qty;