OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_25_8\UpdateIndexes::up()

Complexity

Conditions	3
Paths	2

Size

Total Lines	18
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up(Schema $schema, QueryBag $queries)
    {
        $table = $schema->getTable('orocrm_sales_opportunity');
        $indexName    = 'opportunities_by_status_idx';
        $indexColumns = [
            'organization_id',
            'status_id',
            'close_revenue',
            'budget_amount',
            'created_at'
        ];
        if ($table->hasIndex($indexName) && $table->getIndex($indexName)->getColumns() !== $indexColumns) {
            $table->dropIndex($indexName);
            $table->addIndex($indexColumns, $indexName);
        } else {
            $table->addIndex($indexColumns, $indexName);
        }
    }
}