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/InventoryStore.migrations | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'OpenSim/Data/MySQL/Resources/InventoryStore.migrations') diff --git a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations index 2d4384c..7283e41 100644 --- a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations +++ b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations @@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `inventoryitems` ( PRIMARY KEY (`inventoryID`), KEY `inventoryitems_avatarid` (`avatarID`), KEY `inventoryitems_parentFolderid` (`parentFolderID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `inventoryfolders` ( `folderName` varchar(64) DEFAULT NULL, @@ -37,6 +37,6 @@ CREATE TABLE IF NOT EXISTS `inventoryfolders` ( PRIMARY KEY (`folderID`), KEY `inventoryfolders_agentid` (`agentID`), KEY `inventoryfolders_parentFolderid` (`parentFolderID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; COMMIT; -- cgit v1.1