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/Migration.cs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim/Data/Migration.cs')

diff --git a/OpenSim/Data/Migration.cs b/OpenSim/Data/Migration.cs
index e54bf55..661f9c1 100644
--- a/OpenSim/Data/Migration.cs
+++ b/OpenSim/Data/Migration.cs
@@ -123,7 +123,7 @@ namespace OpenSim.Data
             if (ver <= 0)   // -1 = no table, 0 = no version record
             {
                 if (ver < 0)
-                    ExecuteScript("create table migrations(name varchar(100), version int)");
+                    ExecuteScript("create table if not exists migrations(name varchar(100), version int) ENGINE=MyISAM DEFAULT CHARSET=utf8");
                 InsertVersion("migrations", 1);
             }
         }
-- 
cgit v1.1