From 6711adb8b1581801b0244fd01084697432e7fff2 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 18 Jun 2008 20:51:42 +0000
Subject: add inventory store migration

---
 .../Resources/SQLiteDialect/001_InventoryStore.sql | 40 ++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql

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

diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
new file mode 100644
index 0000000..89892df
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
@@ -0,0 +1,40 @@
+BEGIN TRANSACTION;
+
+CREATE TABLE InventoryFolders (
+       ID varchar(36) not null primary key, 
+       Type int,
+       Version int,
+       ParentID varchar(36),
+       Owner varchar(36),
+       Name varchar(64)
+);
+
+create table InventoryItems (
+   ID varchar(36) not null primary key,
+   InvType int,
+   AssetType int,
+   AssetID varchar(36),
+   Folder varchar(36),
+   Owner varchar(36),
+   Creator varchar(36),
+   Name varchar(64),
+   Description varchar(64),
+   NextPermissions int,
+   CurrentPermissions int,
+   BasePermissions int,
+   EveryOnePermissions int,
+   GroupID varchar(36),
+   GroupOwned int,
+   SalePrice int,
+   SaleType int,
+   Flags int,
+   CreationDate int
+);
+
+CREATE INDEX folder_owner_id on InventoryFolders (Owner);
+CREATE INDEX folder_parent_id on InventoryFolders (ParentID);
+CREATE INDEX item_group_id on InventoryItems (GroupID);
+CREATE INDEX item_owner_id on InventoryItems (Owner);
+CREATE INDEX item_folder_id on InventoryItems (Folder);
+
+COMMIT;
-- 
cgit v1.1

