ALTER TABLE transactions ADD COLUMN parent_transaction_ref VARCHAR(32) NULL AFTER transaction_ref;