2017080400_calendar.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 Calendar extends AbstractMigration {

  /* This is the process for moving forward. We are re-creating the table so if there is
   * existing data will need to create a temporary table, copy the data, drop the old table,
   * rename the temporary table.
   */
  public function up() {

    // create scheduledtxn table if it doesn't exist
    $exists = $this->hasTable("cu_calendar");

    if (!$exists) {
      $sql = "
        CREATE TABLE cu_calendar (
          cu character varying(10) NOT NULL,
          year character varying(4) NOT NULL,
          dates text NOT NULL
        );";
      $sqlRs = $this->query($sql);

      // create sequence
      $sql = "ALTER TABLE ONLY cu_calendar ADD CONSTRAINT cu_calendar_pkey PRIMARY KEY (cu, year);";
      $sqlRs = $this->query($sql);
    }
  }

  /* To execute this you need to run the following command:
   * php vendor/bin/phinx rollback (using correct path to phinx)
   * Or, to roll back to a specific time:
   * php vendor/bin/phinx rollback -t 20151123211207
   */
  public function down() {
    // drop cu_scheduledtxn table
    $this->dropTable("cu_calendar");
  }
}

?>