UPDATE spip_types_documents SET mime_type = 'image/jpeg' WHERE extension = 'jpg'; UPDATE spip_types_documents SET mime_type = 'image/png' WHERE extension = 'png'; UPDATE spip_types_documents SET mime_type = 'image/gif' WHERE extension = 'gif'; UPDATE spip_types_documents SET mime_type = 'image/bmp' WHERE extension = 'bmp'; UPDATE spip_types_documents SET mime_type = 'image/psd' WHERE extension = 'psd'; UPDATE spip_types_documents SET mime_type = 'image/tiff' WHERE extension = 'tif'; UPDATE spip_types_documents SET mime_type = 'audio/x-aiff' WHERE extension = 'aiff'; UPDATE spip_types_documents SET mime_type = 'application/vnd.ms-asf' WHERE extension = 'asf'; UPDATE spip_types_documents SET mime_type = 'video/x-msvideo' WHERE extension = 'avi'; UPDATE spip_types_documents SET mime_type = 'audio/midi' WHERE extension = 'mid'; UPDATE spip_types_documents SET mime_type = 'video/quicktime' WHERE extension = 'mov'; UPDATE spip_types_documents SET mime_type = 'audio/mpeg' WHERE extension = 'mp3'; UPDATE spip_types_documents SET mime_type = 'video/mpeg' WHERE extension = 'mpg'; UPDATE spip_types_documents SET mime_type = 'application/ogg' WHERE extension = 'ogg'; UPDATE spip_types_documents SET mime_type = 'video/quicktime' WHERE extension = 'qt'; UPDATE spip_types_documents SET mime_type = 'audio/x-realaudio' WHERE extension = 'ra'; UPDATE spip_types_documents SET mime_type = 'audio/x-pn-realaudio' WHERE extension = 'ram'; UPDATE spip_types_documents SET mime_type = 'audio/x-pn-realaudio' WHERE extension = 'rm'; UPDATE spip_types_documents SET mime_type = 'application/x-shockwave-flash' WHERE extension = 'swf'; UPDATE spip_types_documents SET mime_type = 'audio/x-wav' WHERE extension = 'wav'; UPDATE spip_types_documents SET mime_type = 'application/postscript' WHERE extension = 'ai'; UPDATE spip_types_documents SET mime_type = 'application/x-bzip2' WHERE extension = 'bz2'; UPDATE spip_types_documents SET mime_type = 'application/msword' WHERE extension = 'doc'; UPDATE spip_types_documents SET mime_type = 'image/vnd.djvu' WHERE extension = 'djvu'; UPDATE spip_types_documents SET mime_type = 'application/x-dvi' WHERE extension = 'dvi'; UPDATE spip_types_documents SET mime_type = 'application/postscript' WHERE extension = 'eps'; UPDATE spip_types_documents SET mime_type = 'application/x-gzip' WHERE extension = 'gz'; UPDATE spip_types_documents SET mime_type = 'text/html' WHERE extension = 'html'; UPDATE spip_types_documents SET mime_type = 'application/pdf' WHERE extension = 'pdf'; UPDATE spip_types_documents SET mime_type = 'application/vnd.ms-powerpoint' WHERE extension = 'ppt'; UPDATE spip_types_documents SET mime_type = 'application/postscript' WHERE extension = 'ps'; UPDATE spip_types_documents SET mime_type = 'application/x-rpm' WHERE extension = 'rpm'; UPDATE spip_types_documents SET mime_type = 'application/rtf' WHERE extension = 'rtf'; UPDATE spip_types_documents SET mime_type = 'application/x-stuffit' WHERE extension = 'sit'; UPDATE spip_types_documents SET mime_type = 'application/vnd.sun.xml.calc' WHERE extension = 'sxc'; UPDATE spip_types_documents SET mime_type = 'application/vnd.sun.xml.impress' WHERE extension = 'sxi'; UPDATE spip_types_documents SET mime_type = 'application/vnd.sun.xml.writer' WHERE extension = 'sxw'; UPDATE spip_types_documents SET mime_type = 'application/x-tex' WHERE extension = 'tex'; UPDATE spip_types_documents SET mime_type = 'application/x-gzip' WHERE extension = 'tgz'; UPDATE spip_types_documents SET mime_type = 'text/plain' WHERE extension = 'txt'; UPDATE spip_types_documents SET mime_type = 'application/vnd.ms-excel' WHERE extension = 'xls'; UPDATE spip_types_documents SET mime_type = 'text/xml' WHERE extension = 'xml'; UPDATE spip_types_documents SET mime_type = 'application/zip' WHERE extension = 'zip';