Correct DB Update for MySQL 5.5.29 and Activiti 5.15.1

[lpkchri1]

We are running MySQL 5.5.29 and Activiti 5.14 currently.

From looking at the upgrade scripts, I would assume the following would need to be run, in order:

activiti.mysql55.upgradestep.514.to.515.engine.sql
activiti.mysql55.upgradestep.514.to.515.history.sql
activiti.mysql55.upgradestep.515.to.5151.engine.sql

I am assuming that the 514.to.515 scripts would be run then the 5.151 script would need to follow, is this a correct assumption?

Also, this is the first time I have seen a difference in scripts based on the version of MySql.  (I understand this is because of a bug in the 5.15 release and MySQL 5.6.x).  If we update our MySQL version to 5.6.x after this upgrade, would we need to run any of the activiti.mysql.upgradestep scripts or otherwise modify the database tables?

Thanks for any clairification,

Kent

[trademak]

Hi,

Yes, that's a correct assumption. The 514.to.515 scripts need to be executed before 515.to.5151.
If you upgrade to MySQL 5.6.x afterwards you can run the parts of the 514.to.515 script that change the date/time columns. MySQL 5.6 is able to handle precision in time values better than 5.5.x and earlier.

Best regards,

[lpkchri1]

Thanks for the reply!

I do not have control over the database that we use and it appears that this change will fork the MySQL scripts going forward.  Do you plan on continuing to support the pre-5.6 database creation / update scripts for the foreseeable future in Activiti updates?

Thanks again,

Kent

[trademak]

Hi Kent,

We will keep supporting pre 5.6 as well. We just added better time precision for 5.6 (which is not available in pre 5.6), that's it.

Best regards,