Bug 17549

Summary: Table borrower_modifications allows for duplication verification tokens
Product: Koha Reporter: Kyle M Hall (khall) <kyle>
Component: Architecture, internals, and plumbingAssignee: Galen Charlton <gmcharlt>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 17494    
Bug Blocks:    

Description Kyle M Hall (khall) 2016-11-04 10:07:03 UTC
Due to the multi-key nature of the borrower modifications table, it is possible to allow duplicate verification tokens to enter the database. It would be better to give this table a unique id column and add individual UNQIUE constraints to both the borrowernumber and verification token columns.