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

[Steve Tonnesen]

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

Modified Files:
        marcschema.sql 
Log Message:
removed fieldid in favour of tagid, removed _sergey from table names, added
tagorder field to tag table, renamed marc_field_table to marc_tag_table.


Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -r1.10 -r1.11
*** marcschema.sql      31 May 2002 19:36:08 -0000      1.10
--- marcschema.sql      31 May 2002 19:41:29 -0000      1.11
***************
*** 1,3 ****
! 
  #  These first three tables store the data from a MARC record.
        
--- 1,11 ----
! #  $Id$
! #  
! #  $Log$
! #  Revision 1.11  2002/05/31 19:41:29  tonnesen
! #  removed fieldid in favour of tagid, removed _sergey from table names, added
! #  tagorder field to tag table, renamed marc_field_table to marc_tag_table.
! #
! #
! #
  #  These first three tables store the data from a MARC record.
        
***************
*** 12,23 ****
                ) 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)
  );
--- 20,30 ----
                ) TYPE=MyISAM;
  
! CREATE TABLE marc_tag_table (
!        tagid    bigint(20) unsigned NOT NULL auto_increment,  # tag identifier
         bibid    bigint(20) NOT NULL default '0',                # biblio 
identifier
         tag      char(3) NOT NULL default '',                  # tag number 
(eg 110)
!        tagorder tinyint(4) NOT NULL default '0',              # display order 
of tag within a record
!        PRIMARY KEY (tagid),
         KEY (bibid),
         KEY (tag)
  );
***************
*** 25,35 ****
  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)
  );
  
--- 32,42 ----
  CREATE TABLE marc_subfield_table_sergey (
         subfieldid  bigint(20) unsigned NOT NULL auto_increment,       # 
subfield identifier
!        tagid bigint(20),                                      # tag identifier
!        subfieldorder tinyint(4) NOT NULL default '0',         # display order 
for subfields within a tag
         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 (tagid)
  );