diff options
author | AlexRa | 2010-05-06 22:44:57 +0300 |
---|---|---|
committer | AlexRa | 2010-05-16 17:04:39 +0300 |
commit | 1ad12851d076094d6fad3ebe604b4cae378eaef3 (patch) | |
tree | 9aa6706c2b890f63f19a5f3c1e05099a2edba000 /OpenSim/Data/SQLite/Resources/InventoryStore.migrations | |
parent | Converted MySQL migration history to the new format (diff) | |
download | opensim-SC_OLD-1ad12851d076094d6fad3ebe604b4cae378eaef3.zip opensim-SC_OLD-1ad12851d076094d6fad3ebe604b4cae378eaef3.tar.gz opensim-SC_OLD-1ad12851d076094d6fad3ebe604b4cae378eaef3.tar.bz2 opensim-SC_OLD-1ad12851d076094d6fad3ebe604b4cae378eaef3.tar.xz |
Migrations for SQLite converted to new format
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/InventoryStore.migrations (renamed from OpenSim/Data/SQLite/Resources/004_InventoryStore.sql) | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/004_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/InventoryStore.migrations index e8f4d46..585ac49 100644 --- a/OpenSim/Data/SQLite/Resources/004_InventoryStore.sql +++ b/OpenSim/Data/SQLite/Resources/InventoryStore.migrations | |||
@@ -1,3 +1,59 @@ | |||
1 | :VERSION 1 | ||
2 | |||
3 | BEGIN TRANSACTION; | ||
4 | |||
5 | CREATE TABLE inventoryfolders( | ||
6 | UUID varchar(255) primary key, | ||
7 | name varchar(255), | ||
8 | agentID varchar(255), | ||
9 | parentID varchar(255), | ||
10 | type integer, | ||
11 | version integer); | ||
12 | |||
13 | CREATE TABLE inventoryitems( | ||
14 | UUID varchar(255) primary key, | ||
15 | assetID varchar(255), | ||
16 | assetType integer, | ||
17 | invType integer, | ||
18 | parentFolderID varchar(255), | ||
19 | avatarID varchar(255), | ||
20 | creatorsID varchar(255), | ||
21 | inventoryName varchar(255), | ||
22 | inventoryDescription varchar(255), | ||
23 | inventoryNextPermissions integer, | ||
24 | inventoryCurrentPermissions integer, | ||
25 | inventoryBasePermissions integer, | ||
26 | inventoryEveryOnePermissions integer, | ||
27 | salePrice integer default 99, | ||
28 | saleType integer default 0, | ||
29 | creationDate integer default 2000, | ||
30 | groupID varchar(255) default '00000000-0000-0000-0000-000000000000', | ||
31 | groupOwned integer default 0, | ||
32 | flags integer default 0); | ||
33 | |||
34 | COMMIT; | ||
35 | |||
36 | :VERSION 2 | ||
37 | |||
38 | BEGIN TRANSACTION; | ||
39 | |||
40 | create index inventoryfolders_agentid on inventoryfolders(agentid); | ||
41 | create index inventoryfolders_parentid on inventoryfolders(parentid); | ||
42 | create index inventoryitems_parentfolderid on inventoryitems(parentfolderid); | ||
43 | create index inventoryitems_avatarid on inventoryitems(avatarid); | ||
44 | |||
45 | COMMIT; | ||
46 | |||
47 | :VERSION 3 | ||
48 | |||
49 | BEGIN; | ||
50 | |||
51 | alter table inventoryitems add column inventoryGroupPermissions integer unsigned not null default 0; | ||
52 | |||
53 | COMMIT; | ||
54 | |||
55 | :VERSION 4 | ||
56 | |||
1 | BEGIN; | 57 | BEGIN; |
2 | 58 | ||
3 | update inventoryitems | 59 | update inventoryitems |