@@ -, +, @@ frameworks CHRON_TERM => 148 CORPO_NAME => 110 GENRE/FORM => 155 GEOGR_NAME => 151 MEETI_NAME => 111 PERSO_NAME => 100 TOPIC_TERM => 150 UNIF_TITLE => 130 - Create a fresh install in the language of your choice. - Confirm that when you create a new authority you cannot save without - Edit marc record's field 648 -> chronological term - Try to add there one by clicking a link on the left side of the field. --- .../mandatory/authorities_normal_marc21.yml | 16 +++++------ .../mandatory/authorities_normal_marc21.sql | 16 +++++------ .../obligatoire/authorities_normal_marc21.sql | 16 +++++------ .../Obligatoire/authorities_normal_marc21.sql | 16 +++++------ .../mandatory/authorities_normal_marc21.sql | 16 +++++------ .../mandatory/authorities_normal_marc21.sql | 16 +++++------ .../mandatory/authorities_normal_marc21.sql | 16 +++++------ .../marc21_authorities_DEFAULT_general.sql | 28 +++++++++---------- .../marc21_authorities_CHRON_TERM_general.sql | 4 +-- .../marc21_authorities_DEFAULT_general.sql | 28 +++++++++---------- .../marc21_authorities_CHRON_TERM_general.sql | 4 +-- 11 files changed, 88 insertions(+), 88 deletions(-) --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml +++ a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml @@ -479,7 +479,7 @@ tables: liblibrarian: "HEADING--PERSONAL NAME" libopac: "HEADING--PERSONAL NAME" repeatable: 0 - mandatory: 0 + mandatory: 1 authorised_value: - authtypecode: "" @@ -487,7 +487,7 @@ tables: liblibrarian: "HEADING--CORPORATE NAME" libopac: "HEADING--CORPORATE NAME" repeatable: 0 - mandatory: 0 + mandatory: 1 authorised_value: - authtypecode: "" @@ -495,7 +495,7 @@ tables: liblibrarian: "HEADING--MEETING NAME" libopac: "HEADING--MEETING NAME" repeatable: 0 - mandatory: 0 + mandatory: 1 authorised_value: - authtypecode: "" @@ -503,7 +503,7 @@ tables: liblibrarian: "HEADING--UNIFORM TITLE" libopac: "HEADING--UNIFORM TITLE" repeatable: 0 - mandatory: 0 + mandatory: 1 authorised_value: - authtypecode: "" @@ -535,7 +535,7 @@ tables: liblibrarian: "HEADING--CHRONOLOGICAL TERM" libopac: "HEADING--CHRONOLOGICAL TERM" repeatable: 0 - mandatory: 0 + mandatory: 1 authorised_value: - authtypecode: "" @@ -543,7 +543,7 @@ tables: liblibrarian: "HEADING--TOPICAL TERM" libopac: "HEADING--TOPICAL TERM" repeatable: 0 - mandatory: 0 + mandatory: 1 authorised_value: - authtypecode: "" @@ -551,7 +551,7 @@ tables: liblibrarian: "HEADING--GEOGRAPHIC NAME" libopac: "HEADING--GEOGRAPHIC NAME" repeatable: 0 - mandatory: 0 + mandatory: 1 authorised_value: - authtypecode: "" @@ -575,7 +575,7 @@ tables: liblibrarian: "HEADING--GENRE/FORM TERM" libopac: "HEADING--GENRE/FORM TERM" repeatable: 0 - mandatory: 0 + mandatory: 1 authorised_value: - authtypecode: "" --- a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -142,18 +142,18 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l ('', '097', 'ASIGNACIÓN LOCAL TIPO-NLM NÚMERO DE CLASIFICACIÓN (OCLC)', 'ASIGNACIÓN LOCAL TIPO-NLM NÚMERO DE CLASIFICACIÓN (OCLC)', 1, 0, NULL), ('', '098', 'OTROS ESQUEMAS DE CLASIFICACIÓN (OCLC)', 'OTROS ESQUEMAS DE CLASIFICACIÓN (OCLC)', 1, 0, NULL), ('', '099', 'TEXTO-LIBRO SIGNATURA TOPOGRÁFICA LOCAL (OCLC)', 'TEXTO-LIBRO SIGNATURA TOPOGRÁFICA LOCAL (OCLC)', 1, 0, NULL), - ('', '100', 'ENCABEZAMIENTO-NOMBRE DE PERSONA', 'ENCABEZAMIENTO-NOMBRE DE PERSONA', 0, 0, NULL), - ('', '110', 'ENCABEZAMIENTO-NOMBRE DE ENTIDAD CORPORATIVA', 'ENCABEZAMIENTO-NOMBRE DE ENTIDAD CORPORATIVA', 0, 0, NULL), - ('', '111', 'ENCABEZAMIENTO--NOMBRE DE CONGRESO/REUNIÓN', 'ENCABEZAMIENTO--NOMBRE DE CONGRESO/REUNIÓN', 0, 0, NULL), - ('', '130', 'ENCABEZAMIENTO--TÍTULO UNIFORME', 'ENCABEZAMIENTO--TÍTULO UNIFORME', 0, 0, NULL), + ('', '100', 'ENCABEZAMIENTO-NOMBRE DE PERSONA', 'ENCABEZAMIENTO-NOMBRE DE PERSONA', 0, 1, NULL), + ('', '110', 'ENCABEZAMIENTO-NOMBRE DE ENTIDAD CORPORATIVA', 'ENCABEZAMIENTO-NOMBRE DE ENTIDAD CORPORATIVA', 0, 1, NULL), + ('', '111', 'ENCABEZAMIENTO--NOMBRE DE CONGRESO/REUNIÓN', 'ENCABEZAMIENTO--NOMBRE DE CONGRESO/REUNIÓN', 0, 1, NULL), + ('', '130', 'ENCABEZAMIENTO--TÍTULO UNIFORME', 'ENCABEZAMIENTO--TÍTULO UNIFORME', 1, 0, NULL), ('', '140', 'TÍTULO UNIFORME [OBSOLETO, CAN/MARC]', 'TÍTULO UNIFORME [OBSOLETO, CAN/MARC]', 1, 0, NULL), ('', '143', 'TÍTULO COLECTIVO [OBSOLETO, CAN/MARC]', 'TÍTULO COLECTIVO [OBSOLETO, CAN/MARC]', 1, 0, NULL), - ('', '148', 'ENCABEZAMIENTO--TÉRMINO CRONOLÓGICO', 'ENCABEZAMIENTO--TÉRMINO CRONOLÓGICO', 0, 0, NULL), - ('', '150', 'ENCABEZAMIENTO--TÉRMINO DE MATERIA', 'ENCABEZAMIENTO--TÉRMINO DE MATERIA', 0, 0, NULL), - ('', '151', 'ENCABEZAMIENTO--NOMBRE GEOGRÁFICO', 'ENCABEZAMIENTO--NOMBRE GEOGRÁFICO', 0, 0, NULL), + ('', '148', 'ENCABEZAMIENTO--TÉRMINO CRONOLÓGICO', 'ENCABEZAMIENTO--TÉRMINO CRONOLÓGICO', 0, 1, NULL), + ('', '150', 'ENCABEZAMIENTO--TÉRMINO DE MATERIA', 'ENCABEZAMIENTO--TÉRMINO DE MATERIA', 0, 1, NULL), + ('', '151', 'ENCABEZAMIENTO--NOMBRE GEOGRÁFICO', 'ENCABEZAMIENTO--NOMBRE GEOGRÁFICO', 0, 1, NULL), ('', '153', 'NÚMERO DE CLASIFICACIÓN [FORMATO DE CLASIFICACIÓN]', 'NÚMERO DE CLASIFICACIÓN [FORMATO DE CLASIFICACIÓN]', 0, 0, NULL), ('', '154', 'TÉRMINO EXPLICATIVO GENERAL DE ÍNDICE [FORMATO DE CLASIFICACIÓN]', 'TÉRMINO EXPLICATIVO GENERAL DE ÍNDICE [FORMATO DE CLASIFICACIÓN]', 0, 0, NULL), - ('', '155', 'ENCABEZAMIENTO--TÉRMINO DE GÉNERO/FORMA', 'ENCABEZAMIENTO--TÉRMINO DE GÉNERO/FORMA', 0, 0, NULL), + ('', '155', 'ENCABEZAMIENTO--TÉRMINO DE GÉNERO/FORMA', 'ENCABEZAMIENTO--TÉRMINO DE GÉNERO/FORMA', 0, 1, NULL), ('', '162', 'ENCABEZAMIENTO-TÉRMINO DE MEDIO DE INTERPRETACIÓN', 'ENCABEZAMIENTO-TÉRMINO DE MEDIO DE INTERPRETACIÓN', 0, 0, NULL), ('', '180', 'ENCABEZAMIENTO--SUBDIVISIÓN GENERAL', 'ENCABEZAMIENTO--SUBDIVISIÓN GENERAL', 0, 0, NULL), ('', '181', 'ENCABEZAMIENTO--SUBDIVISIÓN GEOGRÁFICA', 'ENCABEZAMIENTO--SUBDIVISIÓN GEOGRÁFICA', 0, 0, NULL), --- a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/authorities_normal_marc21.sql +++ a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/authorities_normal_marc21.sql @@ -128,14 +128,14 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l ("","083","Indice de classification décimale de Dewey","Indice de classification décimale de Dewey","1","0",NULL), ("","086","Cote du document officiel","Cote du document officiel","1","0",NULL), ("","087","Numéro de classification de document officiel","Numéro de classification de document officiel","1","0",NULL), -("","100","Vedette - Nom de personne","Vedette - Nom de personne","0","0",NULL), -("","110","Vedette - Nom de collectivité","Vedette - Nom de collectivité","0","0",NULL), -("","111","Vedette - Nom de réunion","Vedette - Nom de réunion","0","0",NULL), -("","130","Vedette - Titre uniforme","Vedette - Titre uniforme","0","0",NULL), -("","148","Vedette - Terme chronologique","Vedette - Terme chronologique","0","0",NULL), -("","150","Vedette - Nom commun","Vedette - Nom commun","0","0",NULL), -("","151","Vedette - Nom géographique","Vedette - Nom géographique","0","0",NULL), -("","155","Vedette - Terme de genre/forme","Vedette - Terme de genre/forme","0","0",NULL), +("","100","Vedette - Nom de personne","Vedette - Nom de personne","0","1",NULL), +("","110","Vedette - Nom de collectivité","Vedette - Nom de collectivité","0","1",NULL), +("","111","Vedette - Nom de réunion","Vedette - Nom de réunion","0","1",NULL), +("","130","Vedette - Titre uniforme","Vedette - Titre uniforme","0","1",NULL), +("","148","Vedette - Terme chronologique","Vedette - Terme chronologique","0","1",NULL), +("","150","Vedette - Nom commun","Vedette - Nom commun","0","1",NULL), +("","151","Vedette - Nom géographique","Vedette - Nom géographique","0","1",NULL), +("","155","Vedette - Terme de genre/forme","Vedette - Terme de genre/forme","0","1",NULL), ("","180","Vedette - Subdivision générale","Vedette - Subdivision générale","0","0",NULL), ("","181","Vedette - Subdivision géographique","Vedette - Subdivision géographique","0","0",NULL), ("","182","Vedette - Subdivision chronologique","Vedette - Subdivision chronologique","0","0",NULL), --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql +++ a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql @@ -163,18 +163,18 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l ('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL), ('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL), ('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL), - ('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL), - ('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL), - ('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL), - ('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL), + ('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 1, NULL), + ('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 1, NULL), + ('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 1, NULL), + ('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 1, NULL), ('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL), ('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL), - ('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL), - ('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL), - ('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL), + ('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 1, NULL), + ('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 1, NULL), + ('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 1, NULL), ('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL), ('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL), - ('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL), + ('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 1, NULL), ('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL), ('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL), ('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL), --- a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -142,18 +142,18 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l ('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL), ('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL), ('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL), - ('', '100', 'Intestazione-Nome di persona', 'Intestazione-Nome di persona', 0, 0, NULL), - ('', '110', 'Intestazione-Nome di ente', 'Intestazione-Nome di ente', 0, 0, NULL), - ('', '111', 'Intestazione-Nome di convegno', 'Intestazione-Nome di convegno', 0, 0, NULL), - ('', '130', 'Intestazione-Titolo uniforme', 'Intestazione-Titolo uniforme', 0, 0, NULL), + ('', '100', 'Intestazione-Nome di persona', 'Intestazione-Nome di persona', 0, 1, NULL), + ('', '110', 'Intestazione-Nome di ente', 'Intestazione-Nome di ente', 0, 1, NULL), + ('', '111', 'Intestazione-Nome di convegno', 'Intestazione-Nome di convegno', 0, 1, NULL), + ('', '130', 'Intestazione-Titolo uniforme', 'Intestazione-Titolo uniforme', 0, 1, NULL), ('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL), ('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL), - ('', '148', 'Intestazione-Termine cronologico', 'Intestazione-Termine cronologico', 0, 0, NULL), - ('', '150', 'Intestazione-Termine topico', 'Intestazione-Termine topico', 0, 0, NULL), - ('', '151', 'Intestazione – Nome geografico', 'Intestazione – Nome geografico', 0, 0, NULL), + ('', '148', 'Intestazione-Termine cronologico', 'Intestazione-Termine cronologico', 0, 1, NULL), + ('', '150', 'Intestazione-Termine topico', 'Intestazione-Termine topico', 0, 1, NULL), + ('', '151', 'Intestazione – Nome geografico', 'Intestazione – Nome geografico', 0, 1, NULL), ('', '153', 'Numero classificazione [Formato per classificazione]]', 'Numero classificazione [Formato per classificazione]]', 0, 0, NULL), ('', '154', 'Termine d\'indice, spiegazione generale [Formato per classificazione]', 'Termine d\'indice, spiegazione generale [Formato per classificazione]', 0, 0, NULL), - ('', '155', 'Intestazione-Termine di genere/forma', 'Intestazione-Termine di genere/forma', 0, 0, NULL), + ('', '155', 'Intestazione-Termine di genere/forma', 'Intestazione-Termine di genere/forma', 0, 1, NULL), ('', '162', 'Intestazione – Termine del mezzo di esecuzione', 'Intestazione – Termine del mezzo di esecuzione', 0, 0, NULL), ('', '180', 'Intestazione-Suddivisione generale', 'Intestazione-Suddivisione generale', 0, 0, NULL), ('', '181', 'Intestazione-Suddivisione geografica', 'Intestazione-Suddivisione geografica', 0, 0, NULL), --- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -163,18 +163,18 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l ('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL), ('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL), ('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL), - ('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL), - ('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL), - ('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL), - ('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL), + ('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 1, NULL), + ('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 1, NULL), + ('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 1, NULL), + ('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 1, NULL), ('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL), ('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL), - ('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL), - ('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL), - ('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL), + ('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 1, NULL), + ('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 1, NULL), + ('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 1, NULL), ('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL), ('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL), - ('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL), + ('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 1, NULL), ('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL), ('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL), ('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL), --- a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -163,18 +163,18 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l ('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL), ('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL), ('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL), - ('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL), - ('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL), - ('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL), - ('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL), + ('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 1, NULL), + ('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 1, NULL), + ('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 1, NULL), + ('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 1, NULL), ('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL), ('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL), - ('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL), - ('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL), - ('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL), + ('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 1, NULL), + ('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 1, NULL), + ('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 1, NULL), ('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL), ('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL), - ('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL), + ('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 1, NULL), ('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL), ('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL), ('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL), --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql +++ a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql @@ -426,8 +426,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '098', 'e', 0, 0, 'Feature heading', 'Feature heading', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix', 0, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '100', '', '', 'Заголовок – имя лица', 'Заголовок – имя лица', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '100', '', '', 'Заголовок – имя лица', 'Заголовок – имя лица', 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 ('', '', '100', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '100', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -455,8 +455,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '100', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '100', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '110', '', '', 'Заголовок – наименование организации', 'Заголовок – наименование организации', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '110', '', '', 'Заголовок – наименование организации', 'Заголовок – наименование организации', 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 ('', '', '110', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '110', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -482,8 +482,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '110', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '110', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '111', '', '', 'Заголовок – наименование мероприятия', 'Заголовок – наименование мероприятия', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '111', '', '', 'Заголовок – наименование мероприятия', 'Заголовок – наименование мероприятия', 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 ('', '', '111', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '111', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -508,8 +508,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '111', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '111', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '130', '', '', 'Заголовок – унифицированное заглавие', 'Заголовок – унифицированное заглавие', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '130', '', '', 'Заголовок – унифицированное заглавие', 'Заголовок – унифицированное заглавие', 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 ('', '', '130', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '130', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -568,8 +568,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '143', 'r', 0, 0, 'Музыкальный ключ', 'Музыкальный ключ', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '143', 's', 0, 1, 'Версия', 'Версия', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 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 ('', '', '148', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '148', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -591,8 +591,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '150', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '150', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '151', '', '', 'Заголовок – географическое название', 'Заголовок – географическое название', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '151', '', '', 'Заголовок – географическое название', 'Заголовок – географическое название', 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 ('', '', '151', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '151', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -624,8 +624,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '154', 'b', 0, 1, 'General explanatory index term--Succeeding level', 'General explanatory index term--Succeeding level', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '154', 'f', 0, 1, 'Schedule identification', 'Schedule identification', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '155', '', '', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '155', '', '', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 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 ('', '', '155', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '155', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0), --- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql @@ -337,8 +337,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'CHRON_TERM', '098', 'e', 0, 0, 'Feature heading', 'Feature heading', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix', 0, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('CHRON_TERM', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('CHRON_TERM', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 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', '148', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '148', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0), --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql +++ a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql @@ -455,8 +455,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '100', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '100', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '110', '', '', 'Заголовок — найменування організації', 'Заголовок — найменування організації', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '110', '', '', 'Заголовок — найменування організації', 'Заголовок — найменування організації', 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 ('', '', '110', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '110', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -482,8 +482,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '110', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '110', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '111', '', '', 'Заголовок – назва заходу', 'Заголовок – назва заходу', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '111', '', '', 'Заголовок – назва заходу', 'Заголовок – назва заходу', 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 ('', '', '111', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '111', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -508,8 +508,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '111', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '111', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '130', '', '', 'Заголовок — уніфікований заголовок', 'Заголовок — уніфікований заголовок', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '130', '', '', 'Заголовок — уніфікований заголовок', 'Заголовок — уніфікований заголовок', 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 ('', '', '130', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '130', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -568,8 +568,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '143', 'r', 0, 0, 'Музичний ключ', 'Музичний ключ', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '143', 's', 0, 1, 'Версія', 'Версія', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 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 ('', '', '148', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '148', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -579,8 +579,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '148', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '148', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '150', '', '', 'Заголовок — тематичний термін', 'Заголовок — тематичний термін', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '150', '', '', 'Заголовок — тематичний термін', 'Заголовок — тематичний термін', 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 ('', '', '150', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '150', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -591,8 +591,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '150', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '150', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '151', '', '', 'Заголовок — географічна назва', 'Заголовок — географічна назва', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '151', '', '', 'Заголовок — географічна назва', 'Заголовок — географічна назва', 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 ('', '', '151', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '151', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0), @@ -624,8 +624,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '154', 'b', 0, 1, 'General explanatory index term--Succeeding level', 'General explanatory index term--Succeeding level', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '154', 'f', 0, 1, 'Schedule identification', 'Schedule identification', 1, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('', '155', '', '', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('', '155', '', '', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 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 ('', '', '155', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', '', '155', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0), --- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql +++ a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_authorities_CHRON_TERM_general.sql @@ -337,8 +337,8 @@ INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', 'CHRON_TERM', '098', 'e', 0, 0, 'Feature heading', 'Feature heading', 0, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix', 0, 0, '', NULL, NULL, 0, NULL, 0); -INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES - ('CHRON_TERM', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', NULL); +INSERT INTO auth_tag_structure (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES + ('CHRON_TERM', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 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', '148', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0), ('', 'CHRON_TERM', '148', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0), --