-- Run once in phpMyAdmin.
-- Names typed on New Transaction that are NOT saved to the master (history recording switched off) are kept on the ticket itself.
ALTER TABLE tblTransaction_Job
  ADD COLUMN truck_text VARCHAR(100) NULL,
  ADD COLUMN driver_text VARCHAR(100) NULL,
  ADD COLUMN transporter_text VARCHAR(100) NULL,
  ADD COLUMN customer_text VARCHAR(100) NULL,
  ADD COLUMN supplier_text VARCHAR(100) NULL;