[Opensim-dev] Item description should be varchar(84) or varchar(64)?

[Ai Austin]

At 10:03 31/07/2014, Tom Mettam wrote:
>I believe it should be VARCHAR(127), since object descriptions can 
>be 127 characters long.


Ah thanks Tom ...  prims can actually be varchar(255) according to my 
schema and I now wonder if the assets "name" field should also be 
varchar(64), as it is for Openvue grid just now, or something else?

I see that prims and primitems have varchar(255) for both the name 
and description which seems odd as I would think all these should be the same?

I created a fresh data base for Openvue for a new server setup as 
recently as May 2013 and loaded content back in then via OARS and 
IARs rather than a SQL backup. So I wonder how I got the varchar(64) 
description and if anyone else has the same value?

Does anyone have the SQL skill to know the command which will amend 
the description field to change its size and advise if that could 
mess up any existing assets that have a varchar(64) current description?

-- Yuck.  I see that in prims the CreatorID can be varchar(255) 
presuMably to accommodate HG creators, but that LastOwnerIDis 
char(36) yet that also of course can be a HG user.  Maybe this shouLd 
be a mantis issue as there seems to be a check needed at least?