• Home
• com.liferay
• com.liferay.account.service
• 2.0.117
• 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_48CB043 on AccountEntry (companyId, status);
create index IX_24DB5FF2 on AccountEntry (externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_908C3410 on AccountEntry (userId, type_[$COLUMN_LENGTH:75$]);
create index IX_6901A669 on AccountEntry (uuid_[$COLUMN_LENGTH:75$]);

create index IX_B233281D on AccountEntryOrganizationRel (organizationId, accountEntryId);

create index IX_EED84268 on AccountEntryUserRel (accountUserId, accountEntryId);

create index IX_38BDB33 on AccountGroup (companyId, defaultAccountGroup);
create index IX_8EE6A92F on AccountGroup (companyId, name[$COLUMN_LENGTH:75$]);
create index IX_B4733E65 on AccountGroup (companyId, type_[$COLUMN_LENGTH:75$]);
create index IX_B2AE6A85 on AccountGroup (externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_E86A36FC on AccountGroup (uuid_[$COLUMN_LENGTH:75$]);

create index IX_617C42A3 on AccountGroupRel (classNameId, classPK, accountGroupId);

create index IX_9BCBCB2B on AccountRole (accountEntryId, companyId);
create index IX_714A358E on AccountRole (roleId);