20200331083912_add_entity_guid_name_index_to_annotations.php

Go to the documentation of this file.

<?php

use Phinx\Db\Adapter\MysqlAdapter;
use Phinx\Migration\AbstractMigration;

class AddEntityGuidNameIndexToAnnotations extends AbstractMigration {
    
    public function change() {
        if (!$this->hasTable('annotations')) {
            return;
        }
        
        $table = $this->table('annotations');
        if ($table->hasIndexByName('entity_guid_name')) {
            return;
        }
        
        $table->addIndex(['entity_guid', 'name'], [
            'name' => 'entity_guid_name',
            'unique' => false,
            'limit' => [
                'name' => MysqlAdapter::INT_TINY,
            ],
        ]);
        
        $table->save();
    }
}