From 453a01a3912df68506078126211d7f4563b9fe9e Mon Sep 17 00:00:00 2001
From: tipaul <tipaul>
Date: Mon, 3 Jan 2005 12:55:22 +0000
Subject: [PATCH] adding an index

---
 misc/koha.mysql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/misc/koha.mysql b/misc/koha.mysql
index 15a9393ce4..2166a7fc8b 100644
--- a/misc/koha.mysql
+++ b/misc/koha.mysql
@@ -924,7 +924,6 @@ CREATE TABLE marc_breeding (
 #
 # Structure de la table `marc_subfield_structure`
 #
-
 CREATE TABLE marc_subfield_structure (
   tagfield char(3) NOT NULL default '',
   tagsubfield char(1) NOT NULL default '',
@@ -944,7 +943,8 @@ CREATE TABLE marc_subfield_structure (
   link varchar(80) default NULL,
   PRIMARY KEY  (frameworkcode,tagfield,tagsubfield),
   KEY tab (frameworkcode,tab),
-  KEY kohafield (frameworkcode,kohafield)
+  KEY kohafield (frameworkcode,kohafield),
+  KEY kohafield_2 (kohafield)
 ) TYPE=MyISAM;
 # --------------------------------------------------------
 
-- 
2.39.5