Multibyte PagePath (URL) support
Index arLayoutID added for very common filter, compounded with arLayoutColumnIndex for the orderBy

Index arID added for filtering and potentially joining to the area table

Index arLayoutColumnDisplayID indexed to improve performance on MAX() function
Added index areaLayoutPresets.arLayoutID for where clause filtering and potential joining to the areaLayouts table

Added index areaLayoutPresets.arLayoutPresetName for a query that uses it for sorting
Added index AeraPermissionAssignments.paID for join to PermissionAccessList table

Added index AeraPermissionAssignments.paID for join to PermissionKeys table
Merge remote-tracking branch 'upstream/master' into database-indexing
Added index AreaPermissionBlockTypeAccessList.peID for potential join to PermissionAccessEntities table
Added index AreaPermissionBlockTypeAccessListCustom.peID for potential join to PermissionAccessEntities table

Added index AreaPermissionBlockTypeAccessListCustom.btID for potential join to BlockType table
Added index atAddressCustomCountries.akID for potential join to AttributeKeys table and for where clause
Added index atFile.fID for potential join to Files table
Added primary key atSelectedTopics.avID because... well every table should have a primary key... and for where clause on query
Added index to atSelectOptions.akID for where clause and order by clause on the displayOrder when filtered by akID and for potential join to the AttributeKeys table

Added index to atSelectOptions.value for where clause
Added index to atSelectOptionsSelected.atSelectOptionID for where clause
Added column to index to atSocialLinks.avID to allow for order by to leverage the index
Added index to atTopicSettings.akTopicTreeID for potential join to TopicTrees table
Added index to AttributeKeyCategories.akHandle for where clause. From what I could tell this could possibly be made a unique index based on looking at the other queries don't include the pkgID with this. But probably an issue for another day.

Added index to AttributeKeyCategories.pkgID for where clause and where clause with order by on Category ID
Added index to AttributeKeys.akCategoryID for where clause and  join to AttributeKeyCategories

Added index to AttributeKeys.atID for potential join to AttributeTypes

Added index to AttributeKeys.pkgID for potential join to Packages Table
Added index to AttributeSetKeys.asID for where clause + order by on the displayOrder, and also for potential join to the AttributeSets table
Added unique index to AttributeSets.asHandle for where clause

Added index to AttributeSets.akCategoryID for join to AttributeKeyCategories table and for where clause + order by on asDisplayOrder

Added index to AttributeSets.pkgID for where clause + order by on asID
Added index to AttributeTypeCategories.akCategoryID for join to AttributeKeyCategories table and for where clause
Added index to AttributeTypes.pkgID for where clause + order by atID