Lines Matching refs:CustomFields
52 …er, Creator, LastUpdatedBy) SELECT id, Queue, SortOrder, Creator, LastUpdatedBy from CustomFields;
54 alter table CustomFields add column LookupType varchar(255);
55 alter table CustomFields add column Repeated int2;
56 alter table CustomFields add column Pattern varchar(255) NULL;
57 alter table CustomFields add column MaxValues integer;
59 UPDATE CustomFields SET MaxValues = 0 WHERE Type LIKE '%Multiple';
60 UPDATE CustomFields SET MaxValues = 1 WHERE Type LIKE '%Single';
61 UPDATE CustomFields SET Type = 'Select' WHERE Type LIKE 'Select%';
62 UPDATE CustomFields SET Type = 'Freeform' WHERE Type LIKE 'Freeform%';
63 UPDATE CustomFields Set LookupType = 'RT::Queue-RT::Ticket';
64 ALTER TABLE CustomFields ALTER COLUMN LookupType SET NOT NULL;
65 UPDATE CustomFields Set Repeated = 0;
66 ALTER TABLE CustomFields ALTER COLUMN Repeated SET DEFAULT 0;
67 ALTER TABLE CustomFields ALTER COLUMN Repeated SET NOT NULL;
68 alter table CustomFields drop column Queue;