From e624b89b56cb6348a238c6f21ea73d78a0f15071 Mon Sep 17 00:00:00 2001 From: thd Date: Thu, 10 Aug 2006 01:01:23 +0000 Subject: [PATCH] Moved publication, distribution details fields and acquisition info fields to record editor tab 9 for ASMP custom frameworks. --- misc/asmp_marc21_bib_framework.sql | 546 ++++++++++++++--------------- 1 file changed, 273 insertions(+), 273 deletions(-) diff --git a/misc/asmp_marc21_bib_framework.sql b/misc/asmp_marc21_bib_framework.sql index de4d03eab6..17c1095413 100644 --- a/misc/asmp_marc21_bib_framework.sql +++ b/misc/asmp_marc21_bib_framework.sql @@ -2,7 +2,7 @@ -- ASMP KOHA MARC 21 BIBLIOGRAPHIC FRAMEWORKS -- POST-INSTALLATION SCRIPT -- --- PRETEST VERSION 0.0.3 +-- PRETEST VERSION 0.0.4 -- 2006-08-09 -- -- drafted @@ -5031,14 +5031,14 @@ INSERT INTO `marc_subfield_structure` VALUES ('036', '6', 'Linkage', 'Linkage', INSERT INTO `marc_subfield_structure` VALUES ('036', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('036', 'a', 'Original study number', 'Original study number', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('036', 'b', 'Source (agency assigning number)', 'Source (agency assigning number)', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 0, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'b', 'Source of stock number/acquisition', 'Source of stock number/acquisition', 0, 0, '', 0, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'c', 'Terms of availability', 'Terms of availability', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'f', 'Form of issue', 'Form of issue', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'g', 'Additional format characteristics', 'Additional format characteristics', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'n', 'Note', 'Note', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 9, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'b', 'Source of stock number/acquisition', 'Source of stock number/acquisition', 0, 0, '', 9, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'c', 'Terms of availability', 'Terms of availability', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'f', 'Form of issue', 'Form of issue', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'g', 'Additional format characteristics', 'Additional format characteristics', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'n', 'Note', 'Note', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', 'a', 'Record content licensor', 'Record content licensor', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); @@ -5446,27 +5446,27 @@ INSERT INTO `marc_subfield_structure` VALUES ('263', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('263', 'a', 'Projected publication date', 'Projected publication date', 0, 0, '', 2, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('265', '6', 'Linkage [OBSOLETE]', 'Linkage [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('265', 'a', 'Source for acquisition/subscription address [OBSOLETE]', 'Source for acquisition/subscription address [OBSOLETE]', 1, 0, '', 2, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '4', 'Relator code', 'Relator code', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'a', 'Address', 'Address', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'b', 'City', 'City', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'c', 'State or province', 'State or province', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'd', 'Country', 'Country', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'e', 'Postal code', 'Postal code', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'f', 'Terms preceding attention name', 'Terms preceding attention name', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'g', 'Attention name', 'Attention name', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'h', 'Attention position', 'Attention position', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'i', 'Type of address', 'Type of address', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'j', 'Specialized telephone number', 'Specialized telephone number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'k', 'Telephone number', 'Telephone number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'l', 'Fax number', 'Fax number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'm', 'Electronic mail address', 'Electronic mail address', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'n', 'TDD or TTY number', 'TDD or TTY number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'p', 'Contact person', 'Contact person', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'q', 'Title of contact person', 'Title of contact person', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'r', 'Hours', 'Hours', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'z', 'Public note', 'Public note', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '4', 'Relator code', 'Relator code', 1, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '6', 'Linkage', 'Linkage', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'a', 'Address', 'Address', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'b', 'City', 'City', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'c', 'State or province', 'State or province', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'd', 'Country', 'Country', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'e', 'Postal code', 'Postal code', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'f', 'Terms preceding attention name', 'Terms preceding attention name', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'g', 'Attention name', 'Attention name', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'h', 'Attention position', 'Attention position', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'i', 'Type of address', 'Type of address', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'j', 'Specialized telephone number', 'Specialized telephone number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'k', 'Telephone number', 'Telephone number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'l', 'Fax number', 'Fax number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'm', 'Electronic mail address', 'Electronic mail address', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'n', 'TDD or TTY number', 'TDD or TTY number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'p', 'Contact person', 'Contact person', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'q', 'Title of contact person', 'Title of contact person', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'r', 'Hours', 'Hours', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'z', 'Public note', 'Public note', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); @@ -5613,34 +5613,34 @@ INSERT INTO `marc_subfield_structure` VALUES ('362', '6', 'Linkage', 'Linkage', INSERT INTO `marc_subfield_structure` VALUES ('362', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('362', 'a', 'Dates of publication and/or sequential designation', 'Dates of publication and/or sequential designation', 0, 0, 'biblioitems.volumedesc', 3, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('362', 'z', 'Source of information', 'Source of information', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '2', 'Source of price type code', 'Source of price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'a', 'Price type code', 'Price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'b', 'Price amount', 'Price amount', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'c', 'Price type code', 'Price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'd', 'Unit of pricing', 'Unit of pricing', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'e', 'Price note', 'Price note', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'f', 'Price effective from', 'Price effective from', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'g', 'Price effective until', 'Price effective until', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'h', 'Tax rate 1', 'Tax rate 1', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'i', 'Tax rate 2', 'Tax rate 2', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'm', 'Identification of pricing entity', 'Identification of pricing entity', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '2', 'Source of availability status code', 'Source of availability status code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'a', 'Publishers\' compressed title identification', 'Publishers\' compressed title identification', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'b', 'Detailed date of publication', 'Detailed date of publication', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'c', 'Availability status code', 'Availability status code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'd', 'Expected next availability date', 'Expected next availability date', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'e', 'Note', 'Note', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'f', 'Publishers\' discount category', 'Publishers\' discount category', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'g', 'Date made out of print', 'Date made out of print', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '2', 'Source of price type code', 'Source of price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'a', 'Price type code', 'Price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'b', 'Price amount', 'Price amount', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'c', 'Price type code', 'Price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'd', 'Unit of pricing', 'Unit of pricing', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'e', 'Price note', 'Price note', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'f', 'Price effective from', 'Price effective from', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'g', 'Price effective until', 'Price effective until', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'h', 'Tax rate 1', 'Tax rate 1', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'i', 'Tax rate 2', 'Tax rate 2', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'm', 'Identification of pricing entity', 'Identification of pricing entity', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '2', 'Source of availability status code', 'Source of availability status code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'a', 'Publishers\' compressed title identification', 'Publishers\' compressed title identification', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'b', 'Detailed date of publication', 'Detailed date of publication', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'c', 'Availability status code', 'Availability status code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'd', 'Expected next availability date', 'Expected next availability date', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'e', 'Note', 'Note', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'f', 'Publishers\' discount category', 'Publishers\' discount category', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'g', 'Date made out of print', 'Date made out of print', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, 'ASMP_BOOKS', '', ''); @@ -5917,19 +5917,19 @@ INSERT INTO `marc_subfield_structure` VALUES ('540', 'b', 'Jurisdiction', 'Juris INSERT INTO `marc_subfield_structure` VALUES ('540', 'c', 'Authorization', 'Authorization', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', 'd', 'Authorized users', 'Authorized users', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'a', 'Source of acquisition', 'Source of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'b', 'Address', 'Address', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'e', 'Accession number', 'Accession number', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'f', 'Owner', 'Owner', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'h', 'Purchase price', 'Purchase price', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'n', 'Extent', 'Extent', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'a', 'Source of acquisition', 'Source of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'b', 'Address', 'Address', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'e', 'Accession number', 'Accession number', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'f', 'Owner', 'Owner', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'h', 'Purchase price', 'Purchase price', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'n', 'Extent', 'Extent', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 9, '', '', '', NULL, 1, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('543', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('543', 'a', 'Solicitation information note', 'Solicitation information note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('544', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); @@ -6038,27 +6038,27 @@ INSERT INTO `marc_subfield_structure` VALUES ('581', 'a', 'Publications about de INSERT INTO `marc_subfield_structure` VALUES ('581', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('582', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('582', 'a', 'Related computer files note', 'Related computer files note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '2', 'Source of term', 'Source of term', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'a', 'Action', 'Action', 0, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'b', 'Action identification', 'Action identification', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'c', 'Time/date of action', 'Time/date of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'd', 'Action interval', 'Action interval', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'f', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'h', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'i', 'Method of action', 'Method of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'j', 'Site of action', 'Site of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'k', 'Action agent', 'Action agent', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'l', 'Status', 'Status', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'n', 'Extent', 'Extent', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 5, '', '', '', NULL, 4, 'ASMP_BOOKS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'z', 'Public note', 'Public note', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '2', 'Source of term', 'Source of term', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'a', 'Action', 'Action', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'b', 'Action identification', 'Action identification', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'c', 'Time/date of action', 'Time/date of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'd', 'Action interval', 'Action interval', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'f', 'Authorization', 'Authorization', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'h', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'i', 'Method of action', 'Method of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'j', 'Site of action', 'Site of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'k', 'Action agent', 'Action agent', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'l', 'Status', 'Status', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'n', 'Extent', 'Extent', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 9, '', '', '', 1, -1, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 9, '', '', '', NULL, 4, 'ASMP_BOOKS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'z', 'Public note', 'Public note', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_BOOKS', '', ''); @@ -9201,14 +9201,14 @@ INSERT INTO `marc_subfield_structure` VALUES ('036', '6', 'Linkage', 'Linkage', INSERT INTO `marc_subfield_structure` VALUES ('036', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('036', 'a', 'Original study number', 'Original study number', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('036', 'b', 'Source (agency assigning number)', 'Source (agency assigning number)', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('037', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 9, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('037', 'b', 'Source of stock number/acquisition', 'Source of stock number/acquisition', 0, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'c', 'Terms of availability', 'Terms of availability', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'f', 'Form of issue', 'Form of issue', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'g', 'Additional format characteristics', 'Additional format characteristics', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'n', 'Note', 'Note', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'c', 'Terms of availability', 'Terms of availability', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'f', 'Form of issue', 'Form of issue', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'g', 'Additional format characteristics', 'Additional format characteristics', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'n', 'Note', 'Note', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', 'a', 'Record content licensor', 'Record content licensor', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); @@ -9616,27 +9616,27 @@ INSERT INTO `marc_subfield_structure` VALUES ('263', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('263', 'a', 'Projected publication date', 'Projected publication date', 0, 0, '', 2, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('265', '6', 'Linkage [OBSOLETE]', 'Linkage [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('265', 'a', 'Source for acquisition/subscription address [OBSOLETE]', 'Source for acquisition/subscription address [OBSOLETE]', 1, 0, '', 2, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '4', 'Relator code', 'Relator code', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'a', 'Address', 'Address', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'b', 'City', 'City', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'c', 'State or province', 'State or province', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'd', 'Country', 'Country', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'e', 'Postal code', 'Postal code', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'f', 'Terms preceding attention name', 'Terms preceding attention name', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'g', 'Attention name', 'Attention name', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'h', 'Attention position', 'Attention position', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'i', 'Type of address', 'Type of address', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'j', 'Specialized telephone number', 'Specialized telephone number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'k', 'Telephone number', 'Telephone number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'l', 'Fax number', 'Fax number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'm', 'Electronic mail address', 'Electronic mail address', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'n', 'TDD or TTY number', 'TDD or TTY number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'p', 'Contact person', 'Contact person', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'q', 'Title of contact person', 'Title of contact person', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'r', 'Hours', 'Hours', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'z', 'Public note', 'Public note', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '4', 'Relator code', 'Relator code', 1, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '6', 'Linkage', 'Linkage', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'a', 'Address', 'Address', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'b', 'City', 'City', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'c', 'State or province', 'State or province', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'd', 'Country', 'Country', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'e', 'Postal code', 'Postal code', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'f', 'Terms preceding attention name', 'Terms preceding attention name', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'g', 'Attention name', 'Attention name', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'h', 'Attention position', 'Attention position', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'i', 'Type of address', 'Type of address', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'j', 'Specialized telephone number', 'Specialized telephone number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'k', 'Telephone number', 'Telephone number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'l', 'Fax number', 'Fax number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'm', 'Electronic mail address', 'Electronic mail address', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'n', 'TDD or TTY number', 'TDD or TTY number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'p', 'Contact person', 'Contact person', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'q', 'Title of contact person', 'Title of contact person', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'r', 'Hours', 'Hours', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'z', 'Public note', 'Public note', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); @@ -9783,34 +9783,34 @@ INSERT INTO `marc_subfield_structure` VALUES ('362', '6', 'Linkage', 'Linkage', INSERT INTO `marc_subfield_structure` VALUES ('362', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('362', 'a', 'Dates of publication and/or sequential designation', 'Dates of publication and/or sequential designation', 0, 0, 'biblioitems.volumedesc', 3, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('362', 'z', 'Source of information', 'Source of information', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '2', 'Source of price type code', 'Source of price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'a', 'Price type code', 'Price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'b', 'Price amount', 'Price amount', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'c', 'Price type code', 'Price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'd', 'Unit of pricing', 'Unit of pricing', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'e', 'Price note', 'Price note', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'f', 'Price effective from', 'Price effective from', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'g', 'Price effective until', 'Price effective until', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'h', 'Tax rate 1', 'Tax rate 1', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'i', 'Tax rate 2', 'Tax rate 2', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'm', 'Identification of pricing entity', 'Identification of pricing entity', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '2', 'Source of availability status code', 'Source of availability status code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'a', 'Publishers\' compressed title identification', 'Publishers\' compressed title identification', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'b', 'Detailed date of publication', 'Detailed date of publication', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'c', 'Availability status code', 'Availability status code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'd', 'Expected next availability date', 'Expected next availability date', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'e', 'Note', 'Note', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'f', 'Publishers\' discount category', 'Publishers\' discount category', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'g', 'Date made out of print', 'Date made out of print', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '2', 'Source of price type code', 'Source of price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'a', 'Price type code', 'Price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'b', 'Price amount', 'Price amount', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'c', 'Price type code', 'Price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'd', 'Unit of pricing', 'Unit of pricing', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'e', 'Price note', 'Price note', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'f', 'Price effective from', 'Price effective from', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'g', 'Price effective until', 'Price effective until', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'h', 'Tax rate 1', 'Tax rate 1', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'i', 'Tax rate 2', 'Tax rate 2', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'm', 'Identification of pricing entity', 'Identification of pricing entity', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '2', 'Source of availability status code', 'Source of availability status code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'a', 'Publishers\' compressed title identification', 'Publishers\' compressed title identification', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'b', 'Detailed date of publication', 'Detailed date of publication', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'c', 'Availability status code', 'Availability status code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'd', 'Expected next availability date', 'Expected next availability date', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'e', 'Note', 'Note', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'f', 'Publishers\' discount category', 'Publishers\' discount category', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'g', 'Date made out of print', 'Date made out of print', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, 'ASMP_SOUND_RECORDINGS', '', ''); @@ -10087,19 +10087,19 @@ INSERT INTO `marc_subfield_structure` VALUES ('540', 'b', 'Jurisdiction', 'Juris INSERT INTO `marc_subfield_structure` VALUES ('540', 'c', 'Authorization', 'Authorization', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', 'd', 'Authorized users', 'Authorized users', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'a', 'Source of acquisition', 'Source of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'b', 'Address', 'Address', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'e', 'Accession number', 'Accession number', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'f', 'Owner', 'Owner', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'h', 'Purchase price', 'Purchase price', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'n', 'Extent', 'Extent', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'a', 'Source of acquisition', 'Source of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'b', 'Address', 'Address', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'e', 'Accession number', 'Accession number', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'f', 'Owner', 'Owner', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'h', 'Purchase price', 'Purchase price', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'n', 'Extent', 'Extent', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 9, '', '', '', NULL, 1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('543', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('543', 'a', 'Solicitation information note', 'Solicitation information note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('544', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); @@ -10208,27 +10208,27 @@ INSERT INTO `marc_subfield_structure` VALUES ('581', 'a', 'Publications about de INSERT INTO `marc_subfield_structure` VALUES ('581', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('582', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('582', 'a', 'Related computer files note', 'Related computer files note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '2', 'Source of term', 'Source of term', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'a', 'Action', 'Action', 0, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'b', 'Action identification', 'Action identification', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'c', 'Time/date of action', 'Time/date of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'd', 'Action interval', 'Action interval', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'f', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'h', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'i', 'Method of action', 'Method of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'j', 'Site of action', 'Site of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'k', 'Action agent', 'Action agent', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'l', 'Status', 'Status', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'n', 'Extent', 'Extent', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 5, '', '', '', NULL, 4, 'ASMP_SOUND_RECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'z', 'Public note', 'Public note', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '2', 'Source of term', 'Source of term', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'a', 'Action', 'Action', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'b', 'Action identification', 'Action identification', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'c', 'Time/date of action', 'Time/date of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'd', 'Action interval', 'Action interval', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'f', 'Authorization', 'Authorization', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'h', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'i', 'Method of action', 'Method of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'j', 'Site of action', 'Site of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'k', 'Action agent', 'Action agent', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'l', 'Status', 'Status', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'n', 'Extent', 'Extent', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 9, '', '', '', 1, -1, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 9, '', '', '', NULL, 4, 'ASMP_SOUND_RECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'z', 'Public note', 'Public note', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_SOUND_RECORDINGS', '', ''); @@ -13370,14 +13370,14 @@ INSERT INTO `marc_subfield_structure` VALUES ('036', '6', 'Linkage', 'Linkage', INSERT INTO `marc_subfield_structure` VALUES ('036', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('036', 'a', 'Original study number', 'Original study number', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('036', 'b', 'Source (agency assigning number)', 'Source (agency assigning number)', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'b', 'Source of stock number/acquisition', 'Source of stock number/acquisition', 0, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'c', 'Terms of availability', 'Terms of availability', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'f', 'Form of issue', 'Form of issue', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'g', 'Additional format characteristics', 'Additional format characteristics', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('037', 'n', 'Note', 'Note', 1, 0, '', 0, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'a', 'Stock number', 'Stock number', 0, 0, '', 9, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'b', 'Source of stock number/acquisition', 'Source of stock number/acquisition', 0, 0, '', 9, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'c', 'Terms of availability', 'Terms of availability', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'f', 'Form of issue', 'Form of issue', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'g', 'Additional format characteristics', 'Additional format characteristics', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('037', 'n', 'Note', 'Note', 1, 0, '', 9, '', '', '', 0, -1, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('038', 'a', 'Record content licensor', 'Record content licensor', 0, 0, '', 0, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); @@ -13785,27 +13785,27 @@ INSERT INTO `marc_subfield_structure` VALUES ('263', '8', 'Field link and sequen INSERT INTO `marc_subfield_structure` VALUES ('263', 'a', 'Projected publication date', 'Projected publication date', 0, 0, '', 2, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('265', '6', 'Linkage [OBSOLETE]', 'Linkage [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('265', 'a', 'Source for acquisition/subscription address [OBSOLETE]', 'Source for acquisition/subscription address [OBSOLETE]', 1, 0, '', 2, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '4', 'Relator code', 'Relator code', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '6', 'Linkage', 'Linkage', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'a', 'Address', 'Address', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'b', 'City', 'City', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'c', 'State or province', 'State or province', 0, 0, NULL, 2, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'd', 'Country', 'Country', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'e', 'Postal code', 'Postal code', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'f', 'Terms preceding attention name', 'Terms preceding attention name', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'g', 'Attention name', 'Attention name', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'h', 'Attention position', 'Attention position', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'i', 'Type of address', 'Type of address', 0, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'j', 'Specialized telephone number', 'Specialized telephone number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'k', 'Telephone number', 'Telephone number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'l', 'Fax number', 'Fax number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'm', 'Electronic mail address', 'Electronic mail address', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'n', 'TDD or TTY number', 'TDD or TTY number', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'p', 'Contact person', 'Contact person', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'q', 'Title of contact person', 'Title of contact person', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'r', 'Hours', 'Hours', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('270', 'z', 'Public note', 'Public note', 1, 0, NULL, 2, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '4', 'Relator code', 'Relator code', 1, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '6', 'Linkage', 'Linkage', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'a', 'Address', 'Address', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'b', 'City', 'City', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'c', 'State or province', 'State or province', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'd', 'Country', 'Country', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'e', 'Postal code', 'Postal code', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'f', 'Terms preceding attention name', 'Terms preceding attention name', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'g', 'Attention name', 'Attention name', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'h', 'Attention position', 'Attention position', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'i', 'Type of address', 'Type of address', 0, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'j', 'Specialized telephone number', 'Specialized telephone number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'k', 'Telephone number', 'Telephone number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'l', 'Fax number', 'Fax number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'm', 'Electronic mail address', 'Electronic mail address', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'n', 'TDD or TTY number', 'TDD or TTY number', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'p', 'Contact person', 'Contact person', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'q', 'Title of contact person', 'Title of contact person', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'r', 'Hours', 'Hours', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('270', 'z', 'Public note', 'Public note', 1, 0, NULL, 9, NULL, NULL, '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('300', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); @@ -13952,34 +13952,34 @@ INSERT INTO `marc_subfield_structure` VALUES ('362', '6', 'Linkage', 'Linkage', INSERT INTO `marc_subfield_structure` VALUES ('362', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, NULL, 3, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('362', 'a', 'Dates of publication and/or sequential designation', 'Dates of publication and/or sequential designation', 0, 0, 'biblioitems.volumedesc', 3, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('362', 'z', 'Source of information', 'Source of information', 0, 0, NULL, 3, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '2', 'Source of price type code', 'Source of price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'a', 'Price type code', 'Price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'b', 'Price amount', 'Price amount', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'c', 'Price type code', 'Price type code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'd', 'Unit of pricing', 'Unit of pricing', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'e', 'Price note', 'Price note', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'f', 'Price effective from', 'Price effective from', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'g', 'Price effective until', 'Price effective until', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'h', 'Tax rate 1', 'Tax rate 1', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'i', 'Tax rate 2', 'Tax rate 2', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('365', 'm', 'Identification of pricing entity', 'Identification of pricing entity', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '2', 'Source of availability status code', 'Source of availability status code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'a', 'Publishers\' compressed title identification', 'Publishers\' compressed title identification', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'b', 'Detailed date of publication', 'Detailed date of publication', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'c', 'Availability status code', 'Availability status code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'd', 'Expected next availability date', 'Expected next availability date', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'e', 'Note', 'Note', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'f', 'Publishers\' discount category', 'Publishers\' discount category', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'g', 'Date made out of print', 'Date made out of print', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 3, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '2', 'Source of price type code', 'Source of price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'a', 'Price type code', 'Price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'b', 'Price amount', 'Price amount', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'c', 'Price type code', 'Price type code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'd', 'Unit of pricing', 'Unit of pricing', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'e', 'Price note', 'Price note', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'f', 'Price effective from', 'Price effective from', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'g', 'Price effective until', 'Price effective until', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'h', 'Tax rate 1', 'Tax rate 1', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'i', 'Tax rate 2', 'Tax rate 2', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('365', 'm', 'Identification of pricing entity', 'Identification of pricing entity', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '2', 'Source of availability status code', 'Source of availability status code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'a', 'Publishers\' compressed title identification', 'Publishers\' compressed title identification', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'b', 'Detailed date of publication', 'Detailed date of publication', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'c', 'Availability status code', 'Availability status code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'd', 'Expected next availability date', 'Expected next availability date', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'e', 'Note', 'Note', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'f', 'Publishers\' discount category', 'Publishers\' discount category', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'g', 'Date made out of print', 'Date made out of print', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'j', 'ISO country code', 'ISO country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'k', 'MARC country code', 'MARC country code', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('366', 'm', 'Identification of agency', 'Identification of agency', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '4', 'Relator code', 'Relator code', 1, 0, '', 4, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '6', 'Linkage', 'Linkage', 0, 0, '', 4, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('400', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 4, '', '', '', 0, -6, 'ASMP_VIDEORECORDINGS', '', ''); @@ -14256,19 +14256,19 @@ INSERT INTO `marc_subfield_structure` VALUES ('540', 'b', 'Jurisdiction', 'Juris INSERT INTO `marc_subfield_structure` VALUES ('540', 'c', 'Authorization', 'Authorization', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', 'd', 'Authorized users', 'Authorized users', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('540', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'a', 'Source of acquisition', 'Source of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'b', 'Address', 'Address', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'e', 'Accession number', 'Accession number', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'f', 'Owner', 'Owner', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'h', 'Purchase price', 'Purchase price', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'n', 'Extent', 'Extent', 0, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'a', 'Source of acquisition', 'Source of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'b', 'Address', 'Address', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'c', 'Method of acquisition', 'Method of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'd', 'Date of acquisition', 'Date of acquisition', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'e', 'Accession number', 'Accession number', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'f', 'Owner', 'Owner', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'h', 'Purchase price', 'Purchase price', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'n', 'Extent', 'Extent', 0, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('541', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 9, '', '', '', NULL, 1, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('543', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('543', 'a', 'Solicitation information note', 'Solicitation information note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('544', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); @@ -14377,28 +14377,28 @@ INSERT INTO `marc_subfield_structure` VALUES ('581', 'a', 'Publications about de INSERT INTO `marc_subfield_structure` VALUES ('581', 'z', 'International Standard Book Number', 'International Standard Book Number', 1, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('582', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('582', 'a', 'Related computer files note', 'Related computer files note', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '2', 'Source of term', 'Source of term', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'a', 'Action', 'Action', 0, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'b', 'Action identification', 'Action identification', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'c', 'Time/date of action', 'Time/date of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'd', 'Action interval', 'Action interval', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'f', 'Authorization', 'Authorization', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'h', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'i', 'Method of action', 'Method of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'j', 'Site of action', 'Site of action', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'k', 'Action agent', 'Action agent', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'l', 'Status', 'Status', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'n', 'Extent', 'Extent', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 5, '', '', '', 1, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 5, '', '', '', NULL, 4, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('583', 'z', 'Public note', 'Public note', 1, 0, '', 5, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('584', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '2', 'Source of term', 'Source of term', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '6', 'Linkage', 'Linkage', 0, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 9, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'a', 'Action', 'Action', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'b', 'Action identification', 'Action identification', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'c', 'Time/date of action', 'Time/date of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'd', 'Action interval', 'Action interval', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'e', 'Contingency for action', 'Contingency for action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'f', 'Authorization', 'Authorization', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'h', 'Jurisdiction', 'Jurisdiction', 0, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'i', 'Method of action', 'Method of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'j', 'Site of action', 'Site of action', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'k', 'Action agent', 'Action agent', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'l', 'Status', 'Status', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'n', 'Extent', 'Extent', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'o', 'Type of unit', 'Type of unit', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, '', 9, '', '', '', 1, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 9, '', '', '', NULL, 4, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('583', 'z', 'Public note', 'Public note', 1, 0, '', 9, '', '', '', NULL, -1, 'ASMP_VIDEORECORDINGS', '', ''); +INSERT INTO `marc_subfield_structure` VALUES ('584', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 9, NULL, NULL, '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); INSERT INTO `marc_subfield_structure` VALUES ('584', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, 'ASMP_VIDEORECORDINGS', '', ''); -- 2.39.5