CDF display format

This result set should be compared with the list of correct combinations-

SELECT
`field`. fieldtype,
`field`.display_mechanism,
customdefinedfield.cdf_datatype,
Count(`field`.field_guid)
FROM
customdefinedfield
Inner Join `field` ON `field`.cdf_guid = customdefinedfield.cdf_id
GROUP BY
`field`.fieldtype,
`field`.display_mechanism,
customdefinedfield.cdf_datatype
ORDER BY
`field`.fieldtype ASC,
`field`.display_mechanism ASC,
customdefinedfield.cdf_datatype ASC

This UPDATE query is just one of several that might need to be applied

Update `field`
SET `field`.display_mechanism = null
where `field`.display_mechanism = '' AND
`field`. fieldtype = 'cdf'