Subversion Repositories computer_asset_manager_v1

Rev

Rev 56 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

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