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

Add companyId field to all unique indexes and primary keys

    Details

    • Type: Story
    • Status: Closed
    • Priority: Minor
    • Resolution: Discarded
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Core Infrastructure
    • Labels:
      None

      Description

      This is a requirement for most of the databases to use its physical partitioning strategy.

      These modifications shouldn't be executed for all environments, only on-demand in the following circumstances when the user:

      • Wants to activate physical partitioning
      • Has MySQL with the partition plugin available

      We will add the companyId column to all unique indexes for all environments in 7.3 since it reduces the use cases to support and it doesn't hurt to have this column at the end of the definition of unique indexes since it helps to isolate companies to avoid security issues and to support a future new feature to export/import companies.

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                brian.chan Brian Chan
                Reporter:
                alberto.chaparro Alberto Chaparro
                Recent user:
                Alberto Chaparro
                Participants of an Issue:
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package