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, 0 insertions, 40 deletions
diff --git a/share/sql/sqlite3-inventory.sql b/share/sql/sqlite3-inventory.sql
deleted file mode 100644
index 0575c28..0000000
--- a/share/sql/sqlite3-inventory.sql
+++ /dev/null
@@ -1,40 +0,0 @@
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