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.sql35
-rw-r--r--OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml10
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 @@
1CREATE TABLE `prims` ( 1CREATE 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
53CREATE 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