clockwerk-opensim-stable – Blame information for rev 1

Subversion Repositories:
Rev:
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;