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

Jason Parsons jparsons-lists at saffron.net
Thu Sep 23 00:00:48 EDT 2004


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




More information about the rt-users mailing list