From a46d470214324ec6b4e71a14bb7022d0e8d7380d Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 21 Aug 2014 13:15:36 +0200 Subject: [PATCH] Bug 12802: DB changes - Set type multiple for AutoEmailPrimaryAddress Signed-off-by: Brendan Gallagher --- .../bug_12802-change-autoemailprimaryddress-syspref-type.sql | 1 + installer/data/mysql/sysprefs.sql | 2 +- koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref | 2 +- 3 files changed, 3 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_12802-change-autoemailprimaryddress-syspref-type.sql diff --git a/installer/data/mysql/atomicupdate/bug_12802-change-autoemailprimaryddress-syspref-type.sql b/installer/data/mysql/atomicupdate/bug_12802-change-autoemailprimaryddress-syspref-type.sql new file mode 100644 index 0000000000..6a7cb9146d --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_12802-change-autoemailprimaryddress-syspref-type.sql @@ -0,0 +1 @@ +UPDATE systempreferences SET type='multiple' WHERE variable='AutoEmailPrimaryAddress'; \ No newline at end of file diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index bc08b5a5d3..cfa075e69f 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -59,7 +59,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('autoBarcode','OFF','incremental|annual|hbyymmincr|EAN13|OFF','Used to autogenerate a barcode: incremental will be of the form 1, 2, 3; annual of the form 2007-0001, 2007-0002; hbyymmincr of the form HB08010001 where HB=Home Branch','Choice'), ('AutoCreateAuthorities','0',NULL,'Automatically create authorities that do not exist when cataloging records.','YesNo'), ('AutoEmailOpacUser','0',NULL,'Sends notification emails containing new account details to patrons - when account is created.','YesNo'), -('AutoEmailPrimaryAddress','OFF','email|emailpro|B_email|cardnumber|OFF','Defines the default email address where \'Account Details\' emails are sent.','Choice'), +('AutoEmailPrimaryAddress','OFF','email|emailpro|B_email|cardnumber|OFF','Defines the default email address where \'Account Details\' emails are sent.','multiple'), ('AutoLocation','0',NULL,'If ON, IP authentication is enabled, blocking access to the staff client from unauthorized IP addresses','YesNo'), ('AutomaticItemReturn','1',NULL,'If ON, Koha will automatically set up a transfer of this item to its homebranch','YesNo'), ('autoMemberNum','1','','If ON, patron number is auto-calculated','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 3a95ba71aa..765057cacb 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 @@ -10,7 +10,7 @@ Patrons: - "Use" - pref: AutoEmailPrimaryAddress default: "OFF" - choices: + multiple: email: home emailpro: work B_email: alternate -- 2.11.0