From 2c46810e7ba7ae5a7924e116dcdfbcc7af2ea849 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 15 Sep 2015 10:36:44 +0100 Subject: [PATCH] Bug 14820: Add missing prefs SMSSendUsername and SMSSendPassword These 2 system preferences are missing from the sysprefs.sql file. Test plan: Execute the updatedatabase script and confirm that the 2 prefs are now in the systempreferences table. Search for "sms" in the system preferences search box, you should see the 3 prefs. Signed-off-by: Marcel de Rooy Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 39dc8b5a9da902f9f90850421dc2815e448222e5) Signed-off-by: Chris Cormack (cherry picked from commit 27e58d8a204b5977d6ca64567a79f1ee90df9e6f) Signed-off-by: Liz Rea --- .../bug_14820_add_prefs_SMSSendUsername_and_SMSSendPassword.sql | 3 +++ installer/data/mysql/sysprefs.sql | 2 ++ .../intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref | 4 ++++ 3 files changed, 9 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_14820_add_prefs_SMSSendUsername_and_SMSSendPassword.sql diff --git a/installer/data/mysql/atomicupdate/bug_14820_add_prefs_SMSSendUsername_and_SMSSendPassword.sql b/installer/data/mysql/atomicupdate/bug_14820_add_prefs_SMSSendUsername_and_SMSSendPassword.sql new file mode 100644 index 0000000000..43a1d08aa7 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14820_add_prefs_SMSSendUsername_and_SMSSendPassword.sql @@ -0,0 +1,3 @@ +INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES +('SMSSendPassword', '', '', 'Password used to send SMS messages', 'free'), +('SMSSendUsername', '', '', 'Username/Login used to send SMS messages', 'free'); diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index 85b91de95c..9537f5d6ed 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -384,6 +384,8 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('singleBranchMode','0',NULL,'Operate in Single-branch mode, hide branch selection in the OPAC','YesNo'), ('SlipCSS','',NULL,'Slips CSS url.','free'), ('SMSSendDriver','','','Sets which SMS::Send driver is used to send SMS messages.','free'), +('SMSSendPassword', '', '', 'Password used to send SMS messages', 'free'), +('SMSSendUsername', '', '', 'Username/Login used to send SMS messages', 'free'), ('SocialNetworks','0','','Enable/Disable social networks links in opac detail pages','YesNo'), ('soundon','0','','Enable circulation sounds during checkin and checkout in the staff interface. Not supported by all web browsers yet.','YesNo'), ('SpecifyDueDate','1','','Define whether to display \"Specify Due Date\" form in Circulation','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 aa567c3aed..6d3536c550 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 @@ -105,6 +105,10 @@ Patrons: - "Use the SMS::Send::" - pref: SMSSendDriver - driver to send SMS messages. + - "Define a username/login" + - pref: SMSSendUsername + - "and a password" + - pref: SMSSendPassword - - pref: uppercasesurnames choices: -- 2.11.4.GIT