add mysql migrations for nhibernate driver

1 files changed, 41 insertions, 0 deletions

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