From 517e4eb553e31dad4d7d49a6c2b2222884423d75 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 16 Aug 2016 09:18:19 +0100
Subject: [PATCH] Bug 7045: Update default value placeholders for existing
 installs
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Marc Véron <veron@veron.ch>

Signed-off-by: Katrin Fischer  <katrin.fischer@bsz-bw.de>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit 547b5f95f62a00e360c5cac4e416d30365429fcb)
Signed-off-by: Frédéric Demians <f.demians@tamil.fr>
---
 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 0000000000..01608ac005
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_7045.sql
@@ -0,0 +1,4 @@
+update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'YYYY', '<<YYYY>>') where defaultvalue like "%YYYY%" and defaultvalue not like "%<<YYYY>>%";
+update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'MM', '<<MM>>') where defaultvalue like "%MM%" and defaultvalue not like "%<<MM>>%";
+update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'DD', '<<DD>>') where defaultvalue like "%DD%" and defaultvalue not like "%<<DD>>%";
+update marc_subfield_structure set defaultvalue=REPLACE(defaultvalue, 'user', '<<USER>>') where defaultvalue like "%user%" and defaultvalue not like "%<<USER>>%";
-- 
2.39.5