To add new column to table follow this steps:
- write the sql statement
- test it in workbench
- add it to sprint x->new.sql
- add the rollback statement that removes the column to sprint x->rollback.sql
- edit the corresponding XXX_init.sql, so that once init runs, it will not be confused with new column
Small hint:
How to copy data from one column to another:
update TABLE set destinationColumn=copyFromColumn;
for this to work remove the safe update from workbench settings.
Edit->Preferences->SQL editor, untick safe updates, reconnect to db