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 ++++++---------
 1 file changed, 6 insertions(+), 9 deletions(-)

(limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql')

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;
+
-- 
cgit v1.1

