From 63b4c7ab89f896f11647f2f3aeada178700ed4b0 Mon Sep 17 00:00:00 2001 From: rych Date: Sat, 17 Mar 2007 21:57:41 +0000 Subject: [PATCH] *** empty log message *** --- .../optional/marc21_simple_bib_frameworks.sql | 123 ------------------ 1 file changed, 123 deletions(-) diff --git a/misc/sql-datas/en/optional/marc21_simple_bib_frameworks.sql b/misc/sql-datas/en/optional/marc21_simple_bib_frameworks.sql index fdce058418..9afa0d4db3 100644 --- a/misc/sql-datas/en/optional/marc21_simple_bib_frameworks.sql +++ b/misc/sql-datas/en/optional/marc21_simple_bib_frameworks.sql @@ -105,129 +105,6 @@ INSERT INTO `biblio_framework` VALUES ('SER', 'Serials'); --- ****************************************************** --- KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS. --- ****************************************************** - --- These ought to be adjusted for different less conflicting and more --- rationally chosen fields and subfields but I had left that for last. - --- ADJUST ME --- Use values from your dump of marc_tag_structure and marc_subfield_structure --- to provide support for your Koha database. - - --- ****************************************************** - - --- Current Record ID Field/Subfields - - -INSERT INTO `marc_tag_structure` VALUES ('090', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', ''); - -INSERT INTO `marc_subfield_structure` VALUES ('090', 'a', 'Item type [OBSOLETE]', 'Item type [OBSOLETE]', 0, 0, NULL, -1, NULL, NULL, '', NULL, -5, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('090', 'b', 'Koha Dewey Subclass [OBSOLETE]', 'Koha Dewey Subclass [OBSOLETE]', 0, 0, NULL, 0, NULL, NULL, '', NULL, -5, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('090', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('090', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, '', '', ''); - - --- ****************************************************** - --- Current primary biblioitems Field/Subfields - - -INSERT INTO `marc_tag_structure` VALUES ('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', ''); - -INSERT INTO `marc_subfield_structure` VALUES ('942', 'a', 'Institution code [OBSOLETE]', 'Institution code [OBSOLETE]', 0, 0, '', 9, '', '', '', NULL, -5, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('942', 'c', 'Item type', 'Item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('942', 'j', 'Location (call number prefix code)', 'Location (call number prefix code)', 0, 0, 'biblioitems.classification', 9, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('942', 'k', 'Classification base (DDC to decimal or LCC letter class padded after single letter classes with trailing 0', 'Classification base', 0, 0, 'biblioitems.dewey', 9, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('942', 'l', 'Classification subclass (DDC after decimal or LCC number after letters', 'Classification subclass', 0, 0, 'biblioitems.subclass', 9, '', '', '', NULL, 0, '', '', ''); - - --- ****************************************************** - - --- Current items Field/Subfields - - -INSERT INTO `marc_tag_structure` VALUES ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', ''); - -INSERT INTO `marc_subfield_structure` VALUES ('952', '0', 'Item status (withdrawn)', 'Item status (withdrawn)', 0, 0, 'items.withdrawn', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '1', 'Item status (lost)', 'Item status (lost)', 0, 0, 'items.itemlost', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '3', 'Materials specified', 'Materials specified', 0, 0, '', 10, '', '', '', NULL, -1, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '4', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '6', 'Linkage', 'Linkage', 0, 0, '', 10, '', '', '', NULL, -6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '8', 'Sequence number', 'Sequence number', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', '9', 'Cost, normal purchase price', 'Cost, normal purchase price', 0, 0, 'items.price', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'a', 'Canceled barcode', 'Canceled barcode', 1, 0, '', 10, '', '', '', NULL, -1, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'b', 'Location (homebranch)', 'Location (homebranch)', 0, 0, 'items.homebranch', 10, 'branches', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'c', 'Shelving location', 'Shelving location', 1, 0, 'items.location', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'd', 'Sublocation or collection (holdingbranch)', 'Sublocation or collection (holdingbranch)', 0, 0, 'items.holdingbranch', 10, 'branches', '', '', 0, 0, '', '''952b''', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'e', 'Source of acquisition', 'Source of acquisition', 1, 0, 'items.booksellerid', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'g', 'Non-coded location qualifier', 'Non-coded location qualifier', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'h', 'Classification part', 'Classification part', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'i', 'Item part', 'Item part', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'j', 'Shelving control number', 'Shelving control number', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'k', 'Call number (combined)', 'Call number', 0, 0, 'items.itemcallnumber', 10, '', '', NULL, 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'l', 'Shelving form of title', 'Shelving form of title', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'm', 'Call number suffix', 'Call number suffix', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'n', 'Country code', 'Country code', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'o', 'Call number prefix', 'Call number prefix', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'p', 'Barcode', 'Barcode', 0, 1, 'items.barcode', 10, '', '', 'barcode.pl', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'q', 'Piece physical condition', 'Piece physical condition', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'r', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 's', 'Copyright article-fee code', 'Copyright article-fee code', 1, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 't', 'Copy number', 'Copy number', 0, 0, '', 10, '', '', '', NULL, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'u', 'Koha itemnumber (autogenerated)', 'Koha itemnumber', 0, 0, 'items.itemnumber', -1, '', '', '', 0, -5, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'v', 'Date acquired', 'Date acquired', 0, 0, 'items.dateaccessioned', 10, 'usmarc_field_952v.pl', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'x', 'Nonpublic note', 'Nonpublic note', 1, 0, '', 10, '', '', '', NULL, 6, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'y', 'Use restrictions (not for loan)', 'Use restrictions (not for loan)', 0, 0, 'items.notforloan', 10, '', '', '', 0, 0, '', '', ''); -INSERT INTO `marc_subfield_structure` VALUES ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', 1, 0, '', '', ''); - - --- ******************************************************* - - - --- ******************************************************* --- MARC 21 FIELDS/SUBFIELDS AND COMMMONLY USED EXTENSIONS --- ******************************************************* - - --- A Few local use codes need specifying. Several seealso, plugin, and --- authority framework columns need improving. $9 for authority record linking --- needs to be added where not already provided by RLIN specifications. --- Needs checking for errors but probably tolerable for use on a production. --- A server can be upgraded easily from later versions of this file. --- --- In the absense of more column support for qualifying the relative --- importance of subfields to the record editor, some modest modification of --- the default framework is needed setting the not-useful non-Koha holdings --- subfields to not managed in Koha. - --- MARC fields including letters as part of the field identifier are from RLIN --- and should be expected to remain along with RLIN $% subfields. RLIN has --- been using letters in fields because there are not enough local use number --- fields which have not already been specified for very large union catalogue --- networks such as RLIN itself. - - --- Fields ending in c, o, or r are temporary placeholders for information from --- a numeric value until a non-conflicting way to treat the content under the --- proper original numeric field is adopted. 090 for LC call numbers is much --- too common and important so 999 is also provided as a temporary place --- holder until all Koha code for finding control fields has been changed from --- a numeric test of < 10 to a regular expression match of m/^00/ to prevent --- mistaken matching of fields with letters such as 09o if they were control --- fields. - --- ****************************************************** - - -- ******************************************************************* -- SIMPLE BOOKS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS. -- 2.39.5