spiral / components

     *

     * @return self

     */

    protected function synchroniseIndexes(): AbstractTable

    {

        foreach ($this->comparator->addedIndexes() as $index) {

            $this->logger()->debug('Adding index [{statement}] into table {table}.', [

                'statement' => $index->sqlStatement(),

                'table'     => $this->getName(true),

            ]);

            $this->commander->addIndex($this, $index);

        }

        foreach ($this->comparator->alteredIndexes() as $pair) {

            /**

             * @var AbstractIndex $initial

             * @var AbstractIndex $current

             */

            list($current, $initial) = $pair;

            $this->logger()->debug('Altering index [{statement}] to [{new}] in table {table}.', [

                'statement' => $initial->sqlStatement(),

                'new'       => $current->sqlStatement(),

                'table'     => $this->getName(true),

            ]);

            $this->commander->alterIndex($this, $initial, $current);

        }

        return $this;

    }

    /**

     * Drop needed foreign keys.

     *

     * @return self

     */

    protected function synchroniseForeigns(): AbstractTable

    {

        foreach ($this->comparator->addedForeigns() as $foreign) {

            $this->logger()->debug('Adding foreign key [{statement}] into table {table}.', [

                'statement' => $foreign->sqlStatement(),

                'table'     => $this->getName(true),

            ]);

            $this->commander->addForeign($this, $foreign);

        }

        foreach ($this->comparator->alteredForeigns() as $pair) {

            /**

             * @var AbstractReference $initial

             * @var AbstractReference $current

             */

            list($current, $initial) = $pair;

            $this->logger()->debug('Altering foreign key [{statement}] to [{new}] in {table}.', [

                'statement' => $initial->sqlStatement(),

                'table'     => $this->getName(true),

            ]);

            $this->commander->alterForeign($this, $initial, $current);

        }

        return $this;

    }

    /**

     * Driver specific column schema.