Bugzilla – Attachment 73948 Details for
Bug 19289
Allow configuration of the fields on the 'Catalog details' form in the acquisition baskets
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 19289: (follow-up) Add existing fields to the ACQ framework
Bug-19289-follow-up-Add-existing-fields-to-the-ACQ.patch (text/plain), 26.85 KB, created by
Jonathan Druart
on 2018-04-10 15:12:48 UTC
(
hide
)
Description:
Bug 19289: (follow-up) Add existing fields to the ACQ framework
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2018-04-10 15:12:48 UTC
Size:
26.85 KB
patch
obsolete
>From e8f59fefb2dbbcb56e7bcd619525c082fcd1887e Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Mon, 9 Apr 2018 12:52:31 -0300 >Subject: [PATCH] Bug 19289: (follow-up) Add existing fields to the ACQ > framework > >Changes for other frameworks >--- > .../optional/marc21_simple_bib_frameworks.sql | 22 ++++++++++++++++++++++ > .../optional/marc21_simple_bib_frameworks.sql | 22 ++++++++++++++++++++++ > .../obligatoire/marc21_sample_acq_framework.sql | 22 ++++++++++++++++++++++ > .../Optionnel/marc21_simple_bib_frameworks.sql | 22 ++++++++++++++++++++++ > .../Obligatoire/framework_DEFAULT.sql | 22 ++++++++++++++++++++++ > .../optional/marc21_simple_bib_frameworks.sql | 22 ++++++++++++++++++++++ > .../optional/marc21_simple_bib_frameworks.sql | 22 ++++++++++++++++++++++ > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 22 ++++++++++++++++++++++ > .../unimarc_bibliographic_DEFAULT_general.sql | 22 ++++++++++++++++++++++ > .../marc21_bibliographic_DEFAULT_general.sql | 22 ++++++++++++++++++++++ > .../unimarc_bibliographic_DEFAULT_general.sql | 22 ++++++++++++++++++++++ > 11 files changed, 242 insertions(+) > >diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index e39423844a..1cc33529b2 100644 >--- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -500,3 +500,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='952' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblio.copyrightdate" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); >diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index 188885be68..2d1f009a7f 100644 >--- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -500,3 +500,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='952' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblio.copyrightdate" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); >diff --git a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_sample_acq_framework.sql b/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_sample_acq_framework.sql >index c371d95bdd..f5131375d8 100644 >--- a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_sample_acq_framework.sql >+++ b/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_sample_acq_framework.sql >@@ -11,6 +11,28 @@ SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, koha > FROM marc_subfield_structure > WHERE frameworkcode = ''; > >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblio.copyrightdate" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); >+ > -- ************************************** > -- IGNORE CERTAINES SOUS-ZONES EXEMPLAIRE > -- ************************************** >diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >index b8bc4b48b5..c7c6be639f 100644 >--- a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >@@ -31494,3 +31494,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='995' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblio.copyrightdate" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); >diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql >index 8937249c1a..32ac673e90 100644 >--- a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql >+++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql >@@ -7894,3 +7894,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='995' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblioitems.publicationyear" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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" ); >diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index 23911590df..6a0a3643a5 100644 >--- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -500,3 +500,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='952' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblio.copyrightdate" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); >diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index 6e84df20d7..b515756396 100644 >--- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -31486,3 +31486,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='952' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblio.copyrightdate" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); >diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index 1ac10aaa09..15b7db6bc7 100644 >--- a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -4006,3 +4006,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='952' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblio.copyrightdate" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); >diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql >index cc0e7ce58f..5c48729b59 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql >@@ -2218,3 +2218,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='995' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblioitems.publicationyear" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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" ); >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >index 5c2b890e04..74eb9dfd28 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >@@ -4228,3 +4228,25 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='952' AND frameworkcode=''; >+ >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblio.copyrightdate" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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", "biblio.copyrightdate", "biblioitems.isbn", "biblio.seriestitle" ); >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql >index 7297ecbdcf..2d690b1cbd 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql >@@ -2221,4 +2221,26 @@ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, > INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) > 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 tagfield='995' AND frameworkcode=''; > >+INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' >+FROM marc_tag_structure >+WHERE frameworkcode="" AND tagfield IN ( >+ SELECT tagfield >+ FROM marc_subfield_structure >+ WHERE ( >+ kohafield="biblio.title" >+ OR kohafield="biblio.author" >+ OR kohafield="biblioitems.publishercode" >+ OR kohafield="biblioitems.editionstatement" >+ OR kohafield="biblioitems.publicationyear" >+ OR kohafield="biblioitems.isbn" >+ OR kohafield="biblio.seriestitle" >+ ) AND frameworkcode="" >+); >+INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) >+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" ); >+ > SET FOREIGN_KEY_CHECKS=1; >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 19289
:
68640
|
68641
|
68810
|
68811
|
69015
|
69016
|
69114
|
69115
|
70706
|
70765
|
72256
|
72257
|
72258
|
72259
|
73800
|
73819
|
73820
|
73821
|
73822
|
73823
|
73878
|
73948
|
73994