From: Alan Knowles <alan@roojs.com>
Date: Mon, 18 Jan 2016 09:55:47 +0000 (+0800)
Subject: sql/core_notify.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=df8a6c778438c98c95850dc077b159c6f52807f8

sql/core_notify.sql
---

diff --git a/sql/core_notify.sql b/sql/core_notify.sql
index 29035cbc..2bb4b9e1 100644
--- a/sql/core_notify.sql
+++ b/sql/core_notify.sql
@@ -33,6 +33,7 @@ ALTER TABLE core_notify ADD   INDEX lookup(act_when, msgid);
 
 ALTER TABLE core_notify DROP INDEX lookup_a;
 
+-- exceed 1000 characters if larger than this..
 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);