2018100900_addWebContractFields.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 AddWebContractFields extends AbstractMigration {
    public function up() {
      $tableName = "cuinfo";
      $tableColumnExpires = "web_contract_expires";
      $tableColumnTerm = "web_renewal_term";

      if ($this->hasTable($tableName)) {
        // Add web contract columns if they do not already exist
        $table = $this->table($tableName);
        if (!$table->hasColumn($tableColumnExpires)) {
          $this->query("ALTER TABLE $tableName ADD COLUMN $tableColumnExpires date;");
        } 

        if (!$table->hasColumn($tableColumnTerm)) {
          $this->query("ALTER TABLE $tableName ADD COLUMN $tableColumnTerm integer;");
        } 
      } else {
        print "Skip $tableName, table not found.\n";
      }
    } // End "up" function.
    public function down() {
      $tableName = "cuinfo";
      $tableColumnExpires = "web_contract_expires";
      $tableColumnTerm = "web_renewal_term";

      if ($this->hasTable($tableName)) {
        // Add web contract columnsif they do not already exist
        $table = $this->table($tableName);
        if ($table->hasColumn($tableColumnExpires)) {
          $this->query("ALTER TABLE $tableName DROP COLUMN $tableColumnExpires;");
        } 

        if ($table->hasColumn($tableColumnTerm)) {
          $this->query("ALTER TABLE $tableName DROP COLUMN $tableColumnTerm;");
        } 
      } else {
        print "Skip $tableName, table not found.\n";
      }
    } // End "down" function
}