[Koha-cvs] CVS: koha/marc marcschema.sql,1.8,1.9

[Paul POULAIN]

Update of /cvsroot/koha/koha/marc
In directory usw-pr-cvs1:/tmp/cvs-serv22974

Modified Files:
        marcschema.sql 
Log Message:
* modification of tables/row names : *_tag_* replaced by *_subfield_* where 
needed
* modification of word table



Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -r1.8 -r1.9
*** marcschema.sql      30 May 2002 08:00:56 -0000      1.8
--- marcschema.sql      30 May 2002 08:11:51 -0000      1.9
***************
*** 15,36 ****
  CREATE TABLE marc_subfield_table (
                subfieldid bigint(20) unsigned NOT NULL auto_increment,
!               bibid bigint(20) NOT NULL default '0',
!               tag char(3) NOT NULL default '',
!               subfieldcode char(1) NOT NULL default '',
!               subfieldorder tinyint(4) NOT NULL default '0',
!               subfieldvalue varchar(255) default NULL,
!               valuebloblink bigint(20) default NULL,
                PRIMARY KEY (subfieldid),
!               KEY bibid (bibid),
!               KEY (tag),
                KEY (subfieldcode),
                KEY (subfieldorder)
                ) TYPE=MyISAM;
  
! # marc_blob_tag containts tag longer than 255 car.
! # They are linked to a marc_NXX_tag_table record by bloblink
        CREATE TABLE marc_blob_tag (
                blobidlink bigint(20) NOT NULL auto_increment,
!               tagvalue longtext NOT NULL,
                PRIMARY KEY  (blobidlink)
                ) TYPE=MyISAM;
--- 15,38 ----
  CREATE TABLE marc_subfield_table (
                subfieldid bigint(20) unsigned NOT NULL auto_increment,
!               bibid bigint(20) NOT NULL default '0',                  # 
biblio idendifier
!               tag char(3) NOT NULL default '',                        # tag 
number (110)
!               tagorder tinyint(4) NOT NULL default '1',               # used 
when a tag is repeatable, from 1 to N
!               subfieldcode char(1) NOT NULL default '',               # 
subfieldcode (a)
!               subfieldorder tinyint(4) NOT NULL default '1',          # used 
when a subfield is repeatable, from 1 to N
!               subfieldvalue varchar(255) default NULL,                # the 
subfield value, is not longer than 255 char
!               valuebloblink bigint(20) default NULL,                  # the 
link to the blob, if subfield value is longer than 255 char
                PRIMARY KEY (subfieldid),
!               KEY bibid (bibid),                                      # BRUTE 
indexes : we index all the fields except subfieldvalue
!               KEY (tag),                                              # 
should have to be optimized later
!               KEY (tagorder),
                KEY (subfieldcode),
                KEY (subfieldorder)
                ) TYPE=MyISAM;
  
! # marc_blob_subfield containts subfields longer than 255 car.
! # They are linked to a marc_subfield_table record by bloblink
        CREATE TABLE marc_blob_tag (
                blobidlink bigint(20) NOT NULL auto_increment,
!               subfieldvalue longtext NOT NULL,
                PRIMARY KEY  (blobidlink)
                ) TYPE=MyISAM;
***************
*** 71,81 ****
  
  # 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)
--- 73,89 ----
  
  # marc_tag_word contains 1 record for each word in each subfield in each tag 
in each biblio
!       CREATE TABLE marc_word (
                bibid bigint(20) NOT NULL default '0',
!               tag char(3) NOT NULL default '',
!               tagorder tinyint(4) NOT NULL default '1',
                subfieldid char(1) NOT NULL default '',
+               subfieldorder tinyint(4) NOT NULL default '1',
                word varchar(255) NOT NULL default '',
                sndx_word varchar(255) NOT NULL default '',     # the soundex 
version of the word (indexed)
!               KEY bibid (bibid),
!               KEY tag (tag),
!               KEY tagorder (tagorder),
!               KEY subfieldid (subfieldid),
!               KEY subfieldorder (subfieldorder),
                KEY word (word),
                KEY sndx_word (sndx_word)