Execute custom SQL during Activiti DB table creation

[thilo_ginkel]

I am looking for a way to add a custom SQL snippet to Activiti's the database schema creation to create a custom index on one of Activiti's tables.

Is there a way to accomplish this from the application that embeds Activiti without modifying the Activiti source (e.g., though some hook mechanism)?

Thanks for your support!

[jbarrez]

No, not without modifying the source.
But if it is only an index, it is easy to just add it after the tables have been created for the first time?

[thilo_ginkel]

But if it is only an index, it is easy to just add it after the tables have been created for the first time?

Well, yes, that would be an option with the added difficulty that the application's database scripts run before Activiti is started for the first time, i.e., Activiti's tables will not have been created yet at that point.

[ronald_van_kuij]

Then run an additional one after the Activiti tables have been created 😉