New indexes for modules aren't added during the upgrade process

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.2 CE GA3, 7.0.0 DXP FP5, 7.0.0 DXP SP1, Master
• Fix Version/s: 7.0.0 DXP FP29, 7.0.X EE, 7.0.4 CE GA5, 7.0.0 DXP FP34, 7.0.0 DXP SP7, 7.0.5 CE GA6, 7.1.0 M1, 7.1.X, Master
• Component/s: Core Infrastructure, Core Infrastructure > Upgrade Framework
• Labels:
  • LR7UPGRADE
  • QA-F
  • liferay-digital-enterprise-70-sp5
  • liferay-digital-enterprise-70-sp7
  • liferay-fixpack-de-29-7010
  • liferay-fixpack-de-34-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.25
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/46907

Steps to reproduce it:

1. Startup a 6.2 portal so that the database is created
2. Shutdown it
3. Upgrade that database to master
4. Check indexes for JournalArticleResource table

Results: index IX_CC7576C7 doesn't exist
Expected results: IX_CC7576C7 exist

New indexes for Core are created because com.liferay.portal.events.StartupHelper.updateIndexes logic takes care of it. However for modules the indexes should be added to the update.sql file.