From ec5e5fc7b345a7c6fcf6634cbc7d82bc229fcdd4 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Tim=20D=C3=BCsterhus?= Date: Wed, 27 Jan 2021 11:52:30 +0100 Subject: [PATCH] Make wcf1_tag_to_object's PRIMARY KEY a UNIQUE KEY see #3803 --- 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 a30a0a2578..16f4a169d9 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1349,7 +1349,7 @@ CREATE TABLE wcf1_tag_to_object ( tagID INT(10) NOT NULL, objectTypeID INT(10) NOT NULL, languageID INT(10) NOT NULL, - UNIQUE KEY (objectTypeID, objectID, tagID), + PRIMARY KEY (objectTypeID, objectID, tagID), KEY (objectTypeID, tagID), KEY (tagID) ); -- 2.20.1