diff options
Diffstat (limited to 'OpenSim/Data')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLRegionData.cs | 2 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/Presence.migrations | 2 |
2 files changed, 3 insertions, 1 deletions
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 | |||
62 | if (scopeID != UUID.Zero) | 62 | if (scopeID != UUID.Zero) |
63 | command += " and ScopeID = ?scopeID"; | 63 | command += " and ScopeID = ?scopeID"; |
64 | 64 | ||
65 | command += " order by regionName"; | ||
66 | |||
65 | using (MySqlCommand cmd = new MySqlCommand(command)) | 67 | using (MySqlCommand cmd = new MySqlCommand(command)) |
66 | { | 68 | { |
67 | cmd.Parameters.AddWithValue("?regionName", regionName); | 69 | cmd.Parameters.AddWithValue("?regionName", regionName); |
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); | |||
14 | 14 | ||
15 | COMMIT; | 15 | COMMIT; |
16 | 16 | ||
17 | :VERSION 1 # -------------------------- | 17 | :VERSION 2 # -------------------------- |
18 | 18 | ||
19 | BEGIN; | 19 | BEGIN; |
20 | 20 | ||