From 7a27a0f9732ff309fda3c0ad3fa20c1118460140 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 19 Aug 2013 14:52:01 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 51961fe0..7de39cf9 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -427,6 +427,7 @@ ALTER TABLE core_notify CHANGE COLUMN bounced event_id INT(11) NOT NULL DEFAULT ALTER TABLE core_notify ADD INDEX lookup(act_when, msgid); ALTER TABLE core_notify ADD INDEX lookup_a(onid, ontable, person_id, act_when, msgid, to_email); alter table core_notify add INDEX lookup_b (sent, person_id, msgid, ontable); +ALTER TABLE core_notify add index lookup_d (person_id, msgid, ontable); -- 2.39.2