Rev 58 | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed
drop table if exists file;
create table file (
file_id int unsigned not null auto_increment,
name varchar(64) comment 'the visible, displayed name',
owner_type char default 'd' comment 'determines if the owner is from the client, site or device table',
owner_id int unsigned not null comment 'the client_id, site_id or device_id of the owner',
description text comment 'A brief (or long) description of this file',
file_mime_type_id int unsigned default null references file_mime_type (file_mime_type_id),
name_on_disk varchar(128) comment 'link to a file on the disk',
added_date date comment 'date record was added',
removed_date date comment 'date record was deleted/supserceded',
primary key (file_id)
) comment 'Stores files for clients, sites, devices and networks';
drop table if exists file_mime_type;
create table file_mime_type (
file_mime_type_id int unsigned not null auto_increment,
mime_type varchar(64) comment 'The standardized mime type',
extension varchar(10) comment 'a file name extension commonly associated with this file',
primary key (file_mime_type_id)
) comment 'Just a list of some common mime types';
insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'Files', 'modules/file/', now() );
/* location on disk where actual files will be stored */
insert into _system ( group_name,key_name,theValue,added_date) values ( 'Files', 'root path', 'modules/file/file_storage', now() );
/* keep track of the indexes used for storing file names */
insert into _system (group_name,key_name,theValue, added_date) values ( 'Files', 'last index', '0', now() );
/* set up some callable functions */
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Files', 'callable.php:filesView', now() );
insert into _system( group_name,key_name,theValue,added_date ) values ( 'site view', 'Files', 'callable.php:filesView', now() );
insert into _system( group_name,key_name,theValue,added_date ) values ( 'client view', 'Files', 'callable.php:filesView', now() );
create or replace view client_files as select * from file where owner_type = 'c';
create or replace view site_files as select * from file where owner_type = 's';
create or replace view device_files as select * from file where owner_type = 'd';
/* Menu Options */
insert into menu( url, caption, parent_id) values ( null, 'Files', null);
insert into menu( url,caption,parent_id) select '/modules/file/upload_file.html','Add A File',menu_id from menu where caption = 'Files';
insert into menu( url,caption,parent_id) select '/modules/file/view_file.html','View A File',menu_id from menu where caption = 'Files';
/* Reports */
/* a list of well known mime types */
insert into file_mime_type(extension,mime_type) values ('sql','application/sql');
insert into file_mime_type(extension,mime_type) values ('csv','text/csv');
insert into file_mime_type(extension,mime_type) values ('3dm','x-world/x-3dmf');
insert into file_mime_type(extension,mime_type) values ('3dmf','x-world/x-3dmf');
insert into file_mime_type(extension,mime_type) values ('a','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('aab','application/x-authorware-bin');
insert into file_mime_type(extension,mime_type) values ('aam','application/x-authorware-map');
insert into file_mime_type(extension,mime_type) values ('aas','application/x-authorware-seg');
insert into file_mime_type(extension,mime_type) values ('abc','text/vnd.abc');
insert into file_mime_type(extension,mime_type) values ('acgi','text/html');
insert into file_mime_type(extension,mime_type) values ('afl','video/animaflex');
insert into file_mime_type(extension,mime_type) values ('ai','application/postscript');
insert into file_mime_type(extension,mime_type) values ('aif','audio/aiff');
insert into file_mime_type(extension,mime_type) values ('aif','audio/x-aiff');
insert into file_mime_type(extension,mime_type) values ('aifc','audio/aiff');
insert into file_mime_type(extension,mime_type) values ('aifc','audio/x-aiff');
insert into file_mime_type(extension,mime_type) values ('aiff','audio/aiff');
insert into file_mime_type(extension,mime_type) values ('aiff','audio/x-aiff');
insert into file_mime_type(extension,mime_type) values ('aim','application/x-aim');
insert into file_mime_type(extension,mime_type) values ('aip','text/x-audiosoft-intra');
insert into file_mime_type(extension,mime_type) values ('ani','application/x-navi-animation');
insert into file_mime_type(extension,mime_type) values ('aos','application/x-nokia-9000-communicator-add-on-software');
insert into file_mime_type(extension,mime_type) values ('aps','application/mime');
insert into file_mime_type(extension,mime_type) values ('arc','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('arj','application/arj');
insert into file_mime_type(extension,mime_type) values ('arj','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('art','image/x-jg');
insert into file_mime_type(extension,mime_type) values ('asf','video/x-ms-asf');
insert into file_mime_type(extension,mime_type) values ('asm','text/x-asm');
insert into file_mime_type(extension,mime_type) values ('asp','text/asp');
insert into file_mime_type(extension,mime_type) values ('asx','application/x-mplayer2');
insert into file_mime_type(extension,mime_type) values ('asx','video/x-ms-asf');
insert into file_mime_type(extension,mime_type) values ('asx','video/x-ms-asf-plugin');
insert into file_mime_type(extension,mime_type) values ('au','audio/basic');
insert into file_mime_type(extension,mime_type) values ('au','audio/x-au');
insert into file_mime_type(extension,mime_type) values ('avi','application/x-troff-msvideo');
insert into file_mime_type(extension,mime_type) values ('avi','video/avi');
insert into file_mime_type(extension,mime_type) values ('avi','video/msvideo');
insert into file_mime_type(extension,mime_type) values ('avi','video/x-msvideo');
insert into file_mime_type(extension,mime_type) values ('avs','video/avs-video');
insert into file_mime_type(extension,mime_type) values ('bcpio','application/x-bcpio');
insert into file_mime_type(extension,mime_type) values ('bin','application/mac-binary');
insert into file_mime_type(extension,mime_type) values ('bin','application/macbinary');
insert into file_mime_type(extension,mime_type) values ('bin','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('bin','application/x-binary');
insert into file_mime_type(extension,mime_type) values ('bin','application/x-macbinary');
insert into file_mime_type(extension,mime_type) values ('bm','image/bmp');
insert into file_mime_type(extension,mime_type) values ('bmp','image/bmp');
insert into file_mime_type(extension,mime_type) values ('bmp','image/x-windows-bmp');
insert into file_mime_type(extension,mime_type) values ('boo','application/book');
insert into file_mime_type(extension,mime_type) values ('book','application/book');
insert into file_mime_type(extension,mime_type) values ('boz','application/x-bzip2');
insert into file_mime_type(extension,mime_type) values ('bsh','application/x-bsh');
insert into file_mime_type(extension,mime_type) values ('bz','application/x-bzip');
insert into file_mime_type(extension,mime_type) values ('bz2','application/x-bzip2');
insert into file_mime_type(extension,mime_type) values ('c','text/plain');
insert into file_mime_type(extension,mime_type) values ('c','text/x-c');
insert into file_mime_type(extension,mime_type) values ('c++','text/plain');
insert into file_mime_type(extension,mime_type) values ('cat','application/vnd.ms-pki.seccat');
insert into file_mime_type(extension,mime_type) values ('cc','text/plain');
insert into file_mime_type(extension,mime_type) values ('cc','text/x-c');
insert into file_mime_type(extension,mime_type) values ('ccad','application/clariscad');
insert into file_mime_type(extension,mime_type) values ('cco','application/x-cocoa');
insert into file_mime_type(extension,mime_type) values ('cdf','application/cdf');
insert into file_mime_type(extension,mime_type) values ('cdf','application/x-cdf');
insert into file_mime_type(extension,mime_type) values ('cdf','application/x-netcdf');
insert into file_mime_type(extension,mime_type) values ('cer','application/pkix-cert');
insert into file_mime_type(extension,mime_type) values ('cer','application/x-x509-ca-cert');
insert into file_mime_type(extension,mime_type) values ('cha','application/x-chat');
insert into file_mime_type(extension,mime_type) values ('chat','application/x-chat');
insert into file_mime_type(extension,mime_type) values ('class','application/java');
insert into file_mime_type(extension,mime_type) values ('class','application/java-byte-code');
insert into file_mime_type(extension,mime_type) values ('class','application/x-java-class');
insert into file_mime_type(extension,mime_type) values ('com','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('com','text/plain');
insert into file_mime_type(extension,mime_type) values ('conf','text/plain');
insert into file_mime_type(extension,mime_type) values ('cpio','application/x-cpio');
insert into file_mime_type(extension,mime_type) values ('cpp','text/x-c');
insert into file_mime_type(extension,mime_type) values ('cpt','application/mac-compactpro');
insert into file_mime_type(extension,mime_type) values ('cpt','application/x-compactpro');
insert into file_mime_type(extension,mime_type) values ('cpt','application/x-cpt');
insert into file_mime_type(extension,mime_type) values ('crl','application/pkcs-crl');
insert into file_mime_type(extension,mime_type) values ('crl','application/pkix-crl');
insert into file_mime_type(extension,mime_type) values ('crt','application/pkix-cert');
insert into file_mime_type(extension,mime_type) values ('crt','application/x-x509-ca-cert');
insert into file_mime_type(extension,mime_type) values ('crt','application/x-x509-user-cert');
insert into file_mime_type(extension,mime_type) values ('csh','application/x-csh');
insert into file_mime_type(extension,mime_type) values ('csh','text/x-script.csh');
insert into file_mime_type(extension,mime_type) values ('css','application/x-pointplus');
insert into file_mime_type(extension,mime_type) values ('css','text/css');
insert into file_mime_type(extension,mime_type) values ('cxx','text/plain');
insert into file_mime_type(extension,mime_type) values ('dcr','application/x-director');
insert into file_mime_type(extension,mime_type) values ('deepv','application/x-deepv');
insert into file_mime_type(extension,mime_type) values ('def','text/plain');
insert into file_mime_type(extension,mime_type) values ('der','application/x-x509-ca-cert');
insert into file_mime_type(extension,mime_type) values ('dif','video/x-dv');
insert into file_mime_type(extension,mime_type) values ('dir','application/x-director');
insert into file_mime_type(extension,mime_type) values ('dl','video/dl');
insert into file_mime_type(extension,mime_type) values ('dl','video/x-dl');
insert into file_mime_type(extension,mime_type) values ('doc','application/msword');
insert into file_mime_type(extension,mime_type) values ('dot','application/msword');
insert into file_mime_type(extension,mime_type) values ('dp','application/commonground');
insert into file_mime_type(extension,mime_type) values ('drw','application/drafting');
insert into file_mime_type(extension,mime_type) values ('dump','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('dv','video/x-dv');
insert into file_mime_type(extension,mime_type) values ('dvi','application/x-dvi');
insert into file_mime_type(extension,mime_type) values ('dwf','drawing/x-dwf (old)');
insert into file_mime_type(extension,mime_type) values ('dwf','model/vnd.dwf');
insert into file_mime_type(extension,mime_type) values ('dwg','application/acad');
insert into file_mime_type(extension,mime_type) values ('dwg','image/vnd.dwg');
insert into file_mime_type(extension,mime_type) values ('dwg','image/x-dwg');
insert into file_mime_type(extension,mime_type) values ('dxf','application/dxf');
insert into file_mime_type(extension,mime_type) values ('dxf','image/vnd.dwg');
insert into file_mime_type(extension,mime_type) values ('dxf','image/x-dwg');
insert into file_mime_type(extension,mime_type) values ('dxr','application/x-director');
insert into file_mime_type(extension,mime_type) values ('el','text/x-script.elisp');
insert into file_mime_type(extension,mime_type) values ('elc','application/x-bytecode.elisp (compiled elisp)');
insert into file_mime_type(extension,mime_type) values ('elc','application/x-elc');
insert into file_mime_type(extension,mime_type) values ('env','application/x-envoy');
insert into file_mime_type(extension,mime_type) values ('eps','application/postscript');
insert into file_mime_type(extension,mime_type) values ('es','application/x-esrehber');
insert into file_mime_type(extension,mime_type) values ('etx','text/x-setext');
insert into file_mime_type(extension,mime_type) values ('evy','application/envoy');
insert into file_mime_type(extension,mime_type) values ('evy','application/x-envoy');
insert into file_mime_type(extension,mime_type) values ('exe','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('f','text/plain');
insert into file_mime_type(extension,mime_type) values ('f','text/x-fortran');
insert into file_mime_type(extension,mime_type) values ('f77','text/x-fortran');
insert into file_mime_type(extension,mime_type) values ('f90','text/plain');
insert into file_mime_type(extension,mime_type) values ('f90','text/x-fortran');
insert into file_mime_type(extension,mime_type) values ('fdf','application/vnd.fdf');
insert into file_mime_type(extension,mime_type) values ('fif','application/fractals');
insert into file_mime_type(extension,mime_type) values ('fif','image/fif');
insert into file_mime_type(extension,mime_type) values ('fli','video/fli');
insert into file_mime_type(extension,mime_type) values ('fli','video/x-fli');
insert into file_mime_type(extension,mime_type) values ('flo','image/florian');
insert into file_mime_type(extension,mime_type) values ('flx','text/vnd.fmi.flexstor');
insert into file_mime_type(extension,mime_type) values ('fmf','video/x-atomic3d-feature');
insert into file_mime_type(extension,mime_type) values ('for','text/plain');
insert into file_mime_type(extension,mime_type) values ('for','text/x-fortran');
insert into file_mime_type(extension,mime_type) values ('fpx','image/vnd.fpx');
insert into file_mime_type(extension,mime_type) values ('fpx','image/vnd.net-fpx');
insert into file_mime_type(extension,mime_type) values ('frl','application/freeloader');
insert into file_mime_type(extension,mime_type) values ('funk','audio/make');
insert into file_mime_type(extension,mime_type) values ('g','text/plain');
insert into file_mime_type(extension,mime_type) values ('g3','image/g3fax');
insert into file_mime_type(extension,mime_type) values ('gif','image/gif');
insert into file_mime_type(extension,mime_type) values ('gl','video/gl');
insert into file_mime_type(extension,mime_type) values ('gl','video/x-gl');
insert into file_mime_type(extension,mime_type) values ('gsd','audio/x-gsm');
insert into file_mime_type(extension,mime_type) values ('gsm','audio/x-gsm');
insert into file_mime_type(extension,mime_type) values ('gsp','application/x-gsp');
insert into file_mime_type(extension,mime_type) values ('gss','application/x-gss');
insert into file_mime_type(extension,mime_type) values ('gtar','application/x-gtar');
insert into file_mime_type(extension,mime_type) values ('gz','application/x-compressed');
insert into file_mime_type(extension,mime_type) values ('gz','application/x-gzip');
insert into file_mime_type(extension,mime_type) values ('gzip','application/x-gzip');
insert into file_mime_type(extension,mime_type) values ('gzip','multipart/x-gzip');
insert into file_mime_type(extension,mime_type) values ('h','text/plain');
insert into file_mime_type(extension,mime_type) values ('h','text/x-h');
insert into file_mime_type(extension,mime_type) values ('hdf','application/x-hdf');
insert into file_mime_type(extension,mime_type) values ('help','application/x-helpfile');
insert into file_mime_type(extension,mime_type) values ('hgl','application/vnd.hp-hpgl');
insert into file_mime_type(extension,mime_type) values ('hh','text/plain');
insert into file_mime_type(extension,mime_type) values ('hh','text/x-h');
insert into file_mime_type(extension,mime_type) values ('hlb','text/x-script');
insert into file_mime_type(extension,mime_type) values ('hlp','application/hlp');
insert into file_mime_type(extension,mime_type) values ('hlp','application/x-helpfile');
insert into file_mime_type(extension,mime_type) values ('hlp','application/x-winhelp');
insert into file_mime_type(extension,mime_type) values ('hpg','application/vnd.hp-hpgl');
insert into file_mime_type(extension,mime_type) values ('hpgl','application/vnd.hp-hpgl');
insert into file_mime_type(extension,mime_type) values ('hqx','application/binhex');
insert into file_mime_type(extension,mime_type) values ('hqx','application/binhex4');
insert into file_mime_type(extension,mime_type) values ('hqx','application/mac-binhex');
insert into file_mime_type(extension,mime_type) values ('hqx','application/mac-binhex40');
insert into file_mime_type(extension,mime_type) values ('hqx','application/x-binhex40');
insert into file_mime_type(extension,mime_type) values ('hqx','application/x-mac-binhex40');
insert into file_mime_type(extension,mime_type) values ('hta','application/hta');
insert into file_mime_type(extension,mime_type) values ('htc','text/x-component');
insert into file_mime_type(extension,mime_type) values ('htm','text/html');
insert into file_mime_type(extension,mime_type) values ('html','text/html');
insert into file_mime_type(extension,mime_type) values ('htmls','text/html');
insert into file_mime_type(extension,mime_type) values ('htt','text/webviewhtml');
insert into file_mime_type(extension,mime_type) values ('htx','text/html');
insert into file_mime_type(extension,mime_type) values ('ice','x-conference/x-cooltalk');
insert into file_mime_type(extension,mime_type) values ('ico','image/x-icon');
insert into file_mime_type(extension,mime_type) values ('idc','text/plain');
insert into file_mime_type(extension,mime_type) values ('ief','image/ief');
insert into file_mime_type(extension,mime_type) values ('iefs','image/ief');
insert into file_mime_type(extension,mime_type) values ('iges','application/iges');
insert into file_mime_type(extension,mime_type) values ('iges','model/iges');
insert into file_mime_type(extension,mime_type) values ('igs','application/iges');
insert into file_mime_type(extension,mime_type) values ('igs','model/iges');
insert into file_mime_type(extension,mime_type) values ('ima','application/x-ima');
insert into file_mime_type(extension,mime_type) values ('imap','application/x-httpd-imap');
insert into file_mime_type(extension,mime_type) values ('inf','application/inf');
insert into file_mime_type(extension,mime_type) values ('ins','application/x-internett-signup');
insert into file_mime_type(extension,mime_type) values ('ip','application/x-ip2');
insert into file_mime_type(extension,mime_type) values ('isu','video/x-isvideo');
insert into file_mime_type(extension,mime_type) values ('it','audio/it');
insert into file_mime_type(extension,mime_type) values ('iv','application/x-inventor');
insert into file_mime_type(extension,mime_type) values ('ivr','i-world/i-vrml');
insert into file_mime_type(extension,mime_type) values ('ivy','application/x-livescreen');
insert into file_mime_type(extension,mime_type) values ('jam','audio/x-jam');
insert into file_mime_type(extension,mime_type) values ('jav','text/plain');
insert into file_mime_type(extension,mime_type) values ('jav','text/x-java-source');
insert into file_mime_type(extension,mime_type) values ('java','text/plain');
insert into file_mime_type(extension,mime_type) values ('java','text/x-java-source');
insert into file_mime_type(extension,mime_type) values ('jcm','application/x-java-commerce');
insert into file_mime_type(extension,mime_type) values ('jfif','image/jpeg');
insert into file_mime_type(extension,mime_type) values ('jfif','image/pjpeg');
insert into file_mime_type(extension,mime_type) values ('jfif-tbnl','image/jpeg');
insert into file_mime_type(extension,mime_type) values ('jpe','image/jpeg');
insert into file_mime_type(extension,mime_type) values ('jpe','image/pjpeg');
insert into file_mime_type(extension,mime_type) values ('jpeg','image/jpeg');
insert into file_mime_type(extension,mime_type) values ('jpeg','image/pjpeg');
insert into file_mime_type(extension,mime_type) values ('jpg','image/jpeg');
insert into file_mime_type(extension,mime_type) values ('jpg','image/pjpeg');
insert into file_mime_type(extension,mime_type) values ('jps','image/x-jps');
insert into file_mime_type(extension,mime_type) values ('js','application/x-javascript');
insert into file_mime_type(extension,mime_type) values ('jut','image/jutvision');
insert into file_mime_type(extension,mime_type) values ('kar','audio/midi');
insert into file_mime_type(extension,mime_type) values ('kar','music/x-karaoke');
insert into file_mime_type(extension,mime_type) values ('ksh','application/x-ksh');
insert into file_mime_type(extension,mime_type) values ('ksh','text/x-script.ksh');
insert into file_mime_type(extension,mime_type) values ('la','audio/nspaudio');
insert into file_mime_type(extension,mime_type) values ('la','audio/x-nspaudio');
insert into file_mime_type(extension,mime_type) values ('lam','audio/x-liveaudio');
insert into file_mime_type(extension,mime_type) values ('latex','application/x-latex');
insert into file_mime_type(extension,mime_type) values ('lha','application/lha');
insert into file_mime_type(extension,mime_type) values ('lha','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('lha','application/x-lha');
insert into file_mime_type(extension,mime_type) values ('lhx','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('list','text/plain');
insert into file_mime_type(extension,mime_type) values ('lma','audio/nspaudio');
insert into file_mime_type(extension,mime_type) values ('lma','audio/x-nspaudio');
insert into file_mime_type(extension,mime_type) values ('log','text/plain');
insert into file_mime_type(extension,mime_type) values ('lsp','application/x-lisp');
insert into file_mime_type(extension,mime_type) values ('lsp','text/x-script.lisp');
insert into file_mime_type(extension,mime_type) values ('lst','text/plain');
insert into file_mime_type(extension,mime_type) values ('lsx','text/x-la-asf');
insert into file_mime_type(extension,mime_type) values ('ltx','application/x-latex');
insert into file_mime_type(extension,mime_type) values ('lzh','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('lzh','application/x-lzh');
insert into file_mime_type(extension,mime_type) values ('lzx','application/lzx');
insert into file_mime_type(extension,mime_type) values ('lzx','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('lzx','application/x-lzx');
insert into file_mime_type(extension,mime_type) values ('m','text/plain');
insert into file_mime_type(extension,mime_type) values ('m','text/x-m');
insert into file_mime_type(extension,mime_type) values ('m1v','video/mpeg');
insert into file_mime_type(extension,mime_type) values ('m2a','audio/mpeg');
insert into file_mime_type(extension,mime_type) values ('m2v','video/mpeg');
insert into file_mime_type(extension,mime_type) values ('m3u','audio/x-mpequrl');
insert into file_mime_type(extension,mime_type) values ('man','application/x-troff-man');
insert into file_mime_type(extension,mime_type) values ('map','application/x-navimap');
insert into file_mime_type(extension,mime_type) values ('mar','text/plain');
insert into file_mime_type(extension,mime_type) values ('mbd','application/mbedlet');
insert into file_mime_type(extension,mime_type) values ('mc$','application/x-magic-cap-package-1.0');
insert into file_mime_type(extension,mime_type) values ('mcd','application/mcad');
insert into file_mime_type(extension,mime_type) values ('mcd','application/x-mathcad');
insert into file_mime_type(extension,mime_type) values ('mcf','image/vasa');
insert into file_mime_type(extension,mime_type) values ('mcf','text/mcf');
insert into file_mime_type(extension,mime_type) values ('mcp','application/netmc');
insert into file_mime_type(extension,mime_type) values ('me','application/x-troff-me');
insert into file_mime_type(extension,mime_type) values ('mht','message/rfc822');
insert into file_mime_type(extension,mime_type) values ('mhtml','message/rfc822');
insert into file_mime_type(extension,mime_type) values ('mid','application/x-midi');
insert into file_mime_type(extension,mime_type) values ('mid','audio/midi');
insert into file_mime_type(extension,mime_type) values ('mid','audio/x-mid');
insert into file_mime_type(extension,mime_type) values ('mid','audio/x-midi');
insert into file_mime_type(extension,mime_type) values ('mid','music/crescendo');
insert into file_mime_type(extension,mime_type) values ('mid','x-music/x-midi');
insert into file_mime_type(extension,mime_type) values ('midi','application/x-midi');
insert into file_mime_type(extension,mime_type) values ('midi','audio/midi');
insert into file_mime_type(extension,mime_type) values ('midi','audio/x-mid');
insert into file_mime_type(extension,mime_type) values ('midi','audio/x-midi');
insert into file_mime_type(extension,mime_type) values ('midi','music/crescendo');
insert into file_mime_type(extension,mime_type) values ('midi','x-music/x-midi');
insert into file_mime_type(extension,mime_type) values ('mif','application/x-frame');
insert into file_mime_type(extension,mime_type) values ('mif','application/x-mif');
insert into file_mime_type(extension,mime_type) values ('mime','message/rfc822');
insert into file_mime_type(extension,mime_type) values ('mime','www/mime');
insert into file_mime_type(extension,mime_type) values ('mjf','audio/x-vnd.audioexplosion.mjuicemediafile');
insert into file_mime_type(extension,mime_type) values ('mjpg','video/x-motion-jpeg');
insert into file_mime_type(extension,mime_type) values ('mm','application/base64');
insert into file_mime_type(extension,mime_type) values ('mm','application/x-meme');
insert into file_mime_type(extension,mime_type) values ('mme','application/base64');
insert into file_mime_type(extension,mime_type) values ('mod','audio/mod');
insert into file_mime_type(extension,mime_type) values ('mod','audio/x-mod');
insert into file_mime_type(extension,mime_type) values ('moov','video/quicktime');
insert into file_mime_type(extension,mime_type) values ('mov','video/quicktime');
insert into file_mime_type(extension,mime_type) values ('movie','video/x-sgi-movie');
insert into file_mime_type(extension,mime_type) values ('mp2','audio/mpeg');
insert into file_mime_type(extension,mime_type) values ('mp2','audio/x-mpeg');
insert into file_mime_type(extension,mime_type) values ('mp2','video/mpeg');
insert into file_mime_type(extension,mime_type) values ('mp2','video/x-mpeg');
insert into file_mime_type(extension,mime_type) values ('mp2','video/x-mpeq2a');
insert into file_mime_type(extension,mime_type) values ('mp3','audio/mpeg3');
insert into file_mime_type(extension,mime_type) values ('mp3','audio/x-mpeg-3');
insert into file_mime_type(extension,mime_type) values ('mp3','video/mpeg');
insert into file_mime_type(extension,mime_type) values ('mp3','video/x-mpeg');
insert into file_mime_type(extension,mime_type) values ('mpa','audio/mpeg');
insert into file_mime_type(extension,mime_type) values ('mpa','video/mpeg');
insert into file_mime_type(extension,mime_type) values ('mpc','application/x-project');
insert into file_mime_type(extension,mime_type) values ('mpe','video/mpeg');
insert into file_mime_type(extension,mime_type) values ('mpeg','video/mpeg');
insert into file_mime_type(extension,mime_type) values ('mpg','audio/mpeg');
insert into file_mime_type(extension,mime_type) values ('mpg','video/mpeg');
insert into file_mime_type(extension,mime_type) values ('mpga','audio/mpeg');
insert into file_mime_type(extension,mime_type) values ('mpp','application/vnd.ms-project');
insert into file_mime_type(extension,mime_type) values ('mpt','application/x-project');
insert into file_mime_type(extension,mime_type) values ('mpv','application/x-project');
insert into file_mime_type(extension,mime_type) values ('mpx','application/x-project');
insert into file_mime_type(extension,mime_type) values ('mrc','application/marc');
insert into file_mime_type(extension,mime_type) values ('ms','application/x-troff-ms');
insert into file_mime_type(extension,mime_type) values ('mv','video/x-sgi-movie');
insert into file_mime_type(extension,mime_type) values ('my','audio/make');
insert into file_mime_type(extension,mime_type) values ('mzz','application/x-vnd.audioexplosion.mzz');
insert into file_mime_type(extension,mime_type) values ('nap','image/naplps');
insert into file_mime_type(extension,mime_type) values ('naplps','image/naplps');
insert into file_mime_type(extension,mime_type) values ('nc','application/x-netcdf');
insert into file_mime_type(extension,mime_type) values ('ncm','application/vnd.nokia.configuration-message');
insert into file_mime_type(extension,mime_type) values ('nif','image/x-niff');
insert into file_mime_type(extension,mime_type) values ('niff','image/x-niff');
insert into file_mime_type(extension,mime_type) values ('nix','application/x-mix-transfer');
insert into file_mime_type(extension,mime_type) values ('nsc','application/x-conference');
insert into file_mime_type(extension,mime_type) values ('nvd','application/x-navidoc');
insert into file_mime_type(extension,mime_type) values ('o','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('oda','application/oda');
insert into file_mime_type(extension,mime_type) values ('omc','application/x-omc');
insert into file_mime_type(extension,mime_type) values ('omcd','application/x-omcdatamaker');
insert into file_mime_type(extension,mime_type) values ('omcr','application/x-omcregerator');
insert into file_mime_type(extension,mime_type) values ('p','text/x-pascal');
insert into file_mime_type(extension,mime_type) values ('p10','application/pkcs10');
insert into file_mime_type(extension,mime_type) values ('p10','application/x-pkcs10');
insert into file_mime_type(extension,mime_type) values ('p12','application/pkcs-12');
insert into file_mime_type(extension,mime_type) values ('p12','application/x-pkcs12');
insert into file_mime_type(extension,mime_type) values ('p7a','application/x-pkcs7-signature');
insert into file_mime_type(extension,mime_type) values ('p7c','application/pkcs7-mime');
insert into file_mime_type(extension,mime_type) values ('p7c','application/x-pkcs7-mime');
insert into file_mime_type(extension,mime_type) values ('p7m','application/pkcs7-mime');
insert into file_mime_type(extension,mime_type) values ('p7m','application/x-pkcs7-mime');
insert into file_mime_type(extension,mime_type) values ('p7r','application/x-pkcs7-certreqresp');
insert into file_mime_type(extension,mime_type) values ('p7s','application/pkcs7-signature');
insert into file_mime_type(extension,mime_type) values ('part','application/pro_eng');
insert into file_mime_type(extension,mime_type) values ('pas','text/pascal');
insert into file_mime_type(extension,mime_type) values ('pbm','image/x-portable-bitmap');
insert into file_mime_type(extension,mime_type) values ('pcl','application/vnd.hp-pcl');
insert into file_mime_type(extension,mime_type) values ('pcl','application/x-pcl');
insert into file_mime_type(extension,mime_type) values ('pct','image/x-pict');
insert into file_mime_type(extension,mime_type) values ('pcx','image/x-pcx');
insert into file_mime_type(extension,mime_type) values ('pdb','chemical/x-pdb');
insert into file_mime_type(extension,mime_type) values ('pdf','application/pdf');
insert into file_mime_type(extension,mime_type) values ('pfunk','audio/make');
insert into file_mime_type(extension,mime_type) values ('pfunk','audio/make.my.funk');
insert into file_mime_type(extension,mime_type) values ('pgm','image/x-portable-graymap');
insert into file_mime_type(extension,mime_type) values ('pgm','image/x-portable-greymap');
insert into file_mime_type(extension,mime_type) values ('pic','image/pict');
insert into file_mime_type(extension,mime_type) values ('pict','image/pict');
insert into file_mime_type(extension,mime_type) values ('pkg','application/x-newton-compatible-pkg');
insert into file_mime_type(extension,mime_type) values ('pko','application/vnd.ms-pki.pko');
insert into file_mime_type(extension,mime_type) values ('pl','text/plain');
insert into file_mime_type(extension,mime_type) values ('pl','text/x-script.perl');
insert into file_mime_type(extension,mime_type) values ('plx','application/x-pixclscript');
insert into file_mime_type(extension,mime_type) values ('pm','image/x-xpixmap');
insert into file_mime_type(extension,mime_type) values ('pm','text/x-script.perl-module');
insert into file_mime_type(extension,mime_type) values ('pm4','application/x-pagemaker');
insert into file_mime_type(extension,mime_type) values ('pm5','application/x-pagemaker');
insert into file_mime_type(extension,mime_type) values ('png','image/png');
insert into file_mime_type(extension,mime_type) values ('pnm','application/x-portable-anymap');
insert into file_mime_type(extension,mime_type) values ('pnm','image/x-portable-anymap');
insert into file_mime_type(extension,mime_type) values ('pot','application/mspowerpoint');
insert into file_mime_type(extension,mime_type) values ('pot','application/vnd.ms-powerpoint');
insert into file_mime_type(extension,mime_type) values ('pov','model/x-pov');
insert into file_mime_type(extension,mime_type) values ('ppa','application/vnd.ms-powerpoint');
insert into file_mime_type(extension,mime_type) values ('ppm','image/x-portable-pixmap');
insert into file_mime_type(extension,mime_type) values ('pps','application/mspowerpoint');
insert into file_mime_type(extension,mime_type) values ('pps','application/vnd.ms-powerpoint');
insert into file_mime_type(extension,mime_type) values ('ppt','application/mspowerpoint');
insert into file_mime_type(extension,mime_type) values ('ppt','application/powerpoint');
insert into file_mime_type(extension,mime_type) values ('ppt','application/vnd.ms-powerpoint');
insert into file_mime_type(extension,mime_type) values ('ppt','application/x-mspowerpoint');
insert into file_mime_type(extension,mime_type) values ('ppz','application/mspowerpoint');
insert into file_mime_type(extension,mime_type) values ('pre','application/x-freelance');
insert into file_mime_type(extension,mime_type) values ('prt','application/pro_eng');
insert into file_mime_type(extension,mime_type) values ('ps','application/postscript');
insert into file_mime_type(extension,mime_type) values ('psd','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('pvu','paleovu/x-pv');
insert into file_mime_type(extension,mime_type) values ('pwz','application/vnd.ms-powerpoint');
insert into file_mime_type(extension,mime_type) values ('py','text/x-script.phyton');
insert into file_mime_type(extension,mime_type) values ('pyc','applicaiton/x-bytecode.python');
insert into file_mime_type(extension,mime_type) values ('qcp','audio/vnd.qcelp');
insert into file_mime_type(extension,mime_type) values ('qd3','x-world/x-3dmf');
insert into file_mime_type(extension,mime_type) values ('qd3d','x-world/x-3dmf');
insert into file_mime_type(extension,mime_type) values ('qif','image/x-quicktime');
insert into file_mime_type(extension,mime_type) values ('qt','video/quicktime');
insert into file_mime_type(extension,mime_type) values ('qtc','video/x-qtc');
insert into file_mime_type(extension,mime_type) values ('qti','image/x-quicktime');
insert into file_mime_type(extension,mime_type) values ('qtif','image/x-quicktime');
insert into file_mime_type(extension,mime_type) values ('ra','audio/x-pn-realaudio');
insert into file_mime_type(extension,mime_type) values ('ra','audio/x-pn-realaudio-plugin');
insert into file_mime_type(extension,mime_type) values ('ra','audio/x-realaudio');
insert into file_mime_type(extension,mime_type) values ('ram','audio/x-pn-realaudio');
insert into file_mime_type(extension,mime_type) values ('ras','application/x-cmu-raster');
insert into file_mime_type(extension,mime_type) values ('ras','image/cmu-raster');
insert into file_mime_type(extension,mime_type) values ('ras','image/x-cmu-raster');
insert into file_mime_type(extension,mime_type) values ('rast','image/cmu-raster');
insert into file_mime_type(extension,mime_type) values ('rexx','text/x-script.rexx');
insert into file_mime_type(extension,mime_type) values ('rf','image/vnd.rn-realflash');
insert into file_mime_type(extension,mime_type) values ('rgb','image/x-rgb');
insert into file_mime_type(extension,mime_type) values ('rm','application/vnd.rn-realmedia');
insert into file_mime_type(extension,mime_type) values ('rm','audio/x-pn-realaudio');
insert into file_mime_type(extension,mime_type) values ('rmi','audio/mid');
insert into file_mime_type(extension,mime_type) values ('rmm','audio/x-pn-realaudio');
insert into file_mime_type(extension,mime_type) values ('rmp','audio/x-pn-realaudio');
insert into file_mime_type(extension,mime_type) values ('rmp','audio/x-pn-realaudio-plugin');
insert into file_mime_type(extension,mime_type) values ('rng','application/ringing-tones');
insert into file_mime_type(extension,mime_type) values ('rng','application/vnd.nokia.ringing-tone');
insert into file_mime_type(extension,mime_type) values ('rnx','application/vnd.rn-realplayer');
insert into file_mime_type(extension,mime_type) values ('roff','application/x-troff');
insert into file_mime_type(extension,mime_type) values ('rp','image/vnd.rn-realpix');
insert into file_mime_type(extension,mime_type) values ('rpm','audio/x-pn-realaudio-plugin');
insert into file_mime_type(extension,mime_type) values ('rt','text/richtext');
insert into file_mime_type(extension,mime_type) values ('rt','text/vnd.rn-realtext');
insert into file_mime_type(extension,mime_type) values ('rtf','application/rtf');
insert into file_mime_type(extension,mime_type) values ('rtf','application/x-rtf');
insert into file_mime_type(extension,mime_type) values ('rtf','text/richtext');
insert into file_mime_type(extension,mime_type) values ('rtx','application/rtf');
insert into file_mime_type(extension,mime_type) values ('rtx','text/richtext');
insert into file_mime_type(extension,mime_type) values ('rv','video/vnd.rn-realvideo');
insert into file_mime_type(extension,mime_type) values ('s','text/x-asm');
insert into file_mime_type(extension,mime_type) values ('s3m','audio/s3m');
insert into file_mime_type(extension,mime_type) values ('saveme','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('sbk','application/x-tbook');
insert into file_mime_type(extension,mime_type) values ('scm','application/x-lotusscreencam');
insert into file_mime_type(extension,mime_type) values ('scm','text/x-script.guile');
insert into file_mime_type(extension,mime_type) values ('scm','text/x-script.scheme');
insert into file_mime_type(extension,mime_type) values ('scm','video/x-scm');
insert into file_mime_type(extension,mime_type) values ('sdml','text/plain');
insert into file_mime_type(extension,mime_type) values ('sdp','application/sdp');
insert into file_mime_type(extension,mime_type) values ('sdp','application/x-sdp');
insert into file_mime_type(extension,mime_type) values ('sdr','application/sounder');
insert into file_mime_type(extension,mime_type) values ('sea','application/sea');
insert into file_mime_type(extension,mime_type) values ('sea','application/x-sea');
insert into file_mime_type(extension,mime_type) values ('set','application/set');
insert into file_mime_type(extension,mime_type) values ('sgm','text/sgml');
insert into file_mime_type(extension,mime_type) values ('sgm','text/x-sgml');
insert into file_mime_type(extension,mime_type) values ('sgml','text/sgml');
insert into file_mime_type(extension,mime_type) values ('sgml','text/x-sgml');
insert into file_mime_type(extension,mime_type) values ('sh','application/x-bsh');
insert into file_mime_type(extension,mime_type) values ('sh','application/x-sh');
insert into file_mime_type(extension,mime_type) values ('sh','application/x-shar');
insert into file_mime_type(extension,mime_type) values ('sh','text/x-script.sh');
insert into file_mime_type(extension,mime_type) values ('shar','application/x-bsh');
insert into file_mime_type(extension,mime_type) values ('shar','application/x-shar');
insert into file_mime_type(extension,mime_type) values ('shtml','text/html');
insert into file_mime_type(extension,mime_type) values ('shtml','text/x-server-parsed-html');
insert into file_mime_type(extension,mime_type) values ('sid','audio/x-psid');
insert into file_mime_type(extension,mime_type) values ('sit','application/x-sit');
insert into file_mime_type(extension,mime_type) values ('sit','application/x-stuffit');
insert into file_mime_type(extension,mime_type) values ('skd','application/x-koan');
insert into file_mime_type(extension,mime_type) values ('skm','application/x-koan');
insert into file_mime_type(extension,mime_type) values ('skp','application/x-koan');
insert into file_mime_type(extension,mime_type) values ('skt','application/x-koan');
insert into file_mime_type(extension,mime_type) values ('sl','application/x-seelogo');
insert into file_mime_type(extension,mime_type) values ('smi','application/smil');
insert into file_mime_type(extension,mime_type) values ('smil','application/smil');
insert into file_mime_type(extension,mime_type) values ('snd','audio/basic');
insert into file_mime_type(extension,mime_type) values ('snd','audio/x-adpcm');
insert into file_mime_type(extension,mime_type) values ('sol','application/solids');
insert into file_mime_type(extension,mime_type) values ('spc','application/x-pkcs7-certificates');
insert into file_mime_type(extension,mime_type) values ('spc','text/x-speech');
insert into file_mime_type(extension,mime_type) values ('spl','application/futuresplash');
insert into file_mime_type(extension,mime_type) values ('spr','application/x-sprite');
insert into file_mime_type(extension,mime_type) values ('sprite','application/x-sprite');
insert into file_mime_type(extension,mime_type) values ('src','application/x-wais-source');
insert into file_mime_type(extension,mime_type) values ('ssi','text/x-server-parsed-html');
insert into file_mime_type(extension,mime_type) values ('ssm','application/streamingmedia');
insert into file_mime_type(extension,mime_type) values ('sst','application/vnd.ms-pki.certstore');
insert into file_mime_type(extension,mime_type) values ('step','application/step');
insert into file_mime_type(extension,mime_type) values ('stl','application/sla');
insert into file_mime_type(extension,mime_type) values ('stl','application/vnd.ms-pki.stl');
insert into file_mime_type(extension,mime_type) values ('stl','application/x-navistyle');
insert into file_mime_type(extension,mime_type) values ('stp','application/step');
insert into file_mime_type(extension,mime_type) values ('sv4cpio','application/x-sv4cpio');
insert into file_mime_type(extension,mime_type) values ('sv4crc','application/x-sv4crc');
insert into file_mime_type(extension,mime_type) values ('svf','image/vnd.dwg');
insert into file_mime_type(extension,mime_type) values ('svf','image/x-dwg');
insert into file_mime_type(extension,mime_type) values ('svr','application/x-world');
insert into file_mime_type(extension,mime_type) values ('svr','x-world/x-svr');
insert into file_mime_type(extension,mime_type) values ('swf','application/x-shockwave-flash');
insert into file_mime_type(extension,mime_type) values ('t','application/x-troff');
insert into file_mime_type(extension,mime_type) values ('talk','text/x-speech');
insert into file_mime_type(extension,mime_type) values ('tar','application/x-tar');
insert into file_mime_type(extension,mime_type) values ('tbk','application/toolbook');
insert into file_mime_type(extension,mime_type) values ('tbk','application/x-tbook');
insert into file_mime_type(extension,mime_type) values ('tcl','application/x-tcl');
insert into file_mime_type(extension,mime_type) values ('tcl','text/x-script.tcl');
insert into file_mime_type(extension,mime_type) values ('tcsh','text/x-script.tcsh');
insert into file_mime_type(extension,mime_type) values ('tex','application/x-tex');
insert into file_mime_type(extension,mime_type) values ('texi','application/x-texinfo');
insert into file_mime_type(extension,mime_type) values ('texinfo','application/x-texinfo');
insert into file_mime_type(extension,mime_type) values ('text','application/plain');
insert into file_mime_type(extension,mime_type) values ('text','text/plain');
insert into file_mime_type(extension,mime_type) values ('tgz','application/gnutar');
insert into file_mime_type(extension,mime_type) values ('tgz','application/x-compressed');
insert into file_mime_type(extension,mime_type) values ('tif','image/tiff');
insert into file_mime_type(extension,mime_type) values ('tif','image/x-tiff');
insert into file_mime_type(extension,mime_type) values ('tiff','image/tiff');
insert into file_mime_type(extension,mime_type) values ('tiff','image/x-tiff');
insert into file_mime_type(extension,mime_type) values ('tr','application/x-troff');
insert into file_mime_type(extension,mime_type) values ('tsi','audio/tsp-audio');
insert into file_mime_type(extension,mime_type) values ('tsp','application/dsptype');
insert into file_mime_type(extension,mime_type) values ('tsp','audio/tsplayer');
insert into file_mime_type(extension,mime_type) values ('tsv','text/tab-separated-values');
insert into file_mime_type(extension,mime_type) values ('turbot','image/florian');
insert into file_mime_type(extension,mime_type) values ('txt','text/plain');
insert into file_mime_type(extension,mime_type) values ('uil','text/x-uil');
insert into file_mime_type(extension,mime_type) values ('uni','text/uri-list');
insert into file_mime_type(extension,mime_type) values ('unis','text/uri-list');
insert into file_mime_type(extension,mime_type) values ('unv','application/i-deas');
insert into file_mime_type(extension,mime_type) values ('uri','text/uri-list');
insert into file_mime_type(extension,mime_type) values ('uris','text/uri-list');
insert into file_mime_type(extension,mime_type) values ('ustar','application/x-ustar');
insert into file_mime_type(extension,mime_type) values ('ustar','multipart/x-ustar');
insert into file_mime_type(extension,mime_type) values ('uu','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('uu','text/x-uuencode');
insert into file_mime_type(extension,mime_type) values ('uue','text/x-uuencode');
insert into file_mime_type(extension,mime_type) values ('vcd','application/x-cdlink');
insert into file_mime_type(extension,mime_type) values ('vcs','text/x-vcalendar');
insert into file_mime_type(extension,mime_type) values ('vda','application/vda');
insert into file_mime_type(extension,mime_type) values ('vdo','video/vdo');
insert into file_mime_type(extension,mime_type) values ('vew','application/groupwise');
insert into file_mime_type(extension,mime_type) values ('viv','video/vivo');
insert into file_mime_type(extension,mime_type) values ('viv','video/vnd.vivo');
insert into file_mime_type(extension,mime_type) values ('vivo','video/vivo');
insert into file_mime_type(extension,mime_type) values ('vivo','video/vnd.vivo');
insert into file_mime_type(extension,mime_type) values ('vmd','application/vocaltec-media-desc');
insert into file_mime_type(extension,mime_type) values ('vmf','application/vocaltec-media-file');
insert into file_mime_type(extension,mime_type) values ('voc','audio/voc');
insert into file_mime_type(extension,mime_type) values ('voc','audio/x-voc');
insert into file_mime_type(extension,mime_type) values ('vos','video/vosaic');
insert into file_mime_type(extension,mime_type) values ('vox','audio/voxware');
insert into file_mime_type(extension,mime_type) values ('vqe','audio/x-twinvq-plugin');
insert into file_mime_type(extension,mime_type) values ('vqf','audio/x-twinvq');
insert into file_mime_type(extension,mime_type) values ('vql','audio/x-twinvq-plugin');
insert into file_mime_type(extension,mime_type) values ('vrml','application/x-vrml');
insert into file_mime_type(extension,mime_type) values ('vrml','model/vrml');
insert into file_mime_type(extension,mime_type) values ('vrml','x-world/x-vrml');
insert into file_mime_type(extension,mime_type) values ('vrt','x-world/x-vrt');
insert into file_mime_type(extension,mime_type) values ('vsd','application/x-visio');
insert into file_mime_type(extension,mime_type) values ('vst','application/x-visio');
insert into file_mime_type(extension,mime_type) values ('vsw','application/x-visio');
insert into file_mime_type(extension,mime_type) values ('w60','application/wordperfect6.0');
insert into file_mime_type(extension,mime_type) values ('w61','application/wordperfect6.1');
insert into file_mime_type(extension,mime_type) values ('w6w','application/msword');
insert into file_mime_type(extension,mime_type) values ('wav','audio/wav');
insert into file_mime_type(extension,mime_type) values ('wav','audio/x-wav');
insert into file_mime_type(extension,mime_type) values ('wb1','application/x-qpro');
insert into file_mime_type(extension,mime_type) values ('wbmp','image/vnd.wap.wbmp');
insert into file_mime_type(extension,mime_type) values ('web','application/vnd.xara');
insert into file_mime_type(extension,mime_type) values ('wiz','application/msword');
insert into file_mime_type(extension,mime_type) values ('wk1','application/x-123');
insert into file_mime_type(extension,mime_type) values ('wmf','windows/metafile');
insert into file_mime_type(extension,mime_type) values ('wml','text/vnd.wap.wml');
insert into file_mime_type(extension,mime_type) values ('wmlc','application/vnd.wap.wmlc');
insert into file_mime_type(extension,mime_type) values ('wmls','text/vnd.wap.wmlscript');
insert into file_mime_type(extension,mime_type) values ('wmlsc','application/vnd.wap.wmlscriptc');
insert into file_mime_type(extension,mime_type) values ('word','application/msword');
insert into file_mime_type(extension,mime_type) values ('wp','application/wordperfect');
insert into file_mime_type(extension,mime_type) values ('wp5','application/wordperfect');
insert into file_mime_type(extension,mime_type) values ('wp5','application/wordperfect6.0');
insert into file_mime_type(extension,mime_type) values ('wp6','application/wordperfect');
insert into file_mime_type(extension,mime_type) values ('wpd','application/wordperfect');
insert into file_mime_type(extension,mime_type) values ('wpd','application/x-wpwin');
insert into file_mime_type(extension,mime_type) values ('wq1','application/x-lotus');
insert into file_mime_type(extension,mime_type) values ('wri','application/mswrite');
insert into file_mime_type(extension,mime_type) values ('wri','application/x-wri');
insert into file_mime_type(extension,mime_type) values ('wrl','application/x-world');
insert into file_mime_type(extension,mime_type) values ('wrl','model/vrml');
insert into file_mime_type(extension,mime_type) values ('wrl','x-world/x-vrml');
insert into file_mime_type(extension,mime_type) values ('wrz','model/vrml');
insert into file_mime_type(extension,mime_type) values ('wrz','x-world/x-vrml');
insert into file_mime_type(extension,mime_type) values ('wsc','text/scriplet');
insert into file_mime_type(extension,mime_type) values ('wsrc','application/x-wais-source');
insert into file_mime_type(extension,mime_type) values ('wtk','application/x-wintalk');
insert into file_mime_type(extension,mime_type) values ('xbm','image/x-xbitmap');
insert into file_mime_type(extension,mime_type) values ('xbm','image/x-xbm');
insert into file_mime_type(extension,mime_type) values ('xbm','image/xbm');
insert into file_mime_type(extension,mime_type) values ('xdr','video/x-amt-demorun');
insert into file_mime_type(extension,mime_type) values ('xgz','xgl/drawing');
insert into file_mime_type(extension,mime_type) values ('xif','image/vnd.xiff');
insert into file_mime_type(extension,mime_type) values ('xl','application/excel');
insert into file_mime_type(extension,mime_type) values ('xla','application/excel');
insert into file_mime_type(extension,mime_type) values ('xla','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xla','application/x-msexcel');
insert into file_mime_type(extension,mime_type) values ('xlb','application/excel');
insert into file_mime_type(extension,mime_type) values ('xlb','application/vnd.ms-excel');
insert into file_mime_type(extension,mime_type) values ('xlb','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xlc','application/excel');
insert into file_mime_type(extension,mime_type) values ('xlc','application/vnd.ms-excel');
insert into file_mime_type(extension,mime_type) values ('xlc','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xld','application/excel');
insert into file_mime_type(extension,mime_type) values ('xld','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xlk','application/excel');
insert into file_mime_type(extension,mime_type) values ('xlk','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xll','application/excel');
insert into file_mime_type(extension,mime_type) values ('xll','application/vnd.ms-excel');
insert into file_mime_type(extension,mime_type) values ('xll','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xlm','application/excel');
insert into file_mime_type(extension,mime_type) values ('xlm','application/vnd.ms-excel');
insert into file_mime_type(extension,mime_type) values ('xlm','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xls','application/excel');
insert into file_mime_type(extension,mime_type) values ('xls','application/vnd.ms-excel');
insert into file_mime_type(extension,mime_type) values ('xls','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xls','application/x-msexcel');
insert into file_mime_type(extension,mime_type) values ('xlt','application/excel');
insert into file_mime_type(extension,mime_type) values ('xlt','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xlv','application/excel');
insert into file_mime_type(extension,mime_type) values ('xlv','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xlw','application/excel');
insert into file_mime_type(extension,mime_type) values ('xlw','application/vnd.ms-excel');
insert into file_mime_type(extension,mime_type) values ('xlw','application/x-excel');
insert into file_mime_type(extension,mime_type) values ('xlw','application/x-msexcel');
insert into file_mime_type(extension,mime_type) values ('xm','audio/xm');
insert into file_mime_type(extension,mime_type) values ('xml','application/xml');
insert into file_mime_type(extension,mime_type) values ('xml','text/xml');
insert into file_mime_type(extension,mime_type) values ('xmz','xgl/movie');
insert into file_mime_type(extension,mime_type) values ('xpix','application/x-vnd.ls-xpix');
insert into file_mime_type(extension,mime_type) values ('xpm','image/x-xpixmap');
insert into file_mime_type(extension,mime_type) values ('xpm','image/xpm');
insert into file_mime_type(extension,mime_type) values ('x-png','image/png');
insert into file_mime_type(extension,mime_type) values ('xsr','video/x-amt-showrun');
insert into file_mime_type(extension,mime_type) values ('xwd','image/x-xwd');
insert into file_mime_type(extension,mime_type) values ('xwd','image/x-xwindowdump');
insert into file_mime_type(extension,mime_type) values ('xyz','chemical/x-pdb');
insert into file_mime_type(extension,mime_type) values ('z','application/x-compress');
insert into file_mime_type(extension,mime_type) values ('z','application/x-compressed');
insert into file_mime_type(extension,mime_type) values ('zip','application/x-compressed');
insert into file_mime_type(extension,mime_type) values ('zip','application/x-zip-compressed');
insert into file_mime_type(extension,mime_type) values ('zip','application/zip');
insert into file_mime_type(extension,mime_type) values ('zip','multipart/x-zip');
insert into file_mime_type(extension,mime_type) values ('zoo','application/octet-stream');
insert into file_mime_type(extension,mime_type) values ('zsh','text/x-script.zsh');