diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLPresenceData.cs | 4 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/Presence.migrations | 8 |
2 files changed, 11 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/MySQLPresenceData.cs b/OpenSim/Data/MySQL/MySQLPresenceData.cs index 71caa1a..7b0016b 100644 --- a/OpenSim/Data/MySQL/MySQLPresenceData.cs +++ b/OpenSim/Data/MySQL/MySQLPresenceData.cs | |||
@@ -78,6 +78,9 @@ namespace OpenSim.Data.MySQL | |||
78 | if (pd.Length == 0) | 78 | if (pd.Length == 0) |
79 | return false; | 79 | return false; |
80 | 80 | ||
81 | if (regionID == UUID.Zero) | ||
82 | return; | ||
83 | |||
81 | MySqlCommand cmd = new MySqlCommand(); | 84 | MySqlCommand cmd = new MySqlCommand(); |
82 | 85 | ||
83 | cmd.CommandText = String.Format("update {0} set RegionID=?RegionID where `SessionID`=?SessionID", m_Realm); | 86 | cmd.CommandText = String.Format("update {0} set RegionID=?RegionID where `SessionID`=?SessionID", m_Realm); |
@@ -90,6 +93,5 @@ namespace OpenSim.Data.MySQL | |||
90 | 93 | ||
91 | return true; | 94 | return true; |
92 | } | 95 | } |
93 | |||
94 | } | 96 | } |
95 | } | 97 | } |
diff --git a/OpenSim/Data/MySQL/Resources/Presence.migrations b/OpenSim/Data/MySQL/Resources/Presence.migrations index 91f7de5..1075a15 100644 --- a/OpenSim/Data/MySQL/Resources/Presence.migrations +++ b/OpenSim/Data/MySQL/Resources/Presence.migrations | |||
@@ -13,3 +13,11 @@ CREATE UNIQUE INDEX SessionID ON Presence(SessionID); | |||
13 | CREATE INDEX UserID ON Presence(UserID); | 13 | CREATE INDEX UserID ON Presence(UserID); |
14 | 14 | ||
15 | COMMIT; | 15 | COMMIT; |
16 | |||
17 | :VERSION 1 # -------------------------- | ||
18 | |||
19 | BEGIN; | ||
20 | |||
21 | ALTER TABLE `Presence` ADD COLUMN LastSeen timestamp; | ||
22 | |||
23 | COMMIT; | ||