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 'OpenSim/Data/MySQL/Resources/XMute.migrations')
| -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; |