From 9ff12495c12dc859a26d69f342f34955feb5e598 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 26 Apr 2017 15:41:35 -0300 Subject: [PATCH] Bug 18110: Do not update value for existing installs Signed-off-by: Jonathan Druart --- installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql | 2 +- installer/data/mysql/sysprefs.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql b/installer/data/mysql/atomicupdate/bug18110_updated_AddressFormat.sql index 3cf8df8..5cd738c 100644 --- 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 --- 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'), -- 2.9.3