• Home
• com.liferay
• com.liferay.asset.list.service
• 1.0.21
• 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 unique index IX_9E478DAB on AssetListEntry (groupId, assetListEntryKey[$COLUMN_LENGTH:75$]);
create unique index IX_34CEA368 on AssetListEntry (groupId, title[$COLUMN_LENGTH:75$]);
create index IX_4FE08A35 on AssetListEntry (groupId, type_);
create index IX_DD7DDFBE on AssetListEntry (uuid_[$COLUMN_LENGTH:75$], companyId);
create unique index IX_AFD73DC0 on AssetListEntry (uuid_[$COLUMN_LENGTH:75$], groupId);

create unique index IX_E78FD92E on AssetListEntryAssetEntryRel (assetListEntryId, segmentsEntryId, position);
create index IX_99DDCF6D on AssetListEntryAssetEntryRel (uuid_[$COLUMN_LENGTH:75$], companyId);
create unique index IX_3D7D4D2F on AssetListEntryAssetEntryRel (uuid_[$COLUMN_LENGTH:75$], groupId);

create unique index IX_5B2A219 on AssetListEntrySegmentsEntryRel (assetListEntryId, segmentsEntryId);
create index IX_1C9A6A4C on AssetListEntrySegmentsEntryRel (segmentsEntryId);
create index IX_541ED8E5 on AssetListEntrySegmentsEntryRel (uuid_[$COLUMN_LENGTH:75$], companyId);
create unique index IX_3CE254A7 on AssetListEntrySegmentsEntryRel (uuid_[$COLUMN_LENGTH:75$], groupId);

create index IX_6CA44DF8 on AssetListEntryUsage (assetListEntryId, classNameId);
create unique index IX_CA8F030D on AssetListEntryUsage (classNameId, classPK, portletId[$COLUMN_LENGTH:200$]);
create index IX_4976B637 on AssetListEntryUsage (uuid_[$COLUMN_LENGTH:75$], companyId);
create unique index IX_E2D55E79 on AssetListEntryUsage (uuid_[$COLUMN_LENGTH:75$], groupId);