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 @@
+--

+-- 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

+);

+