Various database fixups.

InnoDB -> MyISAM
utf8
if not exists
white space

1 files changed, 2 insertions, 2 deletions

diff --git a/OpenSim/Data/MySQL/Resources/AgentPrefs.migrations b/OpenSim/Data/MySQL/Resources/AgentPrefs.migrations
index e496f72..d41ae66 100644
--- a/OpenSim/Data/MySQL/Resources/AgentPrefs.migrations
+++ b/OpenSim/Data/MySQL/Resources/AgentPrefs.migrations
@@ -2,7 +2,7 @@
 
 BEGIN;
 
-CREATE TABLE `AgentPrefs` (
+CREATE TABLE IF NOT EXISTS `AgentPrefs` (
     `PrincipalID` CHAR(36) NOT NULL,
     `AccessPrefs` CHAR(2) NOT NULL DEFAULT 'M',
     `HoverHeight` DOUBLE(30, 27) NOT NULL DEFAULT 0,
@@ -13,6 +13,6 @@ CREATE TABLE `AgentPrefs` (
     `PermNextOwner` INT(6) NOT NULL DEFAULT 532480,
     UNIQUE KEY `PrincipalID` (`PrincipalID`),
     PRIMARY KEY(`PrincipalID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 COMMIT;