diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | 35 | ||||
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml | 10 |
2 files changed, 41 insertions, 4 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql index f3b7a73..ede281c 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | |||
@@ -1,4 +1,4 @@ | |||
1 | CREATE TABLE `prims` ( | 1 | CREATE TABLE `Prims` ( |
2 | `ParentID` int(11) default NULL, | 2 | `ParentID` int(11) default NULL, |
3 | `CreationDate` int(11) default NULL, | 3 | `CreationDate` int(11) default NULL, |
4 | `Name` varchar(255) default NULL, | 4 | `Name` varchar(255) default NULL, |
@@ -48,4 +48,35 @@ CREATE TABLE `prims` ( | |||
48 | PRIMARY KEY (`UUID`), | 48 | PRIMARY KEY (`UUID`), |
49 | KEY `prims_regionuuid` (`RegionID`), | 49 | KEY `prims_regionuuid` (`RegionID`), |
50 | KEY 'prims_parentuuid' ('ParentUUID') | 50 | KEY 'prims_parentuuid' ('ParentUUID') |
51 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 \ No newline at end of file | 51 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
52 | |||
53 | CREATE TABLE `PrimShapes` ( | ||
54 | `Shape` int(11) default NULL, | ||
55 | `ScaleX` float default NULL, | ||
56 | `ScaleY` float default NULL, | ||
57 | `ScaleZ` float default NULL, | ||
58 | `PCode` int(11) default NULL, | ||
59 | `PathBegin` int(11) default NULL, | ||
60 | `PathEnd` int(11) default NULL, | ||
61 | `PathScaleX` int(11) default NULL, | ||
62 | `PathScaleY` int(11) default NULL, | ||
63 | `PathShearX` int(11) default NULL, | ||
64 | `PathShearY` int(11) default NULL, | ||
65 | `PathSkew` int(11) default NULL, | ||
66 | `PathCurve` int(11) default NULL, | ||
67 | `PathRadiusOffset` int(11) default NULL, | ||
68 | `PathRevolutions` int(11) default NULL, | ||
69 | `PathTaperX` int(11) default NULL, | ||
70 | `PathTaperY` int(11) default NULL, | ||
71 | `PathTwist` int(11) default NULL, | ||
72 | `PathTwistBegin` int(11) default NULL, | ||
73 | `ProfileBegin` int(11) default NULL, | ||
74 | `ProfileEnd` int(11) default NULL, | ||
75 | `ProfileCurve` int(11) default NULL, | ||
76 | `ProfileHollow` int(11) default NULL, | ||
77 | `State` int(11) default NULL, | ||
78 | `Texture` longblob, | ||
79 | `ExtraParams` longblob, | ||
80 | `UUID` char(36) NOT NULL default '', | ||
81 | PRIMARY KEY (`UUID`) | ||
82 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
diff --git a/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml b/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml index 8bd9589..3a7d692 100644 --- a/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml +++ b/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml | |||
@@ -1,10 +1,10 @@ | |||
1 | <?xml version="1.0" encoding="utf-8" ?> | 1 | <?xml version="1.0" encoding="utf-8" ?> |
2 | <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> | 2 | <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> |
3 | <class name="OpenSim.Data.NHibernate.NHPrim, OpenSim.Data.NHibernate" table="Prims" lazy="false"> | 3 | <class name="OpenSim.Region.Environment.Scene.SceneObjectPart, OpenSim.Region.Environment.Scene" table="Prims" lazy="false"> |
4 | <id name="UUID" column="ID" type="OpenSim.Data.NHibernate.LLUUIDUserType, OpenSim.Data.NHibernate"> | 4 | <id name="UUID" column="ID" type="OpenSim.Data.NHibernate.LLUUIDUserType, OpenSim.Data.NHibernate"> |
5 | <generator class="assigned" /> | 5 | <generator class="assigned" /> |
6 | </id> | 6 | </id> |
7 | <property name="ParentID" type="System.UInt32" /> | 7 | <property name="ParentID" type="OpenSim.Data.NHibernate.LLUUIDUserType, OpenSim.Data.NHibernate" /> |
8 | <property name="RegionID" type="OpenSim.Data.NHibernate.LLUUIDUserType, OpenSim.Data.NHibernate" /> | 8 | <property name="RegionID" type="OpenSim.Data.NHibernate.LLUUIDUserType, OpenSim.Data.NHibernate" /> |
9 | <property name="CreationDate" type="System.Int32" /> | 9 | <property name="CreationDate" type="System.Int32" /> |
10 | <property name="Name" type="String" length="255" /> | 10 | <property name="Name" type="String" length="255" /> |
@@ -75,4 +75,10 @@ | |||
75 | <column name="SitTargetOrientW" /> | 75 | <column name="SitTargetOrientW" /> |
76 | </property> | 76 | </property> |
77 | </class> | 77 | </class> |
78 | |||
79 | <class name="OpenSim.Framework.PrimitiveBaseShape, OpenSim.Framework" table="PrimShapes" lazy="false"> | ||
80 | <id name="UUID" column="ID" type="OpenSim.Data.NHibernate.LLUUIDUserType, OpenSim.Data.NHibernate"> | ||
81 | <generator class="assigned" /> | ||
82 | </id> | ||
83 | </class> | ||
78 | </hibernate-mapping> \ No newline at end of file | 84 | </hibernate-mapping> \ No newline at end of file |