From 3c227390c041555e055ee839449dada676b78099 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 23 Jul 2008 22:14:23 +0000
Subject: add primitems migration for nhibernate

---
 .../Resources/MySQLDialect/003_RegionStore.sql     | 27 ++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql

(limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql')

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
-- 
cgit v1.1

