From 3dba170e7d74ae0ef1384d28c06046e1120bacef Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Mon, 24 Apr 2006 06:20:30 +0000
Subject: [PATCH] adding dropindex and addindex for modified tags table

---
 lib/db/migrate2utf8.xml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/lib/db/migrate2utf8.xml b/lib/db/migrate2utf8.xml
index 3ba7dfc61b..87ea7c84dd 100755
--- a/lib/db/migrate2utf8.xml
+++ b/lib/db/migrate2utf8.xml
@@ -33,8 +33,8 @@
     </TABLE>
     <TABLE name="tags">
       <FIELDS>
-        <FIELD name="type" method="NO_CONV" type="varchar" length="255" />
-        <FIELD name="text" method="PHP_FUNCTION" type="varchar" length="255">
+        <FIELD name="type" method="NO_CONV" type="varchar" length="20" dropindex="tags_typeuserid_idx" addindex="tags_typeuserid_idx(type(20), userid)" />
+        <FIELD name="text" method="PHP_FUNCTION" type="varchar" length="255" dropindex="tags_text_idx" addindex="tags_text_idx(text(255))">
           <PHP_FUNCTION>
             migrate2utf8_tags_text(RECORDID)
           </PHP_FUNCTION>
-- 
2.39.5