add a sanity check for tt-rss myisam tables

1 files changed, 15 insertions, 0 deletions

diff --git a/include/functions.php b/include/functions.php
index 4265692ec..ed6f78eef 100644
--- a/include/functions.php
+++ b/include/functions.php
@@ -2546,3 +2546,18 @@
 		}
 	}
 
+	function check_mysql_tables() {
+		$schema = db_escape_string(DB_NAME);
+
+		$result = db_query("SELECT engine, table_name FROM information_schema.tables WHERE
+			table_schema = '$schema' AND table_name LIKE 'ttrss_%' AND engine != 'InnoDB'");
+
+		$bad_tables = [];
+
+		while ($line = db_fetch_assoc($result)) {
+			array_push($bad_tables, $line);
+		}
+
+		return $bad_tables;
+	}
+