2018100901_extendVendorCacheUsername.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 ExtendVendorCacheUsername extends AbstractMigration {
    public function up() {
        $tableName = "cu_vendorcache";
        $tableColumn = "username";
        if ($this->hasTable($tableName)) {
          $table = $this->table( $tableName );
          $hasColumn = $table->hasColumn( $tableColumn );
          if ( $hasColumn ) {
            print "Upgrade {$tableName}.\n";
            // Alter column
            $this->query("alter table $tableName alter column $tableColumn type varchar(50)");
          }
        } else {
          print "Skip $tableName, table not found.\n";
        }
    } // End "up" function.

    public function down() {
      $tableName = "cu_vendorcache";
        $tableColumn = "username";
        if ($this->hasTable($tableName)) {
          $table = $this->table( $tableName );
          $hasColumn = $table->hasColumn( $tableColumn );
          if ( $hasColumn ) {
            print "Downgrade {$tableName}.\n";
            // Alter column
            $this->query("alter table $tableName alter column $tableColumn type char(12)");
          }
        } else {
          print "Skip $tableName, table not found.\n";
        }
    } // End "down" function
}