[rt-users] Correspondence and comment addresses limited to 40 characters

[Jesse Vincent]

On Fri, Sep 14, 2001 at 12:29:40PM -0400, John Stoffel wrote:
> 
> Jesse> Take a look at the db schema. change the column lengths  
> Jesse> for Correspond and Comment addresses from 40 to 255.
> 
> Should these be 'varchar' types so we can make them larger for sites
> that might need the length, but not waste as much space for places
> with smaller addresses?

They are varchar types. In the current 2.0.x, they're just too short.
(though really, the amount of space wasted if they were all char(255) would
be pretty inconsequential. There just aren't that many queue records...

	-j

> This is all MySQL commentary, I don't know anything else.
> 
> John
> 
> P.S.  It was nice meeting you wednesday Jesse!
> 
>    John Stoffel - Senior Unix Systems Administrator - Lucent Technologies
> 	 stoffel at lucent.com - http://www.lucent.com - 978-952-7548
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.