2018121300_AddTablesMenuSequences.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 AddTablesMenuSequences extends AbstractMigration {
    public function up() {
        // Set sequence for cuquestmaster
        $sql = "CREATE SEQUENCE IF NOT EXISTS cuquestmaster_quest_id_seq;";
        $this->query($sql);

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

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

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

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

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

    public function down() {

    } // End "down" function
}