summaryrefslogtreecommitdiffstats
path: root/modules-available/locationinfo/install.inc.php
diff options
context:
space:
mode:
authorSimon Rettberg2017-08-16 18:22:12 +0200
committerSimon Rettberg2017-08-16 18:22:12 +0200
commita92a7cc35115dba2c3a7cf98cb08a9ae0795da5a (patch)
treedb25ac6dacd7d7769c420af854b6a52439b4cd30 /modules-available/locationinfo/install.inc.php
parent[sysconfig] Add support to disable fixNumeric hack in ldadp (diff)
downloadslx-admin-a92a7cc35115dba2c3a7cf98cb08a9ae0795da5a.tar.gz
slx-admin-a92a7cc35115dba2c3a7cf98cb08a9ae0795da5a.tar.xz
slx-admin-a92a7cc35115dba2c3a7cf98cb08a9ae0795da5a.zip
[locationinfo] Fix davinci backend connection test, minor tweaks to web view
Diffstat (limited to 'modules-available/locationinfo/install.inc.php')
-rw-r--r--modules-available/locationinfo/install.inc.php6
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)) {