From d929915d6b176d9c8fdff54f49f10d4e87feaf90 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Mon, 27 Aug 2007 20:39:34 +0000
Subject: remove sqlite3-inventory, this db is autocreated now

---
 share/sql/sqlite3-inventory.sql | 40 ----------------------------------------
 1 file changed, 40 deletions(-)
 delete mode 100644 share/sql/sqlite3-inventory.sql

(limited to 'share')

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
-);
-
-- 
cgit v1.1