Subversion Repositories computer_asset_manager_v1

drop table if exists document;

create table document (

   document_id             int unsigned not null auto_increment,

   name                    varchar(64) comment 'the visible, displayed name',

   owner_type              char default 'd' comment 'determines if the owner is from the client, site or device table', 

   owner_id                int unsigned not null comment 'the client_id, site_id or device_id of the owner',

   description             text comment 'A brief (or long) description of this document',

   document_mime_type_id   int unsigned default null references document_mime_type (document_mime_type_id),

   name_on_disk            varchar(128) comment 'link to a file on the disk',

   added_date              date comment 'date record was added',

   removed_date            date comment 'date record was deleted/supserceded',

   primary key             (document_id)

) comment 'Stores documents for clients, sites, devices and networks';

drop table if exists document_link;

drop table if exists document_mime_type;

create table document_mime_type (

   document_mime_type_id   int unsigned not null auto_increment,

   mime_type               varchar(64) comment 'The standardized mime type',

   extension               varchar(10) comment 'a file name extension commonly associated with this file',

   primary key             (document_mime_type_id)

) comment 'Just a list of some common mime types';

insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'Documents', 'modules/documents/', now() );

/* location on disk where actual files will be stored */

insert into _system ( group_name,key_name,theValue,added_date) values ( 'Documents', 'root path', 'modules/documents/file_storage', now() );

create or replace view client_documents as select * from document where owner_type = 'c';

create or replace view site_documents as select * from document where owner_type = 's';

create or replace view device_documents as select * from document where owner_type = 'd';

/* Menu Options */

insert into menu( url, caption, parent_id) values ('/modules/documents/index.html', 'Documents', null);

insert into menu( url,caption,parent_id) select '/modules/documents/upload_document.html','Add A Document',menu_id from menu where caption = 'Documents';

insert into menu( url,caption,parent_id) select '/modules/documents/view_document.html','View A Document',menu_id from menu where caption = 'Documents';

/* Reports */

/* a list of 642 well known mime types */

insert into document_mime_type(extension,mime_type) values ('3dm','x-world/x-3dmf');

insert into document_mime_type(extension,mime_type) values ('3dmf','x-world/x-3dmf');

