-- Migration: Enhance orders table for new repair intake modal
-- Adds problem_description and service_contract repair_type

ALTER TABLE orders
  ADD COLUMN problem_description TEXT DEFAULT NULL AFTER diagnosis,
  MODIFY COLUMN repair_type ENUM('warranty','paid','evaluation','service_contract') DEFAULT NULL;
