From 194ffb4d88266fcea4cd2e79e4844505c5d663f8 Mon Sep 17 00:00:00 2001 From: Sean Dague Date: Wed, 16 Jul 2008 21:27:52 +0000 Subject: made SOP have a blank setter for 2 convenience properties. Got RegionStore mapping to the point that nhibernate would start, though definitely not complete --- .../NHibernate/Resources/MySQLDialect/001_RegionStore.sql | 15 ++++++--------- OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml | 13 +++++++++---- 2 files changed, 15 insertions(+), 13 deletions(-) (limited to 'OpenSim/Data') diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql index ede281c..1811a44 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql @@ -45,12 +45,7 @@ CREATE TABLE `Prims` ( `OwnerID` char(36) default NULL, `GroupID` char(36) default NULL, `LastOwnerID` char(36) default NULL, - PRIMARY KEY (`UUID`), - KEY `prims_regionuuid` (`RegionID`), - KEY 'prims_parentuuid' ('ParentUUID') -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `PrimShapes` ( + -- this is the shape `Shape` int(11) default NULL, `ScaleX` float default NULL, `ScaleY` float default NULL, @@ -77,6 +72,8 @@ CREATE TABLE `PrimShapes` ( `State` int(11) default NULL, `Texture` longblob, `ExtraParams` longblob, - `UUID` char(36) NOT NULL default '', - PRIMARY KEY (`UUID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + PRIMARY KEY (`UUID`), + KEY `prims_regionuuid` (`RegionID`), + KEY 'prims_parentuuid' ('ParentUUID') +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + diff --git a/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml b/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml index 0004444..4fe01e1 100644 --- a/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml +++ b/OpenSim/Data/NHibernate/Resources/RegionStore.hbm.xml @@ -1,6 +1,6 @@ - + @@ -75,9 +75,14 @@ - - + + + + + + + \ No newline at end of file -- cgit v1.1