aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MySQLDialect
diff options
context:
space:
mode:
authorSean Dague2008-07-15 18:57:18 +0000
committerSean Dague2008-07-15 18:57:18 +0000
commitb5efb49d74919b991fe86b53692180cf4829b565 (patch)
treedced5c727097a1793f8c0ecd26cb614a3e832d51 /OpenSim/Data/NHibernate/Resources/MySQLDialect
parent* Expose client statistics to the console via 'show stats' (diff)
downloadopensim-SC_OLD-b5efb49d74919b991fe86b53692180cf4829b565.zip
opensim-SC_OLD-b5efb49d74919b991fe86b53692180cf4829b565.tar.gz
opensim-SC_OLD-b5efb49d74919b991fe86b53692180cf4829b565.tar.bz2
opensim-SC_OLD-b5efb49d74919b991fe86b53692180cf4829b565.tar.xz
added new ParentUUID property to map out from SOP.
Updated some nhibernate parts, started in on migration.
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect')
-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