From bbfc99545d57249f7f345c9ff0a07022dc02fa46 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 Content-Type: text/plain; charset=utf-8 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 --- .../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 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 88a1f5f..39ed1b6 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 c5a1744..9cc6c87 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: -- 1.7.10.4