clockwerk-opensim – 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" uuid NOT NULL,
8 "SessionID" uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
9 "SecureSessionID" uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'
10 );
11  
12  
13 COMMIT;
14  
15 :VERSION 2
16  
17 BEGIN TRANSACTION;
18  
19 CREATE UNIQUE INDEX SessionID ON Presence("SessionID");
20 CREATE INDEX UserID ON Presence("UserID");
21  
22 COMMIT;
23  
24 :VERSION 2
25  
26 BEGIN TRANSACTION;
27  
28 ALTER TABLE Presence ADD "LastSeen" Timestamp;
29  
30 COMMIT;