* Apply http://opensimulator.org/mantis/view.php?id=2965

* Adds first version of MsSql2005Dialect support for NHibernate
* Thanks mpallari

1 files changed, 35 insertions, 0 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql
new file mode 100644
index 0000000..0dfec7f
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql
@@ -0,0 +1,35 @@
+create table Regions (
+  Uuid NVARCHAR(255) not null,
+   RegionHandle BIGINT null,
+   RegionName NVARCHAR(32) null,
+   RegionRecvKey NVARCHAR(128) null,
+   RegionSendKey NVARCHAR(128) null,
+   RegionSecret NVARCHAR(128) null,
+   RegionDataURI NVARCHAR(255) null,
+   ServerIP NVARCHAR(64) null,
+   ServerPort INT null,
+   ServerURI NVARCHAR(255) null,
+   RegionLocX INT null,
+   RegionLocY INT null,
+   RegionLocZ INT null,
+   EastOverrideHandle BIGINT null,
+   WestOverrideHandle BIGINT null,
+   SouthOverrideHandle BIGINT null,
+   NorthOverrideHandle BIGINT null,
+   RegionAssetURI NVARCHAR(255) null,
+   RegionAssetRecvKey NVARCHAR(128) null,
+   RegionAssetSendKey NVARCHAR(128) null,
+   RegionUserURI NVARCHAR(255) null,
+   RegionUserRecvKey NVARCHAR(128) null,
+   RegionUserSendKey NVARCHAR(128) null,
+   ServerHttpPort INT null,
+   ServerRemotingPort INT null,
+   RegionMapTextureID NVARCHAR(255) null,
+   Owner_uuid NVARCHAR(255) null,
+   OriginUUID NVARCHAR(255) null,
+   primary key (Uuid)
+)
+create index region_handle on Regions (RegionHandle)
+create index region_name on Regions (RegionName)
+create index overrideHandles on Regions (EastOverrideHandle, WestOverrideHandle, SouthOverrideHandle, NorthOverrideHandle)
+