create unique index IX_C0AAD74D on AssetVocabulary (groupId, name);
create index IX_1B352F4A on DLFileEntry (repositoryId, folderId);
create index IX_25F5CAB9 on DLFileEntry (smallImageId, largeImageId, custom1ImageId, custom2ImageId);
create index IX_38F0315 on DLFileRank (companyId, userId, fileEntryId);
create index IX_DDC91A87 on Group_ (companyId, active_);
create index IX_FF0E7A72 on JournalArticle (classNameId, templateId);
create index IX_881EABCB on Layout (companyId, layoutPrototypeUuid);
create index IX_7399B71E on Layout (groupId, privateLayout, parentLayoutId, priority);
create index IX_3BC009C0 on Layout (privateLayout, iconImageId);
create index IX_1B698D9 on LayoutSet (privateLayout, logoId);
create index IX_6A84467D on ShoppingCategory (groupId, name);
create index IX_1E8DFB2E on Ticket (classNameId, classPK, type_);
