diff options
author | David Walter Seikel | 2016-11-03 22:11:59 +1000 |
---|---|---|
committer | David Walter Seikel | 2016-11-03 22:11:59 +1000 |
commit | 7f7e25be924106a47f0d653bf3b32aa8314e7192 (patch) | |
tree | df1ef6ac7aa206097c1387f96a65e51c2e31bf87 /OpenSim/Data/MySQL/Resources/EstateStore.migrations | |
parent | Usual IG version number in money hack. (diff) | |
download | opensim-SC_OLD-7f7e25be924106a47f0d653bf3b32aa8314e7192.zip opensim-SC_OLD-7f7e25be924106a47f0d653bf3b32aa8314e7192.tar.gz opensim-SC_OLD-7f7e25be924106a47f0d653bf3b32aa8314e7192.tar.bz2 opensim-SC_OLD-7f7e25be924106a47f0d653bf3b32aa8314e7192.tar.xz |
MyISAM is still much better performing for OpenSim.
This time we got the file system asset server, even better still. B-)
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/EstateStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations index 2d1c2b5..9dfb77b 100644 --- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -10,19 +10,19 @@ CREATE TABLE IF NOT EXISTS `estate_managers` ( | |||
10 | `EstateID` int(10) unsigned NOT NULL, | 10 | `EstateID` int(10) unsigned NOT NULL, |
11 | `uuid` char(36) NOT NULL, | 11 | `uuid` char(36) NOT NULL, |
12 | KEY `EstateID` (`EstateID`) | 12 | KEY `EstateID` (`EstateID`) |
13 | ) ENGINE=InnoDB; | 13 | ) ENGINE=MyISAM; |
14 | 14 | ||
15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( | 15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( |
16 | `EstateID` int(10) unsigned NOT NULL, | 16 | `EstateID` int(10) unsigned NOT NULL, |
17 | `uuid` char(36) NOT NULL, | 17 | `uuid` char(36) NOT NULL, |
18 | KEY `EstateID` (`EstateID`) | 18 | KEY `EstateID` (`EstateID`) |
19 | ) ENGINE=InnoDB; | 19 | ) ENGINE=MyISAM; |
20 | 20 | ||
21 | CREATE TABLE IF NOT EXISTS `estate_users` ( | 21 | CREATE TABLE IF NOT EXISTS `estate_users` ( |
22 | `EstateID` int(10) unsigned NOT NULL, | 22 | `EstateID` int(10) unsigned NOT NULL, |
23 | `uuid` char(36) NOT NULL, | 23 | `uuid` char(36) NOT NULL, |
24 | KEY `EstateID` (`EstateID`) | 24 | KEY `EstateID` (`EstateID`) |
25 | ) ENGINE=InnoDB; | 25 | ) ENGINE=MyISAM; |
26 | 26 | ||
27 | CREATE TABLE IF NOT EXISTS `estateban` ( | 27 | CREATE TABLE IF NOT EXISTS `estateban` ( |
28 | `EstateID` int(10) unsigned NOT NULL, | 28 | `EstateID` int(10) unsigned NOT NULL, |
@@ -31,7 +31,7 @@ CREATE TABLE IF NOT EXISTS `estateban` ( | |||
31 | `bannedIpHostMask` varchar(16) NOT NULL, | 31 | `bannedIpHostMask` varchar(16) NOT NULL, |
32 | `bannedNameMask` varchar(64) default NULL, | 32 | `bannedNameMask` varchar(64) default NULL, |
33 | KEY `estateban_EstateID` (`EstateID`) | 33 | KEY `estateban_EstateID` (`EstateID`) |
34 | ) ENGINE=InnoDB; | 34 | ) ENGINE=MyISAM; |
35 | 35 | ||
36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( | 36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( |
37 | `EstateID` int(10) unsigned NOT NULL auto_increment, | 37 | `EstateID` int(10) unsigned NOT NULL auto_increment, |
@@ -60,14 +60,14 @@ CREATE TABLE IF NOT EXISTS `estate_settings` ( | |||
60 | `DenyMinors` tinyint not null, | 60 | `DenyMinors` tinyint not null, |
61 | 61 | ||
62 | PRIMARY KEY (`EstateID`) | 62 | PRIMARY KEY (`EstateID`) |
63 | ) ENGINE=InnoDB AUTO_INCREMENT=100; | 63 | ) ENGINE=MyISAM AUTO_INCREMENT=100; |
64 | 64 | ||
65 | CREATE TABLE IF NOT EXISTS `estate_map` ( | 65 | CREATE TABLE IF NOT EXISTS `estate_map` ( |
66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
67 | `EstateID` int(11) NOT NULL, | 67 | `EstateID` int(11) NOT NULL, |
68 | PRIMARY KEY (`RegionID`), | 68 | PRIMARY KEY (`RegionID`), |
69 | KEY `EstateID` (`EstateID`) | 69 | KEY `EstateID` (`EstateID`) |
70 | ) ENGINE=InnoDB; | 70 | ) ENGINE=MyISAM; |
71 | 71 | ||
72 | COMMIT; | 72 | COMMIT; |
73 | 73 | ||