Older sites missing index for `is_deceased` on `civicrm_contact`
This is a follow up from Eileen's comment about a missing index in #4539 (comment 150479).
The index for is_deceased
was added in CiviCRM 4.7 and is defined in xml/schema/Contact/Contact.xml. However, there doesn't appear to be an upgrade task to add this index to existing sites. As a result any site installed before CiviCRM 4.7 is likely to be missing this index. Checking our client sites, I can see a mix of sites that do and don't have it.
The MR where this index was added is: https://github.com/civicrm/civicrm-core/pull/10489
There was a question from Tim about whether there should be an upgrader. There was a later comment from Eileen about whether this index should be removed.
So I guess the question is whether we want this index or not:
- if we do want this index we should add an upgrade task so that older sites have this index
- if we don't want this index we should add an upgrade task to remove it from sites that have it