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 <m.de.rooy@rijksmuseum.nl>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Tomas Cohen Arazi <tomascohen@unc.edu.ar>
(cherry picked from commit 39dc8b5a9da902f9f90850421dc2815e448222e5)
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
(cherry picked from commit 27e58d8a204b5977d6ca64567a79f1ee90df9e6f)
Signed-off-by: Liz Rea <wizzyrea@gmail.com>

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 (file)
index 0000000..43a1d08
--- /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 85b91de..9537f5d 100644 (file)
--- 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 aa567c3..6d3536c 100644 (file)
--- 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: