@@ -, +, @@ --- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 -- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 -- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 -- .../marc21/Obligatoire/marc21_framework_DEFAULT.sql | 2 -- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 -- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 -- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 1 - .../mandatory/marc21_bibliographic_DEFAULT_general.sql | 6 +----- .../mandatory/marc21_bibliographic_DEFAULT_general.sql | 7 ++----- 9 files changed, 3 insertions(+), 23 deletions(-) --- a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -183,7 +183,6 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('016', 'Kontrollnummer der nationalbibliografischen Agentur', 'Kontrollnummer der nationalbibliografischen Agentur', 1, 0, '', ''), ('017', 'Nummer des Copyrights oder der Pflichtabgabe', 'Nummer des Copyrights oder der Pflichtabgabe', 1, 0, '', ''), ('018', 'Code zu Artikelgebühren bei Copyright', 'Code zu Artikelgebühren bei Copyright', 0, 0, '', ''), - ('01e', 'CODED FIELD ERROR (RLIN)', 'CODED FIELD ERROR (RLIN)', 'CODED FIELD ERROR (RLIN)', 0, '', ''), ('020', 'Internationale Standardbuchnummer', 'Internationale Standardbuchnummer', 1, 0, NULL, ''), ('022', 'Internationale Standardseriennummer', 'Internationale Standardseriennummer', 1, 0, NULL, ''), ('023', 'STANDARD FILM NUMBER (VM) [DELETED]', 'STANDARD FILM NUMBER (VM) [DELETED]', 1, 0, NULL, ''), @@ -556,7 +555,6 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('018', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', 'a', 'Code für Copyright-Artikelgebühren', 'Code für Copyright-Artikelgebühren', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('01e', 'a', 'Coded field error', 'Coded field error', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', 'a', 'Internationale Standardbuchnummer', 'Internationale Standardbuchnummer', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, '', '', '', NULL), --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -183,7 +183,6 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, '', ''), ('017', 'COPYRIGHT OR LEGAL DEPOSIT NUMBER', 'COPYRIGHT OR LEGAL DEPOSIT NUMBER', 1, 0, '', ''), ('018', 'COPYRIGHT ARTICLE-FEE CODE', 'COPYRIGHT ARTICLE-FEE CODE', 0, 0, '', ''), - ('01e', 'CODED FIELD ERROR (RLIN)', 'CODED FIELD ERROR (RLIN)', 1, 0, '', ''), ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, ''), ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, ''), ('023', 'STANDARD FILM NUMBER (VM) [DELETED]', 'STANDARD FILM NUMBER (VM) [DELETED]', 1, 0, NULL, ''), @@ -559,7 +558,6 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('018', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', 'a', 'Copyright article-fee code', 'Copyright article-fee code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('01e', 'a', 'Coded field error', 'Coded field error', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, '', '', '', NULL), --- a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -183,7 +183,6 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('016', 'NÚMERO DE CONTROL DE UNA AGENCIA BIBLIOGRÁFICA NACIONAL', 'NÚMERO DE CONTROL DE UNA AGENCIA BIBLIOGRÁFICA NACIONAL', 1, 0, '', ''), ('017', 'NÚMERO DE COPYRIGHT O DE DEPÓSITO LEGAL', 'NÚMERO DE COPYRIGHT O DE DEPÓSITO LEGAL', 1, 0, '', ''), ('018', 'DERECHOS DE AUTOR DEL ARTÍCULO-CÓDIGO DE TARIFA', 'DERECHOS DE AUTOR DEL ARTÍCULO-CÓDIGO DE TARIFA', 0, 0, '', ''), - ('01e', 'CODED FIELD ERROR (RLIN)', 'ERROR DE CAMPO CODIFICADO (RLIN)', 'ERROR DE CAMPO CODIFICADO (RLIN)', 0, '', ''), ('020', 'NÚMERO INTERNACIONAL ESTÁNDAR DEL LIBRO', 'NÚMERO INTERNACIONAL ESTÁNDAR DEL LIBRO', 1, 0, NULL, ''), ('022', 'NÚMERO INTERNACIONAL NORMALIZADO PARA PUBLICACIONES SERIADAS', 'NÚMERO INTERNACIONAL NORMALIZADO PARA PUBLICACIONES SERIADAS', 1, 0, NULL, ''), ('023', 'NÚMERO ESTÁNDAR DE PELÍCULAS (VM) [BORRADO]', 'NÚMERO ESTÁNDAR DE PELÍCULAS (VM) [BORRADO]', 1, 0, NULL, ''), @@ -553,7 +552,6 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('018', '6', 'Enlace', 'Enlace', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', 'a', 'Derechos de autor del artículo-código de tarifa', 'Derechos de autor del artículo-código de tarifa', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('01e', 'a', 'Error de campo codificado', 'Error de campo codificado', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '6', 'Enlace', 'Enlace', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', 'a', 'Número Internacional Estándar del Libro', 'Número Internacional Estándar del Libro', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, '', '', '', NULL), --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql +++ a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql @@ -199,7 +199,6 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, '', ''), ('017', 'COPYRIGHT OR LEGAL DEPOSIT NUMBER', 'COPYRIGHT OR LEGAL DEPOSIT NUMBER', 1, 0, '', ''), ('018', 'COPYRIGHT ARTICLE-FEE CODE', 'COPYRIGHT ARTICLE-FEE CODE', 0, 0, '', ''), - ('01e', 'CODED FIELD ERROR (RLIN)', 'CODED FIELD ERROR (RLIN)', 1, 0, '', ''), ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, ''), ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, ''), ('023', 'STANDARD FILM NUMBER (VM) [DELETED]', 'STANDARD FILM NUMBER (VM) [DELETED]', 1, 0, NULL, ''), @@ -538,7 +537,6 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('018', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', 'a', 'Copyright article-fee code', 'Copyright article-fee code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('01e', 'a', 'Coded field error', 'Coded field error', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, '', '', '', NULL), --- a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -183,7 +183,6 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, ('016', 'Numero di controllo dell\'agenzia bibliografica nazionale', 'Numero di controllo dell\'agenzia bibliografica nazionale', 1, 0, '', ''), ('017', 'Numero di copyright o di deposito legale', 'Numero di copyright o di deposito legale', 1, 0, '', ''), ('018', 'Codice di tassa sul copyright dell’articolo', 'Codice di tassa sul copyright dell’articolo', 0, 0, '', ''), - ('01e', 'CODED FIELD ERROR (RLIN)', 'CODED FIELD ERROR (RLIN)', 'CODED FIELD ERROR (RLIN)', 0, '', ''), ('020', 'ISBN (International Standard Book Number)', 'ISBN (International Standard Book Number)', 1, 0, NULL, ''), ('022', 'ISSN (International Standard Serial Number)', 'ISSN (International Standard Serial Number)', 1, 0, NULL, ''), ('023', 'STANDARD FILM NUMBER (VM) [DELETED]', 'STANDARD FILM NUMBER (VM) [DELETED]', 1, 0, NULL, ''), @@ -553,7 +552,6 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('018', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', 'a', 'Codice di tassa sul copyright dell\'articolo', 'Codice di tassa sul copyright dell\'articolo', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('01e', 'a', 'Coded field error', 'Coded field error', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '6', 'Collegamento', 'Collegamento', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', 'a', 'ISBN (International Standard Book Number)', 'ISBN (International Standard Book Number)', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, '', '', '', NULL), --- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -199,7 +199,6 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, '', ''), ('017', 'COPYRIGHT OR LEGAL DEPOSIT NUMBER', 'COPYRIGHT OR LEGAL DEPOSIT NUMBER', 1, 0, '', ''), ('018', 'COPYRIGHT ARTICLE-FEE CODE', 'COPYRIGHT ARTICLE-FEE CODE', 0, 0, '', ''), - ('01e', 'CODED FIELD ERROR (RLIN)', 'CODED FIELD ERROR (RLIN)', 1, 0, '', ''), ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, ''), ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, ''), ('023', 'STANDARD FILM NUMBER (VM) [DELETED]', 'STANDARD FILM NUMBER (VM) [DELETED]', 1, 0, NULL, ''), @@ -538,7 +537,6 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('018', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', 'a', 'Copyright article-fee code', 'Copyright article-fee code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('01e', 'a', 'Coded field error', 'Coded field error', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, '', '', '', NULL), --- a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -537,7 +537,6 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('018', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('018', 'a', 'Copyright article-fee code', 'Copyright article-fee code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), - ('01e', 'a', 'Coded field error', 'Coded field error', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), ('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, '', '', '', NULL), --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql +++ a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql @@ -105,13 +105,9 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '018', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 0, -6, '', '', '', 0, '', '', NULL), ('', '', '018', 'a', 0, 0, 'Код копирайта', '', 0, -6, '', '', '', 0, '', '', NULL); -INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '01e', 0, 1, 'Ошибка кодированного имени', '', ''); -INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('', '', '01e', 'a', 0, 0, 'Ошибка кодированного имени', '', 0, -6, '', '', '', 0, '', '', NULL); - INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '020', 0, 1, 'Индекс ISBN', '', NULL); + INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('', '', '020', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, -6, '', '', '', 0, '', '', NULL), ('', '', '020', '8', 0, 1, 'Связь поля и ее порядковый номер', '', 0, -6, '', '', '', 0, '', '', NULL), --- 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 @@ -112,13 +112,9 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '018', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 0, -6, '', '', '', 0, '', '', NULL), ('', '', '018', 'a', 0, 0, 'Код копірайту', '', 0, -6, '', '', '', 0, '', '', NULL); -INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '01e', 0, 1, 'Помилка кодованого імені', '', ''); -INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('', '', '01e', 'a', 0, 0, 'Помилка кодованого імені', '', 0, -6, '', '', '', 0, '', '', NULL); - INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '020', 0, 1, 'Індекс ISBN', '', ''); + INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('', '', '020', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, -6, '', '', '', 0, '', '', NULL), ('', '', '020', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 0, -6, '', '', '', 0, '', '', NULL), @@ -128,6 +124,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '022', 0, 1, 'Індекс ISSN', '', ''); + INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES ('', '', '022', '2', 0, 0, 'Source', 'Source', 0, 0, '', '', '', 0, '', '', NULL), ('', '', '022', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, -6, '', '', '', 0, '', '', NULL), --