https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17160 --- Comment #2 from Barton Chittenden <barton@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.