Lines 1-5
Link Here
|
1 |
-- На основі MARC21-структури англійською „DEFAULT“ |
1 |
-- На основі MARC21-структури англійською „DEFAULT“ |
2 |
-- Переклад/адаптація: Сергій Дубик, Ольга Баркова (2011) |
2 |
-- Переклад/адаптація: Сергій Дубик (2011-2016), Ольга Баркова (2011) |
|
|
3 |
|
4 |
-- Changes: |
5 |
-- 2016.12.21: Add 083acmqyz268, 085abcfrstuvwyz68 and much more |
6 |
|
3 |
|
7 |
|
4 |
-- DELETE FROM biblio_framework WHERE frameworkcode=''; |
8 |
-- DELETE FROM biblio_framework WHERE frameworkcode=''; |
5 |
-- INSERT INTO biblio_framework (frameworkcode, frameworktext) VALUES ('', ''); |
9 |
-- INSERT INTO biblio_framework (frameworkcode, frameworktext) VALUES ('', ''); |
Lines 78-84
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
78 |
('', '', '015', '2', 0, 1, 'Джерело номера', '', 0, 0, '', '', NULL, 0, '', '', NULL), |
82 |
('', '', '015', '2', 0, 1, 'Джерело номера', '', 0, 0, '', '', NULL, 0, '', '', NULL), |
79 |
('', '', '015', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, -6, '', '', '', 0, '', '', NULL), |
83 |
('', '', '015', '6', 0, 0, 'Елемент зв’язку', 'Елемент зв’язку', 0, -6, '', '', '', 0, '', '', NULL), |
80 |
('', '', '015', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 0, -6, '', '', '', 0, '', '', NULL), |
84 |
('', '', '015', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 0, -6, '', '', '', 0, '', '', NULL), |
81 |
('', '', '015', 'a', 0, 1, 'Номер в нац.бібліогр.', '', 0, 0, '', '', '', 0, '', '', NULL); |
85 |
('', '', '015', 'a', 0, 1, 'Номер в нац.бібліогр.', '', 0, 0, '', '', '', 0, '', '', NULL), |
|
|
86 |
('', '', '015', 'q', 0, 1, 'Qualifying information', '', 0, 0, '', '', '', 0, '', '', NULL), |
87 |
('', '', '015', 'z', 0, 1, 'Canceled/invalid national bibliography number', '', 0, 0, '', '', '', 0, '', '', NULL); |
82 |
|
88 |
|
83 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
89 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
84 |
('', '016', '', 1, 'Контрольний номер національного бібліографічного агентства', '', ''); |
90 |
('', '016', '', 1, 'Контрольний номер національного бібліографічного агентства', '', ''); |
Lines 529-534
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
529 |
('', '', '082', 'b', 0, 0, 'Номер одиниці', '', 0, 0, '', '', '', NULL, '', '', NULL); |
535 |
('', '', '082', 'b', 0, 0, 'Номер одиниці', '', 0, 0, '', '', '', NULL, '', '', NULL); |
530 |
|
536 |
|
531 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
537 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
538 |
('', '083', '', 1, 'Additional Dewey Decimal Classification Number', '', ''); |
539 |
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 |
540 |
('', NULL, '083', 'a', 0, 0, 'Classification number', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
541 |
('', NULL, '083', 'c', 0, 0, 'Classification number--Ending number of span', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
542 |
('', NULL, '083', 'm', 0, 0, 'Standard or optional designation', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
543 |
('', NULL, '083', 'q', 0, 0, 'Assigning agency', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
544 |
('', NULL, '083', 'y', 0, 0, 'Table sequence number for internal subarrangement or add table', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
545 |
('', NULL, '083', 'z', 0, 0, 'Table identification', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
546 |
('', NULL, '083', '2', 0, 0, 'Edition number', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
547 |
('', NULL, '083', '6', 0, 0, 'Linkage', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
548 |
('', NULL, '083', '8', 0, 0, 'Field link and sequence number', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL); |
549 |
|
550 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
532 |
('', '084', '', 1, 'Індекс ББК', '', ''); |
551 |
('', '084', '', 1, 'Індекс ББК', '', ''); |
533 |
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 |
552 |
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 |
534 |
('', NULL, '084', '2', 0, 0, 'Джерело індексу', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
553 |
('', NULL, '084', '2', 0, 0, 'Джерело індексу', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
Lines 538-543
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
538 |
('', NULL, '084', 'b', 0, 0, 'Номер одиниці', '', 0, -6, NULL, NULL, '', NULL, '', '', NULL); |
557 |
('', NULL, '084', 'b', 0, 0, 'Номер одиниці', '', 0, -6, NULL, NULL, '', NULL, '', '', NULL); |
539 |
|
558 |
|
540 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
559 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
560 |
('', '085', '', 1, 'Synthesized Classification Number Components', '', ''); |
561 |
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 |
562 |
('', NULL, '085', 'a', 0, 0, 'Number where instructions are found-single number or beginning number of span', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
563 |
('', NULL, '085', 'b', 0, 0, 'Base number', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
564 |
('', NULL, '085', 'c', 0, 0, 'Classification number-ending number of span', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
565 |
('', NULL, '085', 'f', 0, 0, 'Facet designator', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
566 |
('', NULL, '085', 'r', 0, 0, 'Root number', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
567 |
('', NULL, '085', 's', 0, 0, 'Digits added from classification number in schedule or external table', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
568 |
('', NULL, '085', 't', 0, 0, 'Digits added from internal subarrangement or add table', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
569 |
('', NULL, '085', 'u', 0, 0, 'Number being analyzed', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
570 |
('', NULL, '085', 'v', 0, 0, 'Number in internal subarrangement or add table where instructions are found', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
571 |
('', NULL, '085', 'w', 0, 0, 'Table identification-Internal subarrangement or add table', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
572 |
('', NULL, '085', 'y', 0, 0, 'Table sequence number for internal subarrangement or add table', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
573 |
('', NULL, '085', 'z', 0, 0, 'Table identification', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
574 |
('', NULL, '085', '6', 0, 0, 'Linkage', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL), |
575 |
('', NULL, '085', '8', 0, 0, 'Field link and sequence number', '', 0, 0, NULL, NULL, '', NULL, '', '', NULL); |
576 |
|
577 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
541 |
('', '086', '', 1, 'Класифікаційний номер документа органу державної влади', '', ''); |
578 |
('', '086', '', 1, 'Класифікаційний номер документа органу державної влади', '', ''); |
542 |
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 |
579 |
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 |
543 |
('', NULL, '086', '2', 0, 0, 'Джерело індексу', '', 0, -1, NULL, NULL, '', NULL, '', '', NULL), |
580 |
('', NULL, '086', '2', 0, 0, 'Джерело індексу', '', 0, -1, NULL, NULL, '', NULL, '', '', NULL), |
Lines 615-621
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
615 |
('', '', '100', '4', 0, 0, 'Код відношення', '', 1, 0, '', '', '', 0, '', '', NULL), |
652 |
('', '', '100', '4', 0, 0, 'Код відношення', '', 1, 0, '', '', '', 0, '', '', NULL), |
616 |
('', '', '100', '6', 0, 0, 'Зв’язок', '', 1, -6, '', '', '', 0, '', '', NULL), |
653 |
('', '', '100', '6', 0, 0, 'Зв’язок', '', 1, -6, '', '', '', 0, '', '', NULL), |
617 |
('', '', '100', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 1, -6, '', '', '', 0, '', '', NULL), |
654 |
('', '', '100', '8', 0, 1, 'Зв’язок поля та його порядковий номер', '', 1, -6, '', '', '', 0, '', '', NULL), |
618 |
('', 'PERSO_NAME', '100', 'a', 0, 0, 'Автор', '', 1, 0, 'biblio.author', '', '', 0, '\'100b\',\'100c\',\'100q\',\'100d\',\'100e\',\'110a\',\'110b\',\'110c\',\'110d\',\'110e\',\'111a\',\'111e\',\'111c\',\'111d\',\'130a\',\'700a\',\'700b\',\'700c\',\'700q\',\'700d\',\'700e\',\'710a\',\'710b\',\'710c\',\'710d\',\'710e\',\'711a\',\'711e\',\'711c\',\'711d\',\'720a\',\'720e\',\'796a\',\'796b\',\'796c\',\'796q\',\'796d\',\'796e\',\'797a\',\'797b\',\'797c\',\'797d\',\'797e\',\'798a\',\'798e\',\'798c\',\'798d\',\'800a\',\'800b\',\'800c\',\'800q\',\'800d\',\'800e\',\'810a\',\'810b\',\'810c\',\'810d\',\'810e\',\'811a\',\'811e\',\'811c\',\'811d\',\'896a\',\'896b\',\'896c\',\'896q\',\'896d\',\'896e\',\'897a\',\'897b\',\'897c\',\'897d\',\'897e\',\'898a\',\'898e\',\'898c\',\'898d\',\'505r\'', '', NULL), |
655 |
('', 'PERSO_NAME', '100', 'a', 0, 0, 'Автор', '', 1, 0, 'biblio.author', '', '', 0, '\'100b\',\'100c\',\'100q\',\'100d\',\'100e\',\'110a\',\'110b\',\'110c\',\'110d\',\'110e\',\'111a\',\'111e\',\'111c\',\'111d\',\'130a\', |
|
|
656 |
\'700a\',\'700b\',\'700c\',\'700q\',\'700d\',\'700e\',\'710a\',\'710b\',\'710c\',\'710d\',\'710e\',\'711a\',\'711e\',\'711c\',\'711d\',\'720a\',\'720e\',\'796a\',\'796b\',\'796c\',\'796q\',\'796d\',\'796e\',\'797a\',\'797b\',\'797c\',\'797d\', |
657 |
\'797e\',\'798a\',\'798e\',\'798c\',\'798d\',\'800a\',\'800b\',\'800c\',\'800q\',\'800d\',\'800e\',\'810a\',\'810b\',\'810c\',\'810d\',\'810e\',\'811a\',\'811e\',\'811c\',\'811d\',\'896a\',\'896b\',\'896c\',\'896q\',\'896d\',\'896e\',\'897a\', |
658 |
\'897b\',\'897c\',\'897d\',\'897e\',\'898a\',\'898e\',\'898c\',\'898d\',\'505r\'', '', NULL), |
619 |
('', '', '100', 'b', 0, 0, 'Династ. номер', '', 1, -1, '', '', '', 0, '', '', NULL), |
659 |
('', '', '100', 'b', 0, 0, 'Династ. номер', '', 1, -1, '', '', '', 0, '', '', NULL), |
620 |
('', '', '100', 'c', 0, 0, 'Титул (звання)', '', 1, -1, '', '', '', 0, '', '', NULL), |
660 |
('', '', '100', 'c', 0, 0, 'Титул (звання)', '', 1, -1, '', '', '', 0, '', '', NULL), |
621 |
('', '', '100', 'd', 0, 0, 'Дата', '', 1, 0, '', '', '', 0, '', '', NULL), |
661 |
('', '', '100', 'd', 0, 0, 'Дата', '', 1, 0, '', '', '', 0, '', '', NULL), |
Lines 1070-1075
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
1070 |
('', NULL, '321', 'b', 0, 0, 'Дата існуючої періодичності', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL); |
1110 |
('', NULL, '321', 'b', 0, 0, 'Дата існуючої періодичності', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL); |
1071 |
|
1111 |
|
1072 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1112 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
1113 |
('', '336', '', 1, 'Content Type', '', ''); |
1114 |
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 |
1115 |
('', '', '336', 'a', 0, 0, 'Content type term', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1116 |
('', '', '336', 'b', 0, 0, 'Content type code', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1117 |
('', '', '336', '0', 0, 0, 'Authority record control number or standard number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1118 |
('', '', '336', '2', 0, 0, 'Source', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1119 |
('', '', '336', '3', 0, 0, 'Materials specified', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1120 |
('', '', '336', '6', 0, 0, 'Linkage', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1121 |
('', '', '336', '8', 0, 0, 'Field link and sequence number', '', 3, -6, '', '', '', NULL, '', '', NULL); |
1122 |
|
1123 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1124 |
('', '337', '', 1, 'Media Type', '', ''); |
1125 |
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 |
1126 |
('', '', '337', 'a', 0, 0, 'Media type term', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1127 |
('', '', '337', 'b', 0, 0, 'Media type code', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1128 |
('', '', '337', '0', 0, 0, 'Authority record control number or standard number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1129 |
('', '', '337', '2', 0, 0, 'Source', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1130 |
('', '', '337', '3', 0, 0, 'Materials specified', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1131 |
('', '', '337', '6', 0, 0, 'Linkage', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1132 |
('', '', '337', '8', 0, 0, 'Field link and sequence number', '', 3, -6, '', '', '', NULL, '', '', NULL); |
1133 |
|
1134 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1135 |
('', '338', '', 1, 'Carrier Type', '', ''); |
1136 |
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 |
1137 |
('', '', '338', 'a', 0, 0, 'Carrier type term', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1138 |
('', '', '338', 'b', 0, 0, 'Carrier type code', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1139 |
('', '', '338', '0', 0, 0, 'Authority record control number or standard number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1140 |
('', '', '338', '2', 0, 0, 'Source', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1141 |
('', '', '338', '3', 0, 0, 'Materials specified', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1142 |
('', '', '338', '6', 0, 0, 'Linkage', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1143 |
('', '', '338', '8', 0, 0, 'Field link and sequence number', '', 3, -6, '', '', '', NULL, '', '', NULL); |
1144 |
|
1145 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1073 |
('', '340', '', 1, 'Фізичний носій', '', ''); |
1146 |
('', '340', '', 1, 'Фізичний носій', '', ''); |
1074 |
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 |
1147 |
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 |
1075 |
('', '', '340', '3', 0, 0, 'Область застосування даних поля', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1148 |
('', '', '340', '3', 0, 0, 'Область застосування даних поля', '', 3, -6, '', '', '', NULL, '', '', NULL), |
Lines 1130-1135
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
1130 |
('', '', '343', 'i', 0, 0, 'Bearing reference meridian', 'Bearing reference meridian', 3, -6, '', '', '', NULL, '', '', NULL); |
1203 |
('', '', '343', 'i', 0, 0, 'Bearing reference meridian', 'Bearing reference meridian', 3, -6, '', '', '', NULL, '', '', NULL); |
1131 |
|
1204 |
|
1132 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1205 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
1206 |
('', '344', '', 1, 'Sound Characteristics', '', NULL); |
1207 |
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 |
1208 |
('', '', '344', '0', 0, 0, 'Authority record control number or standard number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1209 |
('', '', '344', '2', 0, 0, 'Source', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1210 |
('', '', '344', '3', 0, 0, 'Materials specified', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1211 |
('', '', '344', '6', 0, 0, 'Linkage', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1212 |
('', '', '344', '8', 0, 0, 'Field link and sequence number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1213 |
('', '', '344', 'a', 0, 0, 'Type of recording', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1214 |
('', '', '344', 'b', 0, 0, 'Recording medium', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1215 |
('', '', '344', 'c', 0, 0, 'Playing speed', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1216 |
('', '', '344', 'd', 0, 0, 'Groove characteristic', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1217 |
('', '', '344', 'e', 0, 0, 'Track configuration', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1218 |
('', '', '344', 'f', 0, 0, 'Tape configuration', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1219 |
('', '', '344', 'g', 0, 0, 'Configuration of playback channels', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1220 |
('', '', '344', 'h', 0, 0, 'Special playback characteristics', '', 3, -6, '', '', '', NULL, '', '', NULL); |
1221 |
|
1222 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1223 |
('', '345', '', 1, 'Projection Characteristics of Moving Image', '', NULL); |
1224 |
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 |
1225 |
('', '', '345', '0', 0, 0, 'Authority record control number or standard number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1226 |
('', '', '345', '2', 0, 0, 'Source', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1227 |
('', '', '345', '3', 0, 0, 'Materials specified', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1228 |
('', '', '345', '6', 0, 0, 'Linkage', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1229 |
('', '', '345', '8', 0, 0, 'Field link and sequence number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1230 |
('', '', '345', 'a', 0, 0, 'Presentation format', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1231 |
('', '', '345', 'b', 0, 0, 'Projection speed', '', 3, -6, '', '', '', NULL, '', '', NULL); |
1232 |
|
1233 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1234 |
('', '346', '', 1, 'Video Characteristics', '', NULL); |
1235 |
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 |
1236 |
('', '', '346', '0', 0, 0, 'Authority record control number or standard number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1237 |
('', '', '346', '2', 0, 0, 'Source', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1238 |
('', '', '346', '3', 0, 0, 'Materials specified', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1239 |
('', '', '346', '6', 0, 0, 'Linkage', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1240 |
('', '', '346', '8', 0, 0, 'Field link and sequence number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1241 |
('', '', '346', 'a', 0, 0, 'Video format', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1242 |
('', '', '346', 'b', 0, 0, 'Broadcast standard', '', 3, -6, '', '', '', NULL, '', '', NULL); |
1243 |
|
1244 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1245 |
('', '347', '', 1, 'Digital File Characteristics', '', NULL); |
1246 |
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 |
1247 |
('', '', '347', '0', 0, 0, 'Authority record control number or standard number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1248 |
('', '', '347', '2', 0, 0, 'Source', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1249 |
('', '', '347', '3', 0, 0, 'Materials specified', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1250 |
('', '', '347', '6', 0, 0, 'Linkage', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1251 |
('', '', '347', '8', 0, 0, 'Field link and sequence number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1252 |
('', '', '347', 'a', 0, 0, 'File type', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1253 |
('', '', '347', 'b', 0, 0, 'Encoding format', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1254 |
('', '', '347', 'c', 0, 0, 'File size', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1255 |
('', '', '347', 'd', 0, 0, 'Resolution', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1256 |
('', '', '347', 'e', 0, 0, 'Regional encoding', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1257 |
('', '', '347', 'f', 0, 0, 'Encoded bitrate', '', 3, -6, '', '', '', NULL, '', '', NULL); |
1258 |
|
1259 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1260 |
('', '348', '', 1, 'Format of Notated Music', '', NULL); |
1261 |
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 |
1262 |
('', '', '348', '0', 0, 0, 'Authority record control number or standard number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1263 |
('', '', '348', '2', 0, 0, 'Source', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1264 |
('', '', '348', '3', 0, 0, 'Materials specified', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1265 |
('', '', '348', '6', 0, 0, 'Linkage', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1266 |
('', '', '348', '8', 0, 0, 'Field link and sequence number', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1267 |
('', '', '348', 'a', 0, 0, 'Format of notated music term', '', 3, -6, '', '', '', NULL, '', '', NULL), |
1268 |
('', '', '348', 'b', 0, 0, 'Format of notated music code', '', 3, -6, '', '', '', NULL, '', '', NULL); |
1269 |
|
1270 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1133 |
('', '350', '', 1, 'Ціна (застаріле)', '', NULL); |
1271 |
('', '350', '', 1, 'Ціна (застаріле)', '', NULL); |
1134 |
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 |
1272 |
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 |
1135 |
('', NULL, '350', '6', 0, 0, 'Елемент зв’язку', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1273 |
('', NULL, '350', '6', 0, 0, 'Елемент зв’язку', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
Lines 1199-1204
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
1199 |
('', NULL, '362', 'z', 0, 0, 'Джерело відомостей', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL); |
1337 |
('', NULL, '362', 'z', 0, 0, 'Джерело відомостей', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL); |
1200 |
|
1338 |
|
1201 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1339 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
1340 |
('', '363', '', 1, 'Normalized Date and Sequential Designation', '', ''); |
1341 |
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 |
1342 |
('', NULL, '363', '6', 0, 0, 'Linkage', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1343 |
('', NULL, '363', '8', 0, 0, 'Field link and sequence number', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1344 |
('', NULL, '363', 'a', 0, 0, 'First level of enumeration', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1345 |
('', NULL, '363', 'b', 0, 0, 'Second level of enumeration', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1346 |
('', NULL, '363', 'c', 0, 0, 'Third level of enumeration', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1347 |
('', NULL, '363', 'd', 0, 0, 'Fourth level of enumeration', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1348 |
('', NULL, '363', 'e', 0, 0, 'Fifth level of enumeration', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1349 |
('', NULL, '363', 'f', 0, 0, 'Sixth level of enumeration', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1350 |
('', NULL, '363', 'g', 0, 0, 'Alternative numbering scheme, first level of enumeration', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1351 |
('', NULL, '363', 'h', 0, 0, 'Alternative numbering scheme, second level of enumeration', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1352 |
('', NULL, '363', 'i', 0, 0, 'First level of chronology', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1353 |
('', NULL, '363', 'j', 0, 0, 'Second level of chronology', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1354 |
('', NULL, '363', 'k', 0, 0, 'Third level of chronology', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1355 |
('', NULL, '363', 'l', 0, 0, 'Fourth level of chronology', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1356 |
('', NULL, '363', 'm', 0, 0, 'Alternative numbering scheme, chronology', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1357 |
('', NULL, '363', 'u', 0, 0, 'First level textual designation', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1358 |
('', NULL, '363', 'v', 0, 0, 'First level of chronology, issuance', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1359 |
('', NULL, '363', 'x', 0, 0, 'Nonpublic note', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL), |
1360 |
('', NULL, '363', 'z', 0, 0, 'Public note', '', 3, -6, NULL, NULL, '', NULL, '', '', NULL); |
1361 |
|
1362 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1202 |
('', '365', '', 1, 'Торговельна ціна', '', NULL); |
1363 |
('', '365', '', 1, 'Торговельна ціна', '', NULL); |
1203 |
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 |
1364 |
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 |
1204 |
('', '', '365', '2', 0, 0, 'Source of price type code', 'Source of price type code', 3, -1, '', '', '', NULL, '', '', NULL), |
1365 |
('', '', '365', '2', 0, 0, 'Source of price type code', 'Source of price type code', 3, -1, '', '', '', NULL, '', '', NULL), |
Lines 1235-1240
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
1235 |
('', '', '366', 'm', 0, 0, 'Identification of agency', 'Identification of agency', 3, -1, '', '', '', NULL, '', '', NULL); |
1396 |
('', '', '366', 'm', 0, 0, 'Identification of agency', 'Identification of agency', 3, -1, '', '', '', NULL, '', '', NULL); |
1236 |
|
1397 |
|
1237 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1398 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
1399 |
('', '370', '', 1, 'Associated Place', '', NULL); |
1400 |
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 |
1401 |
('', '', '370', '0', 0, 0, 'Authority record control number or standard number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1402 |
('', '', '370', '2', 0, 0, 'Source of term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1403 |
('', '', '370', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1404 |
('', '', '370', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1405 |
('', '', '370', 'c', 0, 0, 'Associated country', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1406 |
('', '', '370', 'f', 0, 0, 'Other associated place', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1407 |
('', '', '370', 'g', 0, 0, 'Place of origin of work', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1408 |
('', '', '370', 's', 0, 0, 'Start period', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1409 |
('', '', '370', 't', 0, 0, 'End period', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1410 |
('', '', '370', 'u', 0, 0, 'Uniform Resource Identifier', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1411 |
('', '', '370', 'v', 0, 0, 'Source of information', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1412 |
|
1413 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1414 |
('', '377', '', 1, 'Associated Language', '', NULL); |
1415 |
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 |
1416 |
('', '', '377', '0', 0, 0, 'Authority record control number or standard number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1417 |
('', '', '377', '2', 0, 0, 'Source', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1418 |
('', '', '377', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1419 |
('', '', '377', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1420 |
('', '', '377', 'a', 0, 0, 'Language code', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1421 |
('', '', '377', 'l', 0, 0, 'Language term', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1422 |
|
1423 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1424 |
('', '380', '', 1, 'Form of Work', '', NULL); |
1425 |
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 |
1426 |
('', '', '380', '0', 0, 0, 'Record control number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1427 |
('', '', '380', '2', 0, 0, 'Source of term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1428 |
('', '', '380', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1429 |
('', '', '380', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1430 |
('', '', '380', 'a', 0, 0, 'Form of work', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1431 |
|
1432 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1433 |
('', '381', '', 1, 'Other Distinguishing Characteristics of Work or Expression', '', NULL); |
1434 |
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 |
1435 |
('', '', '381', '0', 0, 0, 'Record control number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1436 |
('', '', '381', '2', 0, 0, 'Source of term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1437 |
('', '', '381', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1438 |
('', '', '381', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1439 |
('', '', '381', 'a', 0, 0, 'Other distinguishing characteristic', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1440 |
('', '', '381', 'u', 0, 0, 'Uniform Resource Identifier', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1441 |
('', '', '381', 'v', 0, 0, 'Source of information', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1442 |
|
1443 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1444 |
('', '382', '', 1, 'Medium of Performance', '', NULL); |
1445 |
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 |
1446 |
('', '', '382', '0', 0, 0, 'Authority record control number or standard number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1447 |
('', '', '382', '2', 0, 0, 'Source of term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1448 |
('', '', '382', '3', 0, 0, 'Materials specified', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1449 |
('', '', '382', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1450 |
('', '', '382', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1451 |
('', '', '382', 'a', 0, 0, 'Medium of performance', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1452 |
('', '', '382', 'b', 0, 0, 'Soloist', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1453 |
('', '', '382', 'd', 0, 0, 'Doubling instrument', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1454 |
('', '', '382', 'e', 0, 0, 'Number of ensembles of the same type', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1455 |
('', '', '382', 'n', 0, 0, 'Number of performers of the same medium', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1456 |
('', '', '382', 'p', 0, 0, 'Alternative medium of performance', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1457 |
('', '', '382', 'r', 0, 0, 'Total number of individuals performing alongside ensembles', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1458 |
('', '', '382', 's', 0, 0, 'Total number of performers', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1459 |
('', '', '382', 't', 0, 0, 'Total number of ensembles', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1460 |
('', '', '382', 'v', 0, 0, 'Note', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1461 |
|
1462 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1463 |
('', '383', '', 1, 'Numeric Designation of Musical Work', '', NULL); |
1464 |
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 |
1465 |
('', '', '383', '2', 0, 0, 'Source', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1466 |
('', '', '383', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1467 |
('', '', '383', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1468 |
('', '', '383', 'a', 0, 0, 'Serial number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1469 |
('', '', '383', 'b', 0, 0, 'Opus number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1470 |
('', '', '383', 'c', 0, 0, 'Thematic index number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1471 |
('', '', '383', 'd', 0, 0, 'Thematic index code', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1472 |
('', '', '383', 'e', 0, 0, 'Publisher associated with opus number', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1473 |
|
1474 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1475 |
('', '384', '', 1, 'Key', '', NULL); |
1476 |
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 |
1477 |
('', '', '384', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1478 |
('', '', '384', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1479 |
('', '', '384', 'a', 0, 0, 'Key', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1480 |
|
1481 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1482 |
('', '385', '', 1, 'Audience Characteristics', '', NULL); |
1483 |
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 |
1484 |
('', '', '385', '0', 0, 0, 'Authority record control number or standard number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1485 |
('', '', '385', '2', 0, 0, 'Source', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1486 |
('', '', '385', '3', 0, 0, 'Materials specified', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1487 |
('', '', '385', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1488 |
('', '', '385', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1489 |
('', '', '385', 'a', 0, 0, 'Audience term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1490 |
('', '', '385', 'b', 0, 0, 'Audience code', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1491 |
('', '', '385', 'm', 0, 0, 'Demographic group term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1492 |
('', '', '385', 'n', 0, 0, 'Demographic group code', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1493 |
|
1494 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1495 |
('', '386', '', 1, 'Creator/Contributor Characteristics', '', NULL); |
1496 |
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 |
1497 |
('', '', '386', '0', 0, 0, 'Authority record control number or standard number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1498 |
('', '', '386', '2', 0, 0, 'Source', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1499 |
('', '', '386', '3', 0, 0, 'Materials specified', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1500 |
('', '', '386', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1501 |
('', '', '386', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1502 |
('', '', '386', 'a', 0, 0, 'Creator/contributor term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1503 |
('', '', '386', 'b', 0, 0, 'Creator/contributor code', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1504 |
('', '', '386', 'm', 0, 0, 'Demographic group term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1505 |
('', '', '386', 'n', 0, 0, 'Demographic group code', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1506 |
|
1507 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1508 |
('', '388', '', 1, 'Time Period of Creation', '', NULL); |
1509 |
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 |
1510 |
('', '', '388', '0', 0, 0, 'Authority record control number or standard number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1511 |
('', '', '388', '2', 0, 0, 'Source of term', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1512 |
('', '', '388', '3', 0, 0, 'Materials specified', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1513 |
('', '', '388', '6', 0, 0, 'Linkage', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1514 |
('', '', '388', '8', 0, 0, 'Field link and sequence number', '', 3, -1, '', '', '', NULL, '', '', NULL), |
1515 |
('', '', '388', 'a', 0, 0, 'Time period of creation term', '', 3, -1, '', '', '', NULL, '', '', NULL); |
1516 |
|
1517 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1238 |
('', '400', '', 1, 'Область серії / додаткова пошукова ознака — індивідуальне ім’я (застаріле, CAN/MARC), (локальне, США)', '', NULL); |
1518 |
('', '400', '', 1, 'Область серії / додаткова пошукова ознака — індивідуальне ім’я (застаріле, CAN/MARC), (локальне, США)', '', NULL); |
1239 |
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 |
1519 |
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 |
1240 |
('', '', '400', '4', 0, 1, 'Код відношення', '', 4, -6, '', '', '', 0, '', '', NULL), |
1520 |
('', '', '400', '4', 0, 1, 'Код відношення', '', 4, -6, '', '', '', 0, '', '', NULL), |
Lines 1686-1691
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
1686 |
('', '', '541', 'o', 0, 1, 'Назва одиниці вимірювання', '', 5, 1, '', '', '', NULL, '', '', NULL); |
1966 |
('', '', '541', 'o', 0, 1, 'Назва одиниці вимірювання', '', 5, 1, '', '', '', NULL, '', '', NULL); |
1687 |
|
1967 |
|
1688 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1968 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
1969 |
('', '542', '', 1, 'Information Relating to Copyright Status', '', ''); |
1970 |
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 |
1971 |
('', '', '542', 'a', 0, 0, 'Personal creator', '', 5, -6, NULL, NULL, '', NULL, '', '', NULL), |
1972 |
('', '', '542', 'b', 0, 0, 'Personal creator death date', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1973 |
('', '', '542', 'c', 0, 0, 'Corporate creator', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1974 |
('', '', '542', 'd', 0, 0, 'Copyright holder', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1975 |
('', '', '542', 'e', 0, 0, 'Copyright holder contact information', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1976 |
('', '', '542', 'f', 0, 0, 'Copyright statement', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1977 |
('', '', '542', 'g', 0, 0, 'Copyright date', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1978 |
('', '', '542', 'h', 0, 0, 'Copyright renewal date', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1979 |
('', '', '542', 'i', 0, 0, 'Publication date', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1980 |
('', '', '542', 'j', 0, 0, 'Creation date', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1981 |
('', '', '542', 'k', 0, 0, 'Publisher', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1982 |
('', '', '542', 'l', 0, 0, 'Copyright status', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1983 |
('', '', '542', 'm', 0, 0, 'Publication status', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1984 |
('', '', '542', 'n', 0, 0, 'Note', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1985 |
('', '', '542', 'o', 0, 0, 'Research date', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1986 |
('', '', '542', 'p', 0, 0, 'Country of publication or creation', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1987 |
('', '', '542', 'q', 0, 0, 'Supplying agency', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1988 |
('', '', '542', 'r', 0, 0, 'Jurisdiction of copyright assessment', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1989 |
('', '', '542', 's', 0, 0, 'Source of information', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1990 |
('', '', '542', 'u', 0, 0, 'Uniform Resource Identifier', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1991 |
('', '', '542', '3', 0, 0, 'Materials specified', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1992 |
('', '', '542', '6', 0, 0, 'Linkage', '', 5, -6, '', '', '', NULL, '', '', NULL), |
1993 |
('', '', '542', '8', 0, 0, 'Field link and sequence number', '', 5, -6, '', '', '', NULL, '', '', NULL); |
1994 |
|
1995 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1689 |
('', '543', '', 1, 'Примітка про супровідну інформацію (застаріле)', '', NULL); |
1996 |
('', '543', '', 1, 'Примітка про супровідну інформацію (застаріле)', '', NULL); |
1690 |
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 |
1997 |
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 |
1691 |
('', NULL, '543', '6', 0, 0, 'Елемент зв’язку', '', 5, -6, NULL, NULL, '', NULL, '', '', NULL), |
1998 |
('', NULL, '543', '6', 0, 0, 'Елемент зв’язку', '', 5, -6, NULL, NULL, '', NULL, '', '', NULL), |
Lines 1918-1923
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
1918 |
('', '', '586', 'a', 0, 0, 'Примітка про нагороди', '', 5, -1, NULL, NULL, '', NULL, '', '', NULL); |
2225 |
('', '', '586', 'a', 0, 0, 'Примітка про нагороди', '', 5, -1, NULL, NULL, '', NULL, '', '', NULL); |
1919 |
|
2226 |
|
1920 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
2227 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
2228 |
('', '588', '', 1, 'Source of Description Note', '', NULL); |
2229 |
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 |
2230 |
('', '', '588', '5', 0, 0, 'Institution to which field applies', '', 5, -6, NULL, NULL, '', NULL, '', '', NULL), |
2231 |
('', '', '588', '6', 0, 0, 'Linkage', '', 5, -6, NULL, NULL, '', NULL, '', '', NULL), |
2232 |
('', '', '588', '8', 0, 1, 'Field link and sequence number', '', 5, -6, NULL, NULL, '', NULL, '', '', NULL), |
2233 |
('', '', '588', 'a', 0, 0, 'Source of description note', '', 5, -1, NULL, NULL, '', NULL, '', '', NULL); |
2234 |
|
2235 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
1921 |
('', '590', '', 1, 'Примітка про автограф і колекцію', '', NULL); |
2236 |
('', '590', '', 1, 'Примітка про автограф і колекцію', '', NULL); |
1922 |
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 |
2237 |
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 |
1923 |
('', '', '590', '6', 0, 0, 'Елемент зв’язку (RLIN)', '', 5, -6, NULL, NULL, '', NULL, '', '', NULL), |
2238 |
('', '', '590', '6', 0, 0, 'Елемент зв’язку (RLIN)', '', 5, -6, NULL, NULL, '', NULL, '', '', NULL), |
Lines 2050-2055
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
2050 |
('', '', '630', 'z', 0, 1, 'Географічне ділення', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL); |
2365 |
('', '', '630', 'z', 0, 1, 'Географічне ділення', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL); |
2051 |
|
2366 |
|
2052 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
2367 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
2368 |
('', '647', '', 1, 'Subject Added Entry-Named Event', '', ''); |
2369 |
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 |
2370 |
('', '', '647', '0', 0, 0, 'Authority record control number or standard number', '', 6, -1, NULL, NULL, '', NULL, '', '', NULL), |
2371 |
('', '', '647', '2', 0, 0, 'Source of heading or term', '', 6, -1, NULL, NULL, '', NULL, '', '', NULL), |
2372 |
('', '', '647', '3', 0, 0, 'Materials specified', '', 6, -6, NULL, NULL, '', NULL, '', '', NULL), |
2373 |
('', '', '647', '6', 0, 0, 'Linkage', '', 6, -6, NULL, NULL, '', NULL, '', '', NULL), |
2374 |
('', '', '647', '8', 0, 1, 'Field link and sequence number', '', 6, -6, NULL, NULL, '', NULL, '', '', NULL), |
2375 |
('', '', '647', 'a', 0, 0, 'Named event', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL), |
2376 |
('', '', '647', 'c', 0, 0, 'Location of named event', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL), |
2377 |
('', '', '647', 'd', 0, 1, 'Date of named event', '', 6, -6, NULL, NULL, '', NULL, '', '', NULL), |
2378 |
('', '', '647', 'g', 0, 0, 'Miscellaneous information', '', 6, -6, NULL, NULL, '', NULL, '', '', NULL), |
2379 |
('', '', '647', 'v', 0, 1, 'Form subdivision', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL), |
2380 |
('', '', '647', 'x', 0, 1, 'General subdivision', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL), |
2381 |
('', '', '647', 'y', 0, 1, 'Chronological subdivision', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL), |
2382 |
('', '', '647', 'z', 0, 1, 'Geographic subdivision', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL); |
2383 |
|
2384 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
2053 |
('', '648', '', 1, 'Хронологічне поняття як додаткова предметна пошукова ознака', '', ''); |
2385 |
('', '648', '', 1, 'Хронологічне поняття як додаткова предметна пошукова ознака', '', ''); |
2054 |
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 |
2386 |
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 |
2055 |
('', '', '648', '2', 0, 0, 'Джерело рубрики чи терміну', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL), |
2387 |
('', '', '648', '2', 0, 0, 'Джерело рубрики чи терміну', '', 6, 0, NULL, NULL, '', NULL, '', '', NULL), |
Lines 2070-2076
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
2070 |
('', '', '650', '4', 0, 1, 'Код відношення', '', 6, -6, NULL, NULL, '', NULL, '', '', NULL), |
2402 |
('', '', '650', '4', 0, 1, 'Код відношення', '', 6, -6, NULL, NULL, '', NULL, '', '', NULL), |
2071 |
('', '', '650', '6', 0, 0, 'Елемент зв’язку', '', 6, -6, '', '', '', 0, '', '', NULL), |
2403 |
('', '', '650', '6', 0, 0, 'Елемент зв’язку', '', 6, -6, '', '', '', 0, '', '', NULL), |
2072 |
('', '', '650', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 6, -6, '', '', '', 0, '', '', NULL), |
2404 |
('', '', '650', '8', 0, 1, 'Зв’язок полів і номер послідовності', '', 6, -6, '', '', '', 0, '', '', NULL), |
2073 |
('', 'TOPIC_TERM', '650', 'a', 0, 0, 'Основна рубрика', '', 6, 0, 'bibliosubject.subject', '', '', 0, '\'6003\',\'600a\',\'600b\',\'600c\',\'600d\',\'600e\',\'600f\',\'600g\',\'600h\',\'600k\',\'600l\',\'600m\',\'600n\',\'600o\',\'600p\',\'600r\',\'600s\',\'600t\',\'600u\',\'600x\',\'600z\',\'600y\',\'600v\',\'6103\',\'610a\',\'610b\',\'610c\',\'610d\',\'610e\',\'610f\',\'610g\',\'610h\',\'610k\',\'610l\',\'610m\',\'610n\',\'610o\',\'610p\',\'610r\',\'610s\',\'610t\',\'610u\',\'610x\',\'610z\',\'610y\',\'610v\',\'6113\',\'611a\',\'611b\',\'611c\',\'611d\',\'611e\',\'611f\',\'611g\',\'611h\',\'611k\',\'611l\',\'611m\',\'611n\',\'611o\',\'611p\',\'611r\',\'611s\',\'611t\',\'611u\',\'611x\',\'611z\',\'611y\',\'611v\',\'630a\',\'630b\',\'630c\',\'630d\',\'630e\',\'630f\',\'630g\',\'630h\',\'630k\',\'630l\',\'630m\',\'630n\',\'630o\',\'630p\',\'630r\',\'630s\',\'630t\',\'630x\',\'630z\',\'630y\',\'630v\',\'6483\',\'648a\',\'648x\',\'648z\',\'648y\',\'648v\',\'6503\',\'650b\',\'650c\',\'650d\',\'650e\',\'650x\',\'650z\',\'650y\',\'650v\',\'6513\',\'651a\',\'651b\',\'651c\',\'651d\',\'651e\',\'651x\',\'651z\',\'651y\',\'651v\',\'653a\',\'6543\',\'654a\',\'654b\',\'654x\',\'654z\',\'654y\',\'654v\',\'6553\',\'655a\',\'655b\',\'655x\',\'655z\',\'655y\',\'655v\',\'6563\',\'656a\',\'656k\',\'656x\',\'656z\',\'656y\',\'656v\',\'6573\',\'657a\',\'657x\',\'657z\',\'657y\',\'657v\',\'658a\',\'658b\',\'658c\',\'658d\',\'658v\'', '', NULL), |
2405 |
('', 'TOPIC_TERM', '650', 'a', 0, 0, 'Основна рубрика', '', 6, 0, 'bibliosubject.subject', '', '', 0, '\'6003\',\'600a\',\'600b\',\'600c\',\'600d\',\'600e\',\'600f\',\'600g\',\'600h\',\'600k\',\'600l\',\'600m\',\'600n\',\'600o\', |
|
|
2406 |
\'600p\',\'600r\',\'600s\',\'600t\',\'600u\',\'600x\',\'600z\',\'600y\',\'600v\',\'6103\',\'610a\',\'610b\',\'610c\',\'610d\',\'610e\',\'610f\',\'610g\',\'610h\',\'610k\',\'610l\',\'610m\',\'610n\',\'610o\',\'610p\',\'610r\',\'610s\',\'610t\', |
2407 |
\'610u\',\'610x\',\'610z\',\'610y\',\'610v\',\'6113\',\'611a\',\'611b\',\'611c\',\'611d\',\'611e\',\'611f\',\'611g\',\'611h\',\'611k\',\'611l\',\'611m\',\'611n\',\'611o\',\'611p\',\'611r\',\'611s\',\'611t\',\'611u\',\'611x\',\'611z\',\'611y\', |
2408 |
\'611v\',\'630a\',\'630b\',\'630c\',\'630d\',\'630e\',\'630f\',\'630g\',\'630h\',\'630k\',\'630l\',\'630m\',\'630n\',\'630o\',\'630p\',\'630r\',\'630s\',\'630t\',\'630x\',\'630z\',\'630y\',\'630v\',\'6483\',\'648a\',\'648x\',\'648z\',\'648y\', |
2409 |
\'648v\',\'6503\',\'650b\',\'650c\',\'650d\',\'650e\',\'650x\',\'650z\',\'650y\',\'650v\',\'6513\',\'651a\',\'651b\',\'651c\',\'651d\',\'651e\',\'651x\',\'651z\',\'651y\',\'651v\',\'653a\',\'6543\',\'654a\',\'654b\',\'654x\',\'654z\',\'654y\', |
2410 |
\'654v\',\'6553\',\'655a\',\'655b\',\'655x\',\'655z\',\'655y\',\'655v\',\'6563\',\'656a\',\'656k\',\'656x\',\'656z\',\'656y\',\'656v\',\'6573\',\'657a\',\'657x\',\'657z\',\'657y\',\'657v\',\'658a\',\'658b\',\'658c\',\'658d\',\'658v\'', '', NULL), |
2074 |
('', '', '650', 'b', 0, 0, 'Ін. геогр. рубрика', '', 6, -1, '', '', '', 0, '', '', NULL), |
2411 |
('', '', '650', 'b', 0, 0, 'Ін. геогр. рубрика', '', 6, -1, '', '', '', 0, '', '', NULL), |
2075 |
('', '', '650', 'c', 0, 0, 'Місце події', '', 6, -1, '', '', '', 0, '', '', NULL), |
2412 |
('', '', '650', 'c', 0, 0, 'Місце події', '', 6, -1, '', '', '', 0, '', '', NULL), |
2076 |
('', '', '650', 'd', 0, 0, 'Дати події', '', 6, -1, '', '', '', 0, '', '', NULL), |
2413 |
('', '', '650', 'd', 0, 0, 'Дати події', '', 6, -1, '', '', '', 0, '', '', NULL), |
Lines 2523-2528
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
2523 |
('', '', '740', 'p', 0, 1, 'Заголовок частини/розділу твору', '', 7, -6, '', '', '', NULL, '', '', NULL); |
2860 |
('', '', '740', 'p', 0, 1, 'Заголовок частини/розділу твору', '', 7, -6, '', '', '', NULL, '', '', NULL); |
2524 |
|
2861 |
|
2525 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
2862 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
2863 |
('', '751', '', 1, 'Added Entry-Geographic Name', '', NULL); |
2864 |
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 |
2865 |
('', '', '751', '0', 0, 0, 'Authority record control number', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2866 |
('', '', '751', '2', 0, 0, 'Source of heading or term', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2867 |
('', '', '751', '3', 0, 0, 'Materials specified', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2868 |
('', '', '751', '4', 0, 0, 'Relator code', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2869 |
('', '', '751', '6', 0, 0, 'Linkage', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2870 |
('', '', '751', '8', 0, 0, 'Field link and sequence number', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2871 |
('', '', '751', 'a', 0, 0, 'Geographic name', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2872 |
('', '', '751', 'e', 0, 0, 'Relator term', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL); |
2873 |
|
2874 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
2526 |
('', '752', '', 1, 'Додаткове введення — ієрархічна назва місця', '', NULL); |
2875 |
('', '752', '', 1, 'Додаткове введення — ієрархічна назва місця', '', NULL); |
2527 |
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 |
2876 |
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 |
2528 |
('', '', '752', '2', 0, 0, 'Джерело рубрики або терміну', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2877 |
('', '', '752', '2', 0, 0, 'Джерело рубрики або терміну', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
Lines 2674-2680
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable,
Link Here
|
2674 |
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 |
3023 |
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 |
2675 |
('', '', '770', '6', 0, 0, 'Елемент зв’язку', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
3024 |
('', '', '770', '6', 0, 0, 'Елемент зв’язку', '', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2676 |
('', '', '770', '7', 0, 0, 'Control subfield', 'Control subfield', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
3025 |
('', '', '770', '7', 0, 0, 'Control subfield', 'Control subfield', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2677 |
('', '', '770', '8', 0, 1, 'Field link and sequence number', 'Field link and sequence number ', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
3026 |
('', '', '770', '8', 0, 1, 'Field link and sequence number', 'Field link and sequence number', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2678 |
('', '', '770', 'a', 0, 0, 'Main entry heading', 'Main entry heading', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
3027 |
('', '', '770', 'a', 0, 0, 'Main entry heading', 'Main entry heading', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2679 |
('', '', '770', 'b', 0, 0, 'Edition', 'Edition', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
3028 |
('', '', '770', 'b', 0, 0, 'Edition', 'Edition', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
2680 |
('', '', '770', 'c', 0, 0, 'Qualifying information', 'Qualifying information', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
3029 |
('', '', '770', 'c', 0, 0, 'Qualifying information', 'Qualifying information', 7, -6, NULL, NULL, '', NULL, '', '', NULL), |
Lines 3680-3685
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
3680 |
('', '', '880', 'z', 0, 1, 'z', 'z', 8, -6, '', '', '', NULL, '', '', NULL); |
4029 |
('', '', '880', 'z', 0, 1, 'z', 'z', 8, -6, '', '', '', NULL, '', '', NULL); |
3681 |
|
4030 |
|
3682 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
4031 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
|
|
4032 |
('', '882', '', 1, 'Replacement Record Information', '', NULL); |
4033 |
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 |
4034 |
('', '', '882', '6', 0, 0, 'Linkage', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4035 |
('', '', '882', '8', 0, 0, 'Field link and sequence number', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4036 |
('', '', '882', 'a', 0, 0, 'Replacement title', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4037 |
('', '', '882', 'i', 0, 0, 'Explanatory text', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4038 |
('', '', '882', 'q', 0, 0, 'Replacement bibliographic record control number', '', 8, -6, '', '', '', NULL, '', '', NULL); |
4039 |
|
4040 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
4041 |
('', '883', '', 1, 'Machine-generated Metadata Provenance', '', NULL); |
4042 |
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 |
4043 |
('', '', '883', '0', 0, 0, 'Authority record control number or standard number', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4044 |
('', '', '883', '8', 0, 0, 'Field link and sequence number', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4045 |
('', '', '883', 'a', 0, 0, 'Generation process', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4046 |
('', '', '883', 'c', 0, 0, 'Confidence value', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4047 |
('', '', '883', 'd', 0, 0, 'Generation date', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4048 |
('', '', '883', 'q', 0, 0, 'Generation agency', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4049 |
('', '', '883', 'x', 0, 0, 'Validity end date', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4050 |
('', '', '883', 'u', 0, 0, 'Uniform Resource Identifier', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4051 |
('', '', '883', 'w', 0, 0, 'Bibliographic record control number', '', 8, -6, '', '', '', NULL, '', '', NULL); |
4052 |
|
4053 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
4054 |
('', '884', '', 1, 'Description Conversion Information', '', NULL); |
4055 |
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 |
4056 |
('', '', '884', 'a', 0, 0, 'Conversion process', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4057 |
('', '', '884', 'g', 0, 0, 'Conversion date', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4058 |
('', '', '884', 'k', 0, 0, 'Identifier of source metadata', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4059 |
('', '', '884', 'q', 0, 0, 'Conversion agency', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4060 |
('', '', '884', 'u', 0, 0, 'Uniform Resource Identifier', '', 8, -6, '', '', '', NULL, '', '', NULL); |
4061 |
|
4062 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
4063 |
('', '885', '', 1, 'Matching Information', '', NULL); |
4064 |
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 |
4065 |
('', '', '885', '0', 0, 0, 'Authority record control number or standard number', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4066 |
('', '', '885', '2', 0, 0, 'Source', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4067 |
('', '', '885', '5', 0, 0, 'Institution to which field applies', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4068 |
('', '', '885', 'a', 0, 0, 'Matching information', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4069 |
('', '', '885', 'b', 0, 0, 'Status of matching and its checking', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4070 |
('', '', '885', 'c', 0, 0, 'Confidence value', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4071 |
('', '', '885', 'd', 0, 0, 'Generation date', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4072 |
('', '', '885', 'w', 0, 0, 'Record control number', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4073 |
('', '', '885', 'x', 0, 0, 'Nonpublic note', '', 8, -6, '', '', '', NULL, '', '', NULL), |
4074 |
('', '', '885', 'z', 0, 0, 'Public note', '', 8, -6, '', '', '', NULL, '', '', NULL); |
4075 |
|
4076 |
INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES |
3683 |
('', '886', '', 1, 'Поле інформації про іноземний формат MARC', '', NULL); |
4077 |
('', '886', '', 1, 'Поле інформації про іноземний формат MARC', '', NULL); |
3684 |
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 |
4078 |
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 |
3685 |
('', '', '886', '0', 0, 1, 0, 0, 8, -6, '', '', '', NULL, '', '', NULL), |
4079 |
('', '', '886', '0', 0, 1, 0, 0, 8, -6, '', '', '', NULL, '', '', NULL), |
Lines 3786-3792
INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag
Link Here
|
3786 |
('', '', '898', '%', 0, 0, '% (RLIN)', '% (RLIN)', 8, -6, '', '', '', 0, '', '', NULL), |
4180 |
('', '', '898', '%', 0, 0, '% (RLIN)', '% (RLIN)', 8, -6, '', '', '', 0, '', '', NULL), |
3787 |
('', NULL, '898', '4', 0, 1, 'Код відношення', '', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
4181 |
('', NULL, '898', '4', 0, 1, 'Код відношення', '', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
3788 |
('', NULL, '898', '6', 0, 0, 'Елемент зв’язку', '', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
4182 |
('', NULL, '898', '6', 0, 0, 'Елемент зв’язку', '', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
3789 |
('', NULL, '898', '8', 0, 1, 'Field link and sequence number ', 'Field link and sequence number ', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
4183 |
('', NULL, '898', '8', 0, 1, 'Field link and sequence number', 'Field link and sequence number', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
3790 |
('', 'MEETI_NAME', '898', 'a', 0, 0, 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
4184 |
('', 'MEETI_NAME', '898', 'a', 0, 0, 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
3791 |
('', NULL, '898', 'b', 0, 0, 'Number (BK CF MP MU SE VM MX) [OBSOLETE]', 'Number (BK CF MP MU SE VM MX) [OBSOLETE]', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
4185 |
('', NULL, '898', 'b', 0, 0, 'Number (BK CF MP MU SE VM MX) [OBSOLETE]', 'Number (BK CF MP MU SE VM MX) [OBSOLETE]', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
3792 |
('', NULL, '898', 'c', 0, 0, 'Location of meeting', 'Location of meeting', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |
4186 |
('', NULL, '898', 'c', 0, 0, 'Location of meeting', 'Location of meeting', 8, -6, NULL, NULL, '', NULL, '', '', NULL), |