diff options
| author | friendica <info@friendica.com> | 2013-11-20 21:09:13 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2013-11-20 21:09:13 -0800 |
| commit | 4791b2fd9c6dabc9ebb1f42a4993185d85493261 (patch) | |
| tree | 4a63752ec22345dabc3e8d07c483046c91547a98 /install/database.sql | |
| parent | eb3d8e2cd7e2bd51035918b4106d1c29b6605505 (diff) | |
| download | volse-hubzilla-4791b2fd9c6dabc9ebb1f42a4993185d85493261.tar.gz volse-hubzilla-4791b2fd9c6dabc9ebb1f42a4993185d85493261.tar.bz2 volse-hubzilla-4791b2fd9c6dabc9ebb1f42a4993185d85493261.zip | |
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
Diffstat (limited to 'install/database.sql')
| -rw-r--r-- | install/database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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` ( |