cakephp / phinx

    /**

     * {@inheritdoc}

     */

    public function addColumn(Table $table, Column $column)

    {

        $sql = sprintf(

            'ALTER TABLE %s ADD %s %s',

            $this->quoteTableName($table->getName()),

            $this->quoteColumnName($column->getName()),

            $this->getColumnSqlDefinition($column)

        );

        if ($column->getAfter()) {

            $sql .= ' AFTER ' . $this->quoteColumnName($column->getAfter());

        }

        $this->execute($sql);

    }

    /**

     * {@inheritdoc}

    /**

     * {@inheritdoc}

     */

    public function changeColumn($tableName, $columnName, Column $newColumn)

    {

        $after = $newColumn->getAfter() ? ' AFTER ' . $this->quoteColumnName($newColumn->getAfter()) : '';

        $this->execute(

            sprintf(

                'ALTER TABLE %s CHANGE %s %s %s%s',

                $this->quoteTableName($tableName),

                $this->quoteColumnName($columnName),

                $this->quoteColumnName($newColumn->getName()),

                $this->getColumnSqlDefinition($newColumn),

                $after

            )

        );

    }

    /**

     * {@inheritdoc}