diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/RegionStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index a974503..014d227 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -204,7 +204,7 @@ 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=MyISAM DEFAULT CHARSET=utf8; | 207 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
208 | 208 | ||
209 | CREATE TABLE IF NOT EXISTS `landaccesslist` ( | 209 | CREATE TABLE IF NOT EXISTS `landaccesslist` ( |
210 | `LandUUID` varchar(255) DEFAULT NULL, | 210 | `LandUUID` varchar(255) DEFAULT NULL, |
@@ -218,7 +218,7 @@ CREATE TABLE IF NOT EXISTS `regionban` ( | |||
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=MyISAM DEFAULT CHARSET=utf8; | 221 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
222 | 222 | ||
223 | CREATE TABLE IF NOT EXISTS `regionsettings` ( | 223 | CREATE 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=MyISAM DEFAULT CHARSET=utf8; | 268 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
269 | 269 | ||
270 | CREATE TABLE IF NOT EXISTS `regionwindlight` ( | 270 | CREATE 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,28 +332,28 @@ 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=MyISAM DEFAULT CHARSET=utf8; | 335 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
336 | 336 | ||
337 | CREATE TABLE IF NOT EXISTS `spawn_points` ( | 337 | CREATE 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 utf8mb4 COLLATE utf8_unicode_ci NOT NULL, |
339 | `Yaw` float NOT NULL, | 339 | `Yaw` float NOT NULL, |
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=MyISAM DEFAULT CHARSET=utf8; | 343 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
344 | 344 | ||
345 | CREATE TABLE IF NOT EXISTS `regionenvironment` ( | 345 | CREATE 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=MyISAM DEFAULT CHARSET=utf8; | 349 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
350 | 350 | ||
351 | CREATE TABLE IF NOT EXISTS `regionextra` ( | 351 | CREATE 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=MyISAM DEFAULT CHARSET=utf8; | 356 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
357 | 357 | ||
358 | COMMIT; | 358 | COMMIT; |
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=MyISAM DEFAULT CHARSET=utf8; | 390 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
391 | 391 | ||
392 | COMMIT; | 392 | COMMIT; |
393 | 393 | ||