diff options
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 | |||