[Koha-cvs] CVS: koha/marc marcschema.sql,1.3,1.4
Steve Tonnesen
tonnesen at users.sourceforge.net
Thu May 16 22:27:14 CEST 2002
Update of /cvsroot/koha/koha/marc
In directory usw-pr-cvs1:/tmp/cvs-serv9731
Modified Files:
marcschema.sql
Log Message:
Added marc_NXX_subfield_table tables
Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** marcschema.sql 16 May 2002 16:20:40 -0000 1.3
--- marcschema.sql 16 May 2002 20:27:12 -0000 1.4
***************
*** 1,106 ****
# marc_biblio contains 1 record for each biblio in the DB
CREATE TABLE marc_biblio (
! bibcode bigint(20) unsigned NOT NULL auto_increment,
datecreated date NOT NULL default '0000-00-00',
datemodified date default NULL,
origincode char(20) default NULL,
! PRIMARY KEY (bibcode),
KEY origincode (origincode)
) TYPE=MyISAM;
! # marc NXX_table contains 1 record for each tag of every biblio
! # if the tag 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_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_1XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_2XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_3XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_4XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_5XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_6XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_7XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_8XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
! valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
CREATE TABLE marc_9XX_tag_table (
! bibcode 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 '',
! tagvalue varchar(255) default NULL,
valuebloblink bigint(20) default NULL,
! PRIMARY KEY (bibcode,tagnumber,tagorder)
) TYPE=MyISAM;
# marc_blob_tag containts tag longer than 255 car.
--- 1,222 ----
# marc_biblio contains 1 record for each biblio in the DB
CREATE TABLE marc_biblio (
! bibid bigint(20) unsigned NOT NULL auto_increment,
datecreated date NOT NULL default '0000-00-00',
datemodified date default NULL,
origincode char(20) default NULL,
! PRIMARY KEY (bibid),
KEY origincode (origincode)
) TYPE=MyISAM;
! # 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 (subfieldcode),
! 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 (subfieldcode),
! 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 (subfieldcode),
+ 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 (subfieldcode),
+ 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 (subfieldcode),
+ 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 (subfieldcode),
+ 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 (subfieldcode),
+ 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 (subfieldcode),
+ 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 (subfieldcode),
+ 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 (subfieldcode),
+ KEY (bibid,tagid,subfieldcode)
+ ) TYPE=MyISAM;
+
# marc_blob_tag containts tag longer than 255 car.
***************
*** 138,147 ****
# marc_tag_word contains 1 record for each word in each subfield in each tag in each biblio
CREATE TABLE marc_tag_word (
! bibcode bigint(20) NOT NULL default '0',
tagnumber char(3) NOT NULL default '',
subfieldid char(1) NOT NULL default '',
word varchar(255) NOT NULL default '',
sndx_word varchar(255) NOT NULL default '', # the soundex version of the word (indexed)
! PRIMARY KEY (bibcode,tagnumber,subfieldid),
KEY word (word),
KEY sndx_word (sndx_word)
--- 254,263 ----
# marc_tag_word contains 1 record for each word in each subfield in each tag in each biblio
CREATE TABLE marc_tag_word (
! bibid bigint(20) NOT NULL default '0',
tagnumber char(3) NOT NULL default '',
subfieldid char(1) NOT NULL default '',
word varchar(255) NOT NULL default '',
sndx_word varchar(255) NOT NULL default '', # the soundex version of the word (indexed)
! PRIMARY KEY (bibid,tagnumber,subfieldid),
KEY word (word),
KEY sndx_word (sndx_word)
More information about the Koha-cvs
mailing list