OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_25_8\UpdateIndexes

Complexity

Total Complexity

3

Size/Duplication

Total Lines	24
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	up()	0	18	3

<?php

namespace OroCRM\Bundle\SalesBundle\Migrations\Schema\v1_25_8;

use Doctrine\DBAL\Schema\Schema;

use Oro\Bundle\MigrationBundle\Migration\Migration;
use Oro\Bundle\MigrationBundle\Migration\QueryBag;

class UpdateIndexes implements Migration
{
    /**
     * {@inheritdoc}
     */
    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);
        }
    }
}