clockwerk-opensim – Blame information for rev 1
?pathlinks?
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; |