aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/AuthStore.migrations
diff options
context:
space:
mode:
authoronefang2019-05-19 21:56:12 +1000
committeronefang2019-05-19 21:56:12 +1000
commitd6bcc229eba25ae240322f48ea3f31b832d55ab4 (patch)
tree7235d35cc1065352e443951fec44c7aadcb4fdfe /OpenSim/Data/MySQL/Resources/AuthStore.migrations
parentDump OpenSim 0.9.0.1 into it's own branch. (diff)
downloadopensim-SC_OLD-d6bcc229eba25ae240322f48ea3f31b832d55ab4.zip
opensim-SC_OLD-d6bcc229eba25ae240322f48ea3f31b832d55ab4.tar.gz
opensim-SC_OLD-d6bcc229eba25ae240322f48ea3f31b832d55ab4.tar.bz2
opensim-SC_OLD-d6bcc229eba25ae240322f48ea3f31b832d55ab4.tar.xz
Various database fixups.
InnoDB -> MyISAM utf8 if not exists white space
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 f00979f..8d24fbd 100644
--- a/OpenSim/Data/MySQL/Resources/AuthStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/AuthStore.migrations
@@ -9,7 +9,7 @@ CREATE TABLE IF NOT EXISTS `auth` (
9 `webLoginKey` varchar(255) NOT NULL DEFAULT '', 9 `webLoginKey` varchar(255) NOT NULL DEFAULT '',
10 `accountType` varchar(32) NOT NULL DEFAULT 'UserAccount', 10 `accountType` varchar(32) NOT NULL DEFAULT 'UserAccount',
11 PRIMARY KEY (`UUID`) 11 PRIMARY KEY (`UUID`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8; 12) ENGINE=MyISAM DEFAULT CHARSET=utf8;
13 13
14CREATE TABLE IF NOT EXISTS `tokens` ( 14CREATE TABLE IF NOT EXISTS `tokens` (
15 `UUID` char(36) NOT NULL, 15 `UUID` char(36) NOT NULL,
@@ -19,6 +19,6 @@ CREATE TABLE IF NOT EXISTS `tokens` (
19 KEY `UUID` (`UUID`), 19 KEY `UUID` (`UUID`),
20 KEY `token` (`token`), 20 KEY `token` (`token`),
21 KEY `validity` (`validity`) 21 KEY `validity` (`validity`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8; 22) ENGINE=MyISAM DEFAULT CHARSET=utf8;
23 23
24COMMIT; 24COMMIT;