From 6efc4645ec2646e5a873d6b502d64750ee10e32b Mon Sep 17 00:00:00 2001 From: =?utf8?q?Tim=20D=C3=BCsterhus?= Date: Tue, 16 Aug 2016 16:55:35 +0200 Subject: [PATCH] Add KEY for wcf1_user_notification.confirmTime see DailyMailNotificationCronjob::execute() --- 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 dbffcf1581..9473072e7b 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1477,7 +1477,8 @@ CREATE TABLE wcf1_user_notification ( confirmTime INT(10) NOT NULL DEFAULT 0, additionalData TEXT, KEY (userID, eventID, objectID, confirmTime), - KEY (userID, confirmTime) + KEY (userID, confirmTime), + KEY (confirmTime) ); -- notification authors (stacking) -- 2.20.1