From 25b11f799bef635995cf869ebbfc78dfdaf22cf9 Mon Sep 17 00:00:00 2001
From: Edward <edward@roojs.com>
Date: Thu, 8 Nov 2018 14:06:22 +0800
Subject: [PATCH] sql/core_notify_recur.sql

---
 sql/core_notify_recur.sql | 2 ++
 1 file changed, 2 insertions(+)

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);
+
-- 
2.39.2