What numbnuts thought UUIDs should be varchar(255)?

1 files changed, 4 insertions, 4 deletions

diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index 014d227..83bc532 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -157,13 +157,13 @@ CREATE TABLE IF NOT EXISTS `primitems` (
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 CREATE TABLE IF NOT EXISTS `terrain` (
-  `RegionUUID` varchar(255) DEFAULT NULL,
+  `RegionUUID` char(36) DEFAULT NULL,
   `Revision` int(11) DEFAULT NULL,
   `Heightfield` longblob
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 CREATE TABLE IF NOT EXISTS `land` (
-  `UUID` varchar(255) NOT NULL,
+  `UUID` char(36) NOT NULL,
   `RegionUUID` varchar(255) DEFAULT NULL,
   `LocalLandID` int(11) DEFAULT NULL,
   `Bitmap` longblob,
@@ -207,7 +207,7 @@ CREATE TABLE IF NOT EXISTS `land` (
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
 
 CREATE TABLE IF NOT EXISTS `landaccesslist` (
-  `LandUUID` varchar(255) DEFAULT NULL,
+  `LandUUID` char(36) DEFAULT NULL,
   `AccessUUID` varchar(255) DEFAULT NULL,
   `Flags` int(11) DEFAULT NULL,
   `Expires` int(11) NOT NULL DEFAULT '0'
@@ -384,7 +384,7 @@ COMMIT;
 BEGIN;
 
 CREATE TABLE IF NOT EXISTS `bakedterrain` (
-  `RegionUUID` varchar(255) DEFAULT NULL,
+  `RegionUUID` char(36) DEFAULT NULL,
   `Revision` int(11) DEFAULT NULL,
   `Heightfield` longblob
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;