clockwerk-opensim-stable – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | vero | 1 | :VERSION 1 # -------------------------- |
2 | |||
3 | BEGIN; |
||
4 | |||
5 | CREATE TABLE `Presence` ( |
||
6 | `UserID` VARCHAR(255) NOT NULL, |
||
7 | `RegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
||
8 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
||
9 | `SecureSessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' |
||
10 | ) ENGINE=InnoDB; |
||
11 | |||
12 | CREATE UNIQUE INDEX SessionID ON Presence(SessionID); |
||
13 | CREATE INDEX UserID ON Presence(UserID); |
||
14 | |||
15 | COMMIT; |
||
16 | |||
17 | :VERSION 2 # -------------------------- |
||
18 | |||
19 | BEGIN; |
||
20 | |||
21 | ALTER TABLE `Presence` ADD COLUMN LastSeen timestamp; |
||
22 | |||
23 | COMMIT; |