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

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql (-8 / +8 lines)
Lines 1584-1604 INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, Link Here
1584
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1584
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1585
 ('', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1585
 ('', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1586
 ('', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1586
 ('', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1587
 ('', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1587
 ('', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1588
 ('', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1588
 ('', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1589
 ('', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, 0, '', '', '', NULL, '', '', NULL),
1589
 ('', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1590
 ('', '', '440', 'v', 0, 0, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1590
 ('', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1591
 ('', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1591
 ('', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1592
1592
1593
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1593
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1594
 ('', '490', 0, 1, 'Серія', '', '');
1594
 ('', '490', 0, 1, 'Серія', '', '');
1595
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1595
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1596
 ('', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1596
 ('', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1597
 ('', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1597
 ('', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1598
 ('', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, -1, '', '', '', NULL, '', '', NULL),
1598
 ('', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1599
 ('', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1599
 ('', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1600
 ('', '', '490', 'v', 0, 1, '№ тому', '',                               4, -1, '', '', '', NULL, '', '', NULL),
1600
 ('', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1601
 ('', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, -1, '', '', '', NULL, '', '', NULL);
1601
 ('', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1602
1602
1603
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1603
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1604
 ('', '500', 0, 1, 'Примітка', '', '');
1604
 ('', '500', 0, 1, 'Примітка', '', '');
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql (-1 / +1 lines)
Lines 53-59 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
53
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
53
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
54
 ('', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     4, -5, '', '', '', 0, '', '', NULL);
54
 ('', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     4, -5, '', '', '', 0, '', '', NULL);
55
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
55
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
56
 ('', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     4, -5, '', '', '', 0, '', '', NULL);
56
 ('', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     4, -6, '', '', '', 0, '', '', NULL);
57
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
57
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
58
 ('', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     6, -5, '', '', '', 0, '', '', NULL);
58
 ('', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                     6, -5, '', '', '', 0, '', '', NULL);
59
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
59
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_general.sql (-13 / +13 lines)
Lines 1276-1300 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
1276
 ('AR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1276
 ('AR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1277
1277
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1279
 ('AR', '440', '', 1, 'Серія', '', NULL);
1279
 ('AR', '440', 0, 1, 'Серія', '', '');
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1281
 ('AR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1281
 ('AR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('AR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('AR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1283
 ('AR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1283
 ('AR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1284
 ('AR', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1284
 ('AR', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1285
 ('AR', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
1285
 ('AR', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1286
 ('AR', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1286
 ('AR', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1287
 ('AR', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
1287
 ('AR', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1288
1288
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1290
 ('AR', '490', '', 1, 'Серія', '', '');
1290
 ('AR', '490', 0, 1, 'Серія', '', '');
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1292
 ('AR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1292
 ('AR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1293
 ('AR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
1293
 ('AR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1294
 ('AR', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1294
 ('AR', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1295
 ('AR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1295
 ('AR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('AR', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('AR', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1297
 ('AR', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
1297
 ('AR', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1298
1298
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1300
 ('AR', '500', '', 1, 'Примітка', '', NULL);
1300
 ('AR', '500', '', 1, 'Примітка', '', NULL);
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql (-1 / +1 lines)
Lines 43-49 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
44
 ('AR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
44
 ('AR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
46
 ('AR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
46
 ('AR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
48
 ('AR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
48
 ('AR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_general.sql (-13 / +13 lines)
Lines 1276-1300 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
1276
 ('BKS', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1276
 ('BKS', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1277
1277
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1279
 ('BKS', '440', '', 1, 'Серія', '', NULL);
1279
 ('BKS', '440', 0, 1, 'Серія', '', '');
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1281
 ('BKS', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                   4, -6, '', '', '', NULL, '', '', NULL),
1281
 ('BKS', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('BKS', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('BKS', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1283
 ('BKS', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                   4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1283
 ('BKS', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1284
 ('BKS', '', '440', 'n', 0, 1, 'Номер частини', '',                     4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1284
 ('BKS', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1285
 ('BKS', '', '440', 'p', 0, 1, 'Назва частини', '',                     4, 0, '', '', '', NULL, '', '', NULL),
1285
 ('BKS', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1286
 ('BKS', '', '440', 'v', 0, 0, '№ тому', '',                            4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1286
 ('BKS', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1287
 ('BKS', '', '440', 'x', 0, 0, 'ISSN серії', '',                        4, 0, '', '', '', NULL, '', '', NULL);
1287
 ('BKS', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1288
1288
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1290
 ('BKS', '490', '', 1, 'Серія', '', '');
1290
 ('BKS', '490', 0, 1, 'Серія', '', '');
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1292
 ('BKS', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                   4, -6, '', '', '', NULL, '', '', NULL),
1292
 ('BKS', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1293
 ('BKS', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
1293
 ('BKS', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1294
 ('BKS', '', '490', 'a', 0, 1, 'Назва серії', '',                       4, -6, '', '', '', NULL, '', '', NULL),
1294
 ('BKS', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1295
 ('BKS', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1295
 ('BKS', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('BKS', '', '490', 'v', 0, 1, '№ тому', '',                            4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('BKS', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1297
 ('BKS', '', '490', 'x', 0, 0, 'ISSN серії', '',                        4, -6, '', '', '', NULL, '', '', NULL);
1297
 ('BKS', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1298
1298
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1300
 ('BKS', '500', '', 1, 'Примітка', '', NULL);
1300
 ('BKS', '500', '', 1, 'Примітка', '', NULL);
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql (-1 / +1 lines)
Lines 43-49 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
44
 ('BKS', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
44
 ('BKS', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
46
 ('BKS', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
46
 ('BKS', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -6, '', '', '', 0, '', '', NULL);
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
48
 ('BKS', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  6, -5, '', '', '', 0, '', '', NULL);
48
 ('BKS', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  6, -5, '', '', '', 0, '', '', NULL);
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_general.sql (-16 / +16 lines)
Lines 1276-1300 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
1276
 ('CF', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1276
 ('CF', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1277
1277
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1279
 ('CF', '440', '', 1, 'Серія', '', NULL);
1279
 ('CF', '440', 0, 1, 'Серія', '', '');
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1281
 ('CF', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1281
 ('CF', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('CF', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('CF', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1283
 ('CF', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1283
 ('CF', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1284
 ('CF', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1284
 ('CF', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1285
 ('CF', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
1285
 ('CF', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1286
 ('CF', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1286
 ('CF', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1287
 ('CF', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
1287
 ('CF', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1288
1288
 
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1290
 ('CF', '490', '', 1, 'Серія', '', '');
1290
 ('CF', '490', 0, 1, 'Серія', '', '');
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1292
 ('CF', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1292
 ('CF', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1293
 ('CF', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
1293
 ('CF', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1294
 ('CF', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1294
 ('CF', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1295
 ('CF', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1295
 ('CF', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('CF', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('CF', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1297
 ('CF', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
1297
 ('CF', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1298
1298
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1300
 ('CF', '500', '', 1, 'Примітка', '', NULL);
1300
 ('CF', '500', '', 1, 'Примітка', '', NULL);
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql (-1 / +1 lines)
Lines 43-49 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
44
 ('CF', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
44
 ('CF', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
46
 ('CF', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
46
 ('CF', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
48
 ('CF', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
48
 ('CF', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_general.sql (-16 / +16 lines)
Lines 1276-1300 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
1276
 ('IR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1276
 ('IR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1277
1277
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1279
 ('IR', '440', '', 1, 'Серія', '', NULL);
1279
 ('IR', '440', 0, 1, 'Серія', '', '');
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1281
 ('IR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1281
 ('IR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('IR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('IR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1283
 ('IR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1283
 ('IR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1284
 ('IR', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1284
 ('IR', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1285
 ('IR', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
1285
 ('IR', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1286
 ('IR', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1286
 ('IR', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1287
 ('IR', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
1287
 ('IR', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1288
1288
 
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1290
 ('IR', '490', '', 1, 'Серія', '', '');
1290
 ('IR', '490', 0, 1, 'Серія', '', '');
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1292
 ('IR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1292
 ('IR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1293
 ('IR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
1293
 ('IR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1294
 ('IR', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1294
 ('IR', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1295
 ('IR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1295
 ('IR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('IR', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('IR', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1297
 ('IR', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
1297
 ('IR', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1298
1298
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1300
 ('IR', '500', '', 1, 'Примітка', '', NULL);
1300
 ('IR', '500', '', 1, 'Примітка', '', NULL);
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql (-1 / +1 lines)
Lines 43-49 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
44
 ('IR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
44
 ('IR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
46
 ('IR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
46
 ('IR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
48
 ('IR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
48
 ('IR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_general.sql (-16 / +16 lines)
Lines 1276-1300 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
1276
 ('KT', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1276
 ('KT', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1277
1277
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1279
 ('KT', '440', '', 1, 'Серія', '', NULL);
1279
 ('KT', '440', 0, 1, 'Серія', '', '');
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1281
 ('KT', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1281
 ('KT', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('KT', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('KT', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1283
 ('KT', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1283
 ('KT', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1284
 ('KT', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1284
 ('KT', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1285
 ('KT', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
1285
 ('KT', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1286
 ('KT', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1286
 ('KT', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1287
 ('KT', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
1287
 ('KT', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1288
1288
 
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1290
 ('KT', '490', '', 1, 'Серія', '', '');
1290
 ('KT', '490', 0, 1, 'Серія', '', '');
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1292
 ('KT', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1292
 ('KT', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1293
 ('KT', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
1293
 ('KT', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1294
 ('KT', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1294
 ('KT', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1295
 ('KT', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1295
 ('KT', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('KT', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('KT', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1297
 ('KT', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
1297
 ('KT', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1298
1298
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1300
 ('KT', '500', '', 1, 'Примітка', '', NULL);
1300
 ('KT', '500', '', 1, 'Примітка', '', NULL);
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql (-1 / +1 lines)
Lines 43-49 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
44
 ('KT', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
44
 ('KT', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
46
 ('KT', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
46
 ('KT', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
48
 ('KT', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
48
 ('KT', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_general.sql (-16 / +16 lines)
Lines 1276-1300 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
1276
 ('SER', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1276
 ('SER', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1277
1277
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1279
 ('SER', '440', '', 1, 'Серія', '', NULL);
1279
 ('SER', '440', 0, 1, 'Серія', '', '');
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1281
 ('SER', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                   4, -6, '', '', '', NULL, '', '', NULL),
1281
 ('SER', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('SER', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('SER', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1283
 ('SER', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                   4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1283
 ('SER', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1284
 ('SER', '', '440', 'n', 0, 1, 'Номер частини', '',                     4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1284
 ('SER', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1285
 ('SER', '', '440', 'p', 0, 1, 'Назва частини', '',                     4, 0, '', '', '', NULL, '', '', NULL),
1285
 ('SER', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1286
 ('SER', '', '440', 'v', 0, 0, '№ тому', '',                            4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1286
 ('SER', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1287
 ('SER', '', '440', 'x', 0, 0, 'ISSN серії', '',                        4, 0, '', '', '', NULL, '', '', NULL);
1287
 ('SER', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1288
1288
 
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1290
 ('SER', '490', '', 1, 'Серія', '', '');
1290
 ('SER', '490', 0, 1, 'Серія', '', '');
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1292
 ('SER', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                   4, -6, '', '', '', NULL, '', '', NULL),
1292
 ('SER', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1293
 ('SER', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
1293
 ('SER', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1294
 ('SER', '', '490', 'a', 0, 1, 'Назва серії', '',                       4, -6, '', '', '', NULL, '', '', NULL),
1294
 ('SER', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1295
 ('SER', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1295
 ('SER', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('SER', '', '490', 'v', 0, 1, '№ тому', '',                            4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('SER', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1297
 ('SER', '', '490', 'x', 0, 0, 'ISSN серії', '',                        4, -6, '', '', '', NULL, '', '', NULL);
1297
 ('SER', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1298
1298
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1300
 ('SER', '500', '', 1, 'Примітка', '', NULL);
1300
 ('SER', '500', '', 1, 'Примітка', '', NULL);
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql (-1 / +1 lines)
Lines 43-49 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
44
 ('SER', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
44
 ('SER', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
46
 ('SER', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -5, '', '', '', 0, '', '', NULL);
46
 ('SER', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  4, -6, '', '', '', 0, '', '', NULL);
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
48
 ('SER', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  6, -5, '', '', '', 0, '', '', NULL);
48
 ('SER', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                  6, -5, '', '', '', 0, '', '', NULL);
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_general.sql (-16 / +16 lines)
Lines 1276-1300 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
1276
 ('SR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1276
 ('SR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1277
1277
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1279
 ('SR', '440', '', 1, 'Серія', '', NULL);
1279
 ('SR', '440', 0, 1, 'Серія', '', '');
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1281
 ('SR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1281
 ('SR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('SR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('SR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1283
 ('SR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1283
 ('SR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1284
 ('SR', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1284
 ('SR', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1285
 ('SR', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
1285
 ('SR', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1286
 ('SR', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1286
 ('SR', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1287
 ('SR', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
1287
 ('SR', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1288
1288
 
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1290
 ('SR', '490', '', 1, 'Серія', '', '');
1290
 ('SR', '490', 0, 1, 'Серія', '', '');
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1292
 ('SR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1292
 ('SR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1293
 ('SR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
1293
 ('SR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1294
 ('SR', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1294
 ('SR', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1295
 ('SR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1295
 ('SR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('SR', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('SR', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1297
 ('SR', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
1297
 ('SR', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1298
1298
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1300
 ('SR', '500', '', 1, 'Примітка', '', NULL);
1300
 ('SR', '500', '', 1, 'Примітка', '', NULL);
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql (-1 / +1 lines)
Lines 43-49 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
44
 ('SR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
44
 ('SR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
46
 ('SR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
46
 ('SR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
48
 ('SR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
48
 ('SR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_general.sql (-16 / +16 lines)
Lines 1276-1300 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
1276
 ('VR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1276
 ('VR', '', '411', 'x', 0, 0, 'International Standard Serial Number', 'International Standard Serial Number', 4, -6, '', '', '', NULL, '', '', NULL);
1277
1277
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1278
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1279
 ('VR', '440', '', 1, 'Серія', '', NULL);
1279
 ('VR', '440', 0, 1, 'Серія', '', '');
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1280
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1281
 ('VR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1281
 ('VR', '', '440', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('VR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1282
 ('VR', '', '440', '8', 0, 1, 'Зв’язок полів та номер послідовності', '', 4, -6, '', '', '', NULL, '', '', NULL),
1283
 ('VR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                    4, 0, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1283
 ('VR', 'UNIF_TITLE', '440', 'a', 0, 0, 'Серія', '',                      4, -6, 'biblio.seriestitle', '', '', NULL, '\'440n\',\'440p\',\'490a\',\'830a\',\'830n\',\'830p\',\'899a\'', '', NULL),
1284
 ('VR', '', '440', 'n', 0, 1, 'Номер частини', '',                      4, 0, 'biblioitems.number', '', '', NULL, '', '', NULL),
1284
 ('VR', '', '440', 'n', 0, 1, 'Номер частини', '',                        4, -6, 'biblioitems.number', '', '', NULL, '', '', NULL),
1285
 ('VR', '', '440', 'p', 0, 1, 'Назва частини', '',                      4, 0, '', '', '', NULL, '', '', NULL),
1285
 ('VR', '', '440', 'p', 0, 1, 'Назва частини', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1286
 ('VR', '', '440', 'v', 0, 0, '№ тому', '',                             4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1286
 ('VR', '', '440', 'v', 0, 0, '№ тому', '',                               4, -6, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1287
 ('VR', '', '440', 'x', 0, 0, 'ISSN серії', '',                         4, 0, '', '', '', NULL, '', '', NULL);
1287
 ('VR', '', '440', 'x', 0, 0, 'ISSN серії', '',                           4, -6, '', '', '', NULL, '', '', NULL);
1288
1288
 
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1289
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1290
 ('VR', '490', '', 1, 'Серія', '', '');
1290
 ('VR', '490', 0, 1, 'Серія', '', '');
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1291
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
1292
 ('VR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                    4, -6, '', '', '', NULL, '', '', NULL),
1292
 ('VR', '', '490', '6', 0, 0, 'Елемент зв’язку', '',                      4, -6, '', '', '', NULL, '', '', NULL),
1293
 ('VR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 4, -6, '', '', NULL, NULL, '', '', NULL),
1293
 ('VR', '', '490', '8', 0, 1, 'Зв’язок полів і номер послідовності', '',  4, -6, '', '', NULL, NULL, '', '', NULL),
1294
 ('VR', '', '490', 'a', 0, 1, 'Назва серії', '',                        4, -6, '', '', '', NULL, '', '', NULL),
1294
 ('VR', '', '490', 'a', 0, 1, 'Назва серії', '',                          4, 0, 'biblioitems.seriestitle', '', '', NULL, '', '', NULL),
1295
 ('VR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1295
 ('VR', '', '490', 'l', 0, 0, 'Library of Congress call number', 'Library of Congress call number', 4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('VR', '', '490', 'v', 0, 1, '№ тому', '',                             4, -6, '', '', '', NULL, '', '', NULL),
1296
 ('VR', '', '490', 'v', 0, 1, '№ тому', '',                               4, 0, 'biblioitems.volume', '', '', NULL, '', '', NULL),
1297
 ('VR', '', '490', 'x', 0, 0, 'ISSN серії', '',                         4, -6, '', '', '', NULL, '', '', NULL);
1297
 ('VR', '', '490', 'x', 0, 0, 'ISSN серії', '',                           4, 0, '', '', '', NULL, '', '', NULL);
1298
1298
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1299
INSERT INTO marc_tag_structure  (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
1300
 ('VR', '500', '', 1, 'Примітка', '', NULL);
1300
 ('VR', '500', '', 1, 'Примітка', '', NULL);
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql (-2 / +1 lines)
Lines 43-49 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
43
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
44
 ('VR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
44
 ('VR', '', '411', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
45
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
46
 ('VR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -5, '', '', '', 0, '', '', NULL);
46
 ('VR', '', '440', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   4, -6, '', '', '', 0, '', '', NULL);
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
47
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
48
 ('VR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
48
 ('VR', '', '600', '9', 0, 0, '9 (RLIN)', '9 (RLIN)',                   6, -5, '', '', '', 0, '', '', NULL);
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
49
INSERT INTO  marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES
50
- 

Return to bug 7947