[Koha] Add record author field locked?

Emrys Minnig emrysminnig at varndean.co.uk
Thu Mar 10 14:37:02 UTC 2011


I've attached a sqldump of data from the relevant rows of the marc_subfield_structure, marc_tag_structure and biblio_framework tables.  This framework (which I called 'BRF') is one I created for our school librarians to use for manual cataloguing.  All of the MARC fields should be displayed in one tab.  All you need to do is load it into your DB.  This should save you some effort, as setting up a custom framework is a bit clunky and time-consuming.
 
HOWEVER, this framework was created under Koha 3.00.04.019.  I have no idea if any of these table structures have changed in more recent versions.  I suppose mysql might shout at you if there is a problem during loading.
 
 
Emrys

________________________________

From: koha-bounces at lists.katipo.co.nz on behalf of Fogg, Shawn (DPH)
Sent: Wed 09/03/2011 15:50
To: Koha koha
Subject: Re: [Koha] Add record author field locked?



Hi,

Thanks for the information, that looks like it was the problem. Good idea about the custom framework. I assume that would be in Koha->Administration->MARC Frameworks?

What fields are required by Koha?

I think for these books the librarian is really just looking for Title, Author, ISBN, Call Number and Barcode.

Thanks,

Shawn

-----------------
Just to elaborate, navigate to Administration/System Preferences/Authorities and set 'BiblioAddsAuthorities' to 'On'.

I found that it was also helpful (especially for a school library) to create a custom bibliographic framework containing only the fields we needed.  It made manual cataloguing significantly easier for school librarians who might not have much experience with MARC format cataloguing.

Hope that helps!

Emrys

_______________________________________________
Koha mailing list  http://koha-community.org <http://koha-community.org/> 
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


-------------- next part --------------
-- MySQL dump 10.11
--
-- Host: localhost    Database: kohaDB
-- ------------------------------------------------------
-- Server version	5.0.51a-24+lenny2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `marc_subfield_structure`
--
-- WHERE:  frameworkcode='BRF'

