20190125082345_entities_add_type_subtype_index.php

Go to the documentation of this file.

<?php

use Phinx\Migration\AbstractMigration;

class EntitiesAddTypeSubtypeIndex extends AbstractMigration {
    public function change() {
        $table = $this->table('entities');
        if ($table->hasIndexByName('type_subtype')) {
            return;
        }
        
        $table->addIndex(['type', 'subtype'], [
            'name' => "type_subtype",
            'unique' => false,
            'limit' => 50,
        ]);
        
        $table->update();
    }
}