From 2be93066da042c21d396bb62b58d4d04fa63cbe0 Mon Sep 17 00:00:00 2001
From: Melanie
Date: Mon, 18 Oct 2010 19:08:26 +0100
Subject: Bump migration version on LastSeen field so it is actually run

---
 OpenSim/Data/MySQL/Resources/Presence.migrations | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/MySQL/Resources/Presence.migrations b/OpenSim/Data/MySQL/Resources/Presence.migrations
index 1075a15..be4030e 100644
--- a/OpenSim/Data/MySQL/Resources/Presence.migrations
+++ b/OpenSim/Data/MySQL/Resources/Presence.migrations
@@ -14,7 +14,7 @@ CREATE INDEX UserID ON Presence(UserID);
 
 COMMIT;
 
-:VERSION 1         # -------------------------- 
+:VERSION 2         # -------------------------- 
 
 BEGIN;
 
-- 
cgit v1.1


From 551015db6382b01d32100e91b569a5717121ccbe Mon Sep 17 00:00:00 2001
From: Melanie
Date: Mon, 18 Oct 2010 20:29:00 +0100
Subject: Alphabetize results on region search by prefix matching

---
 OpenSim/Data/MySQL/MySQLRegionData.cs | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/MySQL/MySQLRegionData.cs b/OpenSim/Data/MySQL/MySQLRegionData.cs
index baa948e..efefad9 100644
--- a/OpenSim/Data/MySQL/MySQLRegionData.cs
+++ b/OpenSim/Data/MySQL/MySQLRegionData.cs
@@ -62,6 +62,8 @@ namespace OpenSim.Data.MySQL
             if (scopeID != UUID.Zero)
                 command += " and ScopeID = ?scopeID";
 
+            command += " order by regionName";
+
             using (MySqlCommand cmd = new MySqlCommand(command))
             {
                 cmd.Parameters.AddWithValue("?regionName", regionName);
-- 
cgit v1.1