2019042200_add_cuinfo_assets_table.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;

/*
 * Belatedly adding the cuinfo_assets table
 */

class AddCuinfoAssetsTable extends AbstractMigration {
    public function up() {
        if (!$this->hasTable('cuinfo_assets')) {
            $cuinfo_assets = $this->table('cuinfo_assets', ['id' => false, 'primary_key' => ['user_name']]);
            $cuinfo_assets
                ->addColumn('user_name', 'string', ['limit' => 12])
                ->addColumn('dec_31_assets', 'decimal', ['precision' => 4, 'scale' => 1])
                ->create();
        }
    }

    public function down() {
        if ($this->hasTable('cuinfo_assets')) {
            $cuinfo_assets = $this->table('cuinfo_assets');
            $cuinfo_assets
                ->drop()
                ->save();
        }
    }
}