Typos in Koha database description (Table "borrowers")
Hi Recently I have found some typos in the SchemaSpy description of table "borrowers". * http://schema.koha-community.org/16_11/tables/borrowers.html 1. In the comment for field "debarred" (YYY-MM-DD) should by replaced by (YYYY-MM-DD) 2. In the comment for field "smsalertnumber" SNS should be replaced by SMS 3. In the comments of fields "contactname", "contacttitle", "guarantorid", "relationship" the term "guarentor" is used, but it should be "guarantor". 4. The comment for field "password" reads "patron/borrower's encrypted password". I think it could be mkore explicit by writing "patron/borrower's MD5 encrypted password". Where can I correct these typos? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Michael, The tables are defined in installer/data/mysql/kohastructure.sql. I'm not sure off hand if it's kosher to edit that directly, or if all changes must be made via updatedatabase.pl. Also, Koha no longer uses md5 encryption. I think we use SHA512, IIRC. Sorry to be vague. --Barton On Sat, May 27, 2017 at 9:47 AM, Michael Kuhn <mik@adminkuhn.ch> wrote:
Hi
Recently I have found some typos in the SchemaSpy description of table "borrowers". * http://schema.koha-community.org/16_11/tables/borrowers.html
1. In the comment for field "debarred" (YYY-MM-DD) should by replaced by (YYYY-MM-DD)
2. In the comment for field "smsalertnumber" SNS should be replaced by SMS
3. In the comments of fields "contactname", "contacttitle", "guarantorid", "relationship" the term "guarentor" is used, but it should be "guarantor".
4. The comment for field "password" reads "patron/borrower's encrypted password". I think it could be mkore explicit by writing "patron/borrower's MD5 encrypted password".
Where can I correct these typos?
Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Barton
The tables are defined in installer/data/mysql/kohastructure.sql. I'm not sure off hand if it's kosher to edit that directly, or if all changes must be made via updatedatabase.pl <http://updatedatabase.pl>.
OK, so I think I won't be the right person to make edits there.
Also, Koha no longer uses md5 encryption. I think we use SHA512, IIRC.
Sorry to be vague.
Yes, no more MD5. I found the following post: * https://lists.katipo.co.nz/pipermail/koha/2014-February/038653.html There Galen Charlton wrote: "Starting with 3.14, Crypt::Eksblowfish::Bcrypt rather than Digest::MD5 is used to hash the passwords." However I think it would be useful to explicitly mention the used encryption. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
On Sat, May 27, 2017 at 12:20 PM, Michael Kuhn <mik@adminkuhn.ch> wrote:
Yes, no more MD5. I found the following post: * https://lists.katipo.co.nz/pipermail/koha/2014-February/038653.html
There Galen Charlton wrote: "Starting with 3.14, Crypt::Eksblowfish::Bcrypt rather than Digest::MD5 is used to hash the passwords."
However I think it would be useful to explicitly mention the used encryption.
I agree entirely :-) --Barton
participants (2)
-
Barton Chittenden -
Michael Kuhn