From 35673cec34c9874e0a5232b70747a4cacbb5bc83 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 27 Feb 2018 10:38:47 -0300
Subject: [PATCH] Bug 19289: Use copyrightdate instead of publicationyear for
 MARC21

See comment 24
---
 .../en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql      | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
index 33997d1bc4..158f181057 100644
--- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
+++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
@@ -4484,7 +4484,7 @@ WHERE frameworkcode="" AND tagfield IN (
         OR  kohafield="biblio.author"
         OR  kohafield="biblioitems.publishercode"
         OR  kohafield="biblioitems.editionstatement"
-        OR  kohafield="biblioitems.publicationyear"
+        OR  kohafield="biblio.copyrightdate"
         OR  kohafield="biblioitems.isbn"
         OR  kohafield="biblio.seriestitle"
     ) AND frameworkcode=""
@@ -4493,4 +4493,4 @@ INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac
 SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength
 FROM marc_subfield_structure
 WHERE frameworkcode=""
-AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblioitems.publicationyear", "biblioitems.isbn", "biblio.seriestitle" );
+AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" );
-- 
2.11.0