Re: svn commit: r478275 - in /incubator/roller/trunk/metadata/database: 310-to-320-migration.vm createdb.vm

[Allen Gilliland <al...@sun.com>]

dear lord, you must have read my mind.  i just sent out an email about 
this a few seconds ago.

-- Allen


Dave wrote:
> What's the consensus here?
> 
> Currently, the database creation scripts setup MySQL to continue to
> use TEXT for the category and folder path fields and and everybody
> else uses VARCHAR(1000). Not ideal, but it works.
> 
> Should I change that and force all databases to use VARCHAR(255) for
> the path fields? That will work on all databases (MySQL 4 is the
> limiting factor).
> 
> Either way, we'll have to add logic to prevent users from creating
> category hierarchies that will not fit in the path field.
> 
> - Dave
> 
> 
> 
> On 11/27/06, Elias Torres <el...@torrez.us> wrote:
>>
>> Dave wrote:
>> > On 11/27/06, Allen Gilliland <al...@sun.com> wrote:
>>
>> ...[snip]...
>>
>>
>> > Yeah, I don't like one-offs either. My preference is to use the
>> > shortest varchar within reason. Unfortunately, thanks to MySQL 4.X,
>> > that 255. Fortunately, as you point out, that's well within reason
>> > considering our current category usage.
>> >
>> > - Dave
>> >
>>
>> I guess that as long as we stick to varchars we can also leave that up
>> to the installer to decide the needs of their site as a last resource.
>>
>> -Elias
>>