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/FSAssetStore.migrations | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

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

diff --git a/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations b/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations
index 87d08c6..3f65d9e 100644
--- a/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations
@@ -3,7 +3,7 @@
 
 BEGIN;
 
-CREATE TABLE `fsassets` (
+CREATE TABLE IF NOT EXISTS `fsassets` (
   `id` char(36) NOT NULL,
   `name` varchar(64) NOT NULL DEFAULT '',
   `description` varchar(64) NOT NULL DEFAULT '',
@@ -13,6 +13,6 @@ CREATE TABLE `fsassets` (
   `access_time` int(11) NOT NULL DEFAULT '0',
   `asset_flags` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-COMMIT;
\ No newline at end of file
+COMMIT;
-- 
cgit v1.1