XF 2.0 Rename and change column details

[Jake B.]

In the SchemaManager there is a 'renameColumn' and 'changeColumn' function, but there doesn't seem to be a way to do both at the same time. In fact, I can't even do both within the same alterTable callback like this:

$schemaManager->alterTable('xf_table', function(\XF\Db\Schema\Alter $table) {
    $table->renameColumn('old_column', 'new_column');
    $table->changeColumn('new_column', 'bool')->setDefault(1);
});

I just get this error: Column definition 'new_column' does not exist therefore it cannot be changed.

However, if I split it into two separate alters it seems to work:

$schemaManager->alterTable('xf_table', function(\XF\Db\Schema\Alter $table) {
    $table->renameColumn('old_column', 'new_column');
});
$schemaManager->alterTable('xf_table', function(\XF\Db\Schema\Alter $table) {
    $table->changeColumn('new_column', 'bool')->setDefault(1);
});

Just seems a bit convoluted, and there likely should be a way to do it all at once (unless I'm missing something and this is already possible)

 

[Jake B.]

Actually, turns out I could do:

$table->renameColumn('old_column', 'new_column')->type('bool')->setDefault(1);

 

[Chris D]

I think you can do changeColumn()->renameTo() as well.