From d3dd53f5a4fefc592cebca61f2e92e72b35b4cdf Mon Sep 17 00:00:00 2001
From: onefang
Date: Thu, 9 Sep 2021 20:35:44 +1000
Subject: What numbnuts thought UUIDs should be varchar(255)?

---
 OpenSim/Data/MySQL/Resources/RegionStore.migrations | 8 ++++----
 1 file 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;
-- 
cgit v1.1