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!

---
 .../Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql   | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql')

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
index 13d8cf6..93d282b 100644
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql
@@ -1,7 +1,7 @@
 CREATE TABLE InventoryFolders (
   ID VARCHAR(36) NOT NULL,
   Type SMALLINT DEFAULT NULL,
-  Version SMALLINT DEFAULT NULL,
+  Version INT DEFAULT NULL,
   ParentID VARCHAR(36) DEFAULT NULL,
   Owner VARCHAR(36) DEFAULT NULL,
   Name VARCHAR(64) DEFAULT NULL,
@@ -13,8 +13,8 @@ CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID);
 
 CREATE TABLE InventoryItems (
   ID VARCHAR(36) NOT NULL,
-  InvType SMALLINT DEFAULT NULL,
-  AssetType SMALLINT DEFAULT NULL,
+  InvType INT DEFAULT NULL,
+  AssetType INT DEFAULT NULL,
   AssetID VARCHAR(36) DEFAULT NULL,
   Folder VARCHAR(36) DEFAULT NULL,
   Owner VARCHAR(36) DEFAULT NULL,
-- 
cgit v1.1

