opensim – Blame information for rev 1
?pathlinks?
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 |