cakephp / phinx

        $instructions = $this->beginAlterByCopyTable($table->getName());

        $tableName = $table->getName();

        $instructions->addPostStep(function ($state) use ($column) {

            $sql = preg_replace("/(`$column`)\s+\w+\s+((NOT )?NULL)/", '$1 INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT', $state['createSQL'], 1);

            $this->execute($sql);

            return $state;

        });

        $instructions->addPostStep(function ($state) {

            $columns = $this->fetchAll(sprintf('pragma table_info(%s)', $this->quoteTableName($state['tmpTableName'])));

            return $newState + $state;

        });

        $instructions->addPostStep(function ($state) {

            $search = "/(,?\s*PRIMARY KEY\s*\([^\)]*\)|\s+PRIMARY KEY(\s+AUTOINCREMENT)?)/";

            $sql = preg_replace($search, '', $state['createSQL'], 1);

            if ($sql) {

                $this->execute($sql);

            }

            return $state;

        });

        return $this->copyAndDropTmpTable($instructions, $table->getName());

    }