• Home
• com.liferay
• com.liferay.journal.service
• 7.0.148
• 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_745E04FA on JournalArticle (DDMStructureId);
create index IX_75CCA4D1 on JournalArticle (DDMTemplateKey[$COLUMN_LENGTH:75$]);
create index IX_A2D2CDB8 on JournalArticle (externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_3048AF7A on JournalArticle (groupId, DDMStructureId);
create index IX_31B74F51 on JournalArticle (groupId, DDMTemplateKey[$COLUMN_LENGTH:75$]);
create index IX_6D117C1E on JournalArticle (groupId, classNameId, DDMStructureId);
create index IX_6E801BF5 on JournalArticle (groupId, classNameId, DDMTemplateKey[$COLUMN_LENGTH:75$]);
create index IX_9CE6E0FA on JournalArticle (groupId, classNameId, classPK);
create index IX_A2534AC2 on JournalArticle (groupId, classNameId, layoutUuid[$COLUMN_LENGTH:75$]);
create index IX_373DCC43 on JournalArticle (groupId, classNameId, userId);
create unique index IX_7D5A7391 on JournalArticle (groupId, ctCollectionId, uuid_[$COLUMN_LENGTH:75$]);
create index IX_5CD17502 on JournalArticle (groupId, folderId);
create index IX_3C028C1E on JournalArticle (groupId, layoutUuid[$COLUMN_LENGTH:75$]);
create index IX_5CA5E0F6 on JournalArticle (groupId, status, articleId[$COLUMN_LENGTH:75$]);
create index IX_BCAFC000 on JournalArticle (groupId, status, classNameId, folderId);
create index IX_9D8D768 on JournalArticle (groupId, status, folderId);
create index IX_CF8F8F68 on JournalArticle (groupId, status, urlTitle[$COLUMN_LENGTH:255$]);
create index IX_22882D02 on JournalArticle (groupId, urlTitle[$COLUMN_LENGTH:255$]);
create index IX_D19C1B9F on JournalArticle (groupId, userId);
create unique index IX_9AA41E0 on JournalArticle (groupId, version, ctCollectionId, articleId[$COLUMN_LENGTH:75$]);
create unique index IX_4D29D87C on JournalArticle (groupId, version, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_3F1EA19E on JournalArticle (layoutUuid[$COLUMN_LENGTH:75$]);
create index IX_89FF8B06 on JournalArticle (resourcePrimKey, indexable);
create index IX_EF9B7028 on JournalArticle (smallImageId);
create index IX_2AA511D5 on JournalArticle (status, displayDate);
create index IX_BCE7DFEC on JournalArticle (status, resourcePrimKey, indexable);
create index IX_BDC9FD6B on JournalArticle (status, version, companyId);
create index IX_F029602F on JournalArticle (uuid_[$COLUMN_LENGTH:75$]);
create index IX_E5236285 on JournalArticle (version, companyId);

create unique index IX_5593D868 on JournalArticleLocalization (articlePK, languageId[$COLUMN_LENGTH:75$], ctCollectionId);

create unique index IX_42F04A2C on JournalArticleResource (groupId, ctCollectionId, articleId[$COLUMN_LENGTH:75$]);
create unique index IX_67A4813F on JournalArticleResource (groupId, ctCollectionId, uuid_[$COLUMN_LENGTH:75$]);

create index IX_9207CB31 on JournalContentSearch (articleId[$COLUMN_LENGTH:75$]);
create index IX_42F51F38 on JournalContentSearch (companyId);
create unique index IX_D3D72048 on JournalContentSearch (portletId[$COLUMN_LENGTH:200$], groupId, articleId[$COLUMN_LENGTH:75$], privateLayout, layoutId, ctCollectionId);
create index IX_AD9062E1 on JournalContentSearch (portletId[$COLUMN_LENGTH:200$], groupId, privateLayout, layoutId);

create unique index IX_E5E4C71A on JournalFeed (groupId, ctCollectionId, feedId[$COLUMN_LENGTH:75$]);
create unique index IX_B00B0D87 on JournalFeed (groupId, ctCollectionId, uuid_[$COLUMN_LENGTH:75$]);

create index IX_E6E2725D on JournalFolder (companyId);
create unique index IX_5C538C20 on JournalFolder (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_6F0364E3 on JournalFolder (groupId, ctCollectionId, parentFolderId, name[$COLUMN_LENGTH:100$]);
create unique index IX_9F83EE97 on JournalFolder (groupId, ctCollectionId, uuid_[$COLUMN_LENGTH:75$]);
create index IX_E988689E on JournalFolder (groupId, name[$COLUMN_LENGTH:100$]);
create index IX_EFD9CAC on JournalFolder (groupId, parentFolderId, status);
create index IX_8D6902B7 on JournalFolder (status, companyId);
create index IX_63BDFA69 on JournalFolder (uuid_[$COLUMN_LENGTH:75$]);