* 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!

2 files changed, 6 insertions, 6 deletions

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,