aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/RegionStore.migrations
diff options
context:
space:
mode:
authorDavid Walter Seikel2016-11-03 22:11:59 +1000
committerDavid Walter Seikel2016-11-03 22:11:59 +1000
commit7f7e25be924106a47f0d653bf3b32aa8314e7192 (patch)
treedf1ef6ac7aa206097c1387f96a65e51c2e31bf87 /OpenSim/Data/MySQL/Resources/RegionStore.migrations
parentUsual IG version number in money hack. (diff)
downloadopensim-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/RegionStore.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/RegionStore.migrations24
1 files changed, 12 insertions, 12 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index ac31380..834d249 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -146,7 +146,7 @@ CREATE TABLE `land` (
146 `UserLookAtZ` float default NULL, 146 `UserLookAtZ` float default NULL,
147 `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', 147 `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
148 PRIMARY KEY (`UUID`) 148 PRIMARY KEY (`UUID`)
149) ENGINE=InnoDB DEFAULT CHARSET=utf8; 149) ENGINE=MyISAM DEFAULT CHARSET=utf8;
150 150
151CREATE TABLE `landaccesslist` ( 151CREATE TABLE `landaccesslist` (
152 `LandUUID` varchar(255) default NULL, 152 `LandUUID` varchar(255) default NULL,
@@ -168,7 +168,7 @@ COMMIT;
168:VERSION 3 #--------------------- 168:VERSION 3 #---------------------
169 169
170BEGIN; 170BEGIN;
171 CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; 171 CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
172COMMIT; 172COMMIT;
173 173
174:VERSION 4 #--------------------- 174:VERSION 4 #---------------------
@@ -226,13 +226,13 @@ COMMIT;
226 226
227BEGIN; 227BEGIN;
228 228
229alter table landaccesslist ENGINE = InnoDB; 229alter table landaccesslist ENGINE = MyISAM;
230alter table migrations ENGINE = InnoDB; 230alter table migrations ENGINE = MyISAM;
231alter table primitems ENGINE = InnoDB; 231alter table primitems ENGINE = MyISAM;
232alter table prims ENGINE = InnoDB; 232alter table prims ENGINE = MyISAM;
233alter table primshapes ENGINE = InnoDB; 233alter table primshapes ENGINE = MyISAM;
234alter table regionsettings ENGINE = InnoDB; 234alter table regionsettings ENGINE = MyISAM;
235alter table terrain ENGINE = InnoDB; 235alter table terrain ENGINE = MyISAM;
236 236
237COMMIT; 237COMMIT;
238 238
@@ -384,7 +384,7 @@ CREATE TABLE `regionsettings` (
384 `covenant` char(36) default NULL, 384 `covenant` char(36) default NULL,
385 `Sandbox` tinyint(4) NOT NULL, 385 `Sandbox` tinyint(4) NOT NULL,
386 PRIMARY KEY (`regionUUID`) 386 PRIMARY KEY (`regionUUID`)
387) ENGINE=InnoDB; 387) ENGINE=MyISAM;
388 388
389commit; 389commit;
390 390
@@ -852,7 +852,7 @@ CREATE TABLE IF NOT EXISTS `spawn_points` (
852 `Pitch` float NOT NULL, 852 `Pitch` float NOT NULL,
853 `Distance` float NOT NULL, 853 `Distance` float NOT NULL,
854 KEY `RegionID` (`RegionID`) 854 KEY `RegionID` (`RegionID`)
855) ENGINE=Innodb; 855) ENGINE=MyISAM;
856 856
857ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL; 857ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL;
858COMMIT; 858COMMIT;
@@ -891,7 +891,7 @@ CREATE TABLE `regionenvironment` (
891 `region_id` varchar(36) NOT NULL, 891 `region_id` varchar(36) NOT NULL,
892 `llsd_settings` TEXT NOT NULL, 892 `llsd_settings` TEXT NOT NULL,
893 PRIMARY KEY (`region_id`) 893 PRIMARY KEY (`region_id`)
894) ENGINE=InnoDB DEFAULT CHARSET=utf8; 894) ENGINE=MyISAM DEFAULT CHARSET=utf8;
895 895
896COMMIT; 896COMMIT;
897 897