[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