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/UserStore.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/UserStore.migrations | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/OpenSim/Data/MySQL/Resources/UserStore.migrations b/OpenSim/Data/MySQL/Resources/UserStore.migrations index f054611..9129075 100644 --- a/OpenSim/Data/MySQL/Resources/UserStore.migrations +++ b/OpenSim/Data/MySQL/Resources/UserStore.migrations | |||
@@ -21,7 +21,7 @@ CREATE TABLE `agents` ( | |||
21 | PRIMARY KEY (`UUID`), | 21 | PRIMARY KEY (`UUID`), |
22 | UNIQUE KEY `session` (`sessionID`), | 22 | UNIQUE KEY `session` (`sessionID`), |
23 | UNIQUE KEY `ssession` (`secureSessionID`) | 23 | UNIQUE KEY `ssession` (`secureSessionID`) |
24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 24 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
25 | 25 | ||
26 | -- Create schema avatar_appearance | 26 | -- Create schema avatar_appearance |
27 | -- | 27 | -- |
@@ -59,7 +59,7 @@ CREATE TABLE `avatarappearance` ( | |||
59 | Skirt_Item char(36) NOT NULL, | 59 | Skirt_Item char(36) NOT NULL, |
60 | Skirt_Asset char(36) NOT NULL, | 60 | Skirt_Asset char(36) NOT NULL, |
61 | PRIMARY KEY (`Owner`) | 61 | PRIMARY KEY (`Owner`) |
62 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 62 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
63 | 63 | ||
64 | SET FOREIGN_KEY_CHECKS=0; | 64 | SET FOREIGN_KEY_CHECKS=0; |
65 | -- ---------------------------- | 65 | -- ---------------------------- |
@@ -71,7 +71,7 @@ CREATE TABLE `userfriends` ( | |||
71 | `friendPerms` INT NOT NULL, | 71 | `friendPerms` INT NOT NULL, |
72 | `datetimestamp` INT NOT NULL, | 72 | `datetimestamp` INT NOT NULL, |
73 | UNIQUE KEY (`ownerID`, `friendID`) | 73 | UNIQUE KEY (`ownerID`, `friendID`) |
74 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 74 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
75 | -- ---------------------------- | 75 | -- ---------------------------- |
76 | -- Table structure for users | 76 | -- Table structure for users |
77 | -- ---------------------------- | 77 | -- ---------------------------- |
@@ -101,7 +101,7 @@ CREATE TABLE `users` ( | |||
101 | `webLoginKey` varchar(36) default NULL, | 101 | `webLoginKey` varchar(36) default NULL, |
102 | PRIMARY KEY (`UUID`), | 102 | PRIMARY KEY (`UUID`), |
103 | UNIQUE KEY `usernames` (`username`,`lastname`) | 103 | UNIQUE KEY `usernames` (`username`,`lastname`) |
104 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 104 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
105 | 105 | ||
106 | -- ---------------------------- | 106 | -- ---------------------------- |
107 | -- Records | 107 | -- Records |
@@ -138,7 +138,7 @@ COMMIT; | |||
138 | 138 | ||
139 | BEGIN; | 139 | BEGIN; |
140 | 140 | ||
141 | CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL, `attachpoint` int(11) NOT NULL, `item` char(36) NOT NULL, `asset` char(36) NOT NULL) ENGINE=InnoDB; | 141 | CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL, `attachpoint` int(11) NOT NULL, `item` char(36) NOT NULL, `asset` char(36) NOT NULL) ENGINE=MyISAM; |
142 | 142 | ||
143 | COMMIT; | 143 | COMMIT; |
144 | 144 | ||