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

Foreign keys in the database should generally be set to "CASCADE DELETE"

          Details

          • Type: Improvement
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Fixed/Completed
          • Affects Version/s: 1.4, 1.5
          • Fix Version/s: Unscheduled
          • Component/s: Technical infrastructure
          • Labels:
            None

            Description

            Even if CiviCRM chooses to clean up the many side of relationships manually, setting the relationships to CASCADE DELETE would make database manipulation by third-party applications easier.

            Subclasses like civicrm_individual should ALWAYS be set to CASCADE DELETE.

              Attachments

                Activity

                  People

                  • Assignee:
                    lobo Donald A. Lobo
                    Reporter:
                    davidstrauss David Strauss
                  • Votes:
                    1 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: