@@ -, +, @@ framework --- .../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 ++++++++++++++++++++++ .../unimarc_bibliographic_DEFAULT_general.sql | 22 ++++++++++++++++++++++ .../marc21_bibliographic_DEFAULT_general.sql | 22 ++++++++++++++++++++++ .../unimarc_bibliographic_DEFAULT_general.sql | 22 ++++++++++++++++++++++ 10 files changed, 220 insertions(+) --- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ a/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" ); --- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ a/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" ); --- a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_sample_acq_framework.sql +++ a/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 -- ************************************** --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql +++ a/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" ); --- a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql +++ a/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" ); --- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ a/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" ); --- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ a/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" ); --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql +++ a/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" ); --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql +++ a/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" ); --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_general.sql +++ a/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; --