aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/Presence.migrations
diff options
context:
space:
mode:
authorDiva Canto2011-04-28 07:28:29 -0700
committerDiva Canto2011-04-28 07:28:29 -0700
commit7ecf6895842eff93155e49d2f7fa4cd833510726 (patch)
tree76caa8db816b9b6d83dc945135e2a7f16c740d48 /OpenSim/Data/MSSQL/Resources/Presence.migrations
parentFix a bug where physical objects rezzed with an initial velocity by script do... (diff)
downloadopensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.zip
opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.gz
opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.bz2
opensim-SC_OLD-7ecf6895842eff93155e49d2f7fa4cd833510726.tar.xz
Thank you MrMonkE for a patch that seems to bring the MSSQL data layer up to speed with 0.7.x.
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/Presence.migrations')
-rw-r--r--OpenSim/Data/MSSQL/Resources/Presence.migrations17
1 files changed, 9 insertions, 8 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/Presence.migrations b/OpenSim/Data/MSSQL/Resources/Presence.migrations
index 35f78e1..bcb6328 100644
--- a/OpenSim/Data/MSSQL/Resources/Presence.migrations
+++ b/OpenSim/Data/MSSQL/Resources/Presence.migrations
@@ -7,14 +7,7 @@ CREATE TABLE [Presence] (
7[RegionID] uniqueidentifier NOT NULL, 7[RegionID] uniqueidentifier NOT NULL,
8[SessionID] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', 8[SessionID] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
9[SecureSessionID] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', 9[SecureSessionID] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
10[Online] char(5) NOT NULL DEFAULT 'false', 10
11[Login] char(16) NOT NULL DEFAULT '0',
12[Logout] char(16) NOT NULL DEFAULT '0',
13[Position] char(64) NOT NULL DEFAULT '<0,0,0>',
14[LookAt] char(64) NOT NULL DEFAULT '<0,0,0>',
15[HomeRegionID] uniqueidentifier NOT NULL,
16[HomePosition] CHAR(64) NOT NULL DEFAULT '<0,0,0>',
17[HomeLookAt] CHAR(64) NOT NULL DEFAULT '<0,0,0>',
18) 11)
19 ON [PRIMARY] 12 ON [PRIMARY]
20 13
@@ -27,4 +20,12 @@ BEGIN TRANSACTION
27CREATE UNIQUE INDEX SessionID ON Presence(SessionID); 20CREATE UNIQUE INDEX SessionID ON Presence(SessionID);
28CREATE INDEX UserID ON Presence(UserID); 21CREATE INDEX UserID ON Presence(UserID);
29 22
23COMMIT
24
25:VERSION 2
26
27BEGIN TRANSACTION
28
29ALTER TABLE Presence ADD LastSeen DateTime
30
30COMMIT \ No newline at end of file 31COMMIT \ No newline at end of file