https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17160
--- Comment #2 from Barton Chittenden <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
