diff options
author | Sean Dague | 2008-07-16 21:27:52 +0000 |
---|---|---|
committer | Sean Dague | 2008-07-16 21:27:52 +0000 |
commit | 194ffb4d88266fcea4cd2e79e4844505c5d663f8 (patch) | |
tree | 0aee15b9b86e343ae320f97d039e233c703f3a00 /OpenSim/Data/NHibernate/Resources/MySQLDialect | |
parent | be a little more discriminating on firing ShapeChanged script events (diff) | |
download | opensim-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')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | 15 |
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 | |||
53 | CREATE 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 | |||