2019061200_addMobileRDCInstruct.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 AddMobileRDCInstruct extends AbstractMigration {
    public function up() {

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

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

          // specify the columns so automatically get next sequence number
          $this->query("insert into cucmsdocs (docsname, docsdesc, docstype,
                          docsdisplaylink, docsdisplaytext, docsdefaultavail,
                          docsresponsetype, docstitle, docsmaintsection,
                          docsmaintsort, docstarget, docstargetname)
                        values ('mblRDCInstructions', 'Helpful instructions and/or notice for the user.',
                       '2', 'Y', 'Instructions', 'Y', 'N', '', 'Mobile', '65', '', '')");
          print "Inserted 'mblRDCInstructions' into cucmsdocs.\n";
        } else {
          print "docs table doesn't exist.\n";
        }
    } // End "up" function.

    public function down() {

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

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

          $this->query("delete from cucmsdocs where docsname = 'mblRDCInstructions'");
          print "Delete 'mblRDCInstructions' from cucmsdocs.\n";
        } else {
          print "docs table doesn't exist.\n";
        }
    } // End "down" function
}