create index IX_93D5AD4E on Address (companyId);
create index IX_ABD7DAC0 on Address (companyId, classNameId);
create index IX_71CB1123 on Address (companyId, classNameId, classPK);
create index IX_381E55DA on Address (uuid_);
create index IX_6EDB9600 on AnnouncementsDelivery (userId);
create index IX_A6EF0B81 on AnnouncementsEntry (classNameId, classPK);
create index IX_1AFBDE08 on AnnouncementsEntry (uuid_);
create index IX_E639E2F6 on AssetCategory (groupId);
create index IX_7BB1826B on AssetCategory (parentCategoryId);
create index IX_9DDD15EA on AssetCategory (parentCategoryId, name);
create index IX_4D37BB00 on AssetCategory (uuid_);
create index IX_99DA856 on AssetCategoryProperty (categoryId);
create index IX_8654719F on AssetCategoryProperty (companyId);
create index IX_FC1F9C7B on AssetEntry (classUuid);
create index IX_128516C8 on AssetLink (entryId1);
create index IX_56E0AB21 on AssetLink (entryId1, entryId2);
create index IX_12851A89 on AssetLink (entryId2);
create index IX_7C9E46BA on AssetTag (groupId);
create index IX_DFF1F063 on AssetTagProperty (companyId);
create index IX_3269E180 on AssetTagProperty (tagId);
create index IX_9464CA on AssetTagStats (tagId);
create index IX_B6B8CA0E on AssetVocabulary (groupId);
create index IX_C0AAD74D on AssetVocabulary (groupId, name);
create index IX_55F58818 on AssetVocabulary (uuid_);
create index IX_5A09E5D1 on BackgroundTask (groupId);
create index IX_98CC0AAB on BackgroundTask (groupId, name, taskExecutorClassName);
create index IX_A73B688A on BackgroundTask (groupId, taskExecutorClassName);
create index IX_C07CC7F8 on BackgroundTask (name);
create index IX_72EF6041 on BlogsEntry (companyId);
create index IX_430D791F on BlogsEntry (companyId, displayDate);
create index IX_8CACE77B on BlogsEntry (companyId, userId);
create index IX_81A50303 on BlogsEntry (groupId);
create index IX_621E19D on BlogsEntry (groupId, displayDate);
create index IX_FBDE0AA3 on BlogsEntry (groupId, userId, displayDate);
create index IX_69157A4D on BlogsEntry (uuid_);
create index IX_43840EEB on BlogsStatsUser (groupId);
create index IX_BB51F1D9 on BlogsStatsUser (userId);
create index IX_1F90CA2D on BookmarksEntry (companyId);
create index IX_5200100C on BookmarksEntry (groupId, folderId);
create index IX_B670BA39 on BookmarksEntry (uuid_);
create index IX_2ABA25D7 on BookmarksFolder (companyId);
create index IX_7F703619 on BookmarksFolder (groupId);
create index IX_967799C0 on BookmarksFolder (groupId, parentFolderId);
create index IX_451E7AE3 on BookmarksFolder (uuid_);
create index IX_12EE4898 on CalEvent (groupId);
create index IX_FCD7C63D on CalEvent (groupId, type_);
create index IX_C1AD2122 on CalEvent (uuid_);
create index IX_87A6B599 on DDLRecord (recordSetId);
create index IX_8BC2F891 on DDLRecord (uuid_);
create index IX_4FA5969F on DDLRecordSet (groupId);
create index IX_561E44E9 on DDLRecordSet (uuid_);
create index IX_2F4DDFE1 on DDLRecordVersion (recordId);
create index IX_AE4B50C2 on DDMContent (uuid_);
create index IX_C8419FBE on DDMStructure (groupId);
create index IX_B6ED5E50 on DDMStructure (groupId, classNameId);
create index IX_E61809C8 on DDMStructure (uuid_);
create index IX_DB24DDDD on DDMTemplate (groupId);
create index IX_BD9A4A91 on DDMTemplate (groupId, classNameId);
create index IX_824ADC72 on DDMTemplate (groupId, classNameId, classPK);
create index IX_90800923 on DDMTemplate (groupId, classNameId, classPK, type_);
create index IX_F2A243A7 on DDMTemplate (uuid_);
create index IX_6A83A66A on DLContent (companyId, repositoryId);
create index IX_EB531760 on DLContent (companyId, repositoryId, path_);
create index IX_F4AF5636 on DLFileEntry (groupId);
create index IX_93CF8193 on DLFileEntry (groupId, folderId);
create index IX_43261870 on DLFileEntry (groupId, userId);
create index IX_64F0FE40 on DLFileEntry (uuid_);
create index IX_A44636C9 on DLFileEntryMetadata (fileEntryId, fileVersionId);
create index IX_4501FD9C on DLFileEntryType (groupId);
create index IX_90724726 on DLFileEntryType (uuid_);
create unique index IX_38F0315 on DLFileRank (companyId, userId, fileEntryId);
create index IX_BAFB116E on DLFileRank (groupId, userId);
create index IX_A4BB2E58 on DLFileShortcut (companyId);
create index IX_B0051937 on DLFileShortcut (groupId, folderId);
create index IX_348DC3B2 on DLFileShortcut (groupId, folderId, active_);
create index IX_4831EBE4 on DLFileShortcut (uuid_);
create index IX_F389330E on DLFileVersion (companyId);
create index IX_C68DC967 on DLFileVersion (fileEntryId);
create index IX_4BFABB9A on DLFileVersion (uuid_);
create index IX_A74DB14C on DLFolder (companyId);
create index IX_F2EA1ACE on DLFolder (groupId);
create index IX_F78286C5 on DLFolder (groupId, mountPoint, parentFolderId, hidden_);
create index IX_49C37475 on DLFolder (groupId, parentFolderId);
create index IX_CBC408D8 on DLFolder (uuid_);
create index IX_1BB072CA on EmailAddress (companyId);
create index IX_49D2DEC4 on EmailAddress (companyId, classNameId);
create index IX_551A519F on EmailAddress (companyId, classNameId, classPK);
create index IX_D24F3956 on EmailAddress (uuid_);
create index IX_A8C0CBE8 on ExpandoColumn (tableId);
create index IX_D3F5D7AE on ExpandoRow (tableId);
create index IX_B5AE8A85 on ExpandoTable (companyId, classNameId);
create index IX_F7DD0987 on ExpandoValue (columnId);
create index IX_F0566A77 on ExpandoValue (tableId);
create index IX_CA9AFB7C on ExpandoValue (tableId, columnId);
create index IX_ABA5CEC2 on Group_ (companyId);
create index IX_B584B5CC on Group_ (companyId, classNameId);
create index IX_5D75499E on Group_ (companyId, parentGroupId);
create index IX_F981514E on Group_ (uuid_);
create index IX_DFF98523 on JournalArticle (companyId);
create index IX_3D070845 on JournalArticle (companyId, version);
create index IX_9356F865 on JournalArticle (groupId);
create index IX_68C0F69C on JournalArticle (groupId, articleId);
create index IX_5CD17502 on JournalArticle (groupId, folderId);
create index IX_22882D02 on JournalArticle (groupId, urlTitle);
create index IX_D19C1B9F on JournalArticle (groupId, userId);
create index IX_33F49D16 on JournalArticle (resourcePrimKey);
create index IX_89FF8B06 on JournalArticle (resourcePrimKey, indexable);
create index IX_F029602F on JournalArticle (uuid_);
create index IX_3B51BB68 on JournalArticleImage (groupId);
create index IX_158B526F on JournalArticleImage (groupId, articleId, version);
create index IX_F8433677 on JournalArticleResource (groupId);
create index IX_DCD1FAC1 on JournalArticleResource (uuid_);
create index IX_20962903 on JournalContentSearch (groupId, privateLayout);
create index IX_B3B318DC on JournalContentSearch (groupId, privateLayout, layoutId);
create index IX_7ACC74C9 on JournalContentSearch (groupId, privateLayout, layoutId, portletId);
create index IX_35A2DB2F on JournalFeed (groupId);
create index IX_50C36D79 on JournalFeed (uuid_);
create index IX_E6E2725D on JournalFolder (companyId);
create index IX_742DEC1F on JournalFolder (groupId);
create index IX_190483C6 on JournalFolder (groupId, parentFolderId);
create index IX_63BDFA69 on JournalFolder (uuid_);
create index IX_C7FBC998 on Layout (companyId);
create index IX_C099D61A on Layout (groupId);
create index IX_705F5AA3 on Layout (groupId, privateLayout);
create index IX_6DE88B06 on Layout (groupId, privateLayout, parentLayoutId);
create index IX_D0822724 on Layout (uuid_);
create index IX_6C226433 on LayoutBranch (layoutSetBranchId);
create index IX_2C42603E on LayoutBranch (layoutSetBranchId, plid);
create index IX_742EF04A on LayoutFriendlyURL (groupId);
create index IX_CA713461 on LayoutFriendlyURL (groupId, privateLayout, friendlyURL);
create index IX_83AE56AB on LayoutFriendlyURL (plid);
create index IX_9F80D54 on LayoutFriendlyURL (uuid_);
create index IX_30616AAA on LayoutPrototype (companyId);
create index IX_CEF72136 on LayoutPrototype (uuid_);
create index IX_314B621A on LayoutRevision (layoutSetBranchId);
create index IX_A9AC086E on LayoutRevision (layoutSetBranchId, head);
create index IX_B7B914E5 on LayoutRevision (layoutSetBranchId, plid);
create index IX_9329C9D6 on LayoutRevision (plid);
create index IX_A40B8BEC on LayoutSet (groupId);
create index IX_8FF5D6EA on LayoutSetBranch (groupId);
create index IX_C4079FD3 on LayoutSetBranch (groupId, privateLayout);
create index IX_55F63D98 on LayoutSetPrototype (companyId);
create index IX_C5D69B24 on LayoutSetPrototype (uuid_);
create index IX_13C5CD3A on Lock_ (uuid_);
create index IX_5C3FF12A on MBBan (groupId);
create index IX_8A13C634 on MBBan (uuid_);
create index IX_BC735DCF on MBCategory (companyId);
create index IX_BB870C11 on MBCategory (groupId);
create index IX_ED292508 on MBCategory (groupId, parentCategoryId);
create index IX_C2626EDB on MBCategory (uuid_);
create index IX_79D0120B on MBDiscussion (classNameId);
create index IX_5477D431 on MBDiscussion (uuid_);
create index IX_4115EC7A on MBMailingList (uuid_);
create index IX_51A8D44D on MBMessage (classNameId, classPK);
create index IX_B1432D30 on MBMessage (companyId);
create index IX_5B153FB2 on MBMessage (groupId);
create index IX_1073AB9F on MBMessage (groupId, categoryId);
create index IX_B674AB58 on MBMessage (groupId, categoryId, threadId);
create index IX_8EB8C5EC on MBMessage (groupId, userId);
create index IX_75B95071 on MBMessage (threadId);
create index IX_7A040C32 on MBMessage (userId);
create index IX_59F9CE5C on MBMessage (userId, classNameId);
create index IX_ABEB6D07 on MBMessage (userId, classNameId, classPK);
create index IX_C57B16BC on MBMessage (uuid_);
create index IX_A00A898F on MBStatsUser (groupId);
create index IX_D33A5445 on MBStatsUser (groupId, userId, messageCount);
create index IX_95C0EA45 on MBThread (groupId);
create index IX_9A2D11B2 on MBThread (groupId, categoryId);
create index IX_7E264A0F on MBThread (uuid_);
create index IX_A28004B on MBThreadFlag (userId);
create index IX_F36BBB83 on MBThreadFlag (uuid_);
create index IX_77BB5E9D on MDRAction (uuid_);
create index IX_EA63B9D7 on MDRRule (uuid_);
create index IX_7F26B2A6 on MDRRuleGroup (uuid_);
create index IX_C95A08D8 on MDRRuleGroupInstance (classNameId, classPK);
create index IX_AFF28547 on MDRRuleGroupInstance (groupId);
create index IX_B6A6BD91 on MDRRuleGroupInstance (uuid_);
create index IX_8A1CC4B on MembershipRequest (groupId);
create index IX_834BCEB6 on Organization_ (companyId);
create index IX_396D6B42 on Organization_ (uuid_);
create index IX_8FEE65F5 on PasswordPolicy (companyId);
create index IX_51437A01 on PasswordPolicy (uuid_);
create index IX_9F704A14 on Phone (companyId);
create index IX_A2E4AFBA on Phone (companyId, classNameId);
create index IX_9A53569 on Phone (companyId, classNameId, classPK);
create index IX_EA6245A0 on Phone (uuid_);
create index IX_B9746445 on PluginSetting (companyId);
create index IX_EC370F10 on PollsChoice (questionId);
create index IX_6660B399 on PollsChoice (uuid_);
create index IX_51F087F4 on PollsQuestion (uuid_);
create index IX_12112599 on PollsVote (questionId);
create index IX_FD32EB70 on PollsVote (uuid_);
create index IX_80CC9508 on Portlet (companyId);
create index IX_2C61314E on PortletItem (groupId, portletId);
create index IX_8E71167F on PortletItem (groupId, portletId, classNameId, name);
create index IX_33B8CE8D on PortletItem (groupId, portletId, name);
create index IX_E4F13E6E on PortletPreferences (ownerId, ownerType, plid);
create index IX_F15C1C4F on PortletPreferences (plid);
create index IX_16184D57 on RatingsEntry (classNameId, classPK);
create index IX_16D87CA7 on Region (countryId);
create index IX_5253B1FA on Repository (groupId);
create index IX_74C17B04 on Repository (uuid_);
create index IX_B7034B27 on RepositoryEntry (repositoryId);
create index IX_B9B1506 on RepositoryEntry (uuid_);
create index IX_81F2DB09 on ResourceAction (name);
create index IX_DA30B086 on ResourceBlock (companyId, groupId, name);
create index IX_4AB3756 on ResourceBlockPermission (resourceBlockId);
create index IX_60B99860 on ResourcePermission (companyId, name, scope);
create index IX_2200AA69 on ResourcePermission (companyId, name, scope, primKey);
create index IX_449A10B9 on Role_ (companyId);
create index IX_F92B66E6 on Role_ (type_);
create index IX_26DB26C5 on Role_ (uuid_);
create index IX_272991FA on SCFrameworkVersion (groupId);
create index IX_1C841592 on SCLicense (active_);
create index IX_72F87291 on SCProductEntry (groupId);
create index IX_467956FD on SCProductScreenshot (productEntryId);
create index IX_7338606F on ServiceComponent (buildNamespace);
create index IX_C28B41DC on ShoppingCart (groupId);
create index IX_5F615D3E on ShoppingCategory (groupId);
create index IX_1D15553E on ShoppingOrder (groupId);
create index IX_82E39A0C on SocialActivity (classNameId);
create index IX_A853C757 on SocialActivity (classNameId, classPK);
create index IX_2A2468 on SocialActivity (groupId);
create index IX_1271F25F on SocialActivity (mirrorActivityId);
create index IX_E14B1F1 on SocialActivityAchievement (groupId);
create index IX_C8FD892B on SocialActivityAchievement (groupId, userId);
create index IX_D6666704 on SocialActivityCounter (groupId);
create index IX_18D4BAE5 on SocialActivityLimit (groupId);
create index IX_9E13F2DE on SocialActivitySet (groupId);
create index IX_F80C4386 on SocialActivitySet (userId);
create index IX_8BE5F230 on SocialActivitySetting (groupId);
create index IX_9D22151E on SocialActivitySetting (groupId, classNameId);
create index IX_1E9CF33B on SocialActivitySetting (groupId, classNameId, activityType);
create index IX_61171E99 on SocialRelation (companyId);
create index IX_5A40CDCC on SocialRelation (userId1);
create index IX_B5C9C690 on SocialRelation (userId1, userId2);
create index IX_5A40D18D on SocialRelation (userId2);
create index IX_F0CA24A5 on SocialRelation (uuid_);
create index IX_32292ED1 on SocialRequest (receiverUserId);
create index IX_80F7A9C2 on SocialRequest (userId);
create index IX_49D5872C on SocialRequest (uuid_);
create index IX_54243AFD on Subscription (userId);
create index IX_72D73D39 on SystemEvent (groupId);
create index IX_7A2F0ECE on SystemEvent (groupId, classNameId, classPK);
create index IX_AE6E9907 on Team (groupId);
create index IX_526A032A on TrashEntry (groupId);
create index IX_55D44577 on TrashVersion (entryId);
create index IX_72D58D37 on TrashVersion (entryId, classNameId);
create index IX_524FEFCE on UserGroup (companyId);
create index IX_5F1DD85A on UserGroup (uuid_);
create index IX_CCBE4063 on UserGroupGroupRole (groupId);
create index IX_DCDED558 on UserGroupGroupRole (userGroupId);
create index IX_1B988D7A on UserGroupRole (groupId);
create index IX_887BE56A on UserGroupRole (userId);
create index IX_E60EA987 on UserIdMapper (userId);
create index IX_C648700A on UserNotificationDelivery (userId);
create index IX_3E5D78C4 on UserNotificationEvent (userId);
create index IX_ECD8CFEA on UserNotificationEvent (uuid_);
create index IX_3A1E834E on User_ (companyId);
create index IX_740C4D0C on User_ (companyId, createDate);
create index IX_E0422BDA on User_ (uuid_);
create index IX_96F07007 on Website (companyId);
create index IX_4F0F0CA7 on Website (companyId, classNameId);
create index IX_F960131C on Website (companyId, classNameId, classPK);
create index IX_76F15D13 on Website (uuid_);
create index IX_5D6FE3F0 on WikiNode (companyId);
create index IX_B480A672 on WikiNode (groupId);
create index IX_6C112D7C on WikiNode (uuid_);
create index IX_16E99B0A on WikiPage (groupId, nodeId, head);
create index IX_C8A9C476 on WikiPage (nodeId);
create index IX_E7F635CA on WikiPage (nodeId, head);
create index IX_65E84AF4 on WikiPage (nodeId, head, parentTitle);
create index IX_997EEDD2 on WikiPage (nodeId, title);
create index IX_85E7CC76 on WikiPage (resourcePrimKey);
create index IX_B771D67 on WikiPage (resourcePrimKey, nodeId);
create index IX_9C0E478F on WikiPage (uuid_);
create index IX_A8B0D276 on WorkflowDefinitionLink (companyId);
create index IX_B6EE8C9E on WorkflowDefinitionLink (groupId, companyId, classNameId);
create index IX_1E5B9905 on WorkflowDefinitionLink (groupId, companyId, classNameId, classPK);
