3.3.6 etc/upgrade/3.3.0/schema.mysql case problems

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

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