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

Is a unique index needed on ufgroup.name?

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Won't Fix
    • Affects Version/s: 3.2
    • Fix Version/s: 4.3.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      In trying to figure out how to make the CustomGroupData.xml import for CiviEngage work, it seems that the best approach is to use a unique name for entities that is not dependent on the id, as that makes the data import liable to fail depending on what has previously happened in the database. The unique name needs to be used later in the xml file for references back to the entity by children.

      In the case of UFGroup, it seems that the name field should be able to play this role - the comment in the schema is that it is Name of the UF group for directly addressing it in the codebase. In order to ensure this is possible, we should add a unique index on this field, as per the attached patch.

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              joemurray Joe Murray
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: