2018022200_vendorCodeChange.php

<?php
/* Notes:
 * 1. Anything complicated needs to be done with SQL.
 * 2. Always have a check to know if the migration needs to occur (up or down).
 * 3. Use up() and down(), not change(), because of the SQL
 */
use Phinx\Migration\AbstractMigration;

class VendorCodeChange extends AbstractMigration {

  /* This is the process for moving forward. We are re-creating the table so if there is
   * existing data will need to create a temporary table, copy the data, drop the old table,
   * rename the temporary table.
   */
  public function up() {
      // Update cuvendor records
      $this->query("update cuvendors set vendor = 'CUPRODIGY', venddesc = 'CUPRODIGY', vendvar = 'CUPRODIGY' where vendor = 'CUDP'");

      // Update cuinfo records
      $this->query("update cuinfo set vendor = 'CUPRODIGY' where vendor = 'CUDP'");
  }

}