diff options
author | Sean Dague | 2008-07-15 18:57:18 +0000 |
---|---|---|
committer | Sean Dague | 2008-07-15 18:57:18 +0000 |
commit | b5efb49d74919b991fe86b53692180cf4829b565 (patch) | |
tree | dced5c727097a1793f8c0ecd26cb614a3e832d51 /OpenSim/Data/NHibernate/Resources | |
parent | * Expose client statistics to the console via 'show stats' (diff) | |
download | opensim-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')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | 51 |
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 @@ | |||
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 | ||