From 6bb15d29daac4b39d2b184928d5c4fa50e7456ab Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 17 Nov 2007 14:01:24 +0000
Subject: - Patch #192348 by douggreen and bjaspan: fixed database
 inconsistencies.

---
 modules/system/system.install | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/system/system.install')

diff --git a/modules/system/system.install b/modules/system/system.install
index f51c2e54c..03250d52c 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -4515,7 +4515,7 @@ function system_update_6036() {
       // Since it's possible that some existing sites have duplicates,
       // create the index using the IGNORE keyword, which ignores duplicate errors.
       // However, pgsql doesn't support it
-      $ret[] = update_sql("ALTER IGNORE TABLE {search_index} ADD UNIQUE KEY sid_word_type (sid, word, type)");
+      $ret[] = update_sql("ALTER IGNORE TABLE {search_index} ADD UNIQUE KEY word_sid_type (word, sid, type)");
       $ret[] = update_sql("ALTER IGNORE TABLE {search_dataset} ADD UNIQUE KEY sid_type (sid, type)");
     }
     else {
-- 
cgit v1.2.3