[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;