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

            kyle.miho Kyle Miho
            alberto.chaparro Alberto Chaparro
            Kiyoshi Lee Kiyoshi Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Packages

                Version Package
                7.3.7 CE GA8
                7.3.X
                7.4.0 CE GA1 DXP 7,4
                7.4.13 DXP GA1
                Master