diff options
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/Presence.migrations | 14 |
1 files changed, 11 insertions, 3 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/Presence.migrations b/OpenSim/Data/MSSQL/Resources/Presence.migrations index bcb6328..f84275d 100644 --- a/OpenSim/Data/MSSQL/Resources/Presence.migrations +++ b/OpenSim/Data/MSSQL/Resources/Presence.migrations | |||
@@ -1,4 +1,4 @@ | |||
1 | :VERSION 1 | 1 | :VERSION 1 |
2 | 2 | ||
3 | BEGIN TRANSACTION | 3 | BEGIN TRANSACTION |
4 | 4 | ||
@@ -26,6 +26,14 @@ COMMIT | |||
26 | 26 | ||
27 | BEGIN TRANSACTION | 27 | BEGIN TRANSACTION |
28 | 28 | ||
29 | ALTER TABLE Presence ADD LastSeen DateTime | 29 | ALTER TABLE Presence ADD LastSeen DateTime; |
30 | 30 | ||
31 | COMMIT \ No newline at end of file | 31 | COMMIT |
32 | |||
33 | :VERSION 3 | ||
34 | |||
35 | BEGIN TRANSACTION | ||
36 | |||
37 | CREATE INDEX RegionID ON Presence(RegionID); | ||
38 | |||
39 | COMMIT | ||