AssetListEntrySegmentsEntryRel db column mismatch on upgraded database

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.4.13 DXP U25, Master
• Fix Version/s: 7.4.3.40 CE GA40, 7.4.3.41 CE GA41, 7.4.3.42 CE GA42, Master
• Component/s: Segments Editor
• Labels:
  • QA-AUTOMATION
  • pt-upgrade-review
• Fix Priority: 3
• Git Pull Request: https://github.com/liferay-tango/liferay-portal/pull/2676
• QA Test Name:
  • LocalFile.PortalDatabaseValidationUpgrade#CompareUpgradedAndFreshDatabaseSchemas7310
• QA Test Score: 4

Steps to Reproduce:

1. Import attached 7.3.10 database to MySQL data-archive-portal-mysql.zip
2. Upgrade this database to Master (with DXP profile)
   • tools/portal-tools-db-upgrade-client/db_upgrade.sh
3. Connect Master to a different, empty database schema
4. Start master against blank database schema
5. Compare AssetListEntrySegmentsEntryRel tables between upgraded and fresh database

Expected Result:
Table indexes match between the 2 databases.

Actual Result:
"priority" column default value is different

7.3 Upgraded database:

`priority` int(11) NOT NULL DEFAULT '0'

Fresh master database:

`priority` int(11) DEFAULT NULL