diff options
Diffstat (limited to 'modules-available/locationinfo/install.inc.php')
| -rw-r--r-- | modules-available/locationinfo/install.inc.php | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/modules-available/locationinfo/install.inc.php b/modules-available/locationinfo/install.inc.php index 10422241..7c47ac90 100644 --- a/modules-available/locationinfo/install.inc.php +++ b/modules-available/locationinfo/install.inc.php @@ -19,7 +19,8 @@ $t2 = $res[] = tableCreate('locationinfo_coursebackend', ' `servertype` VARCHAR(100) NOT NULL, `credentials` BLOB, `error` VARCHAR(500), - PRIMARY KEY (`serverid`) + PRIMARY KEY (`serverid`), + KEY `servername` (`servername`) '); $t3 = $res[] = tableCreate('locationinfo_panel', " @@ -72,6 +73,9 @@ if ($t3 === UPDATE_NOOP) { `paneltype` ENUM('DEFAULT', 'SUMMARY', 'URL') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL"); } +// 2017-07-26 Add servername key +Database::exec("ALTER TABLE `locationinfo_coursebackend` ADD KEY `servername` (`servername`)"); + // Create response for browser if (in_array(UPDATE_RETRY, $res)) { |