aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/sqlite3-inventory.sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql/sqlite3-inventory.sql')
-rw-r--r--share/sql/sqlite3-inventory.sql40
1 files changed, 40 insertions, 0 deletions
diff --git a/share/sql/sqlite3-inventory.sql b/share/sql/sqlite3-inventory.sql
new file mode 100644
index 0000000..0575c28
--- /dev/null
+++ b/share/sql/sqlite3-inventory.sql
@@ -0,0 +1,40 @@
1--
2-- Database schema for inventory storage
3--
4--
5-- Some type mappings
6-- LLUID => char(36) (in ascii hex format)
7-- uint => integer
8-- string => varchar(256) until such time as we know we need bigger
9
10create table inventoryitems (
11 UUID char(36) primary key, -- inventoryid
12 assetID char(36),
13 assetType integer,
14 invType integer,
15 parentFolderID char(36),
16 avatarID char(36),
17 creatorsID char(36),
18 inventoryName varchar(256),
19 inventoryDescription varchar(256),
20 -- permissions
21 inventoryNextPermissions integer,
22 inventoryCurrentPermissions integer,
23 inventoryBasePermissions integer,
24 inventoryEveryOnePermissions integer
25);
26
27create index inventoryitems_parent on inventoryitems(parentFolderID);
28create index inventoryitems_ownerid on inventoryitems(avatarID);
29create index inventoryitems_assetid on inventoryitems(assetID);
30
31create table inventoryfolders (
32 -- The same UUID as prim, just to keep them easily linked
33 UUID varchar(36) primary key not null, --folderid
34 name varchar(256),
35 agentID char(36),
36 parentID char(36),
37 type integer,
38 version integer
39);
40