Opened 17 months ago

Last modified 17 months ago

#4521 new defect

Replace trigger with use of ON DELETE CASCADE in MySQL

Reported by: tmark Owned by:
Priority: medium Milestone: Outstanding Tasks
Component: database-backend Version: git
Keywords: Cc:
CVSS Scoring: Parent Tickets:
Sensitive: no Defect Severity: N/A
Sub-Project: DHCP Feature Depending on Ticket:
Estimated Difficulty: 0 Add Hours to Ticket: 0
Total Hours: 2 Internal?: no

Description

Currently we are using a trigger to effect cascading deletes from the options tables when hosts are deleted. Turns out that the SQL standard provides an ON DELETE action (among others) for foreign key constraints, one of which is CASCADE. This dictates that the child entry be removed when the parent table entry is deleted.

Subtickets

Change History (1)

comment:1 Changed 17 months ago by hschempf

  • Milestone changed from Kea-proposed to Outstanding Tasks

per june 16 team meeting, move to outstanding

Note: See TracTickets for help on using tickets.