From a92a7cc35115dba2c3a7cf98cb08a9ae0795da5a Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 16 Aug 2017 18:22:12 +0200
Subject: [locationinfo] Fix davinci backend connection test, minor tweaks to
 web view

---
 modules-available/locationinfo/install.inc.php | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'modules-available/locationinfo/install.inc.php')

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)) {
-- 
cgit v1.2.3-55-g7522