2017111000_fixcurdcstatus.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 fixcurdcstatus extends AbstractMigration {

  /*
   * add the column 'user_id' to curdcstatus table.
   */

public function up() {

    if (!$this->hasTable("curdcstatus"))
    {
      print "Table doesn't exist.  Nothing done.";
    }
    else
    {
      $table= $this->table('curdcstatus');

      if (!$table->hasColumn('user_id'))
      {
        print "Adding user_id to table.\n";
    $this->query('DROP table curdcstatus');
    $sql = "CREATE TABLE curdcstatus (
            depositid integer NOT NULL,
            cu character(12) NOT NULL,
            user_id integer NOT NULL,
            accountnumber character(12) NOT NULL,
            rdcvendor character varying(20) NOT NULL,
            starttime timestamp with time zone DEFAULT now() NOT NULL,
            lastupdate timestamp with time zone DEFAULT now() NOT NULL,
            frontpath character varying(100),
            frontaccept character(1),
            backpath character varying(100),
            backaccept character(1),
            amount numeric(11,2),
            amountaccept character(1),
            acctid character varying(100),
            status character varying,
            vendorinfo character varying
        );";

    $this->query("$sql");
    $sql = "CREATE SEQUENCE curdcstatus_depositid_seq
        START WITH 1
        INCREMENT BY 1
        NO MINVALUE
        NO MAXVALUE
        CACHE 1;";
    $this->query("$sql");
    $this->query("ALTER SEQUENCE curdcstatus_depositid_seq OWNED BY curdcstatus.depositid;");
    $this->query("ALTER TABLE ONLY curdcstatus ALTER COLUMN depositid SET DEFAULT nextval('curdcstatus_depositid_seq'::regclass);");
    $this->query("ALTER TABLE ONLY curdcstatus ADD CONSTRAINT curdcstatus_pkey PRIMARY KEY (depositid);");
      }
    }
  }


  /* 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() {

    if (!$this->hasTable("curdcstatus"))
    {
      print "Table doesn't exist.  Nothing done.";
    }
    else
    {
      $table= $this->table('curdcstatus');

      if ($table->hasColumn('user_id'))
      {
        print "Dropping user_id from table.\n";
    $table->removeColumn('user_id')
              ->save();
      }
    }
  }
}

?>