| 1 | rodolico | 1 | drop table if exists document;
 | 
        
           |  |  | 2 | create table document (
 | 
        
           |  |  | 3 |    document_id             int unsigned not null auto_increment,
 | 
        
           |  |  | 4 |    name                    varchar(64) comment 'the visible, displayed name',
 | 
        
           | 51 | rodolico | 5 |    owner_type              char default 'd' comment 'determines if the owner is from the client, site or device table', 
 | 
        
           |  |  | 6 |    owner_id                int unsigned not null comment 'the client_id, site_id or device_id of the owner',
 | 
        
           | 1 | rodolico | 7 |    description             text comment 'A brief (or long) description of this document',
 | 
        
           |  |  | 8 |    document_mime_type_id   int unsigned default null references document_mime_type (document_mime_type_id),
 | 
        
           | 51 | rodolico | 9 |    name_on_disk            varchar(128) comment 'link to a file on the disk',
 | 
        
           | 1 | rodolico | 10 |    added_date              date comment 'date record was added',
 | 
        
           |  |  | 11 |    removed_date            date comment 'date record was deleted/supserceded',
 | 
        
           |  |  | 12 |    primary key             (document_id)
 | 
        
           | 51 | rodolico | 13 | ) comment 'Stores documents for clients, sites, devices and networks';
 | 
        
           | 1 | rodolico | 14 |   | 
        
           |  |  | 15 | drop table if exists document_mime_type;
 | 
        
           |  |  | 16 | create table document_mime_type (
 | 
        
           |  |  | 17 |    document_mime_type_id   int unsigned not null auto_increment,
 | 
        
           |  |  | 18 |    mime_type               varchar(64) comment 'The standardized mime type',
 | 
        
           |  |  | 19 |    extension               varchar(10) comment 'a file name extension commonly associated with this file',
 | 
        
           |  |  | 20 |    primary key             (document_mime_type_id)
 | 
        
           |  |  | 21 | ) comment 'Just a list of some common mime types';
 | 
        
           |  |  | 22 |   | 
        
           |  |  | 23 | insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'Documents', 'modules/documents/', now() );
 | 
        
           | 51 | rodolico | 24 | /* location on disk where actual files will be stored */
 | 
        
           |  |  | 25 | insert into _system ( group_name,key_name,theValue,added_date) values ( 'Documents', 'root path', 'modules/documents/file_storage', now() );
 | 
        
           | 54 | rodolico | 26 | /* keep track of the indexes used for storing file names */
 | 
        
           |  |  | 27 | insert into _system (group_name,key_name,theValue, added_date) values ( 'Documents', 'last index', '0', now() );
 | 
        
           | 55 | rodolico | 28 | /* set up some callable functions */
 | 
        
           |  |  | 29 | insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Documents', 'callable.php:documentsView', now() );
 | 
        
           |  |  | 30 | insert into _system( group_name,key_name,theValue,added_date ) values ( 'site view', 'Documents', 'callable.php:documentsView', now() );
 | 
        
           |  |  | 31 | insert into _system( group_name,key_name,theValue,added_date ) values ( 'client view', 'Documents', 'callable.php:documentsView', now() );
 | 
        
           | 1 | rodolico | 32 |   | 
        
           | 55 | rodolico | 33 |   | 
        
           | 51 | rodolico | 34 | create or replace view client_documents as select * from document where owner_type = 'c';
 | 
        
           |  |  | 35 | create or replace view site_documents as select * from document where owner_type = 's';
 | 
        
           |  |  | 36 | create or replace view device_documents as select * from document where owner_type = 'd';
 | 
        
           | 1 | rodolico | 37 |   | 
        
           |  |  | 38 | /* Menu Options */
 | 
        
           | 55 | rodolico | 39 | insert into menu( url, caption, parent_id) values ( null, 'Documents', null);
 | 
        
           | 1 | rodolico | 40 | insert into menu( url,caption,parent_id) select '/modules/documents/upload_document.html','Add A Document',menu_id from menu where caption = 'Documents';
 | 
        
           |  |  | 41 | insert into menu( url,caption,parent_id) select '/modules/documents/view_document.html','View A Document',menu_id from menu where caption = 'Documents';
 | 
        
           |  |  | 42 |   | 
        
           |  |  | 43 | /* Reports */
 | 
        
           |  |  | 44 |   | 
        
           |  |  | 45 |   | 
        
           |  |  | 46 |   | 
        
           |  |  | 47 | /* a list of 642 well known mime types */
 | 
        
           | 54 | rodolico | 48 | insert into document_mime_type(extension,mime_type) values ('csv','text/csv');
 | 
        
           | 1 | rodolico | 49 | insert into document_mime_type(extension,mime_type) values ('3dm','x-world/x-3dmf');
 | 
        
           |  |  | 50 | insert into document_mime_type(extension,mime_type) values ('3dmf','x-world/x-3dmf');
 | 
        
           |  |  | 51 | insert into document_mime_type(extension,mime_type) values ('a','application/octet-stream');
 | 
        
           |  |  | 52 | insert into document_mime_type(extension,mime_type) values ('aab','application/x-authorware-bin');
 | 
        
           |  |  | 53 | insert into document_mime_type(extension,mime_type) values ('aam','application/x-authorware-map');
 | 
        
           |  |  | 54 | insert into document_mime_type(extension,mime_type) values ('aas','application/x-authorware-seg');
 | 
        
           |  |  | 55 | insert into document_mime_type(extension,mime_type) values ('abc','text/vnd.abc');
 | 
        
           |  |  | 56 | insert into document_mime_type(extension,mime_type) values ('acgi','text/html');
 | 
        
           |  |  | 57 | insert into document_mime_type(extension,mime_type) values ('afl','video/animaflex');
 | 
        
           |  |  | 58 | insert into document_mime_type(extension,mime_type) values ('ai','application/postscript');
 | 
        
           |  |  | 59 | insert into document_mime_type(extension,mime_type) values ('aif','audio/aiff');
 | 
        
           |  |  | 60 | insert into document_mime_type(extension,mime_type) values ('aif','audio/x-aiff');
 | 
        
           |  |  | 61 | insert into document_mime_type(extension,mime_type) values ('aifc','audio/aiff');
 | 
        
           |  |  | 62 | insert into document_mime_type(extension,mime_type) values ('aifc','audio/x-aiff');
 | 
        
           |  |  | 63 | insert into document_mime_type(extension,mime_type) values ('aiff','audio/aiff');
 | 
        
           |  |  | 64 | insert into document_mime_type(extension,mime_type) values ('aiff','audio/x-aiff');
 | 
        
           |  |  | 65 | insert into document_mime_type(extension,mime_type) values ('aim','application/x-aim');
 | 
        
           |  |  | 66 | insert into document_mime_type(extension,mime_type) values ('aip','text/x-audiosoft-intra');
 | 
        
           |  |  | 67 | insert into document_mime_type(extension,mime_type) values ('ani','application/x-navi-animation');
 | 
        
           |  |  | 68 | insert into document_mime_type(extension,mime_type) values ('aos','application/x-nokia-9000-communicator-add-on-software');
 | 
        
           |  |  | 69 | insert into document_mime_type(extension,mime_type) values ('aps','application/mime');
 | 
        
           |  |  | 70 | insert into document_mime_type(extension,mime_type) values ('arc','application/octet-stream');
 | 
        
           |  |  | 71 | insert into document_mime_type(extension,mime_type) values ('arj','application/arj');
 | 
        
           |  |  | 72 | insert into document_mime_type(extension,mime_type) values ('arj','application/octet-stream');
 | 
        
           |  |  | 73 | insert into document_mime_type(extension,mime_type) values ('art','image/x-jg');
 | 
        
           |  |  | 74 | insert into document_mime_type(extension,mime_type) values ('asf','video/x-ms-asf');
 | 
        
           |  |  | 75 | insert into document_mime_type(extension,mime_type) values ('asm','text/x-asm');
 | 
        
           |  |  | 76 | insert into document_mime_type(extension,mime_type) values ('asp','text/asp');
 | 
        
           |  |  | 77 | insert into document_mime_type(extension,mime_type) values ('asx','application/x-mplayer2');
 | 
        
           |  |  | 78 | insert into document_mime_type(extension,mime_type) values ('asx','video/x-ms-asf');
 | 
        
           |  |  | 79 | insert into document_mime_type(extension,mime_type) values ('asx','video/x-ms-asf-plugin');
 | 
        
           |  |  | 80 | insert into document_mime_type(extension,mime_type) values ('au','audio/basic');
 | 
        
           |  |  | 81 | insert into document_mime_type(extension,mime_type) values ('au','audio/x-au');
 | 
        
           |  |  | 82 | insert into document_mime_type(extension,mime_type) values ('avi','application/x-troff-msvideo');
 | 
        
           |  |  | 83 | insert into document_mime_type(extension,mime_type) values ('avi','video/avi');
 | 
        
           |  |  | 84 | insert into document_mime_type(extension,mime_type) values ('avi','video/msvideo');
 | 
        
           |  |  | 85 | insert into document_mime_type(extension,mime_type) values ('avi','video/x-msvideo');
 | 
        
           |  |  | 86 | insert into document_mime_type(extension,mime_type) values ('avs','video/avs-video');
 | 
        
           |  |  | 87 | insert into document_mime_type(extension,mime_type) values ('bcpio','application/x-bcpio');
 | 
        
           |  |  | 88 | insert into document_mime_type(extension,mime_type) values ('bin','application/mac-binary');
 | 
        
           |  |  | 89 | insert into document_mime_type(extension,mime_type) values ('bin','application/macbinary');
 | 
        
           |  |  | 90 | insert into document_mime_type(extension,mime_type) values ('bin','application/octet-stream');
 | 
        
           |  |  | 91 | insert into document_mime_type(extension,mime_type) values ('bin','application/x-binary');
 | 
        
           |  |  | 92 | insert into document_mime_type(extension,mime_type) values ('bin','application/x-macbinary');
 | 
        
           |  |  | 93 | insert into document_mime_type(extension,mime_type) values ('bm','image/bmp');
 | 
        
           |  |  | 94 | insert into document_mime_type(extension,mime_type) values ('bmp','image/bmp');
 | 
        
           |  |  | 95 | insert into document_mime_type(extension,mime_type) values ('bmp','image/x-windows-bmp');
 | 
        
           |  |  | 96 | insert into document_mime_type(extension,mime_type) values ('boo','application/book');
 | 
        
           |  |  | 97 | insert into document_mime_type(extension,mime_type) values ('book','application/book');
 | 
        
           |  |  | 98 | insert into document_mime_type(extension,mime_type) values ('boz','application/x-bzip2');
 | 
        
           |  |  | 99 | insert into document_mime_type(extension,mime_type) values ('bsh','application/x-bsh');
 | 
        
           |  |  | 100 | insert into document_mime_type(extension,mime_type) values ('bz','application/x-bzip');
 | 
        
           |  |  | 101 | insert into document_mime_type(extension,mime_type) values ('bz2','application/x-bzip2');
 | 
        
           |  |  | 102 | insert into document_mime_type(extension,mime_type) values ('c','text/plain');
 | 
        
           |  |  | 103 | insert into document_mime_type(extension,mime_type) values ('c','text/x-c');
 | 
        
           |  |  | 104 | insert into document_mime_type(extension,mime_type) values ('c++','text/plain');
 | 
        
           |  |  | 105 | insert into document_mime_type(extension,mime_type) values ('cat','application/vnd.ms-pki.seccat');
 | 
        
           |  |  | 106 | insert into document_mime_type(extension,mime_type) values ('cc','text/plain');
 | 
        
           |  |  | 107 | insert into document_mime_type(extension,mime_type) values ('cc','text/x-c');
 | 
        
           |  |  | 108 | insert into document_mime_type(extension,mime_type) values ('ccad','application/clariscad');
 | 
        
           |  |  | 109 | insert into document_mime_type(extension,mime_type) values ('cco','application/x-cocoa');
 | 
        
           |  |  | 110 | insert into document_mime_type(extension,mime_type) values ('cdf','application/cdf');
 | 
        
           |  |  | 111 | insert into document_mime_type(extension,mime_type) values ('cdf','application/x-cdf');
 | 
        
           |  |  | 112 | insert into document_mime_type(extension,mime_type) values ('cdf','application/x-netcdf');
 | 
        
           |  |  | 113 | insert into document_mime_type(extension,mime_type) values ('cer','application/pkix-cert');
 | 
        
           |  |  | 114 | insert into document_mime_type(extension,mime_type) values ('cer','application/x-x509-ca-cert');
 | 
        
           |  |  | 115 | insert into document_mime_type(extension,mime_type) values ('cha','application/x-chat');
 | 
        
           |  |  | 116 | insert into document_mime_type(extension,mime_type) values ('chat','application/x-chat');
 | 
        
           |  |  | 117 | insert into document_mime_type(extension,mime_type) values ('class','application/java');
 | 
        
           |  |  | 118 | insert into document_mime_type(extension,mime_type) values ('class','application/java-byte-code');
 | 
        
           |  |  | 119 | insert into document_mime_type(extension,mime_type) values ('class','application/x-java-class');
 | 
        
           |  |  | 120 | insert into document_mime_type(extension,mime_type) values ('com','application/octet-stream');
 | 
        
           |  |  | 121 | insert into document_mime_type(extension,mime_type) values ('com','text/plain');
 | 
        
           |  |  | 122 | insert into document_mime_type(extension,mime_type) values ('conf','text/plain');
 | 
        
           |  |  | 123 | insert into document_mime_type(extension,mime_type) values ('cpio','application/x-cpio');
 | 
        
           |  |  | 124 | insert into document_mime_type(extension,mime_type) values ('cpp','text/x-c');
 | 
        
           |  |  | 125 | insert into document_mime_type(extension,mime_type) values ('cpt','application/mac-compactpro');
 | 
        
           |  |  | 126 | insert into document_mime_type(extension,mime_type) values ('cpt','application/x-compactpro');
 | 
        
           |  |  | 127 | insert into document_mime_type(extension,mime_type) values ('cpt','application/x-cpt');
 | 
        
           |  |  | 128 | insert into document_mime_type(extension,mime_type) values ('crl','application/pkcs-crl');
 | 
        
           |  |  | 129 | insert into document_mime_type(extension,mime_type) values ('crl','application/pkix-crl');
 | 
        
           |  |  | 130 | insert into document_mime_type(extension,mime_type) values ('crt','application/pkix-cert');
 | 
        
           |  |  | 131 | insert into document_mime_type(extension,mime_type) values ('crt','application/x-x509-ca-cert');
 | 
        
           |  |  | 132 | insert into document_mime_type(extension,mime_type) values ('crt','application/x-x509-user-cert');
 | 
        
           |  |  | 133 | insert into document_mime_type(extension,mime_type) values ('csh','application/x-csh');
 | 
        
           |  |  | 134 | insert into document_mime_type(extension,mime_type) values ('csh','text/x-script.csh');
 | 
        
           |  |  | 135 | insert into document_mime_type(extension,mime_type) values ('css','application/x-pointplus');
 | 
        
           |  |  | 136 | insert into document_mime_type(extension,mime_type) values ('css','text/css');
 | 
        
           |  |  | 137 | insert into document_mime_type(extension,mime_type) values ('cxx','text/plain');
 | 
        
           |  |  | 138 | insert into document_mime_type(extension,mime_type) values ('dcr','application/x-director');
 | 
        
           |  |  | 139 | insert into document_mime_type(extension,mime_type) values ('deepv','application/x-deepv');
 | 
        
           |  |  | 140 | insert into document_mime_type(extension,mime_type) values ('def','text/plain');
 | 
        
           |  |  | 141 | insert into document_mime_type(extension,mime_type) values ('der','application/x-x509-ca-cert');
 | 
        
           |  |  | 142 | insert into document_mime_type(extension,mime_type) values ('dif','video/x-dv');
 | 
        
           |  |  | 143 | insert into document_mime_type(extension,mime_type) values ('dir','application/x-director');
 | 
        
           |  |  | 144 | insert into document_mime_type(extension,mime_type) values ('dl','video/dl');
 | 
        
           |  |  | 145 | insert into document_mime_type(extension,mime_type) values ('dl','video/x-dl');
 | 
        
           |  |  | 146 | insert into document_mime_type(extension,mime_type) values ('doc','application/msword');
 | 
        
           |  |  | 147 | insert into document_mime_type(extension,mime_type) values ('dot','application/msword');
 | 
        
           |  |  | 148 | insert into document_mime_type(extension,mime_type) values ('dp','application/commonground');
 | 
        
           |  |  | 149 | insert into document_mime_type(extension,mime_type) values ('drw','application/drafting');
 | 
        
           |  |  | 150 | insert into document_mime_type(extension,mime_type) values ('dump','application/octet-stream');
 | 
        
           |  |  | 151 | insert into document_mime_type(extension,mime_type) values ('dv','video/x-dv');
 | 
        
           |  |  | 152 | insert into document_mime_type(extension,mime_type) values ('dvi','application/x-dvi');
 | 
        
           |  |  | 153 | insert into document_mime_type(extension,mime_type) values ('dwf','drawing/x-dwf (old)');
 | 
        
           |  |  | 154 | insert into document_mime_type(extension,mime_type) values ('dwf','model/vnd.dwf');
 | 
        
           |  |  | 155 | insert into document_mime_type(extension,mime_type) values ('dwg','application/acad');
 | 
        
           |  |  | 156 | insert into document_mime_type(extension,mime_type) values ('dwg','image/vnd.dwg');
 | 
        
           |  |  | 157 | insert into document_mime_type(extension,mime_type) values ('dwg','image/x-dwg');
 | 
        
           |  |  | 158 | insert into document_mime_type(extension,mime_type) values ('dxf','application/dxf');
 | 
        
           |  |  | 159 | insert into document_mime_type(extension,mime_type) values ('dxf','image/vnd.dwg');
 | 
        
           |  |  | 160 | insert into document_mime_type(extension,mime_type) values ('dxf','image/x-dwg');
 | 
        
           |  |  | 161 | insert into document_mime_type(extension,mime_type) values ('dxr','application/x-director');
 | 
        
           |  |  | 162 | insert into document_mime_type(extension,mime_type) values ('el','text/x-script.elisp');
 | 
        
           |  |  | 163 | insert into document_mime_type(extension,mime_type) values ('elc','application/x-bytecode.elisp (compiled elisp)');
 | 
        
           |  |  | 164 | insert into document_mime_type(extension,mime_type) values ('elc','application/x-elc');
 | 
        
           |  |  | 165 | insert into document_mime_type(extension,mime_type) values ('env','application/x-envoy');
 | 
        
           |  |  | 166 | insert into document_mime_type(extension,mime_type) values ('eps','application/postscript');
 | 
        
           |  |  | 167 | insert into document_mime_type(extension,mime_type) values ('es','application/x-esrehber');
 | 
        
           |  |  | 168 | insert into document_mime_type(extension,mime_type) values ('etx','text/x-setext');
 | 
        
           |  |  | 169 | insert into document_mime_type(extension,mime_type) values ('evy','application/envoy');
 | 
        
           |  |  | 170 | insert into document_mime_type(extension,mime_type) values ('evy','application/x-envoy');
 | 
        
           |  |  | 171 | insert into document_mime_type(extension,mime_type) values ('exe','application/octet-stream');
 | 
        
           |  |  | 172 | insert into document_mime_type(extension,mime_type) values ('f','text/plain');
 | 
        
           |  |  | 173 | insert into document_mime_type(extension,mime_type) values ('f','text/x-fortran');
 | 
        
           |  |  | 174 | insert into document_mime_type(extension,mime_type) values ('f77','text/x-fortran');
 | 
        
           |  |  | 175 | insert into document_mime_type(extension,mime_type) values ('f90','text/plain');
 | 
        
           |  |  | 176 | insert into document_mime_type(extension,mime_type) values ('f90','text/x-fortran');
 | 
        
           |  |  | 177 | insert into document_mime_type(extension,mime_type) values ('fdf','application/vnd.fdf');
 | 
        
           |  |  | 178 | insert into document_mime_type(extension,mime_type) values ('fif','application/fractals');
 | 
        
           |  |  | 179 | insert into document_mime_type(extension,mime_type) values ('fif','image/fif');
 | 
        
           |  |  | 180 | insert into document_mime_type(extension,mime_type) values ('fli','video/fli');
 | 
        
           |  |  | 181 | insert into document_mime_type(extension,mime_type) values ('fli','video/x-fli');
 | 
        
           |  |  | 182 | insert into document_mime_type(extension,mime_type) values ('flo','image/florian');
 | 
        
           |  |  | 183 | insert into document_mime_type(extension,mime_type) values ('flx','text/vnd.fmi.flexstor');
 | 
        
           |  |  | 184 | insert into document_mime_type(extension,mime_type) values ('fmf','video/x-atomic3d-feature');
 | 
        
           |  |  | 185 | insert into document_mime_type(extension,mime_type) values ('for','text/plain');
 | 
        
           |  |  | 186 | insert into document_mime_type(extension,mime_type) values ('for','text/x-fortran');
 | 
        
           |  |  | 187 | insert into document_mime_type(extension,mime_type) values ('fpx','image/vnd.fpx');
 | 
        
           |  |  | 188 | insert into document_mime_type(extension,mime_type) values ('fpx','image/vnd.net-fpx');
 | 
        
           |  |  | 189 | insert into document_mime_type(extension,mime_type) values ('frl','application/freeloader');
 | 
        
           |  |  | 190 | insert into document_mime_type(extension,mime_type) values ('funk','audio/make');
 | 
        
           |  |  | 191 | insert into document_mime_type(extension,mime_type) values ('g','text/plain');
 | 
        
           |  |  | 192 | insert into document_mime_type(extension,mime_type) values ('g3','image/g3fax');
 | 
        
           |  |  | 193 | insert into document_mime_type(extension,mime_type) values ('gif','image/gif');
 | 
        
           |  |  | 194 | insert into document_mime_type(extension,mime_type) values ('gl','video/gl');
 | 
        
           |  |  | 195 | insert into document_mime_type(extension,mime_type) values ('gl','video/x-gl');
 | 
        
           |  |  | 196 | insert into document_mime_type(extension,mime_type) values ('gsd','audio/x-gsm');
 | 
        
           |  |  | 197 | insert into document_mime_type(extension,mime_type) values ('gsm','audio/x-gsm');
 | 
        
           |  |  | 198 | insert into document_mime_type(extension,mime_type) values ('gsp','application/x-gsp');
 | 
        
           |  |  | 199 | insert into document_mime_type(extension,mime_type) values ('gss','application/x-gss');
 | 
        
           |  |  | 200 | insert into document_mime_type(extension,mime_type) values ('gtar','application/x-gtar');
 | 
        
           |  |  | 201 | insert into document_mime_type(extension,mime_type) values ('gz','application/x-compressed');
 | 
        
           |  |  | 202 | insert into document_mime_type(extension,mime_type) values ('gz','application/x-gzip');
 | 
        
           |  |  | 203 | insert into document_mime_type(extension,mime_type) values ('gzip','application/x-gzip');
 | 
        
           |  |  | 204 | insert into document_mime_type(extension,mime_type) values ('gzip','multipart/x-gzip');
 | 
        
           |  |  | 205 | insert into document_mime_type(extension,mime_type) values ('h','text/plain');
 | 
        
           |  |  | 206 | insert into document_mime_type(extension,mime_type) values ('h','text/x-h');
 | 
        
           |  |  | 207 | insert into document_mime_type(extension,mime_type) values ('hdf','application/x-hdf');
 | 
        
           |  |  | 208 | insert into document_mime_type(extension,mime_type) values ('help','application/x-helpfile');
 | 
        
           |  |  | 209 | insert into document_mime_type(extension,mime_type) values ('hgl','application/vnd.hp-hpgl');
 | 
        
           |  |  | 210 | insert into document_mime_type(extension,mime_type) values ('hh','text/plain');
 | 
        
           |  |  | 211 | insert into document_mime_type(extension,mime_type) values ('hh','text/x-h');
 | 
        
           |  |  | 212 | insert into document_mime_type(extension,mime_type) values ('hlb','text/x-script');
 | 
        
           |  |  | 213 | insert into document_mime_type(extension,mime_type) values ('hlp','application/hlp');
 | 
        
           |  |  | 214 | insert into document_mime_type(extension,mime_type) values ('hlp','application/x-helpfile');
 | 
        
           |  |  | 215 | insert into document_mime_type(extension,mime_type) values ('hlp','application/x-winhelp');
 | 
        
           |  |  | 216 | insert into document_mime_type(extension,mime_type) values ('hpg','application/vnd.hp-hpgl');
 | 
        
           |  |  | 217 | insert into document_mime_type(extension,mime_type) values ('hpgl','application/vnd.hp-hpgl');
 | 
        
           |  |  | 218 | insert into document_mime_type(extension,mime_type) values ('hqx','application/binhex');
 | 
        
           |  |  | 219 | insert into document_mime_type(extension,mime_type) values ('hqx','application/binhex4');
 | 
        
           |  |  | 220 | insert into document_mime_type(extension,mime_type) values ('hqx','application/mac-binhex');
 | 
        
           |  |  | 221 | insert into document_mime_type(extension,mime_type) values ('hqx','application/mac-binhex40');
 | 
        
           |  |  | 222 | insert into document_mime_type(extension,mime_type) values ('hqx','application/x-binhex40');
 | 
        
           |  |  | 223 | insert into document_mime_type(extension,mime_type) values ('hqx','application/x-mac-binhex40');
 | 
        
           |  |  | 224 | insert into document_mime_type(extension,mime_type) values ('hta','application/hta');
 | 
        
           |  |  | 225 | insert into document_mime_type(extension,mime_type) values ('htc','text/x-component');
 | 
        
           |  |  | 226 | insert into document_mime_type(extension,mime_type) values ('htm','text/html');
 | 
        
           |  |  | 227 | insert into document_mime_type(extension,mime_type) values ('html','text/html');
 | 
        
           |  |  | 228 | insert into document_mime_type(extension,mime_type) values ('htmls','text/html');
 | 
        
           |  |  | 229 | insert into document_mime_type(extension,mime_type) values ('htt','text/webviewhtml');
 | 
        
           |  |  | 230 | insert into document_mime_type(extension,mime_type) values ('htx','text/html');
 | 
        
           |  |  | 231 | insert into document_mime_type(extension,mime_type) values ('ice','x-conference/x-cooltalk');
 | 
        
           |  |  | 232 | insert into document_mime_type(extension,mime_type) values ('ico','image/x-icon');
 | 
        
           |  |  | 233 | insert into document_mime_type(extension,mime_type) values ('idc','text/plain');
 | 
        
           |  |  | 234 | insert into document_mime_type(extension,mime_type) values ('ief','image/ief');
 | 
        
           |  |  | 235 | insert into document_mime_type(extension,mime_type) values ('iefs','image/ief');
 | 
        
           |  |  | 236 | insert into document_mime_type(extension,mime_type) values ('iges','application/iges');
 | 
        
           |  |  | 237 | insert into document_mime_type(extension,mime_type) values ('iges','model/iges');
 | 
        
           |  |  | 238 | insert into document_mime_type(extension,mime_type) values ('igs','application/iges');
 | 
        
           |  |  | 239 | insert into document_mime_type(extension,mime_type) values ('igs','model/iges');
 | 
        
           |  |  | 240 | insert into document_mime_type(extension,mime_type) values ('ima','application/x-ima');
 | 
        
           |  |  | 241 | insert into document_mime_type(extension,mime_type) values ('imap','application/x-httpd-imap');
 | 
        
           |  |  | 242 | insert into document_mime_type(extension,mime_type) values ('inf','application/inf');
 | 
        
           |  |  | 243 | insert into document_mime_type(extension,mime_type) values ('ins','application/x-internett-signup');
 | 
        
           |  |  | 244 | insert into document_mime_type(extension,mime_type) values ('ip','application/x-ip2');
 | 
        
           |  |  | 245 | insert into document_mime_type(extension,mime_type) values ('isu','video/x-isvideo');
 | 
        
           |  |  | 246 | insert into document_mime_type(extension,mime_type) values ('it','audio/it');
 | 
        
           |  |  | 247 | insert into document_mime_type(extension,mime_type) values ('iv','application/x-inventor');
 | 
        
           |  |  | 248 | insert into document_mime_type(extension,mime_type) values ('ivr','i-world/i-vrml');
 | 
        
           |  |  | 249 | insert into document_mime_type(extension,mime_type) values ('ivy','application/x-livescreen');
 | 
        
           |  |  | 250 | insert into document_mime_type(extension,mime_type) values ('jam','audio/x-jam');
 | 
        
           |  |  | 251 | insert into document_mime_type(extension,mime_type) values ('jav','text/plain');
 | 
        
           |  |  | 252 | insert into document_mime_type(extension,mime_type) values ('jav','text/x-java-source');
 | 
        
           |  |  | 253 | insert into document_mime_type(extension,mime_type) values ('java','text/plain');
 | 
        
           |  |  | 254 | insert into document_mime_type(extension,mime_type) values ('java','text/x-java-source');
 | 
        
           |  |  | 255 | insert into document_mime_type(extension,mime_type) values ('jcm','application/x-java-commerce');
 | 
        
           |  |  | 256 | insert into document_mime_type(extension,mime_type) values ('jfif','image/jpeg');
 | 
        
           |  |  | 257 | insert into document_mime_type(extension,mime_type) values ('jfif','image/pjpeg');
 | 
        
           |  |  | 258 | insert into document_mime_type(extension,mime_type) values ('jfif-tbnl','image/jpeg');
 | 
        
           |  |  | 259 | insert into document_mime_type(extension,mime_type) values ('jpe','image/jpeg');
 | 
        
           |  |  | 260 | insert into document_mime_type(extension,mime_type) values ('jpe','image/pjpeg');
 | 
        
           |  |  | 261 | insert into document_mime_type(extension,mime_type) values ('jpeg','image/jpeg');
 | 
        
           |  |  | 262 | insert into document_mime_type(extension,mime_type) values ('jpeg','image/pjpeg');
 | 
        
           |  |  | 263 | insert into document_mime_type(extension,mime_type) values ('jpg','image/jpeg');
 | 
        
           |  |  | 264 | insert into document_mime_type(extension,mime_type) values ('jpg','image/pjpeg');
 | 
        
           |  |  | 265 | insert into document_mime_type(extension,mime_type) values ('jps','image/x-jps');
 | 
        
           |  |  | 266 | insert into document_mime_type(extension,mime_type) values ('js','application/x-javascript');
 | 
        
           |  |  | 267 | insert into document_mime_type(extension,mime_type) values ('jut','image/jutvision');
 | 
        
           |  |  | 268 | insert into document_mime_type(extension,mime_type) values ('kar','audio/midi');
 | 
        
           |  |  | 269 | insert into document_mime_type(extension,mime_type) values ('kar','music/x-karaoke');
 | 
        
           |  |  | 270 | insert into document_mime_type(extension,mime_type) values ('ksh','application/x-ksh');
 | 
        
           |  |  | 271 | insert into document_mime_type(extension,mime_type) values ('ksh','text/x-script.ksh');
 | 
        
           |  |  | 272 | insert into document_mime_type(extension,mime_type) values ('la','audio/nspaudio');
 | 
        
           |  |  | 273 | insert into document_mime_type(extension,mime_type) values ('la','audio/x-nspaudio');
 | 
        
           |  |  | 274 | insert into document_mime_type(extension,mime_type) values ('lam','audio/x-liveaudio');
 | 
        
           |  |  | 275 | insert into document_mime_type(extension,mime_type) values ('latex','application/x-latex');
 | 
        
           |  |  | 276 | insert into document_mime_type(extension,mime_type) values ('lha','application/lha');
 | 
        
           |  |  | 277 | insert into document_mime_type(extension,mime_type) values ('lha','application/octet-stream');
 | 
        
           |  |  | 278 | insert into document_mime_type(extension,mime_type) values ('lha','application/x-lha');
 | 
        
           |  |  | 279 | insert into document_mime_type(extension,mime_type) values ('lhx','application/octet-stream');
 | 
        
           |  |  | 280 | insert into document_mime_type(extension,mime_type) values ('list','text/plain');
 | 
        
           |  |  | 281 | insert into document_mime_type(extension,mime_type) values ('lma','audio/nspaudio');
 | 
        
           |  |  | 282 | insert into document_mime_type(extension,mime_type) values ('lma','audio/x-nspaudio');
 | 
        
           |  |  | 283 | insert into document_mime_type(extension,mime_type) values ('log','text/plain');
 | 
        
           |  |  | 284 | insert into document_mime_type(extension,mime_type) values ('lsp','application/x-lisp');
 | 
        
           |  |  | 285 | insert into document_mime_type(extension,mime_type) values ('lsp','text/x-script.lisp');
 | 
        
           |  |  | 286 | insert into document_mime_type(extension,mime_type) values ('lst','text/plain');
 | 
        
           |  |  | 287 | insert into document_mime_type(extension,mime_type) values ('lsx','text/x-la-asf');
 | 
        
           |  |  | 288 | insert into document_mime_type(extension,mime_type) values ('ltx','application/x-latex');
 | 
        
           |  |  | 289 | insert into document_mime_type(extension,mime_type) values ('lzh','application/octet-stream');
 | 
        
           |  |  | 290 | insert into document_mime_type(extension,mime_type) values ('lzh','application/x-lzh');
 | 
        
           |  |  | 291 | insert into document_mime_type(extension,mime_type) values ('lzx','application/lzx');
 | 
        
           |  |  | 292 | insert into document_mime_type(extension,mime_type) values ('lzx','application/octet-stream');
 | 
        
           |  |  | 293 | insert into document_mime_type(extension,mime_type) values ('lzx','application/x-lzx');
 | 
        
           |  |  | 294 | insert into document_mime_type(extension,mime_type) values ('m','text/plain');
 | 
        
           |  |  | 295 | insert into document_mime_type(extension,mime_type) values ('m','text/x-m');
 | 
        
           |  |  | 296 | insert into document_mime_type(extension,mime_type) values ('m1v','video/mpeg');
 | 
        
           |  |  | 297 | insert into document_mime_type(extension,mime_type) values ('m2a','audio/mpeg');
 | 
        
           |  |  | 298 | insert into document_mime_type(extension,mime_type) values ('m2v','video/mpeg');
 | 
        
           |  |  | 299 | insert into document_mime_type(extension,mime_type) values ('m3u','audio/x-mpequrl');
 | 
        
           |  |  | 300 | insert into document_mime_type(extension,mime_type) values ('man','application/x-troff-man');
 | 
        
           |  |  | 301 | insert into document_mime_type(extension,mime_type) values ('map','application/x-navimap');
 | 
        
           |  |  | 302 | insert into document_mime_type(extension,mime_type) values ('mar','text/plain');
 | 
        
           |  |  | 303 | insert into document_mime_type(extension,mime_type) values ('mbd','application/mbedlet');
 | 
        
           |  |  | 304 | insert into document_mime_type(extension,mime_type) values ('mc$','application/x-magic-cap-package-1.0');
 | 
        
           |  |  | 305 | insert into document_mime_type(extension,mime_type) values ('mcd','application/mcad');
 | 
        
           |  |  | 306 | insert into document_mime_type(extension,mime_type) values ('mcd','application/x-mathcad');
 | 
        
           |  |  | 307 | insert into document_mime_type(extension,mime_type) values ('mcf','image/vasa');
 | 
        
           |  |  | 308 | insert into document_mime_type(extension,mime_type) values ('mcf','text/mcf');
 | 
        
           |  |  | 309 | insert into document_mime_type(extension,mime_type) values ('mcp','application/netmc');
 | 
        
           |  |  | 310 | insert into document_mime_type(extension,mime_type) values ('me','application/x-troff-me');
 | 
        
           |  |  | 311 | insert into document_mime_type(extension,mime_type) values ('mht','message/rfc822');
 | 
        
           |  |  | 312 | insert into document_mime_type(extension,mime_type) values ('mhtml','message/rfc822');
 | 
        
           |  |  | 313 | insert into document_mime_type(extension,mime_type) values ('mid','application/x-midi');
 | 
        
           |  |  | 314 | insert into document_mime_type(extension,mime_type) values ('mid','audio/midi');
 | 
        
           |  |  | 315 | insert into document_mime_type(extension,mime_type) values ('mid','audio/x-mid');
 | 
        
           |  |  | 316 | insert into document_mime_type(extension,mime_type) values ('mid','audio/x-midi');
 | 
        
           |  |  | 317 | insert into document_mime_type(extension,mime_type) values ('mid','music/crescendo');
 | 
        
           |  |  | 318 | insert into document_mime_type(extension,mime_type) values ('mid','x-music/x-midi');
 | 
        
           |  |  | 319 | insert into document_mime_type(extension,mime_type) values ('midi','application/x-midi');
 | 
        
           |  |  | 320 | insert into document_mime_type(extension,mime_type) values ('midi','audio/midi');
 | 
        
           |  |  | 321 | insert into document_mime_type(extension,mime_type) values ('midi','audio/x-mid');
 | 
        
           |  |  | 322 | insert into document_mime_type(extension,mime_type) values ('midi','audio/x-midi');
 | 
        
           |  |  | 323 | insert into document_mime_type(extension,mime_type) values ('midi','music/crescendo');
 | 
        
           |  |  | 324 | insert into document_mime_type(extension,mime_type) values ('midi','x-music/x-midi');
 | 
        
           |  |  | 325 | insert into document_mime_type(extension,mime_type) values ('mif','application/x-frame');
 | 
        
           |  |  | 326 | insert into document_mime_type(extension,mime_type) values ('mif','application/x-mif');
 | 
        
           |  |  | 327 | insert into document_mime_type(extension,mime_type) values ('mime','message/rfc822');
 | 
        
           |  |  | 328 | insert into document_mime_type(extension,mime_type) values ('mime','www/mime');
 | 
        
           |  |  | 329 | insert into document_mime_type(extension,mime_type) values ('mjf','audio/x-vnd.audioexplosion.mjuicemediafile');
 | 
        
           |  |  | 330 | insert into document_mime_type(extension,mime_type) values ('mjpg','video/x-motion-jpeg');
 | 
        
           |  |  | 331 | insert into document_mime_type(extension,mime_type) values ('mm','application/base64');
 | 
        
           |  |  | 332 | insert into document_mime_type(extension,mime_type) values ('mm','application/x-meme');
 | 
        
           |  |  | 333 | insert into document_mime_type(extension,mime_type) values ('mme','application/base64');
 | 
        
           |  |  | 334 | insert into document_mime_type(extension,mime_type) values ('mod','audio/mod');
 | 
        
           |  |  | 335 | insert into document_mime_type(extension,mime_type) values ('mod','audio/x-mod');
 | 
        
           |  |  | 336 | insert into document_mime_type(extension,mime_type) values ('moov','video/quicktime');
 | 
        
           |  |  | 337 | insert into document_mime_type(extension,mime_type) values ('mov','video/quicktime');
 | 
        
           |  |  | 338 | insert into document_mime_type(extension,mime_type) values ('movie','video/x-sgi-movie');
 | 
        
           |  |  | 339 | insert into document_mime_type(extension,mime_type) values ('mp2','audio/mpeg');
 | 
        
           |  |  | 340 | insert into document_mime_type(extension,mime_type) values ('mp2','audio/x-mpeg');
 | 
        
           |  |  | 341 | insert into document_mime_type(extension,mime_type) values ('mp2','video/mpeg');
 | 
        
           |  |  | 342 | insert into document_mime_type(extension,mime_type) values ('mp2','video/x-mpeg');
 | 
        
           |  |  | 343 | insert into document_mime_type(extension,mime_type) values ('mp2','video/x-mpeq2a');
 | 
        
           |  |  | 344 | insert into document_mime_type(extension,mime_type) values ('mp3','audio/mpeg3');
 | 
        
           |  |  | 345 | insert into document_mime_type(extension,mime_type) values ('mp3','audio/x-mpeg-3');
 | 
        
           |  |  | 346 | insert into document_mime_type(extension,mime_type) values ('mp3','video/mpeg');
 | 
        
           |  |  | 347 | insert into document_mime_type(extension,mime_type) values ('mp3','video/x-mpeg');
 | 
        
           |  |  | 348 | insert into document_mime_type(extension,mime_type) values ('mpa','audio/mpeg');
 | 
        
           |  |  | 349 | insert into document_mime_type(extension,mime_type) values ('mpa','video/mpeg');
 | 
        
           |  |  | 350 | insert into document_mime_type(extension,mime_type) values ('mpc','application/x-project');
 | 
        
           |  |  | 351 | insert into document_mime_type(extension,mime_type) values ('mpe','video/mpeg');
 | 
        
           |  |  | 352 | insert into document_mime_type(extension,mime_type) values ('mpeg','video/mpeg');
 | 
        
           |  |  | 353 | insert into document_mime_type(extension,mime_type) values ('mpg','audio/mpeg');
 | 
        
           |  |  | 354 | insert into document_mime_type(extension,mime_type) values ('mpg','video/mpeg');
 | 
        
           |  |  | 355 | insert into document_mime_type(extension,mime_type) values ('mpga','audio/mpeg');
 | 
        
           |  |  | 356 | insert into document_mime_type(extension,mime_type) values ('mpp','application/vnd.ms-project');
 | 
        
           |  |  | 357 | insert into document_mime_type(extension,mime_type) values ('mpt','application/x-project');
 | 
        
           |  |  | 358 | insert into document_mime_type(extension,mime_type) values ('mpv','application/x-project');
 | 
        
           |  |  | 359 | insert into document_mime_type(extension,mime_type) values ('mpx','application/x-project');
 | 
        
           |  |  | 360 | insert into document_mime_type(extension,mime_type) values ('mrc','application/marc');
 | 
        
           |  |  | 361 | insert into document_mime_type(extension,mime_type) values ('ms','application/x-troff-ms');
 | 
        
           |  |  | 362 | insert into document_mime_type(extension,mime_type) values ('mv','video/x-sgi-movie');
 | 
        
           |  |  | 363 | insert into document_mime_type(extension,mime_type) values ('my','audio/make');
 | 
        
           |  |  | 364 | insert into document_mime_type(extension,mime_type) values ('mzz','application/x-vnd.audioexplosion.mzz');
 | 
        
           |  |  | 365 | insert into document_mime_type(extension,mime_type) values ('nap','image/naplps');
 | 
        
           |  |  | 366 | insert into document_mime_type(extension,mime_type) values ('naplps','image/naplps');
 | 
        
           |  |  | 367 | insert into document_mime_type(extension,mime_type) values ('nc','application/x-netcdf');
 | 
        
           |  |  | 368 | insert into document_mime_type(extension,mime_type) values ('ncm','application/vnd.nokia.configuration-message');
 | 
        
           |  |  | 369 | insert into document_mime_type(extension,mime_type) values ('nif','image/x-niff');
 | 
        
           |  |  | 370 | insert into document_mime_type(extension,mime_type) values ('niff','image/x-niff');
 | 
        
           |  |  | 371 | insert into document_mime_type(extension,mime_type) values ('nix','application/x-mix-transfer');
 | 
        
           |  |  | 372 | insert into document_mime_type(extension,mime_type) values ('nsc','application/x-conference');
 | 
        
           |  |  | 373 | insert into document_mime_type(extension,mime_type) values ('nvd','application/x-navidoc');
 | 
        
           |  |  | 374 | insert into document_mime_type(extension,mime_type) values ('o','application/octet-stream');
 | 
        
           |  |  | 375 | insert into document_mime_type(extension,mime_type) values ('oda','application/oda');
 | 
        
           |  |  | 376 | insert into document_mime_type(extension,mime_type) values ('omc','application/x-omc');
 | 
        
           |  |  | 377 | insert into document_mime_type(extension,mime_type) values ('omcd','application/x-omcdatamaker');
 | 
        
           |  |  | 378 | insert into document_mime_type(extension,mime_type) values ('omcr','application/x-omcregerator');
 | 
        
           |  |  | 379 | insert into document_mime_type(extension,mime_type) values ('p','text/x-pascal');
 | 
        
           |  |  | 380 | insert into document_mime_type(extension,mime_type) values ('p10','application/pkcs10');
 | 
        
           |  |  | 381 | insert into document_mime_type(extension,mime_type) values ('p10','application/x-pkcs10');
 | 
        
           |  |  | 382 | insert into document_mime_type(extension,mime_type) values ('p12','application/pkcs-12');
 | 
        
           |  |  | 383 | insert into document_mime_type(extension,mime_type) values ('p12','application/x-pkcs12');
 | 
        
           |  |  | 384 | insert into document_mime_type(extension,mime_type) values ('p7a','application/x-pkcs7-signature');
 | 
        
           |  |  | 385 | insert into document_mime_type(extension,mime_type) values ('p7c','application/pkcs7-mime');
 | 
        
           |  |  | 386 | insert into document_mime_type(extension,mime_type) values ('p7c','application/x-pkcs7-mime');
 | 
        
           |  |  | 387 | insert into document_mime_type(extension,mime_type) values ('p7m','application/pkcs7-mime');
 | 
        
           |  |  | 388 | insert into document_mime_type(extension,mime_type) values ('p7m','application/x-pkcs7-mime');
 | 
        
           |  |  | 389 | insert into document_mime_type(extension,mime_type) values ('p7r','application/x-pkcs7-certreqresp');
 | 
        
           |  |  | 390 | insert into document_mime_type(extension,mime_type) values ('p7s','application/pkcs7-signature');
 | 
        
           |  |  | 391 | insert into document_mime_type(extension,mime_type) values ('part','application/pro_eng');
 | 
        
           |  |  | 392 | insert into document_mime_type(extension,mime_type) values ('pas','text/pascal');
 | 
        
           |  |  | 393 | insert into document_mime_type(extension,mime_type) values ('pbm','image/x-portable-bitmap');
 | 
        
           |  |  | 394 | insert into document_mime_type(extension,mime_type) values ('pcl','application/vnd.hp-pcl');
 | 
        
           |  |  | 395 | insert into document_mime_type(extension,mime_type) values ('pcl','application/x-pcl');
 | 
        
           |  |  | 396 | insert into document_mime_type(extension,mime_type) values ('pct','image/x-pict');
 | 
        
           |  |  | 397 | insert into document_mime_type(extension,mime_type) values ('pcx','image/x-pcx');
 | 
        
           |  |  | 398 | insert into document_mime_type(extension,mime_type) values ('pdb','chemical/x-pdb');
 | 
        
           |  |  | 399 | insert into document_mime_type(extension,mime_type) values ('pdf','application/pdf');
 | 
        
           |  |  | 400 | insert into document_mime_type(extension,mime_type) values ('pfunk','audio/make');
 | 
        
           |  |  | 401 | insert into document_mime_type(extension,mime_type) values ('pfunk','audio/make.my.funk');
 | 
        
           |  |  | 402 | insert into document_mime_type(extension,mime_type) values ('pgm','image/x-portable-graymap');
 | 
        
           |  |  | 403 | insert into document_mime_type(extension,mime_type) values ('pgm','image/x-portable-greymap');
 | 
        
           |  |  | 404 | insert into document_mime_type(extension,mime_type) values ('pic','image/pict');
 | 
        
           |  |  | 405 | insert into document_mime_type(extension,mime_type) values ('pict','image/pict');
 | 
        
           |  |  | 406 | insert into document_mime_type(extension,mime_type) values ('pkg','application/x-newton-compatible-pkg');
 | 
        
           |  |  | 407 | insert into document_mime_type(extension,mime_type) values ('pko','application/vnd.ms-pki.pko');
 | 
        
           |  |  | 408 | insert into document_mime_type(extension,mime_type) values ('pl','text/plain');
 | 
        
           |  |  | 409 | insert into document_mime_type(extension,mime_type) values ('pl','text/x-script.perl');
 | 
        
           |  |  | 410 | insert into document_mime_type(extension,mime_type) values ('plx','application/x-pixclscript');
 | 
        
           |  |  | 411 | insert into document_mime_type(extension,mime_type) values ('pm','image/x-xpixmap');
 | 
        
           |  |  | 412 | insert into document_mime_type(extension,mime_type) values ('pm','text/x-script.perl-module');
 | 
        
           |  |  | 413 | insert into document_mime_type(extension,mime_type) values ('pm4','application/x-pagemaker');
 | 
        
           |  |  | 414 | insert into document_mime_type(extension,mime_type) values ('pm5','application/x-pagemaker');
 | 
        
           |  |  | 415 | insert into document_mime_type(extension,mime_type) values ('png','image/png');
 | 
        
           |  |  | 416 | insert into document_mime_type(extension,mime_type) values ('pnm','application/x-portable-anymap');
 | 
        
           |  |  | 417 | insert into document_mime_type(extension,mime_type) values ('pnm','image/x-portable-anymap');
 | 
        
           |  |  | 418 | insert into document_mime_type(extension,mime_type) values ('pot','application/mspowerpoint');
 | 
        
           |  |  | 419 | insert into document_mime_type(extension,mime_type) values ('pot','application/vnd.ms-powerpoint');
 | 
        
           |  |  | 420 | insert into document_mime_type(extension,mime_type) values ('pov','model/x-pov');
 | 
        
           |  |  | 421 | insert into document_mime_type(extension,mime_type) values ('ppa','application/vnd.ms-powerpoint');
 | 
        
           |  |  | 422 | insert into document_mime_type(extension,mime_type) values ('ppm','image/x-portable-pixmap');
 | 
        
           |  |  | 423 | insert into document_mime_type(extension,mime_type) values ('pps','application/mspowerpoint');
 | 
        
           |  |  | 424 | insert into document_mime_type(extension,mime_type) values ('pps','application/vnd.ms-powerpoint');
 | 
        
           |  |  | 425 | insert into document_mime_type(extension,mime_type) values ('ppt','application/mspowerpoint');
 | 
        
           |  |  | 426 | insert into document_mime_type(extension,mime_type) values ('ppt','application/powerpoint');
 | 
        
           |  |  | 427 | insert into document_mime_type(extension,mime_type) values ('ppt','application/vnd.ms-powerpoint');
 | 
        
           |  |  | 428 | insert into document_mime_type(extension,mime_type) values ('ppt','application/x-mspowerpoint');
 | 
        
           |  |  | 429 | insert into document_mime_type(extension,mime_type) values ('ppz','application/mspowerpoint');
 | 
        
           |  |  | 430 | insert into document_mime_type(extension,mime_type) values ('pre','application/x-freelance');
 | 
        
           |  |  | 431 | insert into document_mime_type(extension,mime_type) values ('prt','application/pro_eng');
 | 
        
           |  |  | 432 | insert into document_mime_type(extension,mime_type) values ('ps','application/postscript');
 | 
        
           |  |  | 433 | insert into document_mime_type(extension,mime_type) values ('psd','application/octet-stream');
 | 
        
           |  |  | 434 | insert into document_mime_type(extension,mime_type) values ('pvu','paleovu/x-pv');
 | 
        
           |  |  | 435 | insert into document_mime_type(extension,mime_type) values ('pwz','application/vnd.ms-powerpoint');
 | 
        
           |  |  | 436 | insert into document_mime_type(extension,mime_type) values ('py','text/x-script.phyton');
 | 
        
           |  |  | 437 | insert into document_mime_type(extension,mime_type) values ('pyc','applicaiton/x-bytecode.python');
 | 
        
           |  |  | 438 | insert into document_mime_type(extension,mime_type) values ('qcp','audio/vnd.qcelp');
 | 
        
           |  |  | 439 | insert into document_mime_type(extension,mime_type) values ('qd3','x-world/x-3dmf');
 | 
        
           |  |  | 440 | insert into document_mime_type(extension,mime_type) values ('qd3d','x-world/x-3dmf');
 | 
        
           |  |  | 441 | insert into document_mime_type(extension,mime_type) values ('qif','image/x-quicktime');
 | 
        
           |  |  | 442 | insert into document_mime_type(extension,mime_type) values ('qt','video/quicktime');
 | 
        
           |  |  | 443 | insert into document_mime_type(extension,mime_type) values ('qtc','video/x-qtc');
 | 
        
           |  |  | 444 | insert into document_mime_type(extension,mime_type) values ('qti','image/x-quicktime');
 | 
        
           |  |  | 445 | insert into document_mime_type(extension,mime_type) values ('qtif','image/x-quicktime');
 | 
        
           |  |  | 446 | insert into document_mime_type(extension,mime_type) values ('ra','audio/x-pn-realaudio');
 | 
        
           |  |  | 447 | insert into document_mime_type(extension,mime_type) values ('ra','audio/x-pn-realaudio-plugin');
 | 
        
           |  |  | 448 | insert into document_mime_type(extension,mime_type) values ('ra','audio/x-realaudio');
 | 
        
           |  |  | 449 | insert into document_mime_type(extension,mime_type) values ('ram','audio/x-pn-realaudio');
 | 
        
           |  |  | 450 | insert into document_mime_type(extension,mime_type) values ('ras','application/x-cmu-raster');
 | 
        
           |  |  | 451 | insert into document_mime_type(extension,mime_type) values ('ras','image/cmu-raster');
 | 
        
           |  |  | 452 | insert into document_mime_type(extension,mime_type) values ('ras','image/x-cmu-raster');
 | 
        
           |  |  | 453 | insert into document_mime_type(extension,mime_type) values ('rast','image/cmu-raster');
 | 
        
           |  |  | 454 | insert into document_mime_type(extension,mime_type) values ('rexx','text/x-script.rexx');
 | 
        
           |  |  | 455 | insert into document_mime_type(extension,mime_type) values ('rf','image/vnd.rn-realflash');
 | 
        
           |  |  | 456 | insert into document_mime_type(extension,mime_type) values ('rgb','image/x-rgb');
 | 
        
           |  |  | 457 | insert into document_mime_type(extension,mime_type) values ('rm','application/vnd.rn-realmedia');
 | 
        
           |  |  | 458 | insert into document_mime_type(extension,mime_type) values ('rm','audio/x-pn-realaudio');
 | 
        
           |  |  | 459 | insert into document_mime_type(extension,mime_type) values ('rmi','audio/mid');
 | 
        
           |  |  | 460 | insert into document_mime_type(extension,mime_type) values ('rmm','audio/x-pn-realaudio');
 | 
        
           |  |  | 461 | insert into document_mime_type(extension,mime_type) values ('rmp','audio/x-pn-realaudio');
 | 
        
           |  |  | 462 | insert into document_mime_type(extension,mime_type) values ('rmp','audio/x-pn-realaudio-plugin');
 | 
        
           |  |  | 463 | insert into document_mime_type(extension,mime_type) values ('rng','application/ringing-tones');
 | 
        
           |  |  | 464 | insert into document_mime_type(extension,mime_type) values ('rng','application/vnd.nokia.ringing-tone');
 | 
        
           |  |  | 465 | insert into document_mime_type(extension,mime_type) values ('rnx','application/vnd.rn-realplayer');
 | 
        
           |  |  | 466 | insert into document_mime_type(extension,mime_type) values ('roff','application/x-troff');
 | 
        
           |  |  | 467 | insert into document_mime_type(extension,mime_type) values ('rp','image/vnd.rn-realpix');
 | 
        
           |  |  | 468 | insert into document_mime_type(extension,mime_type) values ('rpm','audio/x-pn-realaudio-plugin');
 | 
        
           |  |  | 469 | insert into document_mime_type(extension,mime_type) values ('rt','text/richtext');
 | 
        
           |  |  | 470 | insert into document_mime_type(extension,mime_type) values ('rt','text/vnd.rn-realtext');
 | 
        
           |  |  | 471 | insert into document_mime_type(extension,mime_type) values ('rtf','application/rtf');
 | 
        
           |  |  | 472 | insert into document_mime_type(extension,mime_type) values ('rtf','application/x-rtf');
 | 
        
           |  |  | 473 | insert into document_mime_type(extension,mime_type) values ('rtf','text/richtext');
 | 
        
           |  |  | 474 | insert into document_mime_type(extension,mime_type) values ('rtx','application/rtf');
 | 
        
           |  |  | 475 | insert into document_mime_type(extension,mime_type) values ('rtx','text/richtext');
 | 
        
           |  |  | 476 | insert into document_mime_type(extension,mime_type) values ('rv','video/vnd.rn-realvideo');
 | 
        
           |  |  | 477 | insert into document_mime_type(extension,mime_type) values ('s','text/x-asm');
 | 
        
           |  |  | 478 | insert into document_mime_type(extension,mime_type) values ('s3m','audio/s3m');
 | 
        
           |  |  | 479 | insert into document_mime_type(extension,mime_type) values ('saveme','application/octet-stream');
 | 
        
           |  |  | 480 | insert into document_mime_type(extension,mime_type) values ('sbk','application/x-tbook');
 | 
        
           |  |  | 481 | insert into document_mime_type(extension,mime_type) values ('scm','application/x-lotusscreencam');
 | 
        
           |  |  | 482 | insert into document_mime_type(extension,mime_type) values ('scm','text/x-script.guile');
 | 
        
           |  |  | 483 | insert into document_mime_type(extension,mime_type) values ('scm','text/x-script.scheme');
 | 
        
           |  |  | 484 | insert into document_mime_type(extension,mime_type) values ('scm','video/x-scm');
 | 
        
           |  |  | 485 | insert into document_mime_type(extension,mime_type) values ('sdml','text/plain');
 | 
        
           |  |  | 486 | insert into document_mime_type(extension,mime_type) values ('sdp','application/sdp');
 | 
        
           |  |  | 487 | insert into document_mime_type(extension,mime_type) values ('sdp','application/x-sdp');
 | 
        
           |  |  | 488 | insert into document_mime_type(extension,mime_type) values ('sdr','application/sounder');
 | 
        
           |  |  | 489 | insert into document_mime_type(extension,mime_type) values ('sea','application/sea');
 | 
        
           |  |  | 490 | insert into document_mime_type(extension,mime_type) values ('sea','application/x-sea');
 | 
        
           |  |  | 491 | insert into document_mime_type(extension,mime_type) values ('set','application/set');
 | 
        
           |  |  | 492 | insert into document_mime_type(extension,mime_type) values ('sgm','text/sgml');
 | 
        
           |  |  | 493 | insert into document_mime_type(extension,mime_type) values ('sgm','text/x-sgml');
 | 
        
           |  |  | 494 | insert into document_mime_type(extension,mime_type) values ('sgml','text/sgml');
 | 
        
           |  |  | 495 | insert into document_mime_type(extension,mime_type) values ('sgml','text/x-sgml');
 | 
        
           |  |  | 496 | insert into document_mime_type(extension,mime_type) values ('sh','application/x-bsh');
 | 
        
           |  |  | 497 | insert into document_mime_type(extension,mime_type) values ('sh','application/x-sh');
 | 
        
           |  |  | 498 | insert into document_mime_type(extension,mime_type) values ('sh','application/x-shar');
 | 
        
           |  |  | 499 | insert into document_mime_type(extension,mime_type) values ('sh','text/x-script.sh');
 | 
        
           |  |  | 500 | insert into document_mime_type(extension,mime_type) values ('shar','application/x-bsh');
 | 
        
           |  |  | 501 | insert into document_mime_type(extension,mime_type) values ('shar','application/x-shar');
 | 
        
           |  |  | 502 | insert into document_mime_type(extension,mime_type) values ('shtml','text/html');
 | 
        
           |  |  | 503 | insert into document_mime_type(extension,mime_type) values ('shtml','text/x-server-parsed-html');
 | 
        
           |  |  | 504 | insert into document_mime_type(extension,mime_type) values ('sid','audio/x-psid');
 | 
        
           |  |  | 505 | insert into document_mime_type(extension,mime_type) values ('sit','application/x-sit');
 | 
        
           |  |  | 506 | insert into document_mime_type(extension,mime_type) values ('sit','application/x-stuffit');
 | 
        
           |  |  | 507 | insert into document_mime_type(extension,mime_type) values ('skd','application/x-koan');
 | 
        
           |  |  | 508 | insert into document_mime_type(extension,mime_type) values ('skm','application/x-koan');
 | 
        
           |  |  | 509 | insert into document_mime_type(extension,mime_type) values ('skp','application/x-koan');
 | 
        
           |  |  | 510 | insert into document_mime_type(extension,mime_type) values ('skt','application/x-koan');
 | 
        
           |  |  | 511 | insert into document_mime_type(extension,mime_type) values ('sl','application/x-seelogo');
 | 
        
           |  |  | 512 | insert into document_mime_type(extension,mime_type) values ('smi','application/smil');
 | 
        
           |  |  | 513 | insert into document_mime_type(extension,mime_type) values ('smil','application/smil');
 | 
        
           |  |  | 514 | insert into document_mime_type(extension,mime_type) values ('snd','audio/basic');
 | 
        
           |  |  | 515 | insert into document_mime_type(extension,mime_type) values ('snd','audio/x-adpcm');
 | 
        
           |  |  | 516 | insert into document_mime_type(extension,mime_type) values ('sol','application/solids');
 | 
        
           |  |  | 517 | insert into document_mime_type(extension,mime_type) values ('spc','application/x-pkcs7-certificates');
 | 
        
           |  |  | 518 | insert into document_mime_type(extension,mime_type) values ('spc','text/x-speech');
 | 
        
           |  |  | 519 | insert into document_mime_type(extension,mime_type) values ('spl','application/futuresplash');
 | 
        
           |  |  | 520 | insert into document_mime_type(extension,mime_type) values ('spr','application/x-sprite');
 | 
        
           |  |  | 521 | insert into document_mime_type(extension,mime_type) values ('sprite','application/x-sprite');
 | 
        
           |  |  | 522 | insert into document_mime_type(extension,mime_type) values ('src','application/x-wais-source');
 | 
        
           |  |  | 523 | insert into document_mime_type(extension,mime_type) values ('ssi','text/x-server-parsed-html');
 | 
        
           |  |  | 524 | insert into document_mime_type(extension,mime_type) values ('ssm','application/streamingmedia');
 | 
        
           |  |  | 525 | insert into document_mime_type(extension,mime_type) values ('sst','application/vnd.ms-pki.certstore');
 | 
        
           |  |  | 526 | insert into document_mime_type(extension,mime_type) values ('step','application/step');
 | 
        
           |  |  | 527 | insert into document_mime_type(extension,mime_type) values ('stl','application/sla');
 | 
        
           |  |  | 528 | insert into document_mime_type(extension,mime_type) values ('stl','application/vnd.ms-pki.stl');
 | 
        
           |  |  | 529 | insert into document_mime_type(extension,mime_type) values ('stl','application/x-navistyle');
 | 
        
           |  |  | 530 | insert into document_mime_type(extension,mime_type) values ('stp','application/step');
 | 
        
           |  |  | 531 | insert into document_mime_type(extension,mime_type) values ('sv4cpio','application/x-sv4cpio');
 | 
        
           |  |  | 532 | insert into document_mime_type(extension,mime_type) values ('sv4crc','application/x-sv4crc');
 | 
        
           |  |  | 533 | insert into document_mime_type(extension,mime_type) values ('svf','image/vnd.dwg');
 | 
        
           |  |  | 534 | insert into document_mime_type(extension,mime_type) values ('svf','image/x-dwg');
 | 
        
           |  |  | 535 | insert into document_mime_type(extension,mime_type) values ('svr','application/x-world');
 | 
        
           |  |  | 536 | insert into document_mime_type(extension,mime_type) values ('svr','x-world/x-svr');
 | 
        
           |  |  | 537 | insert into document_mime_type(extension,mime_type) values ('swf','application/x-shockwave-flash');
 | 
        
           |  |  | 538 | insert into document_mime_type(extension,mime_type) values ('t','application/x-troff');
 | 
        
           |  |  | 539 | insert into document_mime_type(extension,mime_type) values ('talk','text/x-speech');
 | 
        
           |  |  | 540 | insert into document_mime_type(extension,mime_type) values ('tar','application/x-tar');
 | 
        
           |  |  | 541 | insert into document_mime_type(extension,mime_type) values ('tbk','application/toolbook');
 | 
        
           |  |  | 542 | insert into document_mime_type(extension,mime_type) values ('tbk','application/x-tbook');
 | 
        
           |  |  | 543 | insert into document_mime_type(extension,mime_type) values ('tcl','application/x-tcl');
 | 
        
           |  |  | 544 | insert into document_mime_type(extension,mime_type) values ('tcl','text/x-script.tcl');
 | 
        
           |  |  | 545 | insert into document_mime_type(extension,mime_type) values ('tcsh','text/x-script.tcsh');
 | 
        
           |  |  | 546 | insert into document_mime_type(extension,mime_type) values ('tex','application/x-tex');
 | 
        
           |  |  | 547 | insert into document_mime_type(extension,mime_type) values ('texi','application/x-texinfo');
 | 
        
           |  |  | 548 | insert into document_mime_type(extension,mime_type) values ('texinfo','application/x-texinfo');
 | 
        
           |  |  | 549 | insert into document_mime_type(extension,mime_type) values ('text','application/plain');
 | 
        
           |  |  | 550 | insert into document_mime_type(extension,mime_type) values ('text','text/plain');
 | 
        
           |  |  | 551 | insert into document_mime_type(extension,mime_type) values ('tgz','application/gnutar');
 | 
        
           |  |  | 552 | insert into document_mime_type(extension,mime_type) values ('tgz','application/x-compressed');
 | 
        
           |  |  | 553 | insert into document_mime_type(extension,mime_type) values ('tif','image/tiff');
 | 
        
           |  |  | 554 | insert into document_mime_type(extension,mime_type) values ('tif','image/x-tiff');
 | 
        
           |  |  | 555 | insert into document_mime_type(extension,mime_type) values ('tiff','image/tiff');
 | 
        
           |  |  | 556 | insert into document_mime_type(extension,mime_type) values ('tiff','image/x-tiff');
 | 
        
           |  |  | 557 | insert into document_mime_type(extension,mime_type) values ('tr','application/x-troff');
 | 
        
           |  |  | 558 | insert into document_mime_type(extension,mime_type) values ('tsi','audio/tsp-audio');
 | 
        
           |  |  | 559 | insert into document_mime_type(extension,mime_type) values ('tsp','application/dsptype');
 | 
        
           |  |  | 560 | insert into document_mime_type(extension,mime_type) values ('tsp','audio/tsplayer');
 | 
        
           |  |  | 561 | insert into document_mime_type(extension,mime_type) values ('tsv','text/tab-separated-values');
 | 
        
           |  |  | 562 | insert into document_mime_type(extension,mime_type) values ('turbot','image/florian');
 | 
        
           |  |  | 563 | insert into document_mime_type(extension,mime_type) values ('txt','text/plain');
 | 
        
           |  |  | 564 | insert into document_mime_type(extension,mime_type) values ('uil','text/x-uil');
 | 
        
           |  |  | 565 | insert into document_mime_type(extension,mime_type) values ('uni','text/uri-list');
 | 
        
           |  |  | 566 | insert into document_mime_type(extension,mime_type) values ('unis','text/uri-list');
 | 
        
           |  |  | 567 | insert into document_mime_type(extension,mime_type) values ('unv','application/i-deas');
 | 
        
           |  |  | 568 | insert into document_mime_type(extension,mime_type) values ('uri','text/uri-list');
 | 
        
           |  |  | 569 | insert into document_mime_type(extension,mime_type) values ('uris','text/uri-list');
 | 
        
           |  |  | 570 | insert into document_mime_type(extension,mime_type) values ('ustar','application/x-ustar');
 | 
        
           |  |  | 571 | insert into document_mime_type(extension,mime_type) values ('ustar','multipart/x-ustar');
 | 
        
           |  |  | 572 | insert into document_mime_type(extension,mime_type) values ('uu','application/octet-stream');
 | 
        
           |  |  | 573 | insert into document_mime_type(extension,mime_type) values ('uu','text/x-uuencode');
 | 
        
           |  |  | 574 | insert into document_mime_type(extension,mime_type) values ('uue','text/x-uuencode');
 | 
        
           |  |  | 575 | insert into document_mime_type(extension,mime_type) values ('vcd','application/x-cdlink');
 | 
        
           |  |  | 576 | insert into document_mime_type(extension,mime_type) values ('vcs','text/x-vcalendar');
 | 
        
           |  |  | 577 | insert into document_mime_type(extension,mime_type) values ('vda','application/vda');
 | 
        
           |  |  | 578 | insert into document_mime_type(extension,mime_type) values ('vdo','video/vdo');
 | 
        
           |  |  | 579 | insert into document_mime_type(extension,mime_type) values ('vew','application/groupwise');
 | 
        
           |  |  | 580 | insert into document_mime_type(extension,mime_type) values ('viv','video/vivo');
 | 
        
           |  |  | 581 | insert into document_mime_type(extension,mime_type) values ('viv','video/vnd.vivo');
 | 
        
           |  |  | 582 | insert into document_mime_type(extension,mime_type) values ('vivo','video/vivo');
 | 
        
           |  |  | 583 | insert into document_mime_type(extension,mime_type) values ('vivo','video/vnd.vivo');
 | 
        
           |  |  | 584 | insert into document_mime_type(extension,mime_type) values ('vmd','application/vocaltec-media-desc');
 | 
        
           |  |  | 585 | insert into document_mime_type(extension,mime_type) values ('vmf','application/vocaltec-media-file');
 | 
        
           |  |  | 586 | insert into document_mime_type(extension,mime_type) values ('voc','audio/voc');
 | 
        
           |  |  | 587 | insert into document_mime_type(extension,mime_type) values ('voc','audio/x-voc');
 | 
        
           |  |  | 588 | insert into document_mime_type(extension,mime_type) values ('vos','video/vosaic');
 | 
        
           |  |  | 589 | insert into document_mime_type(extension,mime_type) values ('vox','audio/voxware');
 | 
        
           |  |  | 590 | insert into document_mime_type(extension,mime_type) values ('vqe','audio/x-twinvq-plugin');
 | 
        
           |  |  | 591 | insert into document_mime_type(extension,mime_type) values ('vqf','audio/x-twinvq');
 | 
        
           |  |  | 592 | insert into document_mime_type(extension,mime_type) values ('vql','audio/x-twinvq-plugin');
 | 
        
           |  |  | 593 | insert into document_mime_type(extension,mime_type) values ('vrml','application/x-vrml');
 | 
        
           |  |  | 594 | insert into document_mime_type(extension,mime_type) values ('vrml','model/vrml');
 | 
        
           |  |  | 595 | insert into document_mime_type(extension,mime_type) values ('vrml','x-world/x-vrml');
 | 
        
           |  |  | 596 | insert into document_mime_type(extension,mime_type) values ('vrt','x-world/x-vrt');
 | 
        
           |  |  | 597 | insert into document_mime_type(extension,mime_type) values ('vsd','application/x-visio');
 | 
        
           |  |  | 598 | insert into document_mime_type(extension,mime_type) values ('vst','application/x-visio');
 | 
        
           |  |  | 599 | insert into document_mime_type(extension,mime_type) values ('vsw','application/x-visio');
 | 
        
           |  |  | 600 | insert into document_mime_type(extension,mime_type) values ('w60','application/wordperfect6.0');
 | 
        
           |  |  | 601 | insert into document_mime_type(extension,mime_type) values ('w61','application/wordperfect6.1');
 | 
        
           |  |  | 602 | insert into document_mime_type(extension,mime_type) values ('w6w','application/msword');
 | 
        
           |  |  | 603 | insert into document_mime_type(extension,mime_type) values ('wav','audio/wav');
 | 
        
           |  |  | 604 | insert into document_mime_type(extension,mime_type) values ('wav','audio/x-wav');
 | 
        
           |  |  | 605 | insert into document_mime_type(extension,mime_type) values ('wb1','application/x-qpro');
 | 
        
           |  |  | 606 | insert into document_mime_type(extension,mime_type) values ('wbmp','image/vnd.wap.wbmp');
 | 
        
           |  |  | 607 | insert into document_mime_type(extension,mime_type) values ('web','application/vnd.xara');
 | 
        
           |  |  | 608 | insert into document_mime_type(extension,mime_type) values ('wiz','application/msword');
 | 
        
           |  |  | 609 | insert into document_mime_type(extension,mime_type) values ('wk1','application/x-123');
 | 
        
           |  |  | 610 | insert into document_mime_type(extension,mime_type) values ('wmf','windows/metafile');
 | 
        
           |  |  | 611 | insert into document_mime_type(extension,mime_type) values ('wml','text/vnd.wap.wml');
 | 
        
           |  |  | 612 | insert into document_mime_type(extension,mime_type) values ('wmlc','application/vnd.wap.wmlc');
 | 
        
           |  |  | 613 | insert into document_mime_type(extension,mime_type) values ('wmls','text/vnd.wap.wmlscript');
 | 
        
           |  |  | 614 | insert into document_mime_type(extension,mime_type) values ('wmlsc','application/vnd.wap.wmlscriptc');
 | 
        
           |  |  | 615 | insert into document_mime_type(extension,mime_type) values ('word','application/msword');
 | 
        
           |  |  | 616 | insert into document_mime_type(extension,mime_type) values ('wp','application/wordperfect');
 | 
        
           |  |  | 617 | insert into document_mime_type(extension,mime_type) values ('wp5','application/wordperfect');
 | 
        
           |  |  | 618 | insert into document_mime_type(extension,mime_type) values ('wp5','application/wordperfect6.0');
 | 
        
           |  |  | 619 | insert into document_mime_type(extension,mime_type) values ('wp6','application/wordperfect');
 | 
        
           |  |  | 620 | insert into document_mime_type(extension,mime_type) values ('wpd','application/wordperfect');
 | 
        
           |  |  | 621 | insert into document_mime_type(extension,mime_type) values ('wpd','application/x-wpwin');
 | 
        
           |  |  | 622 | insert into document_mime_type(extension,mime_type) values ('wq1','application/x-lotus');
 | 
        
           |  |  | 623 | insert into document_mime_type(extension,mime_type) values ('wri','application/mswrite');
 | 
        
           |  |  | 624 | insert into document_mime_type(extension,mime_type) values ('wri','application/x-wri');
 | 
        
           |  |  | 625 | insert into document_mime_type(extension,mime_type) values ('wrl','application/x-world');
 | 
        
           |  |  | 626 | insert into document_mime_type(extension,mime_type) values ('wrl','model/vrml');
 | 
        
           |  |  | 627 | insert into document_mime_type(extension,mime_type) values ('wrl','x-world/x-vrml');
 | 
        
           |  |  | 628 | insert into document_mime_type(extension,mime_type) values ('wrz','model/vrml');
 | 
        
           |  |  | 629 | insert into document_mime_type(extension,mime_type) values ('wrz','x-world/x-vrml');
 | 
        
           |  |  | 630 | insert into document_mime_type(extension,mime_type) values ('wsc','text/scriplet');
 | 
        
           |  |  | 631 | insert into document_mime_type(extension,mime_type) values ('wsrc','application/x-wais-source');
 | 
        
           |  |  | 632 | insert into document_mime_type(extension,mime_type) values ('wtk','application/x-wintalk');
 | 
        
           |  |  | 633 | insert into document_mime_type(extension,mime_type) values ('xbm','image/x-xbitmap');
 | 
        
           |  |  | 634 | insert into document_mime_type(extension,mime_type) values ('xbm','image/x-xbm');
 | 
        
           |  |  | 635 | insert into document_mime_type(extension,mime_type) values ('xbm','image/xbm');
 | 
        
           |  |  | 636 | insert into document_mime_type(extension,mime_type) values ('xdr','video/x-amt-demorun');
 | 
        
           |  |  | 637 | insert into document_mime_type(extension,mime_type) values ('xgz','xgl/drawing');
 | 
        
           |  |  | 638 | insert into document_mime_type(extension,mime_type) values ('xif','image/vnd.xiff');
 | 
        
           |  |  | 639 | insert into document_mime_type(extension,mime_type) values ('xl','application/excel');
 | 
        
           |  |  | 640 | insert into document_mime_type(extension,mime_type) values ('xla','application/excel');
 | 
        
           |  |  | 641 | insert into document_mime_type(extension,mime_type) values ('xla','application/x-excel');
 | 
        
           |  |  | 642 | insert into document_mime_type(extension,mime_type) values ('xla','application/x-msexcel');
 | 
        
           |  |  | 643 | insert into document_mime_type(extension,mime_type) values ('xlb','application/excel');
 | 
        
           |  |  | 644 | insert into document_mime_type(extension,mime_type) values ('xlb','application/vnd.ms-excel');
 | 
        
           |  |  | 645 | insert into document_mime_type(extension,mime_type) values ('xlb','application/x-excel');
 | 
        
           |  |  | 646 | insert into document_mime_type(extension,mime_type) values ('xlc','application/excel');
 | 
        
           |  |  | 647 | insert into document_mime_type(extension,mime_type) values ('xlc','application/vnd.ms-excel');
 | 
        
           |  |  | 648 | insert into document_mime_type(extension,mime_type) values ('xlc','application/x-excel');
 | 
        
           |  |  | 649 | insert into document_mime_type(extension,mime_type) values ('xld','application/excel');
 | 
        
           |  |  | 650 | insert into document_mime_type(extension,mime_type) values ('xld','application/x-excel');
 | 
        
           |  |  | 651 | insert into document_mime_type(extension,mime_type) values ('xlk','application/excel');
 | 
        
           |  |  | 652 | insert into document_mime_type(extension,mime_type) values ('xlk','application/x-excel');
 | 
        
           |  |  | 653 | insert into document_mime_type(extension,mime_type) values ('xll','application/excel');
 | 
        
           |  |  | 654 | insert into document_mime_type(extension,mime_type) values ('xll','application/vnd.ms-excel');
 | 
        
           |  |  | 655 | insert into document_mime_type(extension,mime_type) values ('xll','application/x-excel');
 | 
        
           |  |  | 656 | insert into document_mime_type(extension,mime_type) values ('xlm','application/excel');
 | 
        
           |  |  | 657 | insert into document_mime_type(extension,mime_type) values ('xlm','application/vnd.ms-excel');
 | 
        
           |  |  | 658 | insert into document_mime_type(extension,mime_type) values ('xlm','application/x-excel');
 | 
        
           |  |  | 659 | insert into document_mime_type(extension,mime_type) values ('xls','application/excel');
 | 
        
           |  |  | 660 | insert into document_mime_type(extension,mime_type) values ('xls','application/vnd.ms-excel');
 | 
        
           |  |  | 661 | insert into document_mime_type(extension,mime_type) values ('xls','application/x-excel');
 | 
        
           |  |  | 662 | insert into document_mime_type(extension,mime_type) values ('xls','application/x-msexcel');
 | 
        
           |  |  | 663 | insert into document_mime_type(extension,mime_type) values ('xlt','application/excel');
 | 
        
           |  |  | 664 | insert into document_mime_type(extension,mime_type) values ('xlt','application/x-excel');
 | 
        
           |  |  | 665 | insert into document_mime_type(extension,mime_type) values ('xlv','application/excel');
 | 
        
           |  |  | 666 | insert into document_mime_type(extension,mime_type) values ('xlv','application/x-excel');
 | 
        
           |  |  | 667 | insert into document_mime_type(extension,mime_type) values ('xlw','application/excel');
 | 
        
           |  |  | 668 | insert into document_mime_type(extension,mime_type) values ('xlw','application/vnd.ms-excel');
 | 
        
           |  |  | 669 | insert into document_mime_type(extension,mime_type) values ('xlw','application/x-excel');
 | 
        
           |  |  | 670 | insert into document_mime_type(extension,mime_type) values ('xlw','application/x-msexcel');
 | 
        
           |  |  | 671 | insert into document_mime_type(extension,mime_type) values ('xm','audio/xm');
 | 
        
           |  |  | 672 | insert into document_mime_type(extension,mime_type) values ('xml','application/xml');
 | 
        
           |  |  | 673 | insert into document_mime_type(extension,mime_type) values ('xml','text/xml');
 | 
        
           |  |  | 674 | insert into document_mime_type(extension,mime_type) values ('xmz','xgl/movie');
 | 
        
           |  |  | 675 | insert into document_mime_type(extension,mime_type) values ('xpix','application/x-vnd.ls-xpix');
 | 
        
           |  |  | 676 | insert into document_mime_type(extension,mime_type) values ('xpm','image/x-xpixmap');
 | 
        
           |  |  | 677 | insert into document_mime_type(extension,mime_type) values ('xpm','image/xpm');
 | 
        
           |  |  | 678 | insert into document_mime_type(extension,mime_type) values ('x-png','image/png');
 | 
        
           |  |  | 679 | insert into document_mime_type(extension,mime_type) values ('xsr','video/x-amt-showrun');
 | 
        
           |  |  | 680 | insert into document_mime_type(extension,mime_type) values ('xwd','image/x-xwd');
 | 
        
           |  |  | 681 | insert into document_mime_type(extension,mime_type) values ('xwd','image/x-xwindowdump');
 | 
        
           |  |  | 682 | insert into document_mime_type(extension,mime_type) values ('xyz','chemical/x-pdb');
 | 
        
           |  |  | 683 | insert into document_mime_type(extension,mime_type) values ('z','application/x-compress');
 | 
        
           |  |  | 684 | insert into document_mime_type(extension,mime_type) values ('z','application/x-compressed');
 | 
        
           |  |  | 685 | insert into document_mime_type(extension,mime_type) values ('zip','application/x-compressed');
 | 
        
           |  |  | 686 | insert into document_mime_type(extension,mime_type) values ('zip','application/x-zip-compressed');
 | 
        
           |  |  | 687 | insert into document_mime_type(extension,mime_type) values ('zip','application/zip');
 | 
        
           |  |  | 688 | insert into document_mime_type(extension,mime_type) values ('zip','multipart/x-zip');
 | 
        
           |  |  | 689 | insert into document_mime_type(extension,mime_type) values ('zoo','application/octet-stream');
 | 
        
           |  |  | 690 | insert into document_mime_type(extension,mime_type) values ('zsh','text/x-script.zsh');
 |