Manual:file table

This table stores information about uploaded images and other files. It is part of the replacement of the old image and filearchive tables.

Primary key.

Name of the file.

Latest file revision of the file. Foreign key to the new filerevision table.

Type of the file. Foreign key to the new filetypes table.

Whether the file is deleted.

DESCRIBEfile;

+--------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------------+------+-----+---------+----------------+
| file_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| file_name | varbinary(255) | NO | UNI | NULL | |
| file_latest | bigint(20) unsigned | NO | MUL | NULL | |
| file_type | smallint(5) unsigned | NO | | NULL | |
| file_deleted | smallint(5) unsigned | NO | | NULL | |
+--------------+----------------------+------+-----+---------+----------------+

SHOWINDEXINfile;

+-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| file | 0 | PRIMARY | 1 | file_id | A | 0 | NULL | NULL | | BTREE | | |
| file | 0 | file_name | 1 | file_name | A | 0 | NULL | NULL | | BTREE | | |
| file | 1 | file_latest | 1 | file_latest | A | 0 | NULL | NULL | | BTREE | | |
+-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+