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 | |
| 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')
| -rw-r--r-- | install/database.sql | 4 | ||||
| -rw-r--r-- | install/update.php | 11 |
2 files changed, 13 insertions, 2 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` ( diff --git a/install/update.php b/install/update.php index 31eac2963..f498ec042 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1083 ); +define( 'UPDATE_VERSION' , 1084 ); /** * @@ -910,3 +910,12 @@ function update_r1082() { return UPDATE_SUCCESS; return UPDATE_FAILED; } + +function update_r1083() { + $r = q("ALTER TABLE `notify` ADD `aid` INT NOT NULL AFTER `msg` , +ADD INDEX ( `aid` )"); + if($r) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +} + |