diff options
| author | Melanie Thielker | 2010-06-21 17:06:05 +0200 |
|---|---|---|
| committer | Melanie | 2010-10-13 18:40:33 +0100 |
| commit | 01728fb19e1c23e878197753cb788f94883e5838 (patch) | |
| tree | 2a35efd434d950c1a2340d92addc4e7f1e767f1c /OpenSim/Data/MySQL/Resources | |
| parent | Remove carriage returns from OpenSimDefaults.ini. Correct one typo. Change (diff) | |
| download | opensim-SC_OLD-01728fb19e1c23e878197753cb788f94883e5838.zip opensim-SC_OLD-01728fb19e1c23e878197753cb788f94883e5838.tar.gz opensim-SC_OLD-01728fb19e1c23e878197753cb788f94883e5838.tar.bz2 opensim-SC_OLD-01728fb19e1c23e878197753cb788f94883e5838.tar.xz | |
Ensure no UUID.Zero region ID is ever written to presence. Add a Migration
to add a LastSeen field of type "Timestamp" to Presence for MySQL
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/Presence.migrations | 8 |
1 files changed, 8 insertions, 0 deletions
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; | ||