Category: Data persistance

To add new column to table follow this steps:

1. write the sql statement
2. test it in workbench
3. add it to sprint x->new.sql
4. add the rollback statement that removes the column to sprint x->rollback.sql
5. 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