https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18086
Kyle M Hall <k...@bywatersolutions.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #105424|0 |1
is obsolete| |
--- Comment #17 from Kyle M Hall <k...@bywatersolutions.com> ---
Created attachment 105551
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=105551&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.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://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/
