Service builder making index changes on 7.3.x

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.3.X
• Fix Version/s: 7.0.0 DXP FP96, 7.0.10.15 DXP SP15, 7.0.X, 7.1.10 DXP FP20, 7.1.10.5 SP5, 7.1.X, 7.2.X, 7.3.10 DXP FP1, 7.3.10.1 DXP SP1, 7.3.6 CE GA7, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Core Infrastructure > Service Builder
• Labels:
  • liferay-dxp-70-sp15
  • liferay-dxp-71-sp5
  • liferay-dxp-73-sp1
  • liferay-fixpack-de-96-7010
  • liferay-fixpack-dxp-1-7310
  • liferay-fixpack-dxp-20-7110
  • liferay-fixpack-dxp-9-7210
• Branch Version/s:
  7.2.x, 7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Git Pull Request: https://github.com/petershin/liferay-portal/pull/1256
• Bug Type: Regression Bug

Steps to Reproduce:

1. Fetch 7.3.x from https://github.com/brianchandotcom/liferay-portal-ee
2. Run ant setup-profile-dxp
3. Run ant build-services from portal-impl/

Expected Result:
No changes made by Service Builder.

Actual Result:
Service builder making changes to re-add indexes removed in LPS-121714

     [echo] diff --git a/modules/apps/commerce/commerce-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/commerce/commerce-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] index 0ab0215ef21ee..79a0da3e1c544 100644
     [echo] --- a/modules/apps/commerce/commerce-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] +++ b/modules/apps/commerce/commerce-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] @@ -68,6 +68,7 @@ create index IX_DB0BB83C on CommerceShipmentItem (groupId);
     [echo]  create index IX_42E5F6EF on CommerceShippingMethod (groupId, active_);
     [echo]  create unique index IX_C4557F93 on CommerceShippingMethod (groupId, engineKey[$COLUMN_LENGTH:75$]);
     [echo]  
     [echo] +create unique index IX_BE881965 on CommerceSubscriptionEntry (CPInstanceUuid[$COLUMN_LENGTH:75$], CProductId, commerceOrderItemId);
     [echo]  create unique index IX_D7D137B1 on CommerceSubscriptionEntry (commerceOrderItemId);
     [echo]  create index IX_43E6F382 on CommerceSubscriptionEntry (companyId, userId);
     [echo]  create index IX_B99DE058 on CommerceSubscriptionEntry (groupId, companyId, userId);
     [echo] diff --git a/modules/apps/depot/depot-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/depot/depot-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] index 0303d2678c2d2..a0d3b1bf8c5ea 100644
     [echo] --- a/modules/apps/depot/depot-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] +++ b/modules/apps/depot/depot-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] @@ -3,6 +3,7 @@ create unique index IX_DA8D9ACC on DepotAppCustomization (depotEntryId, portletI
     [echo]  
     [echo]  create unique index IX_884D6226 on DepotEntry (groupId);
     [echo]  create index IX_FBDFFFF8 on DepotEntry (uuid_[$COLUMN_LENGTH:75$], companyId);
     [echo] +create unique index IX_8AD8247A on DepotEntry (uuid_[$COLUMN_LENGTH:75$], groupId);
     [echo]  
     [echo]  create index IX_F329B161 on DepotEntryGroupRel (ddmStructuresAvailable, toGroupId);
     [echo]  create unique index IX_65D34444 on DepotEntryGroupRel (depotEntryId, toGroupId);
     [echo] diff --git a/modules/apps/document-library-opener/document-library-opener-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/document-library-opener/document-library-opener-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] index a07a3c00e7595..0cbc618e9caa0 100644
     [echo] --- a/modules/apps/document-library-opener/document-library-opener-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] +++ b/modules/apps/document-library-opener/document-library-opener-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] @@ -1 +1,2 @@
     [echo] -create unique index IX_54148667 on DLOpenerFileEntryReference (fileEntryId);
     [echo] \ No newline at end of file
     [echo] +create unique index IX_54148667 on DLOpenerFileEntryReference (fileEntryId);
     [echo] +create unique index IX_6B9E4A66 on DLOpenerFileEntryReference (referenceType[$COLUMN_LENGTH:75$], fileEntryId);
     [echo] \ No newline at end of file
     [echo] diff --git a/modules/apps/document-library/document-library-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/document-library/document-library-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] index 4494b5f09e546..ef8a9569ee2a3 100644
     [echo] --- a/modules/apps/document-library/document-library-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] +++ b/modules/apps/document-library/document-library-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] @@ -1,3 +1,4 @@
     [echo]  create index IX_D5ED40C5 on DLFileVersionPreview (fileEntryId, ctCollectionId);
     [echo]  create unique index IX_DA3FFE on DLFileVersionPreview (fileEntryId, fileVersionId, ctCollectionId);
     [echo] +create unique index IX_ACBD78C8 on DLFileVersionPreview (fileEntryId, fileVersionId, previewStatus, ctCollectionId);
     [echo]  create index IX_3A1CF42B on DLFileVersionPreview (fileVersionId, ctCollectionId);
     [echo] \ No newline at end of file
     [echo] diff --git a/modules/apps/journal/journal-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/journal/journal-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] index c6f45fe31acfe..52d930533a2fa 100644
     [echo] --- a/modules/apps/journal/journal-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] +++ b/modules/apps/journal/journal-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] @@ -37,6 +37,8 @@ create unique index IX_4D5E99B9 on JournalArticle (uuid_[$COLUMN_LENGTH:75$], gr
     [echo]  
     [echo]  create index IX_E69312A1 on JournalArticleLocalization (articlePK, ctCollectionId);
     [echo]  create unique index IX_5593D868 on JournalArticleLocalization (articlePK, languageId[$COLUMN_LENGTH:75$], ctCollectionId);
     [echo] +create unique index IX_9B44D13C on JournalArticleLocalization (companyId, articlePK, languageId[$COLUMN_LENGTH:75$], ctCollectionId);
     [echo] +create unique index IX_97DC9F36 on JournalArticleLocalization (companyId, articlePK, title[$COLUMN_LENGTH:400$], languageId[$COLUMN_LENGTH:75$], ctCollectionId);
     [echo]  create index IX_429AC23C on JournalArticleLocalization (ctCollectionId);
     [echo]  
     [echo]  create index IX_B332E3F1 on JournalArticleResource (ctCollectionId);
     [echo] diff --git a/modules/apps/knowledge-base/knowledge-base-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/knowledge-base/knowledge-base-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] index 16d2a9cf5f34a..b09e381f3beda 100644
     [echo] --- a/modules/apps/knowledge-base/knowledge-base-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] +++ b/modules/apps/knowledge-base/knowledge-base-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] @@ -16,6 +16,7 @@ create index IX_2B6103F2 on KBArticle (parentResourcePrimKey, status);
     [echo]  create index IX_5FEF5F4F on KBArticle (resourcePrimKey, groupId, latest);
     [echo]  create index IX_8EF92E81 on KBArticle (resourcePrimKey, groupId, main);
     [echo]  create index IX_49630FA on KBArticle (resourcePrimKey, groupId, status);
     [echo] +create unique index IX_B5B6C674 on KBArticle (resourcePrimKey, groupId, version);
     [echo]  create index IX_A9E2C691 on KBArticle (resourcePrimKey, latest);
     [echo]  create index IX_69C17E43 on KBArticle (resourcePrimKey, main);
     [echo]  create index IX_4E89983C on KBArticle (resourcePrimKey, status);
     [echo] diff --git a/modules/apps/layout/layout-seo-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/layout/layout-seo-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] index f9b3a8e65c9e9..f3632037d635a 100644
     [echo] --- a/modules/apps/layout/layout-seo-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] +++ b/modules/apps/layout/layout-seo-service/src/main/resources/META-INF/sql/indexes.sql
     [echo] @@ -3,4 +3,5 @@ create index IX_D9211E39 on LayoutSEOEntry (uuid_[$COLUMN_LENGTH:75$], companyId
     [echo]  create unique index IX_429DDEFB on LayoutSEOEntry (uuid_[$COLUMN_LENGTH:75$], groupId);
     [echo]  
     [echo]  create unique index IX_6E43ACCA on LayoutSEOSite (groupId);
     [echo] -create index IX_24696DD4 on LayoutSEOSite (uuid_[$COLUMN_LENGTH:75$], companyId);
     [echo] \ No newline at end of file
     [echo] +create index IX_24696DD4 on LayoutSEOSite (uuid_[$COLUMN_LENGTH:75$], companyId);
     [echo] +create unique index IX_C75B5956 on LayoutSEOSite (uuid_[$COLUMN_LENGTH:75$], groupId);
     [echo] \ No newline at end of file
     [echo] diff --git a/sql/indexes.sql b/sql/indexes.sql
     [echo] index 860da958061d6..f2bd08071007e 100644
     [echo] --- a/sql/indexes.sql
     [echo] +++ b/sql/indexes.sql
     [echo] @@ -209,11 +209,13 @@ create index IX_BD3CB13A on Group_ (classNameId, groupId, companyId, parentGroup
     [echo]  create index IX_8B5402E5 on Group_ (companyId, active_, ctCollectionId);
     [echo]  create unique index IX_504CABF5 on Group_ (companyId, classNameId, classPK, ctCollectionId);
     [echo]  create index IX_2442742A on Group_ (companyId, classNameId, ctCollectionId);
     [echo] +create unique index IX_B894AE04 on Group_ (companyId, classNameId, liveGroupId, groupKey[$COLUMN_LENGTH:150$], ctCollectionId);
     [echo]  create index IX_B7EBDBB2 on Group_ (companyId, classNameId, parentGroupId, ctCollectionId);
     [echo]  create index IX_A67A0AA5 on Group_ (companyId, classNameId, site, ctCollectionId);
     [echo]  create index IX_286EE120 on Group_ (companyId, ctCollectionId);
     [echo]  create unique index IX_9A7D6AD0 on Group_ (companyId, friendlyURL[$COLUMN_LENGTH:255$], ctCollectionId);
     [echo]  create unique index IX_BE219CF4 on Group_ (companyId, groupKey[$COLUMN_LENGTH:150$], ctCollectionId);
     [echo] +create unique index IX_94AE0C4E on Group_ (companyId, liveGroupId, groupKey[$COLUMN_LENGTH:150$], ctCollectionId);
     [echo]  create index IX_A20523FC on Group_ (companyId, parentGroupId, ctCollectionId);
     [echo]  create index IX_121A14F7 on Group_ (companyId, parentGroupId, site, ctCollectionId);
     [echo]  create index IX_162053E9 on Group_ (companyId, parentGroupId, site, inheritContent, ctCollectionId);
     [echo] @@ -403,6 +405,7 @@ create index IX_3078CBE6 on ResourcePermission (roleId, ctCollectionId);
     [echo]  create index IX_F3870DDF on ResourcePermission (scope, ctCollectionId);
     [echo]  
     [echo]  create unique index IX_C0F6BCAC on Role_ (companyId, classNameId, classPK, ctCollectionId);
     [echo] +create unique index IX_D303FC25 on Role_ (companyId, classNameId, classPK, type_, ctCollectionId);
     [echo]  create index IX_4EA65517 on Role_ (companyId, ctCollectionId);
     [echo]  create unique index IX_4CC99816 on Role_ (companyId, name[$COLUMN_LENGTH:75$], ctCollectionId);
     [echo]  create index IX_7037255A on Role_ (companyId, type_, ctCollectionId);

Not seen on master or 7.2.x.