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

      1. fresh-master-sorted.sql
        439 kB
        Victor Ware
      2. upgraded-7210-sorted.sql
        445 kB
        Victor Ware

        Issue Links

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            victor.ware Victor Ware
            Participants of an Issue:
            Recent user:
            Felipe Lins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Days since last comment:
              1 year, 4 weeks, 1 day ago

                Packages

                Version Package