opensim – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | eva | 1 | :VERSION 1 |
2 | |||
3 | CREATE TABLE [assets] ( |
||
4 | [id] [varchar](36) NOT NULL, |
||
5 | [name] [varchar](64) NOT NULL, |
||
6 | [description] [varchar](64) NOT NULL, |
||
7 | [assetType] [tinyint] NOT NULL, |
||
8 | [local] [tinyint] NOT NULL, |
||
9 | [temporary] [tinyint] NOT NULL, |
||
10 | [data] [image] NOT NULL, |
||
11 | PRIMARY KEY CLUSTERED |
||
12 | ( |
||
13 | [id] ASC |
||
14 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
||
15 | ) ON [PRIMARY] |
||
16 | |||
17 | |||
18 | :VERSION 2 |
||
19 | |||
20 | BEGIN TRANSACTION |
||
21 | |||
22 | CREATE TABLE Tmp_assets |
||
23 | ( |
||
24 | id varchar(36) NOT NULL, |
||
25 | name varchar(64) NOT NULL, |
||
26 | description varchar(64) NOT NULL, |
||
27 | assetType tinyint NOT NULL, |
||
28 | local bit NOT NULL, |
||
29 | temporary bit NOT NULL, |
||
30 | data image NOT NULL |
||
31 | ) ON [PRIMARY] |
||
32 | TEXTIMAGE_ON [PRIMARY] |
||
33 | |||
34 | IF EXISTS(SELECT * FROM assets) |
||
35 | EXEC('INSERT INTO Tmp_assets (id, name, description, assetType, local, temporary, data) |
||
36 | SELECT id, name, description, assetType, CONVERT(bit, local), CONVERT(bit, temporary), data FROM assets WITH (HOLDLOCK TABLOCKX)') |
||
37 | |||
38 | DROP TABLE assets |
||
39 | |||
40 | EXECUTE sp_rename N'Tmp_assets', N'assets', 'OBJECT' |
||
41 | |||
42 | ALTER TABLE dbo.assets ADD CONSTRAINT |
||
43 | PK__assets__id PRIMARY KEY CLUSTERED |
||
44 | ( |
||
45 | id |
||
46 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
||
47 | |||
48 | COMMIT |
||
49 | |||
50 | |||
51 | :VERSION 3 |
||
52 | |||
53 | BEGIN TRANSACTION |
||
54 | |||
55 | ALTER TABLE assets add create_time integer default 0 |
||
56 | ALTER TABLE assets add access_time integer default 0 |
||
57 | |||
58 | COMMIT |
||
59 | |||
60 | |||
61 | :VERSION 4 |
||
62 | |||
63 | BEGIN TRANSACTION |
||
64 | |||
65 | CREATE TABLE dbo.Tmp_assets |
||
66 | ( |
||
67 | id uniqueidentifier NOT NULL, |
||
68 | name varchar(64) NOT NULL, |
||
69 | description varchar(64) NOT NULL, |
||
70 | assetType tinyint NOT NULL, |
||
71 | local bit NOT NULL, |
||
72 | temporary bit NOT NULL, |
||
73 | data image NOT NULL, |
||
74 | create_time int NULL, |
||
75 | access_time int NULL |
||
76 | ) ON [PRIMARY] |
||
77 | TEXTIMAGE_ON [PRIMARY] |
||
78 | |||
79 | IF EXISTS(SELECT * FROM dbo.assets) |
||
80 | EXEC('INSERT INTO dbo.Tmp_assets (id, name, description, assetType, local, temporary, data, create_time, access_time) |
||
81 | SELECT CONVERT(uniqueidentifier, id), name, description, assetType, local, temporary, data, create_time, access_time FROM dbo.assets WITH (HOLDLOCK TABLOCKX)') |
||
82 | |||
83 | DROP TABLE assets |
||
84 | |||
85 | EXECUTE sp_rename N'Tmp_assets', N'assets', 'OBJECT' |
||
86 | |||
87 | ALTER TABLE dbo.assets ADD CONSTRAINT |
||
88 | PK__assets__id PRIMARY KEY CLUSTERED |
||
89 | ( |
||
90 | id |
||
91 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
||
92 | |||
93 | COMMIT |
||
94 | |||
95 | |||
96 | :VERSION 5 |
||
97 | |||
98 | DELETE FROM assets WHERE id = 'dc4b9f0b-d008-45c6-96a4-01dd947ac621'; |
||
99 | |||
100 | :VERSION 6 |
||
101 | |||
102 | ALTER TABLE assets ADD asset_flags INTEGER NOT NULL DEFAULT 0; |
||
103 | |||
104 | :VERSION 7 |
||
105 | |||
106 | alter table assets add creatorid varchar(36) not null default ''; |