file table

Fields

Schema summary

 DESCRIBE file;	

6.1

+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| file_id          | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| page_id          | int(10) unsigned    | NO   | MUL | 0       |                |
| user_id          | int(10) unsigned    | NO   | MUL | 0       |                |
| file_name        | varchar(255)        | NO   | MUL |         |                |
| file_lang        | varchar(5)          | NO   |     |         |                |
| file_description | varchar(255)        | NO   |     |         |                |
| caption          | text                | YES  |     | NULL    |                |
| author           | varchar(255)        | NO   |     |         |                |
| source           | varchar(255)        | NO   |     |         |                |
| source_url       | varchar(255)        | NO   |     |         |                |
| license_id       | int(10) unsigned    | NO   |     | 0       |                |
| created          | datetime            | YES  |     | NULL    |                |
| modified         | datetime            | YES  |     | NULL    |                |
| file_size        | int(10) unsigned    | NO   |     | 0       |                |
| picture_w        | int(10) unsigned    | NO   |     | 0       |                |
| picture_h        | int(10) unsigned    | NO   |     | 0       |                |
| file_ext         | varchar(10)         | NO   |     |         |                |
| mime_type        | varchar(255)        | NO   |     |         |                |
| file_hash        | char(40)            | NO   | MUL |         |                |
| deleted          | tinyint(1) unsigned | YES  | MUL | 0       |                |
+------------------+---------------------+------+-----+---------+----------------+	

6.0

+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| file_id          | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| page_id          | int(10) unsigned    | NO   | MUL | 0       |                |
| user_id          | int(10) unsigned    | NO   | MUL | 0       |                |
| file_name        | varchar(191)        | NO   |     |         |                |
| file_lang        | varchar(5)          | NO   |     | NULL    |                |
| file_description | varchar(250)        | NO   |     | NULL    |                |
| caption          | text                | YES  |     | NULL    |                |
| author           | varchar(250)        | NO   |     | NULL    |                |
| source           | varchar(250)        | NO   |     | NULL    |                |
| source_url       | varchar(255)        | NO   |     | NULL    |                |
| license_id       | int(10) unsigned    | NO   |     | 0       |                |
| uploaded_dt      | datetime            | YES  |     | NULL    |                |
| modified_dt      | datetime            | YES  |     | NULL    |                |
| file_size        | int(10) unsigned    | NO   |     | 0       |                |
| picture_w        | int(10) unsigned    | NO   |     | 0       |                |
| picture_h        | int(10) unsigned    | NO   |     | 0       |                |
| file_ext         | varchar(10)         | NO   |     | NULL    |                |
| mime_type        | varchar(255)        | NO   |     | NULL    |                |
| deleted          | tinyint(1) unsigned | YES  | MUL | 0       |                |
+------------------+---------------------+------+-----+---------+----------------+	

Indices

 SHOW INDEX IN file;	

+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table      | Non_unique | Key_name      | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_file |          0 | PRIMARY       |            1 | file_id     | A         |         110 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_file |          0 | idx_page_id   |            1 | page_id     | A         |          55 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_file |          0 | idx_page_id   |            2 | file_name   | A         |         110 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_file |          1 | idx_page_id_2 |            1 | page_id     | A         |          55 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_file |          1 | idx_page_id_2 |            2 | created     | A         |         110 |     NULL | NULL   | YES  | BTREE      |         |               |
| wacko_file |          1 | idx_deleted   |            1 | deleted     | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
| wacko_file |          1 | idx_user_id   |            1 | user_id     | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_file |          1 | idx_file_name |            1 | file_name   | A         |         110 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_file |          1 | idx_file_hash |            1 | file_hash   | A         |         110 |     NULL | NULL   |      | BTREE      |         |               |
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+