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
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on: 17494
Blocks:
  Show dependency tree / graph
 
Reported: 2016-11-04 10:07 UTC by Kyle M Hall (khall)
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:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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