Summary
Consider unification of DB upgrade script in community and midstream.
Ensure we can migrate to 1.34.0 fro GA without data loss and issues

Scripts in community:
[2] https://github.com/apache/incubator-kie-kogito-apps/tree/main/data-index/data-index-storage/data-index-storage-postgresql/src/main/resources/db/migration
[3] https://github.com/apache/incubator-kie-kogito-apps/tree/main/jobs-service/jobs-service-postgresql-common/src/main/resources/db/jobs-service
[4] https://github.com/apache/incubator-kie-kogito-runtimes/tree/main/addons/common/persistence/jdbc/src/main/resources/db/postgresql

Consider JBPM upgrade scripts form legacy community.