From 39dc8b5a9da902f9f90850421dc2815e448222e5 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 --- ...ug_14820_add_prefs_SMSSendUsername_and_SMSSendPassword.sql | 3 +++ installer/data/mysql/sysprefs.sql | 2 ++ .../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 88a1f5f44e..39ed1b6476 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -398,6 +398,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 c5a1744977..9cc6c879a2 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 @@ -98,6 +98,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.20.1