insert into document_mime_type(extension,mime_type) values ('a','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('aab','application/x-authorware-bin');

insert into document_mime_type(extension,mime_type) values ('aam','application/x-authorware-map');

insert into document_mime_type(extension,mime_type) values ('aas','application/x-authorware-seg');

insert into document_mime_type(extension,mime_type) values ('abc','text/vnd.abc');

insert into document_mime_type(extension,mime_type) values ('acgi','text/html');

insert into document_mime_type(extension,mime_type) values ('afl','video/animaflex');

insert into document_mime_type(extension,mime_type) values ('ai','application/postscript');

insert into document_mime_type(extension,mime_type) values ('aif','audio/aiff');

insert into document_mime_type(extension,mime_type) values ('aif','audio/x-aiff');

insert into document_mime_type(extension,mime_type) values ('aifc','audio/aiff');

insert into document_mime_type(extension,mime_type) values ('aifc','audio/x-aiff');

insert into document_mime_type(extension,mime_type) values ('aiff','audio/aiff');

insert into document_mime_type(extension,mime_type) values ('aiff','audio/x-aiff');

insert into document_mime_type(extension,mime_type) values ('aim','application/x-aim');

insert into document_mime_type(extension,mime_type) values ('aip','text/x-audiosoft-intra');

insert into document_mime_type(extension,mime_type) values ('ani','application/x-navi-animation');

insert into document_mime_type(extension,mime_type) values ('aos','application/x-nokia-9000-communicator-add-on-software');

insert into document_mime_type(extension,mime_type) values ('aps','application/mime');

insert into document_mime_type(extension,mime_type) values ('arc','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('arj','application/arj');

insert into document_mime_type(extension,mime_type) values ('arj','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('art','image/x-jg');

insert into document_mime_type(extension,mime_type) values ('asf','video/x-ms-asf');

insert into document_mime_type(extension,mime_type) values ('asm','text/x-asm');

insert into document_mime_type(extension,mime_type) values ('asp','text/asp');

insert into document_mime_type(extension,mime_type) values ('asx','application/x-mplayer2');

insert into document_mime_type(extension,mime_type) values ('asx','video/x-ms-asf');

insert into document_mime_type(extension,mime_type) values ('asx','video/x-ms-asf-plugin');

insert into document_mime_type(extension,mime_type) values ('au','audio/basic');

insert into document_mime_type(extension,mime_type) values ('au','audio/x-au');

insert into document_mime_type(extension,mime_type) values ('avi','application/x-troff-msvideo');

insert into document_mime_type(extension,mime_type) values ('avi','video/avi');

insert into document_mime_type(extension,mime_type) values ('avi','video/msvideo');

insert into document_mime_type(extension,mime_type) values ('avi','video/x-msvideo');

insert into document_mime_type(extension,mime_type) values ('avs','video/avs-video');

insert into document_mime_type(extension,mime_type) values ('bcpio','application/x-bcpio');

insert into document_mime_type(extension,mime_type) values ('bin','application/mac-binary');

insert into document_mime_type(extension,mime_type) values ('bin','application/macbinary');

insert into document_mime_type(extension,mime_type) values ('bin','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('bin','application/x-binary');

insert into document_mime_type(extension,mime_type) values ('bin','application/x-macbinary');

insert into document_mime_type(extension,mime_type) values ('bm','image/bmp');

insert into document_mime_type(extension,mime_type) values ('bmp','image/bmp');

insert into document_mime_type(extension,mime_type) values ('bmp','image/x-windows-bmp');

insert into document_mime_type(extension,mime_type) values ('boo','application/book');

insert into document_mime_type(extension,mime_type) values ('book','application/book');

insert into document_mime_type(extension,mime_type) values ('boz','application/x-bzip2');

insert into document_mime_type(extension,mime_type) values ('bsh','application/x-bsh');

insert into document_mime_type(extension,mime_type) values ('bz','application/x-bzip');

insert into document_mime_type(extension,mime_type) values ('bz2','application/x-bzip2');

insert into document_mime_type(extension,mime_type) values ('c','text/plain');

insert into document_mime_type(extension,mime_type) values ('c','text/x-c');

insert into document_mime_type(extension,mime_type) values ('c++','text/plain');

insert into document_mime_type(extension,mime_type) values ('cat','application/vnd.ms-pki.seccat');

insert into document_mime_type(extension,mime_type) values ('cc','text/plain');

insert into document_mime_type(extension,mime_type) values ('cc','text/x-c');

insert into document_mime_type(extension,mime_type) values ('ccad','application/clariscad');

insert into document_mime_type(extension,mime_type) values ('cco','application/x-cocoa');

insert into document_mime_type(extension,mime_type) values ('cdf','application/cdf');

insert into document_mime_type(extension,mime_type) values ('cdf','application/x-cdf');

insert into document_mime_type(extension,mime_type) values ('cdf','application/x-netcdf');

insert into document_mime_type(extension,mime_type) values ('cer','application/pkix-cert');

insert into document_mime_type(extension,mime_type) values ('cer','application/x-x509-ca-cert');

insert into document_mime_type(extension,mime_type) values ('cha','application/x-chat');

insert into document_mime_type(extension,mime_type) values ('chat','application/x-chat');

insert into document_mime_type(extension,mime_type) values ('class','application/java');

insert into document_mime_type(extension,mime_type) values ('class','application/java-byte-code');

insert into document_mime_type(extension,mime_type) values ('class','application/x-java-class');

insert into document_mime_type(extension,mime_type) values ('com','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('com','text/plain');

insert into document_mime_type(extension,mime_type) values ('conf','text/plain');

insert into document_mime_type(extension,mime_type) values ('cpio','application/x-cpio');

insert into document_mime_type(extension,mime_type) values ('cpp','text/x-c');

insert into document_mime_type(extension,mime_type) values ('cpt','application/mac-compactpro');

insert into document_mime_type(extension,mime_type) values ('cpt','application/x-compactpro');

insert into document_mime_type(extension,mime_type) values ('cpt','application/x-cpt');

insert into document_mime_type(extension,mime_type) values ('crl','application/pkcs-crl');

insert into document_mime_type(extension,mime_type) values ('crl','application/pkix-crl');

insert into document_mime_type(extension,mime_type) values ('crt','application/pkix-cert');

insert into document_mime_type(extension,mime_type) values ('crt','application/x-x509-ca-cert');

insert into document_mime_type(extension,mime_type) values ('crt','application/x-x509-user-cert');

insert into document_mime_type(extension,mime_type) values ('csh','application/x-csh');

insert into document_mime_type(extension,mime_type) values ('csh','text/x-script.csh');

insert into document_mime_type(extension,mime_type) values ('css','application/x-pointplus');

insert into document_mime_type(extension,mime_type) values ('css','text/css');

insert into document_mime_type(extension,mime_type) values ('cxx','text/plain');

insert into document_mime_type(extension,mime_type) values ('dcr','application/x-director');

insert into document_mime_type(extension,mime_type) values ('deepv','application/x-deepv');

insert into document_mime_type(extension,mime_type) values ('def','text/plain');

insert into document_mime_type(extension,mime_type) values ('der','application/x-x509-ca-cert');

insert into document_mime_type(extension,mime_type) values ('dif','video/x-dv');

insert into document_mime_type(extension,mime_type) values ('dir','application/x-director');

insert into document_mime_type(extension,mime_type) values ('dl','video/dl');

insert into document_mime_type(extension,mime_type) values ('dl','video/x-dl');

insert into document_mime_type(extension,mime_type) values ('doc','application/msword');

insert into document_mime_type(extension,mime_type) values ('dot','application/msword');

insert into document_mime_type(extension,mime_type) values ('dp','application/commonground');

insert into document_mime_type(extension,mime_type) values ('drw','application/drafting');

insert into document_mime_type(extension,mime_type) values ('dump','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('dv','video/x-dv');

insert into document_mime_type(extension,mime_type) values ('dvi','application/x-dvi');

insert into document_mime_type(extension,mime_type) values ('dwf','drawing/x-dwf (old)');

insert into document_mime_type(extension,mime_type) values ('dwf','model/vnd.dwf');

insert into document_mime_type(extension,mime_type) values ('dwg','application/acad');

insert into document_mime_type(extension,mime_type) values ('dwg','image/vnd.dwg');

insert into document_mime_type(extension,mime_type) values ('dwg','image/x-dwg');

insert into document_mime_type(extension,mime_type) values ('dxf','application/dxf');

insert into document_mime_type(extension,mime_type) values ('dxf','image/vnd.dwg');

insert into document_mime_type(extension,mime_type) values ('dxf','image/x-dwg');

insert into document_mime_type(extension,mime_type) values ('dxr','application/x-director');

insert into document_mime_type(extension,mime_type) values ('el','text/x-script.elisp');

insert into document_mime_type(extension,mime_type) values ('elc','application/x-bytecode.elisp (compiled elisp)');

insert into document_mime_type(extension,mime_type) values ('elc','application/x-elc');

insert into document_mime_type(extension,mime_type) values ('env','application/x-envoy');

insert into document_mime_type(extension,mime_type) values ('eps','application/postscript');

insert into document_mime_type(extension,mime_type) values ('es','application/x-esrehber');

insert into document_mime_type(extension,mime_type) values ('etx','text/x-setext');

insert into document_mime_type(extension,mime_type) values ('evy','application/envoy');

insert into document_mime_type(extension,mime_type) values ('evy','application/x-envoy');

insert into document_mime_type(extension,mime_type) values ('exe','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('f','text/plain');

insert into document_mime_type(extension,mime_type) values ('f','text/x-fortran');

insert into document_mime_type(extension,mime_type) values ('f77','text/x-fortran');

insert into document_mime_type(extension,mime_type) values ('f90','text/plain');

insert into document_mime_type(extension,mime_type) values ('f90','text/x-fortran');

insert into document_mime_type(extension,mime_type) values ('fdf','application/vnd.fdf');

insert into document_mime_type(extension,mime_type) values ('fif','application/fractals');

insert into document_mime_type(extension,mime_type) values ('fif','image/fif');

insert into document_mime_type(extension,mime_type) values ('fli','video/fli');

insert into document_mime_type(extension,mime_type) values ('fli','video/x-fli');

insert into document_mime_type(extension,mime_type) values ('flo','image/florian');

insert into document_mime_type(extension,mime_type) values ('flx','text/vnd.fmi.flexstor');

insert into document_mime_type(extension,mime_type) values ('fmf','video/x-atomic3d-feature');

insert into document_mime_type(extension,mime_type) values ('for','text/plain');

insert into document_mime_type(extension,mime_type) values ('for','text/x-fortran');

insert into document_mime_type(extension,mime_type) values ('fpx','image/vnd.fpx');

insert into document_mime_type(extension,mime_type) values ('fpx','image/vnd.net-fpx');

insert into document_mime_type(extension,mime_type) values ('frl','application/freeloader');

insert into document_mime_type(extension,mime_type) values ('funk','audio/make');

insert into document_mime_type(extension,mime_type) values ('g','text/plain');

insert into document_mime_type(extension,mime_type) values ('g3','image/g3fax');

insert into document_mime_type(extension,mime_type) values ('gif','image/gif');

insert into document_mime_type(extension,mime_type) values ('gl','video/gl');

insert into document_mime_type(extension,mime_type) values ('gl','video/x-gl');

insert into document_mime_type(extension,mime_type) values ('gsd','audio/x-gsm');

insert into document_mime_type(extension,mime_type) values ('gsm','audio/x-gsm');

insert into document_mime_type(extension,mime_type) values ('gsp','application/x-gsp');

insert into document_mime_type(extension,mime_type) values ('gss','application/x-gss');

insert into document_mime_type(extension,mime_type) values ('gtar','application/x-gtar');

insert into document_mime_type(extension,mime_type) values ('gz','application/x-compressed');

insert into document_mime_type(extension,mime_type) values ('gz','application/x-gzip');

insert into document_mime_type(extension,mime_type) values ('gzip','application/x-gzip');

insert into document_mime_type(extension,mime_type) values ('gzip','multipart/x-gzip');

insert into document_mime_type(extension,mime_type) values ('h','text/plain');

insert into document_mime_type(extension,mime_type) values ('h','text/x-h');

insert into document_mime_type(extension,mime_type) values ('hdf','application/x-hdf');

insert into document_mime_type(extension,mime_type) values ('help','application/x-helpfile');

insert into document_mime_type(extension,mime_type) values ('hgl','application/vnd.hp-hpgl');

insert into document_mime_type(extension,mime_type) values ('hh','text/plain');

insert into document_mime_type(extension,mime_type) values ('hh','text/x-h');

insert into document_mime_type(extension,mime_type) values ('hlb','text/x-script');

insert into document_mime_type(extension,mime_type) values ('hlp','application/hlp');

insert into document_mime_type(extension,mime_type) values ('hlp','application/x-helpfile');

insert into document_mime_type(extension,mime_type) values ('hlp','application/x-winhelp');

insert into document_mime_type(extension,mime_type) values ('hpg','application/vnd.hp-hpgl');

insert into document_mime_type(extension,mime_type) values ('hpgl','application/vnd.hp-hpgl');

insert into document_mime_type(extension,mime_type) values ('hqx','application/binhex');

insert into document_mime_type(extension,mime_type) values ('hqx','application/binhex4');

insert into document_mime_type(extension,mime_type) values ('hqx','application/mac-binhex');

insert into document_mime_type(extension,mime_type) values ('hqx','application/mac-binhex40');

insert into document_mime_type(extension,mime_type) values ('hqx','application/x-binhex40');

insert into document_mime_type(extension,mime_type) values ('hqx','application/x-mac-binhex40');

insert into document_mime_type(extension,mime_type) values ('hta','application/hta');

insert into document_mime_type(extension,mime_type) values ('htc','text/x-component');

insert into document_mime_type(extension,mime_type) values ('htm','text/html');

insert into document_mime_type(extension,mime_type) values ('html','text/html');

insert into document_mime_type(extension,mime_type) values ('htmls','text/html');

insert into document_mime_type(extension,mime_type) values ('htt','text/webviewhtml');

insert into document_mime_type(extension,mime_type) values ('htx','text/html');

insert into document_mime_type(extension,mime_type) values ('ice','x-conference/x-cooltalk');

insert into document_mime_type(extension,mime_type) values ('ico','image/x-icon');

insert into document_mime_type(extension,mime_type) values ('idc','text/plain');

insert into document_mime_type(extension,mime_type) values ('ief','image/ief');

insert into document_mime_type(extension,mime_type) values ('iefs','image/ief');

insert into document_mime_type(extension,mime_type) values ('iges','application/iges');

insert into document_mime_type(extension,mime_type) values ('iges','model/iges');

insert into document_mime_type(extension,mime_type) values ('igs','application/iges');

insert into document_mime_type(extension,mime_type) values ('igs','model/iges');

insert into document_mime_type(extension,mime_type) values ('ima','application/x-ima');

insert into document_mime_type(extension,mime_type) values ('imap','application/x-httpd-imap');

insert into document_mime_type(extension,mime_type) values ('inf','application/inf');

insert into document_mime_type(extension,mime_type) values ('ins','application/x-internett-signup');

insert into document_mime_type(extension,mime_type) values ('ip','application/x-ip2');

insert into document_mime_type(extension,mime_type) values ('isu','video/x-isvideo');

insert into document_mime_type(extension,mime_type) values ('it','audio/it');

insert into document_mime_type(extension,mime_type) values ('iv','application/x-inventor');

insert into document_mime_type(extension,mime_type) values ('ivr','i-world/i-vrml');

insert into document_mime_type(extension,mime_type) values ('ivy','application/x-livescreen');

insert into document_mime_type(extension,mime_type) values ('jam','audio/x-jam');

insert into document_mime_type(extension,mime_type) values ('jav','text/plain');

insert into document_mime_type(extension,mime_type) values ('jav','text/x-java-source');

insert into document_mime_type(extension,mime_type) values ('java','text/plain');

insert into document_mime_type(extension,mime_type) values ('java','text/x-java-source');

insert into document_mime_type(extension,mime_type) values ('jcm','application/x-java-commerce');

insert into document_mime_type(extension,mime_type) values ('jfif','image/jpeg');

insert into document_mime_type(extension,mime_type) values ('jfif','image/pjpeg');

insert into document_mime_type(extension,mime_type) values ('jfif-tbnl','image/jpeg');

insert into document_mime_type(extension,mime_type) values ('jpe','image/jpeg');

insert into document_mime_type(extension,mime_type) values ('jpe','image/pjpeg');

insert into document_mime_type(extension,mime_type) values ('jpeg','image/jpeg');

insert into document_mime_type(extension,mime_type) values ('jpeg','image/pjpeg');

insert into document_mime_type(extension,mime_type) values ('jpg','image/jpeg');

insert into document_mime_type(extension,mime_type) values ('jpg','image/pjpeg');

insert into document_mime_type(extension,mime_type) values ('jps','image/x-jps');

insert into document_mime_type(extension,mime_type) values ('js','application/x-javascript');

insert into document_mime_type(extension,mime_type) values ('jut','image/jutvision');

insert into document_mime_type(extension,mime_type) values ('kar','audio/midi');

insert into document_mime_type(extension,mime_type) values ('kar','music/x-karaoke');

insert into document_mime_type(extension,mime_type) values ('ksh','application/x-ksh');

insert into document_mime_type(extension,mime_type) values ('ksh','text/x-script.ksh');

insert into document_mime_type(extension,mime_type) values ('la','audio/nspaudio');

insert into document_mime_type(extension,mime_type) values ('la','audio/x-nspaudio');

insert into document_mime_type(extension,mime_type) values ('lam','audio/x-liveaudio');

insert into document_mime_type(extension,mime_type) values ('latex','application/x-latex');

insert into document_mime_type(extension,mime_type) values ('lha','application/lha');

insert into document_mime_type(extension,mime_type) values ('lha','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('lha','application/x-lha');

insert into document_mime_type(extension,mime_type) values ('lhx','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('list','text/plain');

insert into document_mime_type(extension,mime_type) values ('lma','audio/nspaudio');

insert into document_mime_type(extension,mime_type) values ('lma','audio/x-nspaudio');

insert into document_mime_type(extension,mime_type) values ('log','text/plain');

insert into document_mime_type(extension,mime_type) values ('lsp','application/x-lisp');

insert into document_mime_type(extension,mime_type) values ('lsp','text/x-script.lisp');

insert into document_mime_type(extension,mime_type) values ('lst','text/plain');

insert into document_mime_type(extension,mime_type) values ('lsx','text/x-la-asf');

insert into document_mime_type(extension,mime_type) values ('ltx','application/x-latex');

insert into document_mime_type(extension,mime_type) values ('lzh','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('lzh','application/x-lzh');

insert into document_mime_type(extension,mime_type) values ('lzx','application/lzx');

insert into document_mime_type(extension,mime_type) values ('lzx','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('lzx','application/x-lzx');

insert into document_mime_type(extension,mime_type) values ('m','text/plain');

insert into document_mime_type(extension,mime_type) values ('m','text/x-m');

insert into document_mime_type(extension,mime_type) values ('m1v','video/mpeg');

insert into document_mime_type(extension,mime_type) values ('m2a','audio/mpeg');

insert into document_mime_type(extension,mime_type) values ('m2v','video/mpeg');

insert into document_mime_type(extension,mime_type) values ('m3u','audio/x-mpequrl');

insert into document_mime_type(extension,mime_type) values ('man','application/x-troff-man');

insert into document_mime_type(extension,mime_type) values ('map','application/x-navimap');

insert into document_mime_type(extension,mime_type) values ('mar','text/plain');

insert into document_mime_type(extension,mime_type) values ('mbd','application/mbedlet');

insert into document_mime_type(extension,mime_type) values ('mc$','application/x-magic-cap-package-1.0');

insert into document_mime_type(extension,mime_type) values ('mcd','application/mcad');

insert into document_mime_type(extension,mime_type) values ('mcd','application/x-mathcad');

insert into document_mime_type(extension,mime_type) values ('mcf','image/vasa');

insert into document_mime_type(extension,mime_type) values ('mcf','text/mcf');

insert into document_mime_type(extension,mime_type) values ('mcp','application/netmc');

insert into document_mime_type(extension,mime_type) values ('me','application/x-troff-me');

insert into document_mime_type(extension,mime_type) values ('mht','message/rfc822');

insert into document_mime_type(extension,mime_type) values ('mhtml','message/rfc822');

insert into document_mime_type(extension,mime_type) values ('mid','application/x-midi');

insert into document_mime_type(extension,mime_type) values ('mid','audio/midi');

insert into document_mime_type(extension,mime_type) values ('mid','audio/x-mid');

insert into document_mime_type(extension,mime_type) values ('mid','audio/x-midi');

insert into document_mime_type(extension,mime_type) values ('mid','music/crescendo');

insert into document_mime_type(extension,mime_type) values ('mid','x-music/x-midi');

insert into document_mime_type(extension,mime_type) values ('midi','application/x-midi');

insert into document_mime_type(extension,mime_type) values ('midi','audio/midi');

insert into document_mime_type(extension,mime_type) values ('midi','audio/x-mid');

insert into document_mime_type(extension,mime_type) values ('midi','audio/x-midi');

insert into document_mime_type(extension,mime_type) values ('midi','music/crescendo');

insert into document_mime_type(extension,mime_type) values ('midi','x-music/x-midi');

insert into document_mime_type(extension,mime_type) values ('mif','application/x-frame');

insert into document_mime_type(extension,mime_type) values ('mif','application/x-mif');

insert into document_mime_type(extension,mime_type) values ('mime','message/rfc822');

insert into document_mime_type(extension,mime_type) values ('mime','www/mime');

insert into document_mime_type(extension,mime_type) values ('mjf','audio/x-vnd.audioexplosion.mjuicemediafile');

insert into document_mime_type(extension,mime_type) values ('mjpg','video/x-motion-jpeg');

insert into document_mime_type(extension,mime_type) values ('mm','application/base64');

insert into document_mime_type(extension,mime_type) values ('mm','application/x-meme');

insert into document_mime_type(extension,mime_type) values ('mme','application/base64');

insert into document_mime_type(extension,mime_type) values ('mod','audio/mod');

insert into document_mime_type(extension,mime_type) values ('mod','audio/x-mod');

insert into document_mime_type(extension,mime_type) values ('moov','video/quicktime');

insert into document_mime_type(extension,mime_type) values ('mov','video/quicktime');

insert into document_mime_type(extension,mime_type) values ('movie','video/x-sgi-movie');

insert into document_mime_type(extension,mime_type) values ('mp2','audio/mpeg');

insert into document_mime_type(extension,mime_type) values ('mp2','audio/x-mpeg');

insert into document_mime_type(extension,mime_type) values ('mp2','video/mpeg');

insert into document_mime_type(extension,mime_type) values ('mp2','video/x-mpeg');

insert into document_mime_type(extension,mime_type) values ('mp2','video/x-mpeq2a');

insert into document_mime_type(extension,mime_type) values ('mp3','audio/mpeg3');

insert into document_mime_type(extension,mime_type) values ('mp3','audio/x-mpeg-3');

insert into document_mime_type(extension,mime_type) values ('mp3','video/mpeg');

insert into document_mime_type(extension,mime_type) values ('mp3','video/x-mpeg');

insert into document_mime_type(extension,mime_type) values ('mpa','audio/mpeg');

insert into document_mime_type(extension,mime_type) values ('mpa','video/mpeg');

insert into document_mime_type(extension,mime_type) values ('mpc','application/x-project');

insert into document_mime_type(extension,mime_type) values ('mpe','video/mpeg');

insert into document_mime_type(extension,mime_type) values ('mpeg','video/mpeg');

insert into document_mime_type(extension,mime_type) values ('mpg','audio/mpeg');

insert into document_mime_type(extension,mime_type) values ('mpg','video/mpeg');

insert into document_mime_type(extension,mime_type) values ('mpga','audio/mpeg');

insert into document_mime_type(extension,mime_type) values ('mpp','application/vnd.ms-project');

insert into document_mime_type(extension,mime_type) values ('mpt','application/x-project');

insert into document_mime_type(extension,mime_type) values ('mpv','application/x-project');

insert into document_mime_type(extension,mime_type) values ('mpx','application/x-project');

insert into document_mime_type(extension,mime_type) values ('mrc','application/marc');

insert into document_mime_type(extension,mime_type) values ('ms','application/x-troff-ms');

insert into document_mime_type(extension,mime_type) values ('mv','video/x-sgi-movie');

insert into document_mime_type(extension,mime_type) values ('my','audio/make');

insert into document_mime_type(extension,mime_type) values ('mzz','application/x-vnd.audioexplosion.mzz');

insert into document_mime_type(extension,mime_type) values ('nap','image/naplps');

insert into document_mime_type(extension,mime_type) values ('naplps','image/naplps');

insert into document_mime_type(extension,mime_type) values ('nc','application/x-netcdf');

insert into document_mime_type(extension,mime_type) values ('ncm','application/vnd.nokia.configuration-message');

insert into document_mime_type(extension,mime_type) values ('nif','image/x-niff');

insert into document_mime_type(extension,mime_type) values ('niff','image/x-niff');

insert into document_mime_type(extension,mime_type) values ('nix','application/x-mix-transfer');

insert into document_mime_type(extension,mime_type) values ('nsc','application/x-conference');

insert into document_mime_type(extension,mime_type) values ('nvd','application/x-navidoc');

insert into document_mime_type(extension,mime_type) values ('o','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('oda','application/oda');

insert into document_mime_type(extension,mime_type) values ('omc','application/x-omc');

insert into document_mime_type(extension,mime_type) values ('omcd','application/x-omcdatamaker');

insert into document_mime_type(extension,mime_type) values ('omcr','application/x-omcregerator');

insert into document_mime_type(extension,mime_type) values ('p','text/x-pascal');

insert into document_mime_type(extension,mime_type) values ('p10','application/pkcs10');

insert into document_mime_type(extension,mime_type) values ('p10','application/x-pkcs10');

insert into document_mime_type(extension,mime_type) values ('p12','application/pkcs-12');

insert into document_mime_type(extension,mime_type) values ('p12','application/x-pkcs12');

insert into document_mime_type(extension,mime_type) values ('p7a','application/x-pkcs7-signature');

insert into document_mime_type(extension,mime_type) values ('p7c','application/pkcs7-mime');

insert into document_mime_type(extension,mime_type) values ('p7c','application/x-pkcs7-mime');

insert into document_mime_type(extension,mime_type) values ('p7m','application/pkcs7-mime');

insert into document_mime_type(extension,mime_type) values ('p7m','application/x-pkcs7-mime');

insert into document_mime_type(extension,mime_type) values ('p7r','application/x-pkcs7-certreqresp');

insert into document_mime_type(extension,mime_type) values ('p7s','application/pkcs7-signature');

insert into document_mime_type(extension,mime_type) values ('part','application/pro_eng');

insert into document_mime_type(extension,mime_type) values ('pas','text/pascal');

insert into document_mime_type(extension,mime_type) values ('pbm','image/x-portable-bitmap');

insert into document_mime_type(extension,mime_type) values ('pcl','application/vnd.hp-pcl');

insert into document_mime_type(extension,mime_type) values ('pcl','application/x-pcl');

insert into document_mime_type(extension,mime_type) values ('pct','image/x-pict');

insert into document_mime_type(extension,mime_type) values ('pcx','image/x-pcx');

insert into document_mime_type(extension,mime_type) values ('pdb','chemical/x-pdb');

insert into document_mime_type(extension,mime_type) values ('pdf','application/pdf');

insert into document_mime_type(extension,mime_type) values ('pfunk','audio/make');

insert into document_mime_type(extension,mime_type) values ('pfunk','audio/make.my.funk');

insert into document_mime_type(extension,mime_type) values ('pgm','image/x-portable-graymap');

insert into document_mime_type(extension,mime_type) values ('pgm','image/x-portable-greymap');

insert into document_mime_type(extension,mime_type) values ('pic','image/pict');

insert into document_mime_type(extension,mime_type) values ('pict','image/pict');

insert into document_mime_type(extension,mime_type) values ('pkg','application/x-newton-compatible-pkg');

insert into document_mime_type(extension,mime_type) values ('pko','application/vnd.ms-pki.pko');

insert into document_mime_type(extension,mime_type) values ('pl','text/plain');

insert into document_mime_type(extension,mime_type) values ('pl','text/x-script.perl');

insert into document_mime_type(extension,mime_type) values ('plx','application/x-pixclscript');

insert into document_mime_type(extension,mime_type) values ('pm','image/x-xpixmap');

insert into document_mime_type(extension,mime_type) values ('pm','text/x-script.perl-module');

insert into document_mime_type(extension,mime_type) values ('pm4','application/x-pagemaker');

insert into document_mime_type(extension,mime_type) values ('pm5','application/x-pagemaker');

insert into document_mime_type(extension,mime_type) values ('png','image/png');

insert into document_mime_type(extension,mime_type) values ('pnm','application/x-portable-anymap');

insert into document_mime_type(extension,mime_type) values ('pnm','image/x-portable-anymap');

insert into document_mime_type(extension,mime_type) values ('pot','application/mspowerpoint');

insert into document_mime_type(extension,mime_type) values ('pot','application/vnd.ms-powerpoint');

insert into document_mime_type(extension,mime_type) values ('pov','model/x-pov');

insert into document_mime_type(extension,mime_type) values ('ppa','application/vnd.ms-powerpoint');

insert into document_mime_type(extension,mime_type) values ('ppm','image/x-portable-pixmap');

insert into document_mime_type(extension,mime_type) values ('pps','application/mspowerpoint');

insert into document_mime_type(extension,mime_type) values ('pps','application/vnd.ms-powerpoint');

insert into document_mime_type(extension,mime_type) values ('ppt','application/mspowerpoint');

insert into document_mime_type(extension,mime_type) values ('ppt','application/powerpoint');

insert into document_mime_type(extension,mime_type) values ('ppt','application/vnd.ms-powerpoint');

insert into document_mime_type(extension,mime_type) values ('ppt','application/x-mspowerpoint');

insert into document_mime_type(extension,mime_type) values ('ppz','application/mspowerpoint');

insert into document_mime_type(extension,mime_type) values ('pre','application/x-freelance');

insert into document_mime_type(extension,mime_type) values ('prt','application/pro_eng');

insert into document_mime_type(extension,mime_type) values ('ps','application/postscript');

insert into document_mime_type(extension,mime_type) values ('psd','application/octet-stream');

insert into document_mime_type(extension,mime_type) values ('pvu','paleovu/x-pv');

insert into document_mime_type(extension,mime_type) values ('pwz','application/vnd.ms-powerpoint');

insert into document_mime_type(extension,mime_type) values ('py','text/x-script.phyton');

insert into document_mime_type(extension,mime_type) values ('pyc','applicaiton/x-bytecode.python');

insert into document_mime_type(extension,mime_type) values ('qcp','audio/vnd.qcelp');

insert into document_mime_type(extension,mime_type) values ('qd3','x-world/x-3dmf');

insert into document_mime_type(extension,mime_type) values ('qd3d','x-world/x-3dmf');

insert into document_mime_type(extension,mime_type) values ('qif','image/x-quicktime');

insert into document_mime_type(extension,mime_type) values ('qt','video/quicktime');

insert into document_mime_type(extension,mime_type) values ('qtc','video/x-qtc');

insert into document_mime_type(extension,mime_type) values ('qti','image/x-quicktime');

insert into document_mime_type(extension,mime_type) values ('qtif','image/x-quicktime');

insert into document_mime_type(extension,mime_type) values ('ra','audio/x-pn-realaudio');

insert into document_mime_type(extension,mime_type) values ('ra','audio/x-pn-realaudio-plugin');

insert into document_mime_type(extension,mime_type) values ('ra','audio/x-realaudio');

insert into document_mime_type(extension,mime_type) values ('ram','audio/x-pn-realaudio');

insert into document_mime_type(extension,mime_type) values ('ras','application/x-cmu-raster');

insert into document_mime_type(extension,mime_type) values ('ras','image/cmu-raster');

insert into document_mime_type(extension,mime_type) values ('ras','image/x-cmu-raster');

insert into document_mime_type(extension,mime_type) values ('rast','image/cmu-raster');

insert into document_mime_type(extension,mime_type) values ('rexx','text/x-script.rexx');

insert into document_mime_type(extension,mime_type) values ('rf','image/vnd.rn-realflash');