begin;
-- force transcoding for MPEG files
update meta_data set mime_type = 'invalid/content' where mime_type='video/mpeg';
-- alter mime type of avi files
update meta_data set mime_type = 'video/avi' where mime_type='video/x-msvideo';
-- alter upnp class for JPEG images - the xbox does not show other images anyway
update meta_data set class = 'object.item.imageItem.photo' where mime_type='image/jpeg';
commit;

