From f2be7b773bbcf62041424c74fec4f34d25224894 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:05:46 +0800 Subject: [PATCH] sql/core_notify.sql --- sql/core_notify.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/sql/core_notify.sql b/sql/core_notify.sql index 08abc722..6f79c564 100644 --- a/sql/core_notify.sql +++ b/sql/core_notify.sql @@ -42,3 +42,6 @@ ALTER TABLE core_notify ADD INDEX lookup_e (onid, ontable, person_id, act_when ALTER TABLE core_notify ADD INDEX lookup_f (to_email); alter table core_notify add index lookup_g(sent, act_start, act_when); +ALTER TABLE core_notify ADD INDEX lookup_person_id (person_id); +ALTER TABLE core_notify ADD INDEX lookup_trigger_person_id (trigger_person_id); + -- 2.39.2