From 19332a7b0e67c0d7a2c813431d2a4e24c22075e5 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 16 Sep 2015 10:32:43 +0200
Subject: [server] Add missing index to imageversion table

---
 dozentenmodulserver/setup/sat-01-schema.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'dozentenmodulserver/setup')

diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql
index eadd5e4d..6a4e6800 100644
--- a/dozentenmodulserver/setup/sat-01-schema.sql
+++ b/dozentenmodulserver/setup/sat-01-schema.sql
@@ -79,7 +79,8 @@ CREATE TABLE IF NOT EXISTS `imageversion` (
   PRIMARY KEY (`imageversionid`),
   KEY `version_access` (`imagebaseid`,`isvalid`,`createtime`),
   KEY `fk_imageversion_2_idx` (`uploaderid`),
-  KEY `expire_index` (`expiretime`)
+  KEY `expire_index` (`expiretime`),
+  KEY `deletestate` (`deletestate`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
 CREATE TABLE IF NOT EXISTS `imageversion_x_software` (
-- 
cgit v1.2.3-55-g7522