[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] CVS: koha/marc marcschema.sql,1.5,1.6
From: |
Steve Tonnesen |
Subject: |
[Koha-cvs] CVS: koha/marc marcschema.sql,1.5,1.6 |
Date: |
Wed, 29 May 2002 14:11:43 -0700 |
Update of /cvsroot/koha/koha/marc
In directory usw-pr-cvs1:/tmp/cvs-serv24598
Modified Files:
marcschema.sql
Log Message:
Further simplifications to the marc schema specification
Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** marcschema.sql 16 May 2002 20:42:55 -0000 1.5
--- marcschema.sql 29 May 2002 21:11:41 -0000 1.6
***************
*** 1,2 ****
--- 1,5 ----
+
+ # These first three tables store the data from a MARC record.
+
# marc_biblio contains 1 record for each biblio in the DB
CREATE TABLE marc_biblio (
***************
*** 10,223 ****
! # marc_NXX_tag_table contains 1 record for each tag of every biblio
!
! CREATE TABLE marc_0XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_1XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_2XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_3XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_4XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_5XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_6XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_7XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_8XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
! CREATE TABLE marc_9XX_tag_table (
! tagid bigint(20) unsigned NOT NULL auto_increment,
! bibid bigint(20) NOT NULL default '0',
! tagnumber char(3) NOT NULL default '',
! tagorder tinyint(4) NOT NULL default '0',
! indicator char(2) NOT NULL default '',
! PRIMARY KEY (tagid),
! KEY (bibid,tagnumber,tagorder)
! ) TYPE=MyISAM;
!
!
! # marc_NXX_subfield_table contains 1 record for each subfield of every tag if
! # the subfield value is more than 255 length, the value is in the
marc_blob_tag
! # table, the valuebloblink contains the number of the blob
!
! CREATE TABLE marc_0XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_1XX_subfield_table (
subfieldid bigint(20) unsigned NOT NULL auto_increment,
tagid bigint(20) NOT NULL default '0',
bibid bigint(20) NOT NULL default '0',
subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
subfieldvalue varchar(255) default NULL,
valuebloblink bigint(20) default NULL,
PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_2XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_3XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_4XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_5XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_6XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_7XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_8XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
! ) TYPE=MyISAM;
! CREATE TABLE marc_9XX_subfield_table (
! subfieldid bigint(20) unsigned NOT NULL auto_increment,
! tagid bigint(20) NOT NULL default '0',
! bibid bigint(20) NOT NULL default '0',
! subfieldorder tinyint(4) NOT NULL default '0',
! subfieldcode char(1) NOT NULL default '',
! subfieldvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,subfieldcode)
) TYPE=MyISAM;
-
# marc_blob_tag containts tag longer than 255 car.
# They are linked to a marc_NXX_tag_table record by bloblink
--- 13,29 ----
! CREATE TABLE marc_subfield_table (
subfieldid bigint(20) unsigned NOT NULL auto_increment,
tagid bigint(20) NOT NULL default '0',
+ tag char(3) NOT NULL default '',
bibid bigint(20) NOT NULL default '0',
subfieldorder tinyint(4) NOT NULL default '0',
! subfieldmark char(1) NOT NULL default '',
subfieldvalue varchar(255) default NULL,
valuebloblink bigint(20) default NULL,
PRIMARY KEY (subfieldid),
! KEY (bibid,tagid,tag,subfieldmark),
) TYPE=MyISAM;
# marc_blob_tag containts tag longer than 255 car.
# They are linked to a marc_NXX_tag_table record by bloblink
***************
*** 228,231 ****
--- 34,55 ----
) TYPE=MyISAM;
+
+
+
+ # The next two tables are used for labelling the tags and subfields for
+ # different implementions of marc USMARC, UNIMARC, CANMARC, UKMARC, etc.
+
+ # marc_tag_structure contains the definition of the marc tags.
+ # any MARC is supposed to be support-able
+ CREATE TABLE marc_tag_structure (
+ tagfield char(3) NOT NULL default '',
+ liblibrarian char(255) NOT NULL default '',
+ libopac char(255) NOT NULL default '',
+ repeatable tinyint(4) NOT NULL default '0',
+ mandatory tinyint(4) NOT NULL default '0',
+ PRIMARY KEY (tagfield)
+ ) TYPE=MyISAM;
+
+
# marc_subfield_structure contains the definition of the marc
# subfields. Any MARC is supposed to be support-able
***************
*** 241,254 ****
) TYPE=MyISAM;
! # marc_tag_structure contains the definition of the marc tags.
! # any MARC is supposed to be support-able
! CREATE TABLE marc_tag_structure (
! tagfield char(3) NOT NULL default '',
! liblibrarian char(255) NOT NULL default '',
! libopac char(255) NOT NULL default '',
! repeatable tinyint(4) NOT NULL default '0',
! mandatory tinyint(4) NOT NULL default '0',
! PRIMARY KEY (tagfield)
! ) TYPE=MyISAM;
# marc_tag_word contains 1 record for each word in each subfield in each tag
in each biblio
--- 65,70 ----
) TYPE=MyISAM;
!
! # This table is the table used for searching the marc records
# marc_tag_word contains 1 record for each word in each subfield in each tag
in each biblio
***************
*** 263,277 ****
KEY sndx_word (sndx_word)
) TYPE=MyISAM;
-
-
-
-
-
-
-
-
-
-
-
-
--- 79,81 ----
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-cvs] CVS: koha/marc marcschema.sql,1.5,1.6,
Steve Tonnesen <=
- Prev by Date:
[Koha-cvs] CVS: koha barcodes.pl,NONE,1.1
- Next by Date:
[Koha-cvs] CVS: koha/marc marcschema.sql,1.6,1.7 perlmarcstructure,1.1,1.2
- Previous by thread:
[Koha-cvs] CVS: koha barcodes.pl,NONE,1.1
- Next by thread:
[Koha-cvs] CVS: koha/marc marcschema.sql,1.6,1.7 perlmarcstructure,1.1,1.2
- Index(es):