UPDATE tt_content
LEFT JOIN sys_file_reference ON sys_file_reference.uid_foreign=tt_content.uid
AND sys_file_reference.tablenames='tt_content'
AND sys_file_reference.fieldname='image'
SET tt_content.CType='textmedia', tt_content.assets=tt_content.image, tt_content.image=0, sys_file_reference.fieldname='assets'
WHERE tt_content.CType='textpic' OR tt_content.CType='image';
Update auf TYPO3 9.5: Schritt für Schritt