From 78c5071a8f664191c7c837279f7445e280daccf9 Mon Sep 17 00:00:00 2001
From: onefang
Date: Fri, 31 Jul 2020 01:43:03 +1000
Subject: Various database fixups.

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

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

diff --git a/OpenSim/Data/MySQL/Resources/LogStore.migrations b/OpenSim/Data/MySQL/Resources/LogStore.migrations
index 9ac26ac..f2990cc 100644
--- a/OpenSim/Data/MySQL/Resources/LogStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/LogStore.migrations
@@ -1,7 +1,7 @@
 
 :VERSION 1
 
-CREATE TABLE `logs` (
+CREATE TABLE IF NOT EXISTS `logs` (
   `logID` int(10) unsigned NOT NULL auto_increment,
   `target` varchar(36) default NULL,
   `server` varchar(64) default NULL,
@@ -10,4 +10,4 @@ CREATE TABLE `logs` (
   `priority` int(11) default NULL,
   `message` text,
   PRIMARY KEY  (`logID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- 
cgit v1.1


From 804312a2308484cb8eb779a9aa08c0ea8ef8bd52 Mon Sep 17 00:00:00 2001
From: onefang
Date: Tue, 17 Aug 2021 21:19:52 +1000
Subject: MySQL default character set to utfmb4.

Coz on one box they defaulted to utfmb3, which .NET doesn't support.
---
 OpenSim/Data/MySQL/Resources/LogStore.migrations | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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

diff --git a/OpenSim/Data/MySQL/Resources/LogStore.migrations b/OpenSim/Data/MySQL/Resources/LogStore.migrations
index f2990cc..45959d0 100644
--- a/OpenSim/Data/MySQL/Resources/LogStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/LogStore.migrations
@@ -10,4 +10,4 @@ CREATE TABLE IF NOT EXISTS `logs` (
   `priority` int(11) default NULL,
   `message` text,
   PRIMARY KEY  (`logID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
-- 
cgit v1.1