From 6593dff9f5b07c76037fa0afc7357089306195c4 Mon Sep 17 00:00:00 2001
From: Mario Vavti <mario@mariovavti.com>
Date: Wed, 28 Feb 2018 10:21:22 +0100
Subject: missed one index in the last update

---
 install/schema_mysql.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 76e6032fc..5cd04467d 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -658,6 +658,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `uid_item_starred` (`uid`, `item_starred`),
   KEY `uid_item_retained` (`uid`, `item_retained`),
   KEY `uid_item_private` (`uid`, `item_private`),
+  KEY `uid_resource_type` (`uid`, `resource_type`),
   KEY `aid` (`aid`),
   KEY `owner_xchan` (`owner_xchan`),
   KEY `author_xchan` (`author_xchan`),
-- 
cgit v1.2.3

