From 68b98aecab0906f6c55f8c567552fb39a3bda1a2 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 11 Jun 2008 20:04:01 +0000
Subject: updated resources for current sqlite schema for migrations

---
 .../Data/SQLite/Resources/001_InventoryStore.sql   | 48 ++++++++++++----------
 1 file changed, 27 insertions(+), 21 deletions(-)

(limited to 'OpenSim/Data/SQLite/Resources/001_InventoryStore.sql')

diff --git a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
index e4951b0..554d5c2 100644
--- a/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
+++ b/OpenSim/Data/SQLite/Resources/001_InventoryStore.sql
@@ -1,26 +1,32 @@
 BEGIN TRANSACTION;
 
-CREATE TABLE inventoryitems(
-        UUID varchar(255) primary key,
-        assetID varchar(255),
-        assetType integer,
-        invType integer,
-        parentFolderID varchar(255),
-        avatarID varchar(255),
-        creatorsID varchar(255),
-        inventoryName varchar(255),
-        inventoryDescription varchar(255),
-        inventoryNextPermissions integer,
-        inventoryCurrentPermissions integer,
-        inventoryBasePermissions integer,
-        inventoryEveryOnePermissions integer);
-
 CREATE TABLE inventoryfolders(
-        UUID varchar(255) primary key,
-        name varchar(255),
-        agentID varchar(255),
-        parentID varchar(255),
-        type integer,
-        version integer);
+       UUID varchar(255) primary key,
+       name varchar(255),
+       agentID varchar(255),
+       parentID varchar(255),
+       type integer,
+       version integer);
+
+CREATE TABLE inventoryitems(
+       UUID varchar(255) primary key,
+       assetID varchar(255),
+       assetType integer,
+       invType integer,
+       parentFolderID varchar(255),
+       avatarID varchar(255),
+       creatorsID varchar(255),
+       inventoryName varchar(255),
+       inventoryDescription varchar(255),
+       inventoryNextPermissions integer,
+       inventoryCurrentPermissions integer,
+       inventoryBasePermissions integer,
+       inventoryEveryOnePermissions integer, 
+       salePrice integer default 99, 
+       saleType integer default 0, 
+       creationDate integer default 2000, 
+       groupID varchar(255) default '00000000-0000-0000-0000-000000000000', 
+       groupOwned integer default 0, 
+       flags integer default 0);
 
 COMMIT;
-- 
cgit v1.1

