20260910072856_add_metadata_entity_guid_name_index.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
use Phinx\Db\Adapter\MysqlAdapter;
use Phinx\Migration\AbstractMigration;
 
final class AddMetadataEntityGuidNameIndex extends AbstractMigration {
 
    public function change(): void {
        if (!$this->hasTable('metadata')) {
            return;
        }
        
        $table = $this->table('metadata');
        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();
    }
}