From 59fbe479e3ab4f51ada4ee45b642e9d3f0bccec9 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Tim=20D=C3=BCsterhus?= Date: Wed, 27 Jan 2021 11:47:10 +0100 Subject: [PATCH] Remove the languageID column from keys in wcf1_tag_to_object This column is functionally dependent on tagID. Since the previous commits this column is no longer used and only filled for backwards compatibility. See #3803 --- wcfsetup/setup/db/install.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 3c87fa3b35..4f1dec731b 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1349,8 +1349,8 @@ CREATE TABLE wcf1_tag_to_object ( tagID INT(10) NOT NULL, objectTypeID INT(10) NOT NULL, languageID INT(10) NOT NULL, - UNIQUE KEY (objectTypeID, languageID, objectID, tagID), - KEY (objectTypeID, languageID, tagID), + UNIQUE KEY (objectTypeID, objectID, tagID), + KEY (objectTypeID, tagID), KEY (tagID, objectTypeID) ); -- 2.20.1