From 40381db00dd0182abbff2922406a9222dd4e8141 Mon Sep 17 00:00:00 2001
From: Matthias Schmidt <gravatronics@live.com>
Date: Fri, 7 Jun 2013 18:55:06 +0200
Subject: [PATCH] Adds languageID to wcf1_search_index's unique key

---
 wcfsetup/setup/db/install.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql
index f3d518a35d..bb9c5f5e59 100644
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -758,7 +758,7 @@ CREATE TABLE wcf1_search_index (
 	userID INT(10),
 	username VARCHAR(255) NOT NULL DEFAULT '',
 	languageID INT(10),
-	UNIQUE KEY (objectTypeID, objectID),
+	UNIQUE KEY (objectTypeID, objectID, languageID),
 	FULLTEXT INDEX fulltextIndex (subject, message, metaData),
 	FULLTEXT INDEX fulltextIndexSubjectOnly (subject),
 	KEY (userID, objectTypeID, time)
-- 
2.20.1