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/InventoryStore.migrations b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations
index 2d4384c..7283e41 100644
--- a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations
@@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `inventoryitems` (
   PRIMARY KEY (`inventoryID`),
   KEY `inventoryitems_avatarid` (`avatarID`),
   KEY `inventoryitems_parentFolderid` (`parentFolderID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `inventoryfolders` (
   `folderName` varchar(64) DEFAULT NULL,
@@ -37,6 +37,6 @@ CREATE TABLE IF NOT EXISTS `inventoryfolders` (
   PRIMARY KEY (`folderID`),
   KEY `inventoryfolders_agentid` (`agentID`),
   KEY `inventoryfolders_parentFolderid` (`parentFolderID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 COMMIT;