2018090700_lnappSessionAcct.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 lnappSessionAcct extends AbstractMigration {
    public function up() {

    // ** Add the column session_account to the lnappuser table
      // ** this column will indicate the MIR information to load for a user

      // check if we already made the change
      $tableName = "lnappuser";

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

        $hasColumn = $table->hasColumn('session_account');

        // Test for the existence of the column
        if ( !$hasColumn ) {
          print "Upgrade {$tableName}.\n";

          // Add column
          $this->query("alter table $tableName add column session_account character varying");
        }
      }

    } // End "up" function.

    public function down() {
    } // End "down" function
}