I’ve got a table with a column A that is PK.
I want to remove that column and create a new one, named B, that would become the PK.
I used the diffChangeLog command to automatically generate the ChangeLog and apply it on the fly (I’m creating a workflow involving reworking a DB from Hibernate code).
The changeLog propose:
- insert new column B
- add PK on B (that fails)
- drop PK on table X
Which crashs on MySQL as we can’t deal with two PK at the same time…