[Koha-cvs] koha/misc/marc_datas/marc21_en structure_def.sql

[Thomas D]

CVSROOT:        /sources/koha
Module name:    koha
Changes by:     Thomas D <thd>  06/09/11 03:27:04

Modified files:
        misc/marc_datas/marc21_en: structure_def.sql 

Log message:
        Changed some hidden values for the record editor, shortened items 
labels,
        and added a link to the new barcode plugin.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/marc_datas/marc21_en/structure_def.sql?cvsroot=koha&r1=1.15&r2=1.16

Patches:
Index: structure_def.sql
===================================================================
RCS file: /sources/koha/koha/misc/marc_datas/marc21_en/structure_def.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -b -r1.15 -r1.16
--- structure_def.sql   9 Aug 2006 21:04:35 -0000       1.15
+++ structure_def.sql   11 Sep 2006 03:27:04 -0000      1.16
@@ -1,8 +1,8 @@
 -- *******************************************************
 --  KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK 
 --                                                        
---                  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              
@@ -101,7 +101,7 @@
 -- 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, '', '', '');
@@ -117,7 +117,7 @@
 -- 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, '', '', '');
@@ -136,40 +136,40 @@
 
 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, '', '', '');
 
 
 -- *******************************************************
@@ -727,11 +727,11 @@
 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, '', '', '');
@@ -1573,8 +1573,8 @@
 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, '', '', '');
@@ -4210,4 +4210,3 @@
 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, '', '', '');
-