20171021111132_align_subtype_columns.php

Go to the documentation of this file.

<?php

use Phinx\Migration\AbstractMigration;

class AlignSubtypeColumns extends AbstractMigration {
    public function change() {

        $options = [
            'null' => false,
            'limit' => 252,
            'encoding' => "utf8",
            'collation' => "utf8_general_ci",
        ];

        $table = $this->table('river');
        $table->changeColumn('subtype', 'string', $options)->save();

        $table = $this->table('entities');
        $table->changeColumn('subtype', 'string', $options)->save();

        $table = $this->table('system_log');

        $table->removeIndexByName('river_key')->save();

        $table->changeColumn('object_subtype', 'string', $options)->save();

        $table->addIndex([
            'object_type',
            'object_subtype',
            'event'
        ], [
            'name' => "river_key",
            'unique' => false,
            'limit' => 25,
        ]);

        $table->save();
    }
}