From 4791b2fd9c6dabc9ebb1f42a4993185d85493261 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 20 Nov 2013 21:09:13 -0800
Subject: add aid to notifiy table which we may need to supress duplicate
 notify emails across your channels also try to handle the wretched mess of
 broken and duplicated hublocs that fred.cepheus.uberspace.de typically
 reports

---
 install/database.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'install/database.sql')

diff --git a/install/database.sql b/install/database.sql
index 5496072a9..ef79862c3 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -563,6 +563,7 @@ CREATE TABLE IF NOT EXISTS `notify` (
   `photo` char(255) NOT NULL,
   `date` datetime NOT NULL,
   `msg` mediumtext NOT NULL,
+  `aid` int(11) NOT NULL,
   `uid` int(11) NOT NULL,
   `link` char(255) NOT NULL,
   `parent` int(11) NOT NULL,
@@ -578,7 +579,8 @@ CREATE TABLE IF NOT EXISTS `notify` (
   KEY `hash` (`hash`),
   KEY `parent` (`parent`),
   KEY `link` (`link`),
-  KEY `otype` (`otype`)
+  KEY `otype` (`otype`),
+  KEY `aid` (`aid`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `obj` (
-- 
cgit v1.2.3

