aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/RegionStore.migrations
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/MySQL/Resources/RegionStore.migrations26
1 files changed, 13 insertions, 13 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index 0577392..fb7862a 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -97,7 +97,7 @@ CREATE TABLE IF NOT EXISTS `prims` (
97 PRIMARY KEY (`UUID`), 97 PRIMARY KEY (`UUID`),
98 KEY `prims_regionuuid` (`RegionUUID`), 98 KEY `prims_regionuuid` (`RegionUUID`),
99 KEY `prims_scenegroupid` (`SceneGroupID`) 99 KEY `prims_scenegroupid` (`SceneGroupID`)
100) ENGINE=InnoDB DEFAULT CHARSET=latin1; 100) ENGINE=MyISAM DEFAULT CHARSET=latin1;
101 101
102CREATE TABLE IF NOT EXISTS `primshapes` ( 102CREATE TABLE IF NOT EXISTS `primshapes` (
103 `Shape` int(11) DEFAULT NULL, 103 `Shape` int(11) DEFAULT NULL,
@@ -130,7 +130,7 @@ CREATE TABLE IF NOT EXISTS `primshapes` (
130 `Media` text, 130 `Media` text,
131 `LastAttachPoint` int(4) NOT NULL DEFAULT '0', 131 `LastAttachPoint` int(4) NOT NULL DEFAULT '0',
132 PRIMARY KEY (`UUID`) 132 PRIMARY KEY (`UUID`)
133) ENGINE=InnoDB DEFAULT CHARSET=latin1; 133) ENGINE=MyISAM DEFAULT CHARSET=latin1;
134 134
135CREATE TABLE IF NOT EXISTS `primitems` ( 135CREATE TABLE IF NOT EXISTS `primitems` (
136 `invType` int(11) DEFAULT NULL, 136 `invType` int(11) DEFAULT NULL,
@@ -154,13 +154,13 @@ CREATE TABLE IF NOT EXISTS `primitems` (
154 `lastOwnerID` char(36) DEFAULT NULL, 154 `lastOwnerID` char(36) DEFAULT NULL,
155 PRIMARY KEY (`itemID`), 155 PRIMARY KEY (`itemID`),
156 KEY `primitems_primid` (`primID`) 156 KEY `primitems_primid` (`primID`)
157) ENGINE=InnoDB DEFAULT CHARSET=latin1; 157) ENGINE=MyISAM DEFAULT CHARSET=latin1;
158 158
159CREATE TABLE IF NOT EXISTS `terrain` ( 159CREATE TABLE IF NOT EXISTS `terrain` (
160 `RegionUUID` varchar(255) DEFAULT NULL, 160 `RegionUUID` varchar(255) DEFAULT NULL,
161 `Revision` int(11) DEFAULT NULL, 161 `Revision` int(11) DEFAULT NULL,
162 `Heightfield` longblob 162 `Heightfield` longblob
163) ENGINE=InnoDB DEFAULT CHARSET=latin1; 163) ENGINE=MyISAM DEFAULT CHARSET=latin1;
164 164
165CREATE TABLE IF NOT EXISTS `land` ( 165CREATE TABLE IF NOT EXISTS `land` (
166 `UUID` varchar(255) NOT NULL, 166 `UUID` varchar(255) NOT NULL,
@@ -204,21 +204,21 @@ CREATE TABLE IF NOT EXISTS `land` (
204 `ObscureMusic` tinyint(1) NOT NULL DEFAULT '0', 204 `ObscureMusic` tinyint(1) NOT NULL DEFAULT '0',
205 `ObscureMedia` tinyint(1) NOT NULL DEFAULT '0', 205 `ObscureMedia` tinyint(1) NOT NULL DEFAULT '0',
206 PRIMARY KEY (`UUID`) 206 PRIMARY KEY (`UUID`)
207) ENGINE=InnoDB DEFAULT CHARSET=utf8; 207) ENGINE=MyISAM DEFAULT CHARSET=utf8;
208 208
209CREATE TABLE IF NOT EXISTS `landaccesslist` ( 209CREATE TABLE IF NOT EXISTS `landaccesslist` (
210 `LandUUID` varchar(255) DEFAULT NULL, 210 `LandUUID` varchar(255) DEFAULT NULL,
211 `AccessUUID` varchar(255) DEFAULT NULL, 211 `AccessUUID` varchar(255) DEFAULT NULL,
212 `Flags` int(11) DEFAULT NULL, 212 `Flags` int(11) DEFAULT NULL,
213 `Expires` int(11) NOT NULL DEFAULT '0' 213 `Expires` int(11) NOT NULL DEFAULT '0'
214) ENGINE=InnoDB DEFAULT CHARSET=latin1; 214) ENGINE=MyISAM DEFAULT CHARSET=latin1;
215 215
216CREATE TABLE IF NOT EXISTS `regionban` ( 216CREATE TABLE IF NOT EXISTS `regionban` (
217 `regionUUID` varchar(36) NOT NULL, 217 `regionUUID` varchar(36) NOT NULL,
218 `bannedUUID` varchar(36) NOT NULL, 218 `bannedUUID` varchar(36) NOT NULL,
219 `bannedIp` varchar(16) NOT NULL, 219 `bannedIp` varchar(16) NOT NULL,
220 `bannedIpHostMask` varchar(16) NOT NULL 220 `bannedIpHostMask` varchar(16) NOT NULL
221) ENGINE=InnoDB DEFAULT CHARSET=utf8; 221) ENGINE=MyISAM DEFAULT CHARSET=utf8;
222 222
223CREATE TABLE IF NOT EXISTS `regionsettings` ( 223CREATE TABLE IF NOT EXISTS `regionsettings` (
224 `regionUUID` char(36) NOT NULL, 224 `regionUUID` char(36) NOT NULL,
@@ -265,7 +265,7 @@ CREATE TABLE IF NOT EXISTS `regionsettings` (
265 `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', 265 `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
266 `covenant_datetime` int(10) unsigned NOT NULL DEFAULT '0', 266 `covenant_datetime` int(10) unsigned NOT NULL DEFAULT '0',
267 PRIMARY KEY (`regionUUID`) 267 PRIMARY KEY (`regionUUID`)
268) ENGINE=InnoDB DEFAULT CHARSET=utf8; 268) ENGINE=MyISAM DEFAULT CHARSET=utf8;
269 269
270CREATE TABLE IF NOT EXISTS `regionwindlight` ( 270CREATE TABLE IF NOT EXISTS `regionwindlight` (
271 `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', 271 `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000',
@@ -332,7 +332,7 @@ CREATE TABLE IF NOT EXISTS `regionwindlight` (
332 `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', 332 `cloud_scroll_y_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
333 `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1', 333 `draw_classic_clouds` tinyint(1) unsigned NOT NULL DEFAULT '1',
334 PRIMARY KEY (`region_id`) 334 PRIMARY KEY (`region_id`)
335) ENGINE=InnoDB DEFAULT CHARSET=utf8; 335) ENGINE=MyISAM DEFAULT CHARSET=utf8;
336 336
337CREATE TABLE IF NOT EXISTS `spawn_points` ( 337CREATE TABLE IF NOT EXISTS `spawn_points` (
338 `RegionID` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, 338 `RegionID` varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
@@ -340,20 +340,20 @@ CREATE TABLE IF NOT EXISTS `spawn_points` (
340 `Pitch` float NOT NULL, 340 `Pitch` float NOT NULL,
341 `Distance` float NOT NULL, 341 `Distance` float NOT NULL,
342 KEY `RegionID` (`RegionID`) 342 KEY `RegionID` (`RegionID`)
343) ENGINE=InnoDB DEFAULT CHARSET=utf8; 343) ENGINE=MyISAM DEFAULT CHARSET=utf8;
344 344
345CREATE TABLE IF NOT EXISTS `regionenvironment` ( 345CREATE TABLE IF NOT EXISTS `regionenvironment` (
346 `region_id` varchar(36) NOT NULL, 346 `region_id` varchar(36) NOT NULL,
347 `llsd_settings` text NOT NULL, 347 `llsd_settings` text NOT NULL,
348 PRIMARY KEY (`region_id`) 348 PRIMARY KEY (`region_id`)
349) ENGINE=InnoDB DEFAULT CHARSET=utf8; 349) ENGINE=MyISAM DEFAULT CHARSET=utf8;
350 350
351CREATE TABLE IF NOT EXISTS `regionextra` ( 351CREATE TABLE IF NOT EXISTS `regionextra` (
352 `RegionID` char(36) NOT NULL, 352 `RegionID` char(36) NOT NULL,
353 `Name` varchar(32) NOT NULL, 353 `Name` varchar(32) NOT NULL,
354 `value` text, 354 `value` text,
355 PRIMARY KEY (`RegionID`,`Name`) 355 PRIMARY KEY (`RegionID`,`Name`)
356) ENGINE=InnoDB DEFAULT CHARSET=utf8; 356) ENGINE=MyISAM DEFAULT CHARSET=utf8;
357 357
358COMMIT; 358COMMIT;
359 359
@@ -387,7 +387,7 @@ CREATE TABLE IF NOT EXISTS `bakedterrain` (
387 `RegionUUID` varchar(255) DEFAULT NULL, 387 `RegionUUID` varchar(255) DEFAULT NULL,
388 `Revision` int(11) DEFAULT NULL, 388 `Revision` int(11) DEFAULT NULL,
389 `Heightfield` longblob 389 `Heightfield` longblob
390) ENGINE=InnoDB DEFAULT CHARSET=utf8; 390) ENGINE=MyISAM DEFAULT CHARSET=utf8;
391 391
392COMMIT; 392COMMIT;
393 393