From 62312370b7ce7010907a70791b0dacb762d332b6 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Tim=20D=C3=BCsterhus?= Date: Tue, 16 Aug 2016 16:58:07 +0200 Subject: [PATCH] Add KEY for wcf1_clipboard_item.userID see ClipboardHandler::loadMarkedItems() --- wcfsetup/setup/db/install.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 9473072e7b..d42a6c78ea 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -355,7 +355,8 @@ CREATE TABLE wcf1_clipboard_item ( objectTypeID INT(10) NOT NULL DEFAULT 0, userID INT(10) NOT NULL DEFAULT 0, objectID INT(10) NOT NULL DEFAULT 0, - UNIQUE KEY (objectTypeID, userID, objectID) + UNIQUE KEY (objectTypeID, userID, objectID), + KEY (userID) ); DROP TABLE IF EXISTS wcf1_clipboard_page; -- 2.20.1