From a339855b4c85812e0c7e35ff3f83a8534fc24289 Mon Sep 17 00:00:00 2001
From: Frank Karlitschek <frank@owncloud.org>
Date: Sat, 31 May 2014 16:55:50 +0200
Subject: [PATCH] add another index to the filecache to reduce the number of
 queries without a matching index

---
 db_structure.xml | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

diff --git a/db_structure.xml b/db_structure.xml
index 21ac47a781b..95db8d1f9fb 100644
--- a/db_structure.xml
+++ b/db_structure.xml
@@ -400,6 +400,21 @@
 				</field>
 			</index>
 
+			<index>
+				<name>fs_storage_size</name>
+				<field>
+					<name>storage</name>
+					<sorting>ascending</sorting>
+				</field>
+				<field>
+					<name>size</name>
+					<sorting>ascending</sorting>
+				</field>
+				<field>
+					<name>fileid</name>
+				</field>
+			</index>
+
 		</declaration>
 
 	</table>
-- 
2.39.5