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] uniqueidentifier NOT NULL,
7 [Name] varchar(32) NOT NULL,
8 [Value] varchar(255) NOT NULL DEFAULT '',
9 PRIMARY KEY CLUSTERED
10 (
11 [PrincipalID] ASC, [Name] ASC
12 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
13 ) ON [PRIMARY]
14  
15  
16 COMMIT
17  
18 :VERSION 2
19  
20 BEGIN TRANSACTION
21  
22 CREATE TABLE dbo.Tmp_Avatars
23 (
24 PrincipalID uniqueidentifier NOT NULL,
25 [Name] varchar(32) NOT NULL,
26 Value text NOT NULL DEFAULT '',
27 ) ON [PRIMARY]
28 TEXTIMAGE_ON [PRIMARY]
29  
30 IF EXISTS(SELECT * FROM dbo.Avatars)
31 EXEC('INSERT INTO dbo.Tmp_Avatars (PrincipalID, Name, Value)
32 SELECT PrincipalID, CONVERT(text, Name), Value FROM dbo.Avatars WITH (HOLDLOCK TABLOCKX)')
33  
34 DROP TABLE dbo.Avatars
35  
36 EXECUTE sp_rename N'dbo.Tmp_Avatars', N'Avatars', 'OBJECT'
37  
38 COMMIT
39  
40 :VERSION 3
41  
42 BEGIN TRANSACTION
43  
44 CREATE TABLE dbo.Tmp_Avatars
45 (
46 PrincipalID uniqueidentifier NOT NULL,
47 [Name] varchar(32) NOT NULL,
48 Value text NOT NULL DEFAULT '',
49 PRIMARY KEY CLUSTERED
50 (
51 [PrincipalID] ASC, [Name] ASC
52 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
53 ) ON [PRIMARY]
54 TEXTIMAGE_ON [PRIMARY]
55  
56 IF EXISTS(SELECT * FROM dbo.Avatars)
57 EXEC('INSERT INTO dbo.Tmp_Avatars (PrincipalID, Name, Value)
58 SELECT PrincipalID, CONVERT(text, Name), Value FROM dbo.Avatars WITH (HOLDLOCK TABLOCKX)')
59  
60 DROP TABLE dbo.Avatars
61  
62 EXECUTE sp_rename N'dbo.Tmp_Avatars', N'Avatars', 'OBJECT'
63 COMMIT
64