1 files changed, 51 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
new file mode 100644
index 0000000..f3b7a73
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
@@ -0,0 +1,51 @@
+CREATE TABLE `prims` (
+  `ParentID` int(11) default NULL,
+  `CreationDate` int(11) default NULL,
+  `Name` varchar(255) default NULL,
+  `ParentUUID` char(36) default NULL,
+  `Text` varchar(255) default NULL,
+  `Description` varchar(255) default NULL,
+  `SitName` varchar(255) default NULL,
+  `TouchName` varchar(255) default NULL,
+  `ObjectFlags` int(11) default NULL,
+  `OwnerMask` int(11) default NULL,
+  `NextOwnerMask` int(11) default NULL,
+  `GroupMask` int(11) default NULL,
+  `EveryoneMask` int(11) default NULL,
+  `BaseMask` int(11) default NULL,
+  `PositionX` float default NULL,
+  `PositionY` float default NULL,
+  `PositionZ` float default NULL,
+  `GroupPositionX` float default NULL,
+  `GroupPositionY` float default NULL,
+  `GroupPositionZ` float default NULL,
+  `VelocityX` float default NULL,
+  `VelocityY` float default NULL,
+  `VelocityZ` float default NULL,
+  `AngularVelocityX` float default NULL,
+  `AngularVelocityY` float default NULL,
+  `AngularVelocityZ` float default NULL,
+  `AccelerationX` float default NULL,
+  `AccelerationY` float default NULL,
+  `AccelerationZ` float default NULL,
+  `RotationX` float default NULL,
+  `RotationY` float default NULL,
+  `RotationZ` float default NULL,
+  `RotationW` float default NULL,
+  `SitTargetOffsetX` float default NULL,
+  `SitTargetOffsetY` float default NULL,
+  `SitTargetOffsetZ` float default NULL,
+  `SitTargetOrientW` float default NULL,
+  `SitTargetOrientX` float default NULL,
+  `SitTargetOrientY` float default NULL,
+  `SitTargetOrientZ` float default NULL,
+  `UUID` char(36) NOT NULL default '',
+  `RegionID` 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  (`UUID`),
+  KEY `prims_regionuuid` (`RegionID`),
+  KEY 'prims_parentuuid' ('ParentUUID')
+) ENGINE=InnoDB DEFAULT CHARSET=utf8
+\ No newline at end of file

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql new file mode 100644 index 0000000..f3b7a73 --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
@@ -0,0 +1,51 @@
	1	CREATE TABLE `prims` (
	2	`ParentID` int(11) default NULL,
	3	`CreationDate` int(11) default NULL,
	4	`Name` varchar(255) default NULL,
	5	`ParentUUID` char(36) default NULL,
	6	`Text` varchar(255) default NULL,
	7	`Description` varchar(255) default NULL,
	8	`SitName` varchar(255) default NULL,
	9	`TouchName` varchar(255) default NULL,
	10	`ObjectFlags` int(11) default NULL,
	11	`OwnerMask` int(11) default NULL,
	12	`NextOwnerMask` int(11) default NULL,
	13	`GroupMask` int(11) default NULL,
	14	`EveryoneMask` int(11) default NULL,
	15	`BaseMask` int(11) default NULL,
	16	`PositionX` float default NULL,
	17	`PositionY` float default NULL,
	18	`PositionZ` float default NULL,
	19	`GroupPositionX` float default NULL,
	20	`GroupPositionY` float default NULL,
	21	`GroupPositionZ` float default NULL,
	22	`VelocityX` float default NULL,
	23	`VelocityY` float default NULL,
	24	`VelocityZ` float default NULL,
	25	`AngularVelocityX` float default NULL,
	26	`AngularVelocityY` float default NULL,
	27	`AngularVelocityZ` float default NULL,
	28	`AccelerationX` float default NULL,
	29	`AccelerationY` float default NULL,
	30	`AccelerationZ` float default NULL,
	31	`RotationX` float default NULL,
	32	`RotationY` float default NULL,
	33	`RotationZ` float default NULL,
	34	`RotationW` float default NULL,
	35	`SitTargetOffsetX` float default NULL,
	36	`SitTargetOffsetY` float default NULL,
	37	`SitTargetOffsetZ` float default NULL,
	38	`SitTargetOrientW` float default NULL,
	39	`SitTargetOrientX` float default NULL,
	40	`SitTargetOrientY` float default NULL,
	41	`SitTargetOrientZ` float default NULL,
	42	`UUID` char(36) NOT NULL default '',
	43	`RegionID` char(36) default NULL,
	44	`CreatorID` char(36) default NULL,
	45	`OwnerID` char(36) default NULL,
	46	`GroupID` char(36) default NULL,
	47	`LastOwnerID` char(36) default NULL,
	48	PRIMARY KEY (`UUID`),
	49	KEY `prims_regionuuid` (`RegionID`),
	50	KEY 'prims_parentuuid' ('ParentUUID')
	51	) ENGINE=InnoDB DEFAULT CHARSET=utf8 \ No newline at end of file