From b58dc7fb3320b8da2771d69921b7b8bb96e32806 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 18 Jun 2008 21:08:16 +0000
Subject: add mysql migrations for nhibernate driver

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

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

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
new file mode 100644
index 0000000..80afaa0
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
@@ -0,0 +1,41 @@
+START TRANSACTION;
+
+CREATE TABLE `InventoryFolders` (
+  `ID` char(36) NOT NULL,
+  `Type` int(11) default NULL,
+  `Version` int(11) default NULL,
+  `ParentID` char(36) default NULL,
+  `Owner` char(36) default NULL,
+  `Name` varchar(64) default NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `folder_owner_id` (`Owner`),
+  KEY `folder_parent_id` (`ParentID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `InventoryItems` (
+  `ID` char(36) NOT NULL,
+  `InvType` smallint(6) default NULL,
+  `AssetType` smallint(6) default NULL,
+  `AssetID` char(36) default NULL,
+  `Folder` char(36) default NULL,
+  `Owner` char(36) default NULL,
+  `Creator` char(36) default NULL,
+  `Name` varchar(64) default NULL,
+  `Description` varchar(64) default NULL,
+  `NextPermissions` int(11) default NULL,
+  `CurrentPermissions` int(11) default NULL,
+  `BasePermissions` int(11) default NULL,
+  `EveryOnePermissions` int(11) default NULL,
+  `GroupID` char(36) default NULL,
+  `GroupOwned` tinyint(1) default NULL,
+  `SalePrice` int(11) default NULL,
+  `SaleType` smallint(6) default NULL,
+  `Flags` int(11) default NULL,
+  `CreationDate` int(11) default NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `item_group_id` (`GroupID`),
+  KEY `item_owner_id` (`Owner`),
+  KEY `item_folder_id` (`Folder`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1

