From 3417dfc84846b47ed9cbecb20fb8a4ce2abcf54d Mon Sep 17 00:00:00 2001 From: thd Date: Mon, 11 Sep 2006 02:58:03 +0000 Subject: [PATCH] Changed some hidden values for the record editor, shortened items labels, and added a link to the new barcode plugin. --- misc/marc21_standard_bib_framework.sql | 89 +++++++++++++------------- 1 file changed, 44 insertions(+), 45 deletions(-) diff --git a/misc/marc21_standard_bib_framework.sql b/misc/marc21_standard_bib_framework.sql index 32912a197c..3c908eb8e2 100755 --- a/misc/marc21_standard_bib_framework.sql +++ b/misc/marc21_standard_bib_framework.sql @@ -2,8 +2,8 @@ -- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK -- POST-INSTALLATION SCRIPT -- --- PRETEST VERSION 0.1.4 --- 2006-08-09 +-- PRETEST VERSION 0.1.8 +-- 2006-09-10 -- -- original default requiring greater user customisation -- created by a few Koha Hands @@ -243,7 +243,7 @@ INSERT INTO `marc_subfield_structure` VALUES ('942', 'l', 'Classification subcla -- INSERT INTO `marc_subfield_structure` VALUES ('95k', '4', 'Use restrictions (similar to 506 $a, 876-8 $h)', 'Use restrictions', 0, 0, 'items.restricted', 10, '', '', '', 0, 0, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', '6', 'Linkage (similar to 852, 876-8 $6)', 'Linkage', 0, 0, '', 10, '', '', '', NULL, -6, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', '8', 'Sequence number (similar to 852, 876-8 $8)', 'Sequence number', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); --- INSERT INTO `marc_subfield_structure` VALUES ('95k', '9', 'Koha itemnumber (autogenerated similar to 852, 876-8 $3 $8 $t combined)', 'Koha itemnumber', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, '', '', ''); +-- INSERT INTO `marc_subfield_structure` VALUES ('95k', '9', 'Koha itemnumber (autogenerated similar to 852, 876-8 $3 $8 $t combined)', 'Koha itemnumber', 0, 0, 'items.itemnumber', -1, '', '', '', 0, -5, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'a', 'Location (homebranch) (similar to 852 $a)', 'Location (homebranch)', 0, 0, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'b', 'Sublocation or collection (holdingbranch) (similar to 852 $b)', 'Sublocation or collection (holdingbranch)', 1, 0, 'items.holdingbranch', 10, 'branches', '', '', 0, 0, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'c', 'Shelving location (similar to 852 $c, 876-8 $l)', 'Shelving location', 1, 0, 'items.location', 10, '', '', '', 0, 0, '', '', ''); @@ -259,7 +259,7 @@ INSERT INTO `marc_subfield_structure` VALUES ('942', 'l', 'Classification subcla -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'm', 'Call number suffix (similar to 852 $m)', 'Call number suffix', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'n', 'Country code (similar to 852 $n)', 'Country code', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'o', 'Call number (similar to 852 $k $h $i $m combined)', 'Call number', 0, 0, 'items.itemcallnumber', 10, '', '', NULL, 0, 0, '', '', ''); --- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'p', 'Piece designation (barcode) (similar to 852, 876-8 $p)', 'Piece designation (barcode)', 0, 1, 'items.barcode', 10, '', '', '', 0, 0, '', '', ''); +-- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'p', 'Piece designation (barcode) (similar to 852, 876-8 $p)', 'Piece designation (barcode)', 0, 1, 'items.barcode', 10, '', '', 'barcode.pl', 0, 0, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'q', 'Piece physical condition (similar to 562 $a, 852 $q)', 'Piece physical condition', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 'r', 'Invalid or canceled piece designation (canceled barcode) (similar to 876-8 $r)', 'Invalid or canceled piece designation (canceled barcode)', 1, 0, '', 10, '', '', '', NULL, -1, '', '', ''); -- INSERT INTO `marc_subfield_structure` VALUES ('95k', 's', 'Copyright article-fee code (similar to 018 $a, 852 $s)', 'Copyright article-fee code', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); @@ -278,40 +278,40 @@ INSERT INTO `marc_subfield_structure` VALUES ('942', 'l', 'Classification subcla INSERT INTO `marc_tag_structure` VALUES ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '0', 'Item status (withdrawn) (similar to 876-8 $j)', 'Item status (withdrawn)', 0, 0, 'items.withdrawn', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '1', 'Item status (lost) (similar to 876-8 $j)', 'Item status (lost)', 0, 0, 'items.itemlost', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '2', 'Source of classification or shelving scheme (similar to 852 $2)', 'Source of classification or shelving scheme', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '3', 'Materials specified (similar to 852, 876-8 $3)', 'Materials specified', 0, 0, '', 10, '', '', '', NULL, -1, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '4', 'Use restrictions (similar to 506 $a, 876-8 $h)', 'Use restrictions', 0, 0, 'items.restricted', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '6', 'Linkage (similar to 852, 876-8 $6)', 'Linkage', 0, 0, '', 10, '', '', '', NULL, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '8', 'Sequence number (similar to 852, 876-8 $8)', 'Sequence number', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '9', 'Cost, normal purchase price (similar to 541 $h, 876-8 $c)', 'Cost, normal purchase price', 0, 0, 'items.price', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'a', 'Invalid or canceled piece designation (canceled barcode) (similar to 876-8 $r)', 'Invalid or canceled piece designation (canceled barcode)', 1, 0, '', 10, '', '', '', NULL, -1, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'b', 'Location (homebranch) (similar to 852 $a)', 'Location (homebranch)', 0, 0, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'c', 'Shelving location (similar to 852 $c, 876-8 $l)', 'Shelving location', 1, 0, 'items.location', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'd', 'Sublocation or collection (holdingbranch) (similar to 852 $b)', 'Sublocation or collection (holdingbranch)', 0, 0, 'items.holdingbranch', 10, 'branches', '', '', 0, 0, '', '''952b''', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'e', 'Source of acquisition (similar to 541 $a, 876-8 $e)', 'Source of acquisition', 1, 0, 'items.booksellerid', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'f', 'Coded location qualifier (similar to 852 $f)', 'Coded location qualifier', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'g', 'Non-coded location qualifier (similar to 852 $g)', 'Non-coded location qualifier', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'h', 'Classification part (similar to 852 $h)', 'Classification part', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'i', 'Item part (similar to 852 $i)', 'Item part', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'j', 'Shelving control number (similar to 852 $j)', 'Shelving control number', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'k', 'Call number (similar to 852 $k $h $i $m combined)', 'Call number', 0, 0, 'items.itemcallnumber', 10, '', '', NULL, 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'l', 'Shelving form of title (similar to 852 $l)', 'Shelving form of title', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'm', 'Call number suffix (similar to 852 $m)', 'Call number suffix', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'n', 'Country code (similar to 852 $n)', 'Country code', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'o', 'Call number prefix (similar to 852 $k)', 'Call number prefix', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'p', 'Piece designation (barcode) (similar to 852, 876-8 $p)', 'Piece designation (barcode)', 0, 1, 'items.barcode', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'q', 'Piece physical condition (similar to 562 $a, 852 $q)', 'Piece physical condition', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'r', 'Cost, replacement price (similar to 365 $b, 876-8 $c)', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 's', 'Copyright article-fee code (similar to 018 $a, 852 $s)', 'Copyright article-fee code', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 't', 'Copy number (similar to 852, 876-8 $t)', 'Copy number', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'u', 'Koha itemnumber (autogenerated similar to 852, 876-8 $3 $8 $t combined)', 'Koha itemnumber', 0, 0, 'items.itemnumber', -1, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'v', 'Date acquired (similar to 541, 876-8 $d)', 'Date acquired', 0, 0, 'items.dateaccessioned', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'w', 'Price effective from (similar to 365 $f)', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'x', 'Nonpublic note (similar to 852, 876-8 $x)', 'Nonpublic note', 1, 0, '', 10, '', '', '', NULL, 6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'y', 'Use restrictions (not for loan) (similar to 506 $a, 876-8 $h)', 'Use restrictions (not for loan)', 0, 0, 'items.notforloan', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'z', 'Public note (similar to 852, 876-8 $z)', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', 1, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', '0', 'Item status (withdrawn)', 'Item status (withdrawn)', 0, 0, 'items.withdrawn', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', '1', 'Item status (lost)', 'Item status (lost)', 0, 0, 'items.itemlost', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', '3', 'Materials specified', 'Materials specified', 0, 0, '', 10, '', '', '', NULL, -1, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', '4', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', '6', 'Linkage', 'Linkage', 0, 0, '', 10, '', '', '', NULL, -6, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', '8', 'Sequence number', 'Sequence number', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', '9', 'Cost, normal purchase price', 'Cost, normal purchase price', 0, 0, 'items.price', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'a', 'Canceled barcode', 'Canceled barcode', 1, 0, '', 10, '', '', '', NULL, -1, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'b', 'Location (homebranch)', 'Location (homebranch)', 0, 0, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'c', 'Shelving location', 'Shelving location', 1, 0, 'items.location', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'd', 'Sublocation or collection (holdingbranch)', 'Sublocation or collection (holdingbranch)', 0, 0, 'items.holdingbranch', 10, 'branches', '', '', 0, 0, '', '''952b''', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'e', 'Source of acquisition', 'Source of acquisition', 1, 0, 'items.booksellerid', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'g', 'Non-coded location qualifier', 'Non-coded location qualifier', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'h', 'Classification part', 'Classification part', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'i', 'Item part', 'Item part', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'j', 'Shelving control number', 'Shelving control number', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'k', 'Call number (combined)', 'Call number', 0, 0, 'items.itemcallnumber', 10, '', '', NULL, 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'l', 'Shelving form of title', 'Shelving form of title', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'm', 'Call number suffix', 'Call number suffix', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'n', 'Country code', 'Country code', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'o', 'Call number prefix', 'Call number prefix', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'p', 'Barcode', 'Barcode', 0, 1, 'items.barcode', 10, '', '', 'barcode.pl', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'q', 'Piece physical condition', 'Piece physical condition', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'r', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 's', 'Copyright article-fee code', 'Copyright article-fee code', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 't', 'Copy number', 'Copy number', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'u', 'Koha itemnumber (autogenerated)', 'Koha itemnumber', 0, 0, 'items.itemnumber', -1, '', '', '', 0, -5, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'v', 'Date acquired', 'Date acquired', 0, 0, 'items.dateaccessioned', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 10, '', '', '', NULL, 6, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'y', 'Use restrictions (not for loan)', 'Use restrictions (not for loan)', 0, 0, 'items.notforloan', 10, '', '', '', 0, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', 1, 0, '', '', ''); -- ******************************************************* @@ -869,11 +869,11 @@ INSERT INTO `marc_subfield_structure` VALUES ('041', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('041', 'a', 'Language code of text/sound track or separate title', 'Language code of text/sound track or separate title', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'b', 'Language code of summary or abstract/overprinted title or subtitle', 'Language code of summary or abstract/overprinted title or subtitle', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'c', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 'Languages of separate titles (VM) [OBSOLETE] ; Languages of available translation (SE) [OBSOLETE]', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'd', 'Language code of sung or spoken text', 'Language code of sung or spoken text', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'e', 'Language code of librettos', 'Language code of librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('041', 'h', 'Language code of original and/or intermediate translations of text', 'Language code of original and/or intermediate translations of text', 1, 0, '', 0, '', '', '', 0, -1, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('042', 'a', 'Authentication code', 'Authentication code', 0, 0, '', 0, '', '', '', 0, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '2', 'Source of local code', 'Source of local code', 1, 0, '', 0, '', '', '', 0, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('043', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', ''); @@ -1715,8 +1715,8 @@ INSERT INTO `marc_subfield_structure` VALUES ('538', '3', 'Materials specified', INSERT INTO `marc_subfield_structure` VALUES ('538', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('538', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('538', 'a', 'System details note', 'System details note', 0, 0, '', 5, '', '', '', NULL, -1, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('538', 'i', 'Display text', 'Display text', 0, 0, '', 5, '', '', '', NULL, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('538', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, 0, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('538', 'i', 'Display text', 'Display text', 0, 0, '', 5, '', '', '', NULL, -1, '', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('538', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', ''); @@ -4352,4 +4352,3 @@ INSERT INTO `marc_subfield_structure` VALUES ('ufi', 'f', 'FI', 'FI', 0, 0, '', INSERT INTO `marc_subfield_structure` VALUES ('ufi', 'g', 'FI', 'FI', 0, 0, '', 9, '', '', '', 0, 5, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('ufi', 'h', 'FI', 'FI', 0, 0, '', 9, '', '', '', 0, 5, '', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('ufi', 'n', 'FI', 'FI', 0, 0, '', 9, '', '', '', 0, 5, '', '', ''); - -- 2.20.1