Subversion Repositories computer_asset_manager_v1

Rev

Rev 58 | Details | Compare with Previous | Last modification | View Log | RSS feed

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