Issue 9657: Check the age of an item

[friendica.git] / src / Database / View.php

diff --git a/src/Database/View.php b/src/Database/View.php
index bfdcdff7caf7c78a25a74bc72b76e985da859b0b..fd0a8ce1a52cf48a700a5792f9626d7cef1afe6d 100644 (file)
--- a/src/Database/View.php
+++ b/src/Database/View.php
@@ -112,9 +112,9 @@ class View
                }
 
                if (self::isView($name)) {
-                       $sql = sprintf("DROP VIEW `%s`", DBA::escape($name));
+                       $sql = sprintf("DROP VIEW IF EXISTS `%s`", DBA::escape($name));
                } elseif (self::isTable($name)) {
-                       $sql = sprintf("DROP TABLE `%s`", DBA::escape($name));
+                       $sql = sprintf("DROP TABLE IF EXISTS `%s`", DBA::escape($name));
                }
 
                if ($verbose) {
@@ -168,10 +168,10 @@ class View
                $status = DBA::selectFirst(['INFORMATION_SCHEMA' => 'TABLES'], ['TABLE_TYPE'],
                        ['TABLE_SCHEMA' => DBA::databaseName(), 'TABLE_NAME' => $table]);
 
-                       if (empty($status['TABLE_TYPE'])) {
-                               return false;
-                       }
+               if (empty($status['TABLE_TYPE'])) {
+                       return false;
+               }
 
-                       return $status['TABLE_TYPE'] == 'BASE TABLE';
+               return $status['TABLE_TYPE'] == 'BASE TABLE';
        }
 }