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/AgentPrefs.migrations | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

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

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