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/MuteListStore.migrations b/OpenSim/Data/MySQL/Resources/MuteListStore.migrations
index 5bde63e..164dc51 100644
--- a/OpenSim/Data/MySQL/Resources/MuteListStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/MuteListStore.migrations
@@ -2,7 +2,7 @@
 
 BEGIN;
 
-CREATE TABLE `MuteList` (
+CREATE TABLE IF NOT EXISTS `MuteList` (
   `AgentID` char(36) NOT NULL,
   `MuteID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
   `MuteName` varchar(64) NOT NULL DEFAULT '',
@@ -11,6 +11,6 @@ CREATE TABLE `MuteList` (
   `Stamp` int(11) NOT NULL,
   UNIQUE KEY `AgentID_2` (`AgentID`,`MuteID`,`MuteName`),
   KEY `AgentID` (`AgentID`)
-);
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 COMMIT;