Details
-
Type: Improvement
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: None
-
Fix Version/s: 1.6
-
Component/s: None
-
Labels:None
Description
The following tables need unique indexes to help enforce data integrity:
- Add unique constraint on contact_group (contact_id + group_id) (s/b only 1 join record per contact+group combination)
- Add unique index on contact_id for civicrm_individual, household, organization (s/b only 1 individual, hh or org per civicrm_contact record)
- Add unique index on location_id for civicrm_address (s/b only one address per location)
- unique contact_id in uf_match