clockwerk-opensim – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 vero 1 :VERSION 1
2  
3 BEGIN TRANSACTION;
4 CREATE TABLE assets(
5 UUID varchar(255) primary key,
6 Name varchar(255),
7 Description varchar(255),
8 Type integer,
9 InvType integer,
10 Local integer,
11 Temporary integer,
12 Data blob);
13  
14 COMMIT;
15  
16 :VERSION 2
17  
18 BEGIN TRANSACTION;
19  
20 CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data);
21 INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets;
22 DROP TABLE assets;
23 CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data);
24 INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup;
25 DROP TABLE assets_backup;
26  
27 COMMIT;
28  
29 :VERSION 3
30  
31 DELETE FROM assets WHERE UUID = 'dc4b9f0bd00845c696a401dd947ac621'
32  
33 :VERSION 4
34  
35 BEGIN;
36  
37 update assets
38 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
39 where UUID not like '%-%';
40  
41 COMMIT;
42  
43 :VERSION 5
44  
45 BEGIN TRANSACTION;
46  
47 CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data);
48 INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets;
49 DROP TABLE assets;
50 CREATE TABLE assets(
51 UUID NOT NULL PRIMARY KEY,
52 Name,
53 Description,
54 Type,
55 Local,
56 Temporary,
57 asset_flags INTEGER NOT NULL DEFAULT 0,
58 CreatorID varchar(128) default '',
59 Data);
60  
61 INSERT INTO assets(UUID,Name,Description,Type,Local,Temporary,Data)
62 SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup;
63 DROP TABLE assets_backup;
64  
65 COMMIT;
66  
67