-- Migration: Add tech contact fields to orders + customer_organizations for D&H license ordering
-- These fields map to Zoho Account: End_User_Technical_Contact_Name, End_User_Technical_Contact_Phone

-- Orders: add contact_phone + tech contact fields
ALTER TABLE orders
  ADD COLUMN contact_phone VARCHAR(50) DEFAULT NULL AFTER contact_email,
  ADD COLUMN tech_contact_name VARCHAR(255) DEFAULT NULL AFTER contact_phone,
  ADD COLUMN tech_contact_phone VARCHAR(50) DEFAULT NULL AFTER tech_contact_name;

-- Customer organizations: add tech contact fields (from Zoho Account)
ALTER TABLE customer_organizations
  ADD COLUMN tech_contact_name VARCHAR(255) DEFAULT NULL AFTER phone,
  ADD COLUMN tech_contact_phone VARCHAR(50) DEFAULT NULL AFTER tech_contact_name,
  ADD COLUMN tech_contact_email VARCHAR(255) DEFAULT NULL AFTER tech_contact_phone;