What does the Diabled field mean for ObjectCustomFieldValues?
The comment below doesn’t mean anything to me…
CREATE TABLE ObjectCustomFieldValues (
id INTEGER NOT NULL AUTO_INCREMENT,
CustomField int NOT NULL ,
ObjectType varchar(255) NOT NULL, # Final target of the Object
ObjectId int NOT NULL , # New – Replaces Ticket
SortOrder integer NOT NULL DEFAULT 0 , # New – ordering for multiple values
Content varchar(255) NULL ,
LargeContent LONGTEXT NULL, # New – to hold 255+ strings
ContentType varchar(80) NULL, # New – only text/* gets searched
ContentEncoding varchar(80) NULL , # New – for binary Content
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
Disabled int2 NOT NULL DEFAULT 0 , # New – whether the value was current
PRIMARY KEY (id)
) TYPE=InnoDB;
Also, does it indicate that there is an RT bug when both of
these records are in the table?:
mysql> select * from ObjectCustomFieldValues where ObjectId=517 and Content=‘123’;
| id | ObjectId | CustomField | Content | Creator | Created | LastUpdatedBy | LastUpdated | ObjectType | LargeContent | ContentType | ContentEncoding | SortOrder | Disabled |
| 6466 | 517 | 1 | 123 | 71 | 2004-11-16 19:12:16 | 71 | 2004-11-16 19:19:15 | RT::Ticket | NULL | NULL | | 0 | 1 |
| 6468 | 517 | 8 | 123 | 71 | 2004-11-16 19:52:34 | 71 | 2004-11-16 19:54:55 | RT::Ticket | NULL | NULL | | 0 | 1 |
| 6473 | 517 | 1 | 123 | 71 | 2004-11-16 20:32:14 | 71 | 2004-11-16 20:32:14 | RT::Ticket | NULL | NULL | | 0 | 0 |
3 rows in set (0.00 sec)