Uploaded image for project: 'Alfresco'
  1. Alfresco
  2. ALF-16030

Use ON DELETE CASCADE for node aspects and properties

    Details

    • Type: Improvement
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Won't Do
    • Affects Version/s: Community Edition 201704 GA
    • Fix Version/s: None
    • Component/s: Repository, Upgrades
    • Labels:
      None
    • Resolution Time Custom Field:
      266 weeks, 4 days, 10 hours, 11 minutes, 50 seconds

      Description

      Node properties and aspects are tightly linked to nodes i.e. any update to nodes or properties is always accompanied by a version increment on the node.
      Therefore we can, when deleting a node, cascade-delete the aspects and properties.

      The FK constraint on the 'node_id' columns needs to get ON DELETE CASCADE and then a thorough check needs to be done on the different databases. Following this, the SQL upgrade scripts will be fairly simple: drop and recreate the FK constraint.

      This will alleviate some of the changes to deleteNodesByCommitTime required for ALF-16029. It needs to be investigated thoroughly

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedissues Closed Issues
                  Reporter:
                  dhulley Derek Hulley [X] (Inactive)
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  10 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Date of First Response:

                    Structure Helper Panel