2019022000_altercutronab.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 Altercutronab extends AbstractMigration {
    public function up() {

      // ** Change the description column for cutronab
        // allow null characters in the description column of cutronab 
        // which should not have an impact on the running scheduled transfers.

      $tableName = 'cutronab';
      $tableCol = 'description';

      // check if table exists - cu_scheduledtxn
      if ($this->hasTable($tableName)) {

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

          // ** Modify column to allow nulls
          $table->changeColumn($tableCol, 'string', ['null' => true, 'limit' => 255])
                ->save();

        }
      }

    }

    public function down() {
    }
}