From bc4f07e76e516336feabea0caac5f079f8debdb0 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Sun, 11 Dec 2016 22:53:52 +0100 Subject: [PATCH] Added composite index for modification log --- wcfsetup/setup/db/install.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 14e6da4048..542e00ab22 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -706,7 +706,9 @@ CREATE TABLE wcf1_modification_log ( username VARCHAR(255) NOT NULL DEFAULT '', time INT(10) NOT NULL DEFAULT 0, action VARCHAR(80) NOT NULL, - additionalData MEDIUMTEXT + additionalData MEDIUMTEXT, + + KEY objectTypeAndID (objectTypeID, objectID) ); DROP TABLE IF EXISTS wcf1_notice; -- 2.20.1