diff options
| author | Simon Rettberg | 2018-12-10 11:12:14 +0100 |
|---|---|---|
| committer | Simon Rettberg | 2018-12-10 11:12:14 +0100 |
| commit | 79f968e1ededf1ce81e4c6f21fe84217c57999a4 (patch) | |
| tree | ac4216323f79f60229dfb78ac85498a6971d2f44 | |
| parent | [server] Add scriptname index (diff) | |
| download | tutor-module-79f968e1ededf1ce81e4c6f21fe84217c57999a4.tar.gz tutor-module-79f968e1ededf1ce81e4c6f21fe84217c57999a4.tar.xz tutor-module-79f968e1ededf1ce81e4c6f21fe84217c57999a4.zip | |
[server] Add sharename index
| -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"); |