Bug 13484

Summary: Suggestions should have a foreign key constraint for branchcode
Product: Koha Reporter: Kyle M Hall <kyle>
Component: AcquisitionsAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: katrin.fischer, marjorie.barry-vila, martin.renvoize
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5334
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13533
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 10753    
Bug Blocks:    

Description Kyle M Hall 2014-12-19 13:47:39 UTC
The table suggestions should have a key constraint to eliminate the possibility of bad branchcodes being added to the table. Any "any library" suggestions should have a branchcode of NULL.
Comment 1 Martin Renvoize 2019-02-21 09:33:49 UTC

*** This bug has been marked as a duplicate of bug 22368 ***