Various database fixups.

InnoDB -> MyISAM
utf8
if not exists
white space

1 files changed, 11 insertions, 12 deletions

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;
-