[Koha-bugs] [Bug 17160] Foreign key constraint for message_transports is too loose

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17160

--- Comment #2 from Barton Chittenden <barton at bywatersolutions.com> ---
(In reply to Jonathan Druart from comment #1)
> Barton, I understand the problem but it does not look so easy to fix it.

<snip>

> But the letter table does necessarily contain a sms template for CHECKIN or
> CHECKOUT (or whatever).
> If it does not exist, we won't be able to create the FK correctly.

I see your point... can we remove

    ON DELETE CASCADE ON UPDATE CASCADE

from

    CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`,
`letter_code`, `branchcode`) REFERENCES `letter` (`module`, `code`,
`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE


So that at least we're not losing lines in 'message_transports' if we happen to
delete a row from the letter table?

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.