From dc487b98504606163fa1b81e882ec324edfcea7a Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 15 Sep 2015 10:36:44 +0100 Subject: [PATCH] [PASSED QA] 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 --- .../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.9.1