Bugzilla – Attachment 100908 Details for
Bug 13775
Set main headings to mandatory in authority frameworks
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13775: Set main headings to mandatory in authority frameworks
Bug-13775-Set-main-headings-to-mandatory-in-author.patch (text/plain), 47.34 KB, created by
Bernardo Gonzalez Kriegel
on 2020-03-17 15:24:22 UTC
(
hide
)
Description:
Bug 13775: Set main headings to mandatory in authority frameworks
Filename:
MIME Type:
Creator:
Bernardo Gonzalez Kriegel
Created:
2020-03-17 15:24:22 UTC
Size:
47.34 KB
patch
obsolete
>From 03d2da031786257dcf1dc44b818ab7164c61b103 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 12 Dec 2019 10:10:23 +0100 >Subject: [PATCH] Bug 13775: Set main headings to mandatory in authority > frameworks > >For MARC21 we need to set the following tags as mandatory: > CHRON_TERM => 148 > CORPO_NAME => 110 > GENRE/FORM => 155 > GEOGR_NAME => 151 > MEETI_NAME => 111 > PERSO_NAME => 100 > TOPIC_TERM => 150 > UNIF_TITLE => 130 > >Note that it also fixes an error on the UI, which was initially reported >on bug 13775. > >Test plan: >- Create a fresh install in the language of your choice. >- Confirm that when you create a new authority you cannot save without >entering a value for the main heading > >- Edit marc record's field 648 -> chronological term >- Try to add there one by clicking a link on the left side of the field. >From there it opens me to a new window, click "Create a new authority" >Click on the authority creating fields randomly, save. >=> Without this patch an error occurred "Can't call method "subfields" >on an undefined value at authorities/blinddetail-biblio-search.pl line 88." > >Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> >Fixed conflict in english version. >--- > .../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(-) > >diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml >index 887286e288..f151d90c1a 100644 >--- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml >+++ b/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: "" >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 2354715c19..41172a162f 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 >@@ -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), >diff --git a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/authorities_normal_marc21.sql b/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/authorities_normal_marc21.sql >index 028b78077c..ecc8e3cdbc 100644 >--- a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/authorities_normal_marc21.sql >+++ b/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), >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 6d3303c826..3a3e844a58 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 >@@ -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), >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 2b95c91984..af5c6e7818 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 >@@ -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), >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 6d3303c826..3a3e844a58 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 >@@ -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), >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 6d3303c826..3a3e844a58 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 >@@ -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), >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 143ef79d66..3eac422730 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 >@@ -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), >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 ce60cceb0f..909aabe685 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 >@@ -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), >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 b67cfdb780..e873f8adfa 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 >@@ -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), >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 ee22315329..b6638650a2 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 >@@ -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), >-- >2.17.1
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=100908">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 13775
:
96213
|
96214
|
100908
|
100909
|
101104
|
101105