add primitems migration for nhibernate

1 files changed, 27 insertions, 0 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql
new file mode 100644
index 0000000..2cf46b5
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql
@@ -0,0 +1,27 @@
+BEGIN;
+
+CREATE TABLE `PrimItems` (
+  `InvType` int(11) default NULL,
+  `AssetType` int(11) default NULL,
+  `Name` varchar(255) default NULL,
+  `Description` varchar(255) default NULL,
+  `CreationDate` bigint(20) default NULL,
+  `NextPermissions` int(11) default NULL,
+  `CurrentPermissions` int(11) default NULL,
+  `BasePermissions` int(11) default NULL,
+  `EveryonePermissions` int(11) default NULL,
+  `GroupPermissions` int(11) default NULL,
+  `Flags` int(11) NOT NULL default '0',
+  `ItemID` char(36) NOT NULL default '',
+  `PrimID` char(36) default NULL,
+  `AssetID` char(36) default NULL,
+  `ParentFolderID` char(36) default NULL,
+  `CreatorID` char(36) default NULL,
+  `OwnerID` char(36) default NULL,
+  `GroupID` char(36) default NULL,
+  `LastOwnerID` char(36) default NULL,
+  PRIMARY KEY  (`ItemID`),
+  KEY `primitems_primid` (`PrimID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+COMMIT;
\ No newline at end of file