From d48e992aa8efb8c8cde0e7fd5eef4fdb91701361 Mon Sep 17 00:00:00 2001 From: Justin Clarke Casey Date: Fri, 7 Mar 2008 14:40:18 +0000 Subject: * Increase inventory description columns from 64 characters to 128 As per the suggestions in Mantis 687 (thanks Sakai) to resolve an exception * This won't apply to any existing inventory tables you have, but shouldn't cause any issues with old tables either --- OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql | 2 +- OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'OpenSim') diff --git a/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql index 40c047e..5bb27ba 100644 --- a/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Framework/Data.MSSQL/Resources/CreateItemsTable.sql @@ -11,7 +11,7 @@ CREATE TABLE [inventoryitems] ( [parentFolderID] [varchar](36) default NULL, [avatarID] [varchar](36) default NULL, [inventoryName] [varchar](64) default NULL, - [inventoryDescription] [varchar](64) default NULL, + [inventoryDescription] [varchar](128) default NULL, [inventoryNextPermissions] [int] default NULL, [inventoryCurrentPermissions] [int] default NULL, [invType] [int] default NULL, diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql index 53d2db0..1723ee3 100644 --- a/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql +++ b/OpenSim/Framework/Data.MySQL/Resources/CreateItemsTable.sql @@ -5,7 +5,7 @@ CREATE TABLE `inventoryitems` ( `parentFolderID` varchar(36) default NULL, `avatarID` varchar(36) default NULL, `inventoryName` varchar(64) default NULL, - `inventoryDescription` varchar(64) default NULL, + `inventoryDescription` varchar(128) default NULL, `inventoryNextPermissions` int(10) unsigned default NULL, `inventoryCurrentPermissions` int(10) unsigned default NULL, `invType` int(11) default NULL, -- cgit v1.1