From 8d8198ad48844a8e99079073879bf0a38d7e296a 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>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 .../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.39.5