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

Implement missing foreign key for pcp_block.supporter_profile_id and fix onDelete for contribution_soft.pcp_id

          Details

          • Type: Task
          • Status: Done/Fixed
          • Priority: Trivial
          • Resolution: Fixed/Completed
          • Affects Version/s: 3.0
          • Fix Version/s: 3.1
          • Component/s: CiviContribute
          • Labels:
            None

            Description

            Noticed a few schema "defiiciencies" during test sprint...

            1. PCP blocks require a Supporter Profile, so civicrm_pcp_block.supporter_profile_id should be an FKey to civicrm_uf_group.id

            2. We don't want to delete a soft contribution record if the associated PCP is deleted so civicrm_contribution_soft.pcp_id should be an FKey with onDelete = set null.

              Attachments

                Activity

                  People

                  • Assignee:
                    rajan Rajan P Mayekar
                    Reporter:
                    dgg David Greenberg
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: