X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_notify_recur.sql;h=39780d31bf0158ed5129e5d3c2e77a8e704bd3ef;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hp=b107d5c5fb3eb8384410161224ae2aa0461e38d2;hpb=b362c5c141f2ce575cbddf24e93d9465a23e699f;p=Pman.Core

diff --git a/sql/core_notify_recur.sql b/sql/core_notify_recur.sql
index b107d5c5..39780d31 100644
--- a/sql/core_notify_recur.sql
+++ b/sql/core_notify_recur.sql
@@ -30,3 +30,5 @@ ALTER TABLE  core_notify_recur  ADD INDEX lookup(person_id, dtstart, dtend, tz,
 -- old design..
 ALTER TABLE  core_notify_recur  CHANGE COLUMN tz  tz varchar(64)  NOT NULL;
 
+ALTER TABLE core_notify_recur ADD INDEX lookup_person_id (person_id);
+