[Koha-cvs] CVS: koha/marc/benchmarks benchmarkschema,1.2,1.3

[Steve Tonnesen]

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

Modified Files:
        benchmarkschema 
Log Message:
Changed subfieldmark back to subfieldcode


Index: benchmarkschema
===================================================================
RCS file: /cvsroot/koha/koha/marc/benchmarks/benchmarkschema,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** benchmarkschema     22 May 2002 16:00:51 -0000      1.2
--- benchmarkschema     29 May 2002 22:11:20 -0000      1.3
***************
*** 1,12 ****
! 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',
!               tagvalue varchar(255) default NULL,
!               valuebloblink bigint(20) default NULL,
!               PRIMARY KEY  (bibcode,tagnumber,tagorder)
!               ) TYPE=MyISAM;
! 
! CREATE TABLE marc_2XX_subfield_table (
                subfieldid bigint(20) unsigned NOT NULL auto_increment,
                tagid bigint(20) NOT NULL default '0',
--- 1,3 ----
! CREATE TABLE marc_subfield_table (
                subfieldid bigint(20) unsigned NOT NULL auto_increment,
                tagid bigint(20) NOT NULL default '0',
***************
*** 14,23 ****
                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),
!               KEY (bibid,tag,subfieldcode,subfieldvalue)
                ) TYPE=MyISAM;
- 
--- 5,12 ----
                bibid bigint(20) NOT NULL default '0',
                subfieldorder tinyint(4) NOT NULL default '0',
!               subfieldmark char(1) NOT NULL default '',
                subfieldvalue varchar(255) default NULL,
                valuebloblink bigint(20) default NULL,
                PRIMARY KEY (subfieldid),
!               KEY (bibid,tagid,tag,subfieldmark),
                ) TYPE=MyISAM;