From a9b692cae36e56ec986ed43c5d1ad2c032f4d0f9 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Mon, 10 Dec 2018 11:10:18 +0100
Subject: [server] Add scriptname index

---
 .../src/main/java/org/openslx/bwlp/sat/database/Updater.java           | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/Updater.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/Updater.java
index 26bb1856..e3c2e874 100644
--- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/Updater.java
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/Updater.java
@@ -266,7 +266,8 @@ public class Updater {
 						+ "  passcreds tinyint(1) NOT NULL,"
 						+ "  isglobal tinyint(1) NOT NULL COMMENT 'Whether to apply this script to all lectures',"
 						+ "  PRIMARY KEY (runscriptid),"
-						+ "  KEY isglobal (isglobal)"
+						+ "  KEY isglobal (isglobal),"
+						+ "  KEY scriptname (scriptname)"
 						+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci")
 						.executeUpdate();
 				LOGGER.info("Updated database: Created table presetrunscript");
-- 
cgit v1.2.3-55-g7522