Add filecache index on mtime

Gives searching by mtime and "recent" a proper index to use

Signed-off-by: Robin Appelman <robin@icewind.nl>

1 files changed, 8 insertions, 0 deletions

diff --git a/core/Application.php b/core/Application.php
index 400d86f5991..336538187d7 100644
--- a/core/Application.php
+++ b/core/Application.php
@@ -71,6 +71,14 @@ class Application extends App {
 						$subject->addHintForMissingSubject($table->getName(), 'parent_index');
 					}
 				}
+
+				if ($schema->hasTable('filecache')) {
+					$table = $schema->getTable('filecache');
+
+					if (!$table->hasIndex('fs_mtime')) {
+						$subject->addHintForMissingSubject($table->getName(), 'fs_mtime');
+					}
+				}
 			}
 		);
 	}