2018042500_adminSettingsNotAuto.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 AdminSettingsNotAuto extends AbstractMigration {
    public function up() {

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

        if ($this->hasTable($tableName)) { // This table should exist but make sure.

          // This is to prevent program from being auto-added to CUADMINEXCLUDE in cuset.pl.
          $this->query("update cuadminprogs set def_set = 1 where program = 'aAdminSettings'");

          print "Updated aAdminSettings record in cuadminprogs.";
        } else {
          print "Admin programs table doesn't exist.\n";
        }
    } // End "up" function.

    public function down() {

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

        if ($this->hasTable($tableName)) { // This table should exist but make sure.

          // This is to prevent program from being auto-added to CUADMINEXCLUDE in cuset.pl.
          $this->query("update cuadminprogs set def_set = 0 where program = 'aAdminSettings'");

          print "Updated aAdminSettings record in cuadminprogs.";
        } else {
          print "Admin programs table doesn't exist.\n";
        }
    } // End "down" function
}