From 37f7c5a0ea272761793e072f2439e5b8e5f30e13 Mon Sep 17 00:00:00 2001 From: Justin Clarke Casey Date: Tue, 20 Jan 2009 18:38:51 +0000 Subject: * Apply http://opensimulator.org/mantis/view.php?id=3020 * Adds a grid db implementation and unit tests to the NHibernate module --- .../Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect') diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql index 0dfec7f..e4ad525 100644 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql @@ -1,5 +1,5 @@ create table Regions ( - Uuid NVARCHAR(255) not null, + Uuid NVARCHAR(36) not null, RegionHandle BIGINT null, RegionName NVARCHAR(32) null, RegionRecvKey NVARCHAR(128) null, @@ -24,9 +24,9 @@ create table Regions ( RegionUserSendKey NVARCHAR(128) null, ServerHttpPort INT null, ServerRemotingPort INT null, - RegionMapTextureID NVARCHAR(255) null, - Owner_uuid NVARCHAR(255) null, - OriginUUID NVARCHAR(255) null, + RegionMapTextureID NVARCHAR(36) null, + Owner_uuid NVARCHAR(36) null, + OriginUUID NVARCHAR(36) null, primary key (Uuid) ) create index region_handle on Regions (RegionHandle) -- cgit v1.1