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

Make instance's database schema independent when removing a company

    Details

      Description

      We will execcute the following logic when removing a company only when database partitioning is enabled:

      1- Disable the company (we need to use the service API or headless)
      2- Remove Control tables Views (SQL)
      3- Copy control tables to the schema (SQL)
      4- Remove company from the main instance (API or headless)
      5- Remove records from other instances for company, virtualhost and portlet (SQL)
      6- Schema ready to be moved (Using mySQL tools, faster and no errors) -> I wouldn't use the copy tables we had to migrate between databases since it's more difficult to mantain and it's slower.

        Attachments

          Activity

            People

            Assignee:
            kyle.miho Kyle Miho
            Reporter:
            alberto.chaparro Alberto Chaparro
            Recent user:
            Rafaela Nascimento
            Participants of an Issue:
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                7.3.X
                7.4.0 CE GA1
                Master