Opened 3 years ago

Last modified 3 years 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-all 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


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.


Change History (1)

comment:1 Changed 3 years 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.