sql/core_notify.sql

diff --git a/sql/core_notify.sql b/sql/core_notify.sql
index 8e5398f..6c6bbb6 100644 (file)
--- a/sql/core_notify.sql
+++ b/sql/core_notify.sql
@@ -35,5 +35,5 @@ ALTER TABLE core_notify DROP INDEX lookup_a;
 
 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);
-ALTER TABLE core_notify ADD   INDEX lookup_e(onid, ontable, person_id, act_when, msgid);
-ALTER TABLE core_notify ADD   INDEX lookup_f(onid, ontable, person_id, act_when, to_email);
\ No newline at end of file
+ALTER TABLE core_notify ADD   INDEX lookup_e(onid, ontable, person_id, act_when;
+ALTER TABLE core_notify ADD   INDEX lookup_f(msgid, to_email);
\ No newline at end of file