[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[3585] trunk
- Subject: SF.net SVN: ledger-smb:[3585] trunk
- From: ..hidden..
- Date: Thu, 28 Jul 2011 00:46:32 +0000
Revision: 3585
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3585&view=rev
Author: einhverfr
Date: 2011-07-28 00:46:32 +0000 (Thu, 28 Jul 2011)
Log Message:
-----------
mime type table data. Note for Windows users I think we will have to provide the freedesktop mime files to be extracted somewhere safe.
Modified Paths:
--------------
trunk/sql/Pg-database.sql
Added Paths:
-----------
trunk/tools/extract_mimes.sh
Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql 2011-07-28 00:12:08 UTC (rev 3584)
+++ trunk/sql/Pg-database.sql 2011-07-28 00:46:32 UTC (rev 3585)
@@ -3699,6 +3699,606 @@
COMMENT ON TABLE mime_type IS
$$ This is a lookup table for storing MIME types.$$;
+INSERT INTO mime_type (mime_type) VALUES('all/all');
+INSERT INTO mime_type (mime_type) VALUES('all/allfiles');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-flac');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-ape');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-scpls');
+INSERT INTO mime_type (mime_type) VALUES('audio/mp4');
+INSERT INTO mime_type (mime_type) VALUES('audio/mpeg');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-iriver-pla');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-speex+ogg');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-mod');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-tta');
+INSERT INTO mime_type (mime_type) VALUES('audio/annodex');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-mo3');
+INSERT INTO mime_type (mime_type) VALUES('audio/midi');
+INSERT INTO mime_type (mime_type) VALUES('audio/mp2');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-musepack');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-minipsf');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-mpegurl');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-aiff');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-xm');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-aifc');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-m4b');
+INSERT INTO mime_type (mime_type) VALUES('audio/aac');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-psflib');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-pn-realaudio-plugin');
+INSERT INTO mime_type (mime_type) VALUES('audio/basic');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-ms-wma');
+INSERT INTO mime_type (mime_type) VALUES('audio/AMR-WB');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-riff');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-psf');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-adpcm');
+INSERT INTO mime_type (mime_type) VALUES('audio/ogg');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-wav');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-matroska');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-voc');
+INSERT INTO mime_type (mime_type) VALUES('audio/ac3');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-flac+ogg');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-aiffc');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-it');
+INSERT INTO mime_type (mime_type) VALUES('audio/AMR');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-s3m');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-speex');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-wavpack');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-xi');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-xmf');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-wavpack-correction');
+INSERT INTO mime_type (mime_type) VALUES('audio/prs.sid');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-gsm');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-ms-asx');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-vorbis+ogg');
+INSERT INTO mime_type (mime_type) VALUES('audio/x-stm');
+INSERT INTO mime_type (mime_type) VALUES('x-epoc/x-sisx-app');
+INSERT INTO mime_type (mime_type) VALUES('image/x-fpx');
+INSERT INTO mime_type (mime_type) VALUES('image/x-panasonic-raw');
+INSERT INTO mime_type (mime_type) VALUES('image/x-xwindowdump');
+INSERT INTO mime_type (mime_type) VALUES('image/x-nikon-nef');
+INSERT INTO mime_type (mime_type) VALUES('image/x-niff');
+INSERT INTO mime_type (mime_type) VALUES('image/x-pict');
+INSERT INTO mime_type (mime_type) VALUES('image/svg+xml-compressed');
+INSERT INTO mime_type (mime_type) VALUES('image/jp2');
+INSERT INTO mime_type (mime_type) VALUES('image/x-msod');
+INSERT INTO mime_type (mime_type) VALUES('image/x-dds');
+INSERT INTO mime_type (mime_type) VALUES('image/x-olympus-orf');
+INSERT INTO mime_type (mime_type) VALUES('image/x-portable-graymap');
+INSERT INTO mime_type (mime_type) VALUES('image/x-skencil');
+INSERT INTO mime_type (mime_type) VALUES('image/x-sony-srf');
+INSERT INTO mime_type (mime_type) VALUES('image/x-dib');
+INSERT INTO mime_type (mime_type) VALUES('image/x-emf');
+INSERT INTO mime_type (mime_type) VALUES('image/x-eps');
+INSERT INTO mime_type (mime_type) VALUES('image/ief');
+INSERT INTO mime_type (mime_type) VALUES('image/x-pcx');
+INSERT INTO mime_type (mime_type) VALUES('image/x-gzeps');
+INSERT INTO mime_type (mime_type) VALUES('image/x-xcf');
+INSERT INTO mime_type (mime_type) VALUES('image/x-portable-pixmap');
+INSERT INTO mime_type (mime_type) VALUES('image/x-kde-raw');
+INSERT INTO mime_type (mime_type) VALUES('image/openraster');
+INSERT INTO mime_type (mime_type) VALUES('image/x-macpaint');
+INSERT INTO mime_type (mime_type) VALUES('image/x-wmf');
+INSERT INTO mime_type (mime_type) VALUES('image/x-win-bitmap');
+INSERT INTO mime_type (mime_type) VALUES('image/x-sgi');
+INSERT INTO mime_type (mime_type) VALUES('image/x-ilbm');
+INSERT INTO mime_type (mime_type) VALUES('image/x-sony-sr2');
+INSERT INTO mime_type (mime_type) VALUES('image/x-sigma-x3f');
+INSERT INTO mime_type (mime_type) VALUES('image/x-bzeps');
+INSERT INTO mime_type (mime_type) VALUES('image/x-icns');
+INSERT INTO mime_type (mime_type) VALUES('image/g3fax');
+INSERT INTO mime_type (mime_type) VALUES('image/x-applix-graphics');
+INSERT INTO mime_type (mime_type) VALUES('image/x-xcursor');
+INSERT INTO mime_type (mime_type) VALUES('image/x-kodak-dcr');
+INSERT INTO mime_type (mime_type) VALUES('image/x-hdr');
+INSERT INTO mime_type (mime_type) VALUES('image/x-cmu-raster');
+INSERT INTO mime_type (mime_type) VALUES('image/x-sun-raster');
+INSERT INTO mime_type (mime_type) VALUES('image/fax-g3');
+INSERT INTO mime_type (mime_type) VALUES('image/x-kodak-kdc');
+INSERT INTO mime_type (mime_type) VALUES('image/jpeg');
+INSERT INTO mime_type (mime_type) VALUES('image/tiff');
+INSERT INTO mime_type (mime_type) VALUES('image/dpx');
+INSERT INTO mime_type (mime_type) VALUES('image/x-dcraw');
+INSERT INTO mime_type (mime_type) VALUES('image/x-adobe-dng');
+INSERT INTO mime_type (mime_type) VALUES('image/x-canon-crw');
+INSERT INTO mime_type (mime_type) VALUES('image/bmp');
+INSERT INTO mime_type (mime_type) VALUES('image/x-xfig');
+INSERT INTO mime_type (mime_type) VALUES('image/x-lwo');
+INSERT INTO mime_type (mime_type) VALUES('image/x-fuji-raf');
+INSERT INTO mime_type (mime_type) VALUES('image/x-xbitmap');
+INSERT INTO mime_type (mime_type) VALUES('image/x-pentax-pef');
+INSERT INTO mime_type (mime_type) VALUES('image/x-exr');
+INSERT INTO mime_type (mime_type) VALUES('image/rle');
+INSERT INTO mime_type (mime_type) VALUES('image/x-3ds');
+INSERT INTO mime_type (mime_type) VALUES('image/svg+xml');
+INSERT INTO mime_type (mime_type) VALUES('image/x-lws');
+INSERT INTO mime_type (mime_type) VALUES('image/x-tga');
+INSERT INTO mime_type (mime_type) VALUES('image/x-compressed-xcf');
+INSERT INTO mime_type (mime_type) VALUES('image/fits');
+INSERT INTO mime_type (mime_type) VALUES('image/x-kodak-k25');
+INSERT INTO mime_type (mime_type) VALUES('image/x-portable-bitmap');
+INSERT INTO mime_type (mime_type) VALUES('image/x-quicktime');
+INSERT INTO mime_type (mime_type) VALUES('image/x-sony-arw');
+INSERT INTO mime_type (mime_type) VALUES('image/x-xpixmap');
+INSERT INTO mime_type (mime_type) VALUES('image/gif');
+INSERT INTO mime_type (mime_type) VALUES('image/x-portable-anymap');
+INSERT INTO mime_type (mime_type) VALUES('image/x-jng');
+INSERT INTO mime_type (mime_type) VALUES('image/x-iff');
+INSERT INTO mime_type (mime_type) VALUES('image/x-canon-cr2');
+INSERT INTO mime_type (mime_type) VALUES('image/cgm');
+INSERT INTO mime_type (mime_type) VALUES('image/x-photo-cd');
+INSERT INTO mime_type (mime_type) VALUES('image/png');
+INSERT INTO mime_type (mime_type) VALUES('image/x-minolta-mrw');
+INSERT INTO mime_type (mime_type) VALUES('image/x-rgb');
+INSERT INTO mime_type (mime_type) VALUES('image/x-pic');
+INSERT INTO mime_type (mime_type) VALUES('message/disposition-notification');
+INSERT INTO mime_type (mime_type) VALUES('message/news');
+INSERT INTO mime_type (mime_type) VALUES('message/partial');
+INSERT INTO mime_type (mime_type) VALUES('message/x-gnu-rmail');
+INSERT INTO mime_type (mime_type) VALUES('message/delivery-status');
+INSERT INTO mime_type (mime_type) VALUES('message/external-body');
+INSERT INTO mime_type (mime_type) VALUES('message/rfc822');
+INSERT INTO mime_type (mime_type) VALUES('uri/mmst');
+INSERT INTO mime_type (mime_type) VALUES('uri/rtspu');
+INSERT INTO mime_type (mime_type) VALUES('uri/pnm');
+INSERT INTO mime_type (mime_type) VALUES('uri/mmsu');
+INSERT INTO mime_type (mime_type) VALUES('uri/rtspt');
+INSERT INTO mime_type (mime_type) VALUES('uri/mms');
+INSERT INTO mime_type (mime_type) VALUES('text/x-tcl');
+INSERT INTO mime_type (mime_type) VALUES('text/directory');
+INSERT INTO mime_type (mime_type) VALUES('text/htmlh');
+INSERT INTO mime_type (mime_type) VALUES('text/x-literate-haskell');
+INSERT INTO mime_type (mime_type) VALUES('text/xmcd');
+INSERT INTO mime_type (mime_type) VALUES('text/x-ms-regedit');
+INSERT INTO mime_type (mime_type) VALUES('text/x-microdvd');
+INSERT INTO mime_type (mime_type) VALUES('text/x-erlang');
+INSERT INTO mime_type (mime_type) VALUES('text/x-ssa');
+INSERT INTO mime_type (mime_type) VALUES('text/plain');
+INSERT INTO mime_type (mime_type) VALUES('text/spreadsheet');
+INSERT INTO mime_type (mime_type) VALUES('text/sgml');
+INSERT INTO mime_type (mime_type) VALUES('text/x-uil');
+INSERT INTO mime_type (mime_type) VALUES('text/x-troff-mm');
+INSERT INTO mime_type (mime_type) VALUES('text/x-gettext-translation');
+INSERT INTO mime_type (mime_type) VALUES('text/x-vhdl');
+INSERT INTO mime_type (mime_type) VALUES('text/x-java');
+INSERT INTO mime_type (mime_type) VALUES('text/x-nfo');
+INSERT INTO mime_type (mime_type) VALUES('text/csv');
+INSERT INTO mime_type (mime_type) VALUES('text/x-install');
+INSERT INTO mime_type (mime_type) VALUES('text/x-c++src');
+INSERT INTO mime_type (mime_type) VALUES('text/x-subviewer');
+INSERT INTO mime_type (mime_type) VALUES('text/x-adasrc');
+INSERT INTO mime_type (mime_type) VALUES('text/x-dsl');
+INSERT INTO mime_type (mime_type) VALUES('text/x-chdr');
+INSERT INTO mime_type (mime_type) VALUES('text/calendar');
+INSERT INTO mime_type (mime_type) VALUES('text/x-csharp');
+INSERT INTO mime_type (mime_type) VALUES('text/x-lua');
+INSERT INTO mime_type (mime_type) VALUES('text/x-ocaml');
+INSERT INTO mime_type (mime_type) VALUES('text/x-iMelody');
+INSERT INTO mime_type (mime_type) VALUES('text/enriched');
+INSERT INTO mime_type (mime_type) VALUES('text/richtext');
+INSERT INTO mime_type (mime_type) VALUES('text/x-objchdr');
+INSERT INTO mime_type (mime_type) VALUES('text/x-makefile');
+INSERT INTO mime_type (mime_type) VALUES('text/x-copying');
+INSERT INTO mime_type (mime_type) VALUES('text/x-pascal');
+INSERT INTO mime_type (mime_type) VALUES('text/x-credits');
+INSERT INTO mime_type (mime_type) VALUES('text/x-mup');
+INSERT INTO mime_type (mime_type) VALUES('text/x-opml+xml');
+INSERT INTO mime_type (mime_type) VALUES('text/x-rpm-spec');
+INSERT INTO mime_type (mime_type) VALUES('text/x-xmi');
+INSERT INTO mime_type (mime_type) VALUES('text/x-dsrc');
+INSERT INTO mime_type (mime_type) VALUES('text/x-patch');
+INSERT INTO mime_type (mime_type) VALUES('text/x-authors');
+INSERT INTO mime_type (mime_type) VALUES('text/x-ldif');
+INSERT INTO mime_type (mime_type) VALUES('text/x-moc');
+INSERT INTO mime_type (mime_type) VALUES('text/x-tex');
+INSERT INTO mime_type (mime_type) VALUES('text/x-dcl');
+INSERT INTO mime_type (mime_type) VALUES('text/x-python');
+INSERT INTO mime_type (mime_type) VALUES('text/x-lilypond');
+INSERT INTO mime_type (mime_type) VALUES('text/x-katefilelist');
+INSERT INTO mime_type (mime_type) VALUES('text/troff');
+INSERT INTO mime_type (mime_type) VALUES('text/x-hex');
+INSERT INTO mime_type (mime_type) VALUES('text/x-google-video-pointer');
+INSERT INTO mime_type (mime_type) VALUES('text/x-haskell');
+INSERT INTO mime_type (mime_type) VALUES('text/x-ocl');
+INSERT INTO mime_type (mime_type) VALUES('text/x-idl');
+INSERT INTO mime_type (mime_type) VALUES('text/x-troff-me');
+INSERT INTO mime_type (mime_type) VALUES('text/x-bibtex');
+INSERT INTO mime_type (mime_type) VALUES('text/x-sql');
+INSERT INTO mime_type (mime_type) VALUES('text/x-emacs-lisp');
+INSERT INTO mime_type (mime_type) VALUES('text/x-eiffel');
+INSERT INTO mime_type (mime_type) VALUES('text/css');
+INSERT INTO mime_type (mime_type) VALUES('text/x-fortran');
+INSERT INTO mime_type (mime_type) VALUES('text/x-xslfo');
+INSERT INTO mime_type (mime_type) VALUES('text/x-matlab');
+INSERT INTO mime_type (mime_type) VALUES('text/x-uri');
+INSERT INTO mime_type (mime_type) VALUES('text/x-setext');
+INSERT INTO mime_type (mime_type) VALUES('text/x-readme');
+INSERT INTO mime_type (mime_type) VALUES('text/x-troff-ms');
+INSERT INTO mime_type (mime_type) VALUES('text/x-cmake');
+INSERT INTO mime_type (mime_type) VALUES('text/tab-separated-values');
+INSERT INTO mime_type (mime_type) VALUES('text/x-log');
+INSERT INTO mime_type (mime_type) VALUES('text/x-mpsub');
+INSERT INTO mime_type (mime_type) VALUES('text/x-mof');
+INSERT INTO mime_type (mime_type) VALUES('text/html');
+INSERT INTO mime_type (mime_type) VALUES('text/x-txt2tags');
+INSERT INTO mime_type (mime_type) VALUES('text/x-csrc');
+INSERT INTO mime_type (mime_type) VALUES('text/rfc822-headers');
+INSERT INTO mime_type (mime_type) VALUES('text/x-mrml');
+INSERT INTO mime_type (mime_type) VALUES('text/x-vala');
+INSERT INTO mime_type (mime_type) VALUES('text/x-iptables');
+INSERT INTO mime_type (mime_type) VALUES('text/x-c++hdr');
+INSERT INTO mime_type (mime_type) VALUES('text/x-scheme');
+INSERT INTO mime_type (mime_type) VALUES('text/x-texinfo');
+INSERT INTO mime_type (mime_type) VALUES('text/x-objcsrc');
+INSERT INTO mime_type (mime_type) VALUES('text/x-changelog');
+INSERT INTO mime_type (mime_type) VALUES('x-content/audio-dvd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/video-svcd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/video-hddvd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/blank-dvd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/video-vcd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/unix-software');
+INSERT INTO mime_type (mime_type) VALUES('x-content/blank-cd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/audio-cdda');
+INSERT INTO mime_type (mime_type) VALUES('x-content/win32-software');
+INSERT INTO mime_type (mime_type) VALUES('x-content/blank-hddvd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/audio-player');
+INSERT INTO mime_type (mime_type) VALUES('x-content/video-dvd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/image-picturecd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/blank-bd');
+INSERT INTO mime_type (mime_type) VALUES('x-content/video-bluray');
+INSERT INTO mime_type (mime_type) VALUES('x-content/image-dcf');
+INSERT INTO mime_type (mime_type) VALUES('x-content/software');
+INSERT INTO mime_type (mime_type) VALUES('model/vrml');
+INSERT INTO mime_type (mime_type) VALUES('fonts/package');
+INSERT INTO mime_type (mime_type) VALUES('application/x-hwp');
+INSERT INTO mime_type (mime_type) VALUES('application/x-pkcs7-certificates');
+INSERT INTO mime_type (mime_type) VALUES('application/x-shockwave-flash');
+INSERT INTO mime_type (mime_type) VALUES('application/x-turtle');
+INSERT INTO mime_type (mime_type) VALUES('application/x-rar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-bittorrent');
+INSERT INTO mime_type (mime_type) VALUES('application/prs.plucker');
+INSERT INTO mime_type (mime_type) VALUES('application/smil');
+INSERT INTO mime_type (mime_type) VALUES('application/x-abiword');
+INSERT INTO mime_type (mime_type) VALUES('application/x-blender');
+INSERT INTO mime_type (mime_type) VALUES('application/x-oleo');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-sunos-news');
+INSERT INTO mime_type (mime_type) VALUES('application/x-tex-gf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-netshow-channel');
+INSERT INTO mime_type (mime_type) VALUES('application/x-m4');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kexiproject-sqlite2');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kpovmodeler');
+INSERT INTO mime_type (mime_type) VALUES('application/illustrator');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-snf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gedcom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kexiproject-shortcut');
+INSERT INTO mime_type (mime_type) VALUES('application/andrew-inset');
+INSERT INTO mime_type (mime_type) VALUES('application/x-bzdvi');
+INSERT INTO mime_type (mime_type) VALUES('application/x-siag');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ktheme');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kspread');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cbr');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cmakecache');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-framemaker');
+INSERT INTO mime_type (mime_type) VALUES('application/x-msx-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-vfont');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-ttx');
+INSERT INTO mime_type (mime_type) VALUES('application/x-uml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cdrdao-toc');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kpresenter');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kseg');
+INSERT INTO mime_type (mime_type) VALUES('application/x-dvi');
+INSERT INTO mime_type (mime_type) VALUES('application/x-java-applet');
+INSERT INTO mime_type (mime_type) VALUES('application/x-palm-database');
+INSERT INTO mime_type (mime_type) VALUES('application/pgp-encrypted');
+INSERT INTO mime_type (mime_type) VALUES('application/x-pocket-word');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kmplot');
+INSERT INTO mime_type (mime_type) VALUES('application/x-core');
+INSERT INTO mime_type (mime_type) VALUES('application/x-profile');
+INSERT INTO mime_type (mime_type) VALUES('application/x-mswinurl');
+INSERT INTO mime_type (mime_type) VALUES('application/x-lha');
+INSERT INTO mime_type (mime_type) VALUES('application/x-netcdf');
+INSERT INTO mime_type (mime_type) VALUES('application/msword');
+INSERT INTO mime_type (mime_type) VALUES('application/x-dar');
+INSERT INTO mime_type (mime_type) VALUES('application/pgp-signature');
+INSERT INTO mime_type (mime_type) VALUES('application/x-dmod');
+INSERT INTO mime_type (mime_type) VALUES('application/x-fictionbook+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gettext-translation');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ace');
+INSERT INTO mime_type (mime_type) VALUES('application/x-macbinary');
+INSERT INTO mime_type (mime_type) VALUES('application/x-nintendo-ds-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-troff-man-compressed');
+INSERT INTO mime_type (mime_type) VALUES('application/x-java');
+INSERT INTO mime_type (mime_type) VALUES('application/x-mimearchive');
+INSERT INTO mime_type (mime_type) VALUES('application/xml-dtd');
+INSERT INTO mime_type (mime_type) VALUES('application/x-smaf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-pw');
+INSERT INTO mime_type (mime_type) VALUES('application/x-lhz');
+INSERT INTO mime_type (mime_type) VALUES('application/x-dia-diagram');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kugar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-sv4cpio');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kcachegrind');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gnumeric');
+INSERT INTO mime_type (mime_type) VALUES('application/x-fluid');
+INSERT INTO mime_type (mime_type) VALUES('application/x-quattropro');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gzip');
+INSERT INTO mime_type (mime_type) VALUES('application/x-shared-library-la');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gba-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-sc');
+INSERT INTO mime_type (mime_type) VALUES('application/x-glade');
+INSERT INTO mime_type (mime_type) VALUES('application/x-catalog');
+INSERT INTO mime_type (mime_type) VALUES('application/x-php');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kexiproject-sqlite3');
+INSERT INTO mime_type (mime_type) VALUES('application/x-asp');
+INSERT INTO mime_type (mime_type) VALUES('application/x-sqlite2');
+INSERT INTO mime_type (mime_type) VALUES('application/x-tzo');
+INSERT INTO mime_type (mime_type) VALUES('application/x-wais-source');
+INSERT INTO mime_type (mime_type) VALUES('application/x-jbuilder-project');
+INSERT INTO mime_type (mime_type) VALUES('application/x-package-list');
+INSERT INTO mime_type (mime_type) VALUES('application/annodex');
+INSERT INTO mime_type (mime_type) VALUES('application/x-toutdoux');
+INSERT INTO mime_type (mime_type) VALUES('application/x-stuffit');
+INSERT INTO mime_type (mime_type) VALUES('application/pkcs10');
+INSERT INTO mime_type (mime_type) VALUES('application/x-sv4crc');
+INSERT INTO mime_type (mime_type) VALUES('application/x-java-keystore');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kommander');
+INSERT INTO mime_type (mime_type) VALUES('application/x-sami');
+INSERT INTO mime_type (mime_type) VALUES('application/xspf+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-killustrator');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kgetlist');
+INSERT INTO mime_type (mime_type) VALUES('application/x-hdf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-mobipocket-ebook');
+INSERT INTO mime_type (mime_type) VALUES('application/x-shellscript');
+INSERT INTO mime_type (mime_type) VALUES('application/xhtml+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-compressed-tar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-nzb');
+INSERT INTO mime_type (mime_type) VALUES('application/x-markaby');
+INSERT INTO mime_type (mime_type) VALUES('application/x-sms-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/rtf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-tuberling');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kgeo');
+INSERT INTO mime_type (mime_type) VALUES('application/x-n64-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-smb-server');
+INSERT INTO mime_type (mime_type) VALUES('application/pkix-crl');
+INSERT INTO mime_type (mime_type) VALUES('application/x-dbf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-webarchive');
+INSERT INTO mime_type (mime_type) VALUES('application/x-smb-workgroup');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gnome-theme-package');
+INSERT INTO mime_type (mime_type) VALUES('application/epub+zip');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kchart');
+INSERT INTO mime_type (mime_type) VALUES('application/x-aportisdoc');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cisco-vpn-settings');
+INSERT INTO mime_type (mime_type) VALUES('application/x-egon');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kword');
+INSERT INTO mime_type (mime_type) VALUES('application/x-xbel');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-type1');
+INSERT INTO mime_type (mime_type) VALUES('application/x-lzip');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gdbm');
+INSERT INTO mime_type (mime_type) VALUES('application/x-executable');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-linux-psf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-tex-tfm');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-afm');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kcsrc');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kontour');
+INSERT INTO mime_type (mime_type) VALUES('application/x-msi');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cd-image');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-libgrx');
+INSERT INTO mime_type (mime_type) VALUES('application/x-designer');
+INSERT INTO mime_type (mime_type) VALUES('application/x-nautilus-link');
+INSERT INTO mime_type (mime_type) VALUES('application/x-zerosize');
+INSERT INTO mime_type (mime_type) VALUES('application/x-superkaramba');
+INSERT INTO mime_type (mime_type) VALUES('application/x-quanta');
+INSERT INTO mime_type (mime_type) VALUES('application/ram');
+INSERT INTO mime_type (mime_type) VALUES('application/javascript');
+INSERT INTO mime_type (mime_type) VALUES('application/rdf+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-spss-por');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gnuplot');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kformula');
+INSERT INTO mime_type (mime_type) VALUES('application/x-mif');
+INSERT INTO mime_type (mime_type) VALUES('application/x-amipro');
+INSERT INTO mime_type (mime_type) VALUES('application/x-slp');
+INSERT INTO mime_type (mime_type) VALUES('application/x-audacity-project');
+INSERT INTO mime_type (mime_type) VALUES('application/x-archive');
+INSERT INTO mime_type (mime_type) VALUES('application/x-windows-themepack');
+INSERT INTO mime_type (mime_type) VALUES('application/x-t602');
+INSERT INTO mime_type (mime_type) VALUES('application/x-mswrite');
+INSERT INTO mime_type (mime_type) VALUES('application/dicom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gzdvi');
+INSERT INTO mime_type (mime_type) VALUES('application/x-chm');
+INSERT INTO mime_type (mime_type) VALUES('application/x-lzma-compressed-tar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-7z-compressed');
+INSERT INTO mime_type (mime_type) VALUES('application/postscript');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gtktalog');
+INSERT INTO mime_type (mime_type) VALUES('application/x-alz');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ustar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-troff-man');
+INSERT INTO mime_type (mime_type) VALUES('application/xml');
+INSERT INTO mime_type (mime_type) VALUES('application/sieve');
+INSERT INTO mime_type (mime_type) VALUES('application/x-konsole');
+INSERT INTO mime_type (mime_type) VALUES('application/x-dc-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/xsd');
+INSERT INTO mime_type (mime_type) VALUES('application/pkcs7-mime');
+INSERT INTO mime_type (mime_type) VALUES('application/x-xz');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cda');
+INSERT INTO mime_type (mime_type) VALUES('application/x-abicollab');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cpio');
+INSERT INTO mime_type (mime_type) VALUES('application/x-tgif');
+INSERT INTO mime_type (mime_type) VALUES('application/x-class-file');
+INSERT INTO mime_type (mime_type) VALUES('application/x-desktop');
+INSERT INTO mime_type (mime_type) VALUES('application/x-reject');
+INSERT INTO mime_type (mime_type) VALUES('application/x-xz-compressed-tar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kivio');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kopete-emoticons');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kexi-connectiondata');
+INSERT INTO mime_type (mime_type) VALUES('application/x-compress');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gmc-link');
+INSERT INTO mime_type (mime_type) VALUES('application/x-krita');
+INSERT INTO mime_type (mime_type) VALUES('application/x-java-archive');
+INSERT INTO mime_type (mime_type) VALUES('application/x-theme');
+INSERT INTO mime_type (mime_type) VALUES('application/x-deb');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gnucash');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cabri');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-otf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kexiproject-sqlite');
+INSERT INTO mime_type (mime_type) VALUES('application/x-lzma');
+INSERT INTO mime_type (mime_type) VALUES('application/rss+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-khtml-adaptor');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gzpostscript');
+INSERT INTO mime_type (mime_type) VALUES('application/x-bzip');
+INSERT INTO mime_type (mime_type) VALUES('application/mathml+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-chess-pgn');
+INSERT INTO mime_type (mime_type) VALUES('application/x-remote-connection');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gameboy-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/pkix-pkipath');
+INSERT INTO mime_type (mime_type) VALUES('application/x-shorten');
+INSERT INTO mime_type (mime_type) VALUES('application/x-snes-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-quicktime-media-link');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ruby');
+INSERT INTO mime_type (mime_type) VALUES('application/x-tarz');
+INSERT INTO mime_type (mime_type) VALUES('application/ogg');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ole-storage');
+INSERT INTO mime_type (mime_type) VALUES('application/x-shar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ksysv-package');
+INSERT INTO mime_type (mime_type) VALUES('application/x-x509-ca-cert');
+INSERT INTO mime_type (mime_type) VALUES('application/x-par2');
+INSERT INTO mime_type (mime_type) VALUES('application/x-linguist');
+INSERT INTO mime_type (mime_type) VALUES('application/x-trig');
+INSERT INTO mime_type (mime_type) VALUES('application/mac-binhex40');
+INSERT INTO mime_type (mime_type) VALUES('application/x-qw');
+INSERT INTO mime_type (mime_type) VALUES('application/xml-external-parsed-entity');
+INSERT INTO mime_type (mime_type) VALUES('application/octet-stream');
+INSERT INTO mime_type (mime_type) VALUES('application/x-matroska');
+INSERT INTO mime_type (mime_type) VALUES('application/x-applix-spreadsheet');
+INSERT INTO mime_type (mime_type) VALUES('application/x-plasma');
+INSERT INTO mime_type (mime_type) VALUES('application/x-e-theme');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cbz');
+INSERT INTO mime_type (mime_type) VALUES('application/x-java-jnlp-file');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kns');
+INSERT INTO mime_type (mime_type) VALUES('application/x-win-lnk');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ufraw');
+INSERT INTO mime_type (mime_type) VALUES('application/x-drgeo');
+INSERT INTO mime_type (mime_type) VALUES('application/x-perl');
+INSERT INTO mime_type (mime_type) VALUES('application/pkcs7-signature');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ms-dos-executable');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-tex');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kolf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-planperfect');
+INSERT INTO mime_type (mime_type) VALUES('application/x-go-sgf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kwallet');
+INSERT INTO mime_type (mime_type) VALUES('application/x-rpm');
+INSERT INTO mime_type (mime_type) VALUES('application/sdp');
+INSERT INTO mime_type (mime_type) VALUES('application/x-java-pack200');
+INSERT INTO mime_type (mime_type) VALUES('application/relaxng');
+INSERT INTO mime_type (mime_type) VALUES('application/x-servicepack');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-bdf');
+INSERT INTO mime_type (mime_type) VALUES('application/pkix-cert');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ipod-firmware');
+INSERT INTO mime_type (mime_type) VALUES('application/x-object');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ica');
+INSERT INTO mime_type (mime_type) VALUES('application/x-it87');
+INSERT INTO mime_type (mime_type) VALUES('application/x-zoo');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gzpdf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-magicpoint');
+INSERT INTO mime_type (mime_type) VALUES('application/docbook+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-csh');
+INSERT INTO mime_type (mime_type) VALUES('application/x-nes-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-graphite');
+INSERT INTO mime_type (mime_type) VALUES('application/x-spss-sav');
+INSERT INTO mime_type (mime_type) VALUES('application/x-tar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kvtml');
+INSERT INTO mime_type (mime_type) VALUES('application/metalink+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/ecmascript');
+INSERT INTO mime_type (mime_type) VALUES('application/x-hwt');
+INSERT INTO mime_type (mime_type) VALUES('application/x-pak');
+INSERT INTO mime_type (mime_type) VALUES('application/x-sqlite3');
+INSERT INTO mime_type (mime_type) VALUES('application/x-trash');
+INSERT INTO mime_type (mime_type) VALUES('application/x-arj');
+INSERT INTO mime_type (mime_type) VALUES('application/x-k3b');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-pcf');
+INSERT INTO mime_type (mime_type) VALUES('application/oda');
+INSERT INTO mime_type (mime_type) VALUES('application/x-genesis-rom');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-ttf');
+INSERT INTO mime_type (mime_type) VALUES('application/zip');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cbt');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kspread-crypt');
+INSERT INTO mime_type (mime_type) VALUES('application/x-pef-executable');
+INSERT INTO mime_type (mime_type) VALUES('application/x-brasero');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cb7');
+INSERT INTO mime_type (mime_type) VALUES('application/x-frame');
+INSERT INTO mime_type (mime_type) VALUES('application/x-lyx');
+INSERT INTO mime_type (mime_type) VALUES('application/x-lzop');
+INSERT INTO mime_type (mime_type) VALUES('application/x-planner');
+INSERT INTO mime_type (mime_type) VALUES('application/x-vnc');
+INSERT INTO mime_type (mime_type) VALUES('application/atom+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gz-font-linux-psf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-xliff');
+INSERT INTO mime_type (mime_type) VALUES('application/mathematica');
+INSERT INTO mime_type (mime_type) VALUES('application/xslt+xml');
+INSERT INTO mime_type (mime_type) VALUES('application/x-sharedlib');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kwordquiz');
+INSERT INTO mime_type (mime_type) VALUES('application/x-bzpostscript');
+INSERT INTO mime_type (mime_type) VALUES('application/x-pkcs12');
+INSERT INTO mime_type (mime_type) VALUES('application/x-mozilla-bookmarks');
+INSERT INTO mime_type (mime_type) VALUES('application/x-awk');
+INSERT INTO mime_type (mime_type) VALUES('application/x-navi-animation');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cpio-compressed');
+INSERT INTO mime_type (mime_type) VALUES('application/x-arc');
+INSERT INTO mime_type (mime_type) VALUES('application/x-icq');
+INSERT INTO mime_type (mime_type) VALUES('application/x-bzpdf');
+INSERT INTO mime_type (mime_type) VALUES('application/mbox');
+INSERT INTO mime_type (mime_type) VALUES('application/x-ksysguard');
+INSERT INTO mime_type (mime_type) VALUES('application/x-java-jce-keystore');
+INSERT INTO mime_type (mime_type) VALUES('application/x-subrip');
+INSERT INTO mime_type (mime_type) VALUES('application/x-karbon');
+INSERT INTO mime_type (mime_type) VALUES('application/x-python-bytecode');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-dos');
+INSERT INTO mime_type (mime_type) VALUES('application/pgp-keys');
+INSERT INTO mime_type (mime_type) VALUES('application/x-font-speedo');
+INSERT INTO mime_type (mime_type) VALUES('application/pdf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-cue');
+INSERT INTO mime_type (mime_type) VALUES('application/x-gnome-saved-search');
+INSERT INTO mime_type (mime_type) VALUES('application/x-bcpio');
+INSERT INTO mime_type (mime_type) VALUES('application/x-applix-word');
+INSERT INTO mime_type (mime_type) VALUES('application/mxf');
+INSERT INTO mime_type (mime_type) VALUES('application/x-wpg');
+INSERT INTO mime_type (mime_type) VALUES('application/x-bzip-compressed-tar');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kword-crypt');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kig');
+INSERT INTO mime_type (mime_type) VALUES('application/gnunet-directory');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kourse');
+INSERT INTO mime_type (mime_type) VALUES('application/x-kudesigner');
+INSERT INTO mime_type (mime_type) VALUES('application/x-tex-pk');
+INSERT INTO mime_type (mime_type) VALUES('video/x-ms-asf');
+INSERT INTO mime_type (mime_type) VALUES('video/mp4');
+INSERT INTO mime_type (mime_type) VALUES('video/mpeg');
+INSERT INTO mime_type (mime_type) VALUES('video/annodex');
+INSERT INTO mime_type (mime_type) VALUES('video/x-sgi-movie');
+INSERT INTO mime_type (mime_type) VALUES('video/isivideo');
+INSERT INTO mime_type (mime_type) VALUES('video/x-ogm+ogg');
+INSERT INTO mime_type (mime_type) VALUES('video/x-mng');
+INSERT INTO mime_type (mime_type) VALUES('video/x-flv');
+INSERT INTO mime_type (mime_type) VALUES('video/x-flic');
+INSERT INTO mime_type (mime_type) VALUES('video/x-theora+ogg');
+INSERT INTO mime_type (mime_type) VALUES('video/3gpp');
+INSERT INTO mime_type (mime_type) VALUES('video/x-ms-wmv');
+INSERT INTO mime_type (mime_type) VALUES('video/ogg');
+INSERT INTO mime_type (mime_type) VALUES('video/dv');
+INSERT INTO mime_type (mime_type) VALUES('video/x-matroska');
+INSERT INTO mime_type (mime_type) VALUES('video/vivo');
+INSERT INTO mime_type (mime_type) VALUES('video/quicktime');
+INSERT INTO mime_type (mime_type) VALUES('video/x-ms-wmp');
+INSERT INTO mime_type (mime_type) VALUES('video/x-msvideo');
+INSERT INTO mime_type (mime_type) VALUES('video/x-anim');
+INSERT INTO mime_type (mime_type) VALUES('video/wavelet');
+INSERT INTO mime_type (mime_type) VALUES('video/x-nsv');
+INSERT INTO mime_type (mime_type) VALUES('interface/x-winamp-skin');
+INSERT INTO mime_type (mime_type) VALUES('multipart/encrypted');
+INSERT INTO mime_type (mime_type) VALUES('multipart/x-mixed-replace');
+INSERT INTO mime_type (mime_type) VALUES('multipart/related');
+INSERT INTO mime_type (mime_type) VALUES('multipart/report');
+INSERT INTO mime_type (mime_type) VALUES('multipart/signed');
+INSERT INTO mime_type (mime_type) VALUES('multipart/appledouble');
+INSERT INTO mime_type (mime_type) VALUES('multipart/mixed');
+INSERT INTO mime_type (mime_type) VALUES('multipart/alternative');
+INSERT INTO mime_type (mime_type) VALUES('multipart/digest');
+
CREATE TABLE file_class (
id serial not null unique,
class text primary key
Added: trunk/tools/extract_mimes.sh
===================================================================
--- trunk/tools/extract_mimes.sh (rev 0)
+++ trunk/tools/extract_mimes.sh 2011-07-28 00:46:32 UTC (rev 3585)
@@ -0,0 +1,16 @@
+#!/bin/bash
+
+# Searches /usr/share/mime for freedesktop.xml files and builds a list of sql
+# statements for populating the mime_types table. People can occasionally
+# rename the table and rebuild it in order to check for new entries that need
+# to be added.
+
+# This is a build tool, not suited for general administration of the software.
+# --CT
+
+find /usr/share/mime -name '*.xml' \
+ | grep -v packages \
+ | grep -v template \
+ | grep -v 'vnd.' \
+ | grep -v 'inode' \
+ | sed -e "s#/usr/share/mime/\(.*\).xml#INSERT INTO mime_type (mime_type) VALUES(\'\1\')\;#"
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.