aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MySQLDialect
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect')
-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