2017041400_onlineActivity.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 OnlineActivity 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() {

    if (!$this->hasTable("cu_scheduledtxn"))
    {
      print "Table doesn't exist.  Nothing done.  Please run 2017033000_scheduledtxn.php first.";
    }
    else
    {
      $table= $this->table("cu_scheduledtxn");

      if (!$table->hasColumn('approved_status'))
      {
        print "Adding approved_status to table.\n";
        $this->query("alter table cu_scheduledtxn add column approved_status smallint default 0");
      }
    }
  }

  /* 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() {
    if (!$this->hasTable("cu_scheduledtxn"))
    {
      print "Table doesn't exist.  Nothing done.  Please run 2017033000_scheduledtxn.php first.";
    }
    else if (!$this->table("cu_scheduledtxn")->hasColumn('approved_status'))
    {
      $table= $this->table("cu_scheduledtxn");

      if ($table->hasColumn("approved_status"))
      {
        print "Removing approved_status from cu_scheduledtxn";
        $table->removeColumn('approved_status')->save();
      }
    }
  }
}

?>