From 631e10f269210cc352acc453fe04f56343c73360 Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Thu, 19 Feb 2009 18:31:45 +0000
Subject: * Apply http://opensimulator.org/mantis/view.php?id=3151 * Fixes
 NHibernate overflow exception when saving some objects (under at least
 PostgreSQL 8.3) * Thanks Tommil!

---
 .../Resources/MsSql2005Dialect/001_InventoryStore.sql          |  2 +-
 .../NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql  | 10 +++++-----
 2 files changed, 6 insertions(+), 6 deletions(-)

(limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect')

diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql
index 37ba733..82936c4 100644
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_InventoryStore.sql
@@ -1,7 +1,7 @@
 create table InventoryFolders (
   ID NVARCHAR(255) not null,
    Type SMALLINT null,
-   Version SMALLINT null,
+   Version INT null,
    ParentID NVARCHAR(255) null,
    Owner NVARCHAR(255) null,
    Name NVARCHAR(64) null,
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql
index 56ad905..f388f1a 100644
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql
@@ -49,8 +49,8 @@ create table Prims (
    ScaleY REAL null,
    ScaleZ REAL null,
    PCode TINYINT null,
-   PathBegin SMALLINT null,
-   PathEnd SMALLINT null,
+   PathBegin INT null,
+   PathEnd INT null,
    PathScaleX TINYINT null,
    PathScaleY TINYINT null,
    PathShearX TINYINT null,
@@ -62,10 +62,10 @@ create table Prims (
    PathTaperX TINYINT null,
    PathTaperY TINYINT null,
    PathTwist TINYINT null,
-   ProfileBegin SMALLINT null,
-   ProfileEnd SMALLINT null,
+   ProfileBegin INT null,
+   ProfileEnd INT null,
    ProfileCurve TINYINT null,
-   ProfileHollow SMALLINT null,
+   ProfileHollow INT null,
    Texture VARBINARY(8000) null,
    ExtraParams VARBINARY(8000) null,
    State TINYINT null,
-- 
cgit v1.1