diff options
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/Updater.java | 3 |
1 files changed, 2 insertions, 1 deletions
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"); |