2018111300_AddCUJobsSequences.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 AddCUJobsSequences extends AbstractMigration {
    public function up() {
        // Set sequence for cutrack
        $sql = "CREATE SEQUENCE IF NOT EXISTS cutrack_track_id_seq";
        $this->query($sql);

        $sql = "SELECT pg_catalog.setval('cutrack_track_id_seq', 1, false);";
        $this->query($sql);

        // Set sequence for cutrackitem
        $sql = "CREATE SEQUENCE IF NOT EXISTS cutrackitem_trackitem_id_seq";
        $this->query($sql);

        $sql = "SELECT pg_catalog.setval('cutrackitem_trackitem_id_seq', 1, false);";
        $this->query($sql);
    } // End "up" function.

    public function down() {

    } // End "down" function
}