1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
--
-- Database schema for inventory storage
--
--
-- Some type mappings
-- LLUID => char(36) (in ascii hex format)
-- uint => integer
-- string => varchar(256) until such time as we know we need bigger
create table inventoryitems (
UUID char(36) primary key, -- inventoryid
assetID char(36),
assetType integer,
invType integer,
parentFolderID char(36),
avatarID char(36),
creatorsID char(36),
inventoryName varchar(256),
inventoryDescription varchar(256),
-- permissions
inventoryNextPermissions integer,
inventoryCurrentPermissions integer,
inventoryBasePermissions integer,
inventoryEveryOnePermissions integer
);
create index inventoryitems_parent on inventoryitems(parentFolderID);
create index inventoryitems_ownerid on inventoryitems(avatarID);
create index inventoryitems_assetid on inventoryitems(assetID);
create table inventoryfolders (
-- The same UUID as prim, just to keep them easily linked
UUID varchar(36) primary key not null, --folderid
name varchar(256),
agentID char(36),
parentID char(36),
type integer,
version integer
);
|
