Various database fixups.

InnoDB -> MyISAM
utf8
if not exists
white space

1 files changed, 2 insertions, 7 deletions

diff --git a/OpenSim/Data/MySQL/Resources/GridUserStore.migrations b/OpenSim/Data/MySQL/Resources/GridUserStore.migrations
index d08e096..dd73974 100644
--- a/OpenSim/Data/MySQL/Resources/GridUserStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/GridUserStore.migrations
@@ -2,7 +2,7 @@
 
 BEGIN;
 
-CREATE TABLE `GridUser` (
+CREATE TABLE IF NOT EXISTS `GridUser` (
     `UserID` VARCHAR(255) NOT NULL,
     `HomeRegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
     `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
@@ -14,11 +14,6 @@ CREATE TABLE `GridUser` (
     `Login` CHAR(16) NOT NULL DEFAULT '0',
     `Logout` CHAR(16) NOT NULL DEFAULT '0',
     PRIMARY KEY  (`UserID`)
-) ENGINE=InnoDB;
-
-COMMIT;
-
-:VERSION 2         # -------------------------- 
-BEGIN;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 COMMIT;