opensim-development – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 eva 1 :VERSION 1 # -------------------------
2  
3 BEGIN;
4  
5 CREATE TABLE `Friends` (
6 `PrincipalID` CHAR(36) NOT NULL,
7 `Friend` VARCHAR(255) NOT NULL,
8 `Flags` VARCHAR(16) NOT NULL DEFAULT 0,
9 `Offered` VARCHAR(32) NOT NULL DEFAULT 0,
10 PRIMARY KEY(`PrincipalID`, `Friend`),
11 KEY(`PrincipalID`)
12 ) ENGINE=InnoDB;
13  
14 COMMIT;
15  
16 :VERSION 2 # -------------------------
17  
18 BEGIN;
19  
20 INSERT INTO `Friends` SELECT `ownerID`, `friendID`, `friendPerms`, 0 FROM `userfriends`;
21  
22 COMMIT;
23  
24 :VERSION 3 # -------------------------
25  
26 BEGIN;
27  
28 ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
29 ALTER TABLE `Friends` DROP PRIMARY KEY;
30 ALTER TABLE `Friends` ADD PRIMARY KEY(PrincipalID(36), Friend(36));
31  
32 COMMIT;