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/XMute.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 '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/XMute.migrations | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/Resources/XMute.migrations b/OpenSim/Data/MySQL/Resources/XMute.migrations index 4ac7f82..084c67b 100644 --- a/OpenSim/Data/MySQL/Resources/XMute.migrations +++ b/OpenSim/Data/MySQL/Resources/XMute.migrations | |||
@@ -2,7 +2,7 @@ | |||
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `XMute` ( | 5 | CREATE TABLE IF NOT EXISTS `XMute` ( |
6 | `AgentID` char(36) NOT NULL, | 6 | `AgentID` char(36) NOT NULL, |
7 | `MuteID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 7 | `MuteID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
8 | `MuteName` varchar(64) NOT NULL DEFAULT '', | 8 | `MuteName` varchar(64) NOT NULL DEFAULT '', |
@@ -11,6 +11,6 @@ CREATE TABLE `XMute` ( | |||
11 | `Stamp` int(11) NOT NULL, | 11 | `Stamp` int(11) NOT NULL, |
12 | UNIQUE KEY `AgentID_2` (`AgentID`,`MuteID`,`MuteName`), | 12 | UNIQUE KEY `AgentID_2` (`AgentID`,`MuteID`,`MuteName`), |
13 | KEY `AgentID` (`AgentID`) | 13 | KEY `AgentID` (`AgentID`) |
14 | ); | 14 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
15 | 15 | ||
16 | COMMIT; | 16 | COMMIT; |