20190606111641_entities_add_type_subtype_container_and_owner_indexes.php

Go to the documentation of this file.

<?php

use Phinx\Migration\AbstractMigration;

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

        if (!$table->hasIndexByName('type_subtype_container')) {
            $table->addIndex(['type', 'subtype', 'container_guid'], [
                'name' => "type_subtype_container",
                'unique' => false,
                'limit' => ['subtype' => 50],
            ]);
        }
        
        $table->update();
    }
}