aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources')
-rw-r--r--OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql51
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 @@
1CREATE 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