Merge pull request #9474 from annando/faster-expire

[friendica.git] / update.php

diff --git a/update.php b/update.php
index a740019a82d837faa91b5fc25ecaeb2a59d43335..ec6a94f0e3ce982b21ab288e06749860641af10f 100644 (file)
--- a/update.php
+++ b/update.php
@@ -614,6 +614,10 @@ function pre_update_1364()
                return Update::FAILED;
        }
 
+       if (!DBA::e("DELETE FROM `intro` WHERE NOT `uid` IN (SELECT `uid` FROM `user`)")) {
+               return Update::FAILED;
+       }
+
        if (!DBA::e("DELETE FROM `manage` WHERE NOT `uid` IN (SELECT `uid` FROM `user`)")) {
                return Update::FAILED;
        }
@@ -732,3 +736,15 @@ function pre_update_1364()
 
        return Update::SUCCESS;
 }
+
+function pre_update_1365()
+{
+       if (!DBA::e("DELETE FROM `notify-threads` WHERE NOT `notify-id` IN (SELECT `id` FROM `notify`)")) {
+               return Update::FAILED;
+       }
+
+       if (!DBA::e("DELETE FROM `thread` WHERE NOT `iid` IN (SELECT `id` FROM `item`)")) {
+               return Update::FAILED;
+       }
+
+}