Uploaded image for project: 'CiviVolunteer'
  1. CiviVolunteer
  2. VOL-103

Update Project Table constraint on entity_id and entity_type

    Details

    • Type: New Feature
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Labels:
      None

      Description

      Currently an entity can have only one child Project because of a unique constraint on entity type and entity ID. We want Projects, CiviEvents, and other entities to be able to have multiple children.

      It is impossible for there to be two records for the same project, therefore, there is no need to protect against a project having multiple parents.

      The constraint needs to be removed both for fresh installs and for upgrades.

        Attachments

          Activity

            People

            • Assignee:
              pittstains Frank J. Gómez
              Reporter:
              ginkgomzd Michael Z Daryabeygi
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4 hours
                4h
                Remaining:
                Remaining Estimate - 4 hours
                4h
                Logged:
                Time Spent - Not Specified
                Not Specified