opensim-development – Blame information for rev 1
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | eva | 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 |