• Home
• com.liferay.commerce
• com.liferay.commerce.pricing.service
• 1.0.9
• source code
• indexes.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

META-INF.sql.indexes.sql Maven / Gradle / Ivy

create index IX_31653559 on CPricingClassCPDefinitionRel (CPDefinitionId);
create index IX_DF602906 on CPricingClassCPDefinitionRel (commercePricingClassId);

create index IX_176CA5EC on CommercePriceModifier (commercePriceListId);
create index IX_335B7FE0 on CommercePriceModifier (companyId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_FCACD082 on CommercePriceModifier (companyId, target[$COLUMN_LENGTH:75$]);
create index IX_C60214FB on CommercePriceModifier (displayDate, status);
create index IX_E3CDA8A2 on CommercePriceModifier (expirationDate, status);
create index IX_93813A2F on CommercePriceModifier (groupId, companyId, status);
create index IX_EED93BBF on CommercePriceModifier (uuid_[$COLUMN_LENGTH:75$], companyId);
create unique index IX_A4ABA601 on CommercePriceModifier (uuid_[$COLUMN_LENGTH:75$], groupId);

create index IX_391477EF on CommercePriceModifierRel (classNameId, classPK);
create index IX_F688AD98 on CommercePriceModifierRel (commercePriceModifierId, classNameId);

create index IX_FCABA3C8 on CommercePricingClass (companyId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_8A3D0197 on CommercePricingClass (groupId);
create index IX_287E2FA7 on CommercePricingClass (uuid_[$COLUMN_LENGTH:75$], companyId);
create unique index IX_34C73E9 on CommercePricingClass (uuid_[$COLUMN_LENGTH:75$], groupId);