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

[Steve Tonnesen]

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

Modified Files:
        marcschema.sql 
Log Message:
Splitting into separate tag and subfield tables


Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** marcschema.sql      30 May 2002 08:11:51 -0000      1.9
--- marcschema.sql      31 May 2002 19:36:08 -0000      1.10
***************
*** 3,7 ****
        
  # 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',
--- 3,7 ----
        
  # 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',
***************
*** 12,32 ****
                ) TYPE=MyISAM;
  
  
- 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.
--- 12,37 ----
                ) TYPE=MyISAM;
  
+ CREATE TABLE marc_field_table_sergey (
+        fieldid  bigint(20) unsigned NOT NULL auto_increment,    # field 
identifier
+        bibid    bigint(20) NOT NULL default '0',                # biblio 
identifier
+        tagid    bigint(20) NOT NULL default '0',              # tag identifier
+        tag      char(3) NOT NULL default '',                  # tag number 
(eg 110)
+        PRIMARY KEY (fieldid),
+        KEY (bibid),
+        KEY (tagid),
+        KEY (tag)
+ );
+ 
+ CREATE TABLE marc_subfield_table_sergey (
+        subfieldid  bigint(20) unsigned NOT NULL auto_increment,       # 
subfield identifier
+        fieldid bigint(20),                                    # field 
identifier
+        subfieldorder tinyint(4) NOT NULL default '0',         # display order 
for subfields
+        subfieldcode char(1) NOT NULL default '',              # subfield code
+        subfieldvalue varchar(255) default NULL,                       # the 
subfields value if not longer than 255 char
+        valuebloblink bigint(20) default NULL,                 # the link to 
the blob, if value is longer than 255 char
+        PRIMARY KEY (subfieldid),
+        KEY (fieldid)
+ );
  
  
  # marc_blob_subfield containts subfields longer than 255 car.