From 6e77457e09f57741ddf70816d871c34c8c056f1b Mon Sep 17 00:00:00 2001 From: =?utf8?q?Tim=20D=C3=BCsterhus?= Date: Wed, 27 Jan 2021 11:49:23 +0100 Subject: [PATCH] Remove redundant column from wcf1_tag_to_object.tagID key This key was identical to the `(objectTypeID, tagID)` key. We don't need the objectTypeID here. --- 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 4f1dec731b..a30a0a2578 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1351,7 +1351,7 @@ CREATE TABLE wcf1_tag_to_object ( languageID INT(10) NOT NULL, UNIQUE KEY (objectTypeID, objectID, tagID), KEY (objectTypeID, tagID), - KEY (tagID, objectTypeID) + KEY (tagID) ); DROP TABLE IF EXISTS wcf1_template; -- 2.20.1