2019110400_updUserEventsTitle.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 updUserEventsTitle extends AbstractMigration {

  /**
   * FD 1148, GitHub 3182, Change "Audit Member Changes Report" to "View User Events"
   */
    public function up() {

      echo "Updating CU Admin user events title.\n";
      $this->query("update cuadminprogs set displaytext = 'View User Events Report' where program = 'AuditMemChg'");
    }

    public function down() {
        // Nothing to do
    }
}