Ability to change column type

[AramLoosman]

Is your feature request related to a problem? Please describe.

I have created a table and wanted to change the ownership to another user. Since I did not find a way to do so, I've exported the data to csv and imported it as the other user. My boolean values Yes/No were switched to 1/0 and I am unable to change them back to a proper Boolean (with Checkmark in the Frontend).

I think this might affect other column types as well since csv wont be able to save additional info on the column.

Describe the solution you'd like

The ability to change from one column-type to another. Of course this needs to warn about possible data loss and/or be selective about which type change is possible (i.e. number to text, text to number)

Describe alternatives you've considered

I could just create another column and manually enter the correct value there, but this is not feasible for more than a couple of entries.

Additional context

No response

[datenangebot]

Hi,

thanks for your issue.

First: If you create the columns with the correct column types before importing, the 1/0 would parsed as expected.

Besides that: There is an option to change the ownership of a table as an admin via occ: occ tables:owner <ID>

Nevertheless this is a nice enhancement that I like to put on the roadmap.

[beckchin28]

This is a great feature we need.

[baditaflorin]

This would be so useful, would love to see this implemented