clockwerk-opensim-stable – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 vero 1 :VERSION 1
2  
3 BEGIN TRANSACTION
4  
5 CREATE TABLE [Presence] (
6 [UserID] varchar(255) NOT NULL,
7 [RegionID] uniqueidentifier NOT NULL,
8 [SessionID] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
9 [SecureSessionID] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
10  
11 )
12 ON [PRIMARY]
13  
14 COMMIT
15  
16 :VERSION 2
17  
18 BEGIN TRANSACTION
19  
20 CREATE UNIQUE INDEX SessionID ON Presence(SessionID);
21 CREATE INDEX UserID ON Presence(UserID);
22  
23 COMMIT
24  
25 :VERSION 2
26  
27 BEGIN TRANSACTION
28  
29 ALTER TABLE Presence ADD LastSeen DateTime
30  
31 COMMIT