1 files changed, 32 insertions, 0 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql
new file mode 100644
index 0000000..df09603
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql
@@ -0,0 +1,32 @@
+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