From 266fcb42349546d7b49d9d4eaa92515b02b1effc Mon Sep 17 00:00:00 2001
From: Marcel Werk <burntime@woltlab.com>
Date: Tue, 10 Dec 2013 13:33:53 +0100
Subject: [PATCH] Performance optimization

---
 com.woltlab.wcf/package.xml   | 2 +-
 com.woltlab.wcf/update.sql    | 1 +
 wcfsetup/setup/db/install.sql | 3 ++-
 3 files changed, 4 insertions(+), 2 deletions(-)
 create mode 100644 com.woltlab.wcf/update.sql

diff --git a/com.woltlab.wcf/package.xml b/com.woltlab.wcf/package.xml
index 1877fe99fb..36d6b38c5d 100644
--- a/com.woltlab.wcf/package.xml
+++ b/com.woltlab.wcf/package.xml
@@ -47,7 +47,7 @@
 		<instruction type="file" run="standalone">files_update.tar</instruction>
 		<instruction type="template">templates_update.tar</instruction>
 		<instruction type="script">acp/update_2.0.0.php</instruction>
-		
 		<instruction type="language">language/*.xml</instruction>
+		<instruction type="sql" run="standalone">update.sql</instruction>
 	</instructions>
 </package>
diff --git a/com.woltlab.wcf/update.sql b/com.woltlab.wcf/update.sql
new file mode 100644
index 0000000000..c75e17a0e2
--- /dev/null
+++ b/com.woltlab.wcf/update.sql
@@ -0,0 +1 @@
+ALTER TABLE wcf1_search_index ADD KEY (objectTypeID);
\ No newline at end of file
diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql
index ef7dd4260f..6d3690b63f 100644
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -781,7 +781,8 @@ CREATE TABLE wcf1_search_index (
 	UNIQUE KEY (objectTypeID, objectID, languageID),
 	FULLTEXT INDEX fulltextIndex (subject, message, metaData),
 	FULLTEXT INDEX fulltextIndexSubjectOnly (subject),
-	KEY (userID, objectTypeID, time)
+	KEY (userID, objectTypeID, time),
+	KEY (objectTypeID)
 );
 
 DROP TABLE IF EXISTS wcf1_search_keyword;
-- 
2.20.1