aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
diff options
context:
space:
mode:
authorSean Dague2008-07-16 21:27:52 +0000
committerSean Dague2008-07-16 21:27:52 +0000
commit194ffb4d88266fcea4cd2e79e4844505c5d663f8 (patch)
tree0aee15b9b86e343ae320f97d039e233c703f3a00 /OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
parentbe a little more discriminating on firing ShapeChanged script events (diff)
downloadopensim-SC_OLD-194ffb4d88266fcea4cd2e79e4844505c5d663f8.zip
opensim-SC_OLD-194ffb4d88266fcea4cd2e79e4844505c5d663f8.tar.gz
opensim-SC_OLD-194ffb4d88266fcea4cd2e79e4844505c5d663f8.tar.bz2
opensim-SC_OLD-194ffb4d88266fcea4cd2e79e4844505c5d663f8.tar.xz
made SOP have a blank setter for 2 convenience properties.
Got RegionStore mapping to the point that nhibernate would start, though definitely not complete
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql15
1 files changed, 6 insertions, 9 deletions
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` (
45 `OwnerID` char(36) default NULL, 45 `OwnerID` char(36) default NULL,
46 `GroupID` char(36) default NULL, 46 `GroupID` char(36) default NULL,
47 `LastOwnerID` char(36) default NULL, 47 `LastOwnerID` char(36) default NULL,
48 PRIMARY KEY (`UUID`), 48 -- this is the shape
49 KEY `prims_regionuuid` (`RegionID`),
50 KEY 'prims_parentuuid' ('ParentUUID')
51) ENGINE=InnoDB DEFAULT CHARSET=utf8;
52
53CREATE TABLE `PrimShapes` (
54 `Shape` int(11) default NULL, 49 `Shape` int(11) default NULL,
55 `ScaleX` float default NULL, 50 `ScaleX` float default NULL,
56 `ScaleY` float default NULL, 51 `ScaleY` float default NULL,
@@ -77,6 +72,8 @@ CREATE TABLE `PrimShapes` (
77 `State` int(11) default NULL, 72 `State` int(11) default NULL,
78 `Texture` longblob, 73 `Texture` longblob,
79 `ExtraParams` longblob, 74 `ExtraParams` longblob,
80 `UUID` char(36) NOT NULL default '', 75 PRIMARY KEY (`UUID`),
81 PRIMARY KEY (`UUID`) 76 KEY `prims_regionuuid` (`RegionID`),
82) ENGINE=InnoDB DEFAULT CHARSET=utf8; 77 KEY 'prims_parentuuid' ('ParentUUID')
78) ENGINE=InnoDB DEFAULT CHARSET=utf8;
79