[Bug 37599] New: Increase char limit of borrowers.userid database field
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37599 Bug ID: 37599 Summary: Increase char limit of borrowers.userid database field Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: alexbuckley@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org It would be nice if the Koha database field borrowers.userid had a higher char limit than 75 characters. Increasingly, libraries are using organisational emails as a userid for single-sign-on. These email addresses cannot always be stored in the Koha borrowers.email field So the borrowers.userid has to be used for storing it. However, if an email address is long then it may not fit within the current 75 character limit of borrowers.userid. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37599 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- We also have this use case as for authentication it needs to be in userid. We haven't run into the character limit (yet), but it seems a good idea to increase it. Please keep deleted_borrowers and borrower_modifications in mind :) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37599 --- Comment #2 from Alex Buckley <alexbuckley@catalyst.net.nz> --- (In reply to Katrin Fischer from comment #1)
We also have this use case as for authentication it needs to be in userid. We haven't run into the character limit (yet), but it seems a good idea to increase it.
Please keep deleted_borrowers and borrower_modifications in mind :)
thanks for noting this Katrin, much appreciated! Yes, that is a good point that this change would need to happen on deleted_borrowers and borrower_modifications as well -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org