From 61b40e16a0b9412a7eea24a4f14e06a690fa3654 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Sat, 11 Jul 2015 18:49:45 +0200 Subject: [PATCH] Bug 14199: Modify webinstaller sql files for marc21_orgcode plugin This patch updates the sql installer files for new installations. Occurrences to the three plugins marc21_field_003, 040c and 040d are replaced by marc21_orgcode.pl. This has been generated by one sed statement. Test plan: [1] Run a new installation or run some of the changed sql files manually. [2] Verify that marc21_orgcode is linked to fields previously linked to the three old plugins. [3] Do a git grep on the three plugin file names. No occurrences expected. Signed-off-by: Marcel de Rooy Have tested the three english sql files: authorities_normal_marc21.sql: 18 rows with marc21_orgcode (003 and 040a for 9 auth codes) marc21_framework_DEFAULT.sql: 1 row with marc21_orgcode (003) -- this patch does not add them to 040c or 040d; no behavior change.. marc21_simple_bib_frameworks.sql: 8 rows (003 for 8 frameworks) Signed-off-by: Bernardo Gonzalez Kriegel Signed-off-by: Marcel de Rooy The following files do no longer need an adjustment: installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql For details, check Bug 15097: Update MARC21 de-DE frameworks to Update 21. And similar reports for es-ES and it-IT. Verified this change by installing de-DE in the webinstaller. The plugin for field 003 was correctly set to marc21_orgcode.pl. Signed-off-by: Jonathan Druart --- .../marc21/mandatory/authorities_normal_marc21.sql | 4 +-- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/authorities_normal_marc21.sql | 4 +-- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/authorities_normal_marc21.sql | 4 +-- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../Obligatoire/authorities_normal_marc21.sql | 36 +++++++++++----------- .../Obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../Optionnel/marc21_simple_bib_frameworks.sql | 16 +++++----- .../marc21/mandatory/authorities_normal_marc21.sql | 4 +-- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/authorities_normal_marc21.sql | 36 +++++++++++----------- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 +++++----- .../marc21/mandatory/authorities_normal_marc21.sql | 36 +++++++++++----------- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../optional/marc21_simple_bib_frameworks.sql | 16 +++++----- .../marc21_authorities_DEFAULT_general.sql | 4 +-- .../marc21_bibliographic_DEFAULT_general.sql | 2 +- .../marc21_authorities_CHRON_TERM_general.sql | 4 +-- .../marc21_authorities_CORPO_NAME_general.sql | 4 +-- .../marc21_authorities_GENRE-FORM_general.sql | 4 +-- .../marc21_authorities_GEOGR_NAME_general.sql | 4 +-- .../marc21_authorities_MEETI_NAME_general.sql | 4 +-- .../marc21_authorities_PERSO_NAME_general.sql | 4 +-- .../marc21_authorities_TOPIC_TERM_general.sql | 4 +-- .../marc21_authorities_UNIF_TITLE_general.sql | 4 +-- .../optional/marc21_bibliographic_AR_general.sql | 2 +- .../optional/marc21_bibliographic_BKS_general.sql | 2 +- .../optional/marc21_bibliographic_CF_general.sql | 2 +- .../optional/marc21_bibliographic_IR_general.sql | 2 +- .../optional/marc21_bibliographic_KT_general.sql | 2 +- .../optional/marc21_bibliographic_SER_general.sql | 2 +- .../optional/marc21_bibliographic_SR_general.sql | 2 +- .../optional/marc21_bibliographic_VR_general.sql | 2 +- .../marc21_authorities_DEFAULT_general.sql | 4 +-- .../marc21_bibliographic_DEFAULT_general.sql | 2 +- .../marc21_authorities_CHRON_TERM_general.sql | 4 +-- .../marc21_authorities_CORPO_NAME_general.sql | 4 +-- .../marc21_authorities_GENRE-FORM_general.sql | 4 +-- .../marc21_authorities_GEOGR_NAME_general.sql | 4 +-- .../marc21_authorities_MEETI_NAME_general.sql | 4 +-- .../marc21_authorities_PERSO_NAME_general.sql | 4 +-- .../marc21_authorities_TOPIC_TERM_general.sql | 4 +-- .../marc21_authorities_UNIF_TITLE_general.sql | 4 +-- .../optional/marc21_bibliographic_AR_general.sql | 2 +- .../optional/marc21_bibliographic_BKS_general.sql | 2 +- .../optional/marc21_bibliographic_CF_general.sql | 2 +- .../optional/marc21_bibliographic_IR_general.sql | 2 +- .../optional/marc21_bibliographic_KT_general.sql | 2 +- .../optional/marc21_bibliographic_SER_general.sql | 2 +- .../optional/marc21_bibliographic_SR_general.sql | 2 +- .../optional/marc21_bibliographic_VR_general.sql | 2 +- 53 files changed, 147 insertions(+), 147 deletions(-) diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 1fac36b..e3f9e30 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -273,7 +273,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC-Kontrollnummer', 'LC-Kontrollnummer', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -351,7 +351,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Gelöschte/ungültige Kontrollnummer', 'Gelöschte/ungültige Kontrollnummer', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original-Katalogisierungsstelle', 'Original-Katalogisierungsstelle', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original-Katalogisierungsstelle', 'Original-Katalogisierungsstelle', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Katalogisierungssprache', 'Katalogisierungssprache', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Übertragungsstelle', 'Übertragungsstelle', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Bearbeitungsstelle', 'Bearbeitungsstelle', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index dd17b19..5a147c9 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -513,7 +513,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'Kontrollfeld', 'Kontrollfeld', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'Kontrollfeld mit fester Länge', 'Kontrollfeld mit fester Länge', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 83bf952..04b41b6 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -273,7 +273,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -351,7 +351,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid system control number', 'Canceled/invalid system control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 7f9a5a4..09db049 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 @@ -513,7 +513,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index f92a6d4..ddc932a 100644 --- a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -273,7 +273,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'campo de control', 'campo de control', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'campo de control', 'campo de control', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'campo de control', 'campo de control', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'campo de control', 'campo de control', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'Número de control de LC', 'Número de control de LC', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -351,7 +351,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Número de control cancelado/no válido', 'Número de control cancelado/no válido', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Enlace', 'Enlace', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Centro catalogador/agencia de origen', 'Centro catalogador/agencia de origen', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Centro catalogador/agencia de origen', 'Centro catalogador/agencia de origen', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Lengua de catalogación', 'Lengua de catalogación', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Centro/agencia transcriptor', 'Centro/agencia transcriptor', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Centro/agencia modificador', 'Centro/agencia modificador', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 1c84912..08ef881 100644 --- a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -513,7 +513,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'campo de control', 'campo de control', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'campo de control', 'campo de control', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'campo de control', 'campo de control', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'campo de control', 'campo de control', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'campo de control de longitud fija', 'campo de control de longitud fija', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql index 6d28c41..f9b7b7f 100644 --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql +++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql @@ -267,7 +267,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -337,7 +337,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1728,7 +1728,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('PERSO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1780,7 +1780,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('PERSO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2652,7 +2652,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CORPO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2704,7 +2704,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CORPO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3552,7 +3552,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('MEETI_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3622,7 +3622,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('MEETI_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4474,7 +4474,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('UNIF_TITLE', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4544,7 +4544,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('UNIF_TITLE', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5418,7 +5418,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CHRON_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5457,7 +5457,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CHRON_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6286,7 +6286,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('TOPIC_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6325,7 +6325,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('TOPIC_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7158,7 +7158,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GEOGR_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7197,7 +7197,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GEOGR_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8029,7 +8029,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GENRE/FORM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8050,7 +8050,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GENRE/FORM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql index 6dcb0ba..95de08a 100644 --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql @@ -501,7 +501,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), 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 05902a9..7b0e023 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 @@ -527,7 +527,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'BKS', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'BKS', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'BKS', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'BKS', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'BKS', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'BKS', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'BKS', '', '', NULL), @@ -4454,7 +4454,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'CF', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'CF', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'CF', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'CF', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'CF', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'CF', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'CF', '', '', NULL), @@ -8380,7 +8380,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SR', '', '', NULL), @@ -12306,7 +12306,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'VR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'VR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'VR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'VR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'VR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'VR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'VR', '', '', NULL), @@ -16230,7 +16230,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'AR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'AR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'AR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'AR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'AR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'AR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'AR', '', '', NULL), @@ -20154,7 +20154,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'KT', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'KT', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'KT', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'KT', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'KT', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'KT', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'KT', '', '', NULL), @@ -24080,7 +24080,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'IR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'IR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'IR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'IR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'IR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'IR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'IR', '', '', NULL), @@ -28001,7 +28001,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SER', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SER', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SER', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SER', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SER', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SER', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SER', '', '', NULL), diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index b3206a6..177f7d9 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -273,7 +273,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'campo di controllo', 'campo di controllo', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'campo di controllo', 'campo di controllo', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'campo di controllo', 'campo di controllo', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'campo di controllo', 'campo di controllo', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'Numero di controllo della LC', 'Numero di controllo della LC', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -351,7 +351,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Numero di controllo del sistema cancellato o errato', 'Numero di controllo del sistema cancellato o errato', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Collegamento', 'Collegamento', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Agenzia catalografica originale', 'Agenzia catalografica originale', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Agenzia catalografica originale', 'Agenzia catalografica originale', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Lingua della catalogazione', 'Lingua della catalogazione', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Agenzia che fa la trascrizione', 'Agenzia che fa la trascrizione', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Agenzia che fa la modifica', 'Agenzia che fa la modifica', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index a2e477c..e40b10a 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -513,7 +513,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'campo di controllo', 'campo di controllo', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'campo di controllo', 'campo di controllo', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'campo di controllo', 'campo di controllo', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'campo di controllo', 'campo di controllo', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'campo di controllo lung. fissa', 'campo di controllo lung. fissa', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 6d28c41..f9b7b7f 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -267,7 +267,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -337,7 +337,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1728,7 +1728,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('PERSO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1780,7 +1780,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('PERSO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2652,7 +2652,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CORPO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2704,7 +2704,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CORPO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3552,7 +3552,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('MEETI_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3622,7 +3622,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('MEETI_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4474,7 +4474,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('UNIF_TITLE', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4544,7 +4544,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('UNIF_TITLE', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5418,7 +5418,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CHRON_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5457,7 +5457,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CHRON_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6286,7 +6286,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('TOPIC_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6325,7 +6325,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('TOPIC_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7158,7 +7158,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GEOGR_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7197,7 +7197,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GEOGR_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8029,7 +8029,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GENRE/FORM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8050,7 +8050,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GENRE/FORM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 600aa08..c9879b7 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -501,7 +501,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), 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 d178416..f78e9df 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 @@ -526,7 +526,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'BKS', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'BKS', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'BKS', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'BKS', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'BKS', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'BKS', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'BKS', '', '', NULL), @@ -4452,7 +4452,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'CF', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'CF', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'CF', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'CF', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'CF', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'CF', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'CF', '', '', NULL), @@ -8377,7 +8377,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SR', '', '', NULL), @@ -12302,7 +12302,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'VR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'VR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'VR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'VR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'VR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'VR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'VR', '', '', NULL), @@ -16225,7 +16225,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'AR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'AR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'AR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'AR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'AR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'AR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'AR', '', '', NULL), @@ -20148,7 +20148,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'KT', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'KT', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'KT', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'KT', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'KT', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'KT', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'KT', '', '', NULL), @@ -24073,7 +24073,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'IR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'IR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'IR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'IR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'IR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'IR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'IR', '', '', NULL), @@ -27993,7 +27993,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SER', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SER', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SER', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SER', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SER', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SER', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SER', '', '', NULL), diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 6d28c41..f9b7b7f 100644 --- a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -267,7 +267,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -337,7 +337,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1728,7 +1728,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('PERSO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1780,7 +1780,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('PERSO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2652,7 +2652,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CORPO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2704,7 +2704,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CORPO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3552,7 +3552,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('MEETI_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3622,7 +3622,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('MEETI_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4474,7 +4474,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('UNIF_TITLE', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4544,7 +4544,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('UNIF_TITLE', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5418,7 +5418,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('CHRON_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5457,7 +5457,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CHRON_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6286,7 +6286,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('TOPIC_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6325,7 +6325,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('TOPIC_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7158,7 +7158,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GEOGR_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7197,7 +7197,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GEOGR_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8029,7 +8029,7 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES ('GENRE/FORM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', 'auth_header.authid', ''), - ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8050,7 +8050,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GENRE/FORM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_orgcode.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), 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 3671529..77dc23e 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 @@ -500,7 +500,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, '', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_003.pl', 0, 0, '', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_orgcode.pl', 0, 0, '', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 1, '', 0, '', '', 'marc21_field_005.pl', 0, 0, '', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, '', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index 394270b..22532ae 100644 --- a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -527,7 +527,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'BKS', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'BKS', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'BKS', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'BKS', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'BKS', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'BKS', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'BKS', '', '', NULL), @@ -4454,7 +4454,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'CF', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'CF', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'CF', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'CF', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'CF', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'CF', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'CF', '', '', NULL), @@ -8380,7 +8380,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SR', '', '', NULL), @@ -12306,7 +12306,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'VR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'VR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'VR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'VR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'VR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'VR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'VR', '', '', NULL), @@ -16230,7 +16230,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'AR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'AR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'AR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'AR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'AR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'AR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'AR', '', '', NULL), @@ -20154,7 +20154,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'KT', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'KT', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'KT', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'KT', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'KT', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'KT', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'KT', '', '', NULL), @@ -24080,7 +24080,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'IR', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'IR', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'IR', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'IR', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'IR', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'IR', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'IR', '', '', NULL), @@ -28001,7 +28001,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', 0, 0, 'SER', '', '', NULL), ('001', '@', 'control field', 'control field', 0, 0, '', 0, '', '', '', 0, -6, 'SER', '', '', NULL), - ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_003.pl', 0, -6, 'SER', '', '', NULL), + ('003', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_orgcode.pl', 0, -6, 'SER', '', '', NULL), ('005', '@', 'control field', 'control field', 0, 0, '', 0, '', '', 'marc21_field_005.pl', 0, -1, 'SER', '', '', NULL), ('006', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_006.pl', 0, -1, 'SER', '', '', NULL), ('007', '@', 'fixed length control field', 'fixed length control field', 0, 0, '', 0, '', '', 'marc21_field_007.pl', 0, 0, 'SER', '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql index 9560b54..143ef79 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', '', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', '', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', '', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', '', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', '', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', '', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql index f838810..55e18f5 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql @@ -19,7 +19,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql index b4685fb..058a47f 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CHRON_TERM', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'CHRON_TERM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'CHRON_TERM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CHRON_TERM', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CHRON_TERM', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'CHRON_TERM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'CHRON_TERM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'CHRON_TERM', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql index 7a5429b..cd91143 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CORPO_NAME', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'CORPO_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'CORPO_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CORPO_NAME', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -118,7 +118,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CORPO_NAME', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'CORPO_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'CORPO_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'CORPO_NAME', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql index 8cb28d1..ff53c76 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GENRE/FORM', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'GENRE/FORM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'GENRE/FORM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GENRE/FORM', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -71,7 +71,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GENRE/FORM', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'GENRE/FORM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'GENRE/FORM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'GENRE/FORM', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql index 541635f..4e8896b 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GEOGR_NAME', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'GEOGR_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'GEOGR_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GEOGR_NAME', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GEOGR_NAME', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'GEOGR_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'GEOGR_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql index c7ada4f..2e9de3f 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MEETI_NAME', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'MEETI_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'MEETI_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MEETI_NAME', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'MEETI_NAME', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'MEETI_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'MEETI_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'MEETI_NAME', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql index 4fcb4b1..f4add34 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PERSO_NAME', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'PERSO_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'PERSO_NAME', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PERSO_NAME', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -118,7 +118,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'PERSO_NAME', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'PERSO_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'PERSO_NAME', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'PERSO_NAME', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql index 898b90f..37f221c 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TOPIC_TERM', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'TOPIC_TERM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'TOPIC_TERM', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TOPIC_TERM', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'TOPIC_TERM', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'TOPIC_TERM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'TOPIC_TERM', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql index 3efc446..cd6edcf 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('UNIF_TITLE', '003', 1, '', 'Идентификатор контрольного номера', 'Идентификатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'UNIF_TITLE', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'UNIF_TITLE', '003', '@', 1, 0, 'Контрольное поле', 'Контрольное поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('UNIF_TITLE', '005', 1, '', 'Дата и время последней транзакции', 'Дата и время последней транзакции', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'UNIF_TITLE', '040', '6', 0, 0, 'Элемент связи', 'Элемент связи', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'UNIF_TITLE', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'UNIF_TITLE', '040', 'a', 1, 0, 'Служба первичной каталогизации', 'Служба первичной каталогизации', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'b', 0, 0, 'Язык каталогизации', 'Язык каталогизации', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'c', 0, 0, 'Служба перезаписи или преобразования', 'Служба перезаписи или преобразования', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'd', 0, 1, 'Служба модификации', 'Служба модификации', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql index 63a6d0a..36be7b0 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AR', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('AR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('AR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AR', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql index fc918d0..a6c1f07 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BKS', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('BKS', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('BKS', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BKS', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql index 04827a4..9388b51 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CF', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('CF', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('CF', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CF', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql index d84e336..fc043da 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('IR', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('IR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('IR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('IR', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql index 81c7b50..6897303 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('KT', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('KT', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('KT', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('KT', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql index 0160a19..3fcc636 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SER', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('SER', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('SER', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SER', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql index df0d94e..57c9c34 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SR', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('SR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('SR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SR', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql index f5786d4..52f9550 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('VR', '003', '', '', 'Принадлежность контрольного номера', 'Принадлежность контрольного номера', ''); 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 - ('VR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('VR', '', '003', '@', 0, 0, 'Контрольное поле', 'Контрольное поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('VR', '005', '', '', 'Дата корректировки', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql index c1aa57c..d580ab0 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', '', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', '', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', '', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', '', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', '', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', '', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), 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 6ccc172..0233171 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 @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql index 269756a..1172d60 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CHRON_TERM', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'CHRON_TERM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'CHRON_TERM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CHRON_TERM', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CHRON_TERM', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'CHRON_TERM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'CHRON_TERM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'CHRON_TERM', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql index 199eb6f..a54ab19 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CORPO_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CORPO_NAME', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'CORPO_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'CORPO_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CORPO_NAME', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -118,7 +118,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'CORPO_NAME', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'CORPO_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'CORPO_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'CORPO_NAME', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CORPO_NAME', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql index 880fc64..f63b344 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GENRE-FORM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GENRE/FORM', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'GENRE/FORM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'GENRE/FORM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GENRE/FORM', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -71,7 +71,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GENRE/FORM', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'GENRE/FORM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'GENRE/FORM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'GENRE/FORM', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GENRE/FORM', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql index 709af63..214dd90 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_GEOGR_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GEOGR_NAME', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'GEOGR_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'GEOGR_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('GEOGR_NAME', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'GEOGR_NAME', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'GEOGR_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'GEOGR_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'GEOGR_NAME', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql index ee5ef54..1b6dcef 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_MEETI_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MEETI_NAME', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'MEETI_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'MEETI_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MEETI_NAME', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'MEETI_NAME', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'MEETI_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'MEETI_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'MEETI_NAME', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'MEETI_NAME', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql index 8d95e8c..375d63d 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_PERSO_NAME_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PERSO_NAME', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'PERSO_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'PERSO_NAME', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PERSO_NAME', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -118,7 +118,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'PERSO_NAME', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'PERSO_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'PERSO_NAME', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'PERSO_NAME', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'PERSO_NAME', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql index 01c511a..f4d4f13 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_TOPIC_TERM_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TOPIC_TERM', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'TOPIC_TERM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'TOPIC_TERM', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TOPIC_TERM', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -93,7 +93,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'TOPIC_TERM', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'TOPIC_TERM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'TOPIC_TERM', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'TOPIC_TERM', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql index 8a94519..f3f7e9e 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_UNIF_TITLE_general.sql @@ -20,7 +20,7 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('UNIF_TITLE', '003', 1, '', 'Ідентифікатор контрольного номера', 'Ідентифікатор контрольного номера', NULL); INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES - ('', 'UNIF_TITLE', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0); + ('', 'UNIF_TITLE', '003', '@', 1, 0, 'Контрольне поле', 'Контрольне поле', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0); INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('UNIF_TITLE', '005', 1, '', 'Дата і час останньої транзакції', 'Дата і час останньої транзакції', NULL); @@ -140,7 +140,7 @@ INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES ('', 'UNIF_TITLE', '040', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 0, 0, '', NULL, NULL, 0, NULL, 0), - ('', 'UNIF_TITLE', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_field_003.pl', 0, NULL, 0), + ('', 'UNIF_TITLE', '040', 'a', 1, 0, 'Служба первинної каталогізації', 'Служба первинної каталогізації', 0, 0, '', NULL, 'marc21_orgcode.pl', 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'b', 0, 0, 'Мова каталогізації', 'Мова каталогізації', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'c', 0, 0, 'Управління перезапису або перетворення', 'Управління перезапису або перетворення', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'UNIF_TITLE', '040', 'd', 0, 1, 'Служба змін', 'Служба змін', 0, 0, '', NULL, NULL, 0, NULL, 0), diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql index 2228201..1f91fa3 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AR', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('AR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('AR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AR', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql index c16acab..d713b7c 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BKS', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('BKS', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('BKS', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BKS', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql index 942e468..ac4b789 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CF', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('CF', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('CF', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('CF', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql index a1647ae..9ca7ce0 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('IR', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('IR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('IR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('IR', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql index f7c2047..2b791c5 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('KT', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('KT', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('KT', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('KT', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql index 4bb26ca..d619c99 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SER', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('SER', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('SER', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SER', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql index 0b83d44..47da9fd 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SR', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('SR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('SR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('SR', '005', '', '', 'Дата коректування', '', ''); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql index 50f4795..f3829b1 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql @@ -20,7 +20,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('VR', '003', '', '', 'Належність контрольного номера', 'Належність контрольного номера', ''); 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 - ('VR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_field_003.pl', 0, '', '', NULL); + ('VR', '', '003', '@', 0, 0, 'Контрольне поле', 'Контрольне поле', 0, -6, '', '', 'marc21_orgcode.pl', 0, '', '', NULL); INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('VR', '005', '', '', 'Дата коректування', '', ''); -- 2.1.0