This table stores information about file types of uploaded images and other files.It is part of the replacement of the oldimage andfilearchive tables.

Primary key.

Media type as defined by theMEDIATYPE_xxx constants.

Major part of a MIME media type as defined by IANA, seehttps://www.iana.org/assignments/media-types/.Forchemical types, which are defined by the ACS, seehttp://dx.doi.org/10.1021/ci9803233.

Minor part of a MIME media type as defined by IANA the minor parts are not required to adhere to any standard but should be consistent throughout the database seehttps://www.iana.org/assignments/media-types/.

DESCRIBEfiletypes;

+---------------+----------------------+------+-----+---------+----------------+| Field         | Type                 | Null | Key | Default | Extra          |+---------------+----------------------+------+-----+---------+----------------+| ft_id         | smallint(5) unsigned | NO   | PRI | NULL    | auto_increment || ft_media_type | varbinary(255)       | NO   | MUL | NULL    |                || ft_major_mime | varbinary(255)       | NO   |     | NULL    |                || ft_minor_mime | varbinary(255)       | NO   |     | NULL    |                |+---------------+----------------------+------+-----+---------+----------------+

SHOWINDEXINfiletypes;

+-----------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| Table     | Non_unique | Key_name      | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |+-----------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| filetypes |          0 | PRIMARY       |            1 | ft_id         | A         |           0 |     NULL | NULL   |      | BTREE      |         |               || filetypes |          0 | ft_media_mime |            1 | ft_media_type | A         |           0 |     NULL | NULL   |      | BTREE      |         |               || filetypes |          0 | ft_media_mime |            2 | ft_major_mime | A         |           0 |     NULL | NULL   |      | BTREE      |         |               || filetypes |          0 | ft_media_mime |            3 | ft_minor_mime | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |+-----------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+