2017091500_tron2.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 Tron2 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()
    {
        $name = "cutronus";
        $tableExists = $this->hasTable( $name );

        // drop it if it exists
        if ( $tableExists ) {
            $sql = "DROP TABLE cutronus";
            $rows = $this->query( $sql );

            $tableExists = false;
        }

        if ( !$tableExists ) {
            // announce it
            print "Creating table $name\n";

            // create the SQL for the new table
            // note: sched_id is used for background scheduled transactions; accountnumber is used for background alerts
            $sql = "CREATE TABLE cutronus (
                            runslot character varying(10) NOT NULL,
                            cu character(10),
                            user_id integer NOT NULL,
                            shuffle double precision,
                            sched_id integer NOT NULL,
                            accountnumber character(12) NOT NULL,
                            PRIMARY KEY (runslot, cu, user_id, sched_id, accountnumber)
                        )";

            // create the table
            $rows = $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()
    {
        // an earlier migration file will drop all the tables
    }
}