Bug 18110: Do not update value for existing installs

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>

diff --git a/installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql b/installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql
index 3cf8df8..5cd738c 100644 (file)
--- a/installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql
+++ b/installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql
@@ -1 +1 @@
-UPDATE systempreferences  SET value='us', options = 'us | de | fr' WHERE variable = 'AddressFormat';
+UPDATE systempreferences  SET options = 'us|de|fr' WHERE variable = 'AddressFormat';

diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql
index 1ec1dc4..504f5d7 100644 (file)
--- a/installer/data/mysql/sysprefs.sql
+++ b/installer/data/mysql/sysprefs.sql
@@ -6,7 +6,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
 ('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),
 ('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: his own only, any within his branch or all','Choice'),
 ('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),
-('AddressFormat','us','us | de | fr','Choose format to display postal addresses', 'Choice'),
+('AddressFormat','us','us|de|fr','Choose format to display postal addresses', 'Choice'),
 ('advancedMARCeditor','0','','If ON, the MARC editor won\'t display field/subfield descriptions','YesNo'),
 ('AdvancedSearchLanguages','','','ISO 639-2 codes of languages you wish to see appear as an Advanced search option.  Example: eng|fre|ita','Textarea'),
 ('AdvancedSearchTypes','itemtypes','itemtypes|ccode','Select which set of fields comprise the Type limit in the advanced search','Choice'),