-- Brings the live pre-chat form's captured fields in line with the offline contact form
-- (Zip Code, Order Number, Subject), so both forms collect the same information.
ALTER TABLE chat_sessions
  ADD COLUMN zip_code VARCHAR(16) NULL AFTER visitor_reason,
  ADD COLUMN order_number VARCHAR(64) NULL AFTER zip_code,
  ADD COLUMN subject VARCHAR(255) NULL AFTER order_number;