diff options
author | onefang | 2019-05-19 21:56:12 +1000 |
---|---|---|
committer | onefang | 2019-05-19 21:56:12 +1000 |
commit | d6bcc229eba25ae240322f48ea3f31b832d55ab4 (patch) | |
tree | 7235d35cc1065352e443951fec44c7aadcb4fdfe /OpenSim/Data/MySQL/Resources/AuthStore.migrations | |
parent | Dump OpenSim 0.9.0.1 into it's own branch. (diff) | |
download | opensim-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.migrations | 4 |
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 | ||
14 | CREATE TABLE IF NOT EXISTS `tokens` ( | 14 | CREATE 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 | ||
24 | COMMIT; | 24 | COMMIT; |