spiral / components

use Spiral\Migrations\Exceptions\Operations\IndexException;

use Spiral\Migrations\Operations\IndexOperation;

class DropIndex extends IndexOperation

{

    /**

     * {@inheritdoc}

     */

    public function execute(CapsuleInterface $capsule)

    {

        $schema = $capsule->getSchema($this->getDatabase(), $this->getTable());

        if (!$schema->hasIndex($this->columns)) {

            $columns = join(',', $this->columns);

            throw new IndexException(

                "Unable to drop index '{$schema->getName()}'.({$columns}), index does not exists"

            );

        }

        $schema->dropIndex($this->columns);

    }

}

use Spiral\Migrations\Exceptions\Operations\ReferenceException;

use Spiral\Migrations\Operations\ReferenceOperation;

class DropReference extends ReferenceOperation

{

    /**

     * {@inheritdoc}

     */

    public function execute(CapsuleInterface $capsule)

    {

        $schema = $capsule->getSchema($this->getDatabase(), $this->getTable());

        if (!$schema->hasForeign($this->column)) {

            throw new ReferenceException(

                "Unable to drop foreign key '{$schema->getName()}'.'{$this->column}', "

                . "foreign key does not exists"

            );

        }

        $schema->dropForeign($this->column);

    }

}