From d6bcc229eba25ae240322f48ea3f31b832d55ab4 Mon Sep 17 00:00:00 2001
From: onefang
Date: Sun, 19 May 2019 21:56:12 +1000
Subject: Various database fixups.

InnoDB -> MyISAM
utf8
if not exists
white space
---
 OpenSim/Data/MySQL/Resources/MuteListStore.migrations | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'OpenSim/Data/MySQL/Resources/MuteListStore.migrations')

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;
-- 
cgit v1.1