From 71fbc84446ca4cc0191d7c019096f99bcfbf9fa3 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 16 Aug 2016 09:18:19 +0100 Subject: [PATCH] [PASSED QA] Bug 7045: Update default value placeholders for existing installs MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Marc VĂ©ron Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug_7045.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_7045.sql diff --git a/installer/data/mysql/atomicupdate/bug_7045.sql b/installer/data/mysql/atomicupdate/bug_7045.sql new file mode 100644 index 0000000..01608ac --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_7045.sql @@ -0,0 +1,4 @@ +update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'YYYY', '<>') where defaultvalue like "%YYYY%" and defaultvalue not like "%<>%"; +update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'MM', '<>') where defaultvalue like "%MM%" and defaultvalue not like "%<>%"; +update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'DD', '<
>') where defaultvalue like "%DD%" and defaultvalue not like "%<
>%"; +update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'user', '<>') where defaultvalue like "%user%" and defaultvalue not like "%<>%"; -- 2.7.4