opensim-development – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 eva 1 :VERSION 1
2  
3 BEGIN TRANSACTION;
4  
5 CREATE TABLE Avatars (
6 "PrincipalID" uuid NOT NULL PRIMARY KEY,
7 "Name" varchar(32) NOT NULL,
8 "Value" varchar(255) NOT NULL DEFAULT ''
9 );
10  
11  
12 COMMIT;
13  
14 :VERSION 2
15  
16 BEGIN TRANSACTION;
17  
18 CREATE TABLE Tmp_Avatars
19 (
20 "PrincipalID" uuid NOT NULL,
21 "Name" varchar(32) NOT NULL,
22 "Value" text NOT NULL DEFAULT ''
23 ) ;
24  
25 INSERT INTO Tmp_Avatars ("PrincipalID", "Name", "Value")
26 SELECT "PrincipalID", cast("Name" as text), "Value"
27 FROM Avatars ;
28  
29 DROP TABLE Avatars;
30  
31 Alter table Tmp_Avatars
32 rename to Avatars;
33  
34 COMMIT;
35  
36 :VERSION 3
37  
38 BEGIN TRANSACTION;
39  
40 CREATE TABLE Tmp_Avatars
41 (
42 "PrincipalID" uuid NOT NULL,
43 "Name" varchar(32) NOT NULL,
44 "Value" text NOT NULL DEFAULT ''
45 );
46  
47 ALTER TABLE Tmp_Avatars ADD PRIMARY KEY ("PrincipalID", "Name");
48  
49  
50 INSERT INTO Tmp_Avatars ("PrincipalID", "Name", "Value")
51 SELECT "PrincipalID", "Name", cast("Value" as text) FROM Avatars ;
52  
53 DROP TABLE Avatars;
54  
55 Alter table Tmp_Avatars
56 rename to Avatars;
57  
58 COMMIT;
59