spiral / components

     * @param AbstractTable   $table

     * @param StateComparator $comparator

     */

    protected function createForeigns(AbstractTable $table, StateComparator $comparator)

    {

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

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

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

                'table'     => $this->identify($table),

            ]);

            $this->createForeign($table, $foreign);

        }

    }

    /**

     * @param AbstractTable   $table

     * @param AbstractTable   $table

     * @param StateComparator $comparator

     */

    protected function createIndexes(AbstractTable $table, StateComparator $comparator)

    {

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

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

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

                'table'     => $this->identify($table),

            ]);

            $this->createIndex($table, $index);

        }

    }

    /**

     * @param AbstractTable   $table

     * @param AbstractTable   $table

     * @param StateComparator $comparator

     */

    protected function createColumns(AbstractTable $table, StateComparator $comparator)

    {

        foreach ($comparator->addedColumns() as $column) {

            $this->log('Adding column [{statement}] into table {table}.', [

                'statement' => $column->sqlStatement($this->driver),

                'table'     => $this->identify($table),

            ]);

            $this->assertValid($column);

            $this->createColumn($table, $column);

        }

    }

    /**

     * @param AbstractTable   $table

     * @param AbstractTable   $table

     * @param StateComparator $comparator

     */

    protected function dropColumns(AbstractTable $table, StateComparator $comparator)

    {

        foreach ($comparator->droppedColumns() as $column) {

            $this->log('Dropping column [{statement}] from table {table}.', [

                'statement' => $column->sqlStatement($this->driver),

                'table'     => $this->identify($table),

            ]);

            $this->dropColumn($table, $column);

        }

    }

    /**

     * @param AbstractTable   $table

     * @param AbstractTable   $table

     * @param StateComparator $comparator

     */

    protected function dropIndexes(AbstractTable $table, StateComparator $comparator)

    {

        foreach ($comparator->droppedIndexes() as $index) {

            $this->log('Dropping index [{statement}] from table {table}.', [

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

                'table'     => $this->identify($table),

            ]);

            $this->dropIndex($table, $index);

        }

    }

    /**

     * @param AbstractTable   $table

     * @param AbstractTable   $table

     * @param StateComparator $comparator

     */

    protected function dropForeigns(AbstractTable $table, $comparator)

    {

        foreach ($comparator->droppedForeigns() as $foreign) {

            $this->log('Dropping foreign key [{statement}] from table {table}.', [

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

                'table'     => $this->identify($table),

            ]);

            $this->dropForeign($table, $foreign);

        }

    }

    /**

     * Applied to every column in order to make sure that driver support it.