From ebe2b84fa451bb1e72b5618879a5495d4dc1e4ed Mon Sep 17 00:00:00 2001
From: Jannik Schönartz
Date: Sat, 26 Nov 2016 11:33:20 -0800
Subject: Fixed a coordination bug which caused rotation bugs. Deleted the
 locationinfo db and added a setting_location_info all in the install.php

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

(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 f4eaee1f..f94c725e 100644
--- a/modules-available/locationinfo/install.inc.php
+++ b/modules-available/locationinfo/install.inc.php
@@ -11,8 +11,25 @@ $res[] = tableCreate('location_info', '
 	PRIMARY KEY (`locationid`)
 ');
 
+$res[] = tableCreate('setting_location_info', '
+	`serverid` int(10) NOT NULL AUTO_INCREMENT,
+	`serverurl` VARCHAR(2000) NOT NULL,
+	`servertype` VARCHAR(100) NOT NULL,
+	`login` VARCHAR(100) NOT NULL,
+	`passwd` VARCHAR(150) NOT NULL,
+	PRIMARY KEY (`serverid`)
+');
+
 // Create response for browser
 
+if(tableExists('locationinfo')) {
+	$ret = Database::exec("DROP TABLE `locationinfo`");
+	if ($ret === false) {
+		finalResponse(UPDATE_FAILED, 'Droping table locationinfo failed: ' . Database::lastError());
+	}
+	$res[] = UPDATE_DONE;
+}
+
 if (!tableHasColumn('location_info', 'config')) {
 	$ret = Database::exec("ALTER TABLE `location_info` ADD `config` VARCHAR(2000) NOT NULL DEFAULT '' AFTER `openingtime`");
 	if ($ret === false) {
-- 
cgit v1.2.3-55-g7522