From bbd69c1e815c8c8be8265b4dc0554ae60e1ca7f6 Mon Sep 17 00:00:00 2001 From: friendica <info@friendica.com> Date: Mon, 18 Nov 2013 19:54:02 -0800 Subject: drop the queue table which we no longer use --- install/update.php | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'install/update.php') diff --git a/install/update.php b/install/update.php index e1fd8c7a4..f608075fc 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1081 ); +define( 'UPDATE_VERSION' , 1082 ); /** * @@ -896,3 +896,10 @@ ADD INDEX ( `expires` ) "); return UPDATE_SUCCESS; return UPDATE_FAILED; } + +function update_r1081() { + $r = q("DROP TABLE `queue` "); + if($r) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +} -- cgit v1.2.3 From d37f4da37b62bdeabe8fbf048493bfca3ebd6a2d Mon Sep 17 00:00:00 2001 From: friendica <info@friendica.com> Date: Mon, 18 Nov 2013 20:10:53 -0800 Subject: remove the challenge table as well --- install/update.php | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'install/update.php') diff --git a/install/update.php b/install/update.php index f608075fc..31eac2963 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1082 ); +define( 'UPDATE_VERSION' , 1083 ); /** * @@ -903,3 +903,10 @@ function update_r1081() { return UPDATE_SUCCESS; return UPDATE_FAILED; } + +function update_r1082() { + $r = q("DROP TABLE `challenge` "); + if($r) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +} -- cgit v1.2.3 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/update.php | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'install/update.php') 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; +} + -- cgit v1.2.3