From 9413ee2f7d12b47b2c4c5ed3aceb2a7ded6458ad Mon Sep 17 00:00:00 2001 From: tipaul Date: Wed, 3 Sep 2003 15:14:18 +0000 Subject: [PATCH] modifying MARC21 default setup : using Nelsonville setup, that is working. User just need to define itemtypes. --- misc/marc_datas/marc21_en/structure_def.sql | 971 +------------------- 1 file changed, 35 insertions(+), 936 deletions(-) diff --git a/misc/marc_datas/marc21_en/structure_def.sql b/misc/marc_datas/marc21_en/structure_def.sql index 0e7b4fc569..3b61475f4f 100644 --- a/misc/marc_datas/marc21_en/structure_def.sql +++ b/misc/marc_datas/marc21_en/structure_def.sql @@ -3,42 +3,27 @@ # http://www.phpmyadmin.net/ (download page) # # Serveur: localhost -# Généré le : Jeudi 20 Mars 2003 à 12:44 +# Généré le : Mercredi 03 Septembre 2003 à 17:18 # Version du serveur: 3.23.52 # Version de PHP: 4.2.3 -# Base de données: `koha_190` +# Base de données: `koha_200pre2` # # Contenu de la table `marc_subfield_structure` # -INSERT INTO marc_subfield_structure VALUES ('010', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 1, '', 0, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('010', 'a', 'LC control number', 'LC control number', 0, 0, 'biblioitems.lccn', 0, NULL, '', ''); INSERT INTO marc_subfield_structure VALUES ('010', 'b', 'NUCMC control number', 'NUCMC control number', 1, 0, '', 0, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('010', 'z', 'Canceled or invalid LC control number', 'Canceled or invalid LC control number', 1, 0, '', -1, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('011', 'a', 'Linking LC control number (R)', 'Linking LC control number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('013', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('013', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('013', 'a', 'Number', 'Number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('013', 'b', 'Country', 'Country', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('013', 'c', 'Type of number', 'Type of number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('013', 'd', 'Date', 'Date', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('013', 'e', 'Status', 'Status', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('013', 'f', 'Party to document', 'Party to document', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('015', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('015', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('015', 'a', 'National bibliography number', 'National bibliography number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('016', '2', 'Source', 'Source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('016', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('016', 'a', 'Record control number', 'Record control number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('016', 'z', 'Canceled or invalid record control number', 'Canceled or invalid record control number', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('017', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('017', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('017', 'a', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('017', 'b', 'Source (agency assigning number) (NR)', 'Source (agency assigning number) (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('017', 'c', 'Terms of availability', 'Terms of availability', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('017', 'z', 'Canceled/invalid ISBN', 'Canceled/invalid ISBN', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('018', 'a', 'Copyright article-fee code (NR)', 'Copyright article-fee code (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('020', '6', 'Linkage "See "', 'Linkage "See "', 1, 0, '', 0, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('020', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, '', 0, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 1, 'biblioitems.isbn', 0, NULL, NULL, ''); @@ -57,57 +42,14 @@ INSERT INTO marc_subfield_structure VALUES ('024', 'a', 'Standard number or code INSERT INTO marc_subfield_structure VALUES ('024', 'c', 'Terms of availability', 'Terms of availability', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('024', 'd', 'Additional codes following the standard number or code', 'Additional codes following the standard number or code', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('024', 'z', 'Canceled/invalid standard number or code', 'Canceled/invalid standard number or code', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('025', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('025', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('025', 'a', 'Standard technical report number', 'Standard technical report number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('025', 'z', 'Canceled/invalid number', 'Canceled/invalid number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('027', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('027', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('027', 'a', 'Standard Technical Report Number (NR)', 'Standard Technical Report Number (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('027', 'z', 'Cancelled/invalid STRN (R)', 'Cancelled/invalid STRN (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('028', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('028', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('028', 'a', 'Publisher number', 'Publisher number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('028', 'b', 'Source', 'Source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('030', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('030', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('030', 'a', 'CODEN', 'CODEN', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('030', 'z', 'Canceled/invalid CODEN', 'Canceled/invalid CODEN', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('032', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('032', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('032', 'a', 'Postal registration number', 'Postal registration number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('032', 'b', 'Source (agency assigning number)', 'Source (agency assigning number)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('033', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('033', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('033', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('033', 'a', 'Formatted date/time', 'Formatted date/time', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('033', 'b', 'Geographic classification area code', 'Geographic classification area code', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('033', 'c', 'Geographic classification subarea code', 'Geographic classification subarea code', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'a', 'Category of scale', 'Category of scale', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'b', 'Constant ratio linear horizontal scale', 'Constant ratio linear horizontal scale', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'c', 'Constant ratio linear vertical scale', 'Constant ratio linear vertical scale', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'd', 'Coordinates--westernmost longitude', 'Coordinates--westernmost longitude', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'e', 'Coordinates--easternmost longitude', 'Coordinates--easternmost longitude', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'f', 'Coordinates--northernmost longitude', 'Coordinates--northernmost longitude', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'g', 'Coordinates--southernmost longitude', 'Coordinates--southernmost longitude', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'h', 'Angular scale', 'Angular scale', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'j', 'Declination--northern limit', 'Declination--northern limit', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'k', 'Declination--southern limit', 'Declination--southern limit', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'm', 'Right ascension--eastern limit', 'Right ascension--eastern limit', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'n', 'Right ascension--western limit', 'Right ascension--western limit', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 'p', 'Equinox', 'Equinox', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 's', 'G-ring latitude', 'G-ring latitude', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('034', 't', 'G-ring latitude', 'G-ring latitude', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('035', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, '', 0, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('035', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, '', 0, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('035', 'a', 'System control number', 'System control number', 0, 0, '', 0, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, '', -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('036', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('036', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('036', 'a', 'Original study number', 'Original study number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('036', 'b', 'Source (agency assigning number)', 'Source (agency assigning number)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('037', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('037', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('037', 'a', 'Stock number', 'Stock number', 0, 0, NULL, -1, NULL, NULL, ''); @@ -116,11 +58,6 @@ INSERT INTO marc_subfield_structure VALUES ('037', 'c', 'Terms of availability', INSERT INTO marc_subfield_structure VALUES ('037', 'f', 'Form of issue', 'Form of issue', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('037', 'g', 'Additional format characteristics', 'Additional format characteristics', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('037', 'n', 'Note', 'Note', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('039', 'a', 'Level of rules in bibliographic description (NR) 0 - No level defined by rules 1 - Minimal 2 - Less than full 3 - Full', 'Level of rules in bibliographic description (NR) 0 - No level defined by rules 1 - Minimal 2 - Less than full 3 - Full', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('039', 'b', 'Level of effort used to assign nonsubject heading access points (NR) 2 - Less than full 3 - Full', 'Level of effort used to assign nonsubject heading access points (NR) 2 - Less than full 3 - Full', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('039', 'c', 'Level of effort used to assign subject headings (NR) 0 - None 2 - Less than full 3 - Full', 'Level of effort used to assign subject headings (NR) 0 - None 2 - Less than full 3 - Full', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('039', 'd', 'Level of effort used to assign classification (NR) 0 - None 2 - Less than full 3 - Full', 'Level of effort used to assign classification (NR) 0 - None 2 - Less than full 3 - Full', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('039', 'e', 'Number of fixed field character positions coded (NR) 0 - None 1 - Minimal 2 - Most necessary 3 - Full', 'Number of fixed field character positions coded (NR) 0 - None 1 - Minimal 2 - Most necessary 3 - Full', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('040', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('040', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 0, NULL, -1, NULL, NULL, ''); @@ -138,86 +75,28 @@ INSERT INTO marc_subfield_structure VALUES ('041', 'e', 'Language code of libret INSERT INTO marc_subfield_structure VALUES ('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('041', 'g', 'Language code of accompanying material other than librettos (NR)', 'Language code of accompanying material other than librettos (NR)', 0, 0, NULL, -1, NULL, NULL, ''); 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, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('042', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('042', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('042', 'a', 'Time period code', 'Time period code', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('042', 'b', 'Formatted 9999 B', 'Formatted 9999 B', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('042', 'c', 'Formatted pre-9999 B', 'Formatted pre-9999 B', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('043', '2', 'Source of local code (R)', 'Source of local code (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('043', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('043', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('043', 'a', 'Geographic area code (R)', 'Geographic area code (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('043', 'b', 'Local GAC code (R)', 'Local GAC code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('044', '2', 'Source of local subentity code (R)', 'Source of local subentity code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('044', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('044', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('044', 'a', 'Country of publishing/producing entity code (R)', 'Country of publishing/producing entity code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('044', 'b', 'Local subentity code (R)', 'Local subentity code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('044', 'c', 'ISO subentity code (R)', 'ISO subentity code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('045', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('045', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('045', 'a', 'Time period code (R)', 'Time period code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('045', 'b', 'Formatted 9999 B', 'Formatted 9999 B', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('045', 'c', 'Formatted pre-9999 B', 'Formatted pre-9999 B', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('046', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('046', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('046', 'a', 'Type of date code', 'Type of date code', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('046', 'b', 'Date 1 (B', 'Date 1 (B', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('046', 'c', 'Date 1 (C', 'Date 1 (C', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('046', 'd', 'Date 2 (B', 'Date 2 (B', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('046', 'e', 'Date 2 (C', 'Date 2 (C', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('047', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('047', 'a', 'Performer or ensemble', 'Performer or ensemble', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('047', 'b', 'Soloist', 'Soloist', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('048', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('048', 'a', 'Performer or ensemble (R)', 'Performer or ensemble (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('048', 'b', 'Soloist (R)', 'Soloist (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('050', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('050', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('050', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('050', 'a', 'Classification number', 'Classification number', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('050', 'b', 'Item number', 'Item number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('050', 'd', 'Supplementary class number (MU) [OBSOLETE]', 'Supplementary class number (MU) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('051', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('051', 'a', 'Classification number', 'Classification number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('051', 'b', 'Item number', 'Item number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('051', 'c', 'Copy information', 'Copy information', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('052', '2', 'Code source', 'Code source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('052', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('052', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('052', 'a', 'Geographic classification area code', 'Geographic classification area code', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('052', 'b', 'Geographic classification subarea code', 'Geographic classification subarea code', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('052', 'c', 'Subject (MP) [OBSOLETE]', 'Subject (MP) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('052', 'd', 'Populated place name', 'Populated place name', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('055', '2', 'Source of call/class number', 'Source of call/class number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('055', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('055', 'a', 'Classification number', 'Classification number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('055', 'b', 'Item number', 'Item number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('060', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('060', 'a', 'Classification number', 'Classification number', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('060', 'b', 'Item number', 'Item number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('061', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('061', 'a', 'Classification number', 'Classification number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('061', 'b', 'Item number', 'Item number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('061', 'c', 'Copy information', 'Copy information', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('066', 'a', 'Primary G0 character set', 'Primary G0 character set', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('066', 'b', 'Primary G1 character set', 'Primary G1 character set', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('066', 'c', 'Alternate G0 or G1 character set', 'Alternate G0 or G1 character set', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('070', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('070', 'a', 'Classification number', 'Classification number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('070', 'b', 'Item number', 'Item number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('071', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('071', 'a', 'Classification number', 'Classification number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('071', 'b', 'Item number', 'Item number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('071', 'c', 'Copy information', 'Copy information', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('072', '2', 'Code source', 'Code source', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('072', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('072', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('072', 'a', 'Subject category code', 'Subject category code', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('072', 'x', 'Subject category code subdivision', 'Subject category code subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('074', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('074', 'a', 'GPO item number', 'GPO item number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('074', 'z', 'Canceled/invalid GPO item number', 'Canceled/invalid GPO item number', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('080', '2', 'Edition number', 'Edition number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('080', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('080', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); @@ -239,15 +118,10 @@ INSERT INTO marc_subfield_structure VALUES ('086', '6', 'Linkage "See "', 'Linka INSERT INTO marc_subfield_structure VALUES ('086', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('086', 'a', 'Classification number', 'Classification number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('086', 'z', 'Canceled/invalid classification number', 'Canceled/invalid classification number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('088', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('088', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('088', 'a', 'Report number', 'Report number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('088', 'z', 'Canceled/invalid report number', 'Canceled/invalid report number', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('090', 'a', 'Koha Itemtype (NR)', 'Koha Itemtype (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('090', 'b', 'Koha Dewey Subclass (NR)', 'Koha Dewey Subclass (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('090', 'c', 'Koha biblionumber (NR)', 'Koha biblionumber (NR)', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('090', 'd', 'Koha biblioitemnumber (NR)', 'Koha biblioitemnumber (NR)', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('091', 'a', 'Microfilm shelf location (NR)', 'Microfilm shelf location (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('100', '4', 'Relator code', 'Relator code', 1, 0, '', -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('100', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, '', -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('100', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, '', -1, NULL, NULL, ''); @@ -320,12 +194,6 @@ INSERT INTO marc_subfield_structure VALUES ('210', '6', 'Linkage "See "', 'Linka INSERT INTO marc_subfield_structure VALUES ('210', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('210', 'a', 'Abbreviated title', 'Abbreviated title', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('210', 'b', 'Qualifying information', 'Qualifying information', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('211', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('211', 'a', 'Acronym or shortened title (NR)', 'Acronym or shortened title (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('212', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('212', 'a', 'Variant access title (NR)', 'Variant access title (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('214', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('214', 'a', 'Augmented title (NR)', 'Augmented title (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('222', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('222', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('222', 'a', 'Key title', 'Key title', 0, 0, NULL, -1, NULL, NULL, ''); @@ -345,8 +213,6 @@ INSERT INTO marc_subfield_structure VALUES ('240', 'o', 'Arranged statement for INSERT INTO marc_subfield_structure VALUES ('240', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('240', 'r', 'Key for music', 'Key for music', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('240', 's', 'Version', 'Version', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('241', 'a', 'Romanized title (NR)', 'Romanized title (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('241', 'h', 'Medium (NR)', 'Medium (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('242', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('242', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('242', 'a', 'Title', 'Title', 0, 0, NULL, -1, NULL, NULL, ''); @@ -358,25 +224,10 @@ INSERT INTO marc_subfield_structure VALUES ('242', 'h', 'Medium', 'Medium', 0, 0 INSERT INTO marc_subfield_structure VALUES ('242', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('242', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('242', 'y', 'Language code of translated title', 'Language code of translated title', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'a', 'Uniform title', 'Uniform title', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'd', 'Date of treaty signing', 'Date of treaty signing', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'f', 'Date of a work', 'Date of a work', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'h', 'Medium', 'Medium', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'k', 'Form subheading', 'Form subheading', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'l', 'Language of a work', 'Language of a work', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'm', 'Medium of performance for music', 'Medium of performance for music', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'o', 'Arranged statement for music', 'Arranged statement for music', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 'r', 'Key for music', 'Key for music', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('243', 's', 'Version', 'Version', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('245', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('245', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('245', 'a', 'Title', 'Title', 0, 0, 'biblio.title', 1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', -1, NULL, NULL, ''); +INSERT INTO marc_subfield_structure VALUES ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('245', 'd', 'Designation of section (SE) [OBSOLETE]', 'Designation of section (SE) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('245', 'e', 'Name of part/section (SE) [OBSOLETE]', 'Name of part/section (SE) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); @@ -400,86 +251,22 @@ INSERT INTO marc_subfield_structure VALUES ('246', 'h', 'Medium', 'Medium', 0, 0 INSERT INTO marc_subfield_structure VALUES ('246', 'i', 'Display text', 'Display text', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('246', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('246', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'a', 'Title proper/short title', 'Title proper/short title', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'b', 'Remainder of title', 'Remainder of title', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'd', 'Designation of section (SE) [OBSOLETE]', 'Designation of section (SE) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'e', 'Name of part/section (SE) [OBSOLETE]', 'Name of part/section (SE) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'f', 'Date or sequential designation', 'Date or sequential designation', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'h', 'Medium', 'Medium', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('247', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('250', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('250', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('250', 'a', 'Edition statement', 'Edition statement', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('250', 'b', 'Remainder of edition statement', 'Remainder of edition statement', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('254', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('254', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('254', 'a', 'Musical presentation statement', 'Musical presentation statement', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', 'a', 'Statement of scale', 'Statement of scale', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', 'b', 'Statement of projection', 'Statement of projection', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', 'c', 'Statement of coordinates', 'Statement of coordinates', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', 'd', 'Statement of zone', 'Statement of zone', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', 'e', 'Statement of equinox', 'Statement of equinox', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', 'f', 'Outer G-ring coordinate pairs', 'Outer G-ring coordinate pairs', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('255', 'g', 'Exclusion G-ring coordinate pairs', 'Exclusion G-ring coordinate pairs', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('256', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('256', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('256', 'a', 'Computer file characteristics', 'Computer file characteristics', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('257', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('257', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('257', 'a', 'Country of producing entity', 'Country of producing entity', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', 'a', 'Place of publication, distribution, etc', 'Place of publication, distribution, etc', 1, 0, 'biblioitems.place', -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', 'b', 'Name of publisher, distributor, etc', 'Name of publisher, distributor, etc', 1, 0, 'biblioitems.publishercode', -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', 'c', 'Date of publication, distribution, etc', 'Date of publication, distribution, etc', 1, 0, 'biblioitems.publicationyear', -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', 'd', 'Plates of publisher\'s number for music (Pre-AACR 2) (R) [US-LOCAL]', 'Plates of publisher\'s number for music (Pre-AACR 2) (R) [US-LOCAL]', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', 'e', 'Place of manufacture', 'Place of manufacture', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', 'f', 'Manufacturer', 'Manufacturer', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('260', 'g', 'Date of manufacture', 'Date of manufacture', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('261', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('261', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('261', 'a', 'Producing company (R)', 'Producing company (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('261', 'b', 'Releasing company (primary distributor) (R)', 'Releasing company (primary distributor) (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('261', 'd', 'Date of production, release, etc', 'Date of production, release, etc', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('261', 'e', 'Contractual producer (R)', 'Contractual producer (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('261', 'f', 'Place of production, release, etc', 'Place of production, release, etc', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('262', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('262', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('262', 'a', 'Place of production, release, etc', 'Place of production, release, etc', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('262', 'b', 'Publisher or trade name (NR)', 'Publisher or trade name (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('262', 'c', 'Date of production, release, etc', 'Date of production, release, etc', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('262', 'k', 'Serial identification (NR)', 'Serial identification (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('262', 'l', 'Matrix and/or take number (NR)', 'Matrix and/or take number (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', '4', 'Relator code', 'Relator code', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'a', 'Address', 'Address', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'b', 'City', 'City', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'c', 'State or province', 'State or province', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'd', 'Country', 'Country', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'e', 'Postal code', 'Postal code', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'f', 'Terms preceding attention name', 'Terms preceding attention name', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'g', 'Attention name', 'Attention name', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'h', 'Attention position', 'Attention position', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'i', 'Type of address', 'Type of address', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'j', 'Specialized telephone number', 'Specialized telephone number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'k', 'Telephone number', 'Telephone number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'l', 'Fax number', 'Fax number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'm', 'Electronic mail address', 'Electronic mail address', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'n', 'TDD or TTY number', 'TDD or TTY number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'p', 'Contact person', 'Contact person', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'q', 'Title of contact person', 'Title of contact person', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'r', 'Hours', 'Hours', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('263', 'z', 'Public note', 'Public note', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('265', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('265', 'a', 'Source for acquisition/subscription address (R)', 'Source for acquisition/subscription address (R)', 1, 0, NULL, -1, NULL, NULL, ''); +INSERT INTO marc_subfield_structure VALUES ('260', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('260', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('260', 'a', 'Place of publication, distribution, etc', 'Place of publication, distribution, etc', 1, 0, 'biblioitems.place', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('260', 'b', 'Name of publisher, distributor, etc', 'Name of publisher, distributor, etc', 1, 0, 'biblioitems.publishercode', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('260', 'c', 'Date of publication, distribution, etc', 'Date of publication, distribution, etc', 1, 0, 'biblio.copyrightdate', 1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('260', 'd', 'Plates of publisher\'s number for music (Pre-AACR 2) (R) [US-LOCAL]', 'Plates of publisher\'s number for music (Pre-AACR 2) (R) [US-LOCAL]', 1, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('260', 'e', 'Place of manufacture', 'Place of manufacture', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('260', 'f', 'Manufacturer', 'Manufacturer', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('260', 'g', 'Date of manufacture', 'Date of manufacture', 0, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('270', '4', 'Relator code (R)', 'Relator code (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('270', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('270', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); @@ -510,50 +297,14 @@ INSERT INTO marc_subfield_structure VALUES ('300', 'c', 'Dimensions', 'Dimension INSERT INTO marc_subfield_structure VALUES ('300', 'e', 'Accompanying material', 'Accompanying material', 0, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('300', 'f', 'Type of unit', 'Type of unit', 1, 0, 'biblioitems.itemtype', 2, 'itemtypes', '', ''); INSERT INTO marc_subfield_structure VALUES ('300', 'g', 'Size of unit', 'Size of unit', 1, 0, '', -1, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('301', 'a', 'Extent of item (NR)', 'Extent of item (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('301', 'b', 'Sound characteristics (NR)', 'Sound characteristics (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('301', 'c', 'Color characteristics (NR)', 'Color characteristics (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('301', 'd', 'Dimensions (NR)', 'Dimensions (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('301', 'e', 'Accompanying material (NR)', 'Accompanying material (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('301', 'f', 'Speed (NR)', 'Speed (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('302', 'a', 'Page count (NR)', 'Page count (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('303', 'a', 'Unit count (NR)', 'Unit count (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('304', 'a', 'Linear footage (NR)', 'Linear footage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', 'a', 'Extent (NR)', 'Extent (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', 'b', 'Other physical details (NR)', 'Other physical details (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', 'c', 'Dimensions (NR)', 'Dimensions (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', 'd', 'Microgroove or standard (NR)', 'Microgroove or standard (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', 'e', 'Stereophonic, monaural (NR)', 'Stereophonic, monaural (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', 'f', 'Number of tracks (NR)', 'Number of tracks (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', 'm', 'Serial identification (NR)', 'Serial identification (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('305', 'n', 'Matrix and/or take number (NR)', 'Matrix and/or take number (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('306', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('306', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('306', 'a', 'Hours', 'Hours', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('306', 'b', 'Additional information', 'Additional information', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('307', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('307', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('307', 'a', 'Hours (NR)', 'Hours (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('307', 'b', 'Additional information (NR)', 'Additional information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('308', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('308', 'a', 'Number of reels (NR)', 'Number of reels (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('308', 'b', 'Footage (NR)', 'Footage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('308', 'c', 'Sound characteristics (NR)', 'Sound characteristics (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('308', 'd', 'Color characteristics (NR)', 'Color characteristics (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('308', 'e', 'Width (NR)', 'Width (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('308', 'f', 'Presentation format (NR)', 'Presentation format (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('310', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('310', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('310', 'a', 'Current publication frequency', 'Current publication frequency', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('310', 'b', 'Date of current publication frequency', 'Date of current publication frequency', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('315', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('315', 'a', 'Frequency (R)', 'Frequency (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('315', 'b', 'Dates of frequency (R)', 'Dates of frequency (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('321', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('321', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('321', 'a', 'Former publication frequency', 'Former publication frequency', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('321', 'b', 'Dates of former publication frequency', 'Dates of former publication frequency', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('340', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('340', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('340', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); @@ -565,46 +316,6 @@ INSERT INTO marc_subfield_structure VALUES ('340', 'e', 'Support', 'Support', 1, INSERT INTO marc_subfield_structure VALUES ('340', 'f', 'Production rate/ratio', 'Production rate/ratio', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('340', 'h', 'Location within medium', 'Location within medium', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('340', 'i', 'Technical specifications of medium', 'Technical specifications of medium', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', '2', 'Reference method used', 'Reference method used', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'a', 'Name', 'Name', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'b', 'Coordinate or distance units', 'Coordinate or distance units', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'c', 'Latitude resolution', 'Latitude resolution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'd', 'Longitude resolution', 'Longitude resolution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'e', 'Standard parallel or oblique line latitude', 'Standard parallel or oblique line latitude', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'f', 'Oblique line longitude', 'Oblique line longitude', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'g', 'Longitude of central meridian or projection center', 'Longitude of central meridian or projection center', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'h', 'Latitude of projection origin or projection center', 'Latitude of projection origin or projection center', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'i', 'False easting', 'False easting', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'j', 'False northing', 'False northing', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'k', 'Scale factor', 'Scale factor', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'l', 'Height of perspective point above surface', 'Height of perspective point above surface', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'm', 'Azimuthal angle', 'Azimuthal angle', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'n', 'Azimuth measure point longitude or straight vertical longitude from pole', 'Azimuth measure point longitude or straight vertical longitude from pole', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'o', 'Landsat number and path number', 'Landsat number and path number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'p', 'Zone identifier', 'Zone identifier', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'q', 'Ellipsoid name', 'Ellipsoid name', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'r', 'Semi-major axis', 'Semi-major axis', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 's', 'Denominator of flattening ratio', 'Denominator of flattening ratio', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 't', 'Vertical resolution', 'Vertical resolution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'u', 'Vertical encoding method', 'Vertical encoding method', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'v', 'Local planar, local, or other projection or grid description', 'Local planar, local, or other projection or grid description', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('342', 'w', 'Local planar or local georeference information', 'Local planar or local georeference information', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'a', 'Planar coordinate encoding method', 'Planar coordinate encoding method', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'b', 'Planar distance units', 'Planar distance units', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'c', 'Abscissa resolution', 'Abscissa resolution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'd', 'Ordinate resolution', 'Ordinate resolution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'e', 'Distance resolution', 'Distance resolution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'f', 'Bearing resolution', 'Bearing resolution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'g', 'Bearing units', 'Bearing units', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'h', 'Bearing reference direction', 'Bearing reference direction', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('343', 'i', 'Bearing reference meridian', 'Bearing reference meridian', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('350', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('350', 'a', 'Price (R)', 'Price (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('350', 'b', 'Form of issue (R)', 'Form of issue (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('351', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('351', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('351', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); @@ -621,85 +332,10 @@ INSERT INTO marc_subfield_structure VALUES ('352', 'e', 'Column count', 'Column INSERT INTO marc_subfield_structure VALUES ('352', 'f', 'Vertical count', 'Vertical count', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('352', 'g', 'VPF topology level', 'VPF topology level', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('352', 'i', 'Indirect reference description', 'Indirect reference description', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'a', 'Security classification', 'Security classification', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'b', 'Handling instructions', 'Handling instructions', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'c', 'External dissemination information', 'External dissemination information', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'd', 'Downgrading or declassification event', 'Downgrading or declassification event', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'e', 'Classification system', 'Classification system', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'f', 'Country of origin code', 'Country of origin code', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'g', 'Downgrading date', 'Downgrading date', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'h', 'Declassification date', 'Declassification date', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('355', 'j', 'Authorization', 'Authorization', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('357', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('357', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('357', 'a', 'Dates of publication and/or sequential designation', 'Dates of publication and/or sequential designation', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('357', 'b', 'Originating agency (R)', 'Originating agency (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('357', 'c', 'Authorized recipients of material (R)', 'Authorized recipients of material (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('357', 'g', 'Other restrictions (R)', 'Other restrictions (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('357', 'z', 'Source of information', 'Source of information', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('359', 'a', 'Rental price (NR)', 'Rental price (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('362', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('362', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('362', 'a', 'Dates of publication and/or sequential designation (NR)', 'Dates of publication and/or sequential designation (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('362', 'z', 'Source of information (NR)', 'Source of information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', '4', 'Relator code (R)', 'Relator code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'a', 'Personal name (NR)', 'Personal name (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'b', 'Numeration (NR)', 'Numeration (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'c', 'Titles and other words associated with a name (R)', 'Titles and other words associated with a name (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'd', 'Dates associated with a name (NR)', 'Dates associated with a name (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'e', 'Relator term (R)', 'Relator term (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'f', 'Date of a work (NR)', 'Date of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'g', 'Miscellaneous information (NR)', 'Miscellaneous information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'k', 'Form subheading (R)', 'Form subheading (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'l', 'Language of a work (NR)', 'Language of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'n', 'Number of part/section of a work (R)', 'Number of part/section of a work (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'p', 'Name of part/section of a work (R)', 'Name of part/section of a work (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'q', 'Fuller form of name (NR) [OBSOLETE]', 'Fuller form of name (NR) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 't', 'Title of a work (NR)', 'Title of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'u', 'Affiliation (NR)', 'Affiliation (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'v', 'Volume number/sequential designation (NR)', 'Volume number/sequential designation (NR)', 0, 0, 'biblio.serial', -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('400', 'x', 'International Standard Serial Number (NR)', 'International Standard Serial Number (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', '4', 'Relator code (R)', 'Relator code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'a', 'Corporate name or jurisdiction name as entry element (NR)', 'Corporate name or jurisdiction name as entry element (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'b', 'Subordinate unit (R)', 'Subordinate unit (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'c', 'Location of meeting (NR)', 'Location of meeting (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'd', 'Date of meeting or treaty signing (R)', 'Date of meeting or treaty signing (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'e', 'Relator term (R)', 'Relator term (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'f', 'Date of a work (NR)', 'Date of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'g', 'Miscellaneous information (NR)', 'Miscellaneous information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'k', 'Form subheading (R)', 'Form subheading (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'l', 'Language of a work (NR)', 'Language of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'n', 'Number of part/section/meeting (R)', 'Number of part/section/meeting (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'p', 'Name of part/section of a work (R)', 'Name of part/section of a work (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 't', 'Title of a work (NR)', 'Title of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'u', 'Affiliation (NR)', 'Affiliation (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'v', 'Volume number/sequential designation (NR)', 'Volume number/sequential designation (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('410', 'x', 'International Standard Serial Number (NR)', 'International Standard Serial Number (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', '4', 'Relator code (R)', 'Relator code (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'a', 'Meeting name or jurisdiction name as entry element (NR)', 'Meeting name or jurisdiction name as entry element (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'b', 'Number [OBSOLETE]', 'Number [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'c', 'Location of meeting (NR)', 'Location of meeting (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'd', 'Date of meeting (NR)', 'Date of meeting (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'e', 'Subordinate unit (R)', 'Subordinate unit (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'f', 'Date of a work (NR)', 'Date of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'g', 'Miscellaneous information (NR)', 'Miscellaneous information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'k', 'Form subheading (R)', 'Form subheading (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'l', 'Language of a work (NR)', 'Language of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'n', 'Number of part/section/meeting (R)', 'Number of part/section/meeting (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'p', 'Name of part/section of a work (R)', 'Name of part/section of a work (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'q', 'Name of meeting following jurisdiction name entry element (NR)', 'Name of meeting following jurisdiction name entry element (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 't', 'Title of a work (NR)', 'Title of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'u', 'Affiliation (NR)', 'Affiliation (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'v', 'Volume number/sequential designation (NR)', 'Volume number/sequential designation (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('411', 'x', 'International Standard Serial Number (NR)', 'International Standard Serial Number (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('440', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('440', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('440', 'a', 'Title', 'Title', 0, 0, 'biblio.seriestitle', -1, NULL, NULL, ''); @@ -707,12 +343,6 @@ INSERT INTO marc_subfield_structure VALUES ('440', 'n', 'Number of part/section INSERT INTO marc_subfield_structure VALUES ('440', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('440', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, 'biblioitems.volume', -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('440', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('490', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('490', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('490', 'a', 'Series statement', 'Series statement', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('490', 'l', 'Library of Congress call number', 'Library of Congress call number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('490', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('490', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('500', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('500', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('500', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); @@ -721,15 +351,6 @@ INSERT INTO marc_subfield_structure VALUES ('500', 'a', 'General note', 'General INSERT INTO marc_subfield_structure VALUES ('500', 'l', 'Library of Congress call number (SE) [OBSOLETE]', 'Library of Congress call number (SE) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('500', 'x', 'International Standard Serial Number (SE) [OBSOLETE]', 'International Standard Serial Number (SE) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('500', 'z', 'Source of note information (AM SE) [OBSOLETE]', 'Source of note information (AM SE) [OBSOLETE]', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('501', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('501', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('501', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('501', 'a', 'With note', 'With note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('502', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('502', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('502', 'a', 'Dissertation note', 'Dissertation note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('503', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('503', 'a', 'Bibliographic history note (NR)', 'Bibliographic history note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('504', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('504', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('504', 'a', 'Bibliography, etc', 'Bibliography, etc', 0, 0, '', -1, NULL, NULL, ''); @@ -741,64 +362,15 @@ INSERT INTO marc_subfield_structure VALUES ('505', 'g', 'Miscellaneous informati INSERT INTO marc_subfield_structure VALUES ('505', 'r', 'Statement of responsibility', 'Statement of responsibility', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('505', 't', 'Title', 'Title', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('505', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', 'a', 'Terms governing access', 'Terms governing access', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', 'b', 'Jurisdiction', 'Jurisdiction', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', 'c', 'Physical access provisions', 'Physical access provisions', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', 'd', 'Authorized users', 'Authorized users', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('506', 'e', 'Authorization', 'Authorization', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('507', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('507', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('507', 'a', 'Representative fraction of scale note', 'Representative fraction of scale note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('507', 'b', 'Remainder of scale note', 'Remainder of scale note', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('508', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('508', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('508', 'a', 'Creation/production credits note', 'Creation/production credits note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('510', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('510', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('510', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('510', 'a', 'Name of source', 'Name of source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('510', 'b', 'Coverage of source', 'Coverage of source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('510', 'c', 'Location within source', 'Location within source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('510', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('511', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('511', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('511', 'a', 'Participant or performer note', 'Participant or performer note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('512', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('512', 'a', 'Earlier or later volumes separately cataloged note (NR)', 'Earlier or later volumes separately cataloged note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('513', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('513', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('513', 'a', 'Type of report', 'Type of report', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('513', 'b', 'Period covered', 'Period covered', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'a', 'Attribute accuracy report', 'Attribute accuracy report', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'b', 'Attribute accuracy value', 'Attribute accuracy value', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'c', 'Attribute accuracy explanation', 'Attribute accuracy explanation', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'd', 'Logical consistency report', 'Logical consistency report', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'e', 'Completeness report', 'Completeness report', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'f', 'Horizontal position accuracy report', 'Horizontal position accuracy report', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'g', 'Horizontal position accuracy value', 'Horizontal position accuracy value', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'h', 'Horizontal position accuracy explanation', 'Horizontal position accuracy explanation', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'i', 'Vertical positional accuracy report', 'Vertical positional accuracy report', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'j', 'Vertical positional accuracy value', 'Vertical positional accuracy value', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'k', 'Vertical positional accuracy explanation', 'Vertical positional accuracy explanation', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'm', 'Cloud cover', 'Cloud cover', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('514', 'z', 'Display note', 'Display note', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('515', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('515', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('515', 'a', 'Numbering peculiarities note', 'Numbering peculiarities note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('515', 'z', 'Source of note information (NR) (SE) [OBSOLETE]', 'Source of note information (NR) (SE) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('516', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('516', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('516', 'a', 'Type of computer file or data note', 'Type of computer file or data note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('517', 'a', 'Different formats (NR)', 'Different formats (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('517', 'b', 'Content descriptors (R)', 'Content descriptors (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('517', 'c', 'Additional animation techniques (R)', 'Additional animation techniques (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('518', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('518', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('518', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); @@ -815,33 +387,6 @@ INSERT INTO marc_subfield_structure VALUES ('521', '6', 'Linkage "See "', 'Linka INSERT INTO marc_subfield_structure VALUES ('521', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('521', 'a', 'Target audience note', 'Target audience note', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('521', 'b', 'Source', 'Source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('522', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('522', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('522', 'a', 'Geographic coverage note', 'Geographic coverage note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('523', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('523', 'a', 'Time period of content note (NR)', 'Time period of content note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('523', 'b', 'Dates of data collection note (NR)', 'Dates of data collection note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('524', '2', 'Source of schema used', 'Source of schema used', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('524', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('524', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('524', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('524', 'a', 'Preferred citation of described materials note', 'Preferred citation of described materials note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('525', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('525', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('525', 'a', 'Supplement note', 'Supplement note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('525', 'z', 'Source of note information (NR) (SE) [OBSOLETE]', 'Source of note information (NR) (SE) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', 'a', 'Program name', 'Program name', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', 'b', 'Interest level', 'Interest level', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', 'c', 'Reading level', 'Reading level', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', 'd', 'Title point value', 'Title point value', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', 'i', 'Display text', 'Display text', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', 'x', 'Nonpublic note', 'Nonpublic note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('526', 'z', 'Public note', 'Public note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('527', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('527', 'a', 'Censorship note (NR)', 'Censorship note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('530', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('530', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('530', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); @@ -878,100 +423,15 @@ INSERT INTO marc_subfield_structure VALUES ('534', 'p', 'Introductory phrase', ' INSERT INTO marc_subfield_structure VALUES ('534', 't', 'Title statement of original', 'Title statement of original', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('534', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('534', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('535', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('535', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('535', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('535', 'a', 'Custodian', 'Custodian', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('535', 'b', 'Postal address', 'Postal address', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('535', 'c', 'Country', 'Country', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('535', 'd', 'Telecommunications address', 'Telecommunications address', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('535', 'g', 'Repository location code', 'Repository location code', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', 'a', 'Text of note', 'Text of note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', 'b', 'Contract number', 'Contract number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', 'c', 'Grant number', 'Grant number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', 'd', 'Undifferentiated number', 'Undifferentiated number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', 'e', 'Program element number', 'Program element number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', 'f', 'Project number', 'Project number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', 'g', 'Task number', 'Task number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('536', 'h', 'Work unit number', 'Work unit number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('537', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('537', 'a', 'Source of data note (NR)', 'Source of data note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('538', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('538', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('538', 'a', 'System details note', 'System details note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('540', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('540', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('540', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('540', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('540', 'a', 'Terms governing use and reproduction', 'Terms governing use and reproduction', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('540', 'b', 'Jurisdiction', 'Jurisdiction', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('540', 'c', 'Authorization', 'Authorization', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('540', 'd', 'Authorized users', 'Authorized users', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'a', 'Source of acquisition', 'Source of acquisition', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'b', 'Address', 'Address', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'e', 'Accession number', 'Accession number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'f', 'Owner', 'Owner', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'h', 'Purchase price', 'Purchase price', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'n', 'Extent', 'Extent', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('543', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('543', 'a', 'Solicitation information note (NR)', 'Solicitation information note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', 'a', 'Custodian', 'Custodian', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', 'b', 'Address', 'Address', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', 'c', 'Country', 'Country', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', 'd', 'Title', 'Title', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', 'e', 'Provenance', 'Provenance', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('544', 'n', 'Note', 'Note', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('545', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('545', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('545', 'a', 'Biographical or historical note', 'Biographical or historical note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('545', 'b', 'Expansion', 'Expansion', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('545', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('546', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('546', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('546', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('546', 'a', 'Language note', 'Language note', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('546', 'b', 'Information code or alphabet', 'Information code or alphabet', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('546', 'z', 'Source of note information (NR) (SE) [OBSOLETE]', 'Source of note information (NR) (SE) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('547', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('547', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('547', 'a', 'Former title complexity note', 'Former title complexity note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('547', 'z', 'Source of note information (NR) (SE) [OBSOLETE]', 'Source of note information (NR) (SE) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('550', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('550', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('550', 'a', 'Issuing body note', 'Issuing body note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('550', 'z', 'Source of note information (NR) (SE) [OBSOLETE]', 'Source of note information (NR) (SE) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'a', 'Entity type label', 'Entity type label', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'b', 'Entity type definition and source', 'Entity type definition and source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'c', 'Attribute label', 'Attribute label', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'd', 'Attribute definition and source', 'Attribute definition and source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'e', 'Enumerated domain value', 'Enumerated domain value', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'f', 'Enumerated domain value definition and source', 'Enumerated domain value definition and source', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'g', 'Range domain minimum and maximum', 'Range domain minimum and maximum', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'h', 'Codeset name and source', 'Codeset name and source', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'i', 'Unrepresentable domain', 'Unrepresentable domain', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'j', 'Attribute units of measurement and resolution', 'Attribute units of measurement and resolution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'k', 'Beginning date and ending date of attribute values', 'Beginning date and ending date of attribute values', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'l', 'Attribute value accuracy', 'Attribute value accuracy', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'm', 'Attribute value accuracy explanation', 'Attribute value accuracy explanation', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'n', 'Attribute measurement frequency', 'Attribute measurement frequency', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'o', 'Entity and attribute overview', 'Entity and attribute overview', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'p', 'Entity and attribute detail citation', 'Entity and attribute detail citation', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('552', 'z', 'Display note', 'Display note', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('555', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('555', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('555', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); @@ -980,16 +440,6 @@ INSERT INTO marc_subfield_structure VALUES ('555', 'b', 'Availability source', ' INSERT INTO marc_subfield_structure VALUES ('555', 'c', 'Degree of control', 'Degree of control', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('555', 'd', 'Bibliographic reference', 'Bibliographic reference', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('555', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('556', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('556', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('556', 'a', 'Information about documentation note', 'Information about documentation note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('556', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('561', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('561', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('561', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('561', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('561', 'a', 'History', 'History', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('561', 'b', 'Time of collation (NR) [OBSOLETE]', 'Time of collation (NR) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('562', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('562', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('562', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); @@ -999,70 +449,10 @@ INSERT INTO marc_subfield_structure VALUES ('562', 'b', 'Copy identification', ' INSERT INTO marc_subfield_structure VALUES ('562', 'c', 'Version identification', 'Version identification', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('562', 'd', 'Presentation format', 'Presentation format', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('562', 'e', 'Number of copies', 'Number of copies', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('565', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('565', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('565', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('565', 'a', 'Number of cases/variables', 'Number of cases/variables', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('565', 'b', 'Name of variable', 'Name of variable', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('565', 'c', 'Unit of analysis', 'Unit of analysis', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('565', 'd', 'Universe of data', 'Universe of data', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('565', 'e', 'Filing scheme or code', 'Filing scheme or code', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('567', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('567', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('567', 'a', 'Methodology note', 'Methodology note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('570', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('570', 'a', 'Editor note (NR)', 'Editor note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('570', 'z', 'Source of note information (NR)', 'Source of note information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('580', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('580', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('580', 'a', 'Linking entry complexity note', 'Linking entry complexity note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('580', 'z', 'Source of note information (NR) [OBSOLETE]', 'Source of note information (NR) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('581', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('581', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('581', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('581', 'a', 'Publications about described materials note', 'Publications about described materials note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('581', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('582', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('582', 'a', 'Related computer files note (NR)', 'Related computer files note (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', '2', 'Source of term', 'Source of term', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'a', 'Action', 'Action', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'b', 'Action identification', 'Action identification', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'c', 'Time/date of action', 'Time/date of action', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'd', 'Action interval', 'Action interval', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'f', 'Authorization', 'Authorization', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'h', 'Jurisdiction', 'Jurisdiction', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'i', 'Method of action', 'Method of action', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'j', 'Site of action', 'Site of action', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'k', 'Action agent', 'Action agent', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'l', 'Status', 'Status', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'n', 'Extent', 'Extent', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'o', 'Type of unit', 'Type of unit', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('583', 'z', 'Public note', 'Public note', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('584', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('584', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('584', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('584', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('584', 'a', 'Accumulation', 'Accumulation', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('584', 'b', 'Frequency of use', 'Frequency of use', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('585', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('585', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('585', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('585', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('585', 'a', 'Exhibitions note', 'Exhibitions note', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('586', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('586', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('586', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('586', 'a', 'Awards note', 'Awards note', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('590', 'a', 'Receipt date (NR)', 'Receipt date (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('590', 'b', 'Provenance (NR)', 'Provenance (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('590', 'd', 'Origin of safety copy (NR)', 'Origin of safety copy (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('600', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('600', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('600', '4', 'Relator code', 'Relator code', 1, 0, NULL, -1, NULL, NULL, ''); @@ -1166,19 +556,19 @@ INSERT INTO marc_subfield_structure VALUES ('630', 'v', 'Form subdivision', 'For INSERT INTO marc_subfield_structure VALUES ('630', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('630', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('630', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'a', 'Topical term or geographic name as entry element', 'Topical term or geographic name as entry element', 0, 0, 'biblio.subject', -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'b', 'Topical term following geographic name as entry element', 'Topical term following geographic name as entry element', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'c', 'Location of event', 'Location of event', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'd', 'Active dates', 'Active dates', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'e', 'Relator term', 'Relator term', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'v', 'Form subdivision', 'Form subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('650', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, -1, NULL, NULL, ''); +INSERT INTO marc_subfield_structure VALUES ('650', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', '3', 'Materials specified', 'Materials specified', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'a', 'Topical term or geographic name as entry element', 'Topical term or geographic name as entry element', 0, 0, '', 3, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'b', 'Topical term following geographic name as entry element', 'Topical term following geographic name as entry element', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'c', 'Location of event', 'Location of event', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'd', 'Active dates', 'Active dates', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'e', 'Relator term', 'Relator term', 0, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'v', 'Form subdivision', 'Form subdivision', 1, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'x', 'General subdivision', 'General subdivision', 1, 0, '', 3, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, '', -1, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('650', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('651', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('651', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('651', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); @@ -1189,23 +579,9 @@ INSERT INTO marc_subfield_structure VALUES ('651', 'v', 'Form subdivision', 'For INSERT INTO marc_subfield_structure VALUES ('651', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('651', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('651', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('652', 'a', 'Geographic name of place element (NR)', 'Geographic name of place element (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('652', 'x', 'General subdivision (R)', 'General subdivision (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('652', 'y', 'Chronological subdivision (R)', 'Chronological subdivision (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('652', 'z', 'Geographic subdivision (R)', 'Geographic subdivision (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('653', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('653', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('653', 'a', 'Uncontrolled term', 'Uncontrolled term', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', '2', 'Source of heading or term', 'Source of heading or term', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', 'a', 'Focus term', 'Focus term', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', 'b', 'Non-focus term', 'Non-focus term', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', 'c', 'Facet/hierarchy designation', 'Facet/hierarchy designation', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', 'v', 'Form subdivision', 'Form subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('654', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('655', '2', 'Source of term', 'Source of term', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('655', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('655', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); @@ -1218,32 +594,6 @@ INSERT INTO marc_subfield_structure VALUES ('655', 'v', 'Form subdivision', 'For INSERT INTO marc_subfield_structure VALUES ('655', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('655', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('655', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', '2', 'Source of term', 'Source of term', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', 'a', 'Occupation', 'Occupation', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', 'k', 'Form', 'Form', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', 'v', 'Form subdivision', 'Form subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('656', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', '2', 'Source of term', 'Source of term', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', 'a', 'Function', 'Function', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', 'v', 'Form subdivision', 'Form subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', 'x', 'General subdivision', 'General subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', 'y', 'Chronological subdivision', 'Chronological subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('657', 'z', 'Geographic subdivision', 'Geographic subdivision', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('658', '2', 'Source of term or code', 'Source of term or code', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('658', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('658', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('658', 'a', 'Main curriculum objective', 'Main curriculum objective', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('658', 'b', 'Subordinate curriculum objective', 'Subordinate curriculum objective', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('658', 'c', 'Curriculum code', 'Curriculum code', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('658', 'd', 'Correlation factor', 'Correlation factor', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('700', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('700', '4', 'Relator code', 'Relator code', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('700', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); @@ -1270,23 +620,6 @@ INSERT INTO marc_subfield_structure VALUES ('700', 's', 'Version', 'Version', 0, INSERT INTO marc_subfield_structure VALUES ('700', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('700', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('700', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'a', 'Personal name (NR)', 'Personal name (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'b', 'Numeration (NR)', 'Numeration (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'c', 'Titles and other words associated with a name (R)', 'Titles and other words associated with a name (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'd', 'Dates associated with a name (NR)', 'Dates associated with a name (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'e', 'Relator term (R)', 'Relator term (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'f', 'Date of a work (NR)', 'Date of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'g', 'Miscellaneous information (NR)', 'Miscellaneous information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'h', 'Medium (NR)', 'Medium (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'k', 'Form subheading (R)', 'Form subheading (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'l', 'Language of a work (NR)', 'Language of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'm', 'Medium of performance for music (R)', 'Medium of performance for music (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'n', 'Number of part/section of a work (R)', 'Number of part/section of a work (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'o', 'Arranged statement for music (NR)', 'Arranged statement for music (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'p', 'Name of part/section of a work (R)', 'Name of part/section of a work (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 'r', 'Key for music (NR)', 'Key for music (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 's', 'Version (NR)', 'Version (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('705', 't', 'Title of a work (NR)', 'Title of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('710', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('710', '4', 'Relator code', 'Relator code', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('710', '5', 'Institution to which field applies "See "', 'Institution to which field applies "See "', 0, 0, NULL, -1, NULL, NULL, ''); @@ -1333,22 +666,6 @@ INSERT INTO marc_subfield_structure VALUES ('711', 's', 'Version', 'Version', 0, INSERT INTO marc_subfield_structure VALUES ('711', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('711', 'u', 'Affiliation', 'Affiliation', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('711', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'a', 'Corporate name or jurisdiction name (NR)', 'Corporate name or jurisdiction name (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'b', 'Subordinate unit (R)', 'Subordinate unit (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'e', 'Relator term (R)', 'Relator term (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'f', 'Date of a work (NR)', 'Date of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'g', 'Miscellaneous information (NR)', 'Miscellaneous information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'h', 'Medium (NR)', 'Medium (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'k', 'Form subheading (R)', 'Form subheading (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'l', 'Language of a work (NR)', 'Language of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'm', 'Medium of performance for music (R)', 'Medium of performance for music (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'n', 'Number of part/section/meeting (R)', 'Number of part/section/meeting (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'o', 'Arranged statement for music (NR)', 'Arranged statement for music (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'p', 'Name of part/section of a work (R)', 'Name of part/section of a work (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'r', 'Key for music (NR)', 'Key for music (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 's', 'Version (NR)', 'Version (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 't', 'Title of a work (NR)', 'Title of a work (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('715', 'u', 'Nonprinting information (NR)', 'Nonprinting information (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('720', '4', 'Relator code', 'Relator code', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('720', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('720', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); @@ -1391,18 +708,6 @@ INSERT INTO marc_subfield_structure VALUES ('753', '8', 'Field link and sequence INSERT INTO marc_subfield_structure VALUES ('753', 'a', 'Make and model of machine', 'Make and model of machine', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('753', 'b', 'Programming language', 'Programming language', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('753', 'c', 'Operating system', 'Operating system', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('754', '2', 'Source of taxonomic identification', 'Source of taxonomic identification', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('754', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('754', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('754', 'a', 'Taxonomic name/taxonomic hierarchical category', 'Taxonomic name/taxonomic hierarchical category', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('755', '2', 'Source of term (NR)', 'Source of term (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('755', '3', 'Materials specified (NR)', 'Materials specified (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('755', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('755', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('755', 'a', 'Access term (NR)', 'Access term (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('755', 'x', 'General subdivision (R)', 'General subdivision (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('755', 'y', 'Chronological subdivision (R)', 'Chronological subdivision (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('755', 'z', 'Geographic subdivision (R)', 'Geographic subdivision (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('760', '6', 'Linkage "See', 'Linkage "See', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('760', '7', 'Control subfield (NR) 0 - Type of main entry heading 1 - Form of name 2 - Type of record 3 - Bibliographic level', 'Control subfield (NR) 0 - Type of main entry heading 1 - Form of name 2 - Type of record 3 - Bibliographic level', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('760', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); @@ -1692,31 +997,6 @@ INSERT INTO marc_subfield_structure VALUES ('785', 'w', 'Record control number', INSERT INTO marc_subfield_structure VALUES ('785', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('785', 'y', 'CODEN designation', 'CODEN designation', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('785', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', '7', 'Control subfield', 'Control subfield', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'a', 'Main entry heading', 'Main entry heading', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'b', 'Edition', 'Edition', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'c', 'Qualifying information', 'Qualifying information', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'd', 'Place, publisher, and date of publication', 'Place, publisher, and date of publication', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'g', 'Relationship information', 'Relationship information', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'h', 'Physical description', 'Physical description', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'i', 'Display text', 'Display text', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'j', 'Period of content', 'Period of content', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'k', 'Series data for related item', 'Series data for related item', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'm', 'Material-specific details', 'Material-specific details', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'n', 'Note', 'Note', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'o', 'Other item identifier', 'Other item identifier', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'p', 'Abbreviated title', 'Abbreviated title', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'r', 'Report number', 'Report number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 's', 'Uniform title', 'Uniform title', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 't', 'Title', 'Title', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'u', 'Standard Technical Report Number', 'Standard Technical Report Number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'v', 'Source Contribution', 'Source Contribution', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'w', 'Record control number', 'Record control number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'x', 'International Standard Serial Number', 'International Standard Serial Number', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'y', 'CODEN designation', 'CODEN designation', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('786', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('787', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('787', '7', 'Control subfield', 'Control subfield', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('787', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); @@ -1822,9 +1102,6 @@ INSERT INTO marc_subfield_structure VALUES ('830', 'r', 'Key for music', 'Key fo INSERT INTO marc_subfield_structure VALUES ('830', 's', 'Version', 'Version', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('830', 't', 'Title of a work', 'Title of a work', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('830', 'v', 'Volume number/sequential designation', 'Volume number/sequential designation', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('840', 'a', 'Title (NR)', 'Title (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('840', 'h', 'Medium (NR)', 'Medium (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('840', 'v', 'Volume or number (NR)', 'Volume or number (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('841', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('841', 'a', 'Holding institution', 'Holding institution', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('850', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); @@ -1832,15 +1109,6 @@ INSERT INTO marc_subfield_structure VALUES ('850', 'a', 'Holding institution (R) INSERT INTO marc_subfield_structure VALUES ('850', 'b', 'Holdings (NR) (MU VM SE) [OBSOLETE]', 'Holdings (NR) (MU VM SE) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('850', 'd', 'Inclusive dates (NR) (MU VM SE) [OBSOLETE]', 'Inclusive dates (NR) (MU VM SE) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('850', 'e', 'Retention statement (NR) (CF MU VM SE) [OBSOLETE]', 'Retention statement (NR) (CF MU VM SE) [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', '3', 'Materials specified (NR)', 'Materials specified (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', 'a', 'Name (custodian or owner) (NR)', 'Name (custodian or owner) (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', 'b', 'Institutional division (NR)', 'Institutional division (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', 'c', 'Street address (NR)', 'Street address (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', 'd', 'Country (NR)', 'Country (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', 'e', 'Location of units (NR)', 'Location of units (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', 'f', 'Item number (NR)', 'Item number (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('851', 'g', 'Repository location code (NR)', 'Repository location code (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('852', '2', 'Source of classification or shelving scheme (NR)', 'Source of classification or shelving scheme (NR)', 0, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', '3', 'Materials specified (NR)', 'Materials specified (NR)', 0, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, '', -1, '', '', ''); @@ -1854,7 +1122,7 @@ INSERT INTO marc_subfield_structure VALUES ('852', 'g', 'Non-coded location qual INSERT INTO marc_subfield_structure VALUES ('852', 'h', 'Classification part (NR)', 'Classification part (NR)', 0, 0, 'biblioitems.classification', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', 'i', 'Item part (R)', 'Item part (R)', 1, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', 'j', 'Shelving control number (NR)', 'Shelving control number (NR)', 0, 0, '', -1, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('852', 'k', 'Call number prefix (NR)', 'Call number prefix (NR)', 0, 1, 'biblioitems.dewey', 0, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('852', 'k', 'Call number prefix (NR)', 'Call number prefix (NR)', 0, 1, 'biblioitems.dewey', 0, 'itemtypes', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', 'l', 'Shelving form of title (NR)', 'Shelving form of title (NR)', 0, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', 'm', 'Call number suffix (NR)', 'Call number suffix (NR)', 0, 0, 'biblioitems.subclass', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', 'n', 'Country code (NR)', 'Country code (NR)', 0, 0, '', -1, '', '', ''); @@ -1864,34 +1132,6 @@ INSERT INTO marc_subfield_structure VALUES ('852', 's', 'Copyright article-fee c INSERT INTO marc_subfield_structure VALUES ('852', 't', 'Copy number (NR)', 'Copy number (NR)', 0, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', 'x', 'Nonpublic note (R)', 'Nonpublic note (R)', 1, 0, '', -1, '', '', ''); INSERT INTO marc_subfield_structure VALUES ('852', 'z', 'Public note (R)', 'Public note (R)', 1, 0, '', -1, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('853', '2', 'Access method', 'Access method', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', '6', 'Linkage "See "', 'Linkage "See "', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', '8', 'Field link and sequence number "See "', 'Field link and sequence number "See "', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'a', 'Host name', 'Host name', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'b', 'Access number', 'Access number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'c', 'Compression information', 'Compression information', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'd', 'Path', 'Path', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'f', 'Electronic name', 'Electronic name', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'h', 'Processor of request', 'Processor of request', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'i', 'Instruction', 'Instruction', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'j', 'Bits per second', 'Bits per second', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'k', 'Password', 'Password', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'l', 'Logon', 'Logon', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'm', 'Contact for access assistance', 'Contact for access assistance', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'n', 'Name of location of host', 'Name of location of host', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'o', 'Operating system', 'Operating system', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'p', 'Port', 'Port', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'q', 'Electronic format type', 'Electronic format type', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'r', 'Settings', 'Settings', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 's', 'File size', 'File size', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 't', 'Terminal emulation', 'Terminal emulation', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'v', 'Hours access method available', 'Hours access method available', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'w', 'Record control number', 'Record control number', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'y', 'Link text', 'Link text', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('853', 'z', 'Public note', 'Public note', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('856', '2', 'Access method (NR)', 'Access method (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('856', '3', 'Materials specified (NR)', 'Materials specified (NR)', 0, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('856', '6', 'Linkage (NR)', 'Linkage (NR)', 0, 0, NULL, -1, NULL, NULL, ''); @@ -1921,217 +1161,94 @@ INSERT INTO marc_subfield_structure VALUES ('856', 'w', 'Record control number ( INSERT INTO marc_subfield_structure VALUES ('856', 'x', 'Nonpublic note (R)', 'Nonpublic note (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('856', 'y', 'Link text (R)', 'Link text (R)', 1, 0, NULL, -1, NULL, NULL, ''); INSERT INTO marc_subfield_structure VALUES ('856', 'z', 'Public note (R)', 'Public note (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('863', '8', ' (R)', ' (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', '8', 'Field link and sequence number (R)', 'Field link and sequence number (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', 'b', 'Home branch (NR)', 'Home branch (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', 'c', 'Cost (R)', 'Cost (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', 'd', 'Date acquired (R)', 'Date acquired (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', 'e', 'Source of acquisition (R)', 'Source of acquisition (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', 'j', 'Item status (R)', 'Item status (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', 'l', 'Temporary location (R)', 'Temporary location (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', 'p', 'Piece designation (R)', 'Piece designation (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('876', 'z', 'Note (R)', 'Note (R)', 1, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('880', '6', 'Linkage (NR) -z Same as associated field', 'Linkage (NR) -z Same as associated field', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('886', '2', 'Source of data (NR) -z - Foreign MARC subfield (R)', 'Source of data (NR) -z - Foreign MARC subfield (R)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('886', 'a', 'Tag of the foreign MARC field (NR)', 'Tag of the foreign MARC field (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('886', 'b', 'Content of the foreign MARC field (NR)', 'Content of the foreign MARC field (NR)', 0, 0, NULL, -1, NULL, NULL, ''); -INSERT INTO marc_subfield_structure VALUES ('995', 'd', 'homebranch', 'homebranch', 1, 0, 'items.homebranch', 10, 'branches', '', ''); -INSERT INTO marc_subfield_structure VALUES ('995', 'f', 'barcode', 'barcode', 1, 0, 'items.barcode', 10, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('995', 'm', 'dateaccessioned', 'dateaccessioned', 1, 0, 'items.dateaccessioned', 10, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('995', 'o', 'notforloan', 'notforloan', 1, 0, 'items.notforloan', 10, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('995', 's', 'Koha item number', 'Koha item number', 1, 0, 'items.itemnumber', -1, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('995', 'u', 'item notes', 'item notes', 1, 0, 'items.itemnotes', 10, '', '', ''); -INSERT INTO marc_subfield_structure VALUES ('995', 'c', 'holdingbranch', 'holdingbranch', 0, 0, 'items.holdingbranch', 10, 'branches', '', NULL); +INSERT INTO marc_subfield_structure VALUES ('952', 'b', 'homebranch', 'homebranch', 0, 0, 'items.homebranch', 10, 'branches', '', ''); +INSERT INTO marc_subfield_structure VALUES ('952', 'd', 'holdingbranch', 'holdingbranch', 0, 0, 'items.holdingbranch', 10, 'branches', '', ''); +INSERT INTO marc_subfield_structure VALUES ('952', 'p', 'barcode', 'barcode', 0, 0, 'items.barcode', 10, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('952', 'r', 'price', 'price', 0, 0, 'items.price', 10, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('952', 'v', 'dateaccessioned', 'dateaccessioned', 0, 0, 'items.dateaccessioned', 10, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('952', 'y', 'notforloan', 'notforloan', 0, 0, 'items.notforloan', 10, '', '', ''); +INSERT INTO marc_subfield_structure VALUES ('952', 'u', 'itemnumber', 'itemnumber', 0, 0, 'items.itemnumber', -1, '', '', ''); # # Contenu de la table `marc_tag_structure` # INSERT INTO marc_tag_structure VALUES ('010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, ''); -INSERT INTO marc_tag_structure VALUES ('011', 'LINKING LIBRARY OF CONGRESS CONTROL NUMBER (BK MP MU SE VM) [OBSOLETE]', 'LINKING LIBRARY OF CONGRESS CONTROL NUMBER (BK MP MU SE VM) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('013', 'PATENT CONTROL INFORMATION', 'PATENT CONTROL INFORMATION', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('015', 'NATIONAL BIBLIOGRAPHY NUMBER', 'NATIONAL BIBLIOGRAPHY NUMBER', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('016', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 'NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('017', 'COPYRIGHT REGISTRATION NUMBER', 'COPYRIGHT REGISTRATION NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('018', 'COPYRIGHT ARTICLE-FEE CODE', 'COPYRIGHT ARTICLE-FEE CODE', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('023', 'STANDARD FILM NUMBER [DELETED]', 'STANDARD FILM NUMBER [DELETED]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('024', 'OTHER STANDARD IDENTIFIER', 'OTHER STANDARD IDENTIFIER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('025', 'OVERSEAS ACQUISITION NUMBER', 'OVERSEAS ACQUISITION NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('027', 'STANDARD TECHNICAL REPORT NUMBER', 'STANDARD TECHNICAL REPORT NUMBER', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('028', 'PUBLISHER NUMBER', 'PUBLISHER NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('030', 'CODEN DESIGNATION', 'CODEN DESIGNATION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('032', 'POSTAL REGISTRATION NUMBER', 'POSTAL REGISTRATION NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('033', 'DATE/TIME AND PLACE OF AN EVENT', 'DATE/TIME AND PLACE OF AN EVENT', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('034', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 'CODED CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('035', 'SYSTEM CONTROL NUMBER', 'SYSTEM CONTROL NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('036', 'ORIGINAL STUDY NUMBER FOR COMPUTER DATA FILES', 'ORIGINAL STUDY NUMBER FOR COMPUTER DATA FILES', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('037', 'SOURCE OF ACQUISITION', 'SOURCE OF ACQUISITION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('039', 'LEVEL OF BIBLIOGRAPHIC CONTROL AND CODING DETAIL [OBSOLETE]', 'LEVEL OF BIBLIOGRAPHIC CONTROL AND CODING DETAIL [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('040', 'CATALOGING SOURCE', 'CATALOGING SOURCE', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('041', 'LANGUAGE CODE', 'LANGUAGE CODE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('042', 'AUTHENTICATION CODE', 'AUTHENTICATION CODE', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('043', 'GEOGRAPHIC AREA CODE', 'GEOGRAPHIC AREA CODE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('044', 'COUNTRY OF PUBLISHING/PRODUCING ENTITY CODE', 'COUNTRY OF PUBLISHING/PRODUCING ENTITY CODE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('045', 'TIME PERIOD OF CONTENT', 'TIME PERIOD OF CONTENT', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('046', 'SPECIAL CODED DATES', 'SPECIAL CODED DATES', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('047', 'FORM OF MUSICAL COMPOSITION CODE', 'FORM OF MUSICAL COMPOSITION CODE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('048', 'NUMBER OF MUSICAL INSTRUMENTS OR VOICES CODE', 'NUMBER OF MUSICAL INSTRUMENTS OR VOICES CODE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('051', 'LIBRARY OF CONGRESS COPY, ISSUE, OFFPRINT STATEMENT', 'LIBRARY OF CONGRESS COPY, ISSUE, OFFPRINT STATEMENT', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('052', 'GEOGRAPHIC CLASSIFICATION CODE', 'GEOGRAPHIC CLASSIFICATION CODE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('055', 'CALL NUMBERS/CLASS NUMBERS ASSIGNED IN CANADA', 'CALL NUMBERS/CLASS NUMBERS ASSIGNED IN CANADA', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('060', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 'NATIONAL LIBRARY OF MEDICINE CALL NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('061', 'NATIONAL LIBRARY OF MEDICINE COPY STATEMENT', 'NATIONAL LIBRARY OF MEDICINE COPY STATEMENT', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('066', 'CHARACTER SETS PRESENT', 'CHARACTER SETS PRESENT', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('070', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 'NATIONAL AGRICULTURAL LIBRARY CALL NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('071', 'NATIONAL AGRICULTURAL LIBRARY COPY STATEMENT', 'NATIONAL AGRICULTURAL LIBRARY COPY STATEMENT', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('072', 'SUBJECT CATEGORY CODE', 'SUBJECT CATEGORY CODE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('074', 'GPO ITEM NUMBER', 'GPO ITEM NUMBER', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('080', 'UNIVERSAL DECIMAL CLASSIFICATION NUMBER', 'UNIVERSAL DECIMAL CLASSIFICATION NUMBER', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('082', 'DEWEY DECIMAL CALL NUMBER', 'DEWEY DECIMAL CALL NUMBER', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('084', 'OTHER CLASSIFICATION NUMBER', 'OTHER CLASSIFICATION NUMBER', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('086', 'GOVERNMENT DOCUMENT CALL NUMBER', 'GOVERNMENT DOCUMENT CALL NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('088', 'REPORT NUMBER', 'REPORT NUMBER', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('090', 'KOHA DATA', 'KOHA DATA', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('091', 'MICROFILM SHELF LOCATION (AM) [OBSOLETE]', 'MICROFILM SHELF LOCATION (AM) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('100', 'MAIN ENTRY--PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('110', 'MAIN ENTRY--CORPORATE NAME', 'MAIN ENTRY--CORPORATE NAME', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('111', 'MAIN ENTRY--MEETING NAME', 'MAIN ENTRY--MEETING NAME', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('130', 'MAIN ENTRY--UNIFORM TITLE', 'MAIN ENTRY--UNIFORM TITLE', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('210', 'ABBREVIATED TITLE', 'ABBREVIATED TITLE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('211', 'ACRONYM OR SHORTENED TITLE [OBSOLETE]', 'ACRONYM OR SHORTENED TITLE [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('212', 'VARIANT ACCESS TITLE [OBSOLETE]', 'VARIANT ACCESS TITLE [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('214', 'AUGMENTED TITLE [OBSOLETE]', 'AUGMENTED TITLE [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('222', 'KEY TITLE', 'KEY TITLE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('240', 'UNIFORM TITLE', 'UNIFORM TITLE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('241', 'ROMANIZED TITLE (BK AM CF MP MU VM) [OBSOLETE]', 'ROMANIZED TITLE (BK AM CF MP MU VM) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('242', 'TRANSLATION OF TITLE BY CATALOGING AGENCY', 'TRANSLATION OF TITLE BY CATALOGING AGENCY', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('243', 'COLLECTIVE UNIFORM TITLE', 'COLLECTIVE UNIFORM TITLE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 0, NULL); +INSERT INTO marc_tag_structure VALUES ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, ''); INSERT INTO marc_tag_structure VALUES ('246', 'VARYING FORM OF TITLE', 'VARYING FORM OF TITLE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('247', 'FORMER TITLE OR TITLE VARIATIONS', 'FORMER TITLE OR TITLE VARIATIONS', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('254', 'MUSICAL PRESENTATION STATEMENT', 'MUSICAL PRESENTATION STATEMENT', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('255', 'CARTOGRAPHIC MATHEMATICAL DATA', 'CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('257', 'COUNTRY OF PRODUCING ENTITY FOR ARCHIVAL FILMS', 'COUNTRY OF PRODUCING ENTITY FOR ARCHIVAL FILMS', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('261', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [LOCAL]', 'IMPRINT STATEMENT FOR FILMS (Pre-AACR 1 Revised) [LOCAL]', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('262', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL]', 'IMPRINT STATEMENT FOR SOUND RECORDINGS (Pre-AACR 2) [LOCAL]', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('263', 'PROJECTED PUBLICATION DATE', 'PROJECTED PUBLICATION DATE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('265', 'SOURCE FOR ACQUISITION/SUBSCRIPTION ADDRESS [OBSOLETE]', 'SOURCE FOR ACQUISITION/SUBSCRIPTION ADDRESS [OBSOLETE]', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('270', 'ADDRESS', 'ADDRESS', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('301', 'PHYSICAL DESCRIPTION FOR FILMS (PRE-AACR 2) (VM) [OBSOLETE]', 'PHYSICAL DESCRIPTION FOR FILMS (PRE-AACR 2) (VM) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('302', 'PAGE OR ITEM COUNT (BK AM) [OBSOLETE]', 'PAGE OR ITEM COUNT (BK AM) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('303', 'UNIT COUNT (AM) [OBSOLETE]', 'UNIT COUNT (AM) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('304', 'LINEAR FOOTAGE (AM) [OBSOLETE]', 'LINEAR FOOTAGE (AM) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('305', 'PHYSICAL DESCRIPTION FOR SOUND RECORDINGS (Pre-AACR 2) (MU) [OBSOLETE]', 'PHYSICAL DESCRIPTION FOR SOUND RECORDINGS (Pre-AACR 2) (MU) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('306', 'PLAYING TIME', 'PLAYING TIME', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('307', 'HOURS, ETC.', 'HOURS, ETC.', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('308', 'PHYSICAL DESCRIPTION FOR FILMS (ARCHIVAL) (VM) [OBSOLETE]', 'PHYSICAL DESCRIPTION FOR FILMS (ARCHIVAL) (VM) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('310', 'CURRENT PUBLICATION FREQUENCY', 'CURRENT PUBLICATION FREQUENCY', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('315', 'FREQUENCY (CF MP) [OBSOLETE]', 'FREQUENCY (CF MP) [OBSOLETE]', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('321', 'FORMER PUBLICATION FREQUENCY', 'FORMER PUBLICATION FREQUENCY', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('340', 'PHYSICAL MEDIUM', 'PHYSICAL MEDIUM', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('342', 'GEOSPATIAL REFERENCE DATA', 'GEOSPATIAL REFERENCE DATA', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('343', 'PLANAR COORDINATE DATA', 'PLANAR COORDINATE DATA', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('350', 'PRICE (BK AM CF MU VM SE) [OBSOLETE]', 'PRICE (BK AM CF MU VM SE) [OBSOLETE]', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('351', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 'ORGANIZATION AND ARRANGEMENT OF MATERIALS', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('352', 'DIGITAL GRAPHIC REPRESENTATION', 'DIGITAL GRAPHIC REPRESENTATION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('355', 'SECURITY CLASSIFICATION CONTROL', 'SECURITY CLASSIFICATION CONTROL', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('357', 'ORIGINATOR DISSEMINATION CONTROL', 'ORIGINATOR DISSEMINATION CONTROL', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('359', 'RENTAL PRICE (VM) [OBSOLETE]', 'RENTAL PRICE (VM) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('362', 'DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 'DATES OF PUBLICATION AND/OR SEQUENTIAL DESIGNATION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('400', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [US-LOCAL]', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [US-LOCAL]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('410', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [US-LOCAL]', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [US-LOCAL]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('411', 'SERIES STATEMENT/ADDED ENTRY--MEETING NAME [US-LOCAL]', 'SERIES STATEMENT/ADDED ENTRY--MEETING NAME [US-LOCAL]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('440', 'SERIES STATEMENT/ADDED ENTRY--TITLE', 'SERIES STATEMENT/ADDED ENTRY--TITLE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('490', 'SERIES STATEMENT', 'SERIES STATEMENT', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('501', 'WITH NOTE', 'WITH NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('502', 'DISSERTATION NOTE', 'DISSERTATION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('503', 'BIBLIOGRAPHIC HISTORY NOTE (BK CF MU) [OBSOLETE]', 'BIBLIOGRAPHIC HISTORY NOTE (BK CF MU) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('504', 'BIBLIOGRAPHY, ETC. NOTE', 'BIBLIOGRAPHY, ETC. NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('505', 'FORMATTED CONTENTS NOTE', 'FORMATTED CONTENTS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('506', 'RESTRICTIONS ON ACCESS NOTE', 'RESTRICTIONS ON ACCESS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('507', 'SCALE NOTE FOR GRAPHIC MATERIAL', 'SCALE NOTE FOR GRAPHIC MATERIAL', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('508', 'CREATION/PRODUCTION CREDITS NOTE', 'CREATION/PRODUCTION CREDITS NOTE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('510', 'CITATION/REFERENCES NOTE', 'CITATION/REFERENCES NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('511', 'PARTICIPANT OR PERFORMER NOTE', 'PARTICIPANT OR PERFORMER NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('512', 'EARLIER OR LATER VOLUMES SEPARATELY CATALOGED NOTE (SE) [OBSOLETE]', 'EARLIER OR LATER VOLUMES SEPARATELY CATALOGED NOTE (SE) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('513', 'TYPE OF REPORT AND PERIOD COVERED NOTE', 'TYPE OF REPORT AND PERIOD COVERED NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('514', 'DATA QUALITY NOTE', 'DATA QUALITY NOTE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('515', 'NUMBERING PECULIARITIES NOTE', 'NUMBERING PECULIARITIES NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('516', 'TYPE OF COMPUTER FILE OR DATA NOTE', 'TYPE OF COMPUTER FILE OR DATA NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('517', 'CATEGORIES OF FILMS NOTE (ARCHIVAL) (VM) [OBSOLETE]', 'CATEGORIES OF FILMS NOTE (ARCHIVAL) (VM) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('518', 'DATE/TIME AND PLACE OF AN EVENT NOTE', 'DATE/TIME AND PLACE OF AN EVENT NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('520', 'SUMMARY, ETC.', 'SUMMARY, ETC.', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('521', 'TARGET AUDIENCE NOTE', 'TARGET AUDIENCE NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('522', 'GEOGRAPHIC COVERAGE NOTE', 'GEOGRAPHIC COVERAGE NOTE', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('523', 'TIME PERIOD OF CONTENT NOTE (CF) [OBSOLETE]', 'TIME PERIOD OF CONTENT NOTE (CF) [OBSOLETE]', 0, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('524', 'PREFERRED CITATION OF DESCRIBED MATERIALS NOTE', 'PREFERRED CITATION OF DESCRIBED MATERIALS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('525', 'SUPPLEMENT NOTE', 'SUPPLEMENT NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('526', 'STUDY PROGRAM INFORMATION NOTE', 'STUDY PROGRAM INFORMATION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('527', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('530', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('533', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('534', 'ORIGINAL VERSION NOTE', 'ORIGINAL VERSION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('535', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('536', 'FUNDING INFORMATION NOTE', 'FUNDING INFORMATION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('537', 'SOURCE OF DATA NOTE (CF) [OBSOLETE]', 'SOURCE OF DATA NOTE (CF) [OBSOLETE]', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('538', 'SYSTEM DETAILS NOTE', 'SYSTEM DETAILS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('540', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('541', 'IMMEDIATE SOURCE OF ACQUISITION NOTE', 'IMMEDIATE SOURCE OF ACQUISITION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('543', 'SOLICITATION INFORMATION NOTE (AM) [OBSOLETE]', 'SOLICITATION INFORMATION NOTE (AM) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('544', 'LOCATION OF OTHER ARCHIVAL MATERIALS NOTE', 'LOCATION OF OTHER ARCHIVAL MATERIALS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('545', 'BIOGRAPHICAL OR HISTORICAL DATA', 'BIOGRAPHICAL OR HISTORICAL DATA', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('546', 'LANGUAGE NOTE', 'LANGUAGE NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('547', 'FORMER TITLE COMPLEXITY NOTE', 'FORMER TITLE COMPLEXITY NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('550', 'ISSUING BODY NOTE', 'ISSUING BODY NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('552', 'ENTITY AND ATTRIBUTE INFORMATION NOTE', 'ENTITY AND ATTRIBUTE INFORMATION NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('555', 'CUMULATIVE INDEX/FINDING AIDS NOTE', 'CUMULATIVE INDEX/FINDING AIDS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('556', 'INFORMATION ABOUT DOCUMENTATION NOTE', 'INFORMATION ABOUT DOCUMENTATION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('561', 'OWNERSHIP AND CUSTODIAL HISTORY', 'OWNERSHIP AND CUSTODIAL HISTORY', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('562', 'COPY AND VERSION IDENTIFICATION NOTE', 'COPY AND VERSION IDENTIFICATION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('565', 'CASE FILE CHARACTERISTICS NOTE', 'CASE FILE CHARACTERISTICS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('567', 'METHODOLOGY NOTE', 'METHODOLOGY NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('570', 'EDITOR NOTE (SE) [OBSOLETE]', 'EDITOR NOTE (SE) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('580', 'LINKING ENTRY COMPLEXITY NOTE', 'LINKING ENTRY COMPLEXITY NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('581', 'PUBLICATIONS ABOUT DESCRIBED MATERIALS NOTE', 'PUBLICATIONS ABOUT DESCRIBED MATERIALS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('582', 'RELATED COMPUTER FILES NOTE (CF) [OBSOLETE]', 'RELATED COMPUTER FILES NOTE (CF) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('583', 'ACTION NOTE', 'ACTION NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('584', 'ACCUMULATION AND FREQUENCY OF USE NOTE', 'ACCUMULATION AND FREQUENCY OF USE NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('585', 'EXHIBITIONS NOTE', 'EXHIBITIONS NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('586', 'AWARDS NOTE', 'AWARDS NOTE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('590', 'RECEIPT DATE NOTE (VM) [OBSOLETE]', 'RECEIPT DATE NOTE (VM) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('600', 'SUBJECT ADDED ENTRY--PERSONAL NAME', 'SUBJECT ADDED ENTRY--PERSONAL NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('610', 'SUBJECT ADDED ENTRY--CORPORATE NAME', 'SUBJECT ADDED ENTRY--CORPORATE NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('611', 'SUBJECT ADDED ENTRY--MEETING NAME', 'SUBJECT ADDED ENTRY--MEETING NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('630', 'SUBJECT ADDED ENTRY--UNIFORM TITLE', 'SUBJECT ADDED ENTRY--UNIFORM TITLE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('650', 'SUBJECT ADDED ENTRY--TOPICAL TERM', 'SUBJECT ADDED ENTRY--TOPICAL TERM', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('651', 'SUBJECT ADDED ENTRY--GEOGRAPHIC NAME', 'SUBJECT ADDED ENTRY--GEOGRAPHIC NAME', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('652', 'SUBJECT ADDED ENTRY--REVERSED GEOGRAPHIC (BK MP SE) [OBSOLETE]', 'SUBJECT ADDED ENTRY--REVERSED GEOGRAPHIC (BK MP SE) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('653', 'INDEX TERM--UNCONTROLLED', 'INDEX TERM--UNCONTROLLED', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('654', 'SUBJECT ADDED ENTRY--FACETED TOPICAL TERMS', 'SUBJECT ADDED ENTRY--FACETED TOPICAL TERMS', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('655', 'INDEX TERM--GENRE/FORM', 'INDEX TERM--GENRE/FORM', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('656', 'INDEX TERM--OCCUPATION', 'INDEX TERM--OCCUPATION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('657', 'INDEX TERM--FUNCTION', 'INDEX TERM--FUNCTION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('658', 'INDEX TERM--CURRICULUM OBJECTIVE', 'INDEX TERM--CURRICULUM OBJECTIVE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('700', 'ADDED ENTRY--PERSONAL NAME', 'ADDED ENTRY--PERSONAL NAME', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('705', 'ADDED ENTRY--PERSONAL NAME (PERFORMER) (MU) [OBSOLETE]', 'ADDED ENTRY--PERSONAL NAME (PERFORMER) (MU) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('710', 'ADDED ENTRY--CORPORATE NAME', 'ADDED ENTRY--CORPORATE NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('711', 'ADDED ENTRY--MEETING NAME', 'ADDED ENTRY--MEETING NAME', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('715', 'ADDED ENTRY--CORPORATE NAME (PERFORMING GROUP) (MU) [OBSOLETE]', 'ADDED ENTRY--CORPORATE NAME (PERFORMING GROUP) (MU) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('720', 'ADDED ENTRY--UNCONTROLLED NAME', 'ADDED ENTRY--UNCONTROLLED NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('730', 'ADDED ENTRY--UNIFORM TITLE', 'ADDED ENTRY--UNIFORM TITLE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('740', 'ADDED ENTRY--UNCONTROLLED RELATED/ANALYTICAL TITLE', 'ADDED ENTRY--UNCONTROLLED RELATED/ANALYTICAL TITLE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('752', 'ADDED ENTRY--HIERARCHICAL PLACE NAME', 'ADDED ENTRY--HIERARCHICAL PLACE NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('753', 'SYSTEM DETAILS ACCESS TO COMPUTER FILES', 'SYSTEM DETAILS ACCESS TO COMPUTER FILES', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('754', 'ADDED ENTRY--TAXONOMIC IDENTIFICATION', 'ADDED ENTRY--TAXONOMIC IDENTIFICATION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('755', 'ADDED ENTRY--PHYSICAL CHARACTERISTICS [OBSOLETE]', 'ADDED ENTRY--PHYSICAL CHARACTERISTICS [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('760', 'MAIN SERIES ENTRY', 'MAIN SERIES ENTRY', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('762', 'SUBSERIES ENTRY', 'SUBSERIES ENTRY', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('765', 'ORIGINAL LANGUAGE ENTRY', 'ORIGINAL LANGUAGE ENTRY', 1, 0, NULL); @@ -2145,39 +1262,21 @@ INSERT INTO marc_tag_structure VALUES ('776', 'ADDITIONAL PHYSICAL FORM ENTRY', INSERT INTO marc_tag_structure VALUES ('777', 'ISSUED WITH ENTRY', 'ISSUED WITH ENTRY', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('780', 'PRECEDING ENTRY', 'PRECEDING ENTRY', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('785', 'SUCCEEDING ENTRY', 'SUCCEEDING ENTRY', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('786', 'DATA SOURCE ENTRY', 'DATA SOURCE ENTRY', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('787', 'NONSPECIFIC RELATIONSHIP ENTRY', 'NONSPECIFIC RELATIONSHIP ENTRY', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('800', 'SERIES ADDED ENTRY--PERSONAL NAME', 'SERIES ADDED ENTRY--PERSONAL NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('810', 'SERIES ADDED ENTRY--CORPORATE NAME', 'SERIES ADDED ENTRY--CORPORATE NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('811', 'SERIES ADDED ENTRY--MEETING NAME', 'SERIES ADDED ENTRY--MEETING NAME', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('830', 'SERIES ADDED ENTRY--UNIFORM TITLE', 'SERIES ADDED ENTRY--UNIFORM TITLE', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('840', 'SERIES ADDED ENTRY--TITLE (BK CF MP MU SE VM MX) [OBSOLETE]', 'SERIES ADDED ENTRY--TITLE (BK CF MP MU SE VM MX) [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('841', 'HOLDINGS CODED DATA VALUES', 'HOLDINGS CODED DATA VALUES', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('842', 'TEXTUAL PHYSICAL FORM DESIGNATOR', 'TEXTUAL PHYSICAL FORM DESIGNATOR', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('843', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('844', 'NAME OF UNIT', 'NAME OF UNIT', 0, 0, NULL); INSERT INTO marc_tag_structure VALUES ('845', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 'TERMS GOVERNING USE AND REPRODUCTION NOTE', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('850', 'HOLDING INSTITUTION', 'HOLDING INSTITUTION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('851', 'LOCATION [OBSOLETE]', 'LOCATION [OBSOLETE]', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('852', 'LOCATION/CALL NUMBER', 'LOCATION/CALL NUMBER', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('853', 'CAPTIONS AND PATTERN--BASIC BIBLIOGRAPHIC UNIT', 'CAPTIONS AND PATTERN--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('854', 'CAPTIONS AND PATTERN--SUPPLEMENTARY MATERIAL', 'CAPTIONS AND PATTERN--SUPPLEMENTARY MATERIAL', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('855', 'CAPTIONS AND PATTERN--INDEXES', 'CAPTIONS AND PATTERN--INDEXES', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('856', 'ELECTRONIC LOCATION AND ACCESS', 'ELECTRONIC LOCATION AND ACCESS', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('863', 'ENUMERATION AND CHRONOLOGY--BASIC BIBLIOGRAPHIC UNIT', 'ENUMERATION AND CHRONOLOGY--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('864', 'ENUMERATION AND CHRONOLOGY--SUPPLEMENTARY MATERIAL', 'ENUMERATION AND CHRONOLOGY--SUPPLEMENTARY MATERIAL', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('865', 'ENUMERATION AND CHRONOLOGY--INDEXES', 'ENUMERATION AND CHRONOLOGY--INDEXES', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('866', 'TEXTUAL HOLDINGS--BASIC BIBLIOGRAPHIC UNIT', 'TEXTUAL HOLDINGS--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('867', 'TEXTUAL HOLDINGS--SUPPLEMENTARY MATERIAL', 'TEXTUAL HOLDINGS--SUPPLEMENTARY MATERIAL', 1, 0, NULL); INSERT INTO marc_tag_structure VALUES ('868', 'TEXTUAL HOLDINGS--INDEXES', 'TEXTUAL HOLDINGS--INDEXES', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('870', 'VARIANT PERSONAL NAME (SE) [OBSOLETE]', 'VARIANT PERSONAL NAME (SE) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('871', 'VARIANT CORPORATE NAME (SE) [OBSOLETE]', 'VARIANT CORPORATE NAME (SE) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('872', 'VARIANT CONFERENCE OR MEETING NAME (SE) [OBSOLETE]', 'VARIANT CONFERENCE OR MEETING NAME (SE) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('873', 'VARIANT UNIFORM TITLE HEADING (SE) [OBSOLETE]', 'VARIANT UNIFORM TITLE HEADING (SE) [OBSOLETE]', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('876', 'ITEM INFORMATION--BASIC BIBLIOGRAPHIC UNIT', 'ITEM INFORMATION--BASIC BIBLIOGRAPHIC UNIT', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('877', 'ITEM INFORMATION--SUPPLEMENTARY MATERIAL', 'ITEM INFORMATION--SUPPLEMENTARY MATERIAL', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('878', 'ITEM INFORMATION--INDEXES', 'ITEM INFORMATION--INDEXES', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('880', 'ALTERNATE GRAPHIC REPRESENTATION', 'ALTERNATE GRAPHIC REPRESENTATION', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('886', 'FOREIGN MARC INFORMATION FIELD', 'FOREIGN MARC INFORMATION FIELD', 1, 0, NULL); -INSERT INTO marc_tag_structure VALUES ('995', '', '', 1, 0, NULL); +INSERT INTO marc_tag_structure VALUES ('952', 'ITEM INFORMATION', 'ITEM INFORMATION', 1, 0, ''); -- 2.39.5