remove sqlite3-inventory, this db is autocreated now

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

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

-);

-