diff options
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/InventoryStore.migrations | 39 |
1 files changed, 0 insertions, 39 deletions
diff --git a/OpenSim/Data/SQLite/Resources/InventoryStore.migrations b/OpenSim/Data/SQLite/Resources/InventoryStore.migrations deleted file mode 100644 index 2b48623..0000000 --- a/OpenSim/Data/SQLite/Resources/InventoryStore.migrations +++ /dev/null | |||
@@ -1,39 +0,0 @@ | |||
1 | :VERSION 5 | ||
2 | |||
3 | BEGIN TRANSACTION; | ||
4 | |||
5 | CREATE TABLE IF NOT EXISTS inventoryfolders( | ||
6 | folderName varchar(64), | ||
7 | type integer, | ||
8 | version integer, | ||
9 | folderID varchar(36) primary key, | ||
10 | agentID varchar(36) not null default '00000000-0000-0000-0000-000000000000', | ||
11 | parentFolderID varchar(36) not null default '00000000-0000-0000-0000-000000000000'); | ||
12 | CREATE INDEX inventoryfolders_agentid on inventoryfolders(agentID); | ||
13 | CREATE INDEX inventoryfolders_parentid on inventoryfolders(parentFolderID); | ||
14 | |||
15 | CREATE TABLE IF NOT EXISTS inventoryitems( | ||
16 | assetID varchar(36), | ||
17 | assetType integer, | ||
18 | inventoryName varchar(64), | ||
19 | inventoryDescription varchar(128), | ||
20 | inventoryNextPermissions integer, | ||
21 | inventoryCurrentPermissions integer, | ||
22 | invType integer, | ||
23 | creatorID varchar(128), | ||
24 | inventoryBasePermissions integer, | ||
25 | inventoryEveryOnePermissions integer, | ||
26 | salePrice integer default 99, | ||
27 | saleType integer default 0, | ||
28 | creationDate integer default 2000, | ||
29 | groupID varchar(36) default '00000000-0000-0000-0000-000000000000', | ||
30 | groupOwned integer default 0, | ||
31 | flags integer default 0, | ||
32 | inventoryID varchar(36) primary key, | ||
33 | parentFolderID varchar(36) not null default '00000000-0000-0000-0000-000000000000', | ||
34 | avatarID varchar(36) not null default '00000000-0000-0000-0000-000000000000', | ||
35 | inventoryGroupPermissions integer not null default 0); | ||
36 | CREATE INDEX inventoryitems_parentfolderid on inventoryitems(parentFolderID); | ||
37 | CREATE INDEX inventoryitems_avatarid on inventoryitems(avatarID); | ||
38 | |||
39 | COMMIT; | ||