1 files changed, 35 insertions, 32 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql
index df09603..5fb1c19 100644
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql
@@ -1,32 +1,35 @@
-CREATE TABLE `regions` (
-  `Uuid` varchar(36) NOT NULL,
-  `RegionHandle` bigint(20) unsigned NOT NULL,
-  `RegionName` varchar(32) default NULL,
-  `RegionRecvKey` varchar(128) default NULL,
-  `RegionSendKey` varchar(128) default NULL,
-  `RegionSecret` varchar(128) default NULL,
-  `RegionDataURI` varchar(255) default NULL,
-  `ServerIP` varchar(64) default NULL,
-  `ServerPort` int(10) unsigned default NULL,
-  `ServerURI` varchar(255) default NULL,
-  `RegionLocX` int(10) unsigned default NULL,
-  `RegionLocY` int(10) unsigned default NULL,
-  `RegionLocZ` int(10) unsigned default NULL,
-  `EastOverrideHandle` bigint(20) unsigned default NULL,
-  `WestOverrideHandle` bigint(20) unsigned default NULL,
-  `SouthOverrideHandle` bigint(20) unsigned default NULL,
-  `NorthOverrideHandle` bigint(20) unsigned default NULL,
-  `RegionAssetURI` varchar(255) default NULL,
-  `RegionAssetRecvKey` varchar(128) default NULL,
-  `RegionAssetSendKey` varchar(128) default NULL,
-  `RegionUserURI` varchar(255) default NULL,
-  `RegionUserRecvKey` varchar(128) default NULL,
-  `RegionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL,
-  `ServerHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL,
-  `Owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
-  `OriginUUID` varchar(36),
-  PRIMARY KEY  (`uuid`),
-  KEY `region_name` (`RegionName`),
-  KEY `region_handle` (`RegionHandle`),
-  KEY `overrideHandles` (`EastOverrideHandle`,`WestOverrideHandle`,`SouthOverrideHandle`,`NorthOverrideHandle`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
\ No newline at end of file
+CREATE TABLE Regions (
+  RegionID VARCHAR(36) NOT NULL,
+  OwnerID VARCHAR(36) DEFAULT NULL,
+  OriginID VARCHAR(36) DEFAULT NULL,
+  RegionHandle BIGINT DEFAULT NULL,
+  RegionName VARCHAR(32) DEFAULT NULL,
+  RegionRecvKey VARCHAR(128) DEFAULT NULL,
+  RegionSendKey VARCHAR(128) DEFAULT NULL,
+  RegionSecret VARCHAR(128) DEFAULT NULL,
+  RegionDataURI VARCHAR(255) DEFAULT NULL,
+  ServerIP VARCHAR(64) DEFAULT NULL,
+  ServerPort INT DEFAULT NULL,
+  ServerURI VARCHAR(255) DEFAULT NULL,
+  RegionLocX INT DEFAULT NULL,
+  RegionLocY INT DEFAULT NULL,
+  RegionLocZ INT DEFAULT NULL,
+  EastOverrideHandle BIGINT DEFAULT NULL,
+  WestOverrideHandle BIGINT DEFAULT NULL,
+  SouthOverrideHandle BIGINT DEFAULT NULL,
+  NorthOverrideHandle BIGINT DEFAULT NULL,
+  RegionAssetURI VARCHAR(255) DEFAULT NULL,
+  RegionAssetRecvKey VARCHAR(128) DEFAULT NULL,
+  RegionAssetSendKey VARCHAR(128) DEFAULT NULL,
+  RegionUserURI VARCHAR(255) DEFAULT NULL,
+  RegionUserRecvKey VARCHAR(128) DEFAULT NULL,
+  RegionUserSendKey VARCHAR(128) DEFAULT NULL, 
+  RegionMapTexture VARCHAR(36) DEFAULT NULL,
+  ServerHttpPort INT DEFAULT NULL, 
+  ServerRemotingPort INT DEFAULT NULL,
+  PRIMARY KEY  (uuid),
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
+
+CREATE INDEX RegionNameIndex ON Regions (RegionName);
+CREATE INDEX RegionHandleIndex ON Regions (RegionHandle);
+CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle);