Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-134918

Role column constraints differ on upgraded database

Description

    Steps to Reproduce:

    1. Import attached 7.2.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 Role_, UserGroupRole tables between upgraded and fresh database

    Expected Result:
    Column constraints match between the 2 databases.

    Actual Result:
    Upgraded database has some different column constraints.

    Differences (compared with sql dumps)

    Table Upgraded DB Fresh Master DB
    UserGroupGroupRole
    `groupId` bigint(20) NOT NULL
    `roleId` bigint(20) NOT NULL 
    `userGroupGroupRoleId` bigint(20) NOT NULL DEFAULT '0'
    `userGroupId` bigint(20) NOT NULL 
    
    `groupId` bigint(20) DEFAULT NULL
    `roleId` bigint(20) DEFAULT NULL
    `userGroupGroupRoleId` bigint(20) NOT NULL
    `userGroupId` bigint(20) DEFAULT NULL
    
    UserGroupRole
    `groupId` bigint(20) NOT NULL
    `roleId` bigint(20) NOT NULL
    `userGroupRoleId` bigint(20) NOT NULL DEFAULT '0'
    `userId` bigint(20) NOT NULL
    
    `groupId` bigint(20) DEFAULT NULL
    `roleId` bigint(20) DEFAULT NULL
    `userGroupRoleId` bigint(20) NOT NULL
    `userId` bigint(20) DEFAULT NULL
    

    Slimmed down database dumps also attached
    fresh-master-sorted.sql upgraded-7210-sorted.sql

    Attachments

      Issue Links

        Activity

          People

            support-lep@liferay.com SE Support
            victor.ware Victor Ware
            Felipe Lins Felipe Lins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              1 year, 20 weeks, 6 days ago

              Packages

                Version Package