[Koha-cvs] CVS: koha/misc koha.mysql,1.9,1.10

[Paul POULAIN]

Update of /cvsroot/koha/koha/misc
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9571/misc

Modified Files:
	koha.mysql 
Log Message:
adding an index

Index: koha.mysql
===================================================================
RCS file: /cvsroot/koha/koha/misc/koha.mysql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** koha.mysql	12 Nov 2004 16:39:48 -0000	1.9
--- koha.mysql	3 Jan 2005 12:55:22 -0000	1.10
***************
*** 925,929 ****
  # Structure de la table `marc_subfield_structure`
  #
- 
  CREATE TABLE marc_subfield_structure (
    tagfield char(3) NOT NULL default '',
--- 925,928 ----
***************
*** 945,949 ****
    PRIMARY KEY  (frameworkcode,tagfield,tagsubfield),
    KEY tab (frameworkcode,tab),
!   KEY kohafield (frameworkcode,kohafield)
  ) TYPE=MyISAM;
  # --------------------------------------------------------
--- 944,949 ----
    PRIMARY KEY  (frameworkcode,tagfield,tagsubfield),
    KEY tab (frameworkcode,tab),
!   KEY kohafield (frameworkcode,kohafield),
!   KEY kohafield_2 (kohafield)
  ) TYPE=MyISAM;
  # --------------------------------------------------------