diff options
author | David Walter Seikel | 2013-02-23 07:20:32 +1000 |
---|---|---|
committer | David Walter Seikel | 2013-02-23 07:20:32 +1000 |
commit | 18af255e90b54b7b1d39eb20f4932ba433bc7b55 (patch) | |
tree | d5559672bfe22a6fca85a5722d9537a376f941f7 /OpenSim/Data/MySQL/Resources/InventoryStore.migrations | |
parent | Add IG version bits. (diff) | |
download | opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.zip opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.gz opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.bz2 opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.xz |
MyISAM is much better performing for OpenSim.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/InventoryStore.migrations | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations index 993a5a0..ca2fe11 100644 --- a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations +++ b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations | |||
@@ -11,7 +11,7 @@ CREATE TABLE `inventoryfolders` ( | |||
11 | PRIMARY KEY (`folderID`), | 11 | PRIMARY KEY (`folderID`), |
12 | KEY `owner` (`agentID`), | 12 | KEY `owner` (`agentID`), |
13 | KEY `parent` (`parentFolderID`) | 13 | KEY `parent` (`parentFolderID`) |
14 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 14 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
15 | 15 | ||
16 | CREATE TABLE `inventoryitems` ( | 16 | CREATE TABLE `inventoryitems` ( |
17 | `inventoryID` varchar(36) NOT NULL default '', | 17 | `inventoryID` varchar(36) NOT NULL default '', |
@@ -36,7 +36,7 @@ CREATE TABLE `inventoryitems` ( | |||
36 | PRIMARY KEY (`inventoryID`), | 36 | PRIMARY KEY (`inventoryID`), |
37 | KEY `owner` (`avatarID`), | 37 | KEY `owner` (`avatarID`), |
38 | KEY `folder` (`parentFolderID`) | 38 | KEY `folder` (`parentFolderID`) |
39 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 39 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
40 | 40 | ||
41 | COMMIT; | 41 | COMMIT; |
42 | 42 | ||