[Koha-cvs] koha/misc/sql-datas/en/optional marc21_simple_b...

[Ryan Higgins]

CVSROOT:        /sources/koha
Module name:    koha
Changes by:     Ryan Higgins <rych>     07/03/17 21:57:41

Modified files:
        misc/sql-datas/en/optional: marc21_simple_bib_frameworks.sql 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/en/optional/marc21_simple_bib_frameworks.sql?cvsroot=koha&r1=1.1&r2=1.2

Patches:
Index: marc21_simple_bib_frameworks.sql
===================================================================
RCS file: 
/sources/koha/koha/misc/sql-datas/en/optional/marc21_simple_bib_frameworks.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -b -r1.1 -r1.2
--- marc21_simple_bib_frameworks.sql    16 Mar 2007 16:56:48 -0000      1.1
+++ marc21_simple_bib_frameworks.sql    17 Mar 2007 21:57:41 -0000      1.2
@@ -105,129 +105,6 @@
 
 
 
--- ******************************************************
--- 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.