From c049e98881c57470ad761cbee408476e3aa91295 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Fri, 25 Aug 2006 17:02:49 +0000
Subject: [PATCH] Indexes on text fields are not allowed

---
 mod/hotpot/db/install.xml | 8 +-------
 1 file changed, 1 insertion(+), 7 deletions(-)

diff --git a/mod/hotpot/db/install.xml b/mod/hotpot/db/install.xml
index c1e15e3c08..76bea300df 100644
--- a/mod/hotpot/db/install.xml
+++ b/mod/hotpot/db/install.xml
@@ -77,9 +77,6 @@
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for hotpot_questions" NEXT="hotpot"/>
         <KEY NAME="hotpot" TYPE="foreign" FIELDS="hotpot" REFTABLE="hotpot" REFFIELDS="id" PREVIOUS="primary"/>
       </KEYS>
-      <INDEXES>
-        <INDEX NAME="name" UNIQUE="false" FIELDS="name"/>
-      </INDEXES>
     </TABLE>
     <TABLE NAME="hotpot_responses" COMMENT="details about responses in Hot Potatoes quiz attempts" PREVIOUS="hotpot_questions" NEXT="hotpot_strings">
       <FIELDS>
@@ -109,9 +106,6 @@
       <KEYS>
         <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for hotpot_strings"/>
       </KEYS>
-      <INDEXES>
-        <INDEX NAME="string" UNIQUE="false" FIELDS="string"/>
-      </INDEXES>
     </TABLE>
   </TABLES>
-</XMLDB>
\ No newline at end of file
+</XMLDB>
-- 
2.39.5