From a5f71c0bdbf1bbc4c526755b0e5ee5068b8e26b1 Mon Sep 17 00:00:00 2001 From: Chris Date: Wed, 20 Apr 2016 08:44:06 +1200 Subject: [PATCH] Bug 16282 : Setting up the database for case sensitive usernames Just adding a syspref For upgrade, current behaviour stays the same For new installs, usernames are now case sensitive --- installer/data/mysql/atomicupdate/bug_16282.sql | 1 + installer/data/mysql/sysprefs.sql | 3 ++- .../intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref | 6 ++++++ 3 files changed, 9 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_16282.sql diff --git a/installer/data/mysql/atomicupdate/bug_16282.sql b/installer/data/mysql/atomicupdate/bug_16282.sql new file mode 100644 index 0000000..87a2c87 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_16282.sql @@ -0,0 +1 @@ +INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('UsernamesCaseSensitive','0','If ON, usernames are evaluated case sensitively when users are logging in','','YesNo') ; diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index ef4c3f0..9c12c67 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -532,5 +532,6 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('XSLTDetailsDisplay','default','','Enable XSL stylesheet control over details page display on intranet','Free'), ('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'), ('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'), -('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo') +('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'), +('UsernamesCaseSensitive','1','','If ON, usernames are evaluated case sensitively when users are logging in','YesNo') ; diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref index 22c2b27..9f7bdad 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref @@ -159,6 +159,12 @@ Patrons: yes: Do no: "Don't" - charge a fee when a patron changes to a category with an enrollment fee. + - + - Usernames are case sensitive + - pref: UsernamesCaseSensitive + choices: + yes: "Yes" + no: "No" "Norwegian patron database": - - pref: NorwegianPatronDBEnable -- 1.7.10.4