--Description: table to hold a sub-set of the internet media types.

create table media (
 tid tinyint unsigned not null auto_increment,
 ext char(8) not null,
 major enum('application','audio','image','message','multipart','text','video') not null,
 minor char(32) not null,
 primary key (tid),
 unique key uk (tid,ext)
);

insert into media values (null, 'xhtml', 'application', 'xhtml+xml');
insert into media values (null, 'xslt', 'application', 'xslt+xml');
insert into media values (null, 'xml', 'application', 'xml');
insert into media values (null, 'xsl', 'application', 'xml');
insert into media values (null, 'dtd', 'application', 'xml-dtd');
insert into media values (null, 'mml', 'application', 'mathml+xml');
insert into media values (null, 'php', 'application', 'x-httpd-php');
insert into media values (null, 'phps', 'application', 'x-httpd-php-source');
insert into media values (null, 'swf', 'application', 'x-shockwave-flash');
insert into media values (null, 'pdf', 'application', 'pdf');
insert into media values (null, 'png', 'image', 'png');
insert into media values (null, 'jpg', 'image', 'jpeg');
insert into media values (null, 'jpeg', 'image', 'jpeg');
insert into media values (null, 'ico', 'image', 'x-icon');
insert into media values (null, 'gif', 'image', 'gif');
insert into media values (null, 'html', 'text', 'html');
insert into media values (null, 'txt', 'text', 'plain');
insert into media values (null, 'css', 'text', 'css');
insert into media values (null, 'js', 'text', 'javascript');
insert into media values (null, 'sgml', 'text', 'sgml');
insert into media values (null, 'mp3', 'audio', 'mpeg');
insert into media values (null, 'mpg', 'video', 'mpeg');
insert into media values (null, 'mpeg', 'video', 'mpeg');
insert into media values (null, 'mov', 'video', 'quicktime');
insert into media values (null, 'qt', 'video', 'quicktime');