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

[Paul POULAIN]

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

Modified Files:
        marcschema.sql 
Log Message:
some more cleaning : removed duplicated row, added indexes


Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -r1.7 -r1.8
*** marcschema.sql      29 May 2002 22:11:20 -0000      1.7
--- marcschema.sql      30 May 2002 08:00:56 -0000      1.8
***************
*** 15,27 ****
  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',
                subfieldcode char(1) NOT NULL default '',
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
                PRIMARY KEY (subfieldid),
!               KEY (bibid,tagid,tag,subfieldcode),
                ) TYPE=MyISAM;
  
--- 15,29 ----
  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;