2018100200_ExtendCutronAHCheckNum.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 ExtendCutronAHCheckNum extends AbstractMigration {
    public function up() {
        $tableName = "cutronah";
        $tableColumn = "checknumber";

        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 char(9)");
          }
        } else {
          print "Skip $tableName, table not found.\n";
        }
    } // End "up" function.

    public function down() {
      $tableName = "cutronah";
        $tableColumn = "checknumber";

        if ($this->hasTable($tableName)) {
          $table = $this->table( $tableName );

          $hasColumn = $table->hasColumn( $tableColumn );

          if ( $hasColumn ) {
            print "Not downgrading {$tableName}.\n";

            // Alter column
//            $this->query("alter table $tableName alter column $tableColumn type char(6)");
          }
        } else {
          print "Skip $tableName, table not found.\n";
        }
    } // End "down" function
}