spiral / components

        //todo: indexes and foreign keys dropped with columns (!!!!)

        if ($behaviour & self::DROP_FOREIGNS) {

            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);

            }

        }

        if ($behaviour & self::DROP_INDEXES) {

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

            }

        }

        if ($behaviour & self::DROP_INDEXES) {

            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);

            }

        }

        if ($behaviour & self::DROP_COLUMNS) {

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

            }

        }

        if ($behaviour & self::DROP_COLUMNS) {

            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);

            }

        }

        if ($behaviour & self::CREATE_COLUMNS) {

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

            }

        }

        if ($behaviour & self::CREATE_COLUMNS) {

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

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

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

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

                ]);

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

            }

        }

        if ($behaviour & self::ALTER_COLUMNS) {

            foreach ($comparator->alteredColumns() as $pair) {

            }

        }

        if ($behaviour & self::CREATE_INDEXES) {

            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);

            }

        }

        if ($behaviour & self::ALTER_INDEXES) {

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

            }

        }

        if ($behaviour & self::CREATE_FOREIGNS) {

            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);

            }

        }

        if ($behaviour & self::ALTER_FOREIGNS) {

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