https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18086 --- Comment #3 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 105368 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=105368&action=edit Bug 18086: Add FK constraints for branchcode and categorycode The overduerules table has no foreign key constraints to any for the related tables. The columns for branchcode, categorycode, letter1, letter2, and letter3 should all be foreign keys. Test Plan: 0) Create some overdue rules with invalid branchcodes and categorycodes 1) Apply this patch 2) Restart all the things! 3) Run updatedatabase.pl 4) Note the invalid rules are deleted 5) Note Default codes are NULL now instead of empty strings 6) Editor should behave as it did before -- You are receiving this mail because: You are watching all bug changes.