-- *************************************************************
-SET FOREIGN_KEY_CHECKS = 0;
-- ******************************************************
-- Current Record ID Field/Subfields
-DELETE FROM `marc_tag_structure`;
-DELETE FROM `marc_subfield_structure`;
-
INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', '');
INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
('942', '0', 'Koha issues (borrowed), all copies', 'Koha issues (borrowed), all copies', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, -5, '', '', '', NULL),
- ('942', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'biblioitems.cn_source', 9, '', '', '', NULL, 0, '', '', '', NULL),
+ ('942', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'biblioitems.cn_source', 9, 'cn_source', '', '', NULL, 0, '', '', '', NULL),
('942', '6', 'Koha normalized classification for sorting', 'Koha normalized classification for sorting', 0, 0, 'biblioitems.cn_sort', -1, '', '', '', 0, 7, '', '', '', NULL),
('942', 'a', 'Institution code [OBSOLETE]', 'Institution code [OBSOLETE]', 0, 0, '', 9, '', '', '', NULL, -5, '', '', '', NULL),
- ('942', 'c', 'Koha item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 0, '', '', '', NULL),
+ ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 0, '', '', '', NULL),
('942', 'e', 'Edition', 'Edition', 0, 0, 'biblioitems.cn_edition', 9, 'CN_EDITION', '', '', NULL, 0, '', '', '', NULL),
('942', 'h', 'Classification part', 'Classification part', 0, 0, 'biblioitems.cn_class', 9, '', '', '', NULL, 0, '', '', '', NULL),
- ('942', 'i', 'Item part', 'Item part', 1, 0, 'biblioitems.cn_item', 9, '', '', '', NULL, 9, '', '', '', NULL),
+ ('942', 'i', 'Item part', 'Item part', 1, 0, 'biblioitems.cn_item', 9, '', '', '', NULL, 0, '', '', '', NULL),
('942', 'k', 'Call number prefix', 'Call number prefix', 0, 0, 'biblioitems.cn_prefix', 9, '', '', '', NULL, 0, '', '', '', NULL),
- ('942', 'm', 'Call number suffix', 'Call number suffix', 0, 0, 'biblioitems.cn_suffix', 9, '', '', '', 0, 0, '', '', '', NULL);
+ ('942', 'm', 'Call number suffix', 'Call number suffix', 0, 0, 'biblioitems.cn_suffix', 9, '', '', '', 0, 0, '', '', '', NULL),
+ ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 0, '', '', '', NULL),
+ ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, -5, '', '', '', NULL);
-- ******************************************************
('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');
INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES
- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
- ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, '', '', '', NULL),
+ ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL),
('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),
('952', '4', 'Damaged status', 'Damaged status', 0, 0, 'items.damaged', 10, 'DAMAGED', '', '', NULL, 0, '', '', '', NULL),
('952', '5', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),
('952', '9', 'Koha itemnumber (autogenerated)', 'Koha itemnumber', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 7, '', '', '', NULL),
('952', 'a', 'Location (home branch)', 'Location (home branch)', 0, 0, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL),
('952', 'b', 'Sublocation or collection (holding branch)', 'Sublocation or collection (holding branch)', 0, 0, 'items.holdingbranch', 10, 'branches', '', '', 0, 0, '', '', '', NULL),
- ('952', 'c', 'Shelving location', 'Shelving location', 0, 0, 'items.location', 10, 'SHELF_LOC', '', '', 0, 0, '', '', '', NULL),
+ ('952', 'c', 'Shelving location', 'Shelving location', 0, 0, 'items.location', 10, 'LOC', '', '', 0, 0, '', '', '', NULL),
('952', 'd', 'Date acquired', 'Date acquired', 0, 0, 'items.dateaccessioned', 10, '', '', 'dateaccessioned.pl', 0, 0, '', '', '', NULL),
('952', 'e', 'Source of acquisition', 'Source of acquisition', 0, 0, 'items.booksellerid', 10, '', '', '', 0, 0, '', '', '', NULL),
('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, '', '', '', NULL),
('952', 'g', 'Cost, normal purchase price', 'Cost, normal purchase price', 0, 0, 'items.price', 10, '', '', '', 0, 0, '', '', '', NULL),
+ ('952', 'h', 'Serial Enumeration / chronology','Serial Enumeration / chronology', 0, 0, 'items.enumchron', 10, '', '', '', 0, 0, '', '', '', NULL),
('952', 'j', 'Shelving control number', 'Shelving control number', 0, 0, 'items.stack', 10, 'STACK', '', '', NULL, -1, '', '', '', NULL),
('952', 'l', 'Koha issues (times borrowed)', 'Koha issues (times borrowed)', 0, 0, 'items.issues', 10, '', '', '', NULL, -5, '', '', '', NULL),
('952', 'm', 'Koha renewals', 'Koha renewals', 0, 0, 'items.renewals', 10, '', '', '', NULL, -5, '', '', '', NULL),
('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL),
('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL),
('952', 'x', 'Nonpublic note (lost item payment)', 'Nonpublic note (lost item payment)', 1, 0, 'items.paidfor', 10, '', '', '', NULL, 7, '', '', '', NULL),
- ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, -1, '', '', '', NULL),
+ ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL),
('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL);
('263', 'PROJECTED PUBLICATION DATE', 'PROJECTED PUBLICATION DATE', 0, 0, NULL, ''),
('265', 'SOURCE FOR ACQUISITION/SUBSCRIPTION ADDRESS [OBSOLETE]', 'SOURCE FOR ACQUISITION/SUBSCRIPTION ADDRESS [OBSOLETE]', 0, 0, NULL, ''),
('270', 'ADDRESS', 'ADDRESS', 1, 0, NULL, ''),
- ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 1, NULL, ''),
+ ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, ''),
('301', 'PHYSICAL DESCRIPTION FOR FILMS (PRE-AACR 2) (VM) [OBSOLETE, USMARC]', 'PHYSICAL DESCRIPTION FOR FILMS (PRE-AACR 2) (VM) [OBSOLETE, USMARC]', 0, 0, NULL, ''),
('302', 'PAGE OR ITEM COUNT (BK AM) [OBSOLETE]', 'PAGE OR ITEM COUNT (BK AM) [OBSOLETE]', 0, 0, NULL, ''),
('303', 'UNIT COUNT (AM) [OBSOLETE, USMARC]', 'UNIT COUNT (AM) [OBSOLETE, USMARC]', 0, 0, NULL, ''),
('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, '', '', '', NULL),
- ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL),
('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, 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),
('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, '', '', '', NULL),
('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, '', '', '', NULL),
('110', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', NULL, 0, '', '', '', NULL),
('110', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
('110', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', NULL, -6, '', '', '', NULL),
- ('110', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('110', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL),
('110', 'a', 'Corporate name or jurisdiction name as entry element', 'Corporate name or jurisdiction name as entry element', 0, 0, '', 1, '', 'CORPO_NAME', '', NULL, 0, '', '', '', NULL),
('110', 'b', 'Subordinate unit', 'Subordinate unit', 1, 0, '', 1, '', '', '', NULL, 0, '', '', '', NULL),
('110', 'c', 'Location of meeting', 'Location of meeting', 0, 0, '', 1, '', '', '', NULL, -1, '', '', '', NULL),
('111', '4', 'Relator code', 'Relator code', 1, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
('111', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('111', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
- ('111', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('111', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL),
('111', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, NULL, 1, NULL, 'MEETI_NAME', '', NULL, 0, '', '', '', NULL),
('111', 'b', 'Number [OBSOLETE]', 'Number [OBSOLETE]', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('111', 'c', 'Location of meeting', 'Location of meeting', 0, 0, NULL, 1, NULL, NULL, '', NULL, 0, '', '', '', NULL),
('111', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('130', '6', 'Linkage', 'Linkage', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('130', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
- ('130', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('130', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, -5, '', '', '', NULL),
('130', 'a', 'Uniform title', 'Uniform title', 0, 0, NULL, 1, NULL, 'UNIF_TITLE', '', NULL, -1, '', '''130o'',''130m'',''130r'',''130s'',''130d'',''130k'',''130n'',''130p'',''130g'',''130l'',''130f'',''130h'',''130t''', '', NULL),
('130', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('130', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, 1, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('222', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, '', '', '', NULL),
('240', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
('240', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
- ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('240', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL),
('240', 'a', 'Uniform title', 'Uniform title', 0, 0, 'biblio.unititle', 2, '', '', '', 1, -1, '', '', '', NULL),
('240', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
('240', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
('242', 'y', 'Language code of translated title', 'Language code of translated title', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('243', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
('243', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
- ('243', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('243', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 2, '', '', '', 0, -5, '', '', '', NULL),
('243', 'a', 'Uniform title', 'Unifor title', 0, 0, '', 2, '', '', '', 1, -1, '', '', '', NULL),
('243', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
('243', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
('300', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
('300', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
('300', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
- ('300', 'a', 'Extent', 'Extent', 1, 1, 'biblioitems.pages', 3, '', '', '', NULL, 0, '', '', '', NULL),
+ ('300', 'a', 'Extent', 'Extent', 1, 0, 'biblioitems.pages', 3, '', '', '', NULL, 0, '', '', '', NULL),
('300', 'b', 'Other physical details', 'Other physical details', 0, 0, 'biblioitems.illus', 3, '', '', '', 0, 0, '', '', '', NULL),
('300', 'c', 'Dimensions', 'Dimensions', 1, 0, 'biblioitems.size', 3, '', '', '', NULL, 0, '', '', '', NULL),
('300', 'd', 'Accompanying material [OBSOLETE, CAN/MARC]', 'Accompanying material [OBSOLETE, CAN/MARC]', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL),
('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
- ('400', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('400', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL),
('400', 'a', 'Personal name', 'Personal name', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
('400', 'b', 'Numeration', 'Numeration', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
('400', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
('410', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
('410', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
('410', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
- ('410', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -6, '', '', '', NULL),
+ ('410', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -6, '', '', '', NULL),
('410', 'a', 'Corporate name or jurisdiction name as entry element', 'Corporate name or jurisdiction name as entry element', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
('410', 'b', 'Subordinate unit', 'Subordinate unit', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
('410', 'c', 'Location of meeting', 'Location of meeting', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
('411', '4', 'Relator code', 'Relator code', 1, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('411', '6', 'Linkage', 'Linkage', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('411', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL),
- ('411', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('411', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL),
('411', 'a', 'Meeting name or jurisdiction name as entry element', 'Meeting name or jurisdiction name as entry element', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('411', 'b', 'Number [OBSOLETE]', 'Number [OBSOLETE]', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('411', 'c', 'Location of meeting', 'Location of meeting', 0, 0, NULL, 4, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('411', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
('440', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
('440', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', NULL, -6, '', '', '', NULL),
- ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, '', '', '', NULL),
+ ('440', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 4, '', '', '', 0, -5, '', '', '', NULL),
('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', 4, '', 'UNIF_TITLE', '', NULL, 0, '', '''440n'',''440p'',''490a'',''830a'',''830n'',''830p'',''899a''', '', NULL),
('440', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblioitems.number', 4, '', '', '', NULL, 0, '', '', '', NULL),
('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 4, '', '', '', NULL, 0, '', '', '', NULL),
('760', '7', 'Control subfield', 'Control subfield', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('760', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('760', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
- ('760', 'b', 'Edition', 'Edition', 0, 0, NULL, -6, NULL, NULL, '', NULL, 0, '', '', '', NULL),
+ ('760', 'b', 'Edition', 'Edition', 0, 0, NULL, 7, NULL, NULL, '', NULL, 0, '', '', '', NULL),
('760', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('760', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('760', 'g', 'Relationship information', 'Relationship information', 1, 0, NULL, 7, NULL, NULL, '', NULL, -6, '', '', '', NULL),
('855', 'y', 'Regularity pattern', 'Regularity pattern', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
('855', 'z', 'Numbering scheme', 'Numbering scheme', 1, 0, '', 8, '', '', '', NULL, 5, '', '', '', NULL),
('856', '2', 'Access method', 'Access method', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
- ('856', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
+ ('856', '3', 'Materials specified', 'Materials specified', 0, 0, '', 8, '', '', '', 0, 0, '', '', '', NULL),
('856', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
('856', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', 0, -6, '', '', '', NULL),
('856', 'a', 'Host name', 'Host name', 1, 0, '', 8, '', '', '', 0, -1, '', '', '', NULL),