LOCK TABLES `marc_subfield_structure` WRITE;
/*!40000 ALTER TABLE `marc_subfield_structure` DISABLE KEYS */;
INSERT INTO `marc_subfield_structure` VALUES ('020','6','Linkage','Linkage',0,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('020','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('020','z','Cancelled/invalid ISBN','Cancelled/invalid ISBN',1,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('022','6','Linkage','Linkage',0,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('022','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('022','y','Incorrect ISSN','Incorrect ISSN',1,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('022','z','Canceled ISSN','Canceled ISSN',1,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('082','6','Linkage','Linkage',0,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('082','8','Field link and sequence number','Field link and sequence number',1,0,'',0,'','','',0,-6,'BRF',NULL,'',''),('082','a','Classification number','Classification number',0,0,'',0,'','','',0,0,'BRF',NULL,'',''),('100','4','Relator code','Relator code',1,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','6','Linkage','Linkage',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','8','Field link and sequence number','Field link and sequence number',1,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','9','9 (RLIN)','9 (RLIN)',0,0,'',9,'','','',0,-5,'BRF',NULL,'',''),('100','b','Numeration','Numeration',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','c','Titles and other words associated with a name','Titles and other words associated with a name',1,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','d','Dates associated with a name','Dates associated with a name',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','e','Relator term','Relator term',1,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','f','Date of a work','Date of a work',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','g','Miscellaneous information','Miscellaneous information',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','j','Attribution qualifier','Attribution qualifier',1,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','k','Form subheading','Form subheading',1,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','l','Language of a work','Language of a work',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','n','Number of part/section of a work','Number of part/section of a work',1,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','p','Name of part/section of a work','Name of part/section of a work',1,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','q','Fuller form of name','Fuller form of name',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','t','Title of a work','Title of a work',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('100','u','Affiliation','Affiliation',0,0,'',1,'','','',0,-6,'BRF',NULL,'',''),('245','6','Linkage','Linkage',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','8','Field link and sequence number','Field link and sequence number',1,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','b','Remainder of title','Remainder of title',0,0,'',0,'','','',0,0,'BRF',NULL,'',''),('245','d','Designation of section/part/series (SE) [OBSOLETE]','Designation of section section/part/series: (SE) [OBSOLETE]',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','e','Name of part/section/series (SE) [OBSOLETE]','Name of part/section/series (SE) [OBSOLETE]',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','f','Inclusive dates','Inclusive dates',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','g','Bulk dates','Bulk dates',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','k','Form','Form',1,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','n','Number of part/section of a work','Number of part/section of a work',1,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','p','Name of part/section of a work','Name of part/section of a work',1,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('245','s','Version','Version',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('260','6','Linkage','Linkage',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('260','8','Field link and sequence number','Field link and sequence number',1,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('260','d','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,','Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL,',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('260','e','Place of manufacture','Place of manufacture',1,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('260','f','Manufacturer','Manufacturer',1,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('260','g','Date of manufacture','Date of manufacture',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('260','k','Identification/manufacturer number [OBSOLETE, CAN/MARC]','Identification/manufacturer number [OBSOLETE, CAN/MARC]',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('260','l','Matrix and/or take number [OBSOLETE, CAN/MARC]','Matrix and/or take number [OBSOLETE, CAN/MARC]',0,0,'',2,'','','',0,-6,'BRF',NULL,'',''),('300','3','Materials specified','Materials specified',0,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('300','6','Linkage','Linkage',0,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('300','8','Field link and sequence number','Field link and sequence number',1,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('300','d','Accompanying material [OBSOLETE, CAN/MARC]','Accompanying material [OBSOLETE, CAN/MARC]',0,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('300','e','Accompanying material','Accompanying material',0,0,'',0,'','','',0,0,'BRF',NULL,'',''),('300','f','Type of unit','Type of unit',1,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('300','g','Size of unit','Size of unit',1,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('300','k','Speed [Videodiscs, pre-AACR2 records only] [OBSOLETE, CAN/MARC]','Speed [Videodiscs, pre-AACR2 records only] [OBSOLETE, CAN/MARC]',0,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('300','m','Identification/manufacturer number [pre-AACR2 records only] [OBSOLETE, CAN/MARC]','Identification/manufacturer number [pre-AACR2 records only] [OBSOLETE, CAN/MARC]',0,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('300','n','Matrix and/or take number [Sound recordings, pre-AACR2 records only] [OBSOLETE, ','Matrix and/or take number [Sound recordings, pre-AACR2 records only] [OBSOLETE, ',0,0,'',3,'','','',0,-6,'BRF',NULL,'',''),('440','9','9 (RLIN)','9 (RLIN)',0,0,'',9,'','','',0,-6,'BRF',NULL,'',''),('440','n','Number of part/section of a work','Number of part/section of a work',0,0,'',0,'','','',0,0,'BRF',NULL,'',''),('520','3','Materials specified','Materials specified',0,0,'',5,'','','',0,-6,'BRF',NULL,'',''),('520','6','Linkage','Linkage',0,0,'',5,'','','',0,-6,'BRF',NULL,'',''),('520','8','Field link and sequence number','Field link and sequence number',1,0,'',5,'','','',0,-6,'BRF',NULL,'',''),('520','b','Expansion of summary note','Expansion of summary note',0,0,'',5,'','','',0,-6,'BRF',NULL,'',''),('520','u','Uniform Resource Identifier','Uniform Resource Identifier',1,0,'',5,'','','',0,-6,'BRF',NULL,'',''),('520','z','Source of note information [OBSOLETE]','Source of note information [OBSOLETE]',0,0,'',5,'','','',0,-6,'BRF',NULL,'',''),('545','6','Linkage','Linkage',0,0,'',5,'','','',NULL,-6,'BRF','',NULL,NULL),('545','8','Field link and sequence number','Field link and sequence number',1,0,'',5,'','','',NULL,-6,'BRF','',NULL,NULL),('545','a','Biographical or historical note','Biographical or historical note',0,0,'',5,'','','',NULL,-6,'BRF','',NULL,NULL),('545','b','Expansion','Expansion',0,0,'',5,'','','',NULL,-6,'BRF','',NULL,NULL),('545','u','Uniform Resource Identifier','Uniform Resource Identifier',1,0,'',5,'','','',NULL,-6,'BRF','',NULL,NULL),('650','2','Source of heading or term','Source of heading or term',0,0,'',9,'','','',0,-6,'BRF',NULL,'',''),('650','3','Materials specified','Materials specified',0,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','4','Relator code','Relator code',1,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','6','Linkage','Linkage',0,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','8','Field link and sequence number','Field link and sequence number',1,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','9','9 (RLIN)','9 (RLIN)',0,0,'',9,'','','',0,-5,'BRF',NULL,'',''),('650','a','Topical term or geographic name as entry element','Topical term or geographic name as entry element',0,0,'',0,'','TOPIC_TERM','',0,0,'BRF',NULL,'',''),('650','b','Topical term following geographic name as entry element','Topical term following geographic name as entry element',0,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','c','Location of event','Location of event',0,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','d','Active dates','Active dates',0,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','e','Relator term','Relator term',0,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','v','Form subdivision','Form subdivision',1,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','x','General subdivision','General subdivision',1,0,'',6,'','','',0,-6,'BRF',NULL,'',''),('650','y','Chronological subdivision','Chronological subdivision',0,0,'',0,'','','',0,0,'BRF',NULL,'',''),('650','z','Geographic subdivision','Geographic subdivision',0,0,'',0,'','','',0,0,'BRF',NULL,'',''),('942','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'',9,'cn_source','','',0,-6,'BRF',NULL,'',''),('942','6','Koha normalized classification for sorting','Koha normalized classification for sorting',0,0,'',-1,'','','',0,7,'BRF',NULL,'',''),('942','a','Institution code [OBSOLETE]','Institution code [OBSOLETE]',0,0,'',9,'','','',0,-5,'BRF',NULL,'',''),('942','e','Edition','Edition',0,0,'',9,'','','',0,-6,'BRF',NULL,'',''),('942','h','Classification part','Classification part',0,0,'',9,'','','',0,-6,'BRF',NULL,'',''),('942','k','Call number prefix','Call number prefix',0,0,'',9,'','','',0,-6,'BRF',NULL,'',''),('942','m','Call number suffix','Call number suffix',0,0,'',9,'','','',0,-6,'BRF',NULL,'',''),('942','n','Suppress in OPAC','Suppress in OPAC',0,0,'',9,'','','',0,-6,'BRF',NULL,'',''),('952','f','Coded location qualifier','Coded location qualifier',0,0,'',10,'','','',0,0,'BRF',NULL,'',''),('999','a','Item type [OBSOLETE]','Item type [OBSOLETE]',0,0,'',-1,'itemtypes','','',0,-5,'BRF',NULL,'','BK'),('999','b','Koha Dewey Subclass [OBSOLETE]','Koha Dewey Subclass [OBSOLETE]',0,0,'',0,'','','',0,-5,'BRF',NULL,'',''),('520','a','Summary, etc','Summary, etc',0,0,'biblio.abstract',0,'','','',0,0,'BRF',NULL,'',''),('100','a','Personal name','Personal name',1,0,'biblio.author',0,'','PERSO_NAME','',0,0,'BRF',NULL,'',''),('999','c','Koha biblionumber','Koha biblionumber',0,0,'biblio.biblionumber',-1,'','','',0,-5,'BRF',NULL,'',''),('260','c','Date of publication, distribution, etc','Date of publication, distribution, etc',0,0,'biblio.copyrightdate',0,'','','',0,0,'BRF',NULL,'',''),('942','s','Serial record flag','Serial record',0,0,'biblio.serial',9,'','','',0,-5,'BRF',NULL,'',''),('440','a','Title','Title',0,0,'biblio.seriestitle',0,'','UNIF_TITLE','',0,0,'BRF',NULL,'',''),('245','a','Title','Title',0,1,'biblio.title',0,'','','',0,0,'BRF',NULL,'',''),('999','d','Koha biblioitemnumber','Koha biblioitemnumber',0,0,'biblioitems.biblioitemnumber',-1,'','','',0,-5,'BRF',NULL,'',''),('942','i','Item part','Item part',1,0,'biblioitems.cn_item',9,'','','',0,-6,'BRF',NULL,'',''),('300','b','Other physical details','Other physical details',0,0,'biblioitems.illus',0,'','','',0,0,'BRF',NULL,'',''),('020','a','International Standard Book Number','International Standard Book Number',0,0,'biblioitems.isbn',0,'','','',0,0,'BRF',NULL,'',''),('022','a','International Standard Serial Number','International Standard Serial Number',0,0,'biblioitems.issn',0,'','','',0,0,'BRF',NULL,'',''),('942','c','Koha [default] item type','Koha item type',0,1,'biblioitems.itemtype',0,'itemtypes','','',0,0,'BRF',NULL,'','BK'),('300','a','Extent','Extent',0,0,'biblioitems.pages',0,'','','',0,0,'BRF',NULL,'',''),('260','a','Place of publication, distribution, etc','Place of publication, distribution, etc',0,0,'biblioitems.place',0,'','','',0,0,'BRF',NULL,'',''),('260','b','Name of publisher, distributor, etc','Name of publisher, distributor, etc',0,0,'biblioitems.publishercode',0,'','','',0,0,'BRF',NULL,'',''),('300','c','Dimensions','Dimensions',0,0,'biblioitems.size',0,'','','',0,0,'BRF',NULL,'',''),('942','0','Koha issues (borrowed), all copies','Koha issues (borrowed), all copies',0,0,'biblioitems.totalissues',9,'','','',0,-5,'BRF',NULL,'',''),('952','p','Piece designation (barcode)','Piece designation (barcode)',0,0,'items.barcode',10,'','','barcode.pl',0,0,'BRF',NULL,'',''),('952','e','Source of acquisition','Source of acquisition',0,0,'items.booksellerid',10,'','','',0,0,'BRF',NULL,'',''),('952','8','Koha collection','Koha collection',0,0,'items.ccode',10,'CCODE','','',0,0,'BRF',NULL,'',''),('952','6','Koha normalized classification for sorting','Koha normalized classification for sorting',0,0,'items.cn_sort',-1,'','','',0,7,'BRF',NULL,'',''),('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',0,0,'BRF',NULL,'',''),('952','t','Copy number','Copy number',0,0,'items.copynumber',10,'','','',0,0,'BRF',NULL,'',''),('952','4','Damaged status','Damaged status',0,0,'items.damaged',10,'DAMAGED','','',0,0,'BRF',NULL,'',''),('952','d','Date acquired','Date acquired',0,0,'items.dateaccessioned',10,'','','dateaccessioned.pl',0,0,'BRF',NULL,'',''),('952','s','Koha date last borrowed','Koha date last borrowed',0,0,'items.datelastborrowed',10,'','','',0,-5,'BRF',NULL,'',''),('952','r','Koha date last seen','Koha date last seen',0,0,'items.datelastseen',10,'','','',0,-5,'BRF',NULL,'',''),('952','h','Serial Enumeration / chronology','Serial Enumeration / chronology',0,0,'items.enumchron',10,'','','',0,0,'BRF',NULL,'',''),('952','b','Sublocation or collection (holding branch)','Sublocation or collection (holding branch)',0,0,'items.holdingbranch',10,'branches','','',0,0,'BRF',NULL,'',''),('952','a','Location (home branch)','Location (home branch)',0,0,'items.homebranch',10,'branches','','',0,0,'BRF',NULL,'',''),('952','l','Koha issues (times borrowed)','Koha issues (times borrowed)',0,0,'items.issues',10,'','','',0,-5,'BRF',NULL,'',''),('952','o','Koha full call number','Koha full call number',0,0,'items.itemcallnumber',10,'','','',0,0,'BRF',NULL,'',''),('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',0,0,'BRF',NULL,'',''),('952','z','Public note','Public note',0,0,'items.itemnotes',10,'','','',0,0,'BRF',NULL,'',''),('952','9','Koha itemnumber (autogenerated)','Koha itemnumber',0,0,'items.itemnumber',-1,'','','',0,7,'BRF',NULL,'',''),('952','y','Koha item type','Koha item type',0,0,'items.itype',10,'itemtypes','','',0,0,'BRF',NULL,'','BK'),('952','c','Shelving location','Shelving location',0,0,'items.location',10,'LOC','','',0,0,'BRF',NULL,'',''),('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',0,-1,'BRF',NULL,'',''),('952','7','Not for loan','Not for loan',0,0,'items.notforloan',10,'NOT_LOAN','','',0,0,'BRF',NULL,'',''),('952','q','Koha out on loan','Koha out on loan',0,0,'items.onloan',10,'','','',0,-5,'BRF',NULL,'',''),('952','x','Nonpublic note (lost item payment)','Nonpublic note (lost item payment)',1,0,'items.paidfor',10,'','','',0,7,'BRF',NULL,'',''),('952','g','Cost, normal purchase price','Cost, normal purchase price',0,0,'items.price',10,'','','',0,0,'BRF',NULL,'',''),('952','m','Koha renewals','Koha renewals',0,0,'items.renewals',10,'','','',0,-5,'BRF',NULL,'',''),('952','v','Cost, replacement price','Cost, replacement price',0,0,'items.replacementprice',10,'','','',0,0,'BRF',NULL,'',''),('952','w','Price effective from','Price effective from',0,0,'items.replacementpricedate',10,'','','',0,0,'BRF',NULL,'',''),('952','n','Koha reserves (requests)','Koha reserves (requests)',0,0,'items.reserves',10,'','','',0,-5,'BRF',NULL,'',''),('952','5','Use restrictions','Use restrictions',0,0,'items.restricted',10,'RESTRICTED','','',0,0,'BRF',NULL,'',''),('952','j','Shelving control number','Shelving control number',0,0,'items.stack',10,'STACK','','',0,-1,'BRF',NULL,'',''),('952','u','Uniform Resource Identifier','Uniform Resource Identifier',0,0,'items.uri',10,'','','',0,0,'BRF',NULL,'',''),('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',0,0,'BRF',NULL,'','');
/*!40000 ALTER TABLE `marc_subfield_structure` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `marc_tag_structure`
--
-- WHERE:  frameworkcode='BRF'

LOCK TABLES `marc_tag_structure` WRITE;
/*!40000 ALTER TABLE `marc_tag_structure` DISABLE KEYS */;
INSERT INTO `marc_tag_structure` VALUES ('020','INTERNATIONAL STANDARD BOOK NUMBER','INTERNATIONAL STANDARD BOOK NUMBER',1,0,NULL,'BRF'),('022','INTERNATIONAL STANDARD SERIAL NUMBER','INTERNATIONAL STANDARD SERIAL NUMBER',1,0,NULL,'BRF'),('082','DEWEY DECIMAL CLASSIFICATION NUMBER','DEWEY DECIMAL CLASSIFICATION NUMBER',0,0,'','BRF'),('100','MAIN ENTRY--PERSONAL NAME','MAIN ENTRY--PERSONAL NAME',0,0,NULL,'BRF'),('245','TITLE STATEMENT','TITLE STATEMENT',0,1,'','BRF'),('260','PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)','PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)',0,0,'','BRF'),('300','PHYSICAL DESCRIPTION','PHYSICAL DESCRIPTION',0,0,'','BRF'),('440','SERIES STATEMENT/ADDED ENTRY','SERIES STATEMENT/ADDED ENTRY',0,0,'','BRF'),('520','SUMMARY, ETC.','SUMMARY, ETC.',0,0,'','BRF'),('650','SUBJECT ADDED ENTRY--TOPICAL TERM','SUBJECT ADDED ENTRY--TOPICAL TERM',1,0,NULL,'BRF'),('942','ADDED ENTRY ELEMENTS (KOHA)','ADDED ENTRY ELEMENTS (KOHA)',0,0,'','BRF'),('952','LOCATION AND ITEM INFORMATION (KOHA)','LOCATION AND ITEM INFORMATION (KOHA)',1,0,'','BRF'),('999','SYSTEM CONTROL NUMBERS (KOHA)','SYSTEM CONTROL NUMBERS (KOHA)',1,0,'','BRF');
/*!40000 ALTER TABLE `marc_tag_structure` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `biblio_framework`
--
-- WHERE:  frameworkcode='BRF'

LOCK TABLES `biblio_framework` WRITE;
/*!40000 ALTER TABLE `biblio_framework` DISABLE KEYS */;
INSERT INTO `biblio_framework` VALUES ('BRF','Brief framework for manual entry');
/*!40000 ALTER TABLE `biblio_framework` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-03-10 14:07:52


More information about the Koha mailing list