2018041700_addPinCustomContent.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 AddPinCustomContent 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.

          // Need to update the sequence.  This will not be needed on DEV.  Initial data will be updated.  However, if ever the custom content is added on production, it will need to be corrected.
          $this->query("select setval('cucmsdocs_docsid_seq', 1000, true)");
          // Set the sequence to a big number.  It will never be used in production but when adding custom content just change the number to the next in the list.

          $this->query("insert into cucmsdocs values ('66', 'ActivateMemberPin', 'Used to gather information from the member to activate. Note: Certain form fields are required as named.',
                       '3', '', '', 'Y', 'N', 'ACTIVATE ACCOUNT PIN', 'Member Forms', '15', '', '')");
          print "Inserted 'ActivateMemberPin' into cucmsdocs.";
        } 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 docsid = 66");
          print "Delete 'ActivateMemberPin' from cucmsdocs.";
        } else {
          print "docs table doesn't exist.\n";
        }
    } // End "down" function
}