From acc2c42a795b42df702ded3cc302daa8b3e4c04c Mon Sep 17 00:00:00 2001 From: Oren Hurvitz Date: Sun, 20 Apr 2014 12:47:30 +0300 Subject: Better logging in PresenceService, to help diagnose presence problems. --- OpenSim/Data/MSSQL/Resources/Presence.migrations | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) (limited to 'OpenSim/Data/MSSQL/Resources/Presence.migrations') 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 @@ -:VERSION 1 +:VERSION 1 BEGIN TRANSACTION @@ -26,6 +26,14 @@ COMMIT BEGIN TRANSACTION -ALTER TABLE Presence ADD LastSeen DateTime +ALTER TABLE Presence ADD LastSeen DateTime; -COMMIT \ No newline at end of file +COMMIT + +:VERSION 3 + +BEGIN TRANSACTION + +CREATE INDEX RegionID ON Presence(RegionID); + +COMMIT -- cgit v1.1