2018040300_lnappUser.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 LnappUser extends AbstractMigration {

  /* 
   * Drop the 'user_name' column from the lnappuser table.  
   * This process assumes an empty table and will not make any data changes
   */
  public function up() {

    // Reference lnappuser table
    $tableName = "lnappuser";
    $table = $this->table( $tableName );

    // Evaluate if tables has the column 'user_name'
    $hasColumn = $table->hasColumn('user_name');

    // IF the column exists then we will be:
      // dropping the column
      // adding the column banking_user_id
    if ( $hasColumn ) {
      // announce it
      print "Migration - Upgrade $cu {$tableName}\n";

      /*
       * DROP COLUMN (user_name)
       */

      $table->removeColumn('user_name')
          ->save();

      /*
       * ADD COLUMN (banking_user_id)
       */
      $table->addColumn('banking_user_id', 'integer', array('null' => true))
            ->save();
    }
  }
}