diff options
author | Charles Krinke | 2009-01-11 18:24:16 +0000 |
---|---|---|
committer | Charles Krinke | 2009-01-11 18:24:16 +0000 |
commit | 40f34aeffd64e2aa81cecb2e861f60d6e8886198 (patch) | |
tree | 5d0059eb7aa70799c8239bb273efc997138cabb5 /OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | |
parent | Thank you kindly, Tlaukkan (Tommil) for a patch that: (diff) | |
download | opensim-SC_OLD-40f34aeffd64e2aa81cecb2e861f60d6e8886198.zip opensim-SC_OLD-40f34aeffd64e2aa81cecb2e861f60d6e8886198.tar.gz opensim-SC_OLD-40f34aeffd64e2aa81cecb2e861f60d6e8886198.tar.bz2 opensim-SC_OLD-40f34aeffd64e2aa81cecb2e861f60d6e8886198.tar.xz |
Thank you kindly, Tlaukkan (Tommil) for a patch that:
Fixed all NHibernate unit tests by implementing missing persistency
methods, tables, columns and fixing bugs in the existing implementation.
Two minor changes to classes outside NHibernate module: Added Scene
instantiation for SceneObjectGroup in OpenSim.Data.Tests.BasicRegionTest
as this was required by the NHibernate persistency. In the process added
also mock constructor to Scene which only populates RegionInfo in the scene
which is used by ScenePart.RegionUUID. NHibernate module is still in
experimental state and has not been tested at opensim region or ugaim runtime
configuration. Adding unit tests to build is not yet advisable nor using
NHibernate module in any production setup.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | 80 |
1 files changed, 44 insertions, 36 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql index 99a5227..158ebb4 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | |||
@@ -1,8 +1,15 @@ | |||
1 | CREATE TABLE `Prims` ( | 1 | CREATE TABLE `Prims` ( |
2 | `UUID` char(36) NOT NULL default '', | ||
3 | `RegionID` char(36) default NULL, | ||
4 | `GroupID` char(36) default NULL, | ||
2 | `ParentID` int(11) default NULL, | 5 | `ParentID` int(11) default NULL, |
6 | `ParentUUID` char(36) default NULL, | ||
7 | `OwnerID` char(36) default NULL, | ||
8 | `LastOwnerID` char(36) default NULL, | ||
9 | `CreatorID` char(36) default NULL, | ||
3 | `CreationDate` int(11) default NULL, | 10 | `CreationDate` int(11) default NULL, |
11 | `LinkNum` int(11) default NULL, | ||
4 | `Name` varchar(255) default NULL, | 12 | `Name` varchar(255) default NULL, |
5 | `ParentUUID` char(36) default NULL, | ||
6 | `Text` varchar(255) default NULL, | 13 | `Text` varchar(255) default NULL, |
7 | `Description` varchar(255) default NULL, | 14 | `Description` varchar(255) default NULL, |
8 | `SitName` varchar(255) default NULL, | 15 | `SitName` varchar(255) default NULL, |
@@ -13,43 +20,43 @@ CREATE TABLE `Prims` ( | |||
13 | `GroupMask` int(11) default NULL, | 20 | `GroupMask` int(11) default NULL, |
14 | `EveryoneMask` int(11) default NULL, | 21 | `EveryoneMask` int(11) default NULL, |
15 | `BaseMask` int(11) default NULL, | 22 | `BaseMask` int(11) default NULL, |
16 | `PositionX` float default NULL, | 23 | `Material` int(1) default NULL, |
17 | `PositionY` float default NULL, | 24 | `ScriptAccessPin` int(11) default NULL, |
18 | `PositionZ` float default NULL, | 25 | `TextureAnimation` blob, |
19 | `GroupPositionX` float default NULL, | 26 | `ParticleSystem` blob, |
20 | `GroupPositionY` float default NULL, | 27 | `ClickAction` int(1) default NULL, |
21 | `GroupPositionZ` float default NULL, | 28 | `Color` int(11) default NULL, |
22 | `VelocityX` float default NULL, | 29 | `PositionX` double default NULL, |
23 | `VelocityY` float default NULL, | 30 | `PositionY` double default NULL, |
24 | `VelocityZ` float default NULL, | 31 | `PositionZ` double default NULL, |
25 | `AngularVelocityX` float default NULL, | 32 | `GroupPositionX` double default NULL, |
26 | `AngularVelocityY` float default NULL, | 33 | `GroupPositionY` double default NULL, |
27 | `AngularVelocityZ` float default NULL, | 34 | `GroupPositionZ` double default NULL, |
28 | `AccelerationX` float default NULL, | 35 | `VelocityX` double default NULL, |
29 | `AccelerationY` float default NULL, | 36 | `VelocityY` double default NULL, |
30 | `AccelerationZ` float default NULL, | 37 | `VelocityZ` double default NULL, |
31 | `RotationX` float default NULL, | 38 | `AngularVelocityX` double default NULL, |
32 | `RotationY` float default NULL, | 39 | `AngularVelocityY` double default NULL, |
33 | `RotationZ` float default NULL, | 40 | `AngularVelocityZ` double default NULL, |
34 | `RotationW` float default NULL, | 41 | `AccelerationX` double default NULL, |
35 | `SitTargetOffsetX` float default NULL, | 42 | `AccelerationY` double default NULL, |
36 | `SitTargetOffsetY` float default NULL, | 43 | `AccelerationZ` double default NULL, |
37 | `SitTargetOffsetZ` float default NULL, | 44 | `RotationX` double default NULL, |
38 | `SitTargetOrientW` float default NULL, | 45 | `RotationY` double default NULL, |
39 | `SitTargetOrientX` float default NULL, | 46 | `RotationZ` double default NULL, |
40 | `SitTargetOrientY` float default NULL, | 47 | `RotationW` double default NULL, |
41 | `SitTargetOrientZ` float default NULL, | 48 | `SitTargetOffsetX` double default NULL, |
42 | `UUID` char(36) NOT NULL default '', | 49 | `SitTargetOffsetY` double default NULL, |
43 | `RegionID` char(36) default NULL, | 50 | `SitTargetOffsetZ` double default NULL, |
44 | `CreatorID` char(36) default NULL, | 51 | `SitTargetOrientW` double default NULL, |
45 | `OwnerID` char(36) default NULL, | 52 | `SitTargetOrientX` double default NULL, |
46 | `GroupID` char(36) default NULL, | 53 | `SitTargetOrientY` double default NULL, |
47 | `LastOwnerID` char(36) default NULL, | 54 | `SitTargetOrientZ` double default NULL, |
48 | -- this is the shape | 55 | -- this is the shape |
49 | `Shape` int(11) default NULL, | 56 | `Shape` int(11) default NULL, |
50 | `ScaleX` float default NULL, | 57 | `ScaleX` double default NULL, |
51 | `ScaleY` float default NULL, | 58 | `ScaleY` double default NULL, |
52 | `ScaleZ` float default NULL, | 59 | `ScaleZ` double default NULL, |
53 | `PCode` int(11) default NULL, | 60 | `PCode` int(11) default NULL, |
54 | `PathBegin` int(11) default NULL, | 61 | `PathBegin` int(11) default NULL, |
55 | `PathEnd` int(11) default NULL, | 62 | `PathEnd` int(11) default NULL, |
@@ -77,3 +84,4 @@ CREATE TABLE `Prims` ( | |||
77 | KEY `prims_parentuuid` (`ParentUUID`) | 84 | KEY `prims_parentuuid` (`ParentUUID`) |
78 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 85 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
79 | 86 | ||
87 | |||