Clean up legacy indexes and code which avoids enabling data partitioning

• Type: Technical Task
• Status: Closed
• Priority: Minor
• Resolution: Completed
• Affects Version/s: None
• Fix Version/s: None
• Component/s: Core Infrastructure
• Labels:
  • pt-upgrade-review
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/81754

The following indexes were replaced for others but not removed:
create unique index IX_71A0231C on AssetEntryUsage (assetEntryId, plid, containerType, containerKey[$COLUMN_LENGTH:200$]); (LPS-93595)
create unique index IX_62913C70 on FragmentEntry (groupId, fragmentCollectionId, fragmentEntryKey[$COLUMN_LENGTH:75$]); (LPS-77816)

And we added an incorrect upgrade process for DLFileVersionPreview in LPS-79756

We need to get rid of them before applying Data Partitioning

Results after this:
Those indexes don't exist anymore and we don't get traces regarding upgrades for DLFileVersionPreview on startup