Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-1323

Add Unique Indexes to Tables as Needed to Enforce Data Integrity Rules

    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

        Attachments

          Activity

            People

            • Assignee:
              abhilasha Abhilasha Vasu
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: