aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/AuthStore.migrations
diff options
context:
space:
mode:
authorDavid Walter Seikel2013-02-23 07:20:32 +1000
committerDavid Walter Seikel2013-02-23 07:20:32 +1000
commit18af255e90b54b7b1d39eb20f4932ba433bc7b55 (patch)
treed5559672bfe22a6fca85a5722d9537a376f941f7 /OpenSim/Data/MySQL/Resources/AuthStore.migrations
parentAdd IG version bits. (diff)
downloadopensim-SC-18af255e90b54b7b1d39eb20f4932ba433bc7b55.zip
opensim-SC-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.gz
opensim-SC-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.bz2
opensim-SC-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.xz
MyISAM is much better performing for OpenSim.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/AuthStore.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/AuthStore.migrations4
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/Resources/AuthStore.migrations b/OpenSim/Data/MySQL/Resources/AuthStore.migrations
index 023c786..9450940 100644
--- a/OpenSim/Data/MySQL/Resources/AuthStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/AuthStore.migrations
@@ -8,7 +8,7 @@ CREATE TABLE `auth` (
8 `passwordSalt` char(32) NOT NULL default '', 8 `passwordSalt` char(32) NOT NULL default '',
9 `webLoginKey` varchar(255) NOT NULL default '', 9 `webLoginKey` varchar(255) NOT NULL default '',
10 PRIMARY KEY (`UUID`) 10 PRIMARY KEY (`UUID`)
11) ENGINE=InnoDB; 11) ENGINE=MyISAM;
12 12
13CREATE TABLE `tokens` ( 13CREATE TABLE `tokens` (
14 `UUID` char(36) NOT NULL, 14 `UUID` char(36) NOT NULL,
@@ -18,7 +18,7 @@ CREATE TABLE `tokens` (
18 KEY `UUID` (`UUID`), 18 KEY `UUID` (`UUID`),
19 KEY `token` (`token`), 19 KEY `token` (`token`),
20 KEY `validity` (`validity`) 20 KEY `validity` (`validity`)
21) ENGINE=InnoDB; 21) ENGINE=MyISAM;
22 22
23commit; 23commit;
24 24