2017110700_admeco.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 Admeco 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() {
    // check if we already made the change
    $table = $this->table("cuadmeco");
    $hasColumn = $table->hasColumn('accountnumber');

    if ($hasColumn)
    {
      print "Removing accountnumber column.\n";
      $this->query("alter table cuadmeco drop column accountnumber");
    }

  }

  /* To execute this you need to run the following command:
   * php vendor/bin/phinx rollback (using correct path to phinx)
   * Or, to roll back to a specific time:
   * php vendor/bin/phinx rollback -t 20151123211207
   */
  public function down() {
    // check if we already made the change
    $table = $this->table("cuadmeco");
    $hasColumn = $table->hasColumn('accountnumber');

    if (!$hasColumn)
    {
      print "Adding accountnumber column.\n";
      $this->query("alter table cuadmeco add column accountnumber character(12) not null");
    }
  }
}

?>