From 07609565617aa7936758acba5fd625877564a10d Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Thu, 19 Feb 2009 18:09:10 +0000
Subject: * Apply http://opensimulator.org/mantis/view.php?id=3142 * Changes
 varchar(36) columns to UUID type in MSSQL - this will be much more efficient
 * ===As always, please, please backup your database before applying this
 patch=== * Thanks Ruud Lathrop (for the patch) and StrawberryFride (for the
 review)

---
 OpenSim/Data/MSSQL/MSSQLGridData.cs | 20 +++++++++++---------
 1 file changed, 11 insertions(+), 9 deletions(-)

(limited to 'OpenSim/Data/MSSQL/MSSQLGridData.cs')

diff --git a/OpenSim/Data/MSSQL/MSSQLGridData.cs b/OpenSim/Data/MSSQL/MSSQLGridData.cs
index eec2091..027796a 100644
--- a/OpenSim/Data/MSSQL/MSSQLGridData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLGridData.cs
@@ -395,17 +395,17 @@ namespace OpenSim.Data.MSSQL
 
             retval.regionHandle = tmp64;
 
-            UUID tmp_uuid;
-            if (!UUID.TryParse((string)reader["uuid"], out tmp_uuid))
-            {
-                return null;
-            }
+//            UUID tmp_uuid;
+//            if (!UUID.TryParse((string)reader["uuid"], out tmp_uuid))
+//            {
+//                return null;
+//            }
 
-            retval.UUID = tmp_uuid;
+            retval.UUID = new UUID((Guid)reader["uuid"]); // tmp_uuid;
 
             // non-critical parts
             retval.regionName = reader["regionName"].ToString();
-            retval.originUUID = new UUID((string)reader["originUUID"]);
+            retval.originUUID = new UUID((Guid)reader["originUUID"]);
 
             // Secrets
             retval.regionRecvKey = reader["regionRecvKey"].ToString();
@@ -443,8 +443,10 @@ namespace OpenSim.Data.MSSQL
             retval.regionUserSendKey = reader["regionUserSendKey"].ToString();
 
             // World Map Addition
-            UUID.TryParse((string)reader["regionMapTexture"], out retval.regionMapTextureID);
-            UUID.TryParse((string)reader["owner_uuid"], out retval.owner_uuid);
+            retval.regionMapTextureID = new UUID((Guid)reader["regionMapTexture"]);
+            retval.owner_uuid = new UUID((Guid)reader["owner_uuid"]);
+//            UUID.TryParse((string)reader["regionMapTexture"], out retval.regionMapTextureID);
+//            UUID.TryParse((string)reader["owner_uuid"], out retval.owner_uuid);
 
             return retval;
         }
-- 
cgit v1.1