[rt-users] 3.3.6 etc/upgrade/3.3.0/schema.mysql case problems

[Jesse Vincent]

Yep. Already fixed in the repository. The next 3.3.x release should be
out in the next day or so.


On Thu, Sep 23, 2004 at 12:00:48AM -0400, Jason Parsons wrote:
> 
> etc/upgrade/3.3.0/schema.mysql includes, in part:
> 
> alter table objectcustomfieldvalues add column ObjectType varchar(255) 
> not null;
> update objectcustomfieldvalues set ObjectType = 'RT::Ticket';
> alter table objectcustomfieldvalues add column Current bool default 1;
> alter table objectcustomfieldvalues add column LargeContent LONGTEXT 
> NULL;
> alter table objectcustomfieldvalues add column ContentType varchar(80) 
> NULL;
> alter table objectcustomfieldvalues add column ContentEncoding 
> varchar(80) NULL;
> alter table objectcustomfieldvalues drop index ticketcustomfieldvalues1;
> alter table objectcustomfieldvalues drop index ticketcustomfieldvalues2;
> alter table objectcustomfieldvalues add index ObjectCustomFieldValues1 
> (Content);
> alter table objectcustomfieldvalues add index ObjectCustomFieldValues2 
> (CustomField,ObjectType,ObjectId);
> 
> The table is actually named ObjectCustomFieldValues.  Case does matter.
> 
>  - Jason Parsons
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
> 

--