OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_41_1\SetSkuColumnsOptionsToNull

Complexity

Total Complexity

1

Size/Duplication

Total Lines	18
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Importance

Changes	2
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	up()	0	12	1

<?php

namespace OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_41_1;

use Doctrine\DBAL\Schema\Schema;

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

class SetSkuColumnsOptionsToNull implements Migration
{
    /**
     * {@inheritdoc}
     */
    public function up(Schema $schema, QueryBag $queries)
    {
        $table = $schema->getTable('orocrm_magento_cart_item');
        $table->getColumn('sku')->setOptions(['notnull' => false]);

        $table = $schema->getTable('orocrm_magento_order_items');
        $table->getColumn('sku')->setOptions(['notnull' => false]);

        $table = $schema->getTable('orocrm_magento_product');
        $table->getColumn('sku')->setOptions(['notnull' => false]);
        $table->dropIndex('unq_sku_channel_id');
    }
}