View | Details | Raw Unified | Return to bug 13775
Collapse All | Expand All

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-8 / +8 lines)
Lines 143-161 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
143
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
143
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
144
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
144
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
145
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
145
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
146
		('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL),
146
		('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 1, NULL),
147
		('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL),
147
		('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 1, NULL),
148
		('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL),
148
		('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 1, NULL),
149
		('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL),
149
		('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 1, NULL),
150
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
150
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
151
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
151
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
152
		('', '147', 'HEADING--NAMED EVENT', 'HEADING--NAMED EVENT', 0, 0, NULL),
152
		('', '147', 'HEADING--NAMED EVENT', 'HEADING--NAMED EVENT', 0, 0, NULL),
153
		('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL),
153
		('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 1, NULL),
154
		('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL),
154
		('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 1, NULL),
155
		('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL),
155
		('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 1, NULL),
156
		('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
156
		('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
157
		('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
157
		('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
158
		('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL),
158
		('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 1, NULL),
159
		('', '162', 'HEADING-MEDIUM OF PERFORMANCE TERM', 'HEADING-MEDIUM OF PERFORMANCE TERM', 0, 0, NULL),
159
		('', '162', 'HEADING-MEDIUM OF PERFORMANCE TERM', 'HEADING-MEDIUM OF PERFORMANCE TERM', 0, 0, NULL),
160
		('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
160
		('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
161
		('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
161
		('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
(-)a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-8 / +8 lines)
Lines 142-159 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
142
		('', '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),
142
		('', '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),
143
		('', '098', 'OTROS ESQUEMAS DE CLASIFICACIÓN (OCLC)', 'OTROS ESQUEMAS DE CLASIFICACIÓN (OCLC)', 1, 0, NULL),
143
		('', '098', 'OTROS ESQUEMAS DE CLASIFICACIÓN (OCLC)', 'OTROS ESQUEMAS DE CLASIFICACIÓN (OCLC)', 1, 0, NULL),
144
		('', '099', 'TEXTO-LIBRO SIGNATURA TOPOGRÁFICA LOCAL (OCLC)', 'TEXTO-LIBRO SIGNATURA TOPOGRÁFICA LOCAL (OCLC)', 1, 0, NULL),
144
		('', '099', 'TEXTO-LIBRO SIGNATURA TOPOGRÁFICA LOCAL (OCLC)', 'TEXTO-LIBRO SIGNATURA TOPOGRÁFICA LOCAL (OCLC)', 1, 0, NULL),
145
		('', '100', 'ENCABEZAMIENTO-NOMBRE DE PERSONA', 'ENCABEZAMIENTO-NOMBRE DE PERSONA', 0, 0, NULL),
145
		('', '100', 'ENCABEZAMIENTO-NOMBRE DE PERSONA', 'ENCABEZAMIENTO-NOMBRE DE PERSONA', 0, 1, NULL),
146
		('', '110', 'ENCABEZAMIENTO-NOMBRE DE ENTIDAD CORPORATIVA', 'ENCABEZAMIENTO-NOMBRE DE ENTIDAD CORPORATIVA', 0, 0, NULL),
146
		('', '110', 'ENCABEZAMIENTO-NOMBRE DE ENTIDAD CORPORATIVA', 'ENCABEZAMIENTO-NOMBRE DE ENTIDAD CORPORATIVA', 0, 1, NULL),
147
		('', '111', 'ENCABEZAMIENTO--NOMBRE DE CONGRESO/REUNIÓN', 'ENCABEZAMIENTO--NOMBRE DE CONGRESO/REUNIÓN', 0, 0, NULL),
147
		('', '111', 'ENCABEZAMIENTO--NOMBRE DE CONGRESO/REUNIÓN', 'ENCABEZAMIENTO--NOMBRE DE CONGRESO/REUNIÓN', 0, 1, NULL),
148
		('', '130', 'ENCABEZAMIENTO--TÍTULO UNIFORME', 'ENCABEZAMIENTO--TÍTULO UNIFORME', 0, 0, NULL),
148
		('', '130', 'ENCABEZAMIENTO--TÍTULO UNIFORME', 'ENCABEZAMIENTO--TÍTULO UNIFORME', 1, 0, NULL),
149
		('', '140', 'TÍTULO UNIFORME [OBSOLETO, CAN/MARC]', 'TÍTULO UNIFORME [OBSOLETO, CAN/MARC]', 1, 0, NULL),
149
		('', '140', 'TÍTULO UNIFORME [OBSOLETO, CAN/MARC]', 'TÍTULO UNIFORME [OBSOLETO, CAN/MARC]', 1, 0, NULL),
150
		('', '143', 'TÍTULO COLECTIVO [OBSOLETO, CAN/MARC]', 'TÍTULO COLECTIVO [OBSOLETO, CAN/MARC]', 1, 0, NULL),
150
		('', '143', 'TÍTULO COLECTIVO [OBSOLETO, CAN/MARC]', 'TÍTULO COLECTIVO [OBSOLETO, CAN/MARC]', 1, 0, NULL),
151
		('', '148', 'ENCABEZAMIENTO--TÉRMINO CRONOLÓGICO', 'ENCABEZAMIENTO--TÉRMINO CRONOLÓGICO', 0, 0, NULL),
151
		('', '148', 'ENCABEZAMIENTO--TÉRMINO CRONOLÓGICO', 'ENCABEZAMIENTO--TÉRMINO CRONOLÓGICO', 0, 1, NULL),
152
		('', '150', 'ENCABEZAMIENTO--TÉRMINO DE MATERIA', 'ENCABEZAMIENTO--TÉRMINO DE MATERIA', 0, 0, NULL),
152
		('', '150', 'ENCABEZAMIENTO--TÉRMINO DE MATERIA', 'ENCABEZAMIENTO--TÉRMINO DE MATERIA', 0, 1, NULL),
153
		('', '151', 'ENCABEZAMIENTO--NOMBRE GEOGRÁFICO', 'ENCABEZAMIENTO--NOMBRE GEOGRÁFICO', 0, 0, NULL),
153
		('', '151', 'ENCABEZAMIENTO--NOMBRE GEOGRÁFICO', 'ENCABEZAMIENTO--NOMBRE GEOGRÁFICO', 0, 1, NULL),
154
		('', '153', 'NÚMERO DE CLASIFICACIÓN [FORMATO DE CLASIFICACIÓN]', 'NÚMERO DE CLASIFICACIÓN [FORMATO DE CLASIFICACIÓN]', 0, 0, NULL),
154
		('', '153', 'NÚMERO DE CLASIFICACIÓN [FORMATO DE CLASIFICACIÓN]', 'NÚMERO DE CLASIFICACIÓN [FORMATO DE CLASIFICACIÓN]', 0, 0, NULL),
155
		('', '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
		('', '154', 'TÉRMINO EXPLICATIVO GENERAL DE ÍNDICE [FORMATO DE CLASIFICACIÓN]', 'TÉRMINO EXPLICATIVO GENERAL DE ÍNDICE [FORMATO DE CLASIFICACIÓN]', 0, 0, NULL),
156
		('', '155', 'ENCABEZAMIENTO--TÉRMINO DE GÉNERO/FORMA', 'ENCABEZAMIENTO--TÉRMINO DE GÉNERO/FORMA', 0, 0, NULL),
156
		('', '155', 'ENCABEZAMIENTO--TÉRMINO DE GÉNERO/FORMA', 'ENCABEZAMIENTO--TÉRMINO DE GÉNERO/FORMA', 0, 1, NULL),
157
		('', '162', 'ENCABEZAMIENTO-TÉRMINO DE MEDIO DE INTERPRETACIÓN', 'ENCABEZAMIENTO-TÉRMINO DE MEDIO DE INTERPRETACIÓN', 0, 0, NULL),
157
		('', '162', 'ENCABEZAMIENTO-TÉRMINO DE MEDIO DE INTERPRETACIÓN', 'ENCABEZAMIENTO-TÉRMINO DE MEDIO DE INTERPRETACIÓN', 0, 0, NULL),
158
		('', '180', 'ENCABEZAMIENTO--SUBDIVISIÓN GENERAL', 'ENCABEZAMIENTO--SUBDIVISIÓN GENERAL', 0, 0, NULL),
158
		('', '180', 'ENCABEZAMIENTO--SUBDIVISIÓN GENERAL', 'ENCABEZAMIENTO--SUBDIVISIÓN GENERAL', 0, 0, NULL),
159
		('', '181', 'ENCABEZAMIENTO--SUBDIVISIÓN GEOGRÁFICA', 'ENCABEZAMIENTO--SUBDIVISIÓN GEOGRÁFICA', 0, 0, NULL),
159
		('', '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 (-8 / +8 lines)
Lines 128-141 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
128
("","083","Indice de classification décimale de Dewey","Indice de classification décimale de Dewey","1","0",NULL),
128
("","083","Indice de classification décimale de Dewey","Indice de classification décimale de Dewey","1","0",NULL),
129
("","086","Cote du document officiel","Cote du document officiel","1","0",NULL),
129
("","086","Cote du document officiel","Cote du document officiel","1","0",NULL),
130
("","087","Numéro de classification de document officiel","Numéro de classification de document officiel","1","0",NULL),
130
("","087","Numéro de classification de document officiel","Numéro de classification de document officiel","1","0",NULL),
131
("","100","Vedette - Nom de personne","Vedette - Nom de personne","0","0",NULL),
131
("","100","Vedette - Nom de personne","Vedette - Nom de personne","0","1",NULL),
132
("","110","Vedette - Nom de collectivité","Vedette - Nom de collectivité","0","0",NULL),
132
("","110","Vedette - Nom de collectivité","Vedette - Nom de collectivité","0","1",NULL),
133
("","111","Vedette - Nom de réunion","Vedette - Nom de réunion","0","0",NULL),
133
("","111","Vedette - Nom de réunion","Vedette - Nom de réunion","0","1",NULL),
134
("","130","Vedette - Titre uniforme","Vedette - Titre uniforme","0","0",NULL),
134
("","130","Vedette - Titre uniforme","Vedette - Titre uniforme","0","1",NULL),
135
("","148","Vedette - Terme chronologique","Vedette - Terme chronologique","0","0",NULL),
135
("","148","Vedette - Terme chronologique","Vedette - Terme chronologique","0","1",NULL),
136
("","150","Vedette - Nom commun","Vedette - Nom commun","0","0",NULL),
136
("","150","Vedette - Nom commun","Vedette - Nom commun","0","1",NULL),
137
("","151","Vedette - Nom géographique","Vedette - Nom géographique","0","0",NULL),
137
("","151","Vedette - Nom géographique","Vedette - Nom géographique","0","1",NULL),
138
("","155","Vedette - Terme de genre/forme","Vedette - Terme de genre/forme","0","0",NULL),
138
("","155","Vedette - Terme de genre/forme","Vedette - Terme de genre/forme","0","1",NULL),
139
("","180","Vedette - Subdivision générale","Vedette - Subdivision générale","0","0",NULL),
139
("","180","Vedette - Subdivision générale","Vedette - Subdivision générale","0","0",NULL),
140
("","181","Vedette - Subdivision géographique","Vedette - Subdivision géographique","0","0",NULL),
140
("","181","Vedette - Subdivision géographique","Vedette - Subdivision géographique","0","0",NULL),
141
("","182","Vedette - Subdivision chronologique","Vedette - Subdivision chronologique","0","0",NULL),
141
("","182","Vedette - Subdivision chronologique","Vedette - Subdivision chronologique","0","0",NULL),
(-)a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/authorities_normal_marc21.sql (-8 / +8 lines)
Lines 163-180 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
163
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
163
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
164
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
164
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
165
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
165
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
166
		('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL),
166
		('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 1, NULL),
167
		('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL),
167
		('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 1, NULL),
168
		('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL),
168
		('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 1, NULL),
169
		('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL),
169
		('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 1, NULL),
170
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
170
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
171
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
171
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
172
		('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL),
172
		('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 1, NULL),
173
		('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL),
173
		('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 1, NULL),
174
		('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL),
174
		('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 1, NULL),
175
		('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
175
		('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
176
		('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
176
		('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
177
		('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL),
177
		('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 1, NULL),
178
		('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
178
		('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
179
		('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
179
		('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
180
		('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL),
180
		('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL),
(-)a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-8 / +8 lines)
Lines 142-159 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
142
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
142
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
143
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
143
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
144
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
144
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
145
		('', '100', 'Intestazione-Nome di persona', 'Intestazione-Nome di persona', 0, 0, NULL),
145
		('', '100', 'Intestazione-Nome di persona', 'Intestazione-Nome di persona', 0, 1, NULL),
146
		('', '110', 'Intestazione-Nome di ente', 'Intestazione-Nome di ente', 0, 0, NULL),
146
		('', '110', 'Intestazione-Nome di ente', 'Intestazione-Nome di ente', 0, 1, NULL),
147
		('', '111', 'Intestazione-Nome di convegno', 'Intestazione-Nome di convegno', 0, 0, NULL),
147
		('', '111', 'Intestazione-Nome di convegno', 'Intestazione-Nome di convegno', 0, 1, NULL),
148
		('', '130', 'Intestazione-Titolo uniforme', 'Intestazione-Titolo uniforme', 0, 0, NULL),
148
		('', '130', 'Intestazione-Titolo uniforme', 'Intestazione-Titolo uniforme', 0, 1, NULL),
149
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
149
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
150
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
150
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
151
		('', '148', 'Intestazione-Termine cronologico', 'Intestazione-Termine cronologico', 0, 0, NULL),
151
		('', '148', 'Intestazione-Termine cronologico', 'Intestazione-Termine cronologico', 0, 1, NULL),
152
		('', '150', 'Intestazione-Termine topico', 'Intestazione-Termine topico', 0, 0, NULL),
152
		('', '150', 'Intestazione-Termine topico', 'Intestazione-Termine topico', 0, 1, NULL),
153
		('', '151', 'Intestazione – Nome geografico', 'Intestazione – Nome geografico', 0, 0, NULL),
153
		('', '151', 'Intestazione – Nome geografico', 'Intestazione – Nome geografico', 0, 1, NULL),
154
		('', '153', 'Numero classificazione [Formato per classificazione]]', 'Numero classificazione [Formato per classificazione]]', 0, 0, NULL),
154
		('', '153', 'Numero classificazione [Formato per classificazione]]', 'Numero classificazione [Formato per classificazione]]', 0, 0, NULL),
155
		('', '154', 'Termine d\'indice, spiegazione generale [Formato per classificazione]', 'Termine d\'indice, spiegazione generale [Formato per classificazione]', 0, 0, NULL),
155
		('', '154', 'Termine d\'indice, spiegazione generale [Formato per classificazione]', 'Termine d\'indice, spiegazione generale [Formato per classificazione]', 0, 0, NULL),
156
		('', '155', 'Intestazione-Termine di genere/forma', 'Intestazione-Termine di genere/forma', 0, 0, NULL),
156
		('', '155', 'Intestazione-Termine di genere/forma', 'Intestazione-Termine di genere/forma', 0, 1, NULL),
157
		('', '162', 'Intestazione – Termine del mezzo di esecuzione', 'Intestazione – Termine del mezzo di esecuzione', 0, 0, NULL),
157
		('', '162', 'Intestazione – Termine del mezzo di esecuzione', 'Intestazione – Termine del mezzo di esecuzione', 0, 0, NULL),
158
		('', '180', 'Intestazione-Suddivisione generale', 'Intestazione-Suddivisione generale', 0, 0, NULL),
158
		('', '180', 'Intestazione-Suddivisione generale', 'Intestazione-Suddivisione generale', 0, 0, NULL),
159
		('', '181', 'Intestazione-Suddivisione geografica', 'Intestazione-Suddivisione geografica', 0, 0, NULL),
159
		('', '181', 'Intestazione-Suddivisione geografica', 'Intestazione-Suddivisione geografica', 0, 0, NULL),
(-)a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-8 / +8 lines)
Lines 163-180 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
163
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
163
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
164
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
164
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
165
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
165
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
166
		('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL),
166
		('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 1, NULL),
167
		('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL),
167
		('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 1, NULL),
168
		('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL),
168
		('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 1, NULL),
169
		('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL),
169
		('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 1, NULL),
170
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
170
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
171
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
171
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
172
		('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL),
172
		('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 1, NULL),
173
		('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL),
173
		('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 1, NULL),
174
		('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL),
174
		('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 1, NULL),
175
		('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
175
		('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
176
		('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
176
		('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
177
		('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL),
177
		('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 1, NULL),
178
		('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
178
		('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
179
		('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
179
		('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
180
		('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL),
180
		('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL),
(-)a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-8 / +8 lines)
Lines 163-180 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
163
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
163
		('', '097', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 'LOCALLY ASSIGNED NLM-TYPE CLASSIFICATION NUMBER (OCLC)', 1, 0, NULL),
164
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
164
		('', '098', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 'OTHER CLASSIFICATION SCHEMES (OCLC)', 1, 0, NULL),
165
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
165
		('', '099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, NULL),
166
		('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 0, NULL),
166
		('', '100', 'HEADING--PERSONAL NAME', 'HEADING--PERSONAL NAME', 0, 1, NULL),
167
		('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 0, NULL),
167
		('', '110', 'HEADING--CORPORATE NAME', 'HEADING--CORPORATE NAME', 0, 1, NULL),
168
		('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 0, NULL),
168
		('', '111', 'HEADING--MEETING NAME', 'HEADING--MEETING NAME', 0, 1, NULL),
169
		('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 0, NULL),
169
		('', '130', 'HEADING--UNIFORM TITLE', 'HEADING--UNIFORM TITLE', 0, 1, NULL),
170
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
170
		('', '140', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 'UNIFORM TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
171
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
171
		('', '143', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 'COLLECTIVE TITLE [OBSOLETE, CAN/MARC]', 1, 0, NULL),
172
		('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 0, NULL),
172
		('', '148', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 0, 1, NULL),
173
		('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 0, NULL),
173
		('', '150', 'HEADING--TOPICAL TERM', 'HEADING--TOPICAL TERM', 0, 1, NULL),
174
		('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 0, NULL),
174
		('', '151', 'HEADING--GEOGRAPHIC NAME', 'HEADING--GEOGRAPHIC NAME', 0, 1, NULL),
175
		('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
175
		('', '153', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 'CLASSIFICATION NUMBER [CLASSIFICATION FORMAT]', 0, 0, NULL),
176
		('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
176
		('', '154', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 'GENERAL EXPLANATORY INDEX TERM [CLASSIFICATION FORMAT]', 0, 0, NULL),
177
		('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 0, NULL),
177
		('', '155', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 0, 1, NULL),
178
		('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
178
		('', '180', 'HEADING--GENERAL SUBDIVISION', 'HEADING--GENERAL SUBDIVISION', 0, 0, NULL),
179
		('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
179
		('', '181', 'HEADING--GEOGRAPHIC SUBDIVISION', 'HEADING--GEOGRAPHIC SUBDIVISION', 0, 0, NULL),
180
		('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL),
180
		('', '182', 'HEADING--CHRONOLOGICAL SUBDIVISION', 'HEADING--CHRONOLOGICAL SUBDIVISION', 0, 0, NULL),
(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_authorities_DEFAULT_general.sql (-14 / +14 lines)
Lines 426-433 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
426
 ('', '', '098', 'e', 0, 0, 'Feature heading', 'Feature heading',       0, 0, '', NULL, NULL, 0, NULL, 0),
426
 ('', '', '098', 'e', 0, 0, 'Feature heading', 'Feature heading',       0, 0, '', NULL, NULL, 0, NULL, 0),
427
 ('', '', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix',           0, 0, '', NULL, NULL, 0, NULL, 0);
427
 ('', '', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix',           0, 0, '', NULL, NULL, 0, NULL, 0);
428
428
429
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
429
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
430
 ('', '100', '', '', 'Заголовок – имя лица', 'Заголовок – имя лица', NULL);
430
 ('', '100', '', '', 'Заголовок – имя лица', 'Заголовок – имя лица', 1, NULL);
431
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
431
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
432
 ('', '', '100', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
432
 ('', '', '100', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
433
 ('', '', '100', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
433
 ('', '', '100', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 455-462 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
455
 ('', '', '100', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
455
 ('', '', '100', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
456
 ('', '', '100', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
456
 ('', '', '100', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
457
457
458
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
458
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
459
 ('', '110', '', '', 'Заголовок – наименование организации', 'Заголовок – наименование организации', NULL);
459
 ('', '110', '', '', 'Заголовок – наименование организации', 'Заголовок – наименование организации', 1, NULL);
460
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
460
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
461
 ('', '', '110', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
461
 ('', '', '110', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
462
 ('', '', '110', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
462
 ('', '', '110', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 482-489 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
482
 ('', '', '110', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
482
 ('', '', '110', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
483
 ('', '', '110', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
483
 ('', '', '110', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
484
484
485
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
485
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
486
 ('', '111', '', '', 'Заголовок – наименование мероприятия', 'Заголовок – наименование мероприятия', NULL);
486
 ('', '111', '', '', 'Заголовок – наименование мероприятия', 'Заголовок – наименование мероприятия', 1, NULL);
487
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
487
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
488
 ('', '', '111', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
488
 ('', '', '111', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
489
 ('', '', '111', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
489
 ('', '', '111', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 508-515 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
508
 ('', '', '111', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
508
 ('', '', '111', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
509
 ('', '', '111', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
509
 ('', '', '111', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
510
510
511
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
511
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
512
 ('', '130', '', '', 'Заголовок – унифицированное заглавие', 'Заголовок – унифицированное заглавие', NULL);
512
 ('', '130', '', '', 'Заголовок – унифицированное заглавие', 'Заголовок – унифицированное заглавие', 1, NULL);
513
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
513
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
514
 ('', '', '130', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
514
 ('', '', '130', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
515
 ('', '', '130', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
515
 ('', '', '130', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 568-575 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
568
 ('', '', '143', 'r', 0, 0, 'Музыкальный ключ', 'Музыкальный ключ',     1, 0, '', NULL, NULL, 0, NULL, 0),
568
 ('', '', '143', 'r', 0, 0, 'Музыкальный ключ', 'Музыкальный ключ',     1, 0, '', NULL, NULL, 0, NULL, 0),
569
 ('', '', '143', 's', 0, 1, 'Версия', 'Версия',                         1, 0, '', NULL, NULL, 0, NULL, 0);
569
 ('', '', '143', 's', 0, 1, 'Версия', 'Версия',                         1, 0, '', NULL, NULL, 0, NULL, 0);
570
570
571
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
571
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
572
 ('', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', NULL);
572
 ('', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 1, NULL);
573
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
573
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
574
 ('', '', '148', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
574
 ('', '', '148', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
575
 ('', '', '148', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
575
 ('', '', '148', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 591-598 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
591
 ('', '', '150', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
591
 ('', '', '150', 'y', 0, 1, 'Хронологический подзаголовок', 'Хронологический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
592
 ('', '', '150', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
592
 ('', '', '150', 'z', 0, 1, 'Географический подзаголовок', 'Географический подзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
593
593
594
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
594
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
595
 ('', '151', '', '', 'Заголовок – географическое название', 'Заголовок – географическое название', NULL);
595
 ('', '151', '', '', 'Заголовок – географическое название', 'Заголовок – географическое название', 1, NULL);
596
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
596
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
597
 ('', '', '151', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
597
 ('', '', '151', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
598
 ('', '', '151', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
598
 ('', '', '151', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 624-631 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
624
 ('', '', '154', 'b', 0, 1, 'General explanatory index term--Succeeding level', 'General explanatory index term--Succeeding level', 1, 0, '', NULL, NULL, 0, NULL, 0),
624
 ('', '', '154', 'b', 0, 1, 'General explanatory index term--Succeeding level', 'General explanatory index term--Succeeding level', 1, 0, '', NULL, NULL, 0, NULL, 0),
625
 ('', '', '154', 'f', 0, 1, 'Schedule identification', 'Schedule identification', 1, 0, '', NULL, NULL, 0, NULL, 0);
625
 ('', '', '154', 'f', 0, 1, 'Schedule identification', 'Schedule identification', 1, 0, '', NULL, NULL, 0, NULL, 0);
626
626
627
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
627
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
628
 ('', '155', '', '', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', NULL);
628
 ('', '155', '', '', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 1, NULL);
629
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
629
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
630
 ('', '', '155', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
630
 ('', '', '155', '6', 0, 0, 'Элемент связи', 'Элемент связи',           1, 0, '', NULL, NULL, 0, NULL, 0),
631
 ('', '', '155', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
631
 ('', '', '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 (-2 / +2 lines)
Lines 337-344 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
337
 ('', 'CHRON_TERM', '098', 'e', 0, 0, 'Feature heading', 'Feature heading', 0, 0, '', NULL, NULL, 0, NULL, 0),
337
 ('', 'CHRON_TERM', '098', 'e', 0, 0, 'Feature heading', 'Feature heading', 0, 0, '', NULL, NULL, 0, NULL, 0),
338
 ('', 'CHRON_TERM', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix', 0, 0, '', NULL, NULL, 0, NULL, 0);
338
 ('', 'CHRON_TERM', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix', 0, 0, '', NULL, NULL, 0, NULL, 0);
339
339
340
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
340
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
341
 ('CHRON_TERM', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', NULL);
341
 ('CHRON_TERM', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 1, NULL);
342
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
342
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
343
 ('', 'CHRON_TERM', '148', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0),
343
 ('', 'CHRON_TERM', '148', '6', 0, 0, 'Элемент связи', 'Элемент связи', 1, 0, '', NULL, NULL, 0, NULL, 0),
344
 ('', 'CHRON_TERM', '148', '8', 0, 1, 'Номер связи и порядковый номер', 'Номер связи и порядковый номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
344
 ('', '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 (-14 / +14 lines)
Lines 455-462 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
455
 ('', '', '100', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
455
 ('', '', '100', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
456
 ('', '', '100', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
456
 ('', '', '100', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
457
457
458
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
458
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
459
 ('', '110', '', '', 'Заголовок — найменування організації', 'Заголовок — найменування організації', NULL);
459
 ('', '110', '', '', 'Заголовок — найменування організації', 'Заголовок — найменування організації', 1, NULL);
460
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
460
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
461
 ('', '', '110', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
461
 ('', '', '110', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
462
 ('', '', '110', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
462
 ('', '', '110', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 482-489 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
482
 ('', '', '110', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
482
 ('', '', '110', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
483
 ('', '', '110', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
483
 ('', '', '110', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
484
484
485
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
485
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
486
 ('', '111', '', '', 'Заголовок – назва заходу', 'Заголовок – назва заходу', NULL);
486
 ('', '111', '', '', 'Заголовок – назва заходу', 'Заголовок – назва заходу', 1, NULL);
487
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
487
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
488
 ('', '', '111', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
488
 ('', '', '111', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
489
 ('', '', '111', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
489
 ('', '', '111', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 508-515 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
508
 ('', '', '111', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
508
 ('', '', '111', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
509
 ('', '', '111', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
509
 ('', '', '111', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
510
510
511
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
511
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
512
 ('', '130', '', '', 'Заголовок — уніфікований заголовок', 'Заголовок — уніфікований заголовок', NULL);
512
 ('', '130', '', '', 'Заголовок — уніфікований заголовок', 'Заголовок — уніфікований заголовок', 1, NULL);
513
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
513
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
514
 ('', '', '130', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
514
 ('', '', '130', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
515
 ('', '', '130', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
515
 ('', '', '130', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 568-575 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
568
 ('', '', '143', 'r', 0, 0, 'Музичний ключ', 'Музичний ключ',           1, 0, '', NULL, NULL, 0, NULL, 0),
568
 ('', '', '143', 'r', 0, 0, 'Музичний ключ', 'Музичний ключ',           1, 0, '', NULL, NULL, 0, NULL, 0),
569
 ('', '', '143', 's', 0, 1, 'Версія', 'Версія',                         1, 0, '', NULL, NULL, 0, NULL, 0);
569
 ('', '', '143', 's', 0, 1, 'Версія', 'Версія',                         1, 0, '', NULL, NULL, 0, NULL, 0);
570
570
571
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
571
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
572
 ('', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', NULL);
572
 ('', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 1,  NULL);
573
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
573
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
574
 ('', '', '148', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
574
 ('', '', '148', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
575
 ('', '', '148', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
575
 ('', '', '148', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 579-586 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
579
 ('', '', '148', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
579
 ('', '', '148', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
580
 ('', '', '148', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
580
 ('', '', '148', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
581
581
582
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
582
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
583
 ('', '150', '', '', 'Заголовок — тематичний термін', 'Заголовок — тематичний термін', NULL);
583
 ('', '150', '', '', 'Заголовок — тематичний термін', 'Заголовок — тематичний термін', 1, NULL);
584
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
584
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
585
 ('', '', '150', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
585
 ('', '', '150', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
586
 ('', '', '150', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
586
 ('', '', '150', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 591-598 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
591
 ('', '', '150', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
591
 ('', '', '150', 'y', 0, 1, 'Хронологічний підзаголовок', 'Хронологічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0),
592
 ('', '', '150', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
592
 ('', '', '150', 'z', 0, 1, 'Географічний підзаголовок', 'Географічний підзаголовок', 1, 0, '', NULL, NULL, 0, NULL, 0);
593
593
594
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
594
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
595
 ('', '151', '', '', 'Заголовок — географічна назва', 'Заголовок — географічна назва', NULL);
595
 ('', '151', '', '', 'Заголовок — географічна назва', 'Заголовок — географічна назва', 1, NULL);
596
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
596
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
597
 ('', '', '151', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
597
 ('', '', '151', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
598
 ('', '', '151', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
598
 ('', '', '151', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
Lines 624-631 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
624
 ('', '', '154', 'b', 0, 1, 'General explanatory index term--Succeeding level', 'General explanatory index term--Succeeding level', 1, 0, '', NULL, NULL, 0, NULL, 0),
624
 ('', '', '154', 'b', 0, 1, 'General explanatory index term--Succeeding level', 'General explanatory index term--Succeeding level', 1, 0, '', NULL, NULL, 0, NULL, 0),
625
 ('', '', '154', 'f', 0, 1, 'Schedule identification', 'Schedule identification', 1, 0, '', NULL, NULL, 0, NULL, 0);
625
 ('', '', '154', 'f', 0, 1, 'Schedule identification', 'Schedule identification', 1, 0, '', NULL, NULL, 0, NULL, 0);
626
626
627
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
627
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
628
 ('', '155', '', '', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', NULL);
628
 ('', '155', '', '', 'HEADING--GENRE/FORM TERM', 'HEADING--GENRE/FORM TERM', 1, NULL);
629
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
629
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
630
 ('', '', '155', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
630
 ('', '', '155', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку',       1, 0, '', NULL, NULL, 0, NULL, 0),
631
 ('', '', '155', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
631
 ('', '', '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 (-3 / +2 lines)
Lines 337-344 INSERT INTO auth_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
337
 ('', 'CHRON_TERM', '098', 'e', 0, 0, 'Feature heading', 'Feature heading', 0, 0, '', NULL, NULL, 0, NULL, 0),
337
 ('', 'CHRON_TERM', '098', 'e', 0, 0, 'Feature heading', 'Feature heading', 0, 0, '', NULL, NULL, 0, NULL, 0),
338
 ('', 'CHRON_TERM', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix', 0, 0, '', NULL, NULL, 0, NULL, 0);
338
 ('', 'CHRON_TERM', '098', 'f', 0, 0, 'Filing suffix', 'Filing suffix', 0, 0, '', NULL, NULL, 0, NULL, 0);
339
339
340
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
340
INSERT INTO auth_tag_structure  (authtypecode, tagfield, mandatory, repeatable, liblibrarian, libopac, mandatory, authorised_value) VALUES
341
 ('CHRON_TERM', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', NULL);
341
 ('CHRON_TERM', '148', '', '', 'HEADING--CHRONOLOGICAL TERM', 'HEADING--CHRONOLOGICAL TERM', 1, NULL);
342
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
342
INSERT INTO  auth_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, linkid) VALUES
343
 ('', 'CHRON_TERM', '148', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0),
343
 ('', 'CHRON_TERM', '148', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 1, 0, '', NULL, NULL, 0, NULL, 0),
344
 ('', 'CHRON_TERM', '148', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
344
 ('', 'CHRON_TERM', '148', '8', 0, 1, 'Номер зв’язку та порядковий номер', 'Номер зв’язку та порядковий номер', 1, 0, '', NULL, NULL, 0, NULL, 0),
345
- 

Return to bug 13775