From d6bcc229eba25ae240322f48ea3f31b832d55ab4 Mon Sep 17 00:00:00 2001
From: onefang
Date: Sun, 19 May 2019 21:56:12 +1000
Subject: Various database fixups.

InnoDB -> MyISAM
utf8
if not exists
white space
---
 .../Data/MySQL/Resources/HGTravelStore.migrations  | 23 +++++++++++-----------
 1 file changed, 11 insertions(+), 12 deletions(-)

(limited to 'OpenSim/Data/MySQL/Resources/HGTravelStore.migrations')

diff --git a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
index b4e4422..ed1fede 100644
--- a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
@@ -2,17 +2,16 @@
 
 BEGIN;
 
-CREATE TABLE `hg_traveling_data` (
-    `SessionID` VARCHAR(36) NOT NULL,
-    `UserID` VARCHAR(36) NOT NULL,
-	`GridExternalName` VARCHAR(255) NOT NULL DEFAULT '',
-	`ServiceToken` VARCHAR(255) NOT NULL DEFAULT '',
-	`ClientIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
-	`MyIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
-    `TMStamp` timestamp NOT NULL,
-    PRIMARY KEY  (`SessionID`),
-	KEY (`UserID`)
-) ENGINE=InnoDB;
+CREATE TABLE IF NOT EXISTS `hg_traveling_data` (
+  `SessionID` VARCHAR(36) NOT NULL,
+  `UserID` VARCHAR(36) NOT NULL,
+  `GridExternalName` VARCHAR(255) NOT NULL DEFAULT '',
+  `ServiceToken` VARCHAR(255) NOT NULL DEFAULT '',
+  `ClientIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
+  `MyIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
+  `TMStamp` timestamp NOT NULL,
+  PRIMARY KEY  (`SessionID`),
+  KEY (`UserID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 COMMIT;
-
-- 
cgit v1.1