Bug 17549 - Table borrower_modifications allows for duplication verification tokens
Summary: Table borrower_modifications allows for duplication verification tokens
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on: 17494
Blocks:
  Show dependency treegraph
 
Reported: 2016-11-04 10:07 UTC by Kyle M Hall
Modified: 2016-11-04 10:07 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Kyle M Hall 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.