From 79f968e1ededf1ce81e4c6f21fe84217c57999a4 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Mon, 10 Dec 2018 11:12:14 +0100
Subject: [server] Add sharename 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 e3c2e874..d82e1279 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
@@ -227,7 +227,8 @@ public class Updater {
 						+ "  `sharename` varchar(100) NOT NULL,"
 						+ "  `sharedata` varchar(500) NOT NULL,"
 						+ "  `active` tinyint(1) NOT NULL DEFAULT '0',"
-						+ "  PRIMARY KEY (`shareid`)"
+						+ "  PRIMARY KEY (`shareid`),"
+						+ "  KEY sharename (`sharename`)"
 						+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");
 				addStmt.executeUpdate();
 				LOGGER.info("Updated database: Added preset network shares");
-- 
cgit v1.2.3-55-g